summaryrefslogtreecommitdiffhomepage
path: root/apioforum/db.py
diff options
context:
space:
mode:
authorcitrons <citrons>2021-07-18 06:11:26 +0000
committercitrons <citrons>2021-07-18 06:11:26 +0000
commit96fcef98d7bc0fd8940959077c009016aae56fd0 (patch)
tree6737a72dcbfa91cf3567865224d1bab163a3bfad /apioforum/db.py
parent338d67854d5eca63b6596fb309589755012c4ca2 (diff)
role config UI
Diffstat (limited to 'apioforum/db.py')
-rw-r--r--apioforum/db.py6
1 files changed, 6 insertions, 0 deletions
diff --git a/apioforum/db.py b/apioforum/db.py
index 5ffd5d9..d94a707 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -135,6 +135,12 @@ CREATE TABLE role_config (
INSERT INTO role_config (role,forum) VALUES ("approved",1);
INSERT INTO role_config (role,forum) VALUES ("other",1);
+""",
+"""
+CREATE TABLE role_assignments (
+ user NOT NULL REFERENCES users(username),
+ forum NOT NULL REFERENCES forums(id)
+);
"""
]