| | |
| | | `limit_web_ip` text, |
| | | `limit_web_domain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_web_quota` int(11) NOT NULL DEFAULT '-1', |
| | | `web_php_options` varchar(255) NOT NULL DEFAULT 'no,fast-cgi,cgi,mod,suphp,php-fpm', |
| | | `web_php_options` varchar(255) NOT NULL DEFAULT 'no,fast-cgi,cgi,mod,suphp,php-fpm,hhvm', |
| | | `limit_cgi` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_ssi` enum('n','y') NOT NULL DEFAULT 'n', |
| | | `limit_perl` enum('n','y') NOT NULL DEFAULT 'n', |
| | |
| | | `type` varchar(255) DEFAULT NULL, |
| | | `snippet` mediumtext, |
| | | `customer_viewable` ENUM('n','y') NOT NULL DEFAULT 'n', |
| | | `required_php_snippets` varchar(255) NOT NULL DEFAULT '', |
| | | `active` enum('n','y') NOT NULL DEFAULT 'y', |
| | | PRIMARY KEY (`directive_snippets_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | |
| | | `type` enum('A','AAAA','ALIAS','CNAME','HINFO','MX','NAPTR','NS','PTR','RP','SRV','TXT') default NULL, |
| | | `data` TEXT NOT NULL DEFAULT '', |
| | | `aux` int(11) unsigned NOT NULL default '0', |
| | | `ttl` int(11) unsigned NOT NULL default '86400', |
| | | `ttl` int(11) unsigned NOT NULL default '3600', |
| | | `active` enum('N','Y') NOT NULL default 'Y', |
| | | `stamp` timestamp NOT NULL default CURRENT_TIMESTAMP, |
| | | `serial` int(10) unsigned default NULL, |
| | |
| | | `refresh` int(11) unsigned NOT NULL default '28800', |
| | | `retry` int(11) unsigned NOT NULL default '7200', |
| | | `expire` int(11) unsigned NOT NULL default '604800', |
| | | `minimum` int(11) unsigned NOT NULL default '86400', |
| | | `ttl` int(11) unsigned NOT NULL default '86400', |
| | | `minimum` int(11) unsigned NOT NULL default '3600', |
| | | `ttl` int(11) unsigned NOT NULL default '3600', |
| | | `active` enum('N','Y') NOT NULL DEFAULT 'N', |
| | | `xfer` varchar(255) NOT NULL DEFAULT '', |
| | | `also_notify` varchar(255) default NULL, |
| | |
| | | `nameserver` varchar(255) DEFAULT NULL, |
| | | `create_dns` varchar(1) NOT NULL DEFAULT 'n', |
| | | `capability` varchar(255) DEFAULT NULL, |
| | | `features` varchar(255) DEFAULT NULL, |
| | | PRIMARY KEY (`template_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| | | |
| | |
| | | -- Dumping data for table `openvz_template` |
| | | -- |
| | | |
| | | INSERT INTO `openvz_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `diskspace`, `traffic`, `bandwidth`, `ram`, `ram_burst`, `cpu_units`, `cpu_num`, `cpu_limit`, `io_priority`, `active`, `description`, `numproc`, `numtcpsock`, `numothersock`, `vmguarpages`, `kmemsize`, `tcpsndbuf`, `tcprcvbuf`, `othersockbuf`, `dgramrcvbuf`, `oomguarpages`, `privvmpages`, `lockedpages`, `shmpages`, `physpages`, `numfile`, `avnumproc`, `numflock`, `numpty`, `numsiginfo`, `dcachesize`, `numiptent`, `swappages`, `hostname`, `nameserver`, `create_dns`, `capability`) VALUES(1, 1, 1, 'riud', 'riud', '', 'small', 10, -1, -1, 256, 512, 1000, 4, 400, 4, 'y', '', '999999:999999', '7999992:7999992', '7999992:7999992', '65536:65536', '2147483646:2147483646', '214748160:396774400', '214748160:396774400', '214748160:396774400', '214748160:396774400', '65536:65536', '131072:131072', '999999:999999', '65536:65536', '0:2147483647', '23999976:23999976', '180:180', '999999:999999', '500000:500000', '999999:999999', '2147483646:2147483646', '999999:999999', '256000:256000', 'v{VEID}.test.tld', '8.8.8.8 8.8.4.4', 'n', ''); |
| | | INSERT INTO `openvz_template` (`template_id`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `template_name`, `diskspace`, `traffic`, `bandwidth`, `ram`, `ram_burst`, `cpu_units`, `cpu_num`, `cpu_limit`, `io_priority`, `active`, `description`, `numproc`, `numtcpsock`, `numothersock`, `vmguarpages`, `kmemsize`, `tcpsndbuf`, `tcprcvbuf`, `othersockbuf`, `dgramrcvbuf`, `oomguarpages`, `privvmpages`, `lockedpages`, `shmpages`, `physpages`, `numfile`, `avnumproc`, `numflock`, `numpty`, `numsiginfo`, `dcachesize`, `numiptent`, `swappages`, `hostname`, `nameserver`, `create_dns`, `capability`, `features`) VALUES(1, 1, 1, 'riud', 'riud', '', 'small', 10, -1, -1, 256, 512, 1000, 4, 400, 4, 'y', '', '999999:999999', '7999992:7999992', '7999992:7999992', '65536:65536', '2147483646:2147483646', '214748160:396774400', '214748160:396774400', '214748160:396774400', '214748160:396774400', '65536:65536', '131072:131072', '999999:999999', '65536:65536', '0:2147483647', '23999976:23999976', '180:180', '999999:999999', '500000:500000', '999999:999999', '2147483646:2147483646', '999999:999999', '256000:256000', 'v{VEID}.test.tld', '8.8.8.8 8.8.4.4', 'n', '', ''); |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | |
| | | `nameserver` varchar(255) NOT NULL DEFAULT '8.8.8.8 8.8.4.4', |
| | | `create_dns` varchar(1) NOT NULL DEFAULT 'n', |
| | | `capability` text, |
| | | `features` text, |
| | | `config` mediumtext, |
| | | PRIMARY KEY (`vm_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; |
| | |
| | | -- 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,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'); |
| | | 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=3600\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'); |
| | | |
| | | |
| | | -- -------------------------------------------------------- |