ALTER TABLE  `orders` ADD  `delivery_telephone` VARCHAR( 64 ) NOT NULL AFTER  `delivery_address_format_id` ;
ALTER TABLE  `products_google_feed_data` CHANGE  `availability`  `availability` VARCHAR( 32 ) NOT NULL ;
ALTER TABLE  `orders` ADD  `delivery_email_address` VARCHAR( 255 ) NOT NULL AFTER  `delivery_address_format_id` ;
CREATE TABLE IF NOT EXISTS `ebay_seller_profiles` (  `ebay_seller_profiles_id` int(11) NOT NULL AUTO_INCREMENT,  `ebay_user` varchar(64) NOT NULL,  `ProfileType` varchar(16) NOT NULL,  `ProfileID` varchar(32) NOT NULL,  `ProfileName` varchar(64) NOT NULL,  `ShortSummary` text NOT NULL,  PRIMARY KEY (`ebay_seller_profiles_id`));
ALTER TABLE ebay_products ADD seller_profile_payment_id VARCHAR(32) NOT NULL;
ALTER TABLE ebay_auctions ADD seller_profile_payment_id VARCHAR(32);
ALTER TABLE ebay_sammler ADD seller_profile_payment_id VARCHAR(32);
ALTER TABLE ebay_sammler_copy ADD seller_profile_payment_id VARCHAR(32);
INSERT INTO configuration SET configuration_key='EBAY_SELLER_PROFILE_PAYMENT_ID', configuration_value='', configuration_group_id='101',sort_order='25',last_modified='now()',date_added='now()',set_function='xtc_cfg_pull_down_ebay_seller_profile_payment_id(';

ALTER TABLE ebay_products ADD seller_profile_return_policy_id VARCHAR(32);
ALTER TABLE ebay_auctions ADD seller_profile_return_policy_id VARCHAR(32);
ALTER TABLE ebay_sammler ADD seller_profile_return_policy_id VARCHAR(32);
ALTER TABLE ebay_sammler_copy ADD seller_profile_return_policy_id VARCHAR(32);
INSERT INTO configuration SET configuration_key='EBAY_SELLER_PROFILE_RETURN_POLICY_ID', configuration_value='', configuration_group_id='101',sort_order='25',last_modified='now()',date_added='now()',set_function='xtc_cfg_pull_down_ebay_seller_profile_return_policy_id(';

ALTER TABLE ebay_products ADD seller_profile_shipping_id VARCHAR(32);
ALTER TABLE ebay_auctions ADD seller_profile_shipping_id VARCHAR(32);
ALTER TABLE ebay_sammler ADD seller_profile_shipping_id VARCHAR(32);
ALTER TABLE ebay_sammler_copy ADD seller_profile_shipping_id VARCHAR(32);
INSERT INTO configuration SET configuration_key='EBAY_SELLER_PROFILE_SHIPPING_ID', configuration_value='', configuration_group_id='101',sort_order='25',last_modified='now()',date_added='now()',set_function='xtc_cfg_pull_down_ebay_seller_profile_shipping_id(';

ALTER TABLE orders ADD ebay_plus INT(1);
UPDATE orders SET ebay_plus=1 WHERE shipping_class='EbayPlus';

