# HG changeset patch # User František Kučera # Date 1251473063 -7200 # Node ID 693f2b2587aa5748946e8eff3244db4502bf207c # Parent 3461cdf271d0ee0b9fb2d26be1db725108f1b89a Oprava primárního klíče (přidání domény). Tento soubor získáme tímto příkazem: pg_dump -h veverka.ch -p 5432 -U posta -F p -s -s -O -v -f "schéma.sql" -n 'posta' veverka diff -r 3461cdf271d0 -r 693f2b2587aa sql/schéma.sql --- a/sql/schéma.sql Fri May 29 21:59:34 2009 +0200 +++ b/sql/schéma.sql Fri Aug 28 17:24:23 2009 +0200 @@ -2,7 +2,7 @@ -- PostgreSQL database dump -- --- Started on 2009-05-29 21:13:11 CEST +-- Started on 2009-08-28 17:21:16 CEST SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; @@ -21,13 +21,13 @@ SET search_path = posta, pg_catalog; -- --- TOC entry 55 (class 1255 OID 16694) --- Dependencies: 364 8 +-- TOC entry 57 (class 1255 OID 16694) +-- Dependencies: 472 8 -- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: - -- CREATE FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) RETURNS text - AS $_$DECLARE pocet integer; + AS $$DECLARE pocet integer; BEGIN UPDATE uzivatel SET heslo = md5("Nove_heslo") @@ -36,18 +36,18 @@ AND uzivatel.heslo = md5("Stare_heslo"); GET DIAGNOSTICS pocet = ROW_COUNT; IF pocet = 1 THEN - RETURN 'Změna hesla pro ' || $1 || '@' || $2 || ' proběhla úspěšně.'; + RETURN 'Změna hesla pro ' || "Login" || '@' || "Domena" || ' proběhla úspěšně.'; ELSE - RAISE EXCEPTION 'Nesprávné heslo, nebo uživatel % neexistuje', $1 || '@' || $2; + RAISE EXCEPTION 'Nesprávné heslo, nebo uživatel % neexistuje', "Login" || '@' || "Domena"; END IF; END; - $_$ + $$ LANGUAGE plpgsql SECURITY DEFINER; -- --- TOC entry 1835 (class 0 OID 0) --- Dependencies: 55 +-- TOC entry 1981 (class 0 OID 0) +-- Dependencies: 57 -- Name: FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying); Type: COMMENT; Schema: posta; Owner: - -- @@ -59,7 +59,7 @@ SET default_with_oids = false; -- --- TOC entry 1549 (class 1259 OID 16550) +-- TOC entry 1657 (class 1259 OID 16550) -- Dependencies: 8 -- Name: alias; Type: TABLE; Schema: posta; Owner: -; Tablespace: -- @@ -68,13 +68,13 @@ zdroj_jmeno character varying(255) NOT NULL, zdroj_domena character varying(255) NOT NULL, cil_jmeno character varying(255) NOT NULL, - cil_domena character varying(255) + cil_domena character varying(255) NOT NULL ); -- --- TOC entry 1837 (class 0 OID 0) --- Dependencies: 1549 +-- TOC entry 1983 (class 0 OID 0) +-- Dependencies: 1657 -- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: - -- @@ -83,8 +83,8 @@ -- --- TOC entry 1838 (class 0 OID 0) --- Dependencies: 1549 +-- TOC entry 1984 (class 0 OID 0) +-- Dependencies: 1657 -- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: - -- @@ -93,8 +93,8 @@ -- --- TOC entry 1839 (class 0 OID 0) --- Dependencies: 1549 +-- TOC entry 1985 (class 0 OID 0) +-- Dependencies: 1657 -- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: - -- @@ -103,8 +103,8 @@ -- --- TOC entry 1840 (class 0 OID 0) --- Dependencies: 1549 +-- TOC entry 1986 (class 0 OID 0) +-- Dependencies: 1657 -- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: - -- @@ -113,7 +113,7 @@ -- --- TOC entry 1536 (class 1259 OID 16396) +-- TOC entry 1644 (class 1259 OID 16396) -- Dependencies: 8 -- Name: domena; Type: TABLE; Schema: posta; Owner: -; Tablespace: -- @@ -124,7 +124,7 @@ -- --- TOC entry 1537 (class 1259 OID 16409) +-- TOC entry 1645 (class 1259 OID 16409) -- Dependencies: 8 -- Name: uzivatel; Type: TABLE; Schema: posta; Owner: -; Tablespace: -- @@ -137,8 +137,8 @@ -- --- TOC entry 1550 (class 1259 OID 16602) --- Dependencies: 1629 8 +-- TOC entry 1658 (class 1259 OID 16602) +-- Dependencies: 1775 8 -- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: - -- @@ -147,8 +147,8 @@ -- --- TOC entry 1552 (class 1259 OID 16631) --- Dependencies: 1631 8 +-- TOC entry 1660 (class 1259 OID 16631) +-- Dependencies: 1777 8 -- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: - -- @@ -157,8 +157,8 @@ -- --- TOC entry 1553 (class 1259 OID 16695) --- Dependencies: 1632 8 +-- TOC entry 1661 (class 1259 OID 16695) +-- Dependencies: 1778 8 -- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: - -- @@ -167,8 +167,8 @@ -- --- TOC entry 1551 (class 1259 OID 16607) --- Dependencies: 1630 8 +-- TOC entry 1659 (class 1259 OID 16607) +-- Dependencies: 1776 8 -- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: - -- @@ -177,18 +177,18 @@ -- --- TOC entry 1829 (class 2606 OID 16557) --- Dependencies: 1549 1549 1549 1549 +-- TOC entry 1975 (class 2606 OID 17071) +-- Dependencies: 1657 1657 1657 1657 1657 -- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace: -- ALTER TABLE ONLY alias - ADD CONSTRAINT aliasy_pk PRIMARY KEY (zdroj_jmeno, zdroj_domena, cil_jmeno); + ADD CONSTRAINT aliasy_pk PRIMARY KEY (zdroj_jmeno, zdroj_domena, cil_jmeno, cil_domena); -- --- TOC entry 1825 (class 2606 OID 16400) --- Dependencies: 1536 1536 +-- TOC entry 1971 (class 2606 OID 16400) +-- Dependencies: 1644 1644 -- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace: -- @@ -197,8 +197,8 @@ -- --- TOC entry 1827 (class 2606 OID 16416) --- Dependencies: 1537 1537 1537 +-- TOC entry 1973 (class 2606 OID 16416) +-- Dependencies: 1645 1645 1645 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: -; Tablespace: -- @@ -207,8 +207,8 @@ -- --- TOC entry 1831 (class 2606 OID 16558) --- Dependencies: 1549 1824 1536 +-- TOC entry 1977 (class 2606 OID 16558) +-- Dependencies: 1657 1970 1644 -- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: - -- @@ -217,8 +217,8 @@ -- --- TOC entry 1830 (class 2606 OID 16417) --- Dependencies: 1536 1824 1537 +-- TOC entry 1976 (class 2606 OID 16417) +-- Dependencies: 1644 1645 1970 -- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: - -- @@ -227,7 +227,7 @@ -- --- TOC entry 1834 (class 0 OID 0) +-- TOC entry 1980 (class 0 OID 0) -- Dependencies: 8 -- Name: posta; Type: ACL; Schema: -; Owner: - -- @@ -240,8 +240,8 @@ -- --- TOC entry 1836 (class 0 OID 0) --- Dependencies: 55 +-- TOC entry 1982 (class 0 OID 0) +-- Dependencies: 57 -- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: - -- @@ -253,8 +253,8 @@ -- --- TOC entry 1841 (class 0 OID 0) --- Dependencies: 1549 +-- TOC entry 1987 (class 0 OID 0) +-- Dependencies: 1657 -- Name: alias; Type: ACL; Schema: posta; Owner: - -- @@ -264,8 +264,8 @@ -- --- TOC entry 1842 (class 0 OID 0) --- Dependencies: 1536 +-- TOC entry 1988 (class 0 OID 0) +-- Dependencies: 1644 -- Name: domena; Type: ACL; Schema: posta; Owner: - -- @@ -276,8 +276,8 @@ -- --- TOC entry 1843 (class 0 OID 0) --- Dependencies: 1537 +-- TOC entry 1989 (class 0 OID 0) +-- Dependencies: 1645 -- Name: uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -288,8 +288,8 @@ -- --- TOC entry 1844 (class 0 OID 0) --- Dependencies: 1550 +-- TOC entry 1990 (class 0 OID 0) +-- Dependencies: 1658 -- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: - -- @@ -300,8 +300,8 @@ -- --- TOC entry 1845 (class 0 OID 0) --- Dependencies: 1552 +-- TOC entry 1991 (class 0 OID 0) +-- Dependencies: 1660 -- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -312,8 +312,8 @@ -- --- TOC entry 1846 (class 0 OID 0) --- Dependencies: 1553 +-- TOC entry 1992 (class 0 OID 0) +-- Dependencies: 1661 -- Name: postfix_alias; Type: ACL; Schema: posta; Owner: - -- @@ -324,8 +324,8 @@ -- --- TOC entry 1847 (class 0 OID 0) --- Dependencies: 1551 +-- TOC entry 1993 (class 0 OID 0) +-- Dependencies: 1659 -- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -335,7 +335,7 @@ GRANT SELECT ON TABLE postfix_uzivatel TO posta_cteni; --- Completed on 2009-05-29 21:13:23 CEST +-- Completed on 2009-08-28 17:21:17 CEST -- -- PostgreSQL database dump complete