
diff -r 5a7a24ac3a15 -r a9f49669baad sql/schéma.sql
--- a/sql/schéma.sql	Wed Jun 09 15:53:52 2010 +0200
+++ b/sql/schéma.sql	Sun Jan 09 20:11:55 2011 +0100
@@ -2,7 +2,7 @@
 -- PostgreSQL database dump
 --
 
--- Started on 2010-06-09 15:52:26 CEST
+-- Started on 2011-01-08 19:54:48 CET
 
 SET statement_timeout = 0;
 SET client_encoding = 'UTF8';
@@ -36,7 +36,7 @@
 ALTER DOMAIN nekurak.email OWNER TO nekurak;
 
 --
--- TOC entry 1926 (class 0 OID 0)
+-- TOC entry 1941 (class 0 OID 0)
 -- Dependencies: 366
 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
@@ -46,7 +46,7 @@
 
 --
 -- TOC entry 65 (class 1255 OID 35124)
--- Dependencies: 10 406
+-- Dependencies: 411 10
 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
 --
 
@@ -64,7 +64,7 @@
 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
 
 --
--- TOC entry 1927 (class 0 OID 0)
+-- TOC entry 1942 (class 0 OID 0)
 -- Dependencies: 65
 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
@@ -73,7 +73,7 @@
 
 
 --
--- TOC entry 1605 (class 1259 OID 35223)
+-- TOC entry 1610 (class 1259 OID 35223)
 -- Dependencies: 10
 -- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -92,8 +92,8 @@
 SET default_with_oids = false;
 
 --
--- TOC entry 1604 (class 1259 OID 35205)
--- Dependencies: 1888 10
+-- TOC entry 1609 (class 1259 OID 35205)
+-- Dependencies: 1896 10
 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -107,16 +107,16 @@
 ALTER TABLE nekurak.clanek OWNER TO nekurak;
 
 --
--- TOC entry 1929 (class 0 OID 0)
--- Dependencies: 1604
+-- TOC entry 1944 (class 0 OID 0)
+-- Dependencies: 1609
 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
-COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah, (XúHTML.';
+COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah (XHTML).';
 
 
 --
--- TOC entry 1602 (class 1259 OID 35183)
+-- TOC entry 1607 (class 1259 OID 35183)
 -- Dependencies: 10
 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -132,8 +132,8 @@
 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
 
 --
--- TOC entry 1603 (class 1259 OID 35185)
--- Dependencies: 1886 1887 10
+-- TOC entry 1608 (class 1259 OID 35185)
+-- Dependencies: 1894 1895 10
 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -148,8 +148,8 @@
 ALTER TABLE nekurak.fotka OWNER TO nekurak;
 
 --
--- TOC entry 1932 (class 0 OID 0)
--- Dependencies: 1603
+-- TOC entry 1947 (class 0 OID 0)
+-- Dependencies: 1608
 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -157,8 +157,8 @@
 
 
 --
--- TOC entry 1933 (class 0 OID 0)
--- Dependencies: 1603
+-- TOC entry 1948 (class 0 OID 0)
+-- Dependencies: 1608
 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -166,7 +166,7 @@
 
 
 --
--- TOC entry 1607 (class 1259 OID 35250)
+-- TOC entry 1612 (class 1259 OID 35250)
 -- Dependencies: 10
 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -181,8 +181,8 @@
 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
 
 --
--- TOC entry 1608 (class 1259 OID 35278)
--- Dependencies: 1889 1890 10
+-- TOC entry 1613 (class 1259 OID 35278)
+-- Dependencies: 1897 1898 10
 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -198,8 +198,8 @@
 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
 
 --
--- TOC entry 1936 (class 0 OID 0)
--- Dependencies: 1608
+-- TOC entry 1951 (class 0 OID 0)
+-- Dependencies: 1613
 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -209,8 +209,8 @@
 
 
 --
--- TOC entry 1937 (class 0 OID 0)
--- Dependencies: 1608
+-- TOC entry 1952 (class 0 OID 0)
+-- Dependencies: 1613
 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -220,7 +220,46 @@
 
 
 --
--- TOC entry 1609 (class 1259 OID 35333)
+-- TOC entry 1616 (class 1259 OID 35396)
+-- Dependencies: 10
+-- Name: kategorie_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
+--
+
+CREATE SEQUENCE kategorie_seq
+    INCREMENT BY 1
+    NO MAXVALUE
+    NO MINVALUE
+    CACHE 1;
+
+
+ALTER TABLE nekurak.kategorie_seq OWNER TO nekurak;
+
+--
+-- TOC entry 1617 (class 1259 OID 35398)
+-- Dependencies: 1901 10
+-- Name: kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
+--
+
+CREATE TABLE kategorie (
+    id integer DEFAULT nextval('kategorie_seq'::regclass) NOT NULL,
+    nazev character varying(32) NOT NULL,
+    popis character varying(255)
+);
+
+
+ALTER TABLE nekurak.kategorie OWNER TO nekurak;
+
+--
+-- TOC entry 1955 (class 0 OID 0)
+-- Dependencies: 1617
+-- Name: TABLE kategorie; Type: COMMENT; Schema: nekurak; Owner: nekurak
+--
+
+COMMENT ON TABLE kategorie IS 'Kategorie podniku';
+
+
+--
+-- TOC entry 1614 (class 1259 OID 35333)
 -- Dependencies: 10
 -- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -235,8 +274,8 @@
 ALTER TABLE nekurak.komentar_seq OWNER TO nekurak;
 
 --
--- TOC entry 1610 (class 1259 OID 35376)
--- Dependencies: 1891 1892 10
+-- TOC entry 1615 (class 1259 OID 35376)
+-- Dependencies: 1899 1900 10
 -- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -253,8 +292,8 @@
 ALTER TABLE nekurak.komentar OWNER TO nekurak;
 
 --
--- TOC entry 1940 (class 0 OID 0)
--- Dependencies: 1610
+-- TOC entry 1958 (class 0 OID 0)
+-- Dependencies: 1615
 -- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -262,8 +301,8 @@
 
 
 --
--- TOC entry 1941 (class 0 OID 0)
--- Dependencies: 1610
+-- TOC entry 1959 (class 0 OID 0)
+-- Dependencies: 1615
 -- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -271,8 +310,8 @@
 
 
 --
--- TOC entry 1942 (class 0 OID 0)
--- Dependencies: 1610
+-- TOC entry 1960 (class 0 OID 0)
+-- Dependencies: 1615
 -- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -281,7 +320,7 @@
 
 
 --
--- TOC entry 1596 (class 1259 OID 35019)
+-- TOC entry 1601 (class 1259 OID 35019)
 -- Dependencies: 10
 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -296,8 +335,8 @@
 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
 
 --
--- TOC entry 1597 (class 1259 OID 35049)
--- Dependencies: 1882 1883 10
+-- TOC entry 1602 (class 1259 OID 35049)
+-- Dependencies: 1890 1891 10
 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -319,8 +358,8 @@
 ALTER TABLE nekurak.podnik OWNER TO nekurak;
 
 --
--- TOC entry 1945 (class 0 OID 0)
--- Dependencies: 1597
+-- TOC entry 1963 (class 0 OID 0)
+-- Dependencies: 1602
 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -328,7 +367,21 @@
 
 
 --
--- TOC entry 1600 (class 1259 OID 35101)
+-- TOC entry 1618 (class 1259 OID 35404)
+-- Dependencies: 10
+-- Name: podnik_kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
+--
+
+CREATE TABLE podnik_kategorie (
+    podnik integer NOT NULL,
+    kategorie integer NOT NULL
+);
+
+
+ALTER TABLE nekurak.podnik_kategorie OWNER TO nekurak;
+
+--
+-- TOC entry 1605 (class 1259 OID 35101)
 -- Dependencies: 10
 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
@@ -342,8 +395,8 @@
 ALTER TABLE nekurak.role OWNER TO nekurak;
 
 --
--- TOC entry 1947 (class 0 OID 0)
--- Dependencies: 1600
+-- TOC entry 1966 (class 0 OID 0)
+-- Dependencies: 1605
 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -351,7 +404,7 @@
 
 
 --
--- TOC entry 1598 (class 1259 OID 35080)
+-- TOC entry 1603 (class 1259 OID 35080)
 -- Dependencies: 10
 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
 --
@@ -366,8 +419,8 @@
 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
 
 --
--- TOC entry 1599 (class 1259 OID 35091)
--- Dependencies: 1884 1885 10
+-- TOC entry 1604 (class 1259 OID 35091)
+-- Dependencies: 1892 1893 10
 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -385,8 +438,8 @@
 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
 
 --
--- TOC entry 1950 (class 0 OID 0)
--- Dependencies: 1599
+-- TOC entry 1969 (class 0 OID 0)
+-- Dependencies: 1604
 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -394,7 +447,7 @@
 
 
 --
--- TOC entry 1601 (class 1259 OID 35106)
+-- TOC entry 1606 (class 1259 OID 35106)
 -- Dependencies: 10
 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
@@ -408,8 +461,8 @@
 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
 
 --
--- TOC entry 1952 (class 0 OID 0)
--- Dependencies: 1601
+-- TOC entry 1971 (class 0 OID 0)
+-- Dependencies: 1606
 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
 --
 
@@ -417,8 +470,8 @@
 
 
 --
--- TOC entry 1908 (class 2606 OID 35227)
--- Dependencies: 1604 1604
+-- TOC entry 1917 (class 2606 OID 35227)
+-- Dependencies: 1609 1609
 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -427,8 +480,8 @@
 
 
 --
--- TOC entry 1904 (class 2606 OID 35190)
--- Dependencies: 1603 1603
+-- TOC entry 1913 (class 2606 OID 35190)
+-- Dependencies: 1608 1608
 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -437,8 +490,8 @@
 
 
 --
--- TOC entry 1906 (class 2606 OID 35204)
--- Dependencies: 1603 1603 1603
+-- TOC entry 1915 (class 2606 OID 35204)
+-- Dependencies: 1608 1608 1608
 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -447,8 +500,8 @@
 
 
 --
--- TOC entry 1911 (class 2606 OID 35284)
--- Dependencies: 1608 1608
+-- TOC entry 1920 (class 2606 OID 35284)
+-- Dependencies: 1613 1613
 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -457,8 +510,18 @@
 
 
 --
--- TOC entry 1914 (class 2606 OID 35385)
--- Dependencies: 1610 1610
+-- TOC entry 1925 (class 2606 OID 35403)
+-- Dependencies: 1617 1617
+-- Name: kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
+--
+
+ALTER TABLE ONLY kategorie
+    ADD CONSTRAINT kategorie_pk PRIMARY KEY (id);
+
+
+--
+-- TOC entry 1923 (class 2606 OID 35385)
+-- Dependencies: 1615 1615
 -- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -467,8 +530,18 @@
 
 
 --
--- TOC entry 1894 (class 2606 OID 35058)
--- Dependencies: 1597 1597
+-- TOC entry 1927 (class 2606 OID 35408)
+-- Dependencies: 1618 1618 1618
+-- Name: podnik_kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
+--
+
+ALTER TABLE ONLY podnik_kategorie
+    ADD CONSTRAINT podnik_kategorie_pk PRIMARY KEY (podnik, kategorie);
+
+
+--
+-- TOC entry 1903 (class 2606 OID 35058)
+-- Dependencies: 1602 1602
 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -477,8 +550,8 @@
 
 
 --
--- TOC entry 1900 (class 2606 OID 35105)
--- Dependencies: 1600 1600
+-- TOC entry 1909 (class 2606 OID 35105)
+-- Dependencies: 1605 1605
 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -487,8 +560,8 @@
 
 
 --
--- TOC entry 1896 (class 2606 OID 35098)
--- Dependencies: 1599 1599
+-- TOC entry 1905 (class 2606 OID 35098)
+-- Dependencies: 1604 1604
 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -497,8 +570,8 @@
 
 
 --
--- TOC entry 1898 (class 2606 OID 35100)
--- Dependencies: 1599 1599
+-- TOC entry 1907 (class 2606 OID 35100)
+-- Dependencies: 1604 1604
 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -507,8 +580,8 @@
 
 
 --
--- TOC entry 1902 (class 2606 OID 35137)
--- Dependencies: 1601 1601 1601
+-- TOC entry 1911 (class 2606 OID 35137)
+-- Dependencies: 1606 1606 1606
 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -517,8 +590,8 @@
 
 
 --
--- TOC entry 1909 (class 1259 OID 35291)
--- Dependencies: 1608
+-- TOC entry 1918 (class 1259 OID 35291)
+-- Dependencies: 1613
 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -526,8 +599,8 @@
 
 
 --
--- TOC entry 1912 (class 1259 OID 35309)
--- Dependencies: 1608
+-- TOC entry 1921 (class 1259 OID 35309)
+-- Dependencies: 1613
 -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace: 
 --
 
@@ -535,8 +608,8 @@
 
 
 --
--- TOC entry 1922 (class 2620 OID 35125)
--- Dependencies: 1599 65
+-- TOC entry 1937 (class 2620 OID 35125)
+-- Dependencies: 1604 65
 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
 --
 
@@ -547,8 +620,8 @@
 
 
 --
--- TOC entry 1918 (class 2606 OID 35191)
--- Dependencies: 1893 1597 1603
+-- TOC entry 1931 (class 2606 OID 35191)
+-- Dependencies: 1608 1602 1902
 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -557,8 +630,8 @@
 
 
 --
--- TOC entry 1919 (class 2606 OID 35285)
--- Dependencies: 1597 1608 1893
+-- TOC entry 1932 (class 2606 OID 35285)
+-- Dependencies: 1602 1902 1613
 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -567,8 +640,8 @@
 
 
 --
--- TOC entry 1920 (class 2606 OID 35386)
--- Dependencies: 1610 1893 1597
+-- TOC entry 1933 (class 2606 OID 35386)
+-- Dependencies: 1615 1602 1902
 -- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -577,8 +650,8 @@
 
 
 --
--- TOC entry 1921 (class 2606 OID 35391)
--- Dependencies: 1599 1897 1610
+-- TOC entry 1934 (class 2606 OID 35391)
+-- Dependencies: 1615 1906 1604
 -- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -587,8 +660,28 @@
 
 
 --
--- TOC entry 1915 (class 2606 OID 35178)
--- Dependencies: 1599 1897 1597
+-- TOC entry 1936 (class 2606 OID 35414)
+-- Dependencies: 1924 1618 1617
+-- Name: podnik_kategorie_kategorie_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
+--
+
+ALTER TABLE ONLY podnik_kategorie
+    ADD CONSTRAINT podnik_kategorie_kategorie_fk FOREIGN KEY (kategorie) REFERENCES kategorie(id) ON DELETE CASCADE;
+
+
+--
+-- TOC entry 1935 (class 2606 OID 35409)
+-- Dependencies: 1618 1902 1602
+-- Name: podnik_kategorie_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
+--
+
+ALTER TABLE ONLY podnik_kategorie
+    ADD CONSTRAINT podnik_kategorie_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id) ON DELETE CASCADE;
+
+
+--
+-- TOC entry 1928 (class 2606 OID 35178)
+-- Dependencies: 1602 1604 1906
 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -597,8 +690,8 @@
 
 
 --
