gistfile1.txt

CREATE TABLE statuses (
    'id'                          INTEGER PRIMARY KEY,
    'tweet'                       TEXT,
    'in_reply_to_status_id'       INTEGER,
    'user_id'                     INTEGER,
    'user'                        TEXT
);

CREATE INDEX statuses_in_reply_to_status_id on statuses(in_reply_to_status_id);
CREATE INDEX statuses_user_id on statuses(user_id);