[Summary view] [Print] [Text view]

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