db.migration.V1__create_schema.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of shared-smysql-service-broker Show documentation

Open Service Broker API for an existing shared MySQL

There is a newer version: 0.0.5

Show newest version

CREATE TABLE IF NOT EXISTS service_instance (
  `instance_id` VARCHAR(36) NOT NULL,
  `db_name`     VARCHAR(36) NOT NULL,
  `created_at`  TIMESTAMP   NOT NULL DEFAULT now(),
  PRIMARY KEY (`instance_id`)
)
  ENGINE InnoDB;

CREATE TABLE IF NOT EXISTS service_instance_binding (
  `instance_id` VARCHAR(36) NOT NULL,
  `binding_id`  VARCHAR(36) NOT NULL,
  `username`    VARCHAR(36) NOT NULL,
  `created_at`  TIMESTAMP   NOT NULL DEFAULT now(),
  PRIMARY KEY (`instance_id`, `binding_id`),
  CONSTRAINT FOREIGN KEY (instance_id) REFERENCES service_instance (instance_id)
    ON DELETE CASCADE
)
  ENGINE InnoDB;