text: 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 client_min_messages = warning;
  SET row_security = off;
  
  SET default_tablespace = '';
  
  SET default_with_oids = false;
  
  --
  -- Name: ar_internal_metadata; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.ar_internal_metadata (
      key character varying NOT NULL,
      value character varying,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: countries; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.countries (
      id bigint NOT NULL,
      name text,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL,
      code character varying
  );
  
  
  --
  -- Name: countries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.countries_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: countries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.countries_id_seq OWNED BY public.countries.id;
  
  
  --
  -- Name: match_predictions; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.match_predictions (
      id bigint NOT NULL,
      match_id bigint,
      home_team_goals integer,
      away_team_goals integer,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL,
      user_id bigint
  );
  
  
  --
  -- Name: match_predictions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.match_predictions_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: match_predictions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.match_predictions_id_seq OWNED BY public.match_predictions.id;
  
  
  --
  -- Name: matches; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.matches (
      id bigint NOT NULL,
      home_team_id bigint,
      away_team_id bigint,
      home_team_goals integer,
      away_team_goals integer,
      kick_off timestamp without time zone NOT NULL,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: matches_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.matches_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: matches_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.matches_id_seq OWNED BY public.matches.id;
  
  
  --
  -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.schema_migrations (
      version character varying NOT NULL
  );
  
  
  --
  -- Name: users; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.users (
      id bigint NOT NULL,
      name character varying,
      email character varying,
      password_digest character varying,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.users_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
  
  
  --
  -- Name: countries id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.countries ALTER COLUMN id SET DEFAULT nextval('public.countries_id_seq'::regclass);
  
  
  --
  -- Name: match_predictions id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.match_predictions ALTER COLUMN id SET DEFAULT nextval('public.match_predictions_id_seq'::regclass);
  
  
  --
  -- Name: matches id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.matches ALTER COLUMN id SET DEFAULT nextval('public.matches_id_seq'::regclass);
  
  
  --
  -- Name: users id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
  
  
  --
  -- Name: ar_internal_metadata ar_internal_metadata_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.ar_internal_metadata
      ADD CONSTRAINT ar_internal_metadata_pkey PRIMARY KEY (key);
  
  
  --
  -- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.countries
      ADD CONSTRAINT countries_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: match_predictions match_predictions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.match_predictions
      ADD CONSTRAINT match_predictions_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: matches matches_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.matches
      ADD CONSTRAINT matches_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.schema_migrations
      ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);
  
  
  --
  -- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.users
      ADD CONSTRAINT users_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: index_countries_on_name; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_countries_on_name ON public.countries USING btree (name);
  
  
  --
  -- Name: match_predictions fk_rails_3a1a5bea14; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.match_predictions
      ADD CONSTRAINT fk_rails_3a1a5bea14 FOREIGN KEY (user_id) REFERENCES public.users(id);
  
  
  --
  -- Name: matches fk_rails_4aed6bdf0d; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.matches
      ADD CONSTRAINT fk_rails_4aed6bdf0d FOREIGN KEY (home_team_id) REFERENCES public.countries(id);
  
  
  --
  -- Name: matches fk_rails_6a75121a9b; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.matches
      ADD CONSTRAINT fk_rails_6a75121a9b FOREIGN KEY (away_team_id) REFERENCES public.countries(id);
  
  
  --
  -- Name: match_predictions fk_rails_b872f36908; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.match_predictions
      ADD CONSTRAINT fk_rails_b872f36908 FOREIGN KEY (match_id) REFERENCES public.matches(id);
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  SET search_path TO "$user", public;
  
  INSERT INTO "schema_migrations" (version) VALUES
  ('20190308145819'),
  ('20190308151146'),
  ('20190308161201'),
  ('20190308162201'),
  ('20190308163045'),
  ('20190315141216'),
  ('20190329151024'),
  ('20190407082444'),
  ('20190407082839'),
  ('20190407185703');
  
  
  