diff options
Diffstat (limited to 'www/wiki/maintenance/archives/patch-user_groups-primary-key.sql')
-rw-r--r-- | www/wiki/maintenance/archives/patch-user_groups-primary-key.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/www/wiki/maintenance/archives/patch-user_groups-primary-key.sql b/www/wiki/maintenance/archives/patch-user_groups-primary-key.sql new file mode 100644 index 00000000..e3c87356 --- /dev/null +++ b/www/wiki/maintenance/archives/patch-user_groups-primary-key.sql @@ -0,0 +1,5 @@ +-- Convert unique index into a primary key on user_groups + +ALTER TABLE /*$wgDBprefix*/user_groups + DROP INDEX ug_user_group, + ADD PRIMARY KEY (ug_user, ug_group); |