fixed bug with IP address uniqueness check

[moira.git] / db / dbopt

diff --git a/db/dbopt b/db/dbopt
index a043783e2aa9c70959464a0371f84cda25a4dd86..0a986d7d41ff08bd4ea478de8316011da263344c 100644 (file)
--- a/db/dbopt
+++ b/db/dbopt
@@ -27,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