From: Alan Knowles Date: Thu, 12 May 2011 10:01:50 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=e606e5a224a181303cb4d1d873ec5ee47b760c58 DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 47d8fe77..90ff3c8b 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -194,6 +194,8 @@ ALTER TABLE Projects ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ; #-- we duplicate office_id and company_id here... #-- not sure if we should keep doing that in the new design... #-- we should improve our links code to handle this.. + + CREATE TABLE `ProjectDirectory` ( `id` int(11) NOT NULL auto_increment, `project_id` int(11) NOT NULL,