blob: 1367a3adbb903a6b1f73d58e4de30f507ad82b88 (
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;
|