[1481] in Moira
ghbo index addition
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Thu Mar 23 16:28:11 2000
Message-Id: <200003232128.QAA01022@wing-commander.mit.edu>
To: moiradev@MIT.EDU
Date: Thu, 23 Mar 2000 16:28:07 EST
From: Garry Zacheiss <zacheiss@MIT.EDU>
Index: dbopt.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/dbopt.sql,v
retrieving revision 1.9
diff -c -r1.9 dbopt.sql
*** dbopt.sql 2000/03/06 21:30:48 1.9
--- dbopt.sql 2000/03/21 22:20:24
***************
*** 16,21 ****
--- 16,22 ----
create index i_mac_loc on machine (location);
create index i_mac_snet on machine (snet_id);
create index i_mac_hwaddr on machine (hwaddr);
+ create index i_mac_owner on machine (owner_id);
create unique index i_hal_name on hostalias (name);
create index i_hal_id on hostalias (mach_id);
