diff options
Diffstat (limited to 'mysql-test/r/key.result')
-rw-r--r-- | mysql-test/r/key.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index a89a79dadbb..bc4d69e72eb 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -433,8 +433,8 @@ show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, - `c2` char(12) NOT NULL DEFAULT '', - `c3` varchar(123) NOT NULL DEFAULT '', + `c2` char(12) NOT NULL, + `c3` varchar(123) NOT NULL, `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`c2`,`c3`), UNIQUE KEY `i4` (`c4`), @@ -471,9 +471,9 @@ ERROR 42000: Can't DROP 'PRIMARY'; check that column/key exists show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `c1` int(11) NOT NULL DEFAULT '0', - `c2` char(12) NOT NULL DEFAULT '', - `c3` varchar(123) NOT NULL DEFAULT '', + `c1` int(11) NOT NULL, + `c2` char(12) NOT NULL, + `c3` varchar(123) NOT NULL, `c4` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, KEY `i1` (`c1`), KEY `i5` (`c1`,`c2`,`c3`,`c4`), |