# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1263606225 -3600
# Node ID 0deb8f6abcf56e0d5f57d03d0e6b76a983955a26
# Parent  f12459f8b48210183d6f2705bfd271a2a684d879
Schéma databáze – začátek.

diff -r f12459f8b482 -r 0deb8f6abcf5 sql/schéma.sql
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/schéma.sql	Sat Jan 16 02:43:45 2010 +0100
@@ -0,0 +1,97 @@
+--
+-- PostgreSQL database dump
+--
+
+-- Started on 2010-01-16 02:43:00 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 1847 (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);
+
+
+-- Completed on 2010-01-16 02:43:01 CET
+
+--
+-- PostgreSQL database dump complete
+--
+