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 d559c3d675e67397b234af11d112e73533927a1c..0a986d7d41ff08bd4ea478de8316011da263344c 100644 (file)
--- a/db/dbopt
+++ b/db/dbopt
@@ -16,6 +16,18 @@ 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
+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