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

    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

INSERT INTO FP_DOC_TYPE_T values ('KGAM', SYS_GUID(), 1, 'KR', 'GROUP ATTRIBUTE', 'N', 'Y', 'N', 0, 'N', 'N')
/
INSERT INTO FP_DOC_TYPE_T values ('KATD', SYS_GUID(), 1, 'KR', 'ATTRIBUTE TYPE', 'N', 'Y', 'N', 0, 'N', 'N')
/
INSERT INTO FP_DOC_TYPE_T values ('KETM', SYS_GUID(), 1, 'KR', 'ENTITY TYPE', 'N', 'Y', 'N', 0, 'N', 'N')
/
-- Concatenating KENBootstrap.sql
-- KEN Core Data --
