mysql建表TIMESTAMP的CURRENT_TIMESTAMP用法

CREATE TABLE data(
	id VARCHAR(64) UNIQUE,
	sbj VARCHAR(256),
	prd VARCHAR(256),
	obj VARCHAR(256),
	is_delete INT(11),
	create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	file_id VARCHAR(64),
	pos VARCHAR(256),
	PRIMARY KEY(sbj,prd,obj),
    UNIQUE INDEX in_one(sbj,prd,obj),
	INDEX in_two(sbj,obj),
	INDEX in_three(prd,obj)
);

CURRENT_TIMESTAMP：记录自动添加记录创建的时间
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP：自动添加本次更改时间