Index: trunk/admin/install/inportal_schema.sql
===================================================================
diff -u -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)
 )
 # --------------------------------------------------------
