From: Alan Knowles <alan@roojs.com>
Date: Tue, 14 Aug 2012 06:02:36 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=e0b9ac3385638553b9597588fd43becb3f4bab17

DataObjects/core.sql
---

diff --git a/DataObjects/core.sql b/DataObjects/core.sql
index 11efcfa4..06db0289 100644
--- a/DataObjects/core.sql
+++ b/DataObjects/core.sql
@@ -182,8 +182,8 @@ ALTER TABLE Person ADD COLUMN   project_id int(11) default 0;
 ALTER TABLE Person ADD COLUMN   deleted_by INT(11) NOT NULL default 0 ;
 ALTER TABLE Person ADD COLUMN   deleted_dt DATETIME ;
 
-ALTER TABLE Person ADD COLUMN   firstname varchar(128);
-ALTER TABLE Person ADD COLUMN   lastname varchar(128);
+ALTER TABLE Person ADD COLUMN   firstname varchar(128) NOT NULL DEFAULT '';
+ALTER TABLE Person ADD COLUMN   lastname varchar(128) NOT NULL DEFAULT '';