# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# Date 1244324452 -7200
# Node ID 8d1a92f641103bef81eb41c030667d1b80b8a147
# Parent  4faa76a089e33484c2b554f13207d881c3b42321
SQL: tabulka průvodce (nápovědy) a sekvence

diff -r 4faa76a089e3 -r 8d1a92f64110 sql/schéma.sql
--- a/sql/schéma.sql	Wed Jun 03 22:32:35 2009 +0200
+++ b/sql/schéma.sql	Sat Jun 06 23:40:52 2009 +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