From 0172a0a131a65adb6e404aba4e45fb8c647f2dd0 Mon Sep 17 00:00:00 2001 From: danw Date: Tue, 11 Jan 2000 19:33:15 +0000 Subject: [PATCH] add an index on users.reservations --- db/dbopt.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/db/dbopt.sql b/db/dbopt.sql index bd8f501a..3d569fc1 100644 --- a/db/dbopt.sql +++ b/db/dbopt.sql @@ -5,6 +5,7 @@ create index i_usr_last on users (last, first); 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 unique index i_krb_usid on krbmap (users_id); create index i_krb_str on krbmap (string_id); -- 2.45.1