maintenance/sqlite/archives/patch-ufg_group-length-increase.sql

   1 CREATE TABLE /*_*/user_former_groups_tmp (
   2   ug_user int unsigned NOT NULL default 0,
   3   ug_group varbinary(32) NOT NULL default ''
   4 ) /*$wgDBTableOptions*/;
   5
   6 INSERT INTO /*_*/user_former_groups_tmp
   7         SELECT ug_user, ug_group
   8                 FROM /*_*/user_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