CREATE TABLE posts (
       id INTEGER PRIMARY KEY NOT NULL,
       commiter TEXT NOT NULL,
       commiter_type INTEGER NOT NULL default 1,
       fb_post_id INTEGER UNIQUE NOT NULL,
       uri TEXT NOT NULL,
       prefix TEXT NOT NULL,
       suffix TEXT NOT NULL,
       post_time INTEGER NOT NULL
);

create index posts_fb_post_id_idx on posts(fb_post_id);
create index posts_post_time_idx on posts(post_time);