--- TOC entry 1916 (class 2606 OID 35138)
--- Dependencies: 1600 1601 1899
+-- TOC entry 1929 (class 2606 OID 35138)
+-- Dependencies: 1605 1908 1606
 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -607,8 +700,8 @@
 
 
 --
--- TOC entry 1917 (class 2606 OID 35143)
--- Dependencies: 1599 1897 1601
+-- TOC entry 1930 (class 2606 OID 35143)
+-- Dependencies: 1604 1606 1906
 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
 --
 
@@ -617,7 +710,7 @@
 
 
 --
--- TOC entry 1925 (class 0 OID 0)
+-- TOC entry 1940 (class 0 OID 0)
 -- Dependencies: 10
 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
 --
@@ -629,8 +722,8 @@
 
 
 --
--- TOC entry 1928 (class 0 OID 0)
--- Dependencies: 1605
+-- TOC entry 1943 (class 0 OID 0)
+-- Dependencies: 1610
 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -641,8 +734,8 @@
 
 
 --
--- TOC entry 1930 (class 0 OID 0)
--- Dependencies: 1604
+-- TOC entry 1945 (class 0 OID 0)
+-- Dependencies: 1609
 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -653,8 +746,8 @@
 
 
 --
--- TOC entry 1931 (class 0 OID 0)
--- Dependencies: 1602
+-- TOC entry 1946 (class 0 OID 0)
+-- Dependencies: 1607
 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -665,8 +758,8 @@
 
 
 --
