From 8a4437b6883f7f089577a26ce16041bb5ad5eebc Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 16 Aug 2019 19:25:09 +0200 Subject: [PATCH] Quotes in database --- database/quotes.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 database/quotes.sql diff --git a/database/quotes.sql b/database/quotes.sql new file mode 100644 index 0000000..9fd1de9 --- /dev/null +++ b/database/quotes.sql @@ -0,0 +1,14 @@ +CREATE TABLE IF NOT EXISTS quotes ( + qid serial PRIMARY KEY, + time timestamptz NOT NULL DEFAULT now(), + uid integer NOT NULL REFERENCES users(uid), + quote text NOT NULL +); + +CREATE TABLE IF NOT EXISTS removed_quotes ( + qid serial PRIMARY KEY, + time timestamptz NOT NULL DEFAULT now(), + uid integer NOT NULL REFERENCES users(uid), + removed_by integer NOT NULL REFERENCES users(uid), + quote text NOT NULL +); -- 2.39.2