-- -- PostgreSQL database dump -- -- Started on 2009-06-06 23:39:14 CEST 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 16788) -- Name: sqlvyukaaplikace; Type: SCHEMA; Schema: -; Owner: - -- CREATE SCHEMA sqlvyukaaplikace; SET search_path = sqlvyukaaplikace, pg_catalog; -- -- TOC entry 1583 (class 1259 OID 16797) -- Dependencies: 10 -- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - -- CREATE SEQUENCE historie_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; SET default_tablespace = ''; SET default_with_oids = false; -- -- TOC entry 1582 (class 1259 OID 16789) -- Dependencies: 1854 1855 10 -- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- CREATE TABLE historie ( id numeric DEFAULT nextval('historie_seq'::regclass) NOT NULL, datum timestamp with time zone DEFAULT now(), sql text, id_sezeni character varying(255), ip_adresa character varying(255) ); -- -- TOC entry 1586 (class 1259 OID 16826) -- Dependencies: 10 -- Name: pruvodce_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - -- CREATE SEQUENCE pruvodce_seq INCREMENT BY 10 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1587 (class 1259 OID 16828) -- Dependencies: 1857 10 -- Name: pruvodce; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- CREATE TABLE pruvodce ( id numeric DEFAULT nextval('pruvodce_seq'::regclass) NOT NULL, kod character varying(32), nadpis character varying(255) NOT NULL, obsah text NOT NULL ); -- -- TOC entry 1870 (class 0 OID 0) -- Dependencies: 1587 -- Name: TABLE pruvodce; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON TABLE pruvodce IS 'Nápověda, průvodce'; -- -- TOC entry 1871 (class 0 OID 0) -- Dependencies: 1587 -- Name: COLUMN pruvodce.id; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON COLUMN pruvodce.id IS 'Pořadí kapitoly/lekce'; -- -- TOC entry 1872 (class 0 OID 0) -- Dependencies: 1587 -- Name: COLUMN pruvodce.kod; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON COLUMN pruvodce.kod IS 'kód, na který se můžeme odkazovat'; -- -- TOC entry 1873 (class 0 OID 0) -- Dependencies: 1587 -- Name: COLUMN pruvodce.nadpis; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON COLUMN pruvodce.nadpis IS 'Název kapitoly'; -- -- TOC entry 1874 (class 0 OID 0) -- Dependencies: 1587 -- Name: COLUMN pruvodce.obsah; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON COLUMN pruvodce.obsah IS 'Vlastní text kapitoly'; -- -- TOC entry 1584 (class 1259 OID 16813) -- Dependencies: 10 -- Name: tip_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - -- CREATE SEQUENCE tip_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 1585 (class 1259 OID 16815) -- Dependencies: 1856 10 -- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- CREATE TABLE tip ( id numeric DEFAULT nextval('tip_seq'::regclass) NOT NULL, text character varying(512) NOT NULL ); -- -- TOC entry 1875 (class 0 OID 0) -- Dependencies: 1585 -- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON TABLE tip IS 'Rady, tipy, odkazy a citáty… které budeme zobrazovat uživateli v náhodném pořadí.'; -- -- TOC entry 1876 (class 0 OID 0) -- Dependencies: 1585 -- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- COMMENT ON COLUMN tip.text IS 'HTML text. Bude vložen do

odstavce

. → Pozor na validitu.'; -- -- TOC entry 1859 (class 2606 OID 16796) -- Dependencies: 1582 1582 -- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- ALTER TABLE ONLY historie ADD CONSTRAINT historie_pk PRIMARY KEY (id); -- -- TOC entry 1865 (class 2606 OID 16838) -- Dependencies: 1587 1587 -- Name: pruvodce_kod_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- ALTER TABLE ONLY pruvodce ADD CONSTRAINT pruvodce_kod_uq UNIQUE (kod); -- -- TOC entry 1867 (class 2606 OID 16836) -- Dependencies: 1587 1587 -- Name: pruvodce_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- ALTER TABLE ONLY pruvodce ADD CONSTRAINT pruvodce_pk PRIMARY KEY (id); -- -- TOC entry 1861 (class 2606 OID 16823) -- Dependencies: 1585 1585 -- Name: tip_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- ALTER TABLE ONLY tip ADD CONSTRAINT tip_pk PRIMARY KEY (id); -- -- TOC entry 1863 (class 2606 OID 16825) -- Dependencies: 1585 1585 -- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- ALTER TABLE ONLY tip ADD CONSTRAINT tip_uq UNIQUE (text); -- Completed on 2009-06-06 23:39:14 CEST -- -- PostgreSQL database dump complete --