1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/sql/schéma.sql	Sun May 31 22:36:58 2009 +0200
     1.3 @@ -0,0 +1,133 @@
     1.4 +--
     1.5 +-- PostgreSQL database dump
     1.6 +--
     1.7 +
     1.8 +-- Started on 2009-05-31 22:35:00 CEST
     1.9 +
    1.10 +SET client_encoding = 'UTF8';
    1.11 +SET standard_conforming_strings = off;
    1.12 +SET check_function_bodies = false;
    1.13 +SET client_min_messages = warning;
    1.14 +SET escape_string_warning = off;
    1.15 +
    1.16 +--
    1.17 +-- TOC entry 10 (class 2615 OID 16788)
    1.18 +-- Name: sqlvyukaaplikace; Type: SCHEMA; Schema: -; Owner: -
    1.19 +--
    1.20 +
    1.21 +CREATE SCHEMA sqlvyukaaplikace;
    1.22 +
    1.23 +
    1.24 +SET search_path = sqlvyukaaplikace, pg_catalog;
    1.25 +
    1.26 +--
    1.27 +-- TOC entry 1579 (class 1259 OID 16797)
    1.28 +-- Dependencies: 10
    1.29 +-- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
    1.30 +--
    1.31 +
    1.32 +CREATE SEQUENCE historie_seq
    1.33 +    INCREMENT BY 1
    1.34 +    NO MAXVALUE
    1.35 +    NO MINVALUE
    1.36 +    CACHE 1;
    1.37 +
    1.38 +
    1.39 +SET default_tablespace = '';
    1.40 +
    1.41 +SET default_with_oids = false;
    1.42 +
    1.43 +--
    1.44 +-- TOC entry 1578 (class 1259 OID 16789)
    1.45 +-- Dependencies: 1848 1849 10
    1.46 +-- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
    1.47 +--
    1.48 +
    1.49 +CREATE TABLE historie (
    1.50 +    id numeric DEFAULT nextval('historie_seq'::regclass) NOT NULL,
    1.51 +    datum timestamp with time zone DEFAULT now(),
    1.52 +    sql text,
    1.53 +    id_sezeni character varying(255),
    1.54 +    ip_adresa character varying(255)
    1.55 +);
    1.56 +
    1.57 +
    1.58 +--
    1.59 +-- TOC entry 1580 (class 1259 OID 16813)
    1.60 +-- Dependencies: 10
    1.61 +-- Name: tip_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
    1.62 +--
    1.63 +
    1.64 +CREATE SEQUENCE tip_seq
    1.65 +    INCREMENT BY 1
    1.66 +    NO MAXVALUE
    1.67 +    NO MINVALUE
    1.68 +    CACHE 1;
    1.69 +
    1.70 +
    1.71 +--
    1.72 +-- TOC entry 1581 (class 1259 OID 16815)
    1.73 +-- Dependencies: 1850 10
    1.74 +-- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
    1.75 +--
    1.76 +
    1.77 +CREATE TABLE tip (
    1.78 +    id numeric DEFAULT nextval('tip_seq'::regclass) NOT NULL,
    1.79 +    text character varying(512) NOT NULL
    1.80 +);
    1.81 +
    1.82 +
    1.83 +--
    1.84 +-- TOC entry 1859 (class 0 OID 0)
    1.85 +-- Dependencies: 1581
    1.86 +-- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
    1.87 +--
    1.88 +
    1.89 +COMMENT ON TABLE tip IS 'Rady, tipy, odkazy a citáty… které budeme zobrazovat uživateli v náhodném pořadí.';
    1.90 +
    1.91 +
    1.92 +--
    1.93 +-- TOC entry 1860 (class 0 OID 0)
    1.94 +-- Dependencies: 1581
    1.95 +-- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
    1.96 +--
    1.97 +
    1.98 +COMMENT ON COLUMN tip.text IS 'HTML text. Bude vložen do <p>odstavce</p>. → Pozor na validitu.';
    1.99 +
   1.100 +
   1.101 +--
   1.102 +-- TOC entry 1852 (class 2606 OID 16796)
   1.103 +-- Dependencies: 1578 1578
   1.104 +-- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
   1.105 +--
   1.106 +
   1.107 +ALTER TABLE ONLY historie
   1.108 +    ADD CONSTRAINT historie_pk PRIMARY KEY (id);
   1.109 +
   1.110 +
   1.111 +--
   1.112 +-- TOC entry 1854 (class 2606 OID 16823)
   1.113 +-- Dependencies: 1581 1581
   1.114 +-- Name: tip_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
   1.115 +--
   1.116 +
   1.117 +ALTER TABLE ONLY tip
   1.118 +    ADD CONSTRAINT tip_pk PRIMARY KEY (id);
   1.119 +
   1.120 +
   1.121 +--
   1.122 +-- TOC entry 1856 (class 2606 OID 16825)
   1.123 +-- Dependencies: 1581 1581
   1.124 +-- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
   1.125 +--
   1.126 +
   1.127 +ALTER TABLE ONLY tip
   1.128 +    ADD CONSTRAINT tip_uq UNIQUE (text);
   1.129 +
   1.130 +
   1.131 +-- Completed on 2009-05-31 22:35:01 CEST
   1.132 +
   1.133 +--
   1.134 +-- PostgreSQL database dump complete
   1.135 +--
   1.136 +