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