Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

auth.sql 种建表语句再mysql5.6上提示ss_organization 表 [Err] 1067 - Invalid default value for 'updatetime' #1

Open
aboutdata opened this issue Aug 12, 2015 · 1 comment
Open

auth.sql 种建表语句再mysql5.6上提示ss_organization 表 [Err] 1067 - Invalid default value for 'updatetime' #1

aboutdata opened this issue Aug 12, 2015 · 1 comment

Comments

@aboutdata
Copy link

解决办法:把
ss_organization 创建表语句
updatetime timestamp DEFAULT NULL COMMENT '更新时间',
修改成
updatetime timestamp COMMENT '更新时间',
imalexyang added a commit that referenced this issue Aug 25, 2015
@imalexyang
修改了一个sql报错问题-20150825
1a15281 
建表语句再mysql5.6上提示ss_organization 表 [Err] 1067 - Invalid default value for 'updatetime' (#1)

解决办法:把 
ss_organization 创建表语句
updatetime timestamp DEFAULT NULL COMMENT '更新时间', 
修改成
updatetime timestamp COMMENT '更新时间',
@liulinlin
Copy link

改过之后我的还是通过不了，后来　改成　timestamp NULL DEFAULT NULL COMMENT '更新时间',
就可以了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@liulinlin @aboutdata