From da82578b625dbe5c50d6ba228919cf7e0b585043 Mon Sep 17 00:00:00 2001 From: ubq323 Date: Wed, 9 Jun 2021 22:25:25 +0000 Subject: update db things --- apioforum/db.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'apioforum/db.py') 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(): -- cgit v1.2.3