Index: sql/schéma.sql
===================================================================
--- sql/schéma.sql	(revision 29:4b6ab4ba1a95)
+++ sql/schéma.sql	(revision 43:8d1a92f64110)
@@ -3,5 +3,5 @@
 --
 
--- Started on 2009-05-31 22:35:00 CEST
+-- Started on 2009-06-06 23:39:14 CEST
 
 SET client_encoding = 'UTF8';
@@ -22,5 +22,5 @@
 
 --
--- TOC entry 1579 (class 1259 OID 16797)
+-- TOC entry 1583 (class 1259 OID 16797)
 -- Dependencies: 10
 -- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
@@ -39,6 +39,6 @@
 
 --
--- 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: 
 --
@@ -54,5 +54,77 @@
 
 --
--- 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: -
@@ -67,6 +139,6 @@
 
 --
--- 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: 
 --
@@ -79,6 +151,6 @@
 
 --
--- 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: -
 --
@@ -88,6 +160,6 @@
 
 --
--- 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: -
 --
@@ -97,6 +169,6 @@
 
 --
--- 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: 
 --
@@ -107,6 +179,26 @@
 
 --
--- 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: 
 --
@@ -117,6 +209,6 @@
 
 --
--- 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: 
 --
@@ -126,5 +218,5 @@
 
 
--- Completed on 2009-05-31 22:35:01 CEST
+-- Completed on 2009-06-06 23:39:14 CEST
 
 --