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); UPDATE Modules SET Version = '1.1.0' WHERE Name = 'In-Portal';