PHP7 fix

[Pman.Core] / sql / projectdirectory.sql

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index 42365bc..57697a7 100644 (file)
--- 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);
 
-ALTER TABLE ProjectDirectory ENGINE=InnoDB;
\ 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