update mysql.sql

xiyuning · Sep 22, 2019 · 0f0ee37 · 0f0ee37
1 parent 360a7b9
commit 0f0ee37
Show file tree

Hide file tree

Showing 2 changed files with 3 additions and 0 deletions.
diff --git a/sql/mysql/mysql.sql b/sql/mysql/mysql.sql
@@ -1,6 +1,8 @@
 DROP DATABASE IF EXISTS cboard;
 CREATE DATABASE cboard CHARACTER SET utf8;
 USE cboard;
+SET SQL_MODE='ALLOW_INVALID_DATES';
+SET SQL_SAFE_UPDATES = 0;
 
 CREATE TABLE dashboard_board (
   board_id bigint(20) NOT NULL AUTO_INCREMENT,

diff --git a/sql/mysql/patch/005.sql b/sql/mysql/patch/005.sql
@@ -1,3 +1,4 @@
+SET SQL_MODE='ALLOW_INVALID_DATES';
 -- 升级0.4需要执行的
 ALTER TABLE dashboard_dataset ADD create_time TIMESTAMP DEFAULT now();
 ALTER TABLE dashboard_dataset ADD update_time TIMESTAMP;