X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fquotes.sql;fp=database%2Fquotes.sql;h=9fd1de914a7d3df3881a175371c25e4d26a86e35;hp=0000000000000000000000000000000000000000;hb=8a4437b6883f7f089577a26ce16041bb5ad5eebc;hpb=27a84187a27390a65531888c0068a11f69f6d2cf

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