Index: branches/5.3.x/core/install/upgrades.sql
===================================================================
diff -u -r15963 -r15986
--- branches/5.3.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15963)
+++ branches/5.3.x/core/install/upgrades.sql (.../upgrades.sql) (revision 15986)
@@ -2989,3 +2989,8 @@
l<%PRIMARY_LANGUAGE%>_PlainTextBody = REPLACE(l<%PRIMARY_LANGUAGE%>_PlainTextBody, '', ''),
l<%PRIMARY_LANGUAGE%>_HtmlBody = REPLACE(l<%PRIMARY_LANGUAGE%>_HtmlBody, '', '')
WHERE TemplateName IN ('USER.SUBSCRIBE', 'USER.UNSUBSCRIBE');
+
+ALTER TABLE CategoryItems ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);
+ALTER TABLE UserGroupRelations DROP PRIMARY KEY;
+ALTER TABLE UserGroupRelations ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id), ADD UNIQUE KEY UserGroup (PortalUserId, GroupId);
+ALTER TABLE SpamControl ADD Id int(11) NOT NULL auto_increment FIRST, ADD PRIMARY KEY (Id);