Create index on sponsor_id column in users table.

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 0ae04b42cbf26b04a15c9e9427517649d348909e..64a107f0834596dbd0169d87eb07c4d0910f5257 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -6,6 +6,7 @@ create index i_usr_uid on  users (unix_uid);
 create index i_usr_pop on  users (pop_id);
 create index i_usr_clearid on users (clearid);
 create index i_usr_resv on users (reservations);
+create index i_usr_sponsor on users (sponsor_id);
 
 create unique index i_krb_usid on krbmap  (users_id);
 create index i_krb_str on  krbmap (string_id);