dynamic/schema-comments.sql


1
2
3
4
5
6
7
8
9
10
11
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'.