diff options
Diffstat (limited to 'db/structure.sql')
-rw-r--r-- | db/structure.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/db/structure.sql b/db/structure.sql index f5a8d4f9f16..19eec2aea26 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -9266,6 +9266,7 @@ CREATE TABLE public.application_settings ( wiki_page_max_content_bytes bigint DEFAULT 52428800 NOT NULL, elasticsearch_indexed_file_size_limit_kb integer DEFAULT 1024 NOT NULL, enforce_namespace_storage_limit boolean DEFAULT false NOT NULL, + container_registry_delete_tags_service_timeout integer DEFAULT 250 NOT NULL, CONSTRAINT check_51700b31b5 CHECK ((char_length(default_branch_name) <= 255)), CONSTRAINT check_9c6c447a13 CHECK ((char_length(maintenance_mode_message) <= 255)), CONSTRAINT check_d03919528d CHECK ((char_length(container_registry_vendor) <= 255)), @@ -9479,6 +9480,32 @@ CREATE TABLE public.ar_internal_metadata ( updated_at timestamp(6) without time zone NOT NULL ); +CREATE TABLE public.atlassian_identities ( + user_id bigint NOT NULL, + created_at timestamp with time zone NOT NULL, + updated_at timestamp with time zone NOT NULL, + expires_at timestamp with time zone, + extern_uid text NOT NULL, + encrypted_token bytea, + encrypted_token_iv bytea, + encrypted_refresh_token bytea, + encrypted_refresh_token_iv bytea, + CONSTRAINT atlassian_identities_refresh_token_iv_length_constraint CHECK ((octet_length(encrypted_refresh_token_iv) <= 12)), + CONSTRAINT atlassian_identities_refresh_token_length_constraint CHECK ((octet_length(encrypted_refresh_token) <= 512)), + CONSTRAINT atlassian_identities_token_iv_length_constraint CHECK ((octet_length(encrypted_token_iv) <= 12)), + CONSTRAINT atlassian_identities_token_length_constraint CHECK ((octet_length(encrypted_token) <= 2048)), + CONSTRAINT check_32f5779763 CHECK ((char_length(extern_uid) <= 255)) +); + +CREATE SEQUENCE public.atlassian_identities_user_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + +ALTER SEQUENCE public.atlassian_identities_user_id_seq OWNED BY public.atlassian_identities.user_id; + CREATE TABLE public.audit_events ( id integer NOT NULL, author_id integer NOT NULL, @@ -16880,6 +16907,8 @@ ALTER TABLE ONLY public.approver_groups ALTER COLUMN id SET DEFAULT nextval('pub ALTER TABLE ONLY public.approvers ALTER COLUMN id SET DEFAULT nextval('public.approvers_id_seq'::regclass); +ALTER TABLE ONLY public.atlassian_identities ALTER COLUMN user_id SET DEFAULT nextval('public.atlassian_identities_user_id_seq'::regclass); + ALTER TABLE ONLY public.audit_events ALTER COLUMN id SET DEFAULT nextval('public.audit_events_id_seq'::regclass); ALTER TABLE ONLY public.award_emoji ALTER COLUMN id SET DEFAULT nextval('public.award_emoji_id_seq'::regclass); @@ -17800,6 +17829,9 @@ ALTER TABLE ONLY public.approvers ALTER TABLE ONLY public.ar_internal_metadata ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key); +ALTER TABLE ONLY public.atlassian_identities + ADD CONSTRAINT atlassian_identities_pkey PRIMARY KEY (user_id); + ALTER TABLE ONLY public.audit_events_part_5fc467ac26 ADD CONSTRAINT audit_events_part_5fc467ac26_pkey PRIMARY KEY (id, created_at); @@ -19237,6 +19269,8 @@ CREATE INDEX index_approvers_on_target_id_and_target_type ON public.approvers US CREATE INDEX index_approvers_on_user_id ON public.approvers USING btree (user_id); +CREATE UNIQUE INDEX index_atlassian_identities_on_extern_uid ON public.atlassian_identities USING btree (extern_uid); + CREATE INDEX index_audit_events_on_entity_id_entity_type_id_desc_author_id ON public.audit_events USING btree (entity_id, entity_type, id DESC, author_id); CREATE INDEX index_award_emoji_on_awardable_type_and_awardable_id ON public.award_emoji USING btree (awardable_type, awardable_id); @@ -23097,6 +23131,9 @@ ALTER TABLE ONLY public.resource_weight_events ALTER TABLE ONLY public.design_management_designs ADD CONSTRAINT fk_rails_bfe283ec3c FOREIGN KEY (issue_id) REFERENCES public.issues(id) ON DELETE CASCADE; +ALTER TABLE ONLY public.atlassian_identities + ADD CONSTRAINT fk_rails_c02928bc18 FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE; + ALTER TABLE ONLY public.serverless_domain_cluster ADD CONSTRAINT fk_rails_c09009dee1 FOREIGN KEY (pages_domain_id) REFERENCES public.pages_domains(id) ON DELETE CASCADE; |