
ALTER TABLE  `products` DROP COLUMN  `packaging costs`;
ALTER TABLE `products` ADD `packaging_costs` FLOAT NOT NULL ;

ALTER TABLE  `products` ADD  `uvp` FLOAT NOT NULL ;

CREATE TABLE IF NOT EXISTS `nmedia_serien` (  `nmedia_serien_id` int(11) NOT NULL AUTO_INCREMENT,  `serie_nr` varchar(16) NOT NULL,  `serie` varchar(128) NOT NULL,  `serie_text` text NOT NULL,  `last_modified` datetime NOT NULL,  PRIMARY KEY (`nmedia_serien_id`),  KEY `serie_nr` (`serie_nr`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

ALTER TABLE  `manufacturers` ADD  `short_name` VARCHAR( 16 ) NOT NULL ;

ALTER TABLE  `admin_access` ADD  `nmedia` INT( 1 ) NOT NULL ;
UPDATE admin_access SET nmedia=1 WHERE customers_id='1';


ALTER TABLE `ebay_textitems` ADD `sort_order` TINYINT NOT NULL ,ADD `date_added` DATETIME NOT NULL ;
ALTER TABLE `products` ADD `packaging costs` FLOAT NOT NULL ;

DELETE FROM configuration WHERE configuration_key='MAX_ITEMS_SHIPPING_ACTION';
INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )VALUES ('', 'MAX_ITEMS_SHIPPING_ACTION', '50', '3', '99', NULL , '2014-07-08 00:00:00', NULL , '');

DELETE FROM configuration WHERE configuration_key='MAX_DISPLAY_SEARCH_RESULTS_SHIPPING';
INSERT INTO `configuration` (`configuration_id` ,`configuration_key` ,`configuration_value` ,`configuration_group_id` ,`sort_order` ,`last_modified` ,`date_added` ,`use_function` ,`set_function` )VALUES (NULL , 'MAX_DISPLAY_SEARCH_RESULTS_SHIPPING', '50', '3', '100', NULL , '2014-07-10 00:00:00', NULL , NULL );


