franta-hg@29: --
franta-hg@29: -- PostgreSQL database dump
franta-hg@29: --
franta-hg@29: 
franta-hg@43: -- Started on 2009-06-06 23:39:14 CEST
franta-hg@29: 
franta-hg@29: SET client_encoding = 'UTF8';
franta-hg@29: SET standard_conforming_strings = off;
franta-hg@29: SET check_function_bodies = false;
franta-hg@29: SET client_min_messages = warning;
franta-hg@29: SET escape_string_warning = off;
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 10 (class 2615 OID 16788)
franta-hg@29: -- Name: sqlvyukaaplikace; Type: SCHEMA; Schema: -; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SCHEMA sqlvyukaaplikace;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: SET search_path = sqlvyukaaplikace, pg_catalog;
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1583 (class 1259 OID 16797)
franta-hg@29: -- Dependencies: 10
franta-hg@29: -- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SEQUENCE historie_seq
franta-hg@29:     INCREMENT BY 1
franta-hg@29:     NO MAXVALUE
franta-hg@29:     NO MINVALUE
franta-hg@29:     CACHE 1;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: SET default_tablespace = '';
franta-hg@29: 
franta-hg@29: SET default_with_oids = false;
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1582 (class 1259 OID 16789)
franta-hg@43: -- Dependencies: 1854 1855 10
franta-hg@29: -- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE TABLE historie (
franta-hg@29:     id numeric DEFAULT nextval('historie_seq'::regclass) NOT NULL,
franta-hg@29:     datum timestamp with time zone DEFAULT now(),
franta-hg@29:     sql text,
franta-hg@29:     id_sezeni character varying(255),
franta-hg@29:     ip_adresa character varying(255)
franta-hg@29: );
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1586 (class 1259 OID 16826)
franta-hg@43: -- Dependencies: 10
franta-hg@43: -- Name: pruvodce_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: CREATE SEQUENCE pruvodce_seq
franta-hg@43:     INCREMENT BY 10
franta-hg@43:     NO MAXVALUE
franta-hg@43:     NO MINVALUE
franta-hg@43:     CACHE 1;
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1587 (class 1259 OID 16828)
franta-hg@43: -- Dependencies: 1857 10
franta-hg@43: -- Name: pruvodce; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@43: --
franta-hg@43: 
franta-hg@43: CREATE TABLE pruvodce (
franta-hg@43:     id numeric DEFAULT nextval('pruvodce_seq'::regclass) NOT NULL,
franta-hg@43:     kod character varying(32),
franta-hg@43:     nadpis character varying(255) NOT NULL,
franta-hg@43:     obsah text NOT NULL
franta-hg@43: );
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1870 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1587
franta-hg@43: -- Name: TABLE pruvodce; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: COMMENT ON TABLE pruvodce IS 'Nápověda, průvodce';
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1871 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1587
franta-hg@43: -- Name: COLUMN pruvodce.id; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: COMMENT ON COLUMN pruvodce.id IS 'Pořadí kapitoly/lekce';
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1872 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1587
franta-hg@43: -- Name: COLUMN pruvodce.kod; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: COMMENT ON COLUMN pruvodce.kod IS 'kód, na který se můžeme odkazovat';
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1873 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1587
franta-hg@43: -- Name: COLUMN pruvodce.nadpis; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: COMMENT ON COLUMN pruvodce.nadpis IS 'Název kapitoly';
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1874 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1587
franta-hg@43: -- Name: COLUMN pruvodce.obsah; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@43: --
franta-hg@43: 
franta-hg@43: COMMENT ON COLUMN pruvodce.obsah IS 'Vlastní text kapitoly';
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1584 (class 1259 OID 16813)
franta-hg@29: -- Dependencies: 10
franta-hg@29: -- Name: tip_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SEQUENCE tip_seq
franta-hg@29:     INCREMENT BY 1
franta-hg@29:     NO MAXVALUE
franta-hg@29:     NO MINVALUE
franta-hg@29:     CACHE 1;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1585 (class 1259 OID 16815)
franta-hg@43: -- Dependencies: 1856 10
franta-hg@29: -- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE TABLE tip (
franta-hg@29:     id numeric DEFAULT nextval('tip_seq'::regclass) NOT NULL,
franta-hg@29:     text character varying(512) NOT NULL
franta-hg@29: );
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1875 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1585
franta-hg@29: -- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: COMMENT ON TABLE tip IS 'Rady, tipy, odkazy a citáty… které budeme zobrazovat uživateli v náhodném pořadí.';
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1876 (class 0 OID 0)
franta-hg@43: -- Dependencies: 1585
franta-hg@29: -- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: COMMENT ON COLUMN tip.text IS 'HTML text. Bude vložen do <p>odstavce</p>. → Pozor na validitu.';
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1859 (class 2606 OID 16796)
franta-hg@43: -- Dependencies: 1582 1582
franta-hg@29: -- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY historie
franta-hg@29:     ADD CONSTRAINT historie_pk PRIMARY KEY (id);
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1865 (class 2606 OID 16838)
franta-hg@43: -- Dependencies: 1587 1587
franta-hg@43: -- Name: pruvodce_kod_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@43: --
franta-hg@43: 
franta-hg@43: ALTER TABLE ONLY pruvodce
franta-hg@43:     ADD CONSTRAINT pruvodce_kod_uq UNIQUE (kod);
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1867 (class 2606 OID 16836)
franta-hg@43: -- Dependencies: 1587 1587
franta-hg@43: -- Name: pruvodce_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@43: --
franta-hg@43: 
franta-hg@43: ALTER TABLE ONLY pruvodce
franta-hg@43:     ADD CONSTRAINT pruvodce_pk PRIMARY KEY (id);
franta-hg@43: 
franta-hg@43: 
franta-hg@43: --
franta-hg@43: -- TOC entry 1861 (class 2606 OID 16823)
franta-hg@43: -- Dependencies: 1585 1585
franta-hg@29: -- Name: tip_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY tip
franta-hg@29:     ADD CONSTRAINT tip_pk PRIMARY KEY (id);
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@43: -- TOC entry 1863 (class 2606 OID 16825)
franta-hg@43: -- Dependencies: 1585 1585
franta-hg@29: -- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY tip
franta-hg@29:     ADD CONSTRAINT tip_uq UNIQUE (text);
franta-hg@29: 
franta-hg@29: 
franta-hg@43: -- Completed on 2009-06-06 23:39:14 CEST
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- PostgreSQL database dump complete
franta-hg@29: --
franta-hg@29: