CREATE TABLE bm_cm_bs_search_preferences (
    ID                    NUMBER(18, 0) ,
    USER_ID               NUMBER(18, 0)     NOT NULL,
    PROCESS_ID            NUMBER(18, 0)     NOT NULL,
    OBJECT_ID             NUMBER(18, 0)     NOT NULL,
    RESOURCE_TYPE         VARCHAR2(1020),
    RESOURCE_OBJECT       VARCHAR2(1020),
    CUSTOMIZATION_NAME    VARCHAR2(1020),
    DATE_ADDED            DATE              NOT NULL,
    DATE_MODIFIED         DATE              NOT NULL,
    ID                    NUMBER(18, 0) ,
    USER_ID               NUMBER(18, 0)     NOT NULL,
    PROCESS_ID            NUMBER(18, 0)     NOT NULL,
    OBJECT_ID             NUMBER(18, 0)     NOT NULL,
    RESOURCE_TYPE         VARCHAR2(1020),
    RESOURCE_OBJECT       VARCHAR2(1020),
    CUSTOMIZATION_NAME    VARCHAR2(1020),
    DATE_ADDED            DATE              NOT NULL,
    DATE_MODIFIED         DATE              NOT NULL,
    CONSTRAINT pk_bm_cm_bs_search_preferences PRIMARY KEY (ID, ID)
);
