]> andersk Git - moira.git/blame_incremental - db/dbopt
Use "get_end_members_of_list" query to perform more atomic operation.
[moira.git] / db / dbopt
... / ...
CommitLineData
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_last 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 krbmap to btree unique on users_id
14index on krbmap is i_krb_str (string_id)
15modify i_krb_str to btree
16
17modify machine to cbtree unique on mach_id
18index on machine is i_mac_name (name)
19modify i_mac_name to btree
20
21modify cluster to cbtree unique on clu_id
22index on cluster is i_clu_name (name)
23modify i_clu_name to btree
24
25modify mcmap to cbtree on clu_id
26index on mcmap is i_mcm_mach (mach_id)
27modify i_mcm_mach to cbtree
28
29modify svc to cbtree on clu_id
30
31modify servers to btree on name
32
33modify serverhosts to btree on service
34index on serverhosts is i_sho_mach (mach_id)
35modify i_sho_mach to cbtree
36
37modify list to cbtree unique on list_id
38index on list is i_lis_name (name)
39modify i_lis_name to btree
40index on list is i_lis_mail (maillist)
41index on list is i_lis_group (group)
42index on list is i_lis_gid (gid)
43modify i_lis_gid to btree
44
45modify imembers to cbtree on member_id, member_type
46index on imembers is i_imem_list (list_id)
47modify i_imem_list to hash
48
49modify strings to cbtree unique on string_id
50index on strings is i_str_name (string)
51modify i_str_name to hash
52
53modify nfsphys to cbtree unique on nfsphys_id
54index on nfsphys is i_nfs_mach (mach_id)
55modify i_nfs_mach to btree
56
57modify filesys to cbtree unique on filsys_id
58index on filesys is i_fil_name (label)
59modify i_fil_name to cbtree
60index on filesys is i_fil_mach (mach_id)
61modify i_fil_mach to btree
62index on filesys is i_fil_phys (phys_id)
63modify i_fil_phys to cbtree
64index on filesys is i_fil_grp (owners)
65modify i_fil_grp to btree
66index on filesys is i_fil_user (owner)
67modify i_fil_user to btree
68
69modify fsgroup to cbtree on group_id
70index on fsgroup is i_fsg_filsys (filsys_id)
71modify i_fsg_filsys to btree
72
73modify quota to cbtree on entity_id
74index on quota is i_qot_fil (filsys_id)
75modify i_qot_fil to cbtree
76index on quota is i_qot_phys (phys_id)
77modify i_qot_phys to cbtree
78
79modify zephyr to cbtree unique on class
80
81modify hostaccess to cbtree unique on mach_id
82
83modify printcap to cbtree on name
84index on printcap is i_pcp_mach (mach_id)
85modify i_pcp_mach to btree
86
87modify palladium to cbtree on name
88
89modify capacls to cbtree on tag
This page took 0.197657 seconds and 5 git commands to generate.