a.sql

create table RebuilderProcess (
    id integer not null auto_increment,
    finsihDTTM datetime,
    hql varchar(255),
    lastCompleted integer,
    lastUpdatedDTTM datetime,
    log TEXT,
    numberCompleted integer,
    startDTTM datetime not null,
    status varchar(255),
    totalNumberToProcess integer,
    primary key (id)
) ENGINE=InnoDB;

create table RebuilderProcess_failedIds (
    RebuilderProcess_id integer not null,
    failedIds integer
) ENGINE=InnoDB;

alter table RebuilderProcess_failedIds
    add index FKB532FA6358C189E (RebuilderProcess_id),
    add constraint FKB532FA6358C189E
    foreign key (RebuilderProcess_id)
    references RebuilderProcess (id);