# HG changeset patch # User František Kučera # Date 1241972284 -7200 # Node ID c830b05699ba2d6f148b06a91e66bdf7fb4a0366 # Parent 119744ae41797ff7680e05ceb7bf0fdb57645a5f Normalizace tabulky aliasů – zvláštní sloupeček pro jméno a doménu v cílové e-mailové adrese. V pohledu používaném Postfixem se nic nemění – ten vypadá pořád stejně diff -r 119744ae4179 -r c830b05699ba sql/schéma.sql --- a/sql/schéma.sql Sun May 10 01:13:12 2009 +0200 +++ b/sql/schéma.sql Sun May 10 18:18:04 2009 +0200 @@ -2,7 +2,7 @@ -- PostgreSQL database dump -- --- Started on 2009-05-06 02:13:29 CEST +-- Started on 2009-05-10 17:40:57 CEST SET client_encoding = 'UTF8'; SET standard_conforming_strings = off; @@ -65,13 +65,52 @@ -- CREATE TABLE alias ( - login character varying(255) NOT NULL, - domena character varying(255) NOT NULL, - cilova_adresa character varying(255) NOT NULL + 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) ); -- +-- TOC entry 1837 (class 0 OID 0) +-- Dependencies: 1549 +-- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: - +-- + +COMMENT ON COLUMN alias.zdroj_jmeno IS 'Část zdrojové adresy před zavináčem'; + + +-- +-- TOC entry 1838 (class 0 OID 0) +-- Dependencies: 1549 +-- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: - +-- + +COMMENT ON COLUMN alias.zdroj_domena IS 'Část zdrojové adresy za zavináčem'; + + +-- +-- TOC entry 1839 (class 0 OID 0) +-- Dependencies: 1549 +-- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: - +-- + +COMMENT ON COLUMN alias.cil_jmeno IS 'Část cílové adresy před zavináčem +(sem zprávu předáme)'; + + +-- +-- TOC entry 1840 (class 0 OID 0) +-- Dependencies: 1549 +-- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: - +-- + +COMMENT ON COLUMN alias.cil_domena IS 'Část cílové adresy za zavináčem +(sem zprávu předáme)'; + + +-- -- TOC entry 1536 (class 1259 OID 16396) -- Dependencies: 8 -- Name: domena; Type: TABLE; Schema: posta; Owner: -; Tablespace: @@ -96,8 +135,8 @@ -- --- TOC entry 1551 (class 1259 OID 16602) --- Dependencies: 1630 8 +-- TOC entry 1550 (class 1259 OID 16602) +-- Dependencies: 1629 8 -- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: - -- @@ -106,8 +145,8 @@ -- --- TOC entry 1553 (class 1259 OID 16631) --- Dependencies: 1632 8 +-- TOC entry 1552 (class 1259 OID 16631) +-- Dependencies: 1631 8 -- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: - -- @@ -116,18 +155,18 @@ -- --- TOC entry 1550 (class 1259 OID 16563) --- Dependencies: 1629 8 +-- TOC entry 1553 (class 1259 OID 16695) +-- Dependencies: 1632 8 -- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: - -- CREATE VIEW postfix_alias AS - SELECT (((alias.login)::text || '@'::text) || (alias.domena)::text) AS zdroj, alias.cilova_adresa AS cil FROM alias; + SELECT (((alias.zdroj_jmeno)::text || '@'::text) || (alias.zdroj_domena)::text) AS zdroj, (((alias.cil_jmeno)::text || '@'::text) || (alias.cil_domena)::text) AS cil FROM alias; -- --- TOC entry 1552 (class 1259 OID 16607) --- Dependencies: 1631 8 +-- TOC entry 1551 (class 1259 OID 16607) +-- Dependencies: 1630 8 -- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: - -- @@ -142,7 +181,7 @@ -- ALTER TABLE ONLY alias - ADD CONSTRAINT aliasy_pk PRIMARY KEY (login, domena, cilova_adresa); + ADD CONSTRAINT aliasy_pk PRIMARY KEY (zdroj_jmeno, zdroj_domena, cil_jmeno); -- @@ -167,17 +206,17 @@ -- -- TOC entry 1831 (class 2606 OID 16558) --- Dependencies: 1824 1536 1549 +-- Dependencies: 1536 1549 1824 -- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: - -- ALTER TABLE ONLY alias - ADD CONSTRAINT alias_domena_fk FOREIGN KEY (domena) REFERENCES domena(domena); + ADD CONSTRAINT alias_domena_fk FOREIGN KEY (zdroj_domena) REFERENCES domena(domena); -- -- TOC entry 1830 (class 2606 OID 16417) --- Dependencies: 1537 1536 1824 +-- Dependencies: 1536 1824 1537 -- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: - -- @@ -212,7 +251,7 @@ -- --- TOC entry 1837 (class 0 OID 0) +-- TOC entry 1841 (class 0 OID 0) -- Dependencies: 1549 -- Name: alias; Type: ACL; Schema: posta; Owner: - -- @@ -223,7 +262,7 @@ -- --- TOC entry 1838 (class 0 OID 0) +-- TOC entry 1842 (class 0 OID 0) -- Dependencies: 1536 -- Name: domena; Type: ACL; Schema: posta; Owner: - -- @@ -235,7 +274,7 @@ -- --- TOC entry 1839 (class 0 OID 0) +-- TOC entry 1843 (class 0 OID 0) -- Dependencies: 1537 -- Name: uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -247,8 +286,8 @@ -- --- TOC entry 1840 (class 0 OID 0) --- Dependencies: 1551 +-- TOC entry 1844 (class 0 OID 0) +-- Dependencies: 1550 -- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: - -- @@ -259,8 +298,8 @@ -- --- TOC entry 1841 (class 0 OID 0) --- Dependencies: 1553 +-- TOC entry 1845 (class 0 OID 0) +-- Dependencies: 1552 -- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -271,8 +310,8 @@ -- --- TOC entry 1842 (class 0 OID 0) --- Dependencies: 1550 +-- TOC entry 1846 (class 0 OID 0) +-- Dependencies: 1553 -- Name: postfix_alias; Type: ACL; Schema: posta; Owner: - -- @@ -283,8 +322,8 @@ -- --- TOC entry 1843 (class 0 OID 0) --- Dependencies: 1552 +-- TOC entry 1847 (class 0 OID 0) +-- Dependencies: 1551 -- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: - -- @@ -294,7 +333,7 @@ GRANT SELECT ON TABLE postfix_uzivatel TO posta_cteni; --- Completed on 2009-05-06 02:13:36 CEST +-- Completed on 2009-05-10 17:41:05 CEST -- -- PostgreSQL database dump complete