# alt?
#DELETE FROM configuration WHERE configuration_key='EBAY_PRODUCTS_PRICE_CUSTOMER_STATUS';
#INSERT INTO  `configuration` (`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES ('EBAY_PRODUCTS_PRICE_CUSTOMER_STATUS',  '2',  '100',  '20',  '2015-11-30 00:00:00',  '2015-11-30 00:00:00', 'xtc_get_customers_status_name' , 'xtc_cfg_pull_down_customers_status_list(');
#ALTER TABLE  `distributor_orders_products` CHANGE  `products_name`  `products_name` VARCHAR( 128 ) NOT NULL;
ALTER TABLE  `products` ADD  `disable_cron_update_products_status` INT( 1 ) NOT NULL ;
ALTER TABLE  `ebayapi_favorites` ADD  `mpn_alias` VARCHAR( 64 ) NOT NULL ,ADD  `brand_alias` VARCHAR( 64 ) NOT NULL ;
CREATE TABLE IF NOT EXISTS `ebay_mpn_aliases` (  `ebay_mpn_aliases_id` int(11) NOT NULL AUTO_INCREMENT,  `site` int(1) NOT NULL,  `mpn_alias` varchar(64) NOT NULL,is_default INT(1),  PRIMARY KEY (`ebay_mpn_aliases_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `ebay_brand_aliases` (  `ebay_brand_aliases_id` int(11) NOT NULL AUTO_INCREMENT,  `site` int(1) NOT NULL,  `brand_alias` varchar(64) NOT NULL,is_default INT(1),  PRIMARY KEY (`ebay_brand_aliases_id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
TRUNCATE ebay_brand_aliases;
INSERT INTO ebay_brand_aliases (brand_alias,site,is_default) VALUES ('Marke',77,1);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Teilehersteller/Anbieter',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller/Marke',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marke/Hersteller',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Markenhersteller',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Designer/Marke',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabrikant',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Manufacturer',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller/Anbieter',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller/ Marke',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller/Marke',77);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Hersteller des Gerätes',77);
INSERT INTO ebay_brand_aliases (brand_alias,site,is_default) VALUES ('Brand',3,1);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Manufacturer',3);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand/ Name',3);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand/Name',3);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Part Manufacturer',3);
INSERT INTO ebay_brand_aliases (brand_alias,site,is_default) VALUES ('Brand',0,1);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Manufacturer',0);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand/ Name',0);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand/Name',0);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marque',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('marca',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('marke',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('designer/brand',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('designer/marke',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('manufacteur',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('fabricant',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('producteur',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('fabriquant',71);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marchio',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabbrica',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Designer/marca',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca/brand',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca ricambio',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca del ricambio',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabbricante',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Produttore',101);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('fabricante/proveedor',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('faabricante',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('marca/brand',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca1',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca2',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Marca3',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabricante de pieza',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Diseñador/Marca',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Diseñador',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabricante de la pieza',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Fabricante/Marca',186);
INSERT INTO ebay_brand_aliases (brand_alias,site) VALUES ('Brand',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site,is_default) VALUES ('Artikelnummer',77,1);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Herstellernummer',77);
INSERT INTO ebay_mpn_aliases (mpn_alias,site,is_default) VALUES ('MPN',3,1);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturer Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturerpartnumber',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Mfr Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Interchange Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('OEM Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Mfr Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturerpartnumber',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('OEM Part Number',3);
INSERT INTO ebay_mpn_aliases (mpn_alias,site,is_default) VALUES ('MPN',0,1);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturer Part Number',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturerpartnumber',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Mfr Part Number',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Interchange Part Number',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('OEM Part Number',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Part Number',0);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Numéro de pièce fabricant',71);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('mpn',71);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Referencefabricant',71);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Numerodereference',71);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('numerodereferencefabricant',71);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('MPN',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturer Part Number (MPN)',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturer Part Number',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('P/N',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Codice articolo',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice componente del fabbricante',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice fabbricante',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice del fabbricante',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice del prodotto',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice produttore',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codice del produttore',101);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('MPN',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Manufacturer Part Number',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('mpn1',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('mpn2',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('mpn3',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Numero de Pieza del',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Fabricante',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('Numero de la Pieza del Fabricante (MPN)',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('P/N',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo fabricante',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo del fabricante',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo del producto',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo producto',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo productor',186);
INSERT INTO ebay_mpn_aliases (mpn_alias,site) VALUES ('codigo del productor',186);

ALTER TABLE  `ebay_auctions` ADD  `ebay_plus` INT(1) NOT NULL;
ALTER TABLE  `ebay_products` ADD  `ebay_plus` INT(1) NOT NULL;
ALTER TABLE  `ebay_sammler` ADD  `ebay_plus` INT(1) NOT NULL;
DELETE FROM configuration WHERE configuration_key='EBAY_PLUS';
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_PLUS',  'False',  '101',  '67',  '2016-02-22 00:00:00',  '2016-02-22 00:00:00', NULL ,  'xtc_cfg_select_option(array(''True'', ''False''),');
UPDATE  `configuration` SET  `set_function` =  'xtc_cfg_select_option(array(''ean'', ''orders'',''items''),' WHERE  configuration_key ='SHIPPING_BARCODESCAN_DEFAULTMODE';
CREATE TABLE IF NOT EXISTS `storage_places` (  `storage_places_id` int(11) NOT NULL AUTO_INCREMENT,  `storage_id` int(11) NOT NULL,  `title` varchar(64) NOT NULL,  `storage_type` int(1) NOT NULL,  `description` text NOT NULL,  PRIMARY KEY (`storage_places_id`),  KEY `storage_id` (`storage_id`)) ENGINE=MyISAM COMMENT='lagerplaetze';
ALTER TABLE  `storage_products` ADD  `storage_places_id` INT NOT NULL , ADD INDEX (  `storage_places_id` ) ;