--
-- PostgreSQL database dump
--

-- Dumped from database version 9.2.8
-- Dumped by pg_dump version 9.2.8
-- Started on 2014-09-18 13:00:52 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 323 (class 1259 OID 17274)
-- Name: program; Type: TABLE; Schema: public; Owner: dhis; Tablespace: 
--

CREATE TABLE program (
    programid 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) NOT NULL,
    description text,
    version integer,
    dateofenrollmentdescription text,
    dateofincidentdescription text,
    type integer,
    displayincidentdate boolean,
    onlyenrollonce boolean,
    ignoreoverdueevents boolean,
    displayonallorgunit boolean,
    selectenrollmentdatesinfuture boolean,
    selectincidentdatesinfuture boolean,
    relationshiptext character varying(255),
    relationshiptypeid integer,
    relationshipfroma boolean,
    relatedprogramid integer,
    dataentrymethod boolean,
    trackedentityid integer,
    userid integer,
    publicaccess character varying(8)
);


ALTER TABLE public.program OWNER TO dhis;

--
-- TOC entry 2988 (class 0 OID 17274)
-- Dependencies: 323
-- Data for Name: program; Type: TABLE DATA; Schema: public; Owner: dhis
--

COPY program (programid, uid, code, created, lastupdated, name, description, version, dateofenrollmentdescription, dateofincidentdescription, type, displayincidentdate, onlyenrollonce, ignoreoverdueevents, displayonallorgunit, selectenrollmentdatesinfuture, selectincidentdatesinfuture, relationshiptext, relationshiptypeid, relationshipfroma, relatedprogramid, dataentrymethod, trackedentityid, userid, publicaccess) FROM stdin;
342	CpiDHghr3VQ	\N	2014-07-16 14:30:09.604	2014-09-08 14:15:33.409	Forest Restoration	Follow-up of restoration activities	1	Event Creation Date	Restoration Start Date	2	t	f	f	t	t	f		\N	f	\N	f	479	47	rw------
1440	Rz3Kk3wc7Hr	\N	2014-08-01 10:42:10.686	2014-09-09 11:52:10.282	Reforestation Permit	Reforestation via Exploitation/Cut Permit	1	Enrollment Date	Incident Date	3	f	f	f	f	f	f		\N	f	\N	f	\N	47	rw------
327	a0CGF6Asy1r	\N	2014-07-16 10:13:54.013	2014-07-24 15:42:35.913	On-site Forest Activity	Forest activity data collected on site	1	Enrollment Date	Incident Date	3	f	f	f	f	f	f		\N	f	\N	f	\N	47	rw------
560	ZxpBxMexQLW	\N	2014-07-24 14:50:22.677	2014-07-24 15:42:46.89	Transport Permit	Transport Permit	1	Enrollment Date	Incident Date	3	f	f	f	f	f	f		\N	f	\N	f	\N	47	rw------
2162	vXLf22l8BYp	\N	2014-09-08 18:26:11.785	2014-09-08 18:34:31.669	Test2	Test	1	Enrollment Date	Incident Date	3	f	f	f	f	f	f		\N	f	\N	f	\N	47	rw------
2593	Y2OQ6y3JDay	\N	2014-09-17 14:54:59.663	2014-09-17 14:56:50.018	Forestry Sector Company	Register of forestry sector companies	1	Enrollment Date	Incident Date	3	f	f	f	f	f	f		\N	f	\N	f	\N	47	rw------
\.


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

ALTER TABLE ONLY program
    ADD CONSTRAINT program_pkey PRIMARY KEY (programid);


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

ALTER TABLE ONLY program
    ADD CONSTRAINT program_uid_key UNIQUE (uid);


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

ALTER TABLE ONLY program
    ADD CONSTRAINT fk_program_relatedprogram FOREIGN KEY (relatedprogramid) REFERENCES program(programid);


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

ALTER TABLE ONLY program
    ADD CONSTRAINT fk_program_relationshipid FOREIGN KEY (relationshiptypeid) REFERENCES relationshiptype(relationshiptypeid);


--
-- TOC entry 2880 (class 2606 OID 19199)
-- Name: fk_program_trackedentityid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY program
    ADD CONSTRAINT fk_program_trackedentityid FOREIGN KEY (trackedentityid) REFERENCES trackedentity(trackedentityid);


--
-- TOC entry 2881 (class 2606 OID 19204)
-- Name: fk_program_userid; Type: FK CONSTRAINT; Schema: public; Owner: dhis
--

ALTER TABLE ONLY program
    ADD CONSTRAINT fk_program_userid FOREIGN KEY (userid) REFERENCES userinfo(userinfoid);


-- Completed on 2014-09-18 13:00:53 CAT

--
-- PostgreSQL database dump complete
--