Quotes in database

[ndwebbie.git] / database / quotes.sql

diff --git a/database/quotes.sql b/database/quotes.sql
new file mode 100644 (file)
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
+);