summaryrefslogtreecommitdiff
path: root/dynamic/schema-comments.sql
diff options
context:
space:
mode:
Diffstat (limited to 'dynamic/schema-comments.sql')
-rw-r--r--dynamic/schema-comments.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/dynamic/schema-comments.sql b/dynamic/schema-comments.sql
index 1c690f3..b2cb652 100644
--- a/dynamic/schema-comments.sql
+++ b/dynamic/schema-comments.sql
@@ -4,9 +4,13 @@ CREATE TABLE comments(
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
+ 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!');