Index: trunk/admin/install/upgrades/inportal_upgrade_v1.1.1.sql
===================================================================
diff -u -r2263 -r2280
--- trunk/admin/install/upgrades/inportal_upgrade_v1.1.1.sql	(.../inportal_upgrade_v1.1.1.sql)	(revision 2263)
+++ trunk/admin/install/upgrades/inportal_upgrade_v1.1.1.sql	(.../inportal_upgrade_v1.1.1.sql)	(revision 2280)
@@ -34,4 +34,13 @@
 ALTER TABLE UserGroup ADD MembershipExpires INT UNSIGNED DEFAULT NULL AFTER GroupId;
 ALTER TABLE PersistantSessionData ADD PRIMARY KEY (PortalUserId, VariableName);
 
+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);
+
+DELETE FROM SessionData WHERE 1;
+ALTER TABLE SessionData ADD PRIMARY KEY (SessionKey, VariableName);
+
 UPDATE Modules SET Version = '1.1.1' WHERE Name = 'In-Portal';
\ No newline at end of file
