diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2021-07-07 03:07:23 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2021-07-07 03:07:23 +0300 |
commit | 3462d7613fb761a4cbf2904c6980fd39b6f8bd5f (patch) | |
tree | 62d64c80f804f3cee283de4642c089d327ed61b8 /db/ci_structure.sql | |
parent | c47ade2adb94e4c33f87b4b825c92c7fe61ef044 (diff) |
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'db/ci_structure.sql')
-rw-r--r-- | db/ci_structure.sql | 96 |
1 files changed, 10 insertions, 86 deletions
diff --git a/db/ci_structure.sql b/db/ci_structure.sql index 16e2d25e507..1b898012f46 100644 --- a/db/ci_structure.sql +++ b/db/ci_structure.sql @@ -1,35 +1,11 @@ -SET statement_timeout = 0; -SET lock_timeout = 0; -SET idle_in_transaction_session_timeout = 0; -SET client_encoding = 'UTF8'; -SET standard_conforming_strings = on; -SELECT pg_catalog.set_config('search_path', '', false); -SET check_function_bodies = false; -SET xmloption = content; -SET client_min_messages = warning; -SET row_security = off; - -SET default_tablespace = ''; - -SET default_table_access_method = heap; - --- --- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.ar_internal_metadata ( +CREATE TABLE ar_internal_metadata ( key character varying NOT NULL, value character varying, created_at timestamp(6) without time zone NOT NULL, updated_at timestamp(6) without time zone NOT NULL ); - --- --- Name: ci_instance_variables; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.ci_instance_variables ( +CREATE TABLE ci_instance_variables ( id bigint NOT NULL, variable_type smallint DEFAULT 1 NOT NULL, masked boolean DEFAULT false, @@ -42,80 +18,28 @@ CREATE TABLE public.ci_instance_variables ( CONSTRAINT check_956afd70f1 CHECK ((char_length(encrypted_value) <= 13579)) ); - --- --- Name: ci_instance_variables_id_seq; Type: SEQUENCE; Schema: public; Owner: - --- - -CREATE SEQUENCE public.ci_instance_variables_id_seq +CREATE SEQUENCE ci_instance_variables_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; +ALTER SEQUENCE ci_instance_variables_id_seq OWNED BY ci_instance_variables.id; --- --- Name: ci_instance_variables_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - --- - -ALTER SEQUENCE public.ci_instance_variables_id_seq OWNED BY public.ci_instance_variables.id; - - --- --- Name: schema_migrations; Type: TABLE; Schema: public; Owner: - --- - -CREATE TABLE public.schema_migrations ( +CREATE TABLE schema_migrations ( version character varying NOT NULL ); +ALTER TABLE ONLY ci_instance_variables ALTER COLUMN id SET DEFAULT nextval('ci_instance_variables_id_seq'::regclass); --- --- Name: ci_instance_variables id; Type: DEFAULT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.ci_instance_variables ALTER COLUMN id SET DEFAULT nextval('public.ci_instance_variables_id_seq'::regclass); - - --- --- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.ar_internal_metadata +ALTER TABLE ONLY ar_internal_metadata ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key); - --- --- Name: ci_instance_variables ci_instance_variables_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.ci_instance_variables +ALTER TABLE ONLY ci_instance_variables ADD CONSTRAINT ci_instance_variables_pkey PRIMARY KEY (id); - --- --- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: - --- - -ALTER TABLE ONLY public.schema_migrations +ALTER TABLE ONLY schema_migrations ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version); - --- --- Name: index_ci_instance_variables_on_key; Type: INDEX; Schema: public; Owner: - --- - -CREATE UNIQUE INDEX index_ci_instance_variables_on_key ON public.ci_instance_variables USING btree (key); - - --- --- PostgreSQL database dump complete --- - -SET search_path TO "$user", public; - -INSERT INTO "schema_migrations" (version) VALUES -('20210617101848'); - - +CREATE UNIQUE INDEX index_ci_instance_variables_on_key ON ci_instance_variables USING btree (key); |