]> andersk Git - moira.git/blame - db/dbopt
brought this up-to-date
[moira.git] / db / dbopt
CommitLineData
f3f86c75 1modify users to cbtree unique on users_id
2index on users is i_usr_login (login)
3modify i_usr_login to btree
4index on users is i_usr_name (first, last)
5modify i_usr_name to cbtree on first, last
6index on users is i_usr_last (last, first)
7modify i_usr_name to cbtree on last, first
8index on users is i_usr_uid (uid)
9modify i_usr_uid to btree
10index on users is i_usr_pop (pop_id)
11modify i_usr_pop to btree
12
13modify machine to cbtree unique on mach_id
14index on machine is i_mac_name (name)
15modify i_mac_name to btree
16
17modify cluster to cbtree unique on clu_id
18index on cluster is i_clu_name (name)
19modify i_clu_name to btree
20
21modify mcmap to cbtree on clu_id
22index on mcmap is i_mcm_mach (mach_id)
23modify i_mcm_mach to cbtree
24
25modify svc to cbtree on clu_id
26
27modify servers to btree on name
28
29modify serverhosts to btree on service
30index on serverhosts is i_sho_mach (mach_id)
31modify i_sho_mach to cbtree
32
33modify list to cbtree unique on list_id
34index on list is i_lis_name (name)
35modify i_lis_name to btree
36index on list is i_lis_mail (maillist)
37index on list is i_lis_group (group)
38index on list is i_lis_gid (gid)
39modify i_lis_gid to btree
40
41modify members to cbtree on member_id, member_type
42index on members is i_mem_list (list_id)
43modify i_mem_list to hash
44
45modify strings to cbtree unique on string_id
46index on strings is i_str_name (string)
47modify i_str_name to hash
48
49modify nfsphys to cbtree unique on nfsphys_id
50index on nfsphys is i_nfs_mach (mach_id)
51modify i_nfs_mach to btree
52
53modify filesys to cbtree unique on filsys_id
54index on filesys is i_fil_name (label)
55modify i_fil_name to cbtree
56index on filesys is i_fil_mach (mach_id)
57modify i_fil_mach to btree
58index on filesys is i_fil_phys (phys_id)
59modify i_fil_phys to cbtree
60index on filesys is i_fil_grp (owners)
61modify i_fil_grp to btree
62
63modify nfsquota to cbtree on users_id
64index on nfsquota is i_nfq_fil (filsys_id)
65modify i_nfq_fil to cbtree
66index on nfsquota is i_nfq_phys (phys_id)
67modify i_nfq_phys to cbtree
68
69modify zephyr to cbtree unique on class
70
71modify hostaccess to cbtree unique on mach_id
72
73modify printcap to cbtree on name
74index on printcap is i_pcp_mach (mach_id)
75modify i_pcp_mach to btree
76
77modify capacls to cbtree on tag
This page took 0.061029 seconds and 5 git commands to generate.