INSERT IGNORE INTO `Config` (`section`, `keyName`, `keyValue`, `keyType`) VALUES
('exim', 'enableMailFilters', '1', 'Boolean'),
('exim', 'smtp_load_queue', '10', 'String'),
('exim', 'virus_enable', '1', 'Boolean'),
('exim', 'smtp_sendlimit_enable', '1', 'Boolean'),
('exim', 'smtp_sendlimit', '50', 'String'),
('exim', 'dkim_enable', '0', 'Boolean'),
('exim', 'dkim_enable_outbound', '0', 'Boolean'),
('exim', 'tlssmtp', '1', 'Boolean'),
('exim', 'tlssmtp_remote', '1', 'Boolean'),
('exim', 'smtp_throttle', '1', 'Boolean'),
('exim', 'smtp_auth', '1', 'Boolean'),
('exim', 'filter_max_bodysize', '50', 'String'),
('exim', 'virus_msg', 'Virus $malware_name detected.', 'String'),
('exim', 'split_spool_directory', '1', 'String'),
('exim', 'smtp_load_reserve', '20', 'String'),
('exim', 'queue_run_in_order', '1', 'String'),
('exim', 'smtp_enforce_sync', '1', 'String'),
('exim', 'smtp_load_queue_delivery', '8', 'String'),
('exim', 'smtp_max_rcpt', '100', 'String'),
('exim', 'queue_run_max', '20', 'String'),
('exim', 'remote_max_parallel', '20', 'String'),
('exim', 'smtp_max_connections_perip', '5', 'String'),
('exim', 'smtp_verify_senders', '1', 'String'),
('exim', 'smtp_max_connections', '75', 'String'),
('exim', 'smtp_popimaprelay_timeout', '60', 'String'),
('exim', 'crypt', '0', 'Boolean'),
('exim', 'mail_group_support', '1', 'Boolean'),
('exim', 'smtp_popimaprelay', '1', 'Boolean'),
('exim', 'filter_sa_enable', '1', 'Boolean'),
('exim', 'max_msg_size', '18', 'String'),
('exim', 'filter_required_hits', '5', 'String'),
('exim', 'filter_required_hits_reject', '10', 'String'),
('exim', 'filter_subject_tag', '{SPAM}', 'String'),
('exim', 'filter_spam_treatment', 'mark', 'String'),
('exim', 'filter_trusted_networks', '192.168/16, 127/8', 'String'),
('exim', 'filter_skip_trusted', '1', 'Boolean'),
('exim', 'filter_attach_check', '1', 'Boolean'),
('exim', 'filter_blocked_attachments', '.exe,.pif,.bat,.scr,.lnk,.com', 'String'),
('exim', 'filter_uridns_support', '1', 'Boolean'),
('exim', 'filter_uridnsbl_servers', 'multi.surbl.org', 'String'),
('exim', 'filter_spf_support', '1', 'Boolean'),
('exim', 'filter_awl_support', '1', 'Boolean'),
('exim', 'filter_bayes_auto_learn_threshold_nonspam', '1.0', 'String'),
('exim', 'filter_bayes_auto_learn_threshold_spam', '10.0', 'String'),
('exim', 'filter_bayes_min_ham_num', '200', 'String'),
('exim', 'filter_use_bayes', '1', 'Boolean'),
('exim', 'filter_rbl_support', '1', 'Boolean'),
('exim', 'filter_rbl_servers', 'zen.spamhaus.org', 'String'),
('exim', 'filter_awl_purge_threshold', '5000', 'Integer'),
('exim', 'smtp_smarthost_domain', '', 'String'),
('exim', 'virus_autoupdate', '1', 'String'),
('exim', 'spam_autoupdate', '1', 'String'),
('admin', 'password', 'md5', 'String'),
('dovecot', 'pop3imap_enable', '1', 'Boolean'),
('dovecot', 'imapssl_enable', '0', 'Boolean'),
('dovecot', 'default_domain', '', 'String'),
('dovecot', 'dovecot_max', '512', 'String'),
('dovecot', 'dovecot_maxperip', '10', 'String'),
('dovecot', 'imapssl_cert', '/usr/local/atmail/mailserver/ssl/certs/dovecot.pem', 'String'),
('dovecot', 'imapssl_key', '/usr/local/atmail/mailserver/ssl/private/dovecot.key', 'String'),
('dovecot', 'authType', 'sql', 'String'),
('reg', 'downloadId', '', 'String'),
('reg', 'svnPass', '', 'String'),
('reg', 'email', '', 'String'),
('reg', 'serialKey', '', 'String'),
('global', 'webmail_url', '', 'String'),
('global', 'caldav_url', '', 'String'),
('global', 'mailserver_hostname', '', 'String'),
('global', 'footer_msg', '<hr>Email sent using Atmail - Email, Groupware and Calendaring done right.', 'String'),
('global', 'welcome_msg', '/usr/local/atmail/mailserver/etc/welcome-message.html', 'String'),
('global', 'brandname', 'Atmail', 'String'),
('global', 'company_url', 'http://atmail.com/', 'String'),
('global', 'mail_type', 'imapssl', 'String'),
('global', 'serverDir', '/usr/local/atmail/', 'String'),
('global', 'smtphost', '127.0.0.1', 'String'),
('global', 'smtpauth_password', '', 'String'),
('global', 'smtpauth_username', '', 'String'),
('global', 'smtp_auth', '0', 'String'),
('global', 'session_timeout', '120', 'String'),
('global', 'remoteDomainsOverwrite', '1', 'Boolean'),
('global', 'remoteDomains', '', 'String'),
('global', 'remoteServersOverwrite', '1', 'Boolean'),
('global', 'remoteServers', '', 'String'),
('global', 'admin_email', '', 'String'),
('global', 'adminlink', '1', 'Boolean'),
('global', 'demo', '0', 'Boolean'),
('global', 'localDomains', '', 'Array'),
('global', 'usersFolderBaseName', '/usr/local/atmail/users/', 'String'),
('global', 'cacheEnabled', '65279', 'Integer'),
('global', 'themeEnabled', '1', 'Boolean'),
('global', 'tmpFolderBaseName', 'tmp/', 'String'),
('global', 'allowPlugins', '1', 'Boolean'),
('global', 'groupwareZone', 'System', 'String'),
('global', 'sharedAbook', '1', 'String'),
('global', 'WebSyncEnabled', '1', 'String'),
('global', 'WebSyncShared', '1', 'String'),
('global', 'WebSyncGlobal', '1', 'String'),
('global', 'sortMaxLimit', '30000', 'String'),
('global', 'threadingMaxLimit', '30000', 'String'),
('defaultUserSettings', 'CalDavView', 'Day', 'String'),
('defaultUserSettings', 'CalDavUrl', 'http://localhost:8008/calendars/users/', 'String'),
('defaultUserSettings', 'CalDavType', 'at', 'String'),
('defaultUserSettings', 'Language', 'en', 'String'),
('defaultUserSettings', 'UserQuota', '1024', 'String'),
('defaultUserSettings', 'TimeZone', 'America/Los_Angeles', 'String'),
('defaultUserSettings', 'MsgNum', '25', 'String'),
('defaultUserSettings', 'DefaultView', '3p', 'String'),
('defaultUserSettings', 'DateFormat', '%e/%m/%y', 'String'),
('defaultUserSettings', 'TimeFormat', '%l:%M %p', 'String'),
('defaultUserSettings', 'DisplayImages', '1', 'String'),
('defaultUserSettings', 'ViewThreads', '1', 'String'),
('defaultUserSettings', 'ViewCardDav', '0', 'String'),
('defaultUserSettings', 'CardDavUrl', 'http://localhost:8800/addressbook/users/', 'String'),
('defaultUserSettings', 'cssStyleTheme', 'fresh', 'String'),
('defaultUserSettings', 'ThreadLimit', 6, 'Integer'),
('defaultUserSettings', 'DateDisplay', 1, 'Integer'),
('defaultUserSettings', 'DisplayEmailImages', 1, 'Integer'),
('defaultUserSettings', 'SaveDrafts', 1, 'Integer'),
('defaultUserSettings', 'AutoReload', 1, 'Integer'),
('defaultUserSettings', 'DeleteTrashOnLogout', 0, 'Integer'),
('defaultUserSettings', 'copyThreadReplyToCurrentFolder', 0, 'Integer'),
('defaultUserSettings', 'confirmOnSend', 0, 'Integer'),
('defaultUserSettings', 'enableMessagePreview', 1, 'Integer'),
('global', 'ldap_host', '127.0.0.1', 'String'),
('global', 'ldap_enable', '0', 'Boolean'),
('global', 'ldap_binddn', 'dn=domain.com', 'String'),
('global', 'ldap_bindpass', 'password', 'String'),
('global', 'ldap_basedn', 'ou=users,dn=domain.com', 'String'),
('global', 'ldap_passwdfield', 'userPassword', 'String'),
('global', 'ldap_passfilter', 'inetOrgPerson', 'String'),
('global', 'ldap_bindauth', '1', 'Boolean'),
('global', 'ldap_bindauthdn', 'domain.com', 'String'),
('global', 'cssStyle', 'Original', 'String'),
('global', 'userPasswordEncryptionType', 'PLAIN', 'String'),
('global', 'externalUserPasswordEncryptionType', 'PLAIN', 'String'),
('global', 'autocompleteFetchThreshold', 50, 'Integer'),
('global', 'autocompleteCacheSize', 250, 'Integer'),
('global', 'autocompleteFetchSize', 25, 'Integer'),
('global', 'autocompleteMinFetchLength', 2, 'Integer'),
('global', 'ActiveSyncCacheLifespan', 14, 'Integer'),
('global', 'ActiveSyncTimeout', '30', 'Integer'),
('global', 'ActiveSyncTarpit', '0', 'Integer'),
('global', 'ActiveSyncTarpitMultiplier', '1', 'Integer'),
('global', 'log_purge_days', '180', 'Integer'),
('global', 'iosProfiles', '0', 'Integer'),
('global', 'jsonpAPI', '0', 'Integer'),
('global', 'cacheType', 'fs', 'String'),
('global', 'enableConfirmOnSend', '0', 'Integer'),
('global', 'enableSpellCheck', '0', 'Integer'),
('global', 'defaultImapSort', '', 'String'),
('global', 'mobileCssStyle', 'Original', 'String'),
('global', 'mobileui', '1', 'Integer'),
('global', 'exclusive_sessions', '1', 'Integer'),
('defaultUserSettings', 'enableExtraAddressFields', '0', 'Integer'),
('global', 'resolveLogIPsToGeoLocationViaAtmailGeoLocationServer', '1', 'Boolean'),
('password', 'disallow_nonalphanumeric_last', '0', 'Boolean'),
('password', 'disallow_nonalphanumeric_first', '0', 'Boolean'),
('password', 'disallow_nonalphanumeric_chars', '0', 'Boolean'),
('password', 'max_numeric_chars', '64', 'Integer'),
('password', 'min_numeric_chars', '0', 'Integer'),
('password', 'disallow_numeric_last', '0', 'Boolean'),
('password', 'disallow_numeric_first', '0', 'Boolean'),
('password', 'disallow_numeric_chars', '0', 'Boolean'),
('password', 'max_uppercase_chars', '64', 'Integer'),
('password', 'min_uppercase_chars', '0', 'Integer'),
('password', 'max_lowercase_chars', '64', 'Integer'),
('password', 'min_lowercase_chars', '0', 'Integer'),
('password', 'max_length', '64', 'Integer'),
('password', 'min_length', '4', 'Integer'),
('password', 'min_nonalphanumeric_chars', '0', 'Integer'),
('password', 'max_nonalphanumeric_chars', '64', 'Integer'),
('password', 'three_type_chars', '0', 'Boolean'),
('password', 'use_password_policy', '0', 'Boolean');

INSERT INTO bayes_global_vars VALUES ('VERSION','3');
