From: Edward <edward@roojs.com>
Date: Thu, 8 Nov 2018 06:01:46 +0000 (+0800)
Subject: sql/projectdirectory.sql
X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=0e332be8176a8adda8554ae24c3094c35d3bdd07

sql/projectdirectory.sql
---

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index 01162067..57697a76 100644
--- a/sql/projectdirectory.sql
+++ b/sql/projectdirectory.sql
@@ -21,6 +21,7 @@ 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 ADD INDEX lookup_company_id (company_id);
+ALTER TABLE ProjectDirectory ADD INDEX lookup_person_id (person_id);
  
  
   
\ No newline at end of file