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