franta-hg@0: --
franta-hg@0: -- PostgreSQL database dump
franta-hg@0: --
franta-hg@0: 
franta-hg@24: -- Started on 2011-12-03 17:50:08 CET
franta-hg@0: 
franta-hg@24: SET statement_timeout = 0;
franta-hg@0: SET client_encoding = 'UTF8';
franta-hg@0: SET standard_conforming_strings = off;
franta-hg@0: SET check_function_bodies = false;
franta-hg@0: SET client_min_messages = warning;
franta-hg@0: SET escape_string_warning = off;
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 7 (class 2615 OID 16397)
franta-hg@24: -- Name: posta; Type: SCHEMA; Schema: -; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE SCHEMA posta;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER SCHEMA posta OWNER TO posta;
franta-hg@24: 
franta-hg@0: SET search_path = posta, pg_catalog;
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 189 (class 1255 OID 16398)
franta-hg@24: -- Dependencies: 7 551
franta-hg@24: -- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: FUNCTION; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@16: CREATE FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) RETURNS text
franta-hg@24:     LANGUAGE plpgsql SECURITY DEFINER
franta-hg@17:     AS $$DECLARE pocet integer;
franta-hg@12: BEGIN
franta-hg@12: UPDATE uzivatel
franta-hg@16:  SET heslo = md5("Nove_heslo")
franta-hg@16:  WHERE 	uzivatel.login = "Login"
franta-hg@16: 	AND uzivatel.domena = "Domena"
franta-hg@16: 	AND uzivatel.heslo = md5("Stare_heslo");
franta-hg@12: 	GET DIAGNOSTICS pocet = ROW_COUNT;
franta-hg@12: 	IF pocet = 1 THEN
franta-hg@17: 		RETURN 'Změna hesla pro ' || "Login" || '@' || "Domena" || ' proběhla úspěšně.';
franta-hg@12: 	ELSE
franta-hg@17: 		RAISE EXCEPTION 'Nesprávné heslo, nebo uživatel % neexistuje', "Login" || '@' || "Domena";
franta-hg@12: 	END IF;
franta-hg@12: END;
franta-hg@24: 	$$;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER FUNCTION posta.zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1900 (class 0 OID 0)
franta-hg@24: -- Dependencies: 189
franta-hg@24: -- Name: FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying); Type: COMMENT; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@16: COMMENT ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) IS 'Změní heslo uživatele.';
franta-hg@0: 
franta-hg@0: 
franta-hg@0: SET default_tablespace = '';
franta-hg@0: 
franta-hg@0: SET default_with_oids = false;
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 143 (class 1259 OID 16399)
franta-hg@24: -- Dependencies: 7
franta-hg@24: -- Name: alias; Type: TABLE; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE TABLE alias (
franta-hg@14:     zdroj_jmeno character varying(255) NOT NULL,
franta-hg@14:     zdroj_domena character varying(255) NOT NULL,
franta-hg@14:     cil_jmeno character varying(255) NOT NULL,
franta-hg@17:     cil_domena character varying(255) NOT NULL
franta-hg@0: );
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.alias OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1902 (class 0 OID 0)
franta-hg@24: -- Dependencies: 143
franta-hg@24: -- Name: COLUMN alias.zdroj_jmeno; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@14: --
franta-hg@14: 
franta-hg@15: COMMENT ON COLUMN alias.zdroj_jmeno IS 'Část zdrojové adresy před zavináčem.
franta-hg@15: (sem přijde zpráva)';
franta-hg@14: 
franta-hg@14: 
franta-hg@14: --
franta-hg@24: -- TOC entry 1903 (class 0 OID 0)
franta-hg@24: -- Dependencies: 143
franta-hg@24: -- Name: COLUMN alias.zdroj_domena; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@14: --
franta-hg@14: 
franta-hg@15: COMMENT ON COLUMN alias.zdroj_domena IS 'Část zdrojové adresy za zavináčem.
franta-hg@15: (sem přijde zpráva)';
franta-hg@14: 
franta-hg@14: 
franta-hg@14: --
franta-hg@24: -- TOC entry 1904 (class 0 OID 0)
franta-hg@24: -- Dependencies: 143
franta-hg@24: -- Name: COLUMN alias.cil_jmeno; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@14: --
franta-hg@14: 
franta-hg@15: COMMENT ON COLUMN alias.cil_jmeno IS 'Část cílové adresy před zavináčem.
franta-hg@14: (sem zprávu předáme)';
franta-hg@14: 
franta-hg@14: 
franta-hg@14: --
franta-hg@24: -- TOC entry 1905 (class 0 OID 0)
franta-hg@24: -- Dependencies: 143
franta-hg@24: -- Name: COLUMN alias.cil_domena; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@14: --
franta-hg@14: 
franta-hg@15: COMMENT ON COLUMN alias.cil_domena IS 'Část cílové adresy za zavináčem.
franta-hg@14: (sem zprávu předáme)';
franta-hg@14: 
franta-hg@14: 
franta-hg@14: --
franta-hg@24: -- TOC entry 144 (class 1259 OID 16405)
franta-hg@24: -- Dependencies: 7
franta-hg@24: -- Name: domena; Type: TABLE; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE TABLE domena (
franta-hg@0:     domena character varying(255) NOT NULL
franta-hg@0: );
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.domena OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 145 (class 1259 OID 16408)
franta-hg@24: -- Dependencies: 1691 7
franta-hg@24: -- Name: alias_externi; Type: VIEW; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: CREATE VIEW alias_externi AS
franta-hg@24:     SELECT a.zdroj_jmeno, a.zdroj_domena, a.cil_jmeno, a.cil_domena FROM (alias a LEFT JOIN domena d ON (((a.cil_domena)::text = (d.domena)::text))) WHERE (d.domena IS NULL);
franta-hg@24: 
franta-hg@24: 
franta-hg@24: ALTER TABLE posta.alias_externi OWNER TO posta;
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 1908 (class 0 OID 0)
franta-hg@24: -- Dependencies: 145
franta-hg@24: -- Name: VIEW alias_externi; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: COMMENT ON VIEW alias_externi IS 'Poštovní alias, který vede na doménu nacházející se na jiném serveru (tzn. e-mail opouští Veverku)';
franta-hg@24: 
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 146 (class 1259 OID 16412)
franta-hg@24: -- Dependencies: 1692 7
franta-hg@24: -- Name: alias_interni; Type: VIEW; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: CREATE VIEW alias_interni AS
franta-hg@24:     SELECT a.zdroj_jmeno, a.zdroj_domena, a.cil_jmeno, a.cil_domena FROM (alias a LEFT JOIN domena d ON (((a.cil_domena)::text = (d.domena)::text))) WHERE (d.domena IS NOT NULL);
franta-hg@24: 
franta-hg@24: 
franta-hg@24: ALTER TABLE posta.alias_interni OWNER TO posta;
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 1909 (class 0 OID 0)
franta-hg@24: -- Dependencies: 146
franta-hg@24: -- Name: VIEW alias_interni; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: COMMENT ON VIEW alias_interni IS 'Poštovní alias, který vede na doménu nacházející se na tomto serveru (tzn. e-mail neopouští Veverku)';
franta-hg@24: 
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 147 (class 1259 OID 16416)
franta-hg@24: -- Dependencies: 7
franta-hg@24: -- Name: uzivatel; Type: TABLE; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE TABLE uzivatel (
franta-hg@0:     login character varying(255) NOT NULL,
franta-hg@0:     heslo character varying(512),
franta-hg@24:     domena character varying(255) NOT NULL,
franta-hg@24:     jmeno character varying(32)
franta-hg@0: );
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.uzivatel OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1910 (class 0 OID 0)
franta-hg@24: -- Dependencies: 147
franta-hg@24: -- Name: COLUMN uzivatel.jmeno; Type: COMMENT; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: COMMENT ON COLUMN uzivatel.jmeno IS 'Celé jméno uživatele';
franta-hg@24: 
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 148 (class 1259 OID 16422)
franta-hg@24: -- Dependencies: 1693 7
franta-hg@24: -- Name: dovecot_heslo; Type: VIEW; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE VIEW dovecot_heslo AS
franta-hg@0:     SELECT (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS "user", uzivatel.heslo AS password, uzivatel.login, uzivatel.domena FROM uzivatel;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.dovecot_heslo OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 149 (class 1259 OID 16426)
franta-hg@24: -- Dependencies: 1694 7
franta-hg@24: -- Name: dovecot_uzivatel; Type: VIEW; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE VIEW dovecot_uzivatel AS
franta-hg@24:     SELECT 5000 AS uid, 5000 AS gid, ((('/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) AS home, (((('maildir:/var/mail/virtualniposta/'::text || (uzivatel.domena)::text) || '/'::text) || (uzivatel.login)::text) || '/Maildir'::text) AS mail, 'maildir:Maximalni velikost schranky'::text AS quota, '*:storage=1G'::text AS quota_rule, uzivatel.login, uzivatel.domena FROM uzivatel;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.dovecot_uzivatel OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 150 (class 1259 OID 16430)
franta-hg@24: -- Dependencies: 1695 7
franta-hg@24: -- Name: postfix_alias; Type: VIEW; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE VIEW postfix_alias AS
franta-hg@14:     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;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.postfix_alias OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 151 (class 1259 OID 16434)
franta-hg@24: -- Dependencies: 1696 7
franta-hg@24: -- Name: postfix_uzivatel; Type: VIEW; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: CREATE VIEW postfix_uzivatel AS
franta-hg@0:     SELECT ((((uzivatel.domena)::text || '/'::text) || (uzivatel.login)::text) || '/Maildir/'::text) AS cesta, uzivatel.login, uzivatel.domena FROM uzivatel;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: ALTER TABLE posta.postfix_uzivatel OWNER TO posta;
franta-hg@24: 
franta-hg@0: --
franta-hg@24: -- TOC entry 152 (class 1259 OID 16438)
franta-hg@24: -- Dependencies: 1697 7
franta-hg@24: -- Name: sogo_uzivatel; Type: VIEW; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: CREATE VIEW sogo_uzivatel AS
franta-hg@24:     SELECT (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS c_uid, COALESCE((uzivatel.jmeno)::text, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text)) AS c_cn, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS c_name, (((uzivatel.login)::text || '@'::text) || (uzivatel.domena)::text) AS mail, uzivatel.heslo AS c_password FROM uzivatel;
franta-hg@24: 
franta-hg@24: 
franta-hg@24: ALTER TABLE posta.sogo_uzivatel OWNER TO posta;
franta-hg@24: 
franta-hg@24: --
franta-hg@24: -- TOC entry 1890 (class 2606 OID 16443)
franta-hg@24: -- Dependencies: 143 143 143 143 143
franta-hg@24: -- Name: aliasy_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: ALTER TABLE ONLY alias
franta-hg@17:     ADD CONSTRAINT aliasy_pk PRIMARY KEY (zdroj_jmeno, zdroj_domena, cil_jmeno, cil_domena);
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1892 (class 2606 OID 16445)
franta-hg@24: -- Dependencies: 144 144
franta-hg@24: -- Name: domena_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: ALTER TABLE ONLY domena
franta-hg@0:     ADD CONSTRAINT domena_pk PRIMARY KEY (domena);
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1894 (class 2606 OID 16447)
franta-hg@24: -- Dependencies: 147 147 147
franta-hg@24: -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: posta; Owner: posta; Tablespace: 
franta-hg@0: --
franta-hg@0: 
franta-hg@0: ALTER TABLE ONLY uzivatel
franta-hg@0:     ADD CONSTRAINT uzivatel_pk PRIMARY KEY (login, domena);
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1895 (class 2606 OID 16448)
franta-hg@24: -- Dependencies: 143 1891 144
franta-hg@24: -- Name: alias_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: ALTER TABLE ONLY alias
franta-hg@14:     ADD CONSTRAINT alias_domena_fk FOREIGN KEY (zdroj_domena) REFERENCES domena(domena);
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1896 (class 2606 OID 16453)
franta-hg@24: -- Dependencies: 1891 144 147
franta-hg@24: -- Name: uzivatel_domena_fk; Type: FK CONSTRAINT; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: ALTER TABLE ONLY uzivatel
franta-hg@0:     ADD CONSTRAINT uzivatel_domena_fk FOREIGN KEY (domena) REFERENCES domena(domena);
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1899 (class 0 OID 0)
franta-hg@24: -- Dependencies: 7
franta-hg@24: -- Name: posta; Type: ACL; Schema: -; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON SCHEMA posta FROM PUBLIC;
franta-hg@0: REVOKE ALL ON SCHEMA posta FROM posta;
franta-hg@0: GRANT ALL ON SCHEMA posta TO posta;
franta-hg@0: GRANT USAGE ON SCHEMA posta TO posta_cteni;
franta-hg@12: GRANT USAGE ON SCHEMA posta TO posta_zmena_hesla;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1901 (class 0 OID 0)
franta-hg@24: -- Dependencies: 189
franta-hg@24: -- Name: zmen_heslo(character varying, character varying, character varying, character varying); Type: ACL; Schema: posta; Owner: posta
franta-hg@12: --
franta-hg@12: 
franta-hg@16: REVOKE ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) FROM PUBLIC;
franta-hg@16: REVOKE ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) FROM posta;
franta-hg@16: GRANT ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) TO posta;
franta-hg@16: GRANT ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) TO PUBLIC;
franta-hg@16: GRANT ALL ON FUNCTION zmen_heslo("Login" character varying, "Domena" character varying, "Stare_heslo" character varying, "Nove_heslo" character varying) TO posta_zmena_hesla;
franta-hg@12: 
franta-hg@12: 
franta-hg@12: --
franta-hg@24: -- TOC entry 1906 (class 0 OID 0)
franta-hg@24: -- Dependencies: 143
franta-hg@24: -- Name: alias; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE alias FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE alias FROM posta;
franta-hg@0: GRANT ALL ON TABLE alias TO posta;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1907 (class 0 OID 0)
franta-hg@24: -- Dependencies: 144
franta-hg@24: -- Name: domena; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE domena FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE domena FROM posta;
franta-hg@0: GRANT ALL ON TABLE domena TO posta;
franta-hg@0: GRANT SELECT ON TABLE domena TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1911 (class 0 OID 0)
franta-hg@24: -- Dependencies: 147
franta-hg@24: -- Name: uzivatel; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE uzivatel FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE uzivatel FROM posta;
franta-hg@0: GRANT ALL ON TABLE uzivatel TO posta;
franta-hg@0: GRANT SELECT ON TABLE uzivatel TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1912 (class 0 OID 0)
franta-hg@24: -- Dependencies: 148
franta-hg@24: -- Name: dovecot_heslo; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE dovecot_heslo FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE dovecot_heslo FROM posta;
franta-hg@0: GRANT ALL ON TABLE dovecot_heslo TO posta;
franta-hg@0: GRANT SELECT ON TABLE dovecot_heslo TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1913 (class 0 OID 0)
franta-hg@24: -- Dependencies: 149
franta-hg@24: -- Name: dovecot_uzivatel; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE dovecot_uzivatel FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE dovecot_uzivatel FROM posta;
franta-hg@0: GRANT ALL ON TABLE dovecot_uzivatel TO posta;
franta-hg@0: GRANT SELECT ON TABLE dovecot_uzivatel TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1914 (class 0 OID 0)
franta-hg@24: -- Dependencies: 150
franta-hg@24: -- Name: postfix_alias; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE postfix_alias FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE postfix_alias FROM posta;
franta-hg@0: GRANT ALL ON TABLE postfix_alias TO posta;
franta-hg@0: GRANT SELECT ON TABLE postfix_alias TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@0: --
franta-hg@24: -- TOC entry 1915 (class 0 OID 0)
franta-hg@24: -- Dependencies: 151
franta-hg@24: -- Name: postfix_uzivatel; Type: ACL; Schema: posta; Owner: posta
franta-hg@0: --
franta-hg@0: 
franta-hg@0: REVOKE ALL ON TABLE postfix_uzivatel FROM PUBLIC;
franta-hg@0: REVOKE ALL ON TABLE postfix_uzivatel FROM posta;
franta-hg@0: GRANT ALL ON TABLE postfix_uzivatel TO posta;
franta-hg@0: GRANT SELECT ON TABLE postfix_uzivatel TO posta_cteni;
franta-hg@0: 
franta-hg@0: 
franta-hg@24: --
franta-hg@24: -- TOC entry 1916 (class 0 OID 0)
franta-hg@24: -- Dependencies: 152
franta-hg@24: -- Name: sogo_uzivatel; Type: ACL; Schema: posta; Owner: posta
franta-hg@24: --
franta-hg@24: 
franta-hg@24: REVOKE ALL ON TABLE sogo_uzivatel FROM PUBLIC;
franta-hg@24: REVOKE ALL ON TABLE sogo_uzivatel FROM posta;
franta-hg@24: GRANT ALL ON TABLE sogo_uzivatel TO posta;
franta-hg@24: GRANT SELECT ON TABLE sogo_uzivatel TO posta_cteni;
franta-hg@24: 
franta-hg@24: 
franta-hg@24: -- Completed on 2011-12-03 17:50:08 CET
franta-hg@0: 
franta-hg@0: --
franta-hg@0: -- PostgreSQL database dump complete
franta-hg@0: --
franta-hg@0: