Add mailman (boolean) and mailman_id (a mach_id) to the list table, for

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 02bfa0239120fb487ea3e34d537b82cf8bf8176d..afaf054d24267d23f317797b75697c9cef48070a 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -147,6 +147,8 @@ create table list
        grouplist       INTEGER         DEFAULT 0       NOT NULL,
        gid             SMALLINT        DEFAULT 0       NOT NULL,
        nfsgroup        INTEGER         DEFAULT 0       NOT NULL,       
+       mailman         INTEGER         DEFAULT 0       NOT NULL,
+       mailman_id      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,