From f7306786fc40f926b458c54ce596af1004563ee6 Mon Sep 17 00:00:00 2001 From: mar Date: Thu, 29 Dec 1988 18:43:34 +0000 Subject: [PATCH] Initial revision --- db/dbopt.after | 51 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 51 insertions(+) create mode 100644 db/dbopt.after diff --git a/db/dbopt.after b/db/dbopt.after new file mode 100644 index 00000000..3d29e8fb --- /dev/null +++ b/db/dbopt.after @@ -0,0 +1,51 @@ +index on users is i_usr_name (first, last) +modify i_usr_name to hash +index on users is i_usr_uid (uid) +modify i_usr_uid to btree +index on users is i_usr_pop (pop_id) +modify i_usr_pop to btree + +modify machine to cbtree unique on mach_id +index on machine is i_mac_name (name) +modify i_mac_name to btree + +modify cluster to cbtree unique on clu_id +index on cluster is i_clu_name (name) +modify i_clu_name to btree + +modify mcmap to cbtree on clu_id +index on mcmap is i_mcm_mach (mach_id) +modify i_mcm_mach to cbtree + +modify svc to cbtree on clu_id + +modify servers to btree on name + +index on list is i_lis_gid (gid) +modify i_lis_gid to btree + +modify members to hash on member_id, member_type +index on members is i_mem_list (list_id) +modify i_mem_list to hash + +modify strings to cbtree unique on string_id +index on strings is i_str_name (string) +modify i_str_name to hash + +index on filesys is i_fil_grp (owners) +modify i_fil_grp to btree + +modify nfsquota to cbtree on users_id +index on nfsquota is i_nfq_fil (filsys_id) +modify i_nfq_fil to cbtree +index on nfsquota is i_nfq_phys (phys_id) +modify i_nfq_phys to cbtree + +modify zephyr to cbtree unique on class + +modify hostaccess to cbtree unique on mach_id + +modify printcap to cbtree on name +index on printcap is i_pcp_mach (mach_id) + +modify capacls to cbtree on tag -- 2.45.2