mirror of
https://github.com/paralus/paralus.git
synced 2026-08-24 15:47:19 +00:00
Akshay Gaikwad
d88c82e0df
Make all admindb migration queries re-entrance so re-running migration would not fail. Signed-off-by: Akshay Gaikwad <akgaikwad001@gmail.com>
26 lines
1.1 KiB
SQL
26 lines
1.1 KiB
SQL
CREATE TABLE IF NOT EXISTS sentry_bootstrap_agent (
|
|
-- database id fields
|
|
id uuid default uuid_generate_v4() PRIMARY KEY,
|
|
name character varying(256) NOT NULL,
|
|
organization_id uuid,
|
|
partner_id uuid,
|
|
project_id uuid,
|
|
template_ref character varying(256) NOT NULL REFERENCES sentry_bootstrap_agent_template(name),
|
|
agent_mode character varying(512) NOT NULL,
|
|
-- paralus meta fields
|
|
display_name character varying(256) NOT NULL,
|
|
created_at timestamp WITH time zone NOT NULL,
|
|
modified_at timestamp WITH time zone,
|
|
deleted_at timestamp with time zone,
|
|
labels jsonb NOT NULL DEFAULT '{}' ::jsonb,
|
|
annotations jsonb NOT NULL DEFAULT '{}' ::jsonb,
|
|
-- bootstrap token spec fields
|
|
token character varying(256) NOT NULL UNIQUE,
|
|
-- bootstrap token status fields
|
|
token_state character varying(256) NOT NULL,
|
|
ip_address character varying(20) NOT NULL,
|
|
last_checked_in timestamp with time zone,
|
|
fingerprint character varying(256) NOT NULL,
|
|
CONSTRAINT sentry_bootstrap_agent_name_templateref_organization_id_partner UNIQUE (name, template_ref, organization_id, partner_id, project_id)
|
|
);
|