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

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 361e7babee08e168ba4f4a20d1cce7499b177f3f..e249f591e6a3673e657ff0a0c1e04887e3058e09 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -124,7 +124,7 @@ create table svc
 (
        clu_id          INTEGER         DEFAULT 0       NOT NULL,
        serv_label      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       serv_cluster    VARCHAR(32)     DEFAULT CHR(0)  NOT NULL
+       serv_cluster    VARCHAR(128)    DEFAULT CHR(0)  NOT NULL
 );
 
 create table list
@@ -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,