1--source include/have_rocksdb.inc
2
3CREATE TABLE `r1.lol` (
4  `c1` int(10) NOT NULL DEFAULT '0',
5  `c2` int(11) NOT NULL DEFAULT '0',
6  `c3` int(1) NOT NULL DEFAULT '0',
7  `c4` int(11) NOT NULL DEFAULT '0',
8  `c5` int(11) NOT NULL DEFAULT '0',
9  `c6` varchar(100) NOT NULL DEFAULT '',
10  `c7` varchar(100) NOT NULL DEFAULT '',
11  `c8` varchar(255) NOT NULL DEFAULT '',
12  `c9` int(10) NOT NULL DEFAULT '125',
13  `c10` int(10) NOT NULL DEFAULT '125',
14  `c11` text NOT NULL,
15  `c12` int(11) NOT NULL DEFAULT '0',
16  `c13` int(10) NOT NULL DEFAULT '0',
17  `c14` text NOT NULL,
18  `c15` blob NOT NULL,
19  `c16` int(11) NOT NULL DEFAULT '0',
20  `c17` int(11) NOT NULL DEFAULT '0',
21  `c18` int(11) NOT NULL DEFAULT '0',
22  PRIMARY KEY (`c1`),
23  KEY i1 (`c4`),
24  KEY i2 (`c7`),
25  KEY i3 (`c2`)) ENGINE=RocksDB DEFAULT CHARSET=latin1;
26
27DROP INDEX i1 ON `r1.lol`;
28DROP TABLE `r1.lol`;
29
30