Skip to content
Snippets Groups Projects

Change virt services for anthos on-prem infra

Closed Aliaksandr Ramanovich (EPAM) requested to merge GONRG-3975-on-prem-clear-install into master
Files
13
+ 34
0
CREATE SCHEMA "<DATA_PARTITION_ID>";
DROP TABLE IF EXISTS <DATA_PARTITION_ID>."StorageRecord";
CREATE TABLE <DATA_PARTITION_ID>."StorageRecord"(
id text COLLATE pg_catalog."default" NOT NULL,
pk bigint NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
data jsonb NOT NULL,
CONSTRAINT StorageRecord_id UNIQUE (id)
);
CREATE INDEX StorageRecord_datagin ON <DATA_PARTITION_ID>."StorageRecord" USING GIN (data);
-----------------
DROP TABLE IF EXISTS <DATA_PARTITION_ID>."StorageSchema";
CREATE TABLE <DATA_PARTITION_ID>."StorageSchema"(
id text COLLATE pg_catalog."default" NOT NULL,
pk bigint NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
data jsonb NOT NULL,
CONSTRAINT StorageSchema_id UNIQUE (id)
);
CREATE INDEX StorageSchema_datagin ON <DATA_PARTITION_ID>."StorageSchema" USING GIN (data);
------------------
CREATE TABLE <DATA_PARTITION_ID>."LegalTagOsm"(
id text COLLATE pg_catalog."default" NOT NULL,
pk bigint NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
data jsonb NOT NULL,
CONSTRAINT LegalTagOsm_id UNIQUE (id)
);
CREATE INDEX LegalTagOsm_dataGin ON <DATA_PARTITION_ID>."LegalTagOsm" USING GIN (data);
------------------
CREATE TABLE <DATA_PARTITION_ID>."wksMapping"(
id text COLLATE pg_catalog."default" NOT NULL,
pk bigint NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
data jsonb NOT NULL,
CONSTRAINT wksMapping_id UNIQUE (id)
);
CREATE INDEX wksMapping_datagin ON <DATA_PARTITION_ID>."wksMapping" USING GIN (data);
Loading