-- posts
CREATE TABLE post (
    post_id     INTEGER PRIMARY KEY,   -- unique id of the post
    channel_id  VARCHAR(512) NOT NULL, -- id of the channel in ascii

    posted_time INTEGER NOT NULL,      -- timestamp in epoch
    nick        VARCHAR(512) NOT NULL, -- nick of the person who posted this
    title       BLOB NOT NULL,         -- title of the post
    body        BLOB NOT NULL          -- body of the post
);

-- Local Variables:
-- sql-product: sqlite
-- End: