]>
Commit | Line | Data |
---|---|---|
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 | create index i_mac_addr on machine (address);\g | |
20 | modify i_mac_addr to btree;\g | |
21 | create index i_mac_loc on machine (location);\g | |
22 | modify i_mac_loc to btree;\g | |
23 | ;\g | |
24 | modify hostalias to cbtree unique on name;\g | |
25 | create index i_hal_id on hostalias (mach_id);\g | |
26 | modify i_hal_id to btree;\g | |
27 | ;\g | |
28 | modify subnet to btree unique on snet_id;\g | |
29 | create index i_snt_name on subnet (name);\g | |
30 | create index i_snt_saddr on subnet(saddr);\g | |
31 | ;\g | |
32 | modify cluster to cbtree unique on clu_id;\g | |
33 | create index i_clu_name on cluster (name);\g | |
34 | modify i_clu_name to btree;\g | |
35 | ;\g | |
36 | modify mcmap to cbtree on clu_id;\g | |
37 | create index i_mcm_mach on mcmap (mach_id);\g | |
38 | modify i_mcm_mach to cbtree;\g | |
39 | ;\g | |
40 | modify svc to cbtree on clu_id;\g | |
41 | ;\g | |
42 | modify servers to btree on name;\g | |
43 | ;\g | |
44 | modify serverhosts to btree on service;\g | |
45 | create index i_sho_mach on serverhosts (mach_id);\g | |
46 | modify i_sho_mach to cbtree;\g | |
47 | ;\g | |
48 | modify list to cbtree unique on list_id;\g | |
49 | create index i_lis_name on list (name);\g | |
50 | modify i_lis_name to cbtree;\g | |
51 | create index i_lis_mail on list (maillist);\g | |
52 | create index i_lis_group on list (grouplist);\g | |
53 | create index i_lis_gid on list (gid);\g | |
54 | modify i_lis_gid to btree;\g | |
55 | ;\g | |
56 | modify imembers to cbtree on member_id, member_type;\g | |
57 | create index i_imem_list on imembers (list_id);\g | |
58 | modify i_imem_list to hash;\g | |
59 | ;\g | |
60 | modify strings to cbtree unique on string_id;\g | |
61 | create index i_str_name on strings (string);\g | |
62 | modify i_str_name to hash;\g | |
63 | ;\g | |
64 | modify nfsphys to cbtree unique on nfsphys_id;\g | |
65 | create index i_nfs_mach on nfsphys (mach_id);\g | |
66 | modify i_nfs_mach to btree;\g | |
67 | ;\g | |
68 | modify filesys to cbtree unique on filsys_id;\g | |
69 | create index i_fil_name on filesys (label);\g | |
70 | modify i_fil_name to cbtree;\g | |
71 | create index i_fil_mach on filesys (mach_id);\g | |
72 | modify i_fil_mach to btree;\g | |
73 | create index i_fil_phys on filesys (phys_id);\g | |
74 | modify i_fil_phys to cbtree;\g | |
75 | create index i_fil_grp on filesys (owners);\g | |
76 | modify i_fil_grp to btree;\g | |
77 | create index i_fil_user on filesys (owner);\g | |
78 | modify i_fil_user to btree;\g | |
79 | ;\g | |
80 | modify fsgroup to cbtree on group_id;\g | |
81 | create index i_fsg_filsys on fsgroup (filsys_id);\g | |
82 | modify i_fsg_filsys to btree;\g | |
83 | ;\g | |
84 | modify quota to cbtree on entity_id;\g | |
85 | create index i_qot_fil on quota (filsys_id);\g | |
86 | modify i_qot_fil to cbtree;\g | |
87 | create index i_qot_phys on quota (phys_id);\g | |
88 | modify i_qot_phys to cbtree;\g | |
89 | ;\g | |
90 | modify zephyr to cbtree unique on class;\g | |
91 | ;\g | |
92 | modify hostaccess to cbtree unique on mach_id;\g | |
93 | ;\g | |
94 | modify printcap to cbtree on name;\g | |
95 | create index i_pcp_mach on printcap (mach_id);\g | |
96 | modify i_pcp_mach to btree;\g | |
97 | ;\g | |
98 | modify palladium to cbtree on name;\g | |
99 | ;\g | |
100 | modify capacls to cbtree on tag;\g |