Files
paralus/persistence/migrations/admindb/000031_cluster_metro.up.sql
Akshay Gaikwad d88c82e0df fix: re-running admindb migration fails (#205)
Make all admindb migration queries re-entrance so re-running migration
would not fail.

Signed-off-by: Akshay Gaikwad <akgaikwad001@gmail.com>
2023-04-28 14:21:32 +05:30

17 lines
587 B
SQL

CREATE TABLE IF NOT EXISTS cluster_metro (
id uuid default uuid_generate_v4() PRIMARY KEY,
name character varying(256) NOT NULL,
created_at timestamp with time zone NOT NULL,
modified_at timestamp with time zone NOT NULL,
trash boolean NOT NULL default false,
latitude character varying(16) NOT NULL,
longitude character varying(16) NOT NULL,
city character varying(64),
state character varying(64),
country character varying(64),
cc character varying(2),
st character varying(3),
organization_id uuid,
partner_id uuid NOT NULL
);