Forgot to setacl on www subdir, and do not want OldFiles for type ORG

[moira.git] / db / dbopt

diff --git a/db/dbopt b/db/dbopt
index c673c7999db8e4fe28b035b14ea6666e3ee9ee71..0a986d7d41ff08bd4ea478de8316011da263344c 100644 (file)
--- a/db/dbopt
+++ b/db/dbopt
@@ -16,6 +16,10 @@ modify i_krb_str to btree;\g
 modify machine to cbtree unique on mach_id;\g
 create index i_mac_name on  machine (name);\g
 modify i_mac_name to btree;\g
+create index i_mac_addr on machine (address);\g
+modify i_mac_addr to btree;\g
+create index i_mac_loc on machine (location);\g
+modify i_mac_loc to btree;\g
 ;\g
 modify hostalias to cbtree unique on name;\g
 create index i_hal_id on hostalias (mach_id);\g
@@ -23,6 +27,7 @@ modify i_hal_id to btree;\g
 ;\g
 modify subnet to btree unique on snet_id;\g
 create index i_snt_name on subnet (name);\g
+create index i_snt_saddr on subnet(saddr);\g
 ;\g
 modify cluster to cbtree unique on clu_id;\g
 create index i_clu_name on  cluster (name);\g