SET FOREIGN_KEY_CHECKS=0;

CREATE DATABASE IF NOT EXISTS XPanel;


CREATE TABLE IF NOT EXISTS `XPanel`.`configuration` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`setting` varchar(255) NOT NULL,
	`value` text NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `setting` (`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `XPanel`.`webserver` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`ip` varchar(23) NOT NULL,
	`host_name` varchar(64),
	`login_name` varchar(16) NOT NULL,
	`password` char(32) NOT NULL,
	`default` enum('1'),
	PRIMARY KEY (`id`),
	UNIQUE KEY `ip` (`ip`),
	UNIQUE KEY `host_name` (`host_name`),
	UNIQUE KEY `default` (`default`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `XPanel`.`mailserver` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`ip` varchar(23) NOT NULL,
	`host_name` varchar(64),
	`login_name` varchar(16) NOT NULL,
	`password` char(32) NOT NULL,
	`default` enum('1'),
	PRIMARY KEY (`id`),
	UNIQUE KEY `ip` (`ip`),
	UNIQUE KEY `host_name` (`host_name`),
	UNIQUE KEY `default` (`default`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `XPanel`.`feature` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`name` varchar(255) NOT NULL,
	`php_support` enum('0','1') NOT NULL default '0',
	`php_safe_mode` enum('0','1') NOT NULL default '0',
	`php_as` enum('apache','fast_cgi') NOT NULL default 'apache',
	`cgi_support` enum('0','1') NOT NULL default '0',
	PRIMARY KEY (`id`),
	UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `XPanel`.`package` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`feature_id` int(10) unsigned NOT NULL,
	`name` varchar(255) NOT NULL,
	`description` varchar(255) NOT NULL,
	`hidden` enum('0','1') NOT NULL default '0',
	`free` enum('0','1') NOT NULL default '0',
	`monthly` decimal(10,2) NOT NULL default '0.00',
	`quarterly` decimal(10,2) NOT NULL default '0.00',
	`semiannually` decimal(10,2) NOT NULL default '0.00',
	`annually` decimal(10,2) NOT NULL default '0.00',
	`biennially` decimal(10,2) NOT NULL default '0.00',
	`domains` smallint(3) unsigned NOT NULL default '0',
	`subdomains` smallint(3) unsigned NOT NULL default '0',
	`domain_aliases` smallint(3) unsigned NOT NULL default '0',
	`disk_space_limit` int(10) unsigned NOT NULL default '1',
	`daily_data_transfer_limit` smallint(4) unsigned NOT NULL default '1',
	`monthly_data_transfer_limit` smallint(5) unsigned NOT NULL default '1',
	`email_accounts` smallint(3) unsigned NOT NULL default '0',
	`ftp_accounts` smallint(3) unsigned NOT NULL default '0',
	`mysql_databases` smallint(3) unsigned NOT NULL default '0',
	`mailbox_quota` smallint(5) unsigned NOT NULL default '10',
	PRIMARY KEY  (`id`),
	CONSTRAINT `package_ibfk_1` FOREIGN KEY (`feature_id`) REFERENCES `feature` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE IF NOT EXISTS `XPanel`.`customer` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`login_name` varchar(67) NOT NULL,
	`password` char(32) NOT NULL,
	`status` enum('notValidated','Validated','Active','Suspended','Cancelled','pendingCreate','pendingDelete','pendingUpdate') NOT NULL,
	`password_hint` varchar(64) NOT NULL,
	`call_in_pin` smallint(4) unsigned,
	`first_name` varchar(32) NOT NULL,
	`middle_name` varchar(32),
	`last_name` varchar(32) NOT NULL,
	`organization` varchar(64),
	`address1` varchar(64) NOT NULL,
	`address2` varchar(64),
	`city` varchar(32) NOT NULL,
	`state` varchar(32),
	`postal_code` varchar(16) NOT NULL,
	`country` char(2) NOT NULL,
	`work_phone` bigint(20) unsigned NOT NULL,
	`home_phone` bigint(20) unsigned,
	`mobile_phone` bigint(20) unsigned,
	`fax` bigint(20),
	`email` varchar(128) NOT NULL,
	`account_type` enum('0','1','2') NOT NULL default '0',
	`gender` enum('m','f'),
	`birthday` date,
	`language` char(5) NOT NULL default 'en-US',
	`subscribe` enum('0','1') NOT NULL default '0',
	`last_login` datetime NOT NULL,
	`last_ip_address` varchar(23) NOT NULL,
	`notes` text,
	`credit` decimal(10,2) NOT NULL default '0.00',
	`creation_date` datetime NOT NULL,
	`updated_date` datetime NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `login_name` (`login_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='XPanel Customer';


CREATE TABLE IF NOT EXISTS `XPanel`.`customer_auth_code` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`customer_id` int(10) unsigned NOT NULL,
	`email` varchar(128) NOT NULL,
	`code` varchar(32) NOT NULL,
	`creation_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	KEY (`customer_id`),
	CONSTRAINT `authorization_code_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='XPanel Authorization Code';


CREATE TABLE IF NOT EXISTS `XPanel`.`payment_details` (
	`customer_id` int(10) unsigned NOT NULL,
	`account_owner` varchar(255) NOT NULL,
	`national_identification_number` varchar(32) NOT NULL,
	`tax_identification_number` varchar(64),
	`taxpayer` enum('0','1') NOT NULL default '1',
	`bank_swift_code` varchar(32),
	`bank_account_number` varchar(32),
	`bank_name` varchar(255),
	PRIMARY KEY (`customer_id`),
	CONSTRAINT `customer_payment_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Customer Bank Account';


CREATE TABLE IF NOT EXISTS `XPanel`.`order` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`ordernum` bigint(20),
	`customer_id` int(10) unsigned NOT NULL,
	`date` datetime NOT NULL,
	`product` text NOT NULL,
	`amount` decimal(10,2) NOT NULL,
	`paymentmethod` enum('Credit Card','Cash','Check','Paypal', 'Wire Transfer', 'Free') NOT NULL,
	`invoice_id` int(10) unsigned default NULL,
	`status` enum('Pending','Fraud','Active','Cancelled','Deleted') NOT NULL,
	`ipaddress` text NOT NULL,
	`notes` text NOT NULL,
	PRIMARY KEY  (`id`),
	UNIQUE KEY `ordernum` (`ordernum`),
	KEY `customer_id` (`customer_id`),
	KEY `date` (`date`),
	UNIQUE KEY `invoice_id` (`invoice_id`),
	CONSTRAINT `tblorders_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE RESTRICT,
	CONSTRAINT `tblorders_ibfk_2` FOREIGN KEY (`invoice_id`) REFERENCES `invoice` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='XPanel order';


CREATE TABLE IF NOT EXISTS `XPanel`.`account` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`customer_id` int(10) unsigned NOT NULL,
	`package_id` int(10) unsigned NOT NULL,
	`webserver_id` int(10) unsigned NOT NULL,
	`mailserver_id` int(10) unsigned NOT NULL,
	`order_id` int(10) unsigned NOT NULL,
	`login_name` varchar(67),
	`password` char(32),
	`status` enum('notValidated','Validated','Active','Suspended','Cancelled','pendingCreate','pendingDelete','pendingRenew','pendingUpdate') NOT NULL,
	`billing_cycle` enum('0','1','3','6','12','24') NOT NULL default '3',
	`notes` text,
	`creation_date` datetime NOT NULL,
	`updated_date` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`expiration_date` datetime,
	PRIMARY KEY (`id`),
	UNIQUE KEY `login_name` (`login_name`),
	CONSTRAINT `account_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE RESTRICT,
	CONSTRAINT `account_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `package` (`id`) ON DELETE RESTRICT,
	CONSTRAINT `account_ibfk_3` FOREIGN KEY (`webserver_id`) REFERENCES `webserver` (`id`) ON DELETE RESTRICT,
	CONSTRAINT `account_ibfk_4` FOREIGN KEY (`mailserver_id`) REFERENCES `mailserver` (`id`) ON DELETE RESTRICT,
	CONSTRAINT `account_ibfk_5` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='XPanel Hosting Account';


CREATE TABLE IF NOT EXISTS `XPanel`.`domain` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`account_id` int(10) unsigned NOT NULL,
	`domain_name` varchar(67) NOT NULL,
	`password` varchar(32) NOT NULL,
	`status` enum('notValidated','Validated','Active','Blocked','Reserved','Suspended','Cancelled','pendingCreate','pendingDelete','pendingRenew','pendingUpdate') NOT NULL,
	`subdomains` smallint(3) unsigned NOT NULL default '0',
	`domain_aliases` smallint(3) unsigned NOT NULL default '0',
	`disk_space_limit` int(10) unsigned NOT NULL default '1',
	`disk_space_used` bigint(20) unsigned NOT NULL default '0',
	`daily_data_transfer_limit` smallint(4) unsigned NOT NULL default '1',
	`daily_data_transfer_used` bigint(20) unsigned NOT NULL default '0',
	`monthly_data_transfer_limit` smallint(5) unsigned NOT NULL default '1',
	`monthly_data_transfer_used` bigint(20) unsigned NOT NULL default '0',
	`email_accounts` smallint(3) unsigned NOT NULL default '0',
	`ftp_accounts` smallint(3) unsigned NOT NULL default '0',
	`mysql_databases` smallint(3) unsigned NOT NULL default '0',
	`mailbox_quota` smallint(5) unsigned NOT NULL default '10',
	`php_support` enum('0','1') NOT NULL default '0',
	`php_safe_mode` enum('0','1') NOT NULL default '0',
	`php_as` enum('apache','fast_cgi') NOT NULL default 'apache',
	`cgi_support` enum('0','1') NOT NULL default '0',
	`notes` text,
	`homedir` varchar(255) NOT NULL default '/tmp',
	`creation_date` datetime NOT NULL,
	`updated_date` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`expiration_date` datetime,
	PRIMARY KEY (`id`),
	UNIQUE KEY `domain_name` (`domain_name`),
	CONSTRAINT `domain_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=latin1 COMMENT='XPanel Domain';


CREATE TABLE IF NOT EXISTS `XPanel`.`dns_zone` (
	`zone_id` int(10) unsigned NOT NULL auto_increment,
	`domain_name` varchar(128) NOT NULL,
	`status` enum('Active','Suspended','Invalid','pendingCreate','pendingDelete','pendingUpdate') NOT NULL,
	`ns1` varchar(128) NOT NULL,
	`ns2` varchar(128) NOT NULL,
	`ns3` varchar(128),
	`ns4` varchar(128),
	`ns5` varchar(128),
	PRIMARY KEY (`zone_id`),
	UNIQUE KEY `domain_name` (`domain_name`),
	CONSTRAINT `dns_ibfk_1` FOREIGN KEY (`domain_name`) REFERENCES `domain` (`domain_name`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='DNS Zone';


CREATE TABLE IF NOT EXISTS `XPanel`.`zone_record` (
	`record_id` int(10) unsigned NOT NULL auto_increment,
	`domain_name` varchar(128) NOT NULL,
	`host` varchar(128),
	`ttl` int(5) NOT NULL default '3600',
	`type` enum('NS','A','CNAME','MX','TXT') NOT NULL default 'A',
	`priority` enum('0','10','20','30','40','50'),
	`value` varchar(128) NOT NULL,
	PRIMARY KEY (`record_id`),
	UNIQUE KEY `unique_record` (`domain_name`,`host`,`type`,`value`),
	CONSTRAINT `zone_record_ibfk_1` FOREIGN KEY (`domain_name`) REFERENCES `dns_zone` (`domain_name`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Resource Record';


CREATE TABLE IF NOT EXISTS `XPanel`.`reload_named` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`reload` enum('0','1'),
	PRIMARY KEY (`id`),
	UNIQUE KEY `reload` (`reload`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Reload named';


CREATE TABLE IF NOT EXISTS `XPanel`.`ftp_account` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`domain_name` varchar(67) NOT NULL,
	`login_name` varchar(128) NOT NULL,
	`password` char(32) NOT NULL,
	`homedir` varchar(255) NOT NULL default '/tmp',
	`status` enum('Active','Suspended','pendingCreate','pendingDelete') NOT NULL,
	PRIMARY KEY  (`id`),
	UNIQUE KEY `login_name` (`login_name`),
	KEY `domain_name` (`domain_name`),
	CONSTRAINT `ftp_ibfk_1` FOREIGN KEY (`domain_name`) REFERENCES `domain` (`domain_name`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Users ftp accounts';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`domain_name` varchar(67) NOT NULL,
	`mailbox` varchar(128) NOT NULL,
	`crypt` varchar(32) NOT NULL,
	`clear` varchar(32) NOT NULL,
	`name` varchar(64) NOT NULL,
	`uid` tinyint(3) unsigned NOT NULL default '93',
	`gid` tinyint(3) unsigned NOT NULL default '12',
	`home` varchar(255) NOT NULL,
	`maildir` varchar(255) NOT NULL,
	`quota` int(10) unsigned NOT NULL default '100',
	`status` enum('Active','Suspended','pendingCreate','pendingDelete') NOT NULL,
	`spam_filter` enum('0','1') NOT NULL default '1',
	`rate_limit` smallint(5) unsigned NOT NULL default '50',
	`sender_verify` enum('0','1') NOT NULL default '1',
	`reverse_dns` enum('0','1') NOT NULL default '1',
	`creation_date` datetime NOT NULL,
	`updated_date` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`),
	UNIQUE KEY `mailbox` (`mailbox`),
	KEY `domain_name` (`domain_name`),
	CONSTRAINT `mailbox_ibfk_1` FOREIGN KEY (`domain_name`) REFERENCES `domain` (`domain_name`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Users emails';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox_alias` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`mailbox` varchar(128) NOT NULL,
	`mailbox_alias` varchar(128) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `mailbox_alias` (`mailbox_alias`),
	KEY `mailbox` (`mailbox`),
	CONSTRAINT `mailbox_alias_ibfk_1` FOREIGN KEY (`mailbox`) REFERENCES `mailbox` (`mailbox`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mailbox Aliases';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox_forward` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`mailbox` varchar(128) NOT NULL,
	`forwarded_to` varchar(128) NOT NULL,
	`leave_copy` enum('0','1') NOT NULL default '0',
	PRIMARY KEY (`id`),
	UNIQUE KEY `mailbox` (`mailbox`),
	KEY `forwarded_to` (`forwarded_to`),
	CONSTRAINT `mailbox_forward_ibfk_1` FOREIGN KEY (`mailbox`) REFERENCES `mailbox` (`mailbox`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mail Forwards';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox_autoresponder` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`mailbox` varchar(128) NOT NULL,
	`subject` varchar(64) NOT NULL,
	`body` text NOT NULL,
	`responder_status` enum('0','1') NOT NULL default '1',
	PRIMARY KEY (`id`),
	UNIQUE KEY `mailbox` (`mailbox`),
	CONSTRAINT `mailbox_autoresponder_ibfk_1` FOREIGN KEY (`mailbox`) REFERENCES `mailbox` (`mailbox`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Autoresponder';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox_filter_status` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`mailbox` varchar(128) NOT NULL,
	`filter_status` enum('Active','Suspended','pendingCreate','pendingDelete','pendingUpdate') NOT NULL,
	PRIMARY KEY  (`id`),
	UNIQUE KEY `mailbox` (`mailbox`),
	CONSTRAINT `mailbox_filter_status_ibfk_1` FOREIGN KEY (`mailbox`) REFERENCES `mailbox` (`mailbox`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mail Filters';


CREATE TABLE IF NOT EXISTS `XPanel`.`mailbox_filter` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`mailbox` varchar(128) NOT NULL,
	`filter` varchar(255) NOT NULL,
	`priority` smallint(3) unsigned NOT NULL default '1',
	PRIMARY KEY  (`id`),
	UNIQUE KEY `unique_filter` (`mailbox`,`filter`),
	KEY `mailbox` (`mailbox`),
	CONSTRAINT `mailbox_filter_ibfk_1` FOREIGN KEY (`mailbox`) REFERENCES `mailbox_filter_status` (`mailbox`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Mail Filters';


CREATE TABLE IF NOT EXISTS `XPanel`.`invoice` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`customer_id` int(10) unsigned NOT NULL,
	`invoice_date` date NOT NULL,
	`payment_due_date` date NOT NULL,
	`status` enum('Unpaid','Pending','Paid','Canceled') NOT NULL,
	`product_name` varchar(255) NOT NULL,
	`product_description` varchar(255) NOT NULL,
	`billing_period` char(23) NOT NULL,
	`quantity` smallint(3) unsigned NOT NULL default '1',
	`unit_price` decimal(8,2) NOT NULL,
	`discount_percentage` decimal(5,2) NOT NULL default '0.00',
	`discount_total` decimal(8,2) NOT NULL default '0.00',
	`sub_total` decimal(8,2) NOT NULL,
	`tax_percentage` decimal(5,2) NOT NULL default '0.00',
	`tax_total` decimal(8,2) NOT NULL default '0.00',
	`total` decimal(8,2) NOT NULL,
	`credit` decimal(8,2) NOT NULL default '0.00',
	`total_amount_due` decimal(8,2) NOT NULL,
	`payable_in` char(3) NOT NULL,
	`notes` text,
	`paid_date` datetime,
	PRIMARY KEY (`id`),
	CONSTRAINT `invoice_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Invoice';


CREATE TABLE IF NOT EXISTS `XPanel`.`whitelisted_domains` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`domain_name` varchar(67) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `domain_name` (`domain_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Whitelisted Domains';


CREATE TABLE IF NOT EXISTS `XPanel`.`whitelisted_hosts` (
	`id` int(10) unsigned NOT NULL auto_increment,
	`address` varchar(23) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE KEY `address` (`address`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Whitelisted Hosts';


INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('1', 'serial_number', 'XP0000-0000-0000-0000');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('2', 'web_site', 'http://www.yourfreehost.com');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('3', 'cgi_bin', 'http://www.yourfreehost.com/cgi-bin/xpanel');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('4', 'domains', 'yourfreehost.com');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('5', 'ns1', 'ns1.yourfreehost.com');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('6', 'ns2', 'ns2.yourfreehost.com');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('7', 'orgname', 'XPanel Group');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('8', 'orgmail', 'support@yourfreehost.com');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('9', 'xpanel', '/usr/local/xpanel');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('10', 'templates_dir', '/usr/local/xpanel/templates');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('11', 'templates', 'default');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('12', 'file_exts', '\.txt|\.htm|\.html|\.tmpl|\.tpl|\.js|\.css|\.log|.cfg|\.conf|\.jpg|\.gif|\.png|\.swf|\.php|\.xml|\.ico|\.inc|\.ini|\.sql|\.pdf|\.dat|\.doc|\.xls|\.htaccess|\.ftpquota');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('13', 'max_html_file_size', '1048576');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('14', 'max_images_file_size', '2097152');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('15', 'twoCheckout_account_number', '61909');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('16', 'business_email', 'paypal@xpanel.de');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('17', 'default_currency_code', 'USD');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('18', 'default_currency_symbol', '$');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('19', 'invoice_generation', '15');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('20', 'first_advance_notification', '10');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('21', 'second_advance_notification', '7');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('22', 'third_advance_notification', '5');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('23', 'last_advance_notification', '1');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('24', 'redemption_period', '15');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('25', 'unconfirm_time_out', '2');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('26', 'secret_word', 'tango');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('27', 'default_language', 'en-US');
INSERT IGNORE INTO `XPanel`.`configuration` VALUES ('28', 'delete_expired', '1');


INSERT IGNORE INTO `XPanel`.`feature` VALUES (1,'Free Hosting','1','1','apache','0');
INSERT IGNORE INTO `XPanel`.`feature` VALUES (2,'Paid Hosting','1','1','fast_cgi','1');

INSERT IGNORE INTO `XPanel`.`package` VALUES ('1', '1', 'Free Hosting', 'Free Hosting Plan', '0', '1', '0.00', '0.00', '0.00', '0.00', '0.00', '1', '5', '5', '50', '1', '10', '1', '1', '1', '50');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('2', '2', 'Personal Minimum', 'Personal Minimum Hosting Plan', '0', '0', '1.00', '2.90', '5.70', '10.80', '21.60', '1', '1', '1', '50', '1', '5', '5', '1', '1', '100');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('3', '2', 'Personal Standard', 'Personal Standard Hosting Plan', '0', '0', '2.00', '5.90', '11.40', '21.60', '43.20', '2', '2', '2', '100', '2', '5', '10', '2', '2', '100');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('4', '2', 'Personal Plus', 'Personal Plus Hosting Plan', '0', '0', '3.00', '8.80', '17.10', '32.40', '64.80', '3', '3', '3', '150', '3', '5', '15', '3', '3', '100');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('5', '2', 'Small Business', 'Small Business Hosting Plan', '0', '0', '4.00', '11.80', '22.80', '43.20', '86.40', '4', '4', '4', '200', '4', '5', '20', '4', '4', '100');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('6', '2', 'Medium Business', 'Medium Business Hosting Plan', '0', '0', '5.00', '14.70', '28.50', '54.00', '108.00', '5', '5', '5', '300', '5', '5', '30', '5', '5', '150');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('7', '2', 'Large Business', 'Large Business Hosting Plan', '0', '0', '6.00', '17.60', '34.20', '64.80', '129.60', '6', '6', '6', '400', '6', '5', '40', '6', '6', '200');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('8', '2', 'Small Enterprise', 'Small Enterprise Hosting Plan', '0', '0', '7.00', '20.50', '39.90', '75.60', '151.20', '7', '7', '7', '600', '7', '5', '60', '7', '7', '300');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('9', '2', 'Medium Enterprise', 'Medium Enterprise Hosting Plan', '0', '0', '8.00', '23.50', '45.60', '86.40', '172.80', '8', '8', '8', '800', '8', '5', '80', '8', '8', '400');
INSERT IGNORE INTO `XPanel`.`package` VALUES ('10', '2', 'Large Enterprise', 'Large Enterprise Hosting Plan', '0', '0', '9.00', '26.50', '51.30', '97.20', '194.40', '9', '9', '9', '1000', '9', '5', '100', '9', '9', '500');

INSERT IGNORE INTO `XPanel`.`mailserver` VALUES (1,'123.45.67.89',NULL,'','','1');
INSERT IGNORE INTO `XPanel`.`webserver` VALUES (1,'123.45.67.89',NULL,'','','1');


INSERT IGNORE INTO mysql.user (Host, User, Password) VALUES('localhost', 'xpanel', PASSWORD('MySQL_PassWord!'));
INSERT IGNORE INTO mysql.db (Host, Db, User, Select_priv, Update_priv) VALUES ('localhost','XPanel','xpanel','Y','Y');
INSERT IGNORE INTO mysql.user VALUES ('localhost','xpanel_root',PASSWORD('MySQL_PassWord!'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
INSERT IGNORE INTO mysql.user VALUES ('123.45.67.89','xpanel_root',PASSWORD('MySQL_PassWord!'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0);
FLUSH PRIVILEGES;