From: zacheiss <zacheiss>
Date: Wed, 19 Apr 2000 23:16:02 +0000 (+0000)
Subject: add an "nfsgroup" column to the lists table, and build an index on it.
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/2a69e049ea7ae9e5d00272a59ec9f6dbc942a85e

add an "nfsgroup" column to the lists table, and build an index on it.
---

diff --git a/db/dbopt.sql b/db/dbopt.sql
index e93fbedc..d3b3a5ac 100644
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -43,6 +43,7 @@ create index i_lis_name on  list (name);
 create index i_lis_mail on  list (maillist);
 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_imem_mid on imembers (member_id, member_type);
diff --git a/db/schema.sql b/db/schema.sql
index 35d52395..e249f591 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -137,6 +137,7 @@ create table list
 	maillist	INTEGER 	DEFAULT 0	NOT NULL,
 	grouplist	INTEGER 	DEFAULT 0	NOT NULL,
 	gid		SMALLINT 	DEFAULT 0	NOT NULL,
+	nfsgroup	INTEGER		DEFAULT 0	NOT NULL,	
 	description	VARCHAR(255) 	DEFAULT CHR(0)	NOT NULL,
 	acl_type	VARCHAR(8) 	DEFAULT CHR(0)	NOT NULL,
 	acl_id		INTEGER		DEFAULT 0	NOT NULL,