← Back to branch summary

~drizzle-trunk/drizzle/development 

1
2
3
4
5
6
7
8
9
10
11
12
13
14

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a text, b int, key ab (a(10),b));

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
CREATE TABLE `t1` (
  `a` TEXT COLLATE utf8_general_ci DEFAULT NULL,
  `b` INT DEFAULT NULL,
  KEY `ab` (`a`(10),`b`)
) ENGINE='InnoDB' COLLATE='utf8_general_ci';

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
DROP TABLE t1;