[1623] in Moira
better list acls
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Mon Aug 7 04:53:40 2000
Message-Id: <200008070853.EAA16775@alice-whacker.mit.edu>
To: moiradev@MIT.EDU
Date: Mon, 07 Aug 2000 04:53:38 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Following are a series of 4 messages that implements the
suggestion in moira[1155]; to add a membership acl to the lists table,
which would be used as an acl for the add/delete member queries, but
nothing else. The first message is the schema changes.
Garry
Index: dbopt.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/dbopt.sql,v
retrieving revision 1.11
diff -c -r1.11 dbopt.sql
*** dbopt.sql 2000/04/19 23:16:02 1.11
--- dbopt.sql 2000/08/07 07:28:25
***************
*** 45,50 ****
--- 45,51 ----
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);
Index: schema.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/schema.sql,v
retrieving revision 1.16
diff -c -r1.16 schema.sql
*** schema.sql 2000/04/21 19:47:07 1.16
--- schema.sql 2000/08/07 04:35:36
***************
*** 142,147 ****
--- 142,149 ----
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
