final SchemaUpdate schemaUpdate = new SchemaUpdate();

            schemaUpdate.setDelimiter(schemaProperties.getDelimiter());
            schemaUpdate.setFormat(schemaProperties.getFormat());
            schemaUpdate.setOutputFile(getHibernateScriptOutputFilename(database, true));
            schemaUpdate.execute(EnumSet.of(TargetType.SCRIPT), getHibernateConfiguration(database, null));

    create table external_care_product (

       DTYPE varchar(31) not null,

        id bigint not null,

        code varchar(255) not null,

        created_by varchar(255),

        created_date datetime,

        last_modified_by varchar(255),

        last_modified_date datetime,

        external_service_id varchar(255),

        external_service_name varchar(255),

        external_service_provider varchar(255),

        care_product_id bigint,

        primary key (id)

    ) engine=InnoDB;

 

    alter table external_care_product

       drop constraint UK_c91alca5s7iub60faehho1u54;

 

    alter table external_care_product

       add constraint UK_c91alca5s7iub60faehho1u54 unique (code);