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 e93fbedca81381a08d5362ccdb2d51bc5a2de208..d3b3a5ac42c84f819f7ecb246767f8daa4e10bae 100644 (file)
--- 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 35d523953558fd8e75ee6d24004999ab6e89cc2c..e249f591e6a3673e657ff0a0c1e04887e3058e09 100644 (file)
--- 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,