diff options
author | Omer BarNir <omer@mysql.com> | 2010-03-17 23:42:07 -0700 |
---|---|---|
committer | Omer BarNir <omer@mysql.com> | 2010-03-17 23:42:07 -0700 |
commit | c92b9b7315c01e87b1099e7df182213a1d8ffa6f (patch) | |
tree | 096cc41e4d541dd16c84cb829e630fef3d5baba7 /mysql-test/suite/engines/funcs/r/ta_add_unique_index.result | |
parent | 96d4a0384629e5cddc93ee215e7af484e4b95bde (diff) | |
download | mariadb-git-c92b9b7315c01e87b1099e7df182213a1d8ffa6f.tar.gz |
Test suites for engine testing, moved from test-extra so will be available
for general use.
mysql-test/Makefile.am:
Adding directories of additional test suites
mysql-test/mysql-stress-test.pl:
Adding check for additional errors checking during test run
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/ta_add_unique_index.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/ta_add_unique_index.result | 6337 |
1 files changed, 6337 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/ta_add_unique_index.result b/mysql-test/suite/engines/funcs/r/ta_add_unique_index.result new file mode 100644 index 00000000000..2a7f3684541 --- /dev/null +++ b/mysql-test/suite/engines/funcs/r/ta_add_unique_index.result @@ -0,0 +1,6337 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `c1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `cst1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE KEY i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bit(1) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TINYINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` tinyint(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 SMALLINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` smallint(6) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 MEDIUMINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` mediumint(9) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 INTEGER NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` int(11) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 BIGINT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 REAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DOUBLE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` double NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 FLOAT NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` float NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DECIMAL NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 NUMERIC NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` decimal(10,0) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 DATE NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` date NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIME NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` time NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 TIMESTAMP NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test +CREATE TABLE t1(c1 YEAR NOT NULL); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +ALTER TABLE t1 ADD CONSTRAINT cst1 UNIQUE INDEX i1 (c1); +SHOW TABLES; +Tables_in_test +t1 +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` year(4) NOT NULL, + UNIQUE KEY `i1` (`c1`) +) ENGINE=ENGINE DEFAULT CHARSET=latin1 +DROP TABLE t1; +SHOW TABLES; +Tables_in_test |