X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fprojectdirectory.sql;h=57697a76c78e1a2b122197d79e60d00f0675a4f0;hb=c1af5e6bb6064e88469651271f4d9aaff34d69c0;hp=627ce3c92971c69658df9b5ae9755308d0f2b721;hpb=c873b33fd8aadc42849e21c17b760a8ca99fbe6b;p=Pman.Core

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index 627ce3c9..57697a76 100644
--- a/sql/projectdirectory.sql
+++ b/sql/projectdirectory.sql
@@ -20,4 +20,8 @@ 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);
 
-call mysql_change_engine('ProjectDirectory');
\ No newline at end of file
+ALTER TABLE ProjectDirectory ADD INDEX lookup_company_id (company_id);
+ALTER TABLE ProjectDirectory ADD INDEX lookup_person_id (person_id);
+ 
+ 
+  
\ No newline at end of file