diff options
Diffstat (limited to 'dynamic/schema-comments.sql')
| -rw-r--r-- | dynamic/schema-comments.sql | 12 |
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'. |