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
odstavce
. → 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: