diff -r 0deb8f6abcf5 -r 2d84736776a9 sql/schéma.sql --- a/sql/schéma.sql Sat Jan 16 02:43:45 2010 +0100 +++ b/sql/schéma.sql Thu Feb 18 10:42:38 2010 +0100 @@ -2,7 +2,7 @@ -- PostgreSQL database dump -- --- Started on 2010-01-16 02:43:00 CET +-- Started on 2010-01-25 17:42:09 CET SET statement_timeout = 0; SET client_encoding = 'UTF8'; @@ -39,7 +39,7 @@ ALTER TABLE nekurak.podnik_seq OWNER TO nekurak; -- --- TOC entry 1847 (class 0 OID 0) +-- TOC entry 1848 (class 0 OID 0) -- Dependencies: 1568 -- Name: podnik_seq; Type: SEQUENCE SET; Schema: nekurak; Owner: nekurak -- @@ -89,7 +89,43 @@ ADD CONSTRAINT podnik_pk PRIMARY KEY (id); --- Completed on 2010-01-16 02:43:01 CET +-- +-- TOC entry 1847 (class 0 OID 0) +-- Dependencies: 10 +-- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak +-- + +REVOKE ALL ON SCHEMA nekurak FROM PUBLIC; +REVOKE ALL ON SCHEMA nekurak FROM nekurak; +GRANT ALL ON SCHEMA nekurak TO nekurak; +GRANT USAGE ON SCHEMA nekurak TO nekurak_web; + + +-- +-- TOC entry 1849 (class 0 OID 0) +-- Dependencies: 1568 +-- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak +-- + +REVOKE ALL ON SEQUENCE podnik_seq FROM PUBLIC; +REVOKE ALL ON SEQUENCE podnik_seq FROM nekurak; +GRANT ALL ON SEQUENCE podnik_seq TO nekurak; +GRANT USAGE ON SEQUENCE podnik_seq TO nekurak_web; + + +-- +-- TOC entry 1850 (class 0 OID 0) +-- Dependencies: 1569 +-- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak +-- + +REVOKE ALL ON TABLE podnik FROM PUBLIC; +REVOKE ALL ON TABLE podnik FROM nekurak; +GRANT ALL ON TABLE podnik TO nekurak; +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik TO nekurak_web; + + +-- Completed on 2010-01-25 17:42:10 CET -- -- PostgreSQL database dump complete