Index: branches/5.3.x/core/install/install_schema.sql
===================================================================
diff -u -N -r15956 -r15986
--- branches/5.3.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 15956)
+++ branches/5.3.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 15986)
@@ -407,11 +407,13 @@
 );
 
 CREATE TABLE UserGroupRelations (
+  Id int(11) NOT NULL auto_increment,
   PortalUserId int(11) NOT NULL DEFAULT '0',
   GroupId int(11) NOT NULL DEFAULT '0',
   MembershipExpires int(10) unsigned DEFAULT NULL,
   ExpirationReminderSent tinyint(4) NOT NULL DEFAULT '0',
-  PRIMARY KEY (PortalUserId,GroupId),
+  PRIMARY KEY (Id),
+  UNIQUE KEY UserGroup (PortalUserId,GroupId),
   KEY GroupId (GroupId),
   KEY MembershipExpires (MembershipExpires),
   KEY ExpirationReminderSent (ExpirationReminderSent)
@@ -636,11 +638,13 @@
 );
 
 CREATE TABLE CategoryItems (
+  Id int(11) NOT NULL auto_increment,
   CategoryId int(11) NOT NULL default '0',
   ItemResourceId int(11) NOT NULL default '0',
   PrimaryCat tinyint(4) NOT NULL default '0',
   ItemPrefix varchar(50) NOT NULL default '',
   Filename varchar(255) NOT NULL default '',
+  PRIMARY KEY (Id),
   UNIQUE KEY CategoryId (CategoryId,ItemResourceId),
   KEY PrimaryCat (PrimaryCat),
   KEY ItemPrefix (ItemPrefix),
@@ -1052,11 +1056,13 @@
 );
 
 CREATE TABLE SpamControl (
+  Id int(11) NOT NULL auto_increment,
   ItemResourceId int(11) NOT NULL default '0',
   IPaddress varchar(20) NOT NULL default '',
   Expire INT UNSIGNED NULL DEFAULT NULL,
   PortalUserId int(11) NOT NULL default '0',
   DataType varchar(20) default NULL,
+  PRIMARY KEY (Id),
   KEY PortalUserId (PortalUserId),
   KEY Expire (Expire),
   KEY DataType (DataType),
