www/wiki/maintenance/sqlite/archives/patch-user_former_groups-fix-pk.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

CREATE TABLE /*_*/user_former_groups_tmp (
  -- Key to user_id
  ufg_user int unsigned NOT NULL default 0,
  ufg_group varbinary(255) NOT NULL default '',
  PRIMARY KEY (ufg_user,ufg_group)
) /*$wgDBTableOptions*/;

INSERT INTO /*_*/user_former_groups_tmp
	SELECT * FROM /*_*/user_former_groups;

DROP TABLE /*_*/user_former_groups;

ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;