1 files changed, 18 insertions, 0 deletions
diff --git a/jakob/dynamic/schema-comments.sql b/jakob/dynamic/schema-comments.sql
new file mode 100644
index 0000000..8519f4b
--- /dev/null
+++ b/jakob/dynamic/schema-comments.sql
@@ -0,0 +1,18 @@
+CREATE TABLE comments(
+    id SERIAL PRIMARY KEY,
+    approved TIMESTAMP,
+    submitted TIMESTAMP NOT NULL,
+    slug VARCHAR(100) NOT NULL,
+    name VARCHAR(50) NOT NULL,
+    subject VARCHAR(100),
+    email VARCHAR(100),
+    url VARCHAR(100),
+    comment VARCHAR(1024) NOT NULL,
+    reactions VARCHAR(1024),
+    reply_to INT,
+    originating_network VARCHAR(100)
+);
+
+-- Use `now' for `submitted'.
+
+-- INSERT INTO comments (submitted, slug, name, comment) VALUES (now(), 'test', 'Jakob', 'Hello, world!');