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