]> scripts.mit.edu Git - autoinstallsdev/mediawiki.git/blob - maintenance/postgres/archives/patch-user_former_groups.sql
MediaWiki 1.30.2
[autoinstallsdev/mediawiki.git] / maintenance / postgres / archives / patch-user_former_groups.sql
1 CREATE TABLE user_former_groups (
2   ufg_user   INTEGER      NULL  REFERENCES mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
3   ufg_group  TEXT     NOT NULL
4 );
5 CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group);