| | |
| | | /* |
| | | Copyright (c) 2007-2011, Till Brehm, projektfarm Gmbh |
| | | Copyright (c) 2007-2012, Till Brehm, projektfarm Gmbh |
| | | All rights reserved. |
| | | |
| | | Redistribution and use in source and binary forms, with or without modification, |
| | |
| | | `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_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', |
| | | `limit_web_subdomain` int(11) NOT NULL default '-1', |
| | | `limit_web_aliasdomain` int(11) NOT NULL default '-1', |
| | | `limit_ftp_user` int(11) NOT NULL default '-1', |
| | | `limit_shell_user` int(11) NOT NULL default '0', |
| | | `ssh_chroot` varchar(255) NOT NULL DEFAULT 'no', |
| | | `limit_webdav_user` int(11) NOT NULL default '0', |
| | | `limit_dns_zone` int(11) NOT NULL default '-1', |
| | | `limit_dns_slave_zone` int(11) NOT NULL default '-1', |
| | |
| | | `limit_traffic_quota` int(11) NOT NULL default '-1', |
| | | `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_id` int(11) NOT NULL DEFAULT '0', |
| | | PRIMARY KEY (`template_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | `shell` varchar(255) NOT NULL default '/bin/bash', |
| | | `dir` varchar(255) default NULL, |
| | | `chroot` varchar(255) NOT NULL, |
| | | `ssh_rsa` VARCHAR( 600 ) NOT NULL default '', |
| | | `ssh_rsa` text NOT NULL, |
| | | PRIMARY KEY (`shell_user_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, |
| | | `ssl` enum('n','y') NOT NULL default 'n', |
| | | `ssl_state` varchar(255) NULL, |
| | | `ssl_locality` varchar(255) 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.6'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |