Schéma databáze – začátek.
authorFrantišek Kučera <franta-hg@frantovo.cz>
Sat Jan 16 02:43:45 2010 +0100 (2010-01-16)
changeset 180deb8f6abcf5
parent 17 f12459f8b482
child 19 5d93bf1c8093
Schéma databáze – začátek.
sql/schéma.sql
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/sql/schéma.sql	Sat Jan 16 02:43:45 2010 +0100
     1.3 @@ -0,0 +1,97 @@
     1.4 +--
     1.5 +-- PostgreSQL database dump
     1.6 +--
     1.7 +
     1.8 +-- Started on 2010-01-16 02:43:00 CET
     1.9 +
    1.10 +SET statement_timeout = 0;
    1.11 +SET client_encoding = 'UTF8';
    1.12 +SET standard_conforming_strings = off;
    1.13 +SET check_function_bodies = false;
    1.14 +SET client_min_messages = warning;
    1.15 +SET escape_string_warning = off;
    1.16 +
    1.17 +--
    1.18 +-- TOC entry 10 (class 2615 OID 35015)
    1.19 +-- Name: nekurak; Type: SCHEMA; Schema: -; Owner: nekurak
    1.20 +--
    1.21 +
    1.22 +CREATE SCHEMA nekurak;
    1.23 +
    1.24 +
    1.25 +ALTER SCHEMA nekurak OWNER TO nekurak;
    1.26 +
    1.27 +SET search_path = nekurak, pg_catalog;
    1.28 +
    1.29 +--
    1.30 +-- TOC entry 1568 (class 1259 OID 35019)
    1.31 +-- Dependencies: 10
    1.32 +-- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
    1.33 +--
    1.34 +
    1.35 +CREATE SEQUENCE podnik_seq
    1.36 +    INCREMENT BY 1
    1.37 +    NO MAXVALUE
    1.38 +    NO MINVALUE
    1.39 +    CACHE 1;
    1.40 +
    1.41 +
    1.42 +ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
    1.43 +
    1.44 +--
    1.45 +-- TOC entry 1847 (class 0 OID 0)
    1.46 +-- Dependencies: 1568
    1.47 +-- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak
    1.48 +--
    1.49 +
    1.50 +SELECT pg_catalog.setval('podnik_seq', 3, true);
    1.51 +
    1.52 +
    1.53 +SET default_tablespace = '';
    1.54 +
    1.55 +SET default_with_oids = false;
    1.56 +
    1.57 +--
    1.58 +-- TOC entry 1569 (class 1259 OID 35021)
    1.59 +-- Dependencies: 1840 1841 10
    1.60 +-- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    1.61 +--
    1.62 +
    1.63 +CREATE TABLE podnik (
    1.64 +    id integer DEFAULT nextval('podnik_seq'::regclass) NOT NULL,
    1.65 +    nazev character varying(255) NOT NULL,
    1.66 +    datum timestamp with time zone DEFAULT now()
    1.67 +);
    1.68 +
    1.69 +
    1.70 +ALTER TABLE nekurak.podnik OWNER TO nekurak;
    1.71 +
    1.72 +--
    1.73 +-- TOC entry 1844 (class 0 OID 35021)
    1.74 +-- Dependencies: 1569
    1.75 +-- Data for Name: podnik; Type: TABLE DATA; Schema: nekurak; Owner: nekurak
    1.76 +--
    1.77 +
    1.78 +COPY podnik (id, nazev, datum) FROM stdin;
    1.79 +1	Na Kovárně	2010-01-16 02:40:12.271326+01
    1.80 +2	U přátelského potkana	2010-01-16 02:40:43.326281+01
    1.81 +3	Na Růžku	2010-01-16 02:40:48.104577+01
    1.82 +\.
    1.83 +
    1.84 +
    1.85 +--
    1.86 +-- TOC entry 1843 (class 2606 OID 35027)
    1.87 +-- Dependencies: 1569 1569
    1.88 +-- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
    1.89 +--
    1.90 +
    1.91 +ALTER TABLE ONLY podnik
    1.92 +    ADD CONSTRAINT podnik_pk PRIMARY KEY (id);
    1.93 +
    1.94 +
    1.95 +-- Completed on 2010-01-16 02:43:01 CET
    1.96 +
    1.97 +--
    1.98 +-- PostgreSQL database dump complete
    1.99 +--
   1.100 +