Files
paralus/persistence/migrations/admindb/000025_sentry_kubeconfig_setting.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

22 lines
957 B
SQL

CREATE TABLE IF NOT EXISTS sentry_kubeconfig_setting (
id uuid default uuid_generate_v4() PRIMARY KEY,
organization_id uuid NOT NULL,
partner_id uuid NOT NULL,
account_id uuid NOT NULL,
scope character varying(256) NOT NULL,
validity_seconds integer NOT NULL DEFAULT 0,
sa_validity_seconds integer NOT NULL DEFAULT 0,
created_at timestamp WITH time zone NOT NULL,
modified_at timestamp WITH time zone,
deleted_at timestamp WITH time zone,
enforce_rsid boolean default false,
disable_all_audit boolean default false,
disable_cmd_audit boolean default false,
is_sso_user boolean default false,
disable_web_kubectl boolean default false,
disable_cli_kubectl boolean default false,
enable_privaterelay boolean default false,
enforce_orgadmin_secret_access boolean default false,
CONSTRAINT sentry_kubeconfig_setting_acc_org_sso_key UNIQUE (organization_id, account_id, is_sso_user)
);