| | |
| | | /* |
| | | 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, |
| | |
| | | `internet` varchar(255) NOT NULL, |
| | | `icq` varchar(16) DEFAULT NULL, |
| | | `notes` text, |
| | | `bank_account_number` varchar(255) DEFAULT NULL, |
| | | `bank_code` varchar(255) DEFAULT NULL, |
| | | `bank_name` varchar(255) DEFAULT NULL, |
| | | `bank_account_iban` varchar(255) DEFAULT NULL, |
| | | `bank_account_swift` varchar(255) DEFAULT NULL, |
| | | `default_mailserver` int(11) unsigned NOT NULL DEFAULT '1', |
| | | `limit_maildomain` int(11) NOT NULL DEFAULT '-1', |
| | | `limit_mailbox` int(11) NOT NULL DEFAULT '-1', |
| | |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | |
| | | -- |
| | | -- Table structure for table `server_php` |
| | | -- |
| | | |
| | | CREATE TABLE `server_php` ( |
| | | `server_php_id` int(11) unsigned NOT NULL AUTO_INCREMENT, |
| | | `sys_userid` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `sys_groupid` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `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) unsigned NOT NULL DEFAULT '0', |
| | | `client_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `name` varchar(255) DEFAULT NULL, |
| | | `php_fastcgi_binary` varchar(255) DEFAULT NULL, |
| | | `php_fastcgi_ini_dir` varchar(255) DEFAULT NULL, |
| | | `php_fpm_init_script` varchar(255) DEFAULT NULL, |
| | | `php_fpm_ini_dir` varchar(255) DEFAULT NULL, |
| | | `php_fpm_pool_dir` varchar(255) DEFAULT NULL, |
| | | PRIMARY KEY (`server_php_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `shell_user` |
| | | -- |
| | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `web_backup` |
| | | -- |
| | | |
| | | CREATE TABLE `web_backup` ( |
| | | `backup_id` int(10) unsigned NOT NULL AUTO_INCREMENT, |
| | | `server_id` int(10) unsigned NOT NULL, |
| | | `parent_domain_id` int(10) unsigned NOT NULL, |
| | | `backup_type` enum('web','mysql') NOT NULL DEFAULT 'web', |
| | | `backup_mode` varchar(64) NOT NULL DEFAULT '', |
| | | `tstamp` int(10) unsigned NOT NULL, |
| | | `filename` varchar(255) NOT NULL, |
| | | PRIMARY KEY (`backup_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | | -- -------------------------------------------------------- |
| | | |
| | | -- |
| | | -- Table structure for table `web_database` |
| | | -- |
| | | |
| | |
| | | `sys_perm_group` varchar(5) DEFAULT NULL, |
| | | `sys_perm_other` varchar(5) DEFAULT NULL, |
| | | `server_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `parent_domain_id` int(11) unsigned NOT NULL DEFAULT '0', |
| | | `type` varchar(16) NOT NULL DEFAULT 'y', |
| | | `database_name` varchar(64) DEFAULT NULL, |
| | | `database_user` varchar(64) DEFAULT NULL, |
| | |
| | | `database_charset` varchar(64) DEFAULT NULL, |
| | | `remote_access` enum('n','y') NOT NULL DEFAULT 'y', |
| | | `remote_ips` text NOT NULL, |
| | | `backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none', |
| | | `backup_copies` INT NOT NULL DEFAULT '1', |
| | | `active` enum('n','y') NOT NULL DEFAULT 'y', |
| | | PRIMARY KEY (`database_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | |
| | | `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', |
| | | `pm` enum('static','dynamic','ondemand') NOT NULL DEFAULT 'dynamic', |
| | | `pm_max_children` int(11) NOT NULL DEFAULT '10', |
| | | `pm_start_servers` int(11) NOT NULL DEFAULT '2', |
| | | `pm_min_spare_servers` int(11) NOT NULL DEFAULT '1', |
| | | `pm_max_spare_servers` int(11) NOT NULL DEFAULT '5', |
| | | `pm_process_idle_timeout` int(11) NOT NULL DEFAULT '10', |
| | | `pm_max_requests` int(11) NOT NULL DEFAULT '0', |
| | | `php_open_basedir` mediumtext, |
| | | `custom_php_ini` mediumtext, |
| | | `backup_interval` VARCHAR( 255 ) NOT NULL DEFAULT 'none', |
| | | `backup_copies` INT NOT NULL DEFAULT '1', |
| | | `active` enum('n','y') NOT NULL default 'y', |
| | | `traffic_quota_lock` enum('n','y') NOT NULL default 'n', |
| | | `fastcgi_php_version` varchar(255) DEFAULT NULL, |
| | | PRIMARY KEY (`domain_id`) |
| | | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |
| | | |
| | |
| | | -- Dumping data for table `sys_config` |
| | | -- |
| | | |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.4'); |
| | | INSERT INTO sys_config VALUES ('1','db','db_version','3.0.4.4'); |
| | | |
| | | SET FOREIGN_KEY_CHECKS = 1; |