Remove usersids and listsids tables.

[moira.git] / db / dbopt.sql

diff --git a/db/dbopt.sql b/db/dbopt.sql
index df88c025870413d360aa678b3099aacd6b469dc1..0ae04b42cbf26b04a15c9e9427517649d348909e 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -5,6 +5,7 @@ create index i_usr_last on  users (last, first);
 create index i_usr_uid on  users (unix_uid);
 create index i_usr_pop on  users (pop_id);
 create index i_usr_clearid on users (clearid);
+create index i_usr_resv on users (reservations);
 
 create unique index i_krb_usid on krbmap  (users_id);
 create index i_krb_str on  krbmap (string_id);
@@ -14,6 +15,9 @@ create index i_mac_name on  machine (name);
 create index i_mac_addr on machine (address);
 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);
@@ -40,13 +44,15 @@ create index i_lis_name on  list (name);
 create index i_lis_mail on  list (maillist);
 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);
 
 create unique index i_str_sid on strings  (string_id);
-create index i_str_name on  strings (string);
+create unique index i_str_name on  strings (string);
 
 create unique index i_nfs_nid on nfsphys  (nfsphys_id);
 create index i_nfs_mach on  nfsphys (mach_id);
@@ -69,9 +75,19 @@ create unique index i_zph_class on zephyr  (class);
 
 create unique index i_hac_mid on hostaccess  (mach_id);
 
-create index i_pcp_name on printcap (name);
-create index i_pcp_mach on  printcap (mach_id);
+create index i_acl_mt on acl (mach_id, target);
 
-create index i_plad_name on palladium (name);
+create index i_prn_name on printers (name);
+create index i_prn_dname on printers (duplexname);
+create index i_prn_mach on printers (mach_id);
+create index i_prn_rm on printers (rm);
+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 unique index i_containers_cntid on containers (cnt_id);
+create unique index i_containers_cname on containers (name);
+
+create unique index i_mcntmap_machid on mcntmap (mach_id);
+create index i_mcntmap_cntid on mcntmap (cnt_id);