update table define

diff --git a/mubot.mysql b/mubot.mysql
index d911302..cea6170 100644 (file)
--- a/mubot.mysql
+++ b/mubot.mysql
@@ -13,7 +13,8 @@ CREATE TABLE posts (
 
 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);
+create index submitter_idx on posts(submitter(64));
+create index uri_idx on posts(uri(1024));
+create fulltext index full_submitter_idx on posts(submitter);
+create fulltext index full_msg_path_idx on posts(prefix,path,suffix);
+create fulltext index full_msg_idx on posts(prefix,uri,suffix);