From f026453324bc5eaff44f05613f56145cad91a971 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 17 Mar 2011 22:33:29 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 68d3a9b8..2d326849 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -192,6 +192,17 @@ ALTER TABLE Projects ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ; +CREATE TABLE `ProjectDirectory` ( + `id` int(11) NOT NULL auto_increment, + `project_id` int(11) NOT NULL, + `person_id` int(11) NOT NULL, + `ispm` int(11) NOT NULL, + `office_id` int(11) default NULL, + `company_id` int(11) default NULL, + `role` varchar(16) NOT NULL, + PRIMARY KEY (`id`) +) ; + CREATE TABLE `Images` ( `id` int(11) NOT NULL auto_increment, -- 2.39.2