]>
Commit | Line | Data |
---|---|---|
644e96a1 | 1 | modify users to cbtree unique on users_id;\g |
2 | create index i_usr_login on users (login);\g | |
3 | modify i_usr_login to btree;\g | |
4 | create index i_usr_name on users (first, last);\g | |
5 | modify i_usr_name to cbtree on first, last;\g | |
6 | create index i_usr_last on users (last, first);\g | |
7 | modify i_usr_last to cbtree on last, first;\g | |
8 | create index i_usr_uid on users (uid);\g | |
9 | modify i_usr_uid to btree;\g | |
10 | create index i_usr_pop on users (pop_id);\g | |
11 | ;\g | |
12 | modify krbmap to btree unique on users_id;\g | |
13 | create index i_krb_str on krbmap (string_id);\g | |
14 | modify i_krb_str to btree;\g | |
15 | ;\g | |
16 | modify machine to cbtree unique on mach_id;\g | |
17 | create index i_mac_name on machine (name);\g | |
18 | modify i_mac_name to btree;\g | |
19 | ;\g | |
230c2fd2 | 20 | modify hostalias to cbtree unique on name;\g |
21 | create index i_hal_id on hostalias (mach_id);\g | |
22 | ;\g | |
23 | modify subnet to btree unique on snet_id;\g | |
24 | create index i_snt_name on subnet (name);\g | |
25 | ;\g | |
644e96a1 | 26 | modify cluster to cbtree unique on clu_id;\g |
27 | create index i_clu_name on cluster (name);\g | |
28 | modify i_clu_name to btree;\g | |
29 | ;\g | |
30 | modify mcmap to cbtree on clu_id;\g | |
31 | create index i_mcm_mach on mcmap (mach_id);\g | |
32 | modify i_mcm_mach to cbtree;\g | |
33 | ;\g | |
34 | modify svc to cbtree on clu_id;\g | |
35 | ;\g | |
36 | modify servers to btree on name;\g | |
37 | ;\g | |
38 | modify serverhosts to btree on service;\g | |
39 | create index i_sho_mach on serverhosts (mach_id);\g | |
40 | modify i_sho_mach to cbtree;\g | |
41 | ;\g | |
42 | modify list to cbtree unique on list_id;\g | |
43 | create index i_lis_name on list (name);\g | |
44 | modify i_lis_name to cbtree;\g | |
45 | create index i_lis_mail on list (maillist);\g | |
46 | create index i_lis_group on list (grouplist);\g | |
47 | create index i_lis_gid on list (gid);\g | |
48 | modify i_lis_gid to btree;\g | |
49 | ;\g | |
50 | modify imembers to cbtree on member_id, member_type;\g | |
51 | create index i_imem_list on imembers (list_id);\g | |
52 | modify i_imem_list to hash;\g | |
53 | ;\g | |
54 | modify strings to cbtree unique on string_id;\g | |
55 | create index i_str_name on strings (string);\g | |
56 | modify i_str_name to hash;\g | |
57 | ;\g | |
58 | modify nfsphys to cbtree unique on nfsphys_id;\g | |
59 | create index i_nfs_mach on nfsphys (mach_id);\g | |
60 | modify i_nfs_mach to btree;\g | |
61 | ;\g | |
62 | modify filesys to cbtree unique on filsys_id;\g | |
63 | create index i_fil_name on filesys (label);\g | |
64 | modify i_fil_name to cbtree;\g | |
65 | create index i_fil_mach on filesys (mach_id);\g | |
66 | modify i_fil_mach to btree;\g | |
67 | create index i_fil_phys on filesys (phys_id);\g | |
68 | modify i_fil_phys to cbtree;\g | |
69 | create index i_fil_grp on filesys (owners);\g | |
70 | modify i_fil_grp to btree;\g | |
71 | create index i_fil_user on filesys (owner);\g | |
72 | modify i_fil_user to btree;\g | |
73 | ;\g | |
74 | modify fsgroup to cbtree on group_id;\g | |
75 | create index i_fsg_filsys on fsgroup (filsys_id);\g | |
76 | modify i_fsg_filsys to btree;\g | |
77 | ;\g | |
78 | modify quota to cbtree on entity_id;\g | |
79 | create index i_qot_fil on quota (filsys_id);\g | |
80 | modify i_qot_fil to cbtree;\g | |
81 | create index i_qot_phys on quota (phys_id);\g | |
82 | modify i_qot_phys to cbtree;\g | |
83 | ;\g | |
84 | modify zephyr to cbtree unique on class;\g | |
85 | ;\g | |
86 | modify hostaccess to cbtree unique on mach_id;\g | |
87 | ;\g | |
88 | modify printcap to cbtree on name;\g | |
89 | create index i_pcp_mach on printcap (mach_id);\g | |
90 | modify i_pcp_mach to btree;\g | |
91 | ;\g | |
92 | modify palladium to cbtree on name;\g | |
93 | ;\g | |
94 | modify capacls to cbtree on tag;\g |