1
CREATE TABLE t1 (a int primary key);
6
PRIMARY KEY (`a`) USING BTREE
7
) ENGINE=InnoDB COLLATE = utf8_general_ci
9
CREATE TABLE t2 (a int primary key, b int unique, c varchar(100) unique);
12
t2 CREATE TABLE `t2` (
14
`b` INT UNIQUE DEFAULT NULL,
15
`c` VARCHAR(100) COLLATE utf8_general_ci UNIQUE DEFAULT NULL,
16
PRIMARY KEY (`a`) USING BTREE,
17
UNIQUE KEY `b` (`b`) USING BTREE,
18
UNIQUE KEY `c` (`c`) USING BTREE
19
) ENGINE=InnoDB COLLATE = utf8_general_ci