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

sql/projectdirectory.sql
---

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index c245e678..01162067 100644
--- a/sql/projectdirectory.sql
+++ b/sql/projectdirectory.sql
@@ -20,6 +20,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);
  
  
   
\ No newline at end of file