| | |
| | | `server_id` int(11) NOT NULL default '1', |
| | | `zone` int(11) unsigned NOT NULL, |
| | | `name` varchar(64) NOT NULL, |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SPF','SRV','TXT') default NULL, |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL, |
| | | `data` varchar(255) NOT NULL, |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | | `ttl` int(11) unsigned NOT NULL default '86400', |
| | |
| | | `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_subject` varchar(255) NOT NULL default 'Out of office reply', |
| | | `autoresponder_text` mediumtext NULL, |
| | | `move_junk` enum('n','y') NOT NULL default 'n', |
| | | `custom_mailfilter` mediumtext, |
| | |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.4'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |
| | | SET FOREIGN_KEY_CHECKS = 1; |