Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql =================================================================== --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql (revision 1349) +++ trunk/admin/install/upgrades/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 Property changes on: trunk/admin/install/upgrades/inportal_upgrade_v1.0.11.sql ___________________________________________________________________ Modified: cvs2svn:cvs-rev ## -1 +1 ## -1.2 \ No newline at end of property +1.3 \ No newline at end of property Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql =================================================================== --- trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql (nonexistent) +++ 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 Property changes on: trunk/admin/install/upgrades/inportal_upgrade_v1.1.0.sql ___________________________________________________________________ Added: cvs2svn:cvs-rev ## -0,0 +1 ## +1.1 \ No newline at end of property Added: svn:executable ## -0,0 +1 ## +* \ No newline at end of property