franta-hg@29: --
franta-hg@29: -- PostgreSQL database dump
franta-hg@29: --
franta-hg@29: 
franta-hg@29: -- Started on 2009-05-31 22:35:00 CEST
franta-hg@29: 
franta-hg@29: SET client_encoding = 'UTF8';
franta-hg@29: SET standard_conforming_strings = off;
franta-hg@29: SET check_function_bodies = false;
franta-hg@29: SET client_min_messages = warning;
franta-hg@29: SET escape_string_warning = off;
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 10 (class 2615 OID 16788)
franta-hg@29: -- Name: sqlvyukaaplikace; Type: SCHEMA; Schema: -; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SCHEMA sqlvyukaaplikace;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: SET search_path = sqlvyukaaplikace, pg_catalog;
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1579 (class 1259 OID 16797)
franta-hg@29: -- Dependencies: 10
franta-hg@29: -- Name: historie_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SEQUENCE historie_seq
franta-hg@29:     INCREMENT BY 1
franta-hg@29:     NO MAXVALUE
franta-hg@29:     NO MINVALUE
franta-hg@29:     CACHE 1;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: SET default_tablespace = '';
franta-hg@29: 
franta-hg@29: SET default_with_oids = false;
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1578 (class 1259 OID 16789)
franta-hg@29: -- Dependencies: 1848 1849 10
franta-hg@29: -- Name: historie; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE TABLE historie (
franta-hg@29:     id numeric DEFAULT nextval('historie_seq'::regclass) NOT NULL,
franta-hg@29:     datum timestamp with time zone DEFAULT now(),
franta-hg@29:     sql text,
franta-hg@29:     id_sezeni character varying(255),
franta-hg@29:     ip_adresa character varying(255)
franta-hg@29: );
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1580 (class 1259 OID 16813)
franta-hg@29: -- Dependencies: 10
franta-hg@29: -- Name: tip_seq; Type: SEQUENCE; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE SEQUENCE tip_seq
franta-hg@29:     INCREMENT BY 1
franta-hg@29:     NO MAXVALUE
franta-hg@29:     NO MINVALUE
franta-hg@29:     CACHE 1;
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1581 (class 1259 OID 16815)
franta-hg@29: -- Dependencies: 1850 10
franta-hg@29: -- Name: tip; Type: TABLE; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: CREATE TABLE tip (
franta-hg@29:     id numeric DEFAULT nextval('tip_seq'::regclass) NOT NULL,
franta-hg@29:     text character varying(512) NOT NULL
franta-hg@29: );
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1859 (class 0 OID 0)
franta-hg@29: -- Dependencies: 1581
franta-hg@29: -- Name: TABLE tip; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: COMMENT ON TABLE tip IS 'Rady, tipy, odkazy a citáty… které budeme zobrazovat uživateli v náhodném pořadí.';
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1860 (class 0 OID 0)
franta-hg@29: -- Dependencies: 1581
franta-hg@29: -- Name: COLUMN tip.text; Type: COMMENT; Schema: sqlvyukaaplikace; Owner: -
franta-hg@29: --
franta-hg@29: 
franta-hg@29: COMMENT ON COLUMN tip.text IS 'HTML text. Bude vložen do <p>odstavce</p>. → Pozor na validitu.';
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1852 (class 2606 OID 16796)
franta-hg@29: -- Dependencies: 1578 1578
franta-hg@29: -- Name: historie_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY historie
franta-hg@29:     ADD CONSTRAINT historie_pk PRIMARY KEY (id);
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1854 (class 2606 OID 16823)
franta-hg@29: -- Dependencies: 1581 1581
franta-hg@29: -- Name: tip_pk; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY tip
franta-hg@29:     ADD CONSTRAINT tip_pk PRIMARY KEY (id);
franta-hg@29: 
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- TOC entry 1856 (class 2606 OID 16825)
franta-hg@29: -- Dependencies: 1581 1581
franta-hg@29: -- Name: tip_uq; Type: CONSTRAINT; Schema: sqlvyukaaplikace; Owner: -; Tablespace: 
franta-hg@29: --
franta-hg@29: 
franta-hg@29: ALTER TABLE ONLY tip
franta-hg@29:     ADD CONSTRAINT tip_uq UNIQUE (text);
franta-hg@29: 
franta-hg@29: 
franta-hg@29: -- Completed on 2009-05-31 22:35:01 CEST
franta-hg@29: 
franta-hg@29: --
franta-hg@29: -- PostgreSQL database dump complete
franta-hg@29: --
franta-hg@29: