--

 -- PostgreSQL database dump

 --

 -- Started on 2010-01-25 17:42:09 CET

 SET statement_timeout = 0;

 SET client_encoding = 'UTF8';

 SET standard_conforming_strings = off;

 SET check_function_bodies = false;

 SET client_min_messages = warning;

 SET escape_string_warning = off;

 --

 -- TOC entry 10 (class 2615 OID 35015)

 -- Name: nekurak; Type: SCHEMA; Schema: -; Owner: nekurak

 --

 CREATE SCHEMA nekurak;

 ALTER SCHEMA nekurak OWNER TO nekurak;

 SET search_path = nekurak, pg_catalog;

 --

 -- TOC entry 1568 (class 1259 OID 35019)

 -- Dependencies: 10

 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak

 --

 CREATE SEQUENCE podnik_seq

     INCREMENT BY 1

     NO MAXVALUE

     NO MINVALUE

     CACHE 1;

 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;

 --

 -- TOC entry 1848 (class 0 OID 0)

 -- Dependencies: 1568

 -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak

 --

 SELECT pg_catalog.setval('podnik_seq', 3, true);

 SET default_tablespace = '';

 SET default_with_oids = false;

 --

 -- TOC entry 1569 (class 1259 OID 35021)

 -- Dependencies: 1840 1841 10

 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 

 --

 CREATE TABLE podnik (

     id integer DEFAULT nextval('podnik_seq'::regclass) NOT NULL,

     nazev character varying(255) NOT NULL,

     datum timestamp with time zone DEFAULT now()

 );

 ALTER TABLE nekurak.podnik OWNER TO nekurak;

 --

 -- TOC entry 1844 (class 0 OID 35021)

 -- Dependencies: 1569

 -- Data for Name: podnik; Type: TABLE DATA; Schema: nekurak; Owner: nekurak

 --

 COPY podnik (id, nazev, datum) FROM stdin;

 1	Na Kovárně	2010-01-16 02:40:12.271326+01

 2	U přátelského potkana	2010-01-16 02:40:43.326281+01

 3	Na Růžku	2010-01-16 02:40:48.104577+01

 \.

 --

 -- TOC entry 1843 (class 2606 OID 35027)

 -- Dependencies: 1569 1569

 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 

 --

 ALTER TABLE ONLY podnik

     ADD CONSTRAINT podnik_pk PRIMARY KEY (id);

 --

 -- TOC entry 1847 (class 0 OID 0)

 -- Dependencies: 10

 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak

 --

 REVOKE ALL ON SCHEMA nekurak FROM PUBLIC;

 REVOKE ALL ON SCHEMA nekurak FROM nekurak;

 GRANT ALL ON SCHEMA nekurak TO nekurak;

 GRANT USAGE ON SCHEMA nekurak TO nekurak_web;

 --

 -- TOC entry 1849 (class 0 OID 0)

 -- Dependencies: 1568

 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak

 --

 REVOKE ALL ON SEQUENCE podnik_seq FROM PUBLIC;

 REVOKE ALL ON SEQUENCE podnik_seq FROM nekurak;

 GRANT ALL ON SEQUENCE podnik_seq TO nekurak;

 GRANT USAGE ON SEQUENCE podnik_seq TO nekurak_web;

 --

 -- TOC entry 1850 (class 0 OID 0)

 -- Dependencies: 1569

 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak

 --

 REVOKE ALL ON TABLE podnik FROM PUBLIC;

 REVOKE ALL ON TABLE podnik FROM nekurak;

 GRANT ALL ON TABLE podnik TO nekurak;

 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik TO nekurak_web;

 -- Completed on 2010-01-25 17:42:10 CET

 --

 -- PostgreSQL database dump complete

 --