jakob/dynamic/schema-comments.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

CREATE TABLE comments(
    id SERIAL PRIMARY KEY,
    approved TIMESTAMP,
    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,
    reactions VARCHAR(1024),
    reply_to INT,
    originating_network VARCHAR(100)
);

-- Use `now' for `submitted'.

-- INSERT INTO comments (submitted, slug, name, comment) VALUES (now(), 'test', 'Jakob', 'Hello, world!');