[Summary view] [Print] [Text view]

   1   CREATE TABLE /*_*/user_former_groups_tmp (
   2    ufg_user int unsigned NOT NULL default 0,
   3    ufg_group varbinary(255) NOT NULL default ''
   4  ) /*$wgDBTableOptions*/;
   5  
   6  INSERT INTO /*_*/user_former_groups_tmp
   7      SELECT ufg_user, ufg_group
   8          FROM /*_*/user_former_groups;
   9  
  10  DROP TABLE /*_*/user_former_groups;
  11  
  12  ALTER TABLE /*_*/user_former_groups_tmp RENAME TO /*_*/user_former_groups;
  13  
  14  CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group);
  15