ON UPDATE is not preserved by CREATE TABLE .. SELECT

DROP TABLE IF EXISTS t1,t2;

CREATE TABLE t1 (

  vc VARCHAR(10) NOT NULL DEFAULT 'test',

  ts timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE t2 AS SELECT * FROM t1 LIMIT 0;

SHOW CREATE TABLE t2;

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table                                                                                                                                                 |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `vc` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT 'test',

  `ts` timestamp NULL DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+