diff options
Diffstat (limited to 'src/main/resources/schema-sqlite.sql')
| -rw-r--r-- | src/main/resources/schema-sqlite.sql | 10 |
1 files changed, 3 insertions, 7 deletions
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql index bffd38d2..ea9ffe36 100644 --- a/src/main/resources/schema-sqlite.sql +++ b/src/main/resources/schema-sqlite.sql @@ -99,6 +99,9 @@ CREATE TABLE messages ( hidden smallint DEFAULT (0) NOT NULL, likes smallint DEFAULT (0) NOT NULL, updated DEFAULT (strftime('%s','now') || substr(strftime('%f','now'),4)) NOT NULL, + repliesby text, + txt text NOT NULL, + updated_at DEFAULT (strftime('%s','now') || substr(strftime('%f','now'),4)) NOT NULL, FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE messages_access ( @@ -120,13 +123,6 @@ CREATE TABLE messages_tags ( tag_id bigint NOT NULL, FOREIGN KEY (message_id) REFERENCES messages(message_id) ); -CREATE TABLE messages_txt ( - message_id INTEGER NOT NULL, - repliesby text, - txt text NOT NULL, - updated_at DEFAULT (strftime('%s','now') || substr(strftime('%f','now'),4)) NOT NULL, - FOREIGN KEY (message_id) REFERENCES messages(message_id) -); CREATE TABLE places ( place_id INTEGER PRIMARY KEY NOT NULL, lat numeric(10,7) NOT NULL, |