Schema changes for membership acls.

diff --git a/db/dbopt.sql b/db/dbopt.sql
index d3b3a5ac42c84f819f7ecb246767f8daa4e10bae..70384ac3cc216203ff2d936a93427143c152769f 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -45,6 +45,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);

diff --git a/db/schema.sql b/db/schema.sql
index df67571f549aea8b7c25663bde176a5355de717d..7f29c800b88f4c787b2a9dd0110d4db52c31831b 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -142,6 +142,8 @@ create table list
        description     VARCHAR(255)    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 CHR(0)  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