ALTER TABLE  `products` ADD  `mpn` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE `ebay_shippingmethods` ADD `site` INT NOT NULL;
UPDATE ebay_shippingmethods SET site=77 WHERE 1;
ALTER TABLE  `products` ADD  `packagings_id` INT NOT NULL ,ADD INDEX (  `packagings_id` ) ;
ALTER TABLE  `admin_access` ADD  `packagings` INT( 1 ) NOT NULL ;
UPDATE admin_access SET packagings=1, products_conditions=1 WHERE customers_id=1;
CREATE TABLE IF NOT EXISTS `packagings` (  `packagings_id` int(11) NOT NULL AUTO_INCREMENT,  `title` varchar(64) NOT NULL,  `weight` decimal(15,4) NOT NULL,  `date_added` datetime NOT NULL,  PRIMARY KEY (`packagings_id`)) ENGINE=InnoDB;
ALTER TABLE  `shippings` ADD  `additional_params` VARCHAR( 255 ) NOT NULL ;
CREATE TABLE IF NOT EXISTS `customers_email_aliases` (  `customers_email_aliases_id` int(11) NOT NULL AUTO_INCREMENT,  `customers_id` int(11) NOT NULL,  `email_address` varchar(255) NOT NULL,  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,  PRIMARY KEY (`customers_email_aliases_id`),  KEY `customers_id` (`customers_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='alternative emailadressen zu kunden';
ALTER TABLE `products` ADD `products_weight_netto` DECIMAL( 12, 4 ) NOT NULL ;
CREATE TABLE `tags_products` (`tags_products_id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,`tags_id` INT NOT NULL ,`products_id` INT NOT NULL ,INDEX ( `tags_id` , `products_id` ) ) ENGINE = MYISAM;
CREATE TABLE IF NOT EXISTS `tags` (  `tags_id` int(11) NOT NULL AUTO_INCREMENT,  `tag` varchar(64) NOT NULL,  `date_added` datetime NOT NULL,  `editor_id` int(11) NOT NULL,  PRIMARY KEY (`tags_id`)) ENGINE=InnoDB;
ALTER TABLE  `tags` ADD  `type` VARCHAR( 8 ) NOT NULL ,ADD INDEX (  `type` ) ;
ALTER TABLE  `distributor_contacts` ADD  `contact_gender` ENUM(  'm',  'f' ) NOT NULL DEFAULT  'm';
ALTER TABLE  `distributor_contacts` ADD  `contact_skype` VARCHAR( 255 ) NOT NULL ;
DELETE FROM configuration WHERE configuration_key IN('EBAY_FEATURE_OUTOFSTOCK');
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'EBAY_FEATURE_OUTOFSTOCK',  'False',  '100',  '100',  '2015-08-02 00:00:00',  '2015-08-02 00:00:00', NULL ,  'xtc_cfg_select_option(array(''True'', ''False''),');
ALTER TABLE  `hartje_products` ADD  `image_imported` INT(1) NOT NULL;
ALTER TABLE `products` ADD `products_conditions_id` INT(11) NOT NULL;
CREATE TABLE IF NOT EXISTS `products_conditions_description` (  `products_conditions_description_id` int(11) NOT NULL AUTO_INCREMENT,  `products_conditions_id` int(11) NOT NULL,  `title` varchar(32) NOT NULL,  `language_id` int(1) NOT NULL,  PRIMARY KEY (`products_conditions_description_id`),  KEY `products_conditions_id` (`products_conditions_id`)) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS `products_conditions` (  `products_conditions_id` int(11) NOT NULL AUTO_INCREMENT,`date_added` datetime NOT NULL,  PRIMARY KEY (`products_conditions_id`)) ENGINE=InnoDB;
ALTER TABLE  `admin_access` ADD  `products_conditions` INT( 1 ) NOT NULL ;
DELETE FROM configuration WHERE configuration_key='NEWSLETTER_SUBSCRIPTION_COUPON';
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'NEWSLETTER_SUBSCRIPTION_COUPON',  '',  '12',  '50',  '2015-07-08 00:00:00',  '2015-07-08 00:00:00', NULL , NULL);
CREATE TABLE IF NOT EXISTS `ebay_import_variations_images` (  `ebay_import_variations_images_id` int(11) NOT NULL AUTO_INCREMENT,  `ebay_url` varchar(255) NOT NULL,  `yes_pic_name` varchar(255) NOT NULL,  `ebay_id` varchar(32) NOT NULL,  PRIMARY KEY (`ebay_import_variations_images_id`)) ENGINE=InnoDB;
DELETE FROM configuration WHERE configuration_key IN('DISTRIBUTOR_ORDER_PRODUCTS_DISTRIBUTOR_PRICES_AUTOMATIC_INSERT');
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'DISTRIBUTOR_ORDER_PRODUCTS_DISTRIBUTOR_PRICES_AUTOMATIC_INSERT',  'True',  '1',  '100',  '2015-07-02 00:00:00',  '2015-07-02 00:00:00', NULL ,  'xtc_cfg_select_option(array(''True'', ''False''),');
ALTER TABLE  `orders` ADD  `shipping_comments` TEXT NOT NULL ;
DELETE FROM configuration WHERE configuration_key IN('EBAY_AUCTION_IMAGE_PATH');
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'EBAY_AUCTION_IMAGE_PATH',  'popup_images',  '101',  '33',  '2015-06-26 00:00:00',  '2015-06-26 00:00:00', NULL , 'xtc_cfg_select_image_path(');