Files
paralus/persistence/migrations/admindb/000024_sentry_kubeconfig_revocation.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

11 lines
448 B
SQL

CREATE TABLE IF NOT EXISTS sentry_kubeconfig_revocation (
id uuid default uuid_generate_v4() PRIMARY KEY,
organization_id uuid NOT NULL,
partner_id uuid NOT NULL,
account_id uuid NOT NULL,
revoked_at timestamp WITH time zone,
created_at timestamp WITH time zone NOT NULL,
is_sso_user boolean default FALSE,
CONSTRAINT sentry_kubeconfig_revocation_acc_org_sso_key UNIQUE (organization_id, account_id, is_sso_user)
);