From: Chris Date: Tue, 12 Jun 2012 07:42:53 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=d3bfd5dabff9f68529174909803d329f062d6c40 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 6725b567..27e871d2 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -200,7 +200,7 @@ ALTER TABLE Projects ADD COLUMN team_id int(11) NOT NULL default '0'; ALTER TABLE Projects ADD COLUMN file_location varchar(254) NOT NULL default ''; ALTER TABLE Projects ADD COLUMN open_date date default NULL; ALTER TABLE Projects ADD COLUMN open_by int(11) NOT NULL default '0'; - +ALTER TABLE Projects ADD COLUMN updated_dt DATETIME NOT NULL; # these should be removed, as they are code specific.. ALTER TABLE Projects ADD COLUMN countries varchar(128) NOT NULL DEFAULT '';