--
--


SELECT pg_catalog.set_config('search_path', '', false);



--
-- Name: public_nestbox_data_projects; Type: TABLE; Schema: public; Owner: public_nestbox_data_admin
--

CREATE TABLE public.public_nestbox_data_projects (
    obm_id integer NOT NULL,
    name character varying(32),
    description text,
    obm_uploading_id integer
);


ALTER TABLE public.public_nestbox_data_projects OWNER TO public_nestbox_data_admin;

--
-- Name: public_nestbox_data_projects_id_seq; Type: SEQUENCE; Schema: public; Owner: public_nestbox_data_admin
--

CREATE SEQUENCE public.public_nestbox_data_projects_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.public_nestbox_data_projects_id_seq OWNER TO public_nestbox_data_admin;

--
-- Name: public_nestbox_data_projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: public_nestbox_data_admin
--

ALTER SEQUENCE public.public_nestbox_data_projects_id_seq OWNED BY public.public_nestbox_data_projects.obm_id;


--
-- Name: public_nestbox_data_projects obm_id; Type: DEFAULT; Schema: public; Owner: public_nestbox_data_admin
--

ALTER TABLE ONLY public.public_nestbox_data_projects ALTER COLUMN obm_id SET DEFAULT nextval('public.public_nestbox_data_projects_id_seq'::regclass);


--
-- Data for Name: public_nestbox_data_projects; Type: TABLE DATA; Schema: public; Owner: public_nestbox_data_admin
--

INSERT INTO public.public_nestbox_data_projects VALUES (1, 'Sáránd közmunka', '2016-ban Sáránd község önkormányzata által közmunkaprogramban készített előre nyílós 3cm vastag nyárfa deszka odúk a faluban kihelyezve', NULL);
INSERT INTO public.public_nestbox_data_projects VALUES (2, 'DE Evol Zool', 'The nestboxes placed around University of Debrecen by Dept. of Evolotionary Zoology and Human Biology', NULL);
INSERT INTO public.public_nestbox_data_projects VALUES (5, 'Vekeri tó', 'Vekeri tavi erdőmentők', 1328);
INSERT INTO public.public_nestbox_data_projects VALUES (8, 'Jósvafő', 'Jósvafő', 12131);
INSERT INTO public.public_nestbox_data_projects VALUES (9, 'Tokaj', 'Tokaj', 15216);
INSERT INTO public.public_nestbox_data_projects VALUES (4, 'Varga Zsolt', 'Varga Zsolt odúi', NULL);
INSERT INTO public.public_nestbox_data_projects VALUES (6, 'Sinkovics Csenge', 'Sinkovics Csenge odútelepek', 1997);
INSERT INTO public.public_nestbox_data_projects VALUES (7, 'ÖNPI odúk', 'Az Őrségi Nemzeti Park Igazgatóság kezelésében lévő odútelepek adatbázisa', 2105);
INSERT INTO public.public_nestbox_data_projects VALUES (3, 'Palics', 'Szekeres Ottó odúi', NULL);
INSERT INTO public.public_nestbox_data_projects VALUES (10, 'MME Debrecen', '', NULL);
INSERT INTO public.public_nestbox_data_projects VALUES (11, 'DE Botkert', 'A DE Botkert által vagy jóváhagyásával ismeretlenek által kirakott, többségében számozatlan, gyakran széteső félben lévő odúk', 23935);
INSERT INTO public.public_nestbox_data_projects VALUES (12, 'DE Agrar', 'Nestboxes placed by and around Agricultural Faculty of UniDeb', 32641);
INSERT INTO public.public_nestbox_data_projects VALUES (13, 'Vörös vércse', 'Vörös vércse ládák', 32680);
INSERT INTO public.public_nestbox_data_projects VALUES (14, 'Ismeretlen', 'Ismeretlen', 32711);


--
-- Name: public_nestbox_data_projects_id_seq; Type: SEQUENCE SET; Schema: public; Owner: public_nestbox_data_admin
--

SELECT pg_catalog.setval('public.public_nestbox_data_projects_id_seq', 14, true);


--
-- Name: public_nestbox_data_projects pnd_project_name; Type: CONSTRAINT; Schema: public; Owner: public_nestbox_data_admin
--

ALTER TABLE ONLY public.public_nestbox_data_projects
    ADD CONSTRAINT pnd_project_name UNIQUE (name);


--
-- Name: public_nestbox_data_projects public_nestbox_data_projects_pkey; Type: CONSTRAINT; Schema: public; Owner: public_nestbox_data_admin
--

ALTER TABLE ONLY public.public_nestbox_data_projects
    ADD CONSTRAINT public_nestbox_data_projects_pkey PRIMARY KEY (obm_id);


--
-- Name: public_nestbox_data_projects obm_uploading_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: public_nestbox_data_admin
--

ALTER TABLE ONLY public.public_nestbox_data_projects
    ADD CONSTRAINT obm_uploading_id_fkey FOREIGN KEY (obm_uploading_id) REFERENCES system.uploadings(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: TABLE public_nestbox_data_projects; Type: ACL; Schema: public; Owner: public_nestbox_data_admin
--

GRANT SELECT ON TABLE public.public_nestbox_data_projects TO public_nestbox_data_user;


--
--

