diff options
Diffstat (limited to 'maintenance/postgres/archives/patch-user_former_groups.sql')
-rw-r--r-- | maintenance/postgres/archives/patch-user_former_groups.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/maintenance/postgres/archives/patch-user_former_groups.sql b/maintenance/postgres/archives/patch-user_former_groups.sql new file mode 100644 index 00000000..1ba011e3 --- /dev/null +++ b/maintenance/postgres/archives/patch-user_former_groups.sql @@ -0,0 +1,5 @@ +CREATE TABLE user_former_groups ( + ufg_user INTEGER NULL REFERENCES mwuser(user_id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, + ufg_group TEXT NOT NULL +); +CREATE UNIQUE INDEX ufg_user_group ON user_former_groups (ufg_user, ufg_group); |