ALTER TABLE Category CHANGE CreatedOn CreatedOn INT(11) DEFAULT '0' NOT NULL , CHANGE Modified Modified INT(11) DEFAULT '0' NOT NULL;
ALTER TABLE CategoryItems DROP PRIMARY KEY;
ALTER TABLE CategoryItems ADD INDEX (CategoryId);
ALTER TABLE SessionData ADD PRIMARY KEY (SessionKey, VariableName);
ALTER TABLE SearchConfig CHANGE JoinClause JoinClause TEXT DEFAULT NULL , CHANGE ForeignField ForeignField TEXT DEFAULT NULL;
ALTER TABLE Theme ADD StylesheetId INT UNSIGNED NOT NULL ;
UPDATE Modules SET Version = '1.1.0' WHERE Name = 'In-Portal';