diff options
Diffstat (limited to 'syscp/patches/syscp-sqlfile/syscp-1.2.13-baseinstall-db.sql')
| -rw-r--r-- | syscp/patches/syscp-sqlfile/syscp-1.2.13-baseinstall-db.sql | 646 |
1 files changed, 0 insertions, 646 deletions
diff --git a/syscp/patches/syscp-sqlfile/syscp-1.2.13-baseinstall-db.sql b/syscp/patches/syscp-sqlfile/syscp-1.2.13-baseinstall-db.sql deleted file mode 100644 index f02d175..0000000 --- a/syscp/patches/syscp-sqlfile/syscp-1.2.13-baseinstall-db.sql +++ /dev/null @@ -1,646 +0,0 @@ -# $Id: syscp.sql,v 1.50 2005/09/21 10:33:05 flo Exp $ -# -------------------------------------------------------- - -# -# Delete old users and databases if present -# - -DELETE FROM `mysql`.`user` WHERE `User` = 'MYSQL_UNPRIV_USER' AND `Host` = 'MYSQL_ACCESS_HOST'; -DELETE FROM `mysql`.`db` WHERE `User` = 'MYSQL_UNPRIV_USER' AND `Host` = 'MYSQL_ACCESS_HOST'; -DELETE FROM `mysql`.`tables_priv` WHERE `User` = 'MYSQL_UNPRIV_USER' AND `Host` = 'MYSQL_ACCESS_HOST'; -DELETE FROM `mysql`.`columns_priv` WHERE `User` = 'MYSQL_UNPRIV_USER' AND `Host` = 'MYSQL_ACCESS_HOST'; -DROP DATABASE IF EXISTS `MYSQL_DATABASE_NAME`; -FLUSH PRIVILEGES; - -# -# Create new users and databases -# - -CREATE DATABASE `MYSQL_DATABASE_NAME`; -GRANT ALL PRIVILEGES ON `MYSQL_DATABASE_NAME`.* TO MYSQL_UNPRIV_USER@MYSQL_ACCESS_HOST IDENTIFIED BY 'password'; -SET PASSWORD FOR MYSQL_UNPRIV_USER@MYSQL_ACCESS_HOST = PASSWORD('MYSQL_UNPRIV_PASSWORD'); -FLUSH PRIVILEGES; - -USE `MYSQL_DATABASE_NAME`; - -# -# Table structure for table `ftp_groups` -# - -DROP TABLE IF EXISTS `ftp_groups`; -CREATE TABLE `ftp_groups` ( - `id` int(20) NOT NULL auto_increment, - `groupname` varchar(60) NOT NULL default '', - `gid` int(5) NOT NULL default '0', - `members` longtext NOT NULL, - `customerid` int(11) NOT NULL default '0', - PRIMARY KEY (`id`), - UNIQUE KEY `groupname` (`groupname`), - KEY `customerid` (`customerid`) -) TYPE=MyISAM ; - -# -# Dumping data for table `ftp_groups` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `ftp_users` -# - -DROP TABLE IF EXISTS `ftp_users`; -CREATE TABLE `ftp_users` ( - `id` int(20) NOT NULL auto_increment, - `username` varchar(128) NOT NULL default '', - `uid` int(5) NOT NULL default '0', - `gid` int(5) NOT NULL default '0', - `password` varchar(128) NOT NULL default '', - `homedir` varchar(255) NOT NULL default '', - `shell` varchar(255) NOT NULL default '/bin/false', - `login_enabled` enum('N','Y') NOT NULL default 'N', - `login_count` int(15) NOT NULL default '0', - `last_login` datetime NOT NULL default '0000-00-00 00:00:00', - `up_count` int(15) NOT NULL default '0', - `up_bytes` bigint(30) NOT NULL default '0', - `down_count` int(15) NOT NULL default '0', - `down_bytes` bigint(30) NOT NULL default '0', - `customerid` int(11) NOT NULL default '0', - PRIMARY KEY (`id`), - UNIQUE KEY `username` (`username`), - KEY `customerid` (`customerid`) -) TYPE=MyISAM ; - -# -# Dumping data for table `ftp_users` -# - -# -------------------------------------------------------- - - -# -# Table structure for table `mail_users` -# - -DROP TABLE IF EXISTS `mail_users`; -CREATE TABLE `mail_users` ( - `id` int(11) NOT NULL auto_increment, - `email` varchar(255) NOT NULL default '', - `username` varchar(255) NOT NULL default '', - `password` varchar(128) NOT NULL default '', - `password_enc` varchar(128) NOT NULL default '', - `uid` int(11) NOT NULL default '0', - `gid` int(11) NOT NULL default '0', - `homedir` varchar(255) NOT NULL default '', - `maildir` varchar(255) NOT NULL default '', - `postfix` enum('Y','N') NOT NULL default 'Y', - `domainid` int(11) NOT NULL default '0', - `customerid` int(11) NOT NULL default '0', - PRIMARY KEY (`id`), - UNIQUE KEY `email` (`email`) -) TYPE=MyISAM ; - -# -# Dumping data for table `mail_users` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `mail_virtual` -# - -DROP TABLE IF EXISTS `mail_virtual`; -CREATE TABLE `mail_virtual` ( - `id` int(11) NOT NULL auto_increment, - `email` varchar(255) NOT NULL default '', - `email_full` varchar(255) NOT NULL default '', - `destination` text NOT NULL, - `domainid` int(11) NOT NULL default '0', - `customerid` int(11) NOT NULL default '0', - `popaccountid` int(11) NOT NULL default '0', - `iscatchall` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `mail_virtual` -# - -# -------------------------------------------------------- - - -# -# Table structure for table `panel_admins` -# - -DROP TABLE IF EXISTS `panel_admins`; -CREATE TABLE `panel_admins` ( - `adminid` int(11) unsigned NOT NULL auto_increment, - `loginname` varchar(50) NOT NULL default '', - `password` varchar(50) NOT NULL default '', - `name` varchar(255) NOT NULL default '', - `email` varchar(255) NOT NULL default '', - `def_language` varchar(255) NOT NULL default '', - `customers` int(15) NOT NULL default '0', - `customers_used` int(15) NOT NULL default '0', - `customers_see_all` tinyint(1) NOT NULL default '0', - `domains` int(15) NOT NULL default '0', - `domains_used` int(15) NOT NULL default '0', - `domains_see_all` tinyint(1) NOT NULL default '0', - `change_serversettings` tinyint(1) NOT NULL default '0', - `diskspace` int(15) NOT NULL default '0', - `diskspace_used` int(15) NOT NULL default '0', - `mysqls` int(15) NOT NULL default '0', - `mysqls_used` int(15) NOT NULL default '0', - `emails` int(15) NOT NULL default '0', - `emails_used` int(15) NOT NULL default '0', - `email_accounts` int(15) NOT NULL default '0', - `email_accounts_used` int(15) NOT NULL default '0', - `email_forwarders` int(15) NOT NULL default '0', - `email_forwarders_used` int(15) NOT NULL default '0', - `ftps` int(15) NOT NULL default '0', - `ftps_used` int(15) NOT NULL default '0', - `subdomains` int(15) NOT NULL default '0', - `subdomains_used` int(15) NOT NULL default '0', - `traffic` int(15) NOT NULL default '0', - `traffic_used` int(15) NOT NULL default '0', - `deactivated` tinyint(1) NOT NULL default '0', - `lastlogin_succ` int(11) unsigned NOT NULL default '0', - `lastlogin_fail` int(11) unsigned NOT NULL default '0', - `loginfail_count` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`adminid`) -) TYPE=MyISAM ; - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_customers` -# - -DROP TABLE IF EXISTS `panel_customers`; -CREATE TABLE `panel_customers` ( - `customerid` int(11) unsigned NOT NULL auto_increment, - `loginname` varchar(50) NOT NULL default '', - `password` varchar(50) NOT NULL default '', - `adminid` int(11) unsigned NOT NULL default '0', - `name` varchar(255) NOT NULL default '', - `firstname` varchar(255) NOT NULL default '', - `company` varchar(255) NOT NULL default '', - `street` varchar(255) NOT NULL default '', - `zipcode` varchar(255) NOT NULL default '', - `city` varchar(255) NOT NULL default '', - `phone` varchar(255) NOT NULL default '', - `fax` varchar(255) NOT NULL default '', - `email` varchar(255) NOT NULL default '', - `customernumber` varchar(255) NOT NULL default '', - `def_language` varchar(255) NOT NULL default '', - `diskspace` int(15) NOT NULL default '0', - `diskspace_used` int(15) NOT NULL default '0', - `mysqls` int(15) NOT NULL default '0', - `mysqls_used` int(15) NOT NULL default '0', - `emails` int(15) NOT NULL default '0', - `emails_used` int(15) NOT NULL default '0', - `email_accounts` int(15) NOT NULL default '0', - `email_accounts_used` int(15) NOT NULL default '0', - `email_forwarders` int(15) NOT NULL default '0', - `email_forwarders_used` int(15) NOT NULL default '0', - `ftps` int(15) NOT NULL default '0', - `ftps_used` int(15) NOT NULL default '0', - `subdomains` int(15) NOT NULL default '0', - `subdomains_used` int(15) NOT NULL default '0', - `traffic` int(15) NOT NULL default '0', - `traffic_used` int(15) NOT NULL default '0', - `documentroot` varchar(255) NOT NULL default '', - `standardsubdomain` int(11) NOT NULL default '0', - `guid` int(5) NOT NULL default '0', - `ftp_lastaccountnumber` int(11) NOT NULL default '0', - `mysql_lastaccountnumber` int(11) NOT NULL default '0', - `deactivated` tinyint(1) NOT NULL default '0', - `lastlogin_succ` int(11) unsigned NOT NULL default '0', - `lastlogin_fail` int(11) unsigned NOT NULL default '0', - `loginfail_count` int(11) unsigned NOT NULL default '0', - PRIMARY KEY (`customerid`), - KEY `loginname` (`loginname`) -) TYPE=MyISAM ; -# -# Dumping data for table `panel_customers` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_databases` -# - -DROP TABLE IF EXISTS `panel_databases`; -CREATE TABLE `panel_databases` ( - `id` int(11) unsigned NOT NULL auto_increment, - `customerid` int(11) NOT NULL default '0', - `databasename` varchar(255) NOT NULL default '', - `description` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`), - KEY `customerid` (`customerid`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_databases` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_domains` -# -DROP TABLE IF EXISTS `panel_domains`; -CREATE TABLE `panel_domains` ( - `id` int(11) unsigned NOT NULL auto_increment, - `domain` varchar(255) NOT NULL default '', - `adminid` int(11) unsigned NOT NULL default '0', - `customerid` int(11) unsigned NOT NULL default '0', - `aliasdomain` int(11) unsigned NULL, - `documentroot` varchar(255) NOT NULL default '', - `ipandport` int(11) unsigned NOT NULL default '1', - `isbinddomain` tinyint(1) NOT NULL default '0', - `isemaildomain` tinyint(1) NOT NULL default '0', - `iswildcarddomain` tinyint(1) NOT NULL default '0', - `subcanemaildomain` tinyint(1) NOT NULL default '0', - `caneditdomain` tinyint(1) NOT NULL default '1', - `zonefile` varchar(255) NOT NULL default '', - `parentdomainid` int(11) unsigned NOT NULL default '0', - `openbasedir` tinyint(1) NOT NULL default '0', - `safemode` tinyint(1) NOT NULL default '0', - `speciallogfile` tinyint(1) NOT NULL default '0', - `specialsettings` text NOT NULL, - `deactivated` tinyint(1) NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `customerid` (`customerid`), - KEY `parentdomain` (`parentdomainid`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_domains` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_ipsandports` -# -DROP TABLE IF EXISTS `panel_ipsandports`; -CREATE TABLE `panel_ipsandports` ( - `id` int(11) unsigned NOT NULL auto_increment, - `ip` varchar(15) NOT NULL default '', - `port` int(5) NOT NULL default '80', - `default` int(1) NOT NULL default '0', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_ipsandports` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_htaccess` -# - -DROP TABLE IF EXISTS `panel_htaccess`; -CREATE TABLE `panel_htaccess` ( - `id` int(11) unsigned NOT NULL auto_increment, - `customerid` int(11) unsigned NOT NULL default '0', - `path` varchar(255) NOT NULL default '', - `options_indexes` tinyint(1) NOT NULL default '0', - `error404path` varchar(255) NOT NULL default '', - `error403path` varchar(255) NOT NULL default '', - `error500path` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_htaccess` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_htpasswds` -# - -DROP TABLE IF EXISTS `panel_htpasswds`; -CREATE TABLE `panel_htpasswds` ( - `id` int(11) unsigned NOT NULL auto_increment, - `customerid` int(11) unsigned NOT NULL default '0', - `path` varchar(255) NOT NULL default '', - `username` varchar(255) NOT NULL default '', - `password` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`), - KEY `customerid` (`customerid`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_htpasswds` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_sessions` -# - -DROP TABLE IF EXISTS `panel_sessions`; -CREATE TABLE `panel_sessions` ( - `hash` varchar(32) NOT NULL default '', - `userid` int(11) unsigned NOT NULL default '0', - `ipaddress` varchar(16) NOT NULL default '', - `useragent` varchar(255) NOT NULL default '', - `lastactivity` int(11) unsigned NOT NULL default '0', - `language` varchar(64) NOT NULL default '', - `adminsession` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`hash`), - KEY `userid` (`userid`) -) TYPE=HEAP; - -# -# Dumping data for table `panel_sessions` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_settings` -# - -DROP TABLE IF EXISTS `panel_settings`; -CREATE TABLE `panel_settings` ( - `settingid` int(11) unsigned NOT NULL auto_increment, - `settinggroup` varchar(255) NOT NULL default '', - `varname` varchar(255) NOT NULL default '', - `value` text NOT NULL, - PRIMARY KEY (`settingid`) -) TYPE=MyISAM ; - - -# -------------------------------------------------------- - -# -# Dumping data for table `panel_settings` -# - -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (1, 'session', 'sessiontimeout', '600'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (2, 'panel', 'adminmail', 'admin@SERVERNAME'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (3, 'panel', 'phpmyadmin_url', ''); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (5, 'customer', 'accountprefix', 'web'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (6, 'customer', 'ftpprefix', 'f'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (7, 'customer', 'mysqlprefix', 's'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (8, 'system', 'lastaccountnumber', '0'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (9, 'system', 'lastguid', '10000'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (10, 'system', 'documentroot_prefix', '/var/www/syscpwebs/'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (11, 'system', 'logfiles_directory', '/var/log/syscplogs/'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (12, 'system', 'ipaddress', 'SERVERIP'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (13, 'system', 'apacheconf_directory', '/etc/apache2/'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (14, 'system', 'apachereload_command', '/etc/init.d/apache2 reload'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (15, 'system', 'last_traffic_run', '000000'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (16, 'system', 'vmail_uid', '9997'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (17, 'system', 'vmail_gid', '9997'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (18, 'system', 'vmail_homedir', '/var/syscpvmail/'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (19, 'system', 'bindconf_directory', '/etc/bind/'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (20, 'system', 'bindreload_command', '/bin/true'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (21, 'system', 'binddefaultzone', 'default.zone'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (22, 'panel', 'version', '1.2.13'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (23, 'system', 'hostname', 'SERVERNAME'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (24, 'login', 'maxloginattempts', '3'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (25, 'login', 'deactivatetime', '900'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (26, 'panel', 'webmail_url', ''); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (27, 'panel', 'webftp_url', ''); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (28, 'panel', 'standardlanguage', 'English'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (29, 'system', 'mysql_access_host', 'MYSQL_ACCESS_HOST'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (30, 'panel', 'pathedit', 'Manual'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (31, 'system', 'apacheconf_filename', 'vhosts.d/99_syscp-vhosts.conf'); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (32, 'system', 'lastcronrun', UNIX_TIMESTAMP()); -INSERT INTO `panel_settings` (`settingid`, `settinggroup`, `varname`, `value`) VALUES (33, 'panel', 'paging', '20'); - -# -------------------------------------------------------- - -# -# Table structure for table `panel_tasks` -# - -DROP TABLE IF EXISTS `panel_tasks`; -CREATE TABLE `panel_tasks` ( - `id` int(11) unsigned NOT NULL auto_increment, - `type` int(11) NOT NULL default '0', - `data` text NOT NULL, - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_tasks` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_templates` -# - -DROP TABLE IF EXISTS `panel_templates`; -CREATE TABLE `panel_templates` ( - `id` int(11) NOT NULL auto_increment, - `adminid` int(11) NOT NULL default '0', - `language` varchar(255) NOT NULL default '', - `templategroup` varchar(255) NOT NULL default '', - `varname` varchar(255) NOT NULL default '', - `value` longtext NOT NULL, - PRIMARY KEY (id), - KEY adminid (adminid) -) TYPE=MyISAM; - -# -# Dumping data for table `panel_templates` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_traffic` -# - -DROP TABLE IF EXISTS `panel_traffic`; -CREATE TABLE `panel_traffic` ( - `id` int(11) unsigned NOT NULL auto_increment, - `customerid` int(11) unsigned NOT NULL default '0', - `year` int(4) unsigned zerofill NOT NULL default '0000', - `month` int(2) unsigned zerofill NOT NULL default '00', - `day` int(2) unsigned zerofill NOT NULL default '00', - `http` bigint(30) unsigned NOT NULL default '0', - `ftp_up` bigint(30) unsigned NOT NULL default '0', - `ftp_down` bigint(30) unsigned NOT NULL default '0', - `mail` bigint(30) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `customerid` (`customerid`), - UNIQUE `date` (`customerid` , `year` , `month` , `day`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_traffic` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_traffic_admins` -# - -DROP TABLE IF EXISTS `panel_traffic_admins`; -CREATE TABLE `panel_traffic_admins` ( - `id` int(11) unsigned NOT NULL auto_increment, - `adminid` int(11) unsigned NOT NULL default '0', - `year` int(4) unsigned zerofill NOT NULL default '0000', - `month` int(2) unsigned zerofill NOT NULL default '00', - `day` int(2) unsigned zerofill NOT NULL default '00', - `http` bigint(30) unsigned NOT NULL default '0', - `ftp_up` bigint(30) unsigned NOT NULL default '0', - `ftp_down` bigint(30) unsigned NOT NULL default '0', - `mail` bigint(30) unsigned NOT NULL default '0', - PRIMARY KEY (`id`), - KEY `adminid` (`adminid`), - UNIQUE `date` (`adminid` , `year` , `month` , `day`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_traffic_admins` -# - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_navigation` -# - -DROP TABLE IF EXISTS `panel_navigation`; -CREATE TABLE `panel_navigation` ( - `id` int(11) unsigned NOT NULL auto_increment, - `area` varchar(20) NOT NULL default '', - `parent_url` varchar(255) NOT NULL default '', - `lang` varchar(255) NOT NULL default '', - `url` varchar(255) NOT NULL default '', - `order` int(4) NOT NULL default '0', - `required_resources` varchar(255) NOT NULL default '', - `new_window` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_navigation` -# - -INSERT INTO `panel_navigation` VALUES (1, 'login', '', 'login;login', 'login.nourl', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (2, 'login', 'login.nourl', 'login;login', 'index.php', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (3, 'customer', '', 'menue;main;main', 'customer_index.php', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (4, 'customer', 'customer_index.php', 'menue;main;changepassword', 'customer_index.php?page=change_password', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (5, 'customer', 'customer_index.php', 'menue;main;changelanguage', 'customer_index.php?page=change_language', '20', '', 0); -INSERT INTO `panel_navigation` VALUES (6, 'customer', 'customer_index.php', 'login;logout', 'customer_index.php?action=logout', '30', '', 0); -INSERT INTO `panel_navigation` VALUES (7, 'customer', '', 'menue;email;email', 'customer_email.php', '20', '', 0); -INSERT INTO `panel_navigation` VALUES (8, 'customer', 'customer_email.php', 'menue;email;emails', 'customer_email.php?page=emails', '10', 'emails', 0); -INSERT INTO `panel_navigation` VALUES (9, 'customer', '', 'menue;mysql;mysql', 'customer_mysql.php', '30', '', 0); -INSERT INTO `panel_navigation` VALUES (10, 'customer', 'customer_mysql.php', 'menue;mysql;databases', 'customer_mysql.php?page=mysqls', '10', 'mysqls', 0); -INSERT INTO `panel_navigation` VALUES (11, 'customer', '', 'menue;domains;domains', 'customer_domains.php', '40', '', 0); -INSERT INTO `panel_navigation` VALUES (12, 'customer', 'customer_domains.php', 'menue;domains;settings', 'customer_domains.php?page=domains', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (13, 'customer', '', 'menue;ftp;ftp', 'customer_ftp.php', '50', '', 0); -INSERT INTO `panel_navigation` VALUES (14, 'customer', 'customer_ftp.php', 'menue;ftp;accounts', 'customer_ftp.php?page=accounts', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (15, 'customer', '', 'menue;extras;extras', 'customer_extras.php', '60', '', 0); -INSERT INTO `panel_navigation` VALUES (16, 'customer', 'customer_extras.php', 'menue;extras;directoryprotection', 'customer_extras.php?page=htpasswds', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (17, 'customer', 'customer_extras.php', 'menue;extras;pathoptions', 'customer_extras.php?page=htaccess', '20', '', 0); -INSERT INTO `panel_navigation` VALUES (18, 'admin', '', 'admin;overview', 'admin_index.php', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (19, 'admin', 'admin_index.php', 'menue;main;changepassword', 'admin_index.php?page=change_password', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (20, 'admin', 'admin_index.php', 'menue;main;changelanguage', 'admin_index.php?page=change_language', '20', '', 0); -INSERT INTO `panel_navigation` VALUES (21, 'admin', 'admin_index.php', 'login;logout', 'admin_index.php?action=logout', '30', '', 0); -INSERT INTO `panel_navigation` VALUES (22, 'admin', '', 'admin;resources', 'admin_resources.nourl', '20', 'customers', 0); -INSERT INTO `panel_navigation` VALUES (23, 'admin', 'admin_resources.nourl', 'admin;customers', 'admin_customers.php?page=customers', '10', 'customers', 0); -INSERT INTO `panel_navigation` VALUES (24, 'admin', 'admin_resources.nourl', 'admin;domains', 'admin_domains.php?page=domains', '20', 'domains', 0); -INSERT INTO `panel_navigation` VALUES (25, 'admin', 'admin_resources.nourl', 'admin;admins', 'admin_admins.php?page=admins', '30', 'change_serversettings', 0); -INSERT INTO `panel_navigation` VALUES (26, 'admin', '', 'admin;server', 'admin_server.nourl', '30', 'change_serversettings', 0); -INSERT INTO `panel_navigation` VALUES (27, 'admin', 'admin_server.nourl', 'admin;configfiles;serverconfiguration', 'admin_configfiles.php?page=configfiles', '10', 'change_serversettings', 0); -INSERT INTO `panel_navigation` VALUES (28, 'admin', 'admin_server.nourl', 'admin;serversettings', 'admin_settings.php?page=settings', '20', 'change_serversettings', 0); -INSERT INTO `panel_navigation` VALUES (29, 'admin', '', 'admin;templates;templates', 'admin_templates.nourl', '40', '', 0); -INSERT INTO `panel_navigation` VALUES (30, 'admin', 'admin_templates.nourl', 'admin;templates;email', 'admin_templates.php?page=email', '10', '', 0); -INSERT INTO `panel_navigation` VALUES (31, 'admin', 'admin_server.nourl', 'admin;rebuildconf', 'admin_settings.php?page=rebuildconfigs', '30', 'change_serversettings', 0); -INSERT INTO `panel_navigation` VALUES (32, 'admin', 'admin_server.nourl', 'admin;ipsandports;ipsandports', 'admin_ipsandports.php?page=ipsandports', '40', 'change_serversettings', 0); - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_languages` -# - -DROP TABLE IF EXISTS `panel_languages`; -CREATE TABLE `panel_languages` ( - `id` int(11) unsigned NOT NULL auto_increment, - `language` varchar(30) NOT NULL default '', - `file` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_languages` -# - -INSERT INTO `panel_languages` VALUES (1, 'Deutsch', 'lng/german.lng.php'); -INSERT INTO `panel_languages` VALUES (2, 'English', 'lng/english.lng.php'); -INSERT INTO `panel_languages` VALUES (3, 'Français', 'lng/french.lng.php'); -INSERT INTO `panel_languages` VALUES (4, 'Chinese', 'lng/zh-cn.lng.php'); -INSERT INTO `panel_languages` VALUES (5, 'Catalan', 'lng/catalan.lng.php'); -INSERT INTO `panel_languages` VALUES (6, 'Español', 'lng/spanish.lng.php'); -INSERT INTO `panel_languages` VALUES (7, 'Português', 'lng/portugues.lng.php'); -INSERT INTO `panel_languages` VALUES (8, 'Italiano', 'lng/italian.lng.php'); - - -# -------------------------------------------------------- - -# -# Table structure for table `panel_cronscript` -# - -DROP TABLE IF EXISTS `panel_cronscript`; -CREATE TABLE `panel_cronscript` ( - `id` int(11) unsigned NOT NULL auto_increment, - `file` varchar(255) NOT NULL default '', - PRIMARY KEY (`id`) -) TYPE=MyISAM ; - -# -# Dumping data for table `panel_cronscript` -# - -INSERT INTO `panel_cronscript` (`id`, `file`) VALUES (1, 'cron_traffic.php'); -INSERT INTO `panel_cronscript` (`id`, `file`) VALUES (2, 'cron_tasks.php'); - - -# -# Add the main IP/Port combo -# - -INSERT INTO `panel_ipsandports` (`ip`, `port`, `default`) VALUES ('SERVERIP', '80', '1'); - -# -# Add the main admin user -# - -INSERT INTO `panel_admins` (`loginname`, `password`, `name`, `email`, `customers`, `customers_used`, `customers_see_all`, `domains`, `domains_used`, `domains_see_all`, `change_serversettings`, `diskspace`, `diskspace_used`, `mysqls`, `mysqls_used`, `emails`, `emails_used`, `email_accounts`, `email_accounts_used`, `email_forwarders`, `email_forwarders_used`, `ftps`, `ftps_used`, `subdomains`, `subdomains_used`, `traffic`, `traffic_used`, `deactivated`) VALUES ('ADMIN_USERNAME', MD5('ADMIN_PASSWORD'), 'Siteadmin', 'admin@SERVERNAME', -1, 0, 1, -1, 0, 1, 1, -1024, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1, 0, -1048576, 0, 0); |