1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
"""
Create group_requests table
"""
from yoyo import step
__depends__ = {'20230116_01_KwuJ3-rework-privileges-schema'}
steps = [
step(
"""
CREATE TABLE IF NOT EXISTS group_join_requests(
request_id TEXT NOT NULL,
group_id TEXT NOT NULL,
requester_id TEXT NOT NULL,
timestamp REAL NOT NULL,
status TEXT NOT NULL DEFAULT 'PENDING',
message TEXT,
PRIMARY KEY(request_id, group_id),
FOREIGN KEY(group_id) REFERENCES groups(group_id)
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
""",
"DROP TABLE IF EXISTS group_join_requests")
]
|
