summaryrefslogtreecommitdiffhomepage
path: root/apioforum/db.py
diff options
context:
space:
mode:
authorubq323 <ubq323>2021-06-09 22:25:25 +0000
committerubq323 <ubq323>2021-06-09 22:25:25 +0000
commitda82578b625dbe5c50d6ba228919cf7e0b585043 (patch)
tree2bd45d2502dbc1ad52cbb8869e065efc0119b2eb /apioforum/db.py
parentb85a4e185a9ca96b5b6f0f492326e556e0d63040 (diff)
update db things
Diffstat (limited to 'apioforum/db.py')
-rw-r--r--apioforum/db.py4
1 files changed, 4 insertions, 0 deletions
diff --git a/apioforum/db.py b/apioforum/db.py
index 9db27db..b138aae 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -42,6 +42,10 @@ CREATE TABLE posts (
CREATE INDEX posts_thread_idx ON posts (thread);
""",
+"""
+ALTER TABLE posts ADD COLUMN edited INT NOT NULL DEFAULT 0;
+ALTER TABLE posts ADD COLUMN updated TIMESTAMP;
+""",
]
def init_db():