text: --
  -- PostgreSQL database dump
  --
  
  -- Dumped from database version 10.15 (Debian 10.15-1.pgdg90+1)
  -- Dumped by pg_dump version 13.1
  
  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 = '';
  
  --
  -- Name: asns; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE public.asns (
      id integer NOT NULL,
      system_number integer NOT NULL,
      system_organization character varying(254) NOT NULL,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  ALTER TABLE public.asns OWNER TO postgres;
  
  --
  -- Name: asns_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  --
  
  CREATE SEQUENCE public.asns_id_seq
      AS integer
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE public.asns_id_seq OWNER TO postgres;
  
  --
  -- Name: asns_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  --
  
  ALTER SEQUENCE public.asns_id_seq OWNED BY public.asns.id;
  
  
  --
  -- Name: ips; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE public.ips (
      id integer NOT NULL,
      address character varying(254) NOT NULL,
      address_type character varying(254) NOT NULL,
      asn_id integer,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  ALTER TABLE public.ips OWNER TO postgres;
  
  --
  -- Name: ips_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  --
  
  CREATE SEQUENCE public.ips_id_seq
      AS integer
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE public.ips_id_seq OWNER TO postgres;
  
  --
  -- Name: ips_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  --
  
  ALTER SEQUENCE public.ips_id_seq OWNED BY public.ips.id;
  
  
  --
  -- Name: migration_versions; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE public.migration_versions (
      id integer NOT NULL,
      version character varying(17) NOT NULL
  );
  
  
  ALTER TABLE public.migration_versions OWNER TO postgres;
  
  --
  -- Name: migration_versions_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  --
  
  CREATE SEQUENCE public.migration_versions_id_seq
      AS integer
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE public.migration_versions_id_seq OWNER TO postgres;
  
  --
  -- Name: migration_versions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  --
  
  ALTER SEQUENCE public.migration_versions_id_seq OWNED BY public.migration_versions.id;
  
  
  --
  -- Name: syncs; Type: TABLE; Schema: public; Owner: postgres
  --
  
  CREATE TABLE public.syncs (
      id integer NOT NULL,
      date character varying(254) NOT NULL,
      file_name character varying(254) NOT NULL,
      created_at timestamp without time zone NOT NULL,
      updated_at timestamp without time zone NOT NULL
  );
  
  
  ALTER TABLE public.syncs OWNER TO postgres;
  
  --
  -- Name: syncs_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
  --
  
  CREATE SEQUENCE public.syncs_id_seq
      AS integer
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  ALTER TABLE public.syncs_id_seq OWNER TO postgres;
  
  --
  -- Name: syncs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
  --
  
  ALTER SEQUENCE public.syncs_id_seq OWNED BY public.syncs.id;
  
  
  --
  -- Name: asns id; Type: DEFAULT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.asns ALTER COLUMN id SET DEFAULT nextval('public.asns_id_seq'::regclass);
  
  
  --
  -- Name: ips id; Type: DEFAULT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.ips ALTER COLUMN id SET DEFAULT nextval('public.ips_id_seq'::regclass);
  
  
  --
  -- Name: migration_versions id; Type: DEFAULT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.migration_versions ALTER COLUMN id SET DEFAULT nextval('public.migration_versions_id_seq'::regclass);
  
  
  --
  -- Name: syncs id; Type: DEFAULT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.syncs ALTER COLUMN id SET DEFAULT nextval('public.syncs_id_seq'::regclass);
  
  
  --
  -- Name: asns asns_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.asns
      ADD CONSTRAINT asns_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: ips ips_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.ips
      ADD CONSTRAINT ips_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: migration_versions migration_versions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.migration_versions
      ADD CONSTRAINT migration_versions_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: syncs syncs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.syncs
      ADD CONSTRAINT syncs_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: ips fk_cr_6d0a7e933f; Type: FK CONSTRAINT; Schema: public; Owner: postgres
  --
  
  ALTER TABLE ONLY public.ips
      ADD CONSTRAINT fk_cr_6d0a7e933f FOREIGN KEY (asn_id) REFERENCES public.asns(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  