From 8083db6c892ac1cf629652e05cdaa9d16807ba6a Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Thu, 29 Nov 2007 21:46:29 +0000
Subject: [PATCH] Create index on sponsor_id column in users table.

---
 db/dbopt.sql | 1 +
 1 file changed, 1 insertion(+)

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 0ae04b42..64a107f0 100644
--- 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);
-- 
2.45.2