Make DEFAULT of memacl_type in list table be 'NONE' so people with old

clients don't shoot themselves in the foot.

diff --git a/db/schema.sql b/db/schema.sql
index 7f29c800b88f4c787b2a9dd0110d4db52c31831b..f29d21356dc9baaf0d7e1da6b6b111ac0058d4cf 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -142,7 +142,7 @@ create table list
        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_type     VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
        memacl_id       INTEGER         DEFAULT 0       NOT NULL,
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,
@@ -264,6 +264,8 @@ create table zephyr
        iws_id          INTEGER         DEFAULT 0       NOT NULL,
        iui_type        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        iui_id          INTEGER         DEFAULT 0       NOT NULL,
+       owner_type      VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       owner_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