--
--

-- Started on 2015-09-22 12:00:11 VET


--
-- TOC entry 167 (class 3079 OID 11645)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 1886 (class 0 OID 0)
-- Dependencies: 167
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';





--
-- TOC entry 162 (class 1259 OID 17070)
-- Dependencies: 5
-- Name: signatures; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
--

CREATE TABLE signatures (
    signature_id integer NOT NULL,
    type character(4) NOT NULL
);


ALTER TABLE public.signatures OWNER TO aaraujo;

--
-- TOC entry 166 (class 1259 OID 17086)
-- Dependencies: 5
-- Name: signatures_error; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
--

CREATE TABLE signatures_error (
    signature_error_id integer NOT NULL,
    type character(4) NOT NULL
);


ALTER TABLE public.signatures_error OWNER TO aaraujo;

--
-- TOC entry 165 (class 1259 OID 17084)
-- Dependencies: 166 5
-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
--

CREATE SEQUENCE signatures_error_signature_error_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.signatures_error_signature_error_id_seq OWNER TO aaraujo;

--
-- TOC entry 1887 (class 0 OID 0)
-- Dependencies: 165
-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
--

ALTER SEQUENCE signatures_error_signature_error_id_seq OWNED BY signatures_error.signature_error_id;


--
-- TOC entry 161 (class 1259 OID 17068)
-- Dependencies: 5 162
-- Name: signatures_signature_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
--

CREATE SEQUENCE signatures_signature_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.signatures_signature_id_seq OWNER TO aaraujo;

--
-- TOC entry 1888 (class 0 OID 0)
-- Dependencies: 161
-- Name: signatures_signature_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
--

ALTER SEQUENCE signatures_signature_id_seq OWNED BY signatures.signature_id;


--
-- TOC entry 164 (class 1259 OID 17078)
-- Dependencies: 5
-- Name: verifications; Type: TABLE; Schema: public; Owner: aaraujo; Tablespace: 
--

CREATE TABLE verifications (
    verification_id integer NOT NULL,
    type character(4) NOT NULL
);


ALTER TABLE public.verifications OWNER TO aaraujo;

--
-- TOC entry 163 (class 1259 OID 17076)
-- Dependencies: 164 5
-- Name: verifications_verification_id_seq; Type: SEQUENCE; Schema: public; Owner: aaraujo
--

CREATE SEQUENCE verifications_verification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.verifications_verification_id_seq OWNER TO aaraujo;

--
-- TOC entry 1889 (class 0 OID 0)
-- Dependencies: 163
-- Name: verifications_verification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: aaraujo
--

ALTER SEQUENCE verifications_verification_id_seq OWNED BY verifications.verification_id;


--
-- TOC entry 1763 (class 2604 OID 17073)
-- Dependencies: 162 161 162
-- Name: signature_id; Type: DEFAULT; Schema: public; Owner: aaraujo
--

ALTER TABLE ONLY signatures ALTER COLUMN signature_id SET DEFAULT nextval('signatures_signature_id_seq'::regclass);


--
-- TOC entry 1765 (class 2604 OID 17089)
-- Dependencies: 165 166 166
-- Name: signature_error_id; Type: DEFAULT; Schema: public; Owner: aaraujo
--

ALTER TABLE ONLY signatures_error ALTER COLUMN signature_error_id SET DEFAULT nextval('signatures_error_signature_error_id_seq'::regclass);


--
-- TOC entry 1764 (class 2604 OID 17081)
-- Dependencies: 164 163 164
-- Name: verification_id; Type: DEFAULT; Schema: public; Owner: aaraujo
--

ALTER TABLE ONLY verifications ALTER COLUMN verification_id SET DEFAULT nextval('verifications_verification_id_seq'::regclass);


--
-- TOC entry 1874 (class 0 OID 17070)
-- Dependencies: 162 1879
-- Data for Name: signatures; Type: TABLE DATA; Schema: public; Owner: aaraujo
--

COPY signatures (signature_id, type) FROM stdin;
\.


--
-- TOC entry 1878 (class 0 OID 17086)
-- Dependencies: 166 1879
-- Data for Name: signatures_error; Type: TABLE DATA; Schema: public; Owner: aaraujo
--

COPY signatures_error (signature_error_id, type) FROM stdin;
\.


--
-- TOC entry 1890 (class 0 OID 0)
-- Dependencies: 165
-- Name: signatures_error_signature_error_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
--

SELECT pg_catalog.setval('signatures_error_signature_error_id_seq', 1, false);


--
-- TOC entry 1891 (class 0 OID 0)
-- Dependencies: 161
-- Name: signatures_signature_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
--

SELECT pg_catalog.setval('signatures_signature_id_seq', 1, false);


--
-- TOC entry 1876 (class 0 OID 17078)
-- Dependencies: 164 1879
-- Data for Name: verifications; Type: TABLE DATA; Schema: public; Owner: aaraujo
--

COPY verifications (verification_id, type) FROM stdin;
\.


--
-- TOC entry 1892 (class 0 OID 0)
-- Dependencies: 163
-- Name: verifications_verification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: aaraujo
--

SELECT pg_catalog.setval('verifications_verification_id_seq', 1, false);


--
-- TOC entry 1771 (class 2606 OID 17091)
-- Dependencies: 166 166 1880
-- Name: signatures_error_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
--

ALTER TABLE ONLY signatures_error
    ADD CONSTRAINT signatures_error_pkey PRIMARY KEY (signature_error_id);


--
-- TOC entry 1767 (class 2606 OID 17075)
-- Dependencies: 162 162 1880
-- Name: signatures_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
--

ALTER TABLE ONLY signatures
    ADD CONSTRAINT signatures_pkey PRIMARY KEY (signature_id);


--
-- TOC entry 1769 (class 2606 OID 17083)
-- Dependencies: 164 164 1880
-- Name: verifications_pkey; Type: CONSTRAINT; Schema: public; Owner: aaraujo; Tablespace: 
--

ALTER TABLE ONLY verifications
    ADD CONSTRAINT verifications_pkey PRIMARY KEY (verification_id);


--
-- TOC entry 1885 (class 0 OID 0)
-- Dependencies: 5
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2015-09-22 12:00:11 VET

--
--

