From: Michael Andreen <harv@ruin.nu>
Date: Fri, 16 Aug 2019 17:25:09 +0000 (+0200)
Subject: Quotes in database
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=8a4437b6883f7f089577a26ce16041bb5ad5eebc

Quotes in database
---

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
+);