Add containers table and mcntmp table.

[moira.git] / db / dbopt.sql

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 2e4b573275c75d2c7a311bea98c74c73f9ff9191..dd4e2d49c53a7ca9debf1097ae73638e00608934 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -88,3 +88,9 @@ 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);