| | |
| | | `company_name` varchar(64) DEFAULT NULL, |
| | | `company_id` varchar(255) DEFAULT NULL, |
| | | `gender` enum('','m','f') NOT NULL DEFAULT '', |
| | | `contact_firstname` varchar( 64 ) NOT NULL DEFAULT '', |
| | | `contact_name` varchar(64) DEFAULT NULL, |
| | | `customer_no` varchar(64) DEFAULT NULL, |
| | | `vat_id` varchar(64) DEFAULT NULL, |
| | |
| | | `name` varchar(255) DEFAULT NULL, |
| | | `type` varchar(255) DEFAULT NULL, |
| | | `snippet` mediumtext, |
| | | `customer_viewable` ENUM('n','y') NOT NULL DEFAULT 'n', |
| | | `active` enum('n','y') NOT NULL DEFAULT 'y', |
| | | PRIMARY KEY (`directive_snippets_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | |
| | | `zone` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `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 '', |
| | | `data` TEXT NOT NULL DEFAULT '', |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | | `ttl` int(11) unsigned NOT NULL default '86400', |
| | | `active` enum('N','Y') NOT NULL default 'Y', |
| | |
| | | `backup_mode` varchar(64) NOT NULL DEFAULT '', |
| | | `tstamp` int(10) unsigned NOT NULL DEFAULT '0', |
| | | `filename` varchar(255) NOT NULL DEFAULT '', |
| | | `filesize` VARCHAR(10) NOT NULL DEFAULT '', |
| | | `filesize` VARCHAR(20) NOT NULL DEFAULT '', |
| | | PRIMARY KEY (`backup_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | `maildir` varchar(255) NOT NULL default '', |
| | | `quota` bigint(20) NOT NULL default '-1', |
| | | `cc` varchar(255) NOT NULL default '', |
| | | `sender_cc` varchar(255) NOT NULL default '', |
| | | `homedir` varchar(255) NOT NULL default '', |
| | | `autoresponder` enum('n','y') NOT NULL default 'n', |
| | | `autoresponder_start_date` datetime NOT NULL default '0000-00-00 00:00:00', |
| | |
| | | `backup_mode` varchar(64) NOT NULL DEFAULT '', |
| | | `tstamp` int(10) unsigned NOT NULL DEFAULT '0', |
| | | `filename` varchar(255) NOT NULL DEFAULT '', |
| | | `filesize` VARCHAR(10) NOT NULL DEFAULT '', |
| | | `filesize` VARCHAR(20) NOT NULL DEFAULT '', |
| | | PRIMARY KEY (`backup_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | `traffic_quota_lock` enum('n','y') NOT NULL default 'n', |
| | | `fastcgi_php_version` varchar(255) DEFAULT NULL, |
| | | `proxy_directives` mediumtext, |
| | | `enable_spdy` ENUM('y','n') NULL DEFAULT 'n', |
| | | `last_quota_notification` date NULL default NULL, |
| | | `rewrite_rules` mediumtext, |
| | | `added_date` date NOT NULL DEFAULT '0000-00-00', |
| | | `added_by` varchar(255) DEFAULT NULL, |
| | | `directive_snippets_id` int(11) unsigned NOT NULL default '0', |
| | | 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 `dns_template` |
| | | -- |
| | | |
| | | INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Default', 'DOMAIN,IP,NS1,NS2,EMAIL', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=86400\nttl=3600\n\n[DNS_RECORDS]\nA|{DOMAIN}.|{IP}|0|3600\nA|www|{IP}|0|3600\nA|mail|{IP}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|mail.{DOMAIN}.|10|3600', 'y'); |
| | | INSERT INTO `dns_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `name`, `fields`, `template`, `visible`) VALUES (1, 1, 1, 'riud', 'riud', '', 'Default', 'DOMAIN,IP,NS1,NS2,EMAIL,DKIM', '[ZONE]\norigin={DOMAIN}.\nns={NS1}.\nmbox={EMAIL}.\nrefresh=7200\nretry=540\nexpire=604800\nminimum=86400\nttl=3600\n\n[DNS_RECORDS]\nA|{DOMAIN}.|{IP}|0|3600\nA|www|{IP}|0|3600\nA|mail|{IP}|0|3600\nNS|{DOMAIN}.|{NS1}.|0|3600\nNS|{DOMAIN}.|{NS2}.|0|3600\nMX|{DOMAIN}.|mail.{DOMAIN}.|10|3600\nTXT|{DOMAIN}.|v=spf1 mx a ~all|0|3600', 'y'); |
| | | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |