added the new imembers index

diff --git a/db/dbopt b/db/dbopt
index 63ca6a6cb02f39caf0db2ba71542b76c21b3caaf..2a2d32992b36f0c2db8600e0c100f8c8ced21663 100644 (file)
--- a/db/dbopt
+++ b/db/dbopt
@@ -62,6 +62,7 @@ modify i_lis_gid to btree;\g
 modify imembers to cbtree on member_id, member_type;\g
 create index i_imem_list on  imembers (list_id);\g
 modify i_imem_list to hash;\g
+create index i_imem_all on imembers (list_id, member_type, member_id, direct);\g
 ;\g
 modify strings to cbtree unique on string_id;\g
 create index i_str_name on  strings (string);\g