diff -r 4b6ab4ba1a95 -r 6569976087aa sql/schéma.sql --- a/sql/schéma.sql Sun May 31 22:36:58 2009 +0200 +++ b/sql/schéma.sql Tue Apr 23 22:04:43 2013 +0200 @@ -2,7 +2,7 @@ -- PostgreSQL database dump -- --- Started on 2009-05-31 22:35:00 CEST +-- Started on 2009-06-06 23:39:14 CEST SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; @@ -21,7 +21,7 @@ SET search_path = sqlvyukaaplikace, pg_catalog; -- --- TOC entry 1579 (class 1259 OID 16797) +-- TOC entry 1583 (class 1259 OID 16797) -- Dependencies: 10 -- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: - -- @@ -38,8 +38,8 @@ SET default_with_oids = false; -- --- TOC entry 1578 (class 1259 OID 16789) --- Dependencies: 1848 1849 10 +-- TOC entry 1582 (class 1259 OID 16789) +-- Dependencies: 1854 1855 10 -- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- @@ -53,7 +53,79 @@ -- --- TOC entry 1580 (class 1259 OID 16813) +-- 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: - -- @@ -66,8 +138,8 @@ -- --- TOC entry 1581 (class 1259 OID 16815) --- Dependencies: 1850 10 +-- TOC entry 1585 (class 1259 OID 16815) +-- Dependencies: 1856 10 -- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- @@ -78,8 +150,8 @@ -- --- TOC entry 1859 (class 0 OID 0) --- Dependencies: 1581 +-- TOC entry 1875 (class 0 OID 0) +-- Dependencies: 1585 -- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- @@ -87,8 +159,8 @@ -- --- TOC entry 1860 (class 0 OID 0) --- Dependencies: 1581 +-- TOC entry 1876 (class 0 OID 0) +-- Dependencies: 1585 -- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: - -- @@ -96,8 +168,8 @@ -- --- TOC entry 1852 (class 2606 OID 16796) --- Dependencies: 1578 1578 +-- TOC entry 1859 (class 2606 OID 16796) +-- Dependencies: 1582 1582 -- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- @@ -106,8 +178,28 @@ -- --- TOC entry 1854 (class 2606 OID 16823) --- Dependencies: 1581 1581 +-- 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: -- @@ -116,8 +208,8 @@ -- --- TOC entry 1856 (class 2606 OID 16825) --- Dependencies: 1581 1581 +-- TOC entry 1863 (class 2606 OID 16825) +-- Dependencies: 1585 1585 -- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: -- @@ -125,7 +217,7 @@ ADD CONSTRAINT tip_uq UNIQUE (text); --- Completed on 2009-05-31 22:35:01 CEST +-- Completed on 2009-06-06 23:39:14 CEST -- -- PostgreSQL database dump complete