| | |
| | | `zone` int(11) unsigned NOT NULL, |
| | | `name` varchar(64) NOT NULL, |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL, |
| | | `data` varchar(128) NOT NULL, |
| | | `data` varchar(255) NOT NULL, |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | | `ttl` int(11) unsigned NOT NULL default '86400', |
| | | `active` enum('N','Y') NOT NULL default 'Y', |
| | | `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
| | | `serial` int(10) unsigned default NULL, |
| | | PRIMARY KEY (`id`), |
| | | UNIQUE KEY `rr` (`zone`,`name`,`type`,`data`) |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | ) ENGINE=MyISAM AUTO_INCREMENT=1; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | |
| | | `quota` int(11) NOT NULL default '0', |
| | | `homedir` varchar(255) NOT NULL, |
| | | `autoresponder` enum('n','y') NOT NULL default 'n', |
| | | `autoresponder_text` tinytext NULL, |
| | | `custom_mailfilter` text, |
| | | `autoresponder_text` mediumtext NULL, |
| | | `custom_mailfilter` mediumtext, |
| | | `postfix` enum('n','y') NOT NULL, |
| | | `access` enum('n','y') NOT NULL, |
| | | `disableimap` enum('0','1') NOT NULL default '0', |
| | |
| | | `suexec` enum('n','y') NOT NULL default 'y', |
| | | `errordocs` tinyint(1) NOT NULL default '1', |
| | | `is_subdomainwww` tinyint(1) NOT NULL default '1', |
| | | `subdomain` enum('none','www','*') NOT NULL default 'www', |
| | | `subdomain` enum('none','www','*') NOT NULL default 'none', |
| | | `php` varchar(32) NOT NULL default 'y', |
| | | `redirect_type` varchar(255) default NULL, |
| | | `redirect_path` varchar(255) default NULL, |
| | |
| | | `ssl_cert` mediumtext NULL, |
| | | `ssl_bundle` mediumtext NULL, |
| | | `ssl_action` varchar(16) NULL, |
| | | `stats_password` varchar(255) default NULL, |
| | | `apache_directives` text, |
| | | `active` enum('n','y') NOT NULL default 'y', |
| | | PRIMARY KEY (`domain_id`) |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.0.9'); |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1'); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |