create table HSEARCH_AGENT (
       id bigint not null,
        type integer,
        name varchar(255),
        expiration timestamp,
        state integer,
        totalShardCount integer,
        assignedShardIndex integer,
        payload blob(255),
        primary key (id)
    )
Hibernate: 
    
    create table HSEARCH_OUTBOX_EVENT (
       id bigint not null,
        entityName varchar(256),
        entityId varchar(256),
        entityIdHash integer,
        payload blob(255),
        retries integer,
        processAfter timestamp,
        status integer,
        primary key (id)
    )