1SELECT mroonga_command("plugin_register token_filters/stop_word"); 2mroonga_command("plugin_register token_filters/stop_word") 3true 4CREATE TABLE terms ( 5term VARCHAR(64) NOT NULL PRIMARY KEY, 6is_stop_word BOOL NOT NULL 7) COMMENT='default_tokenizer "TokenBigram"' DEFAULT CHARSET=utf8; 8CREATE TABLE memos ( 9id INT NOT NULL PRIMARY KEY, 10content TEXT NOT NULL, 11FULLTEXT INDEX (content) COMMENT 'table "terms"' 12) DEFAULT CHARSET=utf8; 13SELECT mroonga_command("dump --dump_plugins no"); 14mroonga_command("dump --dump_plugins no") 15table_create memos TABLE_PAT_KEY Int32 16column_create memos content COLUMN_SCALAR LongText 17column_create memos id COLUMN_SCALAR Int32 18 19table_create mroonga_operations TABLE_NO_KEY 20column_create mroonga_operations record COLUMN_SCALAR UInt32 21column_create mroonga_operations table COLUMN_SCALAR ShortText 22column_create mroonga_operations type COLUMN_SCALAR ShortText 23 24table_create terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerMySQLGeneralCI 25column_create terms is_stop_word COLUMN_SCALAR Int8 26column_create terms term COLUMN_SCALAR ShortText 27 28column_create terms content COLUMN_INDEX|WITH_POSITION memos content 29ALTER TABLE terms COMMENT='default_tokenizer "TokenBigram", token_filters "TokenFilterStopWord"'; 30SELECT mroonga_command("dump --dump_plugins no"); 31mroonga_command("dump --dump_plugins no") 32table_create memos TABLE_PAT_KEY Int32 33column_create memos content COLUMN_SCALAR LongText 34column_create memos id COLUMN_SCALAR Int32 35 36table_create mroonga_operations TABLE_NO_KEY 37column_create mroonga_operations record COLUMN_SCALAR UInt32 38column_create mroonga_operations table COLUMN_SCALAR ShortText 39column_create mroonga_operations type COLUMN_SCALAR ShortText 40 41table_create terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerMySQLGeneralCI --token_filters TokenFilterStopWord 42column_create terms is_stop_word COLUMN_SCALAR Int8 43column_create terms term COLUMN_SCALAR ShortText 44ALTER TABLE memos DISABLE KEYS; 45ALTER TABLE memos ENABLE KEYS; 46SELECT mroonga_command("dump --dump_plugins no"); 47mroonga_command("dump --dump_plugins no") 48table_create memos TABLE_PAT_KEY Int32 49column_create memos content COLUMN_SCALAR LongText 50column_create memos id COLUMN_SCALAR Int32 51 52table_create mroonga_operations TABLE_NO_KEY 53column_create mroonga_operations record COLUMN_SCALAR UInt32 54column_create mroonga_operations table COLUMN_SCALAR ShortText 55column_create mroonga_operations type COLUMN_SCALAR ShortText 56 57table_create terms TABLE_PAT_KEY ShortText --default_tokenizer TokenBigram --normalizer NormalizerMySQLGeneralCI --token_filters TokenFilterStopWord 58column_create terms is_stop_word COLUMN_SCALAR Int8 59column_create terms term COLUMN_SCALAR ShortText 60 61column_create terms content COLUMN_INDEX|WITH_POSITION memos content 62DROP TABLE memos; 63DROP TABLE terms; 64