MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


5.7.39


create table t1 (
id int not null,
d1 timestamp not null,
PRIMARY KEY(id, d1))
engine=innodb;
show create table t1;


Table
Create Table


t1
CREATE TABLE `t1` (
  `id` int(11) NOT NULL,
  `d1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,`d1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


create table t2 (
id int not null,
d1 timestamp,
d2 timestamp) 
engine=innodb;

Invalid default value for 'd2'


show create table t2;

Table 'fiddle.t2' doesn't exist


create table t3 (
id int not null,
d1 timestamp not null,
num double not null)
engine=innodb;
show create table t3;


Table
Create Table


t3
CREATE TABLE `t3` (
  `id` int(11) NOT NULL,
  `d1` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `num` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1