1CREATE TABLE t1(c42 tinyblob not null, c45 TEXT, unique(c42 (255)), unique(c45 (255))) ENGINE=InnoDB;
2ALTER TABLE t1 MODIFY c45 SET('') NOT NULL;
3SHOW CREATE TABLE t1;
4Table	Create Table
5t1	CREATE TABLE `t1` (
6  `c42` tinyblob NOT NULL,
7  `c45` set('') NOT NULL,
8  UNIQUE KEY `c42` (`c42`(255)),
9  UNIQUE KEY `c45` (`c45`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1
11DROP TABLE t1;
12