1
DROP TABLE IF EXISTS t1;
2
CREATE TABLE t1 (a text, b int, key ab (a(10),b));
4
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
5
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
7
`a` TEXT COLLATE utf8_general_ci DEFAULT NULL,
10
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
12
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
13
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;