sql/schéma.sql
changeset 19 5d93bf1c8093
parent 18 0deb8f6abcf5
child 62 d9df3f7b67dd
     1.1 --- a/sql/schéma.sql	Sat Jan 16 02:43:45 2010 +0100
     1.2 +++ b/sql/schéma.sql	Mon Jan 25 17:44:00 2010 +0100
     1.3 @@ -2,7 +2,7 @@
     1.4  -- PostgreSQL database dump
     1.5  --
     1.6  
     1.7 --- Started on 2010-01-16 02:43:00 CET
     1.8 +-- Started on 2010-01-25 17:42:09 CET
     1.9  
    1.10  SET statement_timeout = 0;
    1.11  SET client_encoding = 'UTF8';
    1.12 @@ -39,7 +39,7 @@
    1.13  ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
    1.14  
    1.15  --
    1.16 --- TOC entry 1847 (class 0 OID 0)
    1.17 +-- TOC entry 1848 (class 0 OID 0)
    1.18  -- Dependencies: 1568
    1.19  -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak
    1.20  --
    1.21 @@ -89,7 +89,43 @@
    1.22      ADD CONSTRAINT podnik_pk PRIMARY KEY (id);
    1.23  
    1.24  
    1.25 --- Completed on 2010-01-16 02:43:01 CET
    1.26 +--
    1.27 +-- TOC entry 1847 (class 0 OID 0)
    1.28 +-- Dependencies: 10
    1.29 +-- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
    1.30 +--
    1.31 +
    1.32 +REVOKE ALL ON SCHEMA nekurak FROM PUBLIC;
    1.33 +REVOKE ALL ON SCHEMA nekurak FROM nekurak;
    1.34 +GRANT ALL ON SCHEMA nekurak TO nekurak;
    1.35 +GRANT USAGE ON SCHEMA nekurak TO nekurak_web;
    1.36 +
    1.37 +
    1.38 +--
    1.39 +-- TOC entry 1849 (class 0 OID 0)
    1.40 +-- Dependencies: 1568
    1.41 +-- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
    1.42 +--
    1.43 +
    1.44 +REVOKE ALL ON SEQUENCE podnik_seq FROM PUBLIC;
    1.45 +REVOKE ALL ON SEQUENCE podnik_seq FROM nekurak;
    1.46 +GRANT ALL ON SEQUENCE podnik_seq TO nekurak;
    1.47 +GRANT USAGE ON SEQUENCE podnik_seq TO nekurak_web;
    1.48 +
    1.49 +
    1.50 +--
    1.51 +-- TOC entry 1850 (class 0 OID 0)
    1.52 +-- Dependencies: 1569
    1.53 +-- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
    1.54 +--
    1.55 +
    1.56 +REVOKE ALL ON TABLE podnik FROM PUBLIC;
    1.57 +REVOKE ALL ON TABLE podnik FROM nekurak;
    1.58 +GRANT ALL ON TABLE podnik TO nekurak;
    1.59 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik TO nekurak_web;
    1.60 +
    1.61 +
    1.62 +-- Completed on 2010-01-25 17:42:10 CET
    1.63  
    1.64  --
    1.65  -- PostgreSQL database dump complete