1--source include/have_tokudb.inc 2# 3# Record inconsistency. 4# 5# 6SET DEFAULT_STORAGE_ENGINE = 'tokudb'; 7 8--disable_warnings 9DROP TABLE IF EXISTS foo; 10--enable_warnings 11 12 13set tokudb_disable_slow_alter=ON; 14 15CREATE TABLE `foo` ( 16 `guid` bigint(20) unsigned NOT NULL, 17 `name` varchar(63) NOT NULL, 18 `username` varchar(128) DEFAULT NULL, 19 `password` varchar(32) DEFAULT NULL, 20 `salt` varchar(8) DEFAULT NULL, 21 `email` varchar(256) DEFAULT NULL, 22 `language` varchar(6) DEFAULT NULL, 23 `latitude` int(11) DEFAULT NULL, 24 `longitude` int(11) DEFAULT NULL, 25 `website` varchar(256) DEFAULT NULL, 26 `code` varchar(32) DEFAULT NULL, 27 `banned` enum('yes','no') NOT NULL DEFAULT 'no', 28 `admin` enum('yes','no') NOT NULL DEFAULT 'no', 29 `last_action` int(11) NOT NULL DEFAULT '0', 30 `prev_last_action` int(11) NOT NULL DEFAULT '0', 31 `last_login` int(11) NOT NULL DEFAULT '0', 32 `prev_last_login` int(11) NOT NULL DEFAULT '0', 33 PRIMARY KEY (`guid`), 34 UNIQUE KEY `username` (`username`), 35 KEY `password` (`password`), 36 KEY `email` (`email`(50)), 37 KEY `code` (`code`), 38 KEY `last_action` (`last_action`), 39 KEY `last_login` (`last_login`), 40 KEY `admin` (`admin`) 41) ENGINE=TokuDB DEFAULT CHARSET=utf8; 42 43ALTER TABLE `foo` ADD `gender` TINYINT NULL AFTER `website` , 44ADD `influence` INT NOT NULL DEFAULT '0' AFTER `gender` , 45ADD `virality` INT NOT NULL DEFAULT '0' AFTER `influence`; 46 47 48# Final cleanup. 49DROP TABLE foo; 50 51