CREATE TABLE IF NOT EXISTS `products_fake_sets` (  `products_fake_sets_id` int(11) NOT NULL AUTO_INCREMENT,  `products_id` int(11) NOT NULL,  `artnr_1` varchar(64) NOT NULL,  `artnr_2` varchar(64) NOT NULL,  `artnr_3` varchar(64) NOT NULL,  `artnr_4` varchar(64) NOT NULL,  `artnr_5` varchar(64) NOT NULL,  `qty_1` int(11) NOT NULL,  `qty_2` int(11) NOT NULL,  `qty_3` int(11) NOT NULL,  `qty_4` int(11) NOT NULL,  `qty_5` int(11) NOT NULL,  PRIMARY KEY (`products_fake_sets_id`),  KEY `products_id` (`products_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `amz_products_excluded` (  `amz_products_excluded_id` int(11) NOT NULL AUTO_INCREMENT,  `products_id` int(11) NOT NULL,  PRIMARY KEY (`amz_products_excluded_id`)) ENGINE=MyISAM;
CREATE TABLE IF NOT EXISTS `amz_transactions` (  `amz_tx_id` int(11) NOT NULL AUTO_INCREMENT,  `amz_tx_order_reference` varchar(255) CHARACTER SET latin1 COLLATE latin1_german2_ci NOT NULL,  `amz_tx_type` varchar(16) NOT NULL,  `amz_tx_time` int(11) NOT NULL,  `amz_tx_expiration` int(11) NOT NULL,  `amz_tx_amount` float NOT NULL,  `amz_tx_amount_refunded` float NOT NULL,  `amz_tx_status` varchar(32) NOT NULL,  `amz_tx_reference` varchar(64) NOT NULL,  `amz_tx_amz_id` varchar(255) NOT NULL,  `amz_tx_last_change` int(11) NOT NULL,  `amz_tx_last_update` int(11) NOT NULL,  `amz_tx_order` int(11) NOT NULL,  `amz_tx_customer_informed` tinyint(1) NOT NULL,  `amz_tx_merchant_id` varchar(64) NOT NULL,  PRIMARY KEY (`amz_tx_id`),  UNIQUE KEY `amz_tx_amz_id` (`amz_tx_amz_id`),  KEY `amz_tx_order_reference` (`amz_tx_order_reference`),  KEY `amz_tx_type` (`amz_tx_type`)) ENGINE=MyISAM;
ALTER TABLE  `customers_status` ADD  `account_value_alert_status` INT( 1 ) NOT NULL ;
ALTER TABLE  `customers_status` ADD  `account_value_alert_limit` FLOAT( 15,4 ) NOT NULL ;
ALTER TABLE `customers` ADD `account_value_alert_notified` INT( 1 ) NOT NULL ;
DELETE FROM configuration WHERE configuration_key='SHIPPING_BARCODESCAN_DEFAULTMODE';
INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES (NULL , 'SHIPPING_ACTION_DPD_ACCOUNT_NUMBER', '', '7', '70', NULL , '2014-11-07 00:00:00', NULL , NULL ), (NULL , 'SHIPPING_BARCODESCAN_DEFAULTMODE', 'ean', '7', '100', NULL , '2015-02-03 00:00:00', NULL , "xtc_cfg_select_option(array('ean', 'orders'),");
ALTER TABLE  `admin_access` ADD  `stats_reclamations_products` INT( 1 ) NOT NULL ;
UPDATE admin_access SET stats_reclamations_products='1' WHERE customers_id='1';
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'PRODUCTS_EMAIL_NOTIFICATION_SUBJECT',  'Artikelbenachrichtigung: %s',  '12',  '60', NULL ,  '2015-01-26 00:00:00', NULL , NULL);
ALTER TABLE `admin_access` ADD `products_email_notifications` INT( 1 ) NOT NULL ;
UPDATE `admin_access` SET `products_email_notifications` = '1' WHERE CONVERT( `admin_access`.`customers_id` USING utf8 ) = '1' LIMIT 1 ;
CREATE TABLE IF NOT EXISTS `products_email_notifications` (  `products_email_notifications_id` int(11) NOT NULL AUTO_INCREMENT,  `products_id` int(11) NOT NULL,  `email_address` int(11) NOT NULL,  `customers_id` int(11) NOT NULL,  `notification_confirmed` int(1) NOT NULL,  `date_confirmation` datetime NOT NULL,  `confirmation_code` int(11) NOT NULL,  PRIMARY KEY (`products_email_notifications_id`)) ENGINE=InnoDB;
ALTER TABLE  `products_email_notifications` CHANGE  `confirmation_code`  `confirmation_code` VARCHAR( 8 ) NOT NULL ;
ALTER TABLE  `products_email_notifications` CHANGE  `email_address`  `email_address` VARCHAR( 128 ) NOT NULL ;
ALTER TABLE  `products_email_notifications` ADD  `delete_flag` INT( 1 ) NOT NULL ;
ALTER TABLE `products_email_notifications` ADD `date_added` DATETIME NOT NULL AFTER `customers_id` ;
ALTER TABLE  `customers` ADD  `account_value` DECIMAL( 10, 4 ) NOT NULL ;
ALTER TABLE  `products_characteristic` ADD  `ebay_visible` INT( 1 ) NOT NULL ;
ALTER TABLE  `groups` ADD  `ebay_visible` INT( 1 ) NOT NULL ;
CREATE TABLE IF NOT EXISTS `shippings_tracking_numbers` (  `shippings_tracking_numbers_id` int(11) NOT NULL AUTO_INCREMENT,  `shippings_id` int(11) NOT NULL,  `tracking_number` varchar(64) NOT NULL,  `date_added` datetime NOT NULL,  PRIMARY KEY (`shippings_tracking_numbers_id`),  KEY `shippings_id` (`shippings_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `ebay_variationspecificssets` ADD `variations_pictures_base` INT( 1 ) NOT NULL ;
DELETE FROM configuration WHERE configuration_key='SHIPPING_ACTION_DPD_ACCOUNT_SUFFIX';
INSERT INTO `configuration` (`configuration_id`, `configuration_key`, `configuration_value`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (NULL, 'SHIPPING_ACTION_DPD_ACCOUNT_NUMBER', '', '7', '70', NULL, '2014-11-07 00:00:00', NULL, NULL), (NULL, 'SHIPPING_ACTION_DPD_ACCOUNT_SUFFIX', '', '7', '70', NULL, '2014-11-07 00:00:00', NULL, NULL);
