projects / Pman.Core / commitdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | patch | inline | side by side (parent: 95d8e3c)
sql/projectdirectory.sql
authorEdward <edward@roojs.com>
Thu, 8 Nov 2018 05:20:12 +0000 (13:20 +0800)
committerEdward <edward@roojs.com>
Thu, 8 Nov 2018 05:20:12 +0000 (13:20 +0800)
sql/projectdirectory.sql patch | blob | history

diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql
index c245e67..0116206 100644 (file)
--- 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
Pman Core