From: Alan Knowles <alan@akbkhome.com>
Date: Thu, 17 Mar 2011 14:33:29 +0000 (+0800)
Subject: DataObjects/core.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=f026453324bc5eaff44f05613f56145cad91a971

DataObjects/core.sql
---

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,