www/wiki/maintenance/archives/patch-user_groups-primary-key.sql


1
2
3
4
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);