delete from configuration  where configuration_key='ENTRY_DOB_MIN_LENGTH';
delete from configuration  where configuration_key='MAX_RANDOM_SELECT_REVIEWS';
delete from configuration  where configuration_key='MAX_RANDOM_SELECT_NEW';
delete from configuration  where configuration_key='MAX_RANDOM_SELECT_SPECIALS';
delete from configuration  where configuration_key='MAX_RANDOM_SELECT_SPECIALS';
delete from configuration  where configuration_group_id=15;
delete from configuration  where configuration_group_id=14;
delete from configuration  where configuration_group_id=13;
delete from configuration  where configuration_group_id=11;
delete from configuration  where configuration_group_id=10;

delete from configuration_group where screen_name='sessions';
delete from configuration_group where screen_name='gzip';
delete from configuration_group where screen_name='download';
delete from configuration_group where screen_name='cache';
delete from configuration_group where screen_name='logging';

ALTER TABLE `manufacturers` MODIFY COLUMN `manufacturers_image` VARCHAR(100);
ALTER TABLE `categories` MODIFY COLUMN `categories_image` VARCHAR(100);
ALTER TABLE `languages` MODIFY COLUMN `image` VARCHAR(100);
ALTER TABLE `products` MODIFY COLUMN `products_image` VARCHAR(100);

ALTER TABLE `currencies` MODIFY COLUMN `value` FLOAT(13,8) ZEROFILL DEFAULT 0;

update configuration set configuration_value = 'smtp', use_values = 'smtp' where configuration_key='EMAIL_TRANSPORT';

delete from configuration where configuration_key='SMTP_SERVER_REQUIRES_TLS';
insert into configuration (configuration_title, configuration_key, configuration_value,
	configuration_description, configuration_group_id, sort_order, date_added, set_function,
	use_values, value_type)
values ('SMTP Server Requires TLS', 'SMTP_SERVER_REQUIRES_TLS', 'true',
	'Indicates that the SMTP server used to send mails requires STARTTLS for authentication',
	12, 0, CURRENT_TIMESTAMP, 'tep_cfg_select_option(array(\'true\', \'false\'),',
	'true|false', 'E');

ALTER TABLE `payment_method` MODIFY COLUMN `payment_class` VARCHAR(100);

ALTER TABLE `orders_total_method` MODIFY COLUMN `order_total_class` VARCHAR(100);

ALTER TABLE `shipping_method` MODIFY COLUMN `shipping_class` VARCHAR(100);

update payment_method set payment_class = 'com.facecart.ecm.modules.payments.CashOnDelivery' where id=1;
update payment_method set payment_class = 'com.facecart.ecm.modules.payments.Paypal' where id=2;

update orders_total_method set order_total_class = 'com.facecart.ecm.modules.ordertotals.LowOrderFee' where id=1;
update orders_total_method set order_total_class = 'com.facecart.ecm.modules.ordertotals.Shipping' where id=2;
update orders_total_method set order_total_class = 'com.facecart.ecm.modules.ordertotals.SubTotal' where id=3;
update orders_total_method set order_total_class = 'com.facecart.ecm.modules.ordertotals.OrderTotalTax' where id=4;
update orders_total_method set order_total_class = 'com.facecart.ecm.modules.ordertotals.OrderTotal' where id=4;

update shipping_method set shipping_class = 'com.facecart.ecm.modules.shipping.FlatShipping' where id=1;
update shipping_method set shipping_class = 'com.facecart.ecm.modules.shipping.PerItemShipping' where id=2;
update shipping_method set shipping_class = 'com.facecart.ecm.modules.shipping.TableRateShipping' where id=3;