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

   1 CREATE TABLE /*_*/user_former_groups_tmp (
   2   -- Key to user_id
   3   ufg_user int unsigned NOT NULL default 0,
   4   ufg_group varbinary(255) NOT NULL default '',
   5   PRIMARY KEY (ufg_user,ufg_group)
   6 ) /*$wgDBTableOptions*/;
   7
   8 INSERT INTO /*_*/user_former_groups_tmp
   9         SELECT * FROM /*_*/user_former_groups;
  10
  11 DROP TABLE /*_*/user_former_groups;
  12
  13 ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;