--- TOC entry 1934 (class 0 OID 0)
--- Dependencies: 1603
+-- TOC entry 1949 (class 0 OID 0)
+-- Dependencies: 1608
 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -677,8 +770,8 @@
 
 
 --
--- TOC entry 1935 (class 0 OID 0)
--- Dependencies: 1607
+-- TOC entry 1950 (class 0 OID 0)
+-- Dependencies: 1612
 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -689,8 +782,8 @@
 
 
 --
--- TOC entry 1938 (class 0 OID 0)
--- Dependencies: 1608
+-- TOC entry 1953 (class 0 OID 0)
+-- Dependencies: 1613
 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -701,8 +794,32 @@
 
 
 --
--- TOC entry 1939 (class 0 OID 0)
--- Dependencies: 1609
+-- TOC entry 1954 (class 0 OID 0)
+-- Dependencies: 1616
+-- Name: kategorie_seq; Type: ACL; Schema: nekurak; Owner: nekurak
+--
+
+REVOKE ALL ON SEQUENCE kategorie_seq FROM PUBLIC;
+REVOKE ALL ON SEQUENCE kategorie_seq FROM nekurak;
+GRANT ALL ON SEQUENCE kategorie_seq TO nekurak;
+GRANT USAGE ON SEQUENCE kategorie_seq TO nekurak_web;
+
+
+--
+-- TOC entry 1956 (class 0 OID 0)
+-- Dependencies: 1617
+-- Name: kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
+--
+
+REVOKE ALL ON TABLE kategorie FROM PUBLIC;
+REVOKE ALL ON TABLE kategorie FROM nekurak;
+GRANT ALL ON TABLE kategorie TO nekurak;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE kategorie TO nekurak_web;
+
+
+--
+-- TOC entry 1957 (class 0 OID 0)
+-- Dependencies: 1614
 -- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -713,8 +830,8 @@
 
 
 --
