sqlite> .schema posts
CREATE TABLE posts (
        ip TEXT, 
        board NUMERIC, 
        thread NUMERIC, 
        post NUMERIC, 
        date NUMERIC, 
        sage NUMERIC, 
        name TEXT, 
        trip TEXT, 
        comment TEXT, 
        UNIQUE (thread,post) ON CONFLICT ROLLBACK
);
CREATE UNIQUE INDEX posts_idx on posts (thread, board, post);
sqlite> .schema threads
CREATE TABLE threads (
        ip TEXT, 
        board NUMERIC, 
        thread NUMERIC, 
        topic TEXT, 
        posts NUMERIC, 
        date_created NUMERIC, 
        date_updated NUMERIC, 
        date_nonsage NUMERIC, 
        permasage NUMERIC, 
        closed NUMERIC, 
        UNIQUE(board,thread) ON CONFLICT ROLLBACK
);
CREATE UNIQUE INDEX threads_idx on threads (thread, board);
sqlite> .schema boards
CREATE TABLE boards (
        id NUMERIC, 
        name TEXT, 
        title TEXT, 
        UNIQUE(id) ON CONFLICT ABORT
);