blob: 77765f61dc306a84f5f16d086c0f4ce8d6c6c5c9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
DROP TABLE IF EXISTS variables;
CREATE TABLE variables (
id INT PRIMARY KEY AUTO_INCREMENT,
name TEXT,
FULLTEXT INDEX (name) COMMENT 'parser "off"'
) DEFAULT CHARSET=utf8;
SHOW CREATE TABLE variables;
Table Create Table
variables CREATE TABLE `variables` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text,
PRIMARY KEY (`id`),
FULLTEXT KEY `name` (`name`) COMMENT 'parser "off"'
) ENGINE=Mroonga DEFAULT CHARSET=utf8
INSERT INTO variables (name) VALUES ("mroonga_database_path_prefix");
INSERT INTO variables (name) VALUES ("mroonga_default_parser");
INSERT INTO variables (name) VALUES ("mroonga_default_wrapper_engine");
INSERT INTO variables (name) VALUES ("mroonga_dry_write");
INSERT INTO variables (name) VALUES ("mroonga_enable_optimization");
INSERT INTO variables (name) VALUES ("mroonga_libgroonga_version");
INSERT INTO variables (name) VALUES ("mroonga_log_file");
INSERT INTO variables (name) VALUES ("mroonga_log_level");
INSERT INTO variables (name) VALUES ("mroonga_match_escalation_threshold");
INSERT INTO variables (name) VALUES ("mroonga_version");
SELECT * FROM variables;
id name
1 mroonga_database_path_prefix
2 mroonga_default_parser
3 mroonga_default_wrapper_engine
4 mroonga_dry_write
5 mroonga_enable_optimization
6 mroonga_libgroonga_version
7 mroonga_log_file
8 mroonga_log_level
9 mroonga_match_escalation_threshold
10 mroonga_version
SELECT * FROM variables
WHERE MATCH (name) AGAINST ("mroonga_default*" IN BOOLEAN MODE);
id name
3 mroonga_default_wrapper_engine
2 mroonga_default_parser
DROP TABLE variables;
|