建表语句
CREATE TABLE IF NOT EXISTS `tblTest`(
`id` INT UNSIGNED AUTO_INCREMENT,
`tid` BIGINT(20) NOT NULL DEFAULT 0 COMMENT '测试用例id',
`title` VARCHAR(128) NOT NULL DEFAULT '' COMMENT '测试title',
`operater` VARCHAR(40) NOT NULL DEFAULT '' COMMENT '测试人员',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后一次修改时间',
PRIMARY KEY ( `id` ),
KEY `TID` (`tid`),
KEY `OPERATER` (`operater`),
KEY `CREATE_TIME` (`create_time`),
KEY `UPDATE_TIME` (`update_time`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试表';
字段名黑名单:
lock 锁定,最好改为is_lock。