--liquibase formatted sql

--changeset akif.khan:3 runOnChange:false

CREATE TABLE IF NOT EXISTS `ClientElb` (
  `id` VARCHAR(64) NOT NULL,
  `elbUrl` VARCHAR(100) NOT NULL,
  `createdAt` TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` TIMESTAMP(3) DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
DEFAULT CHARSET=utf8
AUTO_INCREMENT=1;

--rollback drop table ClientElb;

Create DB table for ClientElb Entry
Create DB table for ClientElb Entry

For isolation of Orchestration and Execution environment in Flux,
we need to route client tasks based on events coming in to Flux
Orchestratorto Execution Environment.
Created database table to store Client Elb details viz.Client Elb URL
stored uniquely based on client provided Id which can be used later
to fetch client Elb URL.
