--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:01:31 CAT

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 333 (class 1259 OID 17333)
-- Name: programstage; Type: TABLE; Schema: public; Owner: dhis; Tablespace: 
--

CREATE TABLE programstage (
    programstageid integer NOT NULL,
    uid character varying(11),
    code character varying(50),
    created timestamp without time zone,
    lastupdated timestamp without time zone,
    name character varying(230),
    description character varying(255),
    mindaysfromstart integer NOT NULL,
    programid integer,
    irregular boolean,
    dataentryformid integer,
    standardinterval integer,
    reportdatedescription character varying(255),
    autogenerateevent boolean,
    validcompleteonly boolean,
    displaygenerateeventbox boolean,
    capturecoordinates boolean,
    generatedbyenrollmentdate boolean,
    blockentryform boolean,
    remindcompleted boolean,
    allowgeneratenextvisit boolean,
    openafterenrollment boolean,
    reportdatetouse character varying(255),
    pregenerateuid boolean
);


ALTER TABLE public.programstage OWNER TO dhis;

--
-- TOC entry 2986 (class 0 OID 17333)
-- Dependencies: 333
-- Data for Name: programstage; Type: TABLE DATA; Schema: public; Owner: dhis
--

COPY programstage (programstageid, uid, code, created, lastupdated, name, description, mindaysfromstart, programid, irregular, dataentryformid, standardinterval, reportdatedescription, autogenerateevent, validcompleteonly, displaygenerateeventbox, capturecoordinates, generatedbyenrollmentdate, blockentryform, remindcompleted, allowgeneratenextvisit, openafterenrollment, reportdatetouse, pregenerateuid) FROM stdin;
561	ZHScYfgW1HR	\N	2014-07-24 14:50:22.687	2014-09-17 15:47:17.622	Transport Permit Data Input	Transport Permit Data Input	0	560	f	567	\N	Report date	t	t	f	f	f	f	f	f	f	\N	f
345	yMWsGlnS5el	\N	2014-07-16 14:32:04.534	2014-09-01 17:31:42.872	Restoration Activity Data	Restoration Activity Data	0	342	f	1454	\N	Report date	t	f	f	t	f	f	f	f	f	\N	\N
2163	jU4APnFZSyG	\N	2014-09-08 18:26:11.807	2014-09-17 11:31:16.897	Single-Event Test	Test	0	2162	f	2165	\N	Report date	t	f	f	f	f	f	f	f	f	\N	f
1441	O6kuhQjsj9b	\N	2014-08-01 10:42:10.775	2014-09-11 12:30:19.163	Reforestation Permit Data Entry	Reforestation activity via Exploitation/Cut Permit for DFOs	0	1440	f	\N	\N	Report date	t	f	f	t	f	f	f	f	f	\N	\N
328	fXIhuB7grSL	\N	2014-07-16 10:13:54.023	2014-09-17 14:52:22.844	Forest Activity Data Input	Forest activity data collected on-site	0	327	f	331	\N	Report Date	t	t	f	t	f	f	f	f	f	\N	f
2594	cT3s07Q8iQt	\N	2014-09-17 14:54:59.734	2014-09-17 14:59:25.409	Single-Event Forestry Sector Company	Register of forestry sector companies	0	2593	f	\N	\N	Registration date	t	f	f	f	f	f	f	f	f	\N	f
\.


--
-- TOC entry 2875 (class 2606 OID 17340)
-- Name: programstage_pkey; Type: CONSTRAINT; Schema: public; Owner: dhis; Tablespace: 
--

ALTER TABLE ONLY programstage
    ADD CONSTRAINT programstage_pkey PRIMARY KEY (programstageid);


--
-- TOC entry 2877 (class 2606 OID 19979)
-- Name: programstage_uid_key; Type: CONSTRAINT; Schema: public; Owner: dhis; Tablespace: 
--

ALTER TABLE ONLY programstage
    ADD CONSTRAINT programstage_uid_key UNIQUE (uid);


--
-- TOC entry 2879 (class 2606 OID 19294)
-- Name: fk_programstage_dataentryform; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY programstage
    ADD CONSTRAINT fk_programstage_dataentryform FOREIGN KEY (dataentryformid) REFERENCES dataentryform(dataentryformid);


--
-- TOC entry 2878 (class 2606 OID 19289)
-- Name: fk_programstage_program; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY programstage
    ADD CONSTRAINT fk_programstage_program FOREIGN KEY (programid) REFERENCES program(programid);


-- Completed on 2014-09-18 13:01:31 CAT

--
-- PostgreSQL database dump complete
--