Index: branches/5.3.x/core/install/upgrades.sql =================================================================== diff -u -N -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);