From a0c944d9b22c886f7c2016b655bfa214295d06b6 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Jul 2017 10:17:23 +0800 Subject: [PATCH] sql/core_person.sql --- sql/core_person.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/core_person.sql b/sql/core_person.sql index f229ff73..79d11f74 100644 --- a/sql/core_person.sql +++ b/sql/core_person.sql @@ -22,7 +22,7 @@ ALTER TABLE core_person ADD COLUMN remarks text NOT NULL; ALTER TABLE core_person ADD COLUMN lang varchar(8) default 'en'; ALTER TABLE core_person ADD COLUMN country varchar(8) default ''; --- do not set SQL mode here - it needs to be done in the mysql config +-- do not set SQL mode here - it needs to be done in the mysql config (updatedatabase checks for this) -- SET SQL_MODE='ALLOW_INVALID_DATES'; ALTER TABLE core_person ADD COLUMN birth_date DATE NOT NULL DEFAULT '0000-00-00'; -- 2.39.2