# HG changeset patch
# User František Kučera <franta-hg@frantovo.cz>
# 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