From 214edeff4eff13a7267630c2f8a8fa1a636a9d06 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Jul 2017 10:17:02 +0800 Subject: [PATCH] sql/core_person.sql --- sql/core_person.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/sql/core_person.sql b/sql/core_person.sql index 32dc23d6..1ae3a385 100644 --- a/sql/core_person.sql +++ b/sql/core_person.sql @@ -22,7 +22,8 @@ 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 ''; -SET SQL_MODE='ALLOW_INVALID_DATES'; +-- do not set SQL mode here - it needs to be done in the config +-- SET SQL_MODE='ALLOW_INVALID_DATES'; ALTER TABLE core_person ADD COLUMN birth_date DATE NOT NULL DEFAULT '0000-00-00'; -- main contact details -- 2.39.2