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

   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