From fac99f17639114b3224f0cd971fb0b10a78130ce Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 14 Aug 2012 14:02:22 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 5 +++++ 1 file changed, 5 insertions(+) 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 ''; -- 2.39.2