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

sql/core_project.sql
---

diff --git a/sql/core_project.sql b/sql/core_project.sql
index fac5f33f..b4a74177 100644
--- a/sql/core_project.sql
+++ b/sql/core_project.sql
@@ -29,4 +29,7 @@ ALTER TABLE core_project ADD INDEX plookup (code);
 
 ALTER TABLE core_project ADD INDEX lookup_client_id (client_id);
 ALTER TABLE core_project ADD INDEX lookup_agency_id (agency_id);
+
+ALTER TABLE core_project ADD INDEX lookup_open_by (open_by);
+ALTER TABLE core_project ADD INDEX lookup_owner_id (owner_id);
  
\ No newline at end of file