http://www.mediawiki.org/wiki/Special:Code/MediaWiki/90753
Revision: 90753
Author: aaron
Date: 2011-06-25 04:11:20 +0000 (Sat, 25 Jun 2011)
Log Message:
-----------
Follow-up r90749:
* Removed useless ufg_group index from user_former_groups
* Index name consistency
Modified Paths:
--------------
trunk/phase3/maintenance/archives/patch-user_former_groups.sql
trunk/phase3/maintenance/postgres/archives/patch-user_former_groups.sql
trunk/phase3/maintenance/postgres/tables.sql
trunk/phase3/maintenance/tables.sql
Modified: trunk/phase3/maintenance/archives/patch-user_former_groups.sql
===================================================================
--- trunk/phase3/maintenance/archives/patch-user_former_groups.sql
2011-06-25 03:59:24 UTC (rev 90752)
+++ trunk/phase3/maintenance/archives/patch-user_former_groups.sql
2011-06-25 04:11:20 UTC (rev 90753)
@@ -3,8 +3,7 @@
CREATE TABLE /*_*/user_former_groups (
-- Key to user_id
ufg_user int unsigned NOT NULL default 0,
- ufg_group varbinary(16) NOT NULL default '',
-
- PRIMARY KEY (ufg_user,ufg_group),
- KEY (ufg_group)
+ ufg_group varbinary(16) NOT NULL default ''
) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups
(ufg_user,ufg_group);
Modified:
trunk/phase3/maintenance/postgres/archives/patch-user_former_groups.sql
===================================================================
--- trunk/phase3/maintenance/postgres/archives/patch-user_former_groups.sql
2011-06-25 03:59:24 UTC (rev 90752)
+++ trunk/phase3/maintenance/postgres/archives/patch-user_former_groups.sql
2011-06-25 04:11:20 UTC (rev 90753)
@@ -2,4 +2,4 @@
ufg_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE
DEFERRABLE INITIALLY DEFERRED,
ufg_group TEXT NOT NULL
);
-CREATE UNIQUE INDEX user_former_groups_unique ON user_former_groups (ufg_user,
ufg_group);
+CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group);
Modified: trunk/phase3/maintenance/postgres/tables.sql
===================================================================
--- trunk/phase3/maintenance/postgres/tables.sql 2011-06-25 03:59:24 UTC
(rev 90752)
+++ trunk/phase3/maintenance/postgres/tables.sql 2011-06-25 04:11:20 UTC
(rev 90753)
@@ -58,7 +58,7 @@
ufg_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE
DEFERRABLE INITIALLY DEFERRED,
ufg_group TEXT NOT NULL
);
-CREATE UNIQUE INDEX user_former_groups_unique ON user_former_groups (ufg_user,
ufg_group);
+CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group);
CREATE TABLE user_newtalk (
user_id INTEGER NOT NULL REFERENCES mwuser(user_id) ON
DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
Modified: trunk/phase3/maintenance/tables.sql
===================================================================
--- trunk/phase3/maintenance/tables.sql 2011-06-25 03:59:24 UTC (rev 90752)
+++ trunk/phase3/maintenance/tables.sql 2011-06-25 04:11:20 UTC (rev 90753)
@@ -173,7 +173,6 @@
) /*$wgDBTableOptions*/;
CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups
(ufg_user,ufg_group);
-CREATE INDEX /*i*/ufg_group ON /*_*/user_former_groups (ufg_group);
--
-- Stores notifications of user talk page changes, for the display
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
