-- Create a posts table
CREATE TABLE IF NOT EXISTS posts
(
    id                  INTEGER PRIMARY KEY    NOT NULL,
    created             INTEGER                NOT NULL,
    indexed             TIMESTAMP              NOT NULL DEFAULT CURRENT_TIMESTAMP,
    author              TEXT                   NOT NULL,
    rkey                TEXT                   NOT NULL,
    cid                 TEXT                   NOT NULL,
    subject             TEXT                   NULL,
    raw_blob            BLOB                   NULL,
    subject_raw_blob    BLOB                   NULL,
    UNIQUE(author, rkey)
);