ALTER TABLE core_project ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ;
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