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