1 | create unique index i_usr_usid on users (users_id); |
---|
2 | create index i_usr_login on users (login); |
---|
3 | create index i_usr_name on users (first, last); |
---|
4 | create index i_usr_last on users (last, first); |
---|
5 | create index i_usr_uid on users (unix_uid); |
---|
6 | create index i_usr_pop on users (pop_id); |
---|
7 | create index i_usr_imap on users (imap_id); |
---|
8 | create index i_usr_exchange on users (exchange_id); |
---|
9 | create index i_usr_clearid on users (clearid); |
---|
10 | create index i_usr_resv on users (reservations); |
---|
11 | create index i_usr_sponsor on users (sponsor_id); |
---|
12 | |
---|
13 | create unique index i_krb_usid on krbmap (users_id); |
---|
14 | create index i_krb_str on krbmap (string_id); |
---|
15 | |
---|
16 | create unique index i_mac_mid on machine (mach_id); |
---|
17 | create index i_mac_name on machine (name); |
---|
18 | create index i_mac_addr on machine (address); |
---|
19 | create index i_mac_loc on machine (location); |
---|
20 | create index i_mac_snet on machine (snet_id); |
---|
21 | create index i_mac_hwaddr on machine (hwaddr); |
---|
22 | create index i_mac_owner on machine (owner_id); |
---|
23 | create index i_mac_acctnumber on machine(account_number); |
---|
24 | |
---|
25 | create unique index i_hal_name on hostalias (name); |
---|
26 | create index i_hal_id on hostalias (mach_id); |
---|
27 | |
---|
28 | create unique index i_snt_sid on subnet (snet_id); |
---|
29 | create index i_snt_name on subnet (name); |
---|
30 | create index i_snt_saddr on subnet(saddr); |
---|
31 | |
---|
32 | create unique index i_clu_clid on clusters (clu_id); |
---|
33 | create index i_clu_name on clusters (name); |
---|
34 | |
---|
35 | create index i_mcm_clid on mcmap (clu_id); |
---|
36 | create index i_mcm_mach on mcmap (mach_id); |
---|
37 | |
---|
38 | create index i_svc_clid on svc (clu_id); |
---|
39 | |
---|
40 | create index i_srv_name on servers (name); |
---|
41 | |
---|
42 | create index i_sho_srv on serverhosts (service); |
---|
43 | create index i_sho_mach on serverhosts (mach_id); |
---|
44 | |
---|
45 | create unique index i_lis_lid on list (list_id); |
---|
46 | create index i_lis_name on list (name); |
---|
47 | create index i_lis_mail on list (maillist); |
---|
48 | create index i_lis_group on list (grouplist); |
---|
49 | create index i_lis_gid on list (gid); |
---|
50 | create index i_lis_nfsgroup on list (nfsgroup); |
---|
51 | create index i_lis_acl on list (acl_id); |
---|
52 | create index i_lis_memacl on list (memacl_id); |
---|
53 | |
---|
54 | create index i_imem_mid on imembers (member_id, member_type); |
---|
55 | create index i_imem_list on imembers (list_id); |
---|
56 | |
---|
57 | create unique index i_str_sid on strings (string_id); |
---|
58 | create unique index i_str_name on strings (string); |
---|
59 | |
---|
60 | create unique index i_nfs_nid on nfsphys (nfsphys_id); |
---|
61 | create index i_nfs_mach on nfsphys (mach_id); |
---|
62 | |
---|
63 | create unique index i_fil_fid on filesys (filsys_id); |
---|
64 | create index i_fil_name on filesys (label); |
---|
65 | create index i_fil_mach on filesys (mach_id); |
---|
66 | create index i_fil_phys on filesys (phys_id); |
---|
67 | create index i_fil_grp on filesys (owners); |
---|
68 | create index i_fil_user on filesys (owner); |
---|
69 | |
---|
70 | create index i_fsg_gid on fsgroup (group_id); |
---|
71 | create index i_fsg_filsys on fsgroup (filsys_id); |
---|
72 | |
---|
73 | create index i_qot_eid on quota (entity_id); |
---|
74 | create index i_qot_fil on quota (filsys_id); |
---|
75 | create index i_qot_phys on quota (phys_id); |
---|
76 | |
---|
77 | create unique index i_zph_class on zephyr (class); |
---|
78 | |
---|
79 | create unique index i_hac_mid on hostaccess (mach_id); |
---|
80 | |
---|
81 | create index i_acl_mt on acl (mach_id, target); |
---|
82 | |
---|
83 | create index i_prn_name on printers (name); |
---|
84 | create index i_prn_dname on printers (duplexname); |
---|
85 | create index i_prn_mach on printers (mach_id); |
---|
86 | create index i_prn_rm on printers (rm); |
---|
87 | create index i_prn_loc on printers (location); |
---|
88 | create index i_prn_con on printers (contact); |
---|
89 | |
---|
90 | create index i_cap_tag on capacls (tag); |
---|
91 | |
---|
92 | create unique index i_containers_cntid on containers (cnt_id); |
---|
93 | create unique index i_containers_cname on containers (name); |
---|
94 | |
---|
95 | create unique index i_mcntmap_machid on mcntmap (mach_id); |
---|
96 | create index i_mcntmap_cntid on mcntmap (cnt_id); |
---|
97 | |
---|
98 | create index i_hwaddrmap_machid on hwaddrmap (mach_id); |
---|
99 | create index i_hwaddrmap_hwaddr on hwaddrmap (hwaddr); |
---|