 CREATE TABLE KCB_MESSAGES
 (
     ID                  NUMBER(8) NOT NULL,
-    ORIGIN_ID           VARCHAR2(128) NULL,
     DELIVERY_TYPE       VARCHAR2(500) NOT NULL,
     CREATED_DATETIME    TIMESTAMP NOT NULL,
     TITLE               VARCHAR2(255) NULL,

    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)
)
/

    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_MSG_DELIVS
ADD CONSTRAINT KCB_MSG_DELIVS_UK1 UNIQUE
