blob: b1a7c8efb894febbd466e94f0b524cb918a69c7b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
DROP TABLE IF EXISTS bugs;
CREATE TABLE bugs (
id INT UNSIGNED PRIMARY KEY,
tag VARCHAR(64),
INDEX (tag) COMMENT 'Tag search is required.'
) DEFAULT CHARSET=utf8
COMMENT='engine "InnoDB"';
SHOW CREATE TABLE bugs;
Table Create Table
bugs CREATE TABLE `bugs` (
`id` int(10) unsigned NOT NULL,
`tag` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `tag` (`tag`) COMMENT 'Tag search is required.'
) ENGINE=Mroonga DEFAULT CHARSET=utf8 COMMENT='engine "InnoDB"'
DROP TABLE bugs;
|