     PRODUCER            VARCHAR2(300) NULL,
     CONTENT             CLOB NOT NULL,
     CONTENT_TYPE        VARCHAR2(128) NULL,
-    URL                 VARCHAR2(512) NULL,
     USER_RECIPIENT_ID   VARCHAR2(300) NOT NULL,
     DB_LOCK_VER_NBR     INTEGER DEFAULT 0 NOT NULL,
+
     CONSTRAINT KCB_MESSAGES_PK PRIMARY KEY (ID)
 )
 /

    PROPERTY            VARCHAR2(300) NOT NULL,
    VALUE               VARCHAR2(1000) NOT NULL,
    DB_LOCK_VER_NBR     INTEGER DEFAULT 0 NOT NULL,
    CONSTRAINT KCB_RECIP_PREFS_PK PRIMARY KEY (ID)
)
/
ALTER TABLE KCB_MESSAGES
ADD CONSTRAINT KCB_MESSAGES_UK1 UNIQUE
(
ORIGIN_ID
)
 ENABLE
/
ALTER TABLE KCB_MSG_DELIVS
ADD CONSTRAINT KCB_MSG_DELIVS_UK1 UNIQUE

    CHANNEL             VARCHAR2(300) NOT NULL,
    DELIVERER_NAME      VARCHAR2(300) NOT NULL,
    DB_LOCK_VER_NBR     INTEGER DEFAULT 0 NOT NULL,

    CONSTRAINT KCB_RECIP_DELIVS_PK PRIMARY KEY (ID)
)
/
