diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2020-03-22 15:09:49 +0000 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2020-03-22 15:09:49 +0000 |
commit | f2dfd9ee819afb07bf11bd36a5f9d23009be0d39 (patch) | |
tree | edd9468dc9c6c55f9882175fd83a1aadec22edf0 /spec/fixtures | |
parent | 058c34839488502fcec48d805b83728f928a318c (diff) | |
download | gitlab-ce-f2dfd9ee819afb07bf11bd36a5f9d23009be0d39.tar.gz |
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'spec/fixtures')
-rw-r--r-- | spec/fixtures/gitlab/database/structure_example.sql | 96 | ||||
-rw-r--r-- | spec/fixtures/gitlab/database/structure_example_cleaned.sql | 44 |
2 files changed, 140 insertions, 0 deletions
diff --git a/spec/fixtures/gitlab/database/structure_example.sql b/spec/fixtures/gitlab/database/structure_example.sql new file mode 100644 index 00000000000..9f288e6067e --- /dev/null +++ b/spec/fixtures/gitlab/database/structure_example.sql @@ -0,0 +1,96 @@ +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; + +-- +-- Name: pg_trgm; Type: EXTENSION; Schema: -; Owner: - +-- + +CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; + + +-- +-- Name: EXTENSION pg_trgm; Type: COMMENT; Schema: -; Owner: - +-- + +COMMENT ON EXTENSION pg_trgm IS 'text similarity measurement and index searching based on trigrams'; + + +SET default_tablespace = ''; + +SET default_with_oids = false; + +-- +-- Name: abuse_reports; Type: TABLE; Schema: public; Owner: - +-- + +CREATE TABLE public.abuse_reports ( + id integer NOT NULL, + reporter_id integer, + user_id integer, + message text, + created_at timestamp without time zone, + updated_at timestamp without time zone, + message_html text, + cached_markdown_version integer +); + + +-- +-- Name: abuse_reports_id_seq; Type: SEQUENCE; Schema: public; Owner: - +-- + +CREATE SEQUENCE public.abuse_reports_id_seq + AS integer + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + + +-- +-- Name: abuse_reports id; Type: DEFAULT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY public.abuse_reports ALTER COLUMN id SET DEFAULT nextval('public.abuse_reports_id_seq'::regclass); + + +-- +-- +-- Name: abuse_reports abuse_reports_pkey; Type: CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY public.abuse_reports + ADD CONSTRAINT abuse_reports_pkey PRIMARY KEY (id); + +-- +-- Name: index_abuse_reports_on_user_id; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_abuse_reports_on_user_id ON public.abuse_reports USING btree (user_id); + + + +INSERT INTO "schema_migrations" (version) VALUES +('20200305121159'), +('20200306095654'), +('20200306160521'), +('20200306170211'), +('20200306170321'), +('20200306170531'), +('20200309140540'), +('20200309195209'), +('20200309195710'), +('20200310132654'), +('20200310135823'); + + diff --git a/spec/fixtures/gitlab/database/structure_example_cleaned.sql b/spec/fixtures/gitlab/database/structure_example_cleaned.sql new file mode 100644 index 00000000000..78120fa6ce0 --- /dev/null +++ b/spec/fixtures/gitlab/database/structure_example_cleaned.sql @@ -0,0 +1,44 @@ +SET search_path=public; + +CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; + +CREATE EXTENSION IF NOT EXISTS pg_trgm WITH SCHEMA public; + +CREATE TABLE public.abuse_reports ( + id integer NOT NULL, + reporter_id integer, + user_id integer, + message text, + created_at timestamp without time zone, + updated_at timestamp without time zone, + message_html text, + cached_markdown_version integer +); + +CREATE SEQUENCE public.abuse_reports_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + +ALTER TABLE ONLY public.abuse_reports ALTER COLUMN id SET DEFAULT nextval('public.abuse_reports_id_seq'::regclass); + +ALTER TABLE ONLY public.abuse_reports + ADD CONSTRAINT abuse_reports_pkey PRIMARY KEY (id); + +CREATE INDEX index_abuse_reports_on_user_id ON public.abuse_reports USING btree (user_id); + +INSERT INTO "schema_migrations" (version) VALUES +('20200305121159'), +('20200306095654'), +('20200306160521'), +('20200306170211'), +('20200306170321'), +('20200306170531'), +('20200309140540'), +('20200309195209'), +('20200309195710'), +('20200310132654'), +('20200310135823'); + |