5 files changed, 0 insertions, 671 deletions
diff --git a/syscp/patches/syscp-sqlfile/syscp-1.2.13-addopts-db.sql b/syscp/patches/syscp-sqlfile/syscp-1.2.13-addopts-db.sql
deleted file mode 100644
index 1bc4b28..0000000
--- a/syscp/patches/syscp-sqlfile/syscp-1.2.13-addopts-db.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-USE `MYSQL_DATABASE_NAME` ;
-
-ALTER TABLE `panel_domains` ADD `ssi_includes` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `parentdomainid` ,
-ADD `php_engine` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `ssi_includes` ,
-ADD `php_errordisplay` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `safemode` ;
-
-ALTER TABLE `panel_htaccess` ADD `options_execcgi` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `options_indexes` ;
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&ccedil;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&ntilde;ol', 'lng/spanish.lng.php');
-INSERT INTO `panel_languages` VALUES (7, 'Portugu&ecirc;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);
diff --git a/syscp/patches/syscp-sqlfile/syscp-1.2.13-mysqlftpimp-db.sql b/syscp/patches/syscp-sqlfile/syscp-1.2.13-mysqlftpimp-db.sql
deleted file mode 100644
index 3f29dea..0000000
--- a/syscp/patches/syscp-sqlfile/syscp-1.2.13-mysqlftpimp-db.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-USE `MYSQL_DATABASE_NAME` ;
-
-ALTER TABLE `panel_databases` ADD `databaseuser` VARCHAR( 255 ) NOT NULL AFTER `customerid` ;
-
-DROP TABLE IF EXISTS `panel_databases_users` ;
-CREATE TABLE `panel_databases_users` (
-`id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT,
-`customerid` INT( 11 ) NOT NULL DEFAULT '0',
-`databaseuser` VARCHAR( 255 ) NOT NULL,
-PRIMARY KEY  (`id`),
-KEY `customerid` (`customerid`)
-) TYPE = MYISAM ;
-
-ALTER TABLE `panel_customers` ADD `mysqls_used_users` INT( 15 ) NOT NULL DEFAULT '0' AFTER `mysqls_used` ;
-ALTER TABLE `panel_customers` ADD `mysql_lastusernumber` INT( 11 ) NOT NULL DEFAULT '0' AFTER `mysql_lastaccountnumber` ;
diff --git a/syscp/patches/syscp-sqlfile/syscp-1.2.13-sqlfile-r3.tar.bz2 b/syscp/patches/syscp-sqlfile/syscp-1.2.13-sqlfile-r3.tar.bz2
deleted file mode 100644
index 98fce46..0000000
--- a/syscp/patches/syscp-sqlfile/syscp-1.2.13-sqlfile-r3.tar.bz2
+++ /dev/null
diff --git a/syscp/patches/syscp-sqlfile/syscp-1.2.13-suphp-db.sql b/syscp/patches/syscp-sqlfile/syscp-1.2.13-suphp-db.sql
deleted file mode 100644
index f351acd..0000000
--- a/syscp/patches/syscp-sqlfile/syscp-1.2.13-suphp-db.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-USE `MYSQL_DATABASE_NAME` ;
-
-ALTER TABLE `panel_htaccess` ADD `options_phpversionselect` TINYINT( 1 ) NOT NULL DEFAULT '4' AFTER `options_execcgi` ;