--- TOC entry 1943 (class 0 OID 0)
--- Dependencies: 1610
+-- TOC entry 1961 (class 0 OID 0)
+-- Dependencies: 1615
 -- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -725,8 +842,8 @@
 
 
 --
--- TOC entry 1944 (class 0 OID 0)
--- Dependencies: 1596
+-- TOC entry 1962 (class 0 OID 0)
+-- Dependencies: 1601
 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -737,8 +854,8 @@
 
 
 --
--- TOC entry 1946 (class 0 OID 0)
--- Dependencies: 1597
+-- TOC entry 1964 (class 0 OID 0)
+-- Dependencies: 1602
 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -749,8 +866,20 @@
 
 
 --
--- TOC entry 1948 (class 0 OID 0)
--- Dependencies: 1600
+-- TOC entry 1965 (class 0 OID 0)
+-- Dependencies: 1618
+-- Name: podnik_kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
+--
+
+REVOKE ALL ON TABLE podnik_kategorie FROM PUBLIC;
+REVOKE ALL ON TABLE podnik_kategorie FROM nekurak;
+GRANT ALL ON TABLE podnik_kategorie TO nekurak;
+GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik_kategorie TO nekurak_web;
+
+
+--
+-- TOC entry 1967 (class 0 OID 0)
+-- Dependencies: 1605
 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -761,8 +890,8 @@
 
 
 --
--- TOC entry 1949 (class 0 OID 0)
--- Dependencies: 1598
+-- TOC entry 1968 (class 0 OID 0)
+-- Dependencies: 1603
 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -773,8 +902,8 @@
 
 
 --
--- TOC entry 1951 (class 0 OID 0)
--- Dependencies: 1599
+-- TOC entry 1970 (class 0 OID 0)
+-- Dependencies: 1604
 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -785,8 +914,8 @@
 
 
 --
--- TOC entry 1953 (class 0 OID 0)
--- Dependencies: 1601
+-- TOC entry 1972 (class 0 OID 0)
+-- Dependencies: 1606
 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
 --
 
@@ -796,7 +925,7 @@
 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
 
 
--- Completed on 2010-06-09 15:52:28 CEST
+-- Completed on 2011-01-08 19:54:50 CET
 
 --
 -- PostgreSQL database dump complete




