 
 ALTER TABLE ONLY public.certificates_oplog
     ADD CONSTRAINT certificates_pkey PRIMARY KEY (oid);
-
-
---
--- Name: chapter_guidances_chapters chapter_guidances_chapters_pkey; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.chapter_guidances_chapters
-    ADD CONSTRAINT chapter_guidances_chapters_pkey PRIMARY KEY (id);
-
-
---
--- Name: chapter_guidances chapter_guidances_pkey; Type: CONSTRAINT; Schema: public; Owner: -
---
-
-ALTER TABLE ONLY public.chapter_guidances
-    ADD CONSTRAINT chapter_guidances_pkey PRIMARY KEY (id);
 
 
 --

-- Name: certificates_oid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.certificates_oid_seq OWNED BY public.certificates_oplog.oid;


--
-- Name: chapter_guidances; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.chapter_guidances (
    id integer NOT NULL,
    title text,
    url text,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: chapter_guidances_chapters; Type: TABLE; Schema: public; Owner: -
--

CREATE TABLE public.chapter_guidances_chapters (
    id integer NOT NULL,
    chapter_id integer,
    chapter_guidance_id integer,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone NOT NULL
);


--
-- Name: chapter_guidances_chapters_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.chapter_guidances_chapters_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: chapter_guidances_chapters_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.chapter_guidances_chapters_id_seq OWNED BY public.chapter_guidances_chapters.id;


--
-- Name: chapter_guidances_id_seq; Type: SEQUENCE; Schema: public; Owner: -
--

CREATE SEQUENCE public.chapter_guidances_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- Name: chapter_guidances_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
--

ALTER SEQUENCE public.chapter_guidances_id_seq OWNED BY public.chapter_guidances.id;


--
-- Name: chapter_notes; Type: TABLE; Schema: public; Owner: -

INSERT INTO "schema_migrations" ("filename") VALUES ('20180828074852_add_complete_abrogation_regulation_id_column.rb');
INSERT INTO "schema_migrations" ("filename") VALUES ('20181003140819_add_updated_at_to_sections.rb');
INSERT INTO "schema_migrations" ("filename") VALUES ('20181029112658_change_size_to_six_for_measure_type_id.rb');
INSERT INTO "schema_migrations" ("filename") VALUES ('20181211165412_create_guides.rb');
