hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.62k stars 553 forks source link

表定义不正确,只能有一个TIMESTAMP字段在DEFAULT或ON UPDATE指定CURRENT_TIMESTAMP. #564

Open diaowentao opened 1 year ago

diaowentao commented 1 year ago

create table BOSS_WAITE_DEAL_DONE_RECORDS ( ID int auto_increment not null comment '主键ID' primary key,

CREATE_TIME timestamp default CURRENT_TIMESTAMP not null comment '创建时间', MODIFY_TIME timestamp default CURRENT_TIMESTAMP not null ON UPDATE CURRENT_TIMESTAMP comment '最后一次修改时间', unique key UNIQ_BOSS_WAITE_DEAL_DONE_RECORDS_ORDER_ID (ORDER_ID) ) comment '待办事项临时记录表';

mysql实际支持,goinception这里并不支持 报错 表定义不正确,只能有一个TIMESTAMP字段在DEFAULT或ON UPDATE指定CURRENT_TIMESTAMP.

重现 模拟重现的步骤

环境

参数 可能与问题相关的设置参数

hanchuanchuan commented 1 year ago

可以设置参数check_timestamp_count

stale[bot] commented 1 year ago

由于此问题没有最近的活动,因此已被自动标记为陈旧。如果没有进一步的活动,会作为不活跃issue关闭。感谢你对本项目的贡献。 This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.