| | |
| | | `parent_domain_id` int(11) unsigned NOT NULL default '0', |
| | | `username` varchar(64) default NULL, |
| | | `password` varchar(64) default NULL, |
| | | `quota_size` int(11) NOT NULL default '-1', |
| | | `quota_size` bigint(20) NOT NULL default '-1', |
| | | `active` enum('n','y') NOT NULL default 'y', |
| | | `uid` varchar(64) default NULL, |
| | | `gid` varchar(64) default NULL, |
| | | `dir` varchar(255) default NULL, |
| | | `quota_files` int(11) NOT NULL default '-1', |
| | | `quota_files` bigint(20) NOT NULL default '-1', |
| | | `ul_ratio` int(11) NOT NULL default '-1', |
| | | `dl_ratio` int(11) NOT NULL default '-1', |
| | | `ul_bandwidth` int(11) NOT NULL default '-1', |
| | |
| | | `type` enum('alias','aliasdomain','forward','catchall') NOT NULL default 'alias', |
| | | `active` enum('n','y') NOT NULL, |
| | | PRIMARY KEY (`forwarding_id`), |
| | | KEY `server_id` (`server_id`,`source`) |
| | | KEY `server_id` (`server_id`,`source`), |
| | | KEY `type` (`type`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | `uid` int(11) unsigned NOT NULL default '5000', |
| | | `gid` int(11) unsigned NOT NULL default '5000', |
| | | `maildir` varchar(255) NOT NULL default '', |
| | | `quota` int(11) NOT NULL default '-1', |
| | | `quota` bigint(20) NOT NULL default '-1', |
| | | `homedir` varchar(255) NOT NULL, |
| | | `autoresponder` enum('n','y') NOT NULL default 'n', |
| | | `autoresponder_start_date` datetime NOT NULL default '0000-00-00 00:00:00', |
| | | `autoresponder_end_date` datetime NOT NULL default '0000-00-00 00:00:00', |
| | | `autoresponder_text` mediumtext NULL, |
| | | `move_junk` enum('n','y') NOT NULL default 'n', |
| | | `custom_mailfilter` mediumtext, |
| | | `postfix` enum('n','y') NOT NULL, |
| | | `access` enum('n','y') NOT NULL, |
| | | `disableimap` enum('0','1') NOT NULL default '0', |
| | | `disablepop3` enum('0','1') NOT NULL default '0', |
| | | `disableimap` enum('n','y') NOT NULL default 'n', |
| | | `disablepop3` enum('n','y') NOT NULL default 'n', |
| | | `disabledeliver` enum('n','y') NOT NULL default 'n', |
| | | `disablesmtp` enum('n','y') NOT NULL default 'n', |
| | | PRIMARY KEY (`mailuser_id`), |
| | | KEY `server_id` (`server_id`,`email`), |
| | | KEY `email_access` (`email`,`access`) |
| | |
| | | `parent_domain_id` int(11) unsigned NOT NULL default '0', |
| | | `username` varchar(64) default NULL, |
| | | `password` varchar(64) default NULL, |
| | | `quota_size` int(11) NOT NULL default '-1', |
| | | `quota_size` bigint(20) NOT NULL default '-1', |
| | | `active` enum('n','y') NOT NULL default 'y', |
| | | `puser` varchar(255) default NULL, |
| | | `pgroup` varchar(255) default NULL, |
| | |
| | | `document_root` varchar(255) default NULL, |
| | | `system_user` varchar(255) default NULL, |
| | | `system_group` varchar(255) default NULL, |
| | | `hd_quota` int(11) NOT NULL default '0', |
| | | `traffic_quota` int(11) NOT NULL default '0', |
| | | `hd_quota` bigint(20) NOT NULL default '0', |
| | | `traffic_quota` bigint(20) NOT NULL default '0', |
| | | `cgi` enum('n','y') NOT NULL default 'y', |
| | | `ssi` enum('n','y') NOT NULL default 'y', |
| | | `suexec` enum('n','y') NOT NULL default 'y', |
| | |
| | | `ssl_bundle` mediumtext NULL, |
| | | `ssl_action` varchar(16) NULL, |
| | | `stats_password` varchar(255) default NULL, |
| | | `allow_override` varchar(32) NOT NULL default 'All', |
| | | `allow_override` varchar(255) NOT NULL default 'All', |
| | | `apache_directives` text, |
| | | `php_open_basedir` text, |
| | | `active` enum('n','y') NOT NULL default 'y', |
| | | PRIMARY KEY (`domain_id`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1.5'); |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1.6'); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |