     MESSAGE_ID              NUMBER(8) NOT NULL,
     DELIVERER_TYPE_NAME     VARCHAR2(500) NOT NULL,
     DELIVERER_SYSTEM_ID     VARCHAR2(300),
-    DELIVERY_STATUS         VARCHAR2(15) NOT NULL,
-    LOCKED_DATE             TIMESTAMP NULL,
+    DELIVERY_STATUS         VARCHAR2(15) NOT NULL, 
     DB_LOCK_VER_NBR         INTEGER DEFAULT 0 NOT NULL,
+
     CONSTRAINT KCB_MSG_DELIVS_PK PRIMARY KEY (ID)
 )
 /

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

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