inportal_upgrade_v1.0.1.sql
No OneTemporary
Actions

Subscribers

None

File Metadata

Created: Thu, Oct 29, 7:23 AM

inportal_upgrade_v1.0.1.sql
View Options

	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';

inportal_upgrade_v1.0.1.sqlNo OneTemporaryActions

File Metadata

inportal_upgrade_v1.0.1.sqlView Options

Event Timeline

inportal_upgrade_v1.0.1.sql
No OneTemporary
Actions

inportal_upgrade_v1.0.1.sql
View Options