github.com/kyma-project/kyma-environment-broker@v0.0.1/migrations/202101131045_add_cls_instances.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS cls_instances (
     2      id varchar(255) PRIMARY KEY,
     3      version integer NOT NULL,
     4      global_account_id varchar(255) NOT NULL,
     5      region varchar(12) NOT NULL,
     6      created_at TIMESTAMPTZ NOT NULL,
     7      removed_by_skr_instance_id varchar(255),
     8      UNIQUE (global_account_id, removed_by_skr_instance_id));
     9  
    10  CREATE TABLE IF NOT EXISTS cls_instance_references (
    11      id SERIAL,
    12      cls_instance_id varchar(255) NOT NULL,
    13      skr_instance_id varchar(255) NOT NULL,
    14      FOREIGN KEY(cls_instance_id) REFERENCES cls_instances(id) ON DELETE CASCADE);