diff options
Diffstat (limited to 'migrations/auth')
| -rw-r--r-- | migrations/auth/20230207_01_r0bkZ-create-group-join-requests-table.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/migrations/auth/20230207_01_r0bkZ-create-group-join-requests-table.py b/migrations/auth/20230207_01_r0bkZ-create-group-join-requests-table.py index 6b06a64..ceae5ea 100644 --- a/migrations/auth/20230207_01_r0bkZ-create-group-join-requests-table.py +++ b/migrations/auth/20230207_01_r0bkZ-create-group-join-requests-table.py @@ -21,6 +21,7 @@ steps = [ ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (requester_id) REFERENCES users(user_id) ON UPDATE CASCADE ON DELETE CASCADE, + UNIQUE(group_id, requester_id), CHECK (status IN ('PENDING', 'ACCEPTED', 'REJECTED')) ) WITHOUT ROWID """, |