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