Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql =================================================================== diff -u --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql (revision 0) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql (revision 1350) @@ -0,0 +1,5 @@ +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'; \ No newline at end of file Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql =================================================================== diff -u -r1349 -r1350 --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql (.../inportal_upgrade_v1.0.11.sql) (revision 1349) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql (.../inportal_upgrade_v1.0.11.sql) (revision 1350) @@ -1,6 +1,2 @@ ALTER TABLE PortalUser DROP UNIQUE PwResetConfirm; -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.0.11' WHERE Name = 'In-Portal'; \ No newline at end of file