From: Alan Knowles Date: Tue, 14 Aug 2012 06:02:22 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=fac99f17639114b3224f0cd971fb0b10a78130ce DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 0ad498e7..11efcfa4 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -182,6 +182,11 @@ 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); + + + # old mysql alter table Person change column active active int(11) NOT NULL DEFAULT 1 ; alter table Person change role role varchar(254) NOT NULL DEFAULT '';