ALTER TABLE Orders ADD OrderIP VARCHAR(30) NOT NULL AFTER PortalUserId;
ALTER TABLE Products ADD Virtual TINYINT DEFAULT '0' NOT NULL;
ALTER TABLE Products ADD ProcessingData TEXT;

DELETE FROM StylesheetSelectors WHERE StylesheetId = 1 AND SelectorName LIKE '.calendar%';

INSERT INTO StylesheetSelectors VALUES (162, 1, 'Calendar''s top and bottom titles', '.calendar .title', 'a:0:{}', '', 1, 'color: #00309C;\r\nbackground-color: #98CEE4;\r\nborder: 1px solid #83B2C5;\r\nborder-top: 0px;\r\npadding: 1px;', 0);
INSERT INTO StylesheetSelectors VALUES (163, 1, 'Calendar''s control buttons', '.calendar .calendar_button', 'a:0:{}', '', 1, 'color: black;\r\nfont-size: 12px;\r\nbackground-color: #eeeeee;', 0);
INSERT INTO StylesheetSelectors VALUES (164, 1, 'Calendar''s day names', '.calendar thead .name', 'a:0:{}', '', 1, 'background-color: #DEEEF6;\r\nborder-bottom: 1px solid #000000;', 0);
INSERT INTO StylesheetSelectors VALUES (165, 1, 'Calendar''s days', '.calendar tbody .day', 'a:0:{}', '', 1, 'text-align: right;\r\npadding: 2px 4px 2px 2px;\r\nwidth: 2em;\r\nborder: 1px solid #fefefe;', 0);
INSERT INTO StylesheetSelectors VALUES (166, 1, 'Calendar''s weekends', '.calendar .weekend', 'a:0:{}', '', 1, 'color: #990000;', 0);
INSERT INTO StylesheetSelectors VALUES (167, 1, 'Calendar''s selected days', '.calendar tbody .selected', 'a:0:{}', '', 1, 'font-weight: bold;\r\nbackground-color: #9ED7ED;\r\nborder: 1px solid #83B2C5;', 0);
INSERT INTO StylesheetSelectors VALUES (168, 1, 'Calendar''s highlighted day', '.calendar tbody .hilite', 'a:0:{}', '', 1, 'background-color: #f6f6f6;\r\nborder: 1px solid #83B2C5 !important;', 0);

UPDATE SearchConfig SET DisplayName = 'lu_field_newproduct' WHERE FieldName = 'NewItem' AND TableName = 'Products';
UPDATE SearchConfig SET DisplayName = 'lu_field_prod_popproduct' WHERE FieldName = 'PopItem' AND TableName = 'Products';

ALTER TABLE ProductsPricing DROP UnitsLimit;
ALTER TABLE ProductsPricing ADD AccessDuration INT NOT NULL AFTER Points, ADD AccessUnit INT NOT NULL AFTER AccessDuration;

ALTER TABLE OrderItems ADD ItemData TEXT;

UPDATE Modules SET Version = '1.0.1', LoadOrder = 4 WHERE Name = 'In-Commerce';