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.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/dynamic/schema-comments.sql b/dynamic/schema-comments.sql
new file mode 100644
index 0000000..1c690f3
--- /dev/null
+++ b/dynamic/schema-comments.sql
@@ -0,0 +1,12 @@
+CREATE TABLE comments(
+ id SERIAL PRIMARY KEY,
+ approved TIMESTAMP,
+ submitted TIMESTAMP NOT NULL,
+ slug VARCHAR(100) NOT NULL,
+ name VARCHAR(50) NOT NULL,
+ email VARCHAR(100),
+ url VARCHAR(100),
+ comment VARCHAR(1024) NOT NULL
+);
+
+-- Use `now' for `submitted'.