X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/blobdiff_plain/2a69e049ea7ae9e5d00272a59ec9f6dbc942a85e..81826b3d893d2049be87e8a5445394cb50029d26:/db/dbopt.sql

diff --git a/db/dbopt.sql b/db/dbopt.sql
index d3b3a5ac..1a18065a 100644
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -17,6 +17,7 @@ create index i_mac_loc on machine (location);
 create index i_mac_snet on machine (snet_id);
 create index i_mac_hwaddr on machine (hwaddr);
 create index i_mac_owner on machine (owner_id);
+create index i_mac_acctnumber on machine(account_number);
 
 create unique index i_hal_name on hostalias  (name);
 create index i_hal_id on hostalias (mach_id);
@@ -45,6 +46,7 @@ create index i_lis_group on  list (grouplist);
 create index i_lis_gid on  list (gid);
 create index i_lis_nfsgroup on list (nfsgroup);
 create index i_lis_acl on list (acl_id);
+create index i_lis_memacl on list (memacl_id);
 
 create index i_imem_mid on imembers (member_id, member_type);
 create index i_imem_list on  imembers (list_id);
@@ -83,3 +85,13 @@ create index i_prn_loc on printers (location);
 create index i_prn_con on printers (contact);
 
 create index i_cap_tag on capacls (tag);
+
+create index i_usersids_usid on usersids (users_id);
+
+create index i_listsids_lid on listsids (list_id);
+
+create unique index i_containers_cntid on containers (cnt_id);
+create unique index i_containers_cname on containers (cname);
+
+create unique index i_mcntmap_machid on mcntmap (mach_id);
+create index i_mcntmap_cntid on mcntmap (cnt_id);