summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-user_former_groups.sql
blob: ed18b2b6626e71ff7eb4f87cf0d9a309ddba9b1e (plain)
1
2
3
4
5
6
7
8
9
-- Stores the groups the user has once belonged to. 
-- The user may still belong these groups. Check user_groups.
CREATE TABLE /*_*/user_former_groups (
  -- Key to user_id
  ufg_user int unsigned NOT NULL default 0,
  ufg_group varbinary(16) NOT NULL default ''
) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/ufg_user_group ON /*_*/user_former_groups (ufg_user,ufg_group);