From: Alan Knowles <alan@roojs.com>
Date: Mon, 17 Jul 2017 02:17:02 +0000 (+0800)
Subject: sql/core_person.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=214edeff4eff13a7267630c2f8a8fa1a636a9d06

sql/core_person.sql
---

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