Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql =================================================================== diff -u -r796 -r811 --- trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql (.../inportal_upgrade_v1.0.10.sql) (revision 796) +++ trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql (.../inportal_upgrade_v1.0.10.sql) (revision 811) @@ -1 +1,5 @@ +ALTER TABLE Category DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); +ALTER TABLE PortalGroup DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); +ALTER TABLE PortalUser DROP INDEX ResourceId, ADD UNIQUE ResourceId (ResourceId); + UPDATE Modules SET Version = '1.0.10' WHERE Name = 'In-Portal'; \ No newline at end of file