SqyEXfJy

1mysql> CREATE TABLE IF NOT EXISTS icinga_dbversion (
2    ->   dbversion_id serial,
3    ->   name varchar(10) character set latin1  default '',
4    ->   version varchar(10) character set latin1  default '',
5    ->   create_time timestamp  default NOW(),
6    ->   modify_time timestamp  default NOW(),
7    ->   PRIMARY KEY (dbversion_id),
8    ->   UNIQUE KEY dbversion (name)
9    -> ) ENGINE=InnoDB;
10ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause