1 files changed, 16 insertions, 0 deletions
diff --git a/haunt/jakob/dynamic/schema-comments.sql b/haunt/jakob/dynamic/schema-comments.sql
new file mode 100644
index 0000000..b2cb652
--- /dev/null
+++ b/haunt/jakob/dynamic/schema-comments.sql
@@ -0,0 +1,16 @@
+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)
+);
+
+-- Use `now' for `submitted'.
+
+-- INSERT INTO comments (submitted, slug, name, comment) VALUES (now(), 'test', 'Jakob', 'Hello, world!');