Add containers table and mcntmp table.

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);

diff --git a/db/schema.sql b/db/schema.sql
index b756465c72b72596f07367e1367ae3bef0afb6ee..1b21ade712434e0e8810feeb83b00977ea5fb3ab 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -395,3 +395,25 @@ create table listsids
        sid             VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        created         DATE            DEFAULT SYSDATE NOT NULL
 );
+
+create table containers
+(
+       name            VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
+       cnt_id          INTEGER         DEFAULT 0       NOT NULL,
+       description     VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
+       location        VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
+       contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       acl_type        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       acl_id          INTEGER         DEFAULT 0       NOT NULL,
+       memacl_type     VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
+       memacl_id       INTEGER         DEFAULT 0       NOT NULL,
+       modtime         DATE            DEFAULT SYSDATE NOT NULL,
+       modby           INTEGER         DEFAULT 0       NOT NULL,
+       modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
+);
+
+create table mcntmap
+(
+       mach_id         INTEGER         DEFAULT 0       NOT NULL,
+       cnt_id          INTEGER         DEFAULT 0       NOT NULL
+);

diff --git a/db/unschema.sql b/db/unschema.sql
index eb40dbeba7b77af820fcb852c94c57541dfafcd6..5d90174a6a323be1a6b1893d3f29a9cefb7f21e3 100644 (file)
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -28,3 +28,5 @@ drop table tblstats;
 drop table incremental;
 drop table usersids;
 drop table listsids;
+drop table containers;
+drop table mcntmap;