| | |
| | | `bank_account_swift` varchar(255) DEFAULT NULL, |
| | | `paypal_email` varchar(255) DEFAULT NULL, |
| | | `default_mailserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `mail_servers` blob NOT NULL DEFAULT '', |
| | | `mail_servers` blob NOT NULL, |
| | | `limit_maildomain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_mailbox` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_mailalias` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | `limit_spamfilter_user` int(11) NOT NULL DEFAULT '0', |
| | | `limit_spamfilter_policy` int(11) NOT NULL DEFAULT '0', |
| | | `default_webserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `web_servers` blob NOT NULL DEFAULT '', |
| | | `web_servers` blob NOT NULL, |
| | | `limit_web_ip` text, |
| | | `limit_web_domain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_web_quota` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | `limit_webdav_user` int(11) NOT NULL DEFAULT '0', |
| | | `limit_aps` int(11) NOT NULL DEFAULT '-1', |
| | | `default_dnsserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `db_servers` blob NOT NULL DEFAULT '', |
| | | `db_servers` blob NOT NULL, |
| | | `limit_dns_zone` int(11) NOT NULL DEFAULT '-1', |
| | | `default_slave_dnsserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `limit_dns_slave_zone` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_dns_record` int(11) NOT NULL DEFAULT '-1', |
| | | `default_dbserver` int(11) NOT NULL DEFAULT '1', |
| | | `dns_servers` blob NOT NULL DEFAULT '', |
| | | `dns_servers` blob NOT NULL, |
| | | `limit_database` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_database_quota` int(11) NOT NULL default '-1', |
| | | `limit_cron` int(11) NOT NULL DEFAULT '0', |
| | |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `domain` varchar(255) NOT NULL default '', |
| | | `dkim` ENUM( 'n', 'y' ) NOT NULL default 'n', |
| | | `dkim_private` mediumtext NOT NULL, |
| | | `dkim_public` mediumtext NOT NULL, |
| | | `dkim_private` mediumtext NULL, |
| | | `dkim_public` mediumtext NULL, |
| | | `active` enum('n','y') NOT NULL, |
| | | PRIMARY KEY (`domain_id`), |
| | | KEY `server_id` (`server_id`,`domain`), |
| | |
| | | `disablelmtp` enum('n','y') NOT NULL default 'n', |
| | | `disabledoveadm` enum('n','y') NOT NULL default 'n', |
| | | `last_quota_notification` date NULL default NULL, |
| | | `backup_interval` VARCHAR( 255 ) NOT NULL, |
| | | `backup_interval` VARCHAR( 255 ) NOT NULL default 'none', |
| | | `backup_copies` INT NOT NULL DEFAULT '1', |
| | | PRIMARY KEY (`mailuser_id`), |
| | | KEY `server_id` (`server_id`,`email`), |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('db','db_version','3.0.5.4b1'); |
| | | INSERT INTO sys_config VALUES ('db','db_version','3.0.5.4rc1'); |
| | | INSERT INTO sys_config VALUES ('interface','session_timeout','0'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |