| | |
| | | `limit_client` int(11) NOT NULL DEFAULT '0', |
| | | `limit_mailmailinglist` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_openvz_vm` int(11) NOT NULL DEFAULT '0', |
| | | `limit_openvz_vm_template` int(11) NOT NULL DEFAULT '0', |
| | | `limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0', |
| | | `parent_client_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `username` varchar(64) DEFAULT NULL, |
| | | `password` varchar(64) DEFAULT NULL, |
| | |
| | | `limit_client` int(11) NOT NULL default '0', |
| | | `limit_mailmailinglist` int(11) NOT NULL default '-1', |
| | | `limit_openvz_vm` int(11) NOT NULL DEFAULT '0', |
| | | `limit_openvz_vm_template` int(11) NOT NULL DEFAULT '0', |
| | | `limit_openvz_vm_template_id` int(11) NOT NULL DEFAULT '0', |
| | | PRIMARY KEY (`template_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | -- |
| | | |
| | | CREATE TABLE `sys_session` ( |
| | | `session_id` varchar(32) NOT NULL DEFAULT '', |
| | | `session_id` varchar(64) NOT NULL DEFAULT '', |
| | | `date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `last_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', |
| | | `session_data` longtext, |
| | |
| | | `sys_perm_other` varchar(5) default NULL, |
| | | `server_id` int(11) unsigned NOT NULL default '0', |
| | | `ip_address` varchar(39) default NULL, |
| | | `ipv6_address` VARCHAR( 255 ) default NULL, |
| | | `domain` varchar(255) default NULL, |
| | | `type` varchar(32) default NULL, |
| | | `parent_domain_id` int(11) unsigned NOT NULL default '0', |
| | |
| | | `subdomain` enum('none','www','*') NOT NULL default 'none', |
| | | `php` varchar(32) NOT NULL default 'y', |
| | | `ruby` enum('n','y') NOT NULL default 'n', |
| | | `python` enum('n','y') NOT NULL default 'n', |
| | | `redirect_type` varchar(255) default NULL, |
| | | `redirect_path` varchar(255) default NULL, |
| | | `seo_redirect` varchar(255) default NULL, |
| | |
| | | `allow_override` varchar(255) NOT NULL default 'All', |
| | | `apache_directives` mediumtext, |
| | | `nginx_directives` mediumtext, |
| | | `php_fpm_use_socket` ENUM('n','y') NOT NULL DEFAULT 'n', |
| | | `pm_max_children` int(11) NOT NULL DEFAULT '50', |
| | | `pm_start_servers` int(11) NOT NULL DEFAULT '20', |
| | | `pm_min_spare_servers` int(11) NOT NULL DEFAULT '5', |
| | | `pm_max_spare_servers` int(11) NOT NULL DEFAULT '35', |
| | | `php_open_basedir` mediumtext, |
| | | `custom_php_ini` mediumtext, |
| | | `backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none', |
| | |
| | | `sys_perm_user` varchar(5) DEFAULT NULL, |
| | | `sys_perm_group` varchar(5) DEFAULT NULL, |
| | | `sys_perm_other` varchar(5) DEFAULT NULL, |
| | | `server_id` int(11) NOT NULL DEFAULT '0', |
| | | `web_folder_id` int(11) NOT NULL DEFAULT '0', |
| | | `username` varchar(255) DEFAULT NULL, |
| | | `password` varchar(255) DEFAULT NULL, |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.3.3'); |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.4'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |