Checked in owner_type, owner_id columns to zephyr table in last commit.

Change default for owner_type to be 'NONE' to not eit old clients.

diff --git a/db/schema.sql b/db/schema.sql
index f29d21356dc9baaf0d7e1da6b6b111ac0058d4cf..2b7ffaf8d4a5dcd3ac4e524dd31c4d9d1576a9a0 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -264,7 +264,7 @@ 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_type      VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
        owner_id        INTEGER         DEFAULT 0       NOT NULL,
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,