aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorubq323 <ubq323>2021-06-18 16:18:46 +0000
committerubq323 <ubq323>2021-06-18 16:18:46 +0000
commitb55dbbe2d2996c1c9e4e026766511944e83721e5 (patch)
treec5af27c990991da88e73ecdcd226cd8c9c99cc09
parent8ec18ae1d985aee2bcf146c1e4f783b91643406a (diff)
create admin column
-rw-r--r--apioforum/db.py2
1 files changed, 2 insertions, 0 deletions
diff --git a/apioforum/db.py b/apioforum/db.py
index 1d7bd2b..e1e8fa3 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -78,6 +78,8 @@ CREATE TABLE thread_tags (
tag INTEGER NOT NULL REFERENCES tags(id)
);
""",
+"""CREATE INDEX thread_tags_thread ON thread_tags (thread);""",
+"""ALTER TABLE users ADD COLUMN admin INT NOT NULL DEFAULT 0""",
]
def init_db():