Create index on account_number column of machine table.

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 4c32efaeca1d6ae3f1d668e0a0dffffd599679ed..1a18065acc118ec210afcea250024ad074757714 100644 (file)
--- 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);
@@ -90,7 +91,7 @@ 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 (name);
+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);