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);
9 create unique index i_krb_usid on krbmap (users_id);
10 create index i_krb_str on krbmap (string_id);
12 create unique index i_mac_mid on machine (mach_id);
13 create index i_mac_name on machine (name);
14 create index i_mac_addr on machine (address);
15 create index i_mac_loc on machine (location);
16 create index i_mac_snet on machine (snet_id);
18 create unique index i_hal_name on hostalias (name);
19 create index i_hal_id on hostalias (mach_id);
21 create unique index i_snt_sid on subnet (snet_id);
22 create index i_snt_name on subnet (name);
23 create index i_snt_saddr on subnet(saddr);
25 create unique index i_clu_clid on clusters (clu_id);
26 create index i_clu_name on clusters (name);
28 create index i_mcm_clid on mcmap (clu_id);
29 create index i_mcm_mach on mcmap (mach_id);
31 create index i_svc_clid on svc (clu_id);
33 create index i_srv_name on servers (name);
35 create index i_sho_srv on serverhosts (service);
36 create index i_sho_mach on serverhosts (mach_id);
38 create unique index i_lis_lid on list (list_id);
39 create index i_lis_name on list (name);
40 create index i_lis_mail on list (maillist);
41 create index i_lis_group on list (grouplist);
42 create index i_lis_gid on list (gid);
43 create index i_lis_acl on list (acl_id);
45 create index i_imem_mid on imembers (member_id, member_type);
46 create index i_imem_list on imembers (list_id);
48 create unique index i_str_sid on strings (string_id);
49 create index i_str_name on strings (string);
51 create unique index i_nfs_nid on nfsphys (nfsphys_id);
52 create index i_nfs_mach on nfsphys (mach_id);
54 create unique index i_fil_fid on filesys (filsys_id);
55 create index i_fil_name on filesys (label);
56 create index i_fil_mach on filesys (mach_id);
57 create index i_fil_phys on filesys (phys_id);
58 create index i_fil_grp on filesys (owners);
59 create index i_fil_user on filesys (owner);
61 create index i_fsg_gid on fsgroup (group_id);
62 create index i_fsg_filsys on fsgroup (filsys_id);
64 create index i_qot_eid on quota (entity_id);
65 create index i_qot_fil on quota (filsys_id);
66 create index i_qot_phys on quota (phys_id);
68 create unique index i_zph_class on zephyr (class);
70 create unique index i_hac_mid on hostaccess (mach_id);
72 create index i_pcp_name on printcap (name);
73 create index i_pcp_mach on printcap (mach_id);
75 create index i_plad_name on palladium (name);
77 create index i_cap_tag on capacls (tag);