1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/sql/schéma.sql Sun May 31 23:13:47 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 +