migrations/2017-11-03-164322_create_factoids/up.sql


1
2
3
4
5
6
7
8

CREATE TABLE factoids (
    name VARCHAR(32) NOT NULL,
    idx INTEGER NOT NULL,
    content TEXT NOT NULL,
    author VARCHAR(32) NOT NULL,
    created TIMESTAMP NOT NULL,
    PRIMARY KEY (name, idx)
)