UPDATE Events SET Event = REPLACE(Event, '_', '.');

ALTER TABLE ShippingBrackets CHANGE Start Start DOUBLE NOT NULL DEFAULT '0', CHANGE End End DOUBLE NOT NULL DEFAULT '0';

ALTER TABLE Affiliates ADD CreatedOn INT NOT NULL;

ALTER TABLE Products ADD Filename varchar(255) NOT NULL AFTER l10_Name;
ALTER TABLE Products ADD AutomaticFilename TINYINT UNSIGNED NOT NULL AFTER Filename ;

ALTER TABLE Products ADD l1_Description TEXT AFTER Description, ADD l2_Description TEXT AFTER l1_Description, ADD l3_Description TEXT AFTER l2_Description, ADD l4_Description TEXT AFTER l3_Description, ADD l5_Description TEXT AFTER l4_Description;
ALTER TABLE Products ADD l1_DescriptionExcerpt TEXT AFTER DescriptionExcerpt, ADD l2_DescriptionExcerpt TEXT AFTER l1_DescriptionExcerpt, ADD l3_DescriptionExcerpt TEXT AFTER l2_DescriptionExcerpt, ADD l4_DescriptionExcerpt TEXT AFTER l3_DescriptionExcerpt, ADD l5_DescriptionExcerpt TEXT AFTER l4_DescriptionExcerpt;

UPDATE Modules SET Version = '1.0.3' WHERE Name = 'In-Commerce';