| | |
| | | `sys_perm_other` varchar(5) NOT NULL DEFAULT '', |
| | | `server_id` int(11) NOT NULL default '1', |
| | | `zone` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `name` varchar(64) NOT NULL DEFAULT '', |
| | | `name` varchar(255) NOT NULL DEFAULT '', |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL, |
| | | `data` varchar(255) NOT NULL DEFAULT '', |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | |
| | | `dl_ratio` int(11) NOT NULL default '-1', |
| | | `ul_bandwidth` int(11) NOT NULL default '-1', |
| | | `dl_bandwidth` int(11) NOT NULL default '-1', |
| | | `expires` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | PRIMARY KEY (`ftp_user_id`), |
| | | KEY `active` (`active`), |
| | | KEY `server_id` (`server_id`), |
| | |
| | | `login` varchar(255) NOT NULL default '', |
| | | `password` varchar(255) NOT NULL default '', |
| | | `name` varchar(255) NOT NULL default '', |
| | | `uid` int(11) unsigned NOT NULL default '5000', |
| | | `gid` int(11) unsigned NOT NULL default '5000', |
| | | `uid` int(11) NOT NULL default '5000', |
| | | `gid` int(11) NOT NULL default '5000', |
| | | `maildir` varchar(255) NOT NULL default '', |
| | | `quota` bigint(20) NOT NULL default '-1', |
| | | `cc` varchar(255) NOT NULL default '', |
| | |
| | | `added_date` date NOT NULL DEFAULT '0000-00-00', |
| | | `added_by` varchar(255) DEFAULT NULL, |
| | | PRIMARY KEY (`domain_id`), |
| | | UNIQUE KEY `serverdomain` ( `server_id` , `domain` ) |
| | | UNIQUE KEY `serverdomain` ( `server_id` , `ip_address`, `domain` ) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('db','db_version','3.0.5.4'); |
| | | INSERT INTO sys_config VALUES ('db','db_version','3.0.5.4p6'); |
| | | INSERT INTO sys_config VALUES ('interface','session_timeout','0'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |