CREATE TABLE posts (
       id INT PRIMARY KEY AUTO_INCREMENT,
       submitter TEXT NOT NULL,
       submitter_type INTEGER NOT NULL default 1,
       fb_post_id BIGINT UNSIGNED UNIQUE NOT NULL,
       scheme TEXT NOT NULL,
       uri TEXT NOT NULL,
       prefix TEXT NOT NULL,
       suffix TEXT NOT NULL,
       scheme TEXT NOT NULL,
       path TEXT NOT NULL,
       post_time BIGINT UNSIGNED NOT NULL
) ENGINE = mroonga DEFAULT CHARSET utf8;

create index posts_fb_post_id_idx on posts(fb_post_id);
create index posts_post_time_idx on posts(post_time);
create fulltext index submitter_idx on posts(submitter);
create fulltext index uri_idx on posts(uri);
create fulltext index msg_idx on posts(prefix,path,suffix);
create fulltext index msg_full_idx on posts(prefix,uri,suffix);