source: trunk/third/moira/db/dbopt.sql @ 25198

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