Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -N -r642 -r811
--- trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 642)
+++ trunk/admin/install/inportal_schema.sql	(.../inportal_schema.sql)	(revision 811)
@@ -36,7 +36,7 @@
   ModifiedById int(11) NOT NULL default '0',
   PRIMARY KEY  (CategoryId),
   KEY ParentId (ParentId),
-  KEY ResourceId (ResourceId),
+  UNIQUE KEY ResourceId (ResourceId),
   KEY Modified (Modified),
   KEY Priority (Priority),
   KEY sorting (Name,Priority)
@@ -309,7 +309,7 @@
   ResourceId int(11) NOT NULL default '0',
   PRIMARY KEY  (GroupId),
   UNIQUE KEY Name (Name),
-  KEY ResourceId (ResourceId),
+  UNIQUE KEY ResourceId (ResourceId),
   KEY Personal (Personal),
   KEY Enabled (Enabled)
 )
@@ -337,7 +337,7 @@
   IsBanned tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (PortalUserId),
   UNIQUE KEY Login (Login),
-  KEY ResourceId (ResourceId),
+  UNIQUE KEY ResourceId (ResourceId),
   KEY CreatedOn (CreatedOn)
 )
 # --------------------------------------------------------
Index: trunk/admin/install/upgrades/inportal_upgrade_v1.0.10.sql
===================================================================
diff -u -N -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