ALTER TABLE `shippings` ADD `email_send_status` INT( 1 ) NOT NULL ;
ALTER TABLE  `ebay_auth` ADD  `ebay_store_name` VARCHAR( 128 ) NOT NULL ;
DELETE FROM configuration WHERE configuration_key='ORDERS_CREDIT_PRODUCTS_ID';
INSERT INTO  `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function`)VALUES (NULL ,  'ORDERS_CREDIT_PRODUCTS_ID',  '0',  '102',  '50',  '2014-09-09 00:00:00',  '2014-09-09 00:00:00', NULL , NULL);
CREATE TABLE IF NOT EXISTS `yes_xmlrpc_import_config` (  `yes_xmlrpc_import_config_id` int(11) NOT NULL AUTO_INCREMENT,  `yes_xmlrpc_remote_token_id` int(11) NOT NULL,  `languages` text NOT NULL,  `manufacturers` text NOT NULL,  `import_categories_id` int(11) NOT NULL,  PRIMARY KEY (`yes_xmlrpc_import_config_id`),  KEY `yes_xmlrpc_token_id` (`yes_xmlrpc_remote_token_id`)) ENGINE=InnoDB;
ALTER TABLE  `yes_xmlrpc_import_config` ADD  `shipping_statuses` TEXT NOT NULL ;
ALTER TABLE `yes_xmlrpc_import_config` ADD `units` TEXT NOT NULL ;
ALTER TABLE `yes_xmlrpc_import_config` ADD `products_vpe` TEXT NOT NULL ;
ALTER TABLE  `admin_access` ADD  `amazon_export` INT( 1 ) NOT NULL ;
UPDATE admin_access SET amazon_export =1 WHERE customers_id =1;
ALTER TABLE  `admin_access` ADD  `yes_xmlrpc` INT( 1 ) NOT NULL ;
UPDATE admin_access SET yes_xmlrpc =1 WHERE customers_id =1;
ALTER TABLE  `distributors` ADD  `nmedia_id` VARCHAR( 8 ) NOT NULL ;
ALTER TABLE  `categories` ADD  `categories_additional_image` VARCHAR( 64 ) NOT NULL ;
ALTER TABLE  `manufacturers` ADD  `nmedia_id` VARCHAR( 8 ) NOT NULL ;

DROP TABLE IF EXISTS `yes_xmlrpc_products`;
CREATE TABLE IF NOT EXISTS `yes_xmlrpc_products` (  `yes_xmlrpc_products_id` int(11) NOT NULL AUTO_INCREMENT,  `yes_xmlrpc_remote_token_id` int(11) NOT NULL,  `products_id` int(11) NOT NULL,  `remote_products_id` int(11) NOT NULL,  `date_added` datetime NOT NULL,  PRIMARY KEY (`yes_xmlrpc_products_id`),  KEY `yes_xmlrpc_remote_token_id` (`yes_xmlrpc_remote_token_id`)) ENGINE=InnoDB;
ALTER TABLE `yes_xmlrpc_products` ADD `imported` INT( 1 ) NOT NULL ;
ALTER TABLE `yes_xmlrpc_products` ADD `remote_set_id` VARCHAR( 32 ) NOT NULL;
DROP TABLE IF EXISTS `yes_xmlrpc_remote_token`;
CREATE TABLE `yes_xmlrpc_remote_token` (`yes_xmlrpc_remote_token_id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`token` VARCHAR( 32 ) NOT NULL ,`token_alias` VARCHAR( 32 ) NOT NULL ,`server` VARCHAR( 255 ) NOT NULL ,`server_path` VARCHAR( 255 ) NOT NULL ,`server_image_path` VARCHAR( 255 ) NOT NULL ,`date_added` DATETIME NOT NULL ) ENGINE = MYISAM;


CREATE TABLE IF NOT EXISTS `yes_xmlrpc_token` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `token` varchar(32) NOT NULL,  `token_alias` varchar(32) NOT NULL,  `date_added` datetime NOT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB;
ALTER TABLE  `yes_xmlrpc_token` ADD  `allowed_functions` TEXT NOT NULL ;

DELETE FROM configuration WHERE configuration_key='MARGENRECHNER_FIXKOSTEN_PERCENT';
INSERT INTO `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function` )VALUES (NULL , 'MARGENRECHNER_FIXKOSTEN_PERCENT', '0', '3', '100', NULL , '2014-08-07 00:00:00', NULL , NULL );
DELETE FROM configuration WHERE configuration_key='MARGENRECHNER_AMAZONFEE_PERCENT';
INSERT INTO `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function` )VALUES (NULL , 'MARGENRECHNER_AMAZONFEE_PERCENT', '0', '3', '101', NULL , '2014-08-07 00:00:00', NULL , NULL );
DELETE FROM configuration WHERE configuration_key='MARGENRECHNER_EBAYFEE_PERCENT';
INSERT INTO `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function` )VALUES (NULL , 'MARGENRECHNER_EBAYFEE_PERCENT', '0', '3', '102', NULL , '2014-08-07 00:00:00', NULL , NULL );