sql/core_email.sql

[Pman.Core] / sql / projectdirectory.sql

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index 057f716..c245e67 100644 (file)
--- a/sql/projectdirectory.sql
+++ b/sql/projectdirectory.sql
@@ -14,5 +14,12 @@ ALTER TABLE  ProjectDirectory ADD COLUMN   person_id int(11) NOT NULL DEFAULT 0;
 ALTER TABLE  ProjectDirectory ADD COLUMN   ispm int(11) NOT NULL DEFAULT 0;
 ALTER TABLE  ProjectDirectory ADD COLUMN   role varchar(32) NOT NULL DEFAULT '';
 
+ALTER TABLE  ProjectDirectory ADD COLUMN   company_id int(11) NOT NULL DEFAULT 0;
+ALTER TABLE  ProjectDirectory ADD COLUMN   office_id int(11) NOT NULL DEFAULT 0;
+
+
 ALTER TABLE ProjectDirectory ADD INDEX plookup (project_id,person_id, ispm, role);
 
+ 
+ 
+  
\ No newline at end of file