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_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 prefix_idx on posts(prefix);
-create fulltext index suffix_idx on posts(suffix);
-create fulltext index msg_idx on posts(prefix,uri,suffix);
+create fulltext index msg_idx on posts(prefix,path,suffix);
+create fulltext index msg_full_idx on posts(prefix,uri,suffix);