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 xmloption = content;
  SET client_min_messages = warning;
  SET row_security = off;
  
  SET default_tablespace = '';
  
  SET default_table_access_method = heap;
  
  --
  -- Name: active_storage_attachments; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.active_storage_attachments (
      id bigint NOT NULL,
      name character varying NOT NULL,
      record_type character varying NOT NULL,
      record_id bigint NOT NULL,
      blob_id bigint NOT NULL,
      created_at timestamp without time zone NOT NULL
  );
  
  
  --
  -- Name: active_storage_attachments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.active_storage_attachments_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: active_storage_attachments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.active_storage_attachments_id_seq OWNED BY public.active_storage_attachments.id;
  
  
  --
  -- Name: active_storage_blobs; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.active_storage_blobs (
      id bigint NOT NULL,
      key character varying NOT NULL,
      filename character varying NOT NULL,
      content_type character varying,
      metadata text,
      byte_size bigint NOT NULL,
      checksum character varying NOT NULL,
      created_at timestamp without time zone NOT NULL,
      service_name character varying NOT NULL
  );
  
  
  --
  -- Name: active_storage_blobs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.active_storage_blobs_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: active_storage_blobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.active_storage_blobs_id_seq OWNED BY public.active_storage_blobs.id;
  
  
  --
  -- Name: active_storage_variant_records; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.active_storage_variant_records (
      id bigint NOT NULL,
      blob_id bigint NOT NULL,
      variation_digest character varying NOT NULL
  );
  
  
  --
  -- Name: active_storage_variant_records_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.active_storage_variant_records_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: active_storage_variant_records_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.active_storage_variant_records_id_seq OWNED BY public.active_storage_variant_records.id;
  
  
  --
  -- 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(6) without time zone NOT NULL,
      updated_at timestamp(6) without time zone NOT NULL
  );
  
  
  --
  -- Name: episodes; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.episodes (
      id bigint NOT NULL,
      number integer NOT NULL,
      title character varying NOT NULL,
      subtitle character varying,
      author character varying,
      summary character varying,
      description text NOT NULL,
      credits text,
      script text,
      published_at timestamp without time zone,
      processed boolean DEFAULT false NOT NULL,
      mp3_size bigint,
      aac_size bigint,
      explicit boolean DEFAULT false NOT NULL,
      blocked boolean DEFAULT false NOT NULL,
      fulltext_search tsvector,
      created_at timestamp(6) without time zone NOT NULL,
      updated_at timestamp(6) without time zone NOT NULL
  );
  
  
  --
  -- Name: episodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.episodes_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: episodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.episodes_id_seq OWNED BY public.episodes.id;
  
  
  --
  -- Name: jwt_denylist; Type: TABLE; Schema: public; Owner: -
  --
  
  CREATE TABLE public.jwt_denylist (
      id bigint NOT NULL,
      jti character varying NOT NULL,
      created_at timestamp(6) without time zone NOT NULL,
      updated_at timestamp(6) without time zone NOT NULL
  );
  
  
  --
  -- Name: jwt_denylist_id_seq; Type: SEQUENCE; Schema: public; Owner: -
  --
  
  CREATE SEQUENCE public.jwt_denylist_id_seq
      START WITH 1
      INCREMENT BY 1
      NO MINVALUE
      NO MAXVALUE
      CACHE 1;
  
  
  --
  -- Name: jwt_denylist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
  --
  
  ALTER SEQUENCE public.jwt_denylist_id_seq OWNED BY public.jwt_denylist.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,
      username character varying(50) NOT NULL,
      password_digest character varying NOT NULL,
      created_at timestamp(6) without time zone NOT NULL,
      updated_at timestamp(6) 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: active_storage_attachments id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_attachments ALTER COLUMN id SET DEFAULT nextval('public.active_storage_attachments_id_seq'::regclass);
  
  
  --
  -- Name: active_storage_blobs id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_blobs ALTER COLUMN id SET DEFAULT nextval('public.active_storage_blobs_id_seq'::regclass);
  
  
  --
  -- Name: active_storage_variant_records id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_variant_records ALTER COLUMN id SET DEFAULT nextval('public.active_storage_variant_records_id_seq'::regclass);
  
  
  --
  -- Name: episodes id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.episodes ALTER COLUMN id SET DEFAULT nextval('public.episodes_id_seq'::regclass);
  
  
  --
  -- Name: jwt_denylist id; Type: DEFAULT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.jwt_denylist ALTER COLUMN id SET DEFAULT nextval('public.jwt_denylist_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: active_storage_attachments active_storage_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_attachments
      ADD CONSTRAINT active_storage_attachments_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: active_storage_blobs active_storage_blobs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_blobs
      ADD CONSTRAINT active_storage_blobs_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: active_storage_variant_records active_storage_variant_records_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_variant_records
      ADD CONSTRAINT active_storage_variant_records_pkey PRIMARY KEY (id);
  
  
  --
  -- 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: episodes episodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.episodes
      ADD CONSTRAINT episodes_pkey PRIMARY KEY (id);
  
  
  --
  -- Name: jwt_denylist jwt_denylist_pkey; Type: CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.jwt_denylist
      ADD CONSTRAINT jwt_denylist_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: episodes_fulltext_search; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX episodes_fulltext_search ON public.episodes USING gin (fulltext_search);
  
  
  --
  -- Name: episodes_index_action; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX episodes_index_action ON public.episodes USING btree (published_at, number);
  
  
  --
  -- Name: episodes_number_unique; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX episodes_number_unique ON public.episodes USING btree (number);
  
  
  --
  -- Name: index_active_storage_attachments_on_blob_id; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX index_active_storage_attachments_on_blob_id ON public.active_storage_attachments USING btree (blob_id);
  
  
  --
  -- Name: index_active_storage_attachments_uniqueness; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_active_storage_attachments_uniqueness ON public.active_storage_attachments USING btree (record_type, record_id, name, blob_id);
  
  
  --
  -- Name: index_active_storage_blobs_on_key; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_active_storage_blobs_on_key ON public.active_storage_blobs USING btree (key);
  
  
  --
  -- Name: index_active_storage_variant_records_uniqueness; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_active_storage_variant_records_uniqueness ON public.active_storage_variant_records USING btree (blob_id, variation_digest);
  
  
  --
  -- Name: index_jwt_denylist_on_created_at; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE INDEX index_jwt_denylist_on_created_at ON public.jwt_denylist USING btree (created_at);
  
  
  --
  -- Name: index_jwt_denylist_on_jti; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_jwt_denylist_on_jti ON public.jwt_denylist USING btree (jti);
  
  
  --
  -- Name: index_users_on_username; Type: INDEX; Schema: public; Owner: -
  --
  
  CREATE UNIQUE INDEX index_users_on_username ON public.users USING btree (username);
  
  
  --
  -- Name: episodes episodes_fulltext_update_trigger; Type: TRIGGER; Schema: public; Owner: -
  --
  
  CREATE TRIGGER episodes_fulltext_update_trigger BEFORE INSERT OR UPDATE ON public.episodes FOR EACH ROW EXECUTE FUNCTION tsvector_update_trigger('fulltext_search', 'pg_catalog.english', 'title', 'description', 'script');
  
  
  --
  -- Name: active_storage_variant_records fk_rails_993965df05; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_variant_records
      ADD CONSTRAINT fk_rails_993965df05 FOREIGN KEY (blob_id) REFERENCES public.active_storage_blobs(id);
  
  
  --
  -- Name: active_storage_attachments fk_rails_c3b3935057; Type: FK CONSTRAINT; Schema: public; Owner: -
  --
  
  ALTER TABLE ONLY public.active_storage_attachments
      ADD CONSTRAINT fk_rails_c3b3935057 FOREIGN KEY (blob_id) REFERENCES public.active_storage_blobs(id);
  
  
  --
  -- PostgreSQL database dump complete
  --
  
  SET search_path TO "$user", public;
  
  INSERT INTO "schema_migrations" (version) VALUES
  ('1'),
  ('2'),
  ('20201214221630'),
  ('20201214221631'),
  ('20211216061829'),
  ('3'),
  ('4');
  
  
  