blob: a5ac716d38e974048372c797aeda402a9eb4230b (
plain)
1
2
3
4
5
6
7
8
9
|
SET NAMES utf8;
CREATE TABLE memos (
content VARCHAR(64) NOT NULL PRIMARY KEY,
FULLTEXT INDEX (content) COMMENT 'index_flags "WITH_POSITION|WITH_WEIGHT"'
) COMMENT='engine "InnoDB"' DEFAULT CHARSET=utf8;
SELECT mroonga_command("dump --dump_plugins no --dump_schema no");
mroonga_command("dump --dump_plugins no --dump_schema no")
column_create memos-content index COLUMN_INDEX|WITH_WEIGHT|WITH_POSITION memos
DROP TABLE memos;
|