From a7868226aa04e18eea6ec91d7d0cd78a027fb63d Mon Sep 17 00:00:00 2001 From: zacheiss Date: Thu, 10 Aug 2000 02:20:54 +0000 Subject: [PATCH] Schema changes for membership acls. --- db/dbopt.sql | 1 + db/schema.sql | 2 ++ 2 files changed, 3 insertions(+) diff --git a/db/dbopt.sql b/db/dbopt.sql index d3b3a5ac..70384ac3 100644 --- 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 df67571f..7f29c800 100644 --- 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 -- 2.45.2