sql/schéma.sql
author František Kučera <franta-hg@frantovo.cz>
Sat Jan 16 02:43:45 2010 +0100 (2010-01-16)
changeset 18 0deb8f6abcf5
child 19 5d93bf1c8093
permissions -rw-r--r--
Schéma databáze – začátek.
     1 --
     2 -- PostgreSQL database dump
     3 --
     4 
     5 -- Started on 2010-01-16 02:43:00 CET
     6 
     7 SET statement_timeout = 0;
     8 SET client_encoding = 'UTF8';
     9 SET standard_conforming_strings = off;
    10 SET check_function_bodies = false;
    11 SET client_min_messages = warning;
    12 SET escape_string_warning = off;
    13 
    14 --
    15 -- TOC entry 10 (class 2615 OID 35015)
    16 -- Name: nekurak; Type: SCHEMA; Schema: -; Owner: nekurak
    17 --
    18 
    19 CREATE SCHEMA nekurak;
    20 
    21 
    22 ALTER SCHEMA nekurak OWNER TO nekurak;
    23 
    24 SET search_path = nekurak, pg_catalog;
    25 
    26 --
    27 -- TOC entry 1568 (class 1259 OID 35019)
    28 -- Dependencies: 10
    29 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
    30 --
    31 
    32 CREATE SEQUENCE podnik_seq
    33     INCREMENT BY 1
    34     NO MAXVALUE
    35     NO MINVALUE
    36     CACHE 1;
    37 
    38 
    39 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
    40 
    41 --
    42 -- TOC entry 1847 (class 0 OID 0)
    43 -- Dependencies: 1568
    44 -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak
    45 --
    46 
    47 SELECT pg_catalog.setval('podnik_seq', 3, true);
    48 
    49 
    50 SET default_tablespace = '';
    51 
    52 SET default_with_oids = false;
    53 
    54 --
    55 -- TOC entry 1569 (class 1259 OID 35021)
    56 -- Dependencies: 1840 1841 10
    57 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    58 --
    59 
    60 CREATE TABLE podnik (
    61     id integer DEFAULT nextval('podnik_seq'::regclass) NOT NULL,
    62     nazev character varying(255) NOT NULL,
    63     datum timestamp with time zone DEFAULT now()
    64 );
    65 
    66 
    67 ALTER TABLE nekurak.podnik OWNER TO nekurak;
    68 
    69 --
    70 -- TOC entry 1844 (class 0 OID 35021)
    71 -- Dependencies: 1569
    72 -- Data for Name: podnik; Type: TABLE DATA; Schema: nekurak; Owner: nekurak
    73 --
    74 
    75 COPY podnik (id, nazev, datum) FROM stdin;
    76 1	Na Kovárně	2010-01-16 02:40:12.271326+01
    77 2	U přátelského potkana	2010-01-16 02:40:43.326281+01
    78 3	Na Růžku	2010-01-16 02:40:48.104577+01
    79 \.
    80 
    81 
    82 --
    83 -- TOC entry 1843 (class 2606 OID 35027)
    84 -- Dependencies: 1569 1569
    85 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
    86 --
    87 
    88 ALTER TABLE ONLY podnik
    89     ADD CONSTRAINT podnik_pk PRIMARY KEY (id);
    90 
    91 
    92 -- Completed on 2010-01-16 02:43:01 CET
    93 
    94 --
    95 -- PostgreSQL database dump complete
    96 --
    97