| Index: trunk/phase3/maintenance/tables.sql |
| — | — | @@ -173,7 +173,6 @@ |
| 174 | 174 | ) /*$wgDBTableOptions*/; |
| 175 | 175 | |
| 176 | 176 | CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group); |
| 177 | | -CREATE INDEX /*i*/ufg_group ON /*_*/user_former_groups (ufg_group); |
| 178 | 177 | |
| 179 | 178 | -- |
| 180 | 179 | -- Stores notifications of user talk page changes, for the display |
| Index: trunk/phase3/maintenance/archives/patch-user_former_groups.sql |
| — | — | @@ -3,8 +3,7 @@ |
| 4 | 4 | CREATE TABLE /*_*/user_former_groups ( |
| 5 | 5 | -- Key to user_id |
| 6 | 6 | ufg_user int unsigned NOT NULL default 0, |
| 7 | | - ufg_group varbinary(16) NOT NULL default '', |
| 8 | | - |
| 9 | | - PRIMARY KEY (ufg_user,ufg_group), |
| 10 | | - KEY (ufg_group) |
| | 7 | + ufg_group varbinary(16) NOT NULL default '' |
| 11 | 8 | ) /*$wgDBTableOptions*/; |
| | 9 | + |
| | 10 | +CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group); |
| Index: trunk/phase3/maintenance/postgres/archives/patch-user_former_groups.sql |
| — | — | @@ -2,4 +2,4 @@ |
| 3 | 3 | ufg_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
| 4 | 4 | ufg_group TEXT NOT NULL |
| 5 | 5 | ); |
| 6 | | -CREATE UNIQUE INDEX user_former_groups_unique ON user_former_groups (ufg_user, ufg_group); |
| | 6 | +CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group); |
| Index: trunk/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -58,7 +58,7 @@ |
| 59 | 59 | ufg_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |
| 60 | 60 | ufg_group TEXT NOT NULL |
| 61 | 61 | ); |
| 62 | | -CREATE UNIQUE INDEX user_former_groups_unique ON user_former_groups (ufg_user, ufg_group); |
| | 62 | +CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group); |
| 63 | 63 | |
| 64 | 64 | CREATE TABLE user_newtalk ( |
| 65 | 65 | user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, |