sql/schéma.sql
changeset 163 5f0d5e1305b3
parent 154 bf21a4abea9b
child 173 2b458ac09044
     1.1 --- a/sql/schéma.sql	Mon Jan 10 17:27:53 2011 +0100
     1.2 +++ b/sql/schéma.sql	Tue Jan 11 15:27:51 2011 +0100
     1.3 @@ -2,7 +2,7 @@
     1.4  -- PostgreSQL database dump
     1.5  --
     1.6  
     1.7 --- Started on 2011-01-08 19:54:48 CET
     1.8 +-- Started on 2011-01-11 15:26:21 CET
     1.9  
    1.10  SET statement_timeout = 0;
    1.11  SET client_encoding = 'UTF8';
    1.12 @@ -36,7 +36,7 @@
    1.13  ALTER DOMAIN nekurak.email OWNER TO nekurak;
    1.14  
    1.15  --
    1.16 --- TOC entry 1941 (class 0 OID 0)
    1.17 +-- TOC entry 1942 (class 0 OID 0)
    1.18  -- Dependencies: 366
    1.19  -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.20  --
    1.21 @@ -64,7 +64,7 @@
    1.22  ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
    1.23  
    1.24  --
    1.25 --- TOC entry 1942 (class 0 OID 0)
    1.26 +-- TOC entry 1943 (class 0 OID 0)
    1.27  -- Dependencies: 65
    1.28  -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.29  --
    1.30 @@ -93,7 +93,7 @@
    1.31  
    1.32  --
    1.33  -- TOC entry 1609 (class 1259 OID 35205)
    1.34 --- Dependencies: 1896 10
    1.35 +-- Dependencies: 1897 10
    1.36  -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    1.37  --
    1.38  
    1.39 @@ -107,7 +107,7 @@
    1.40  ALTER TABLE nekurak.clanek OWNER TO nekurak;
    1.41  
    1.42  --
    1.43 --- TOC entry 1944 (class 0 OID 0)
    1.44 +-- TOC entry 1945 (class 0 OID 0)
    1.45  -- Dependencies: 1609
    1.46  -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.47  --
    1.48 @@ -133,7 +133,7 @@
    1.49  
    1.50  --
    1.51  -- TOC entry 1608 (class 1259 OID 35185)
    1.52 --- Dependencies: 1894 1895 10
    1.53 +-- Dependencies: 1895 1896 10
    1.54  -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    1.55  --
    1.56  
    1.57 @@ -148,7 +148,7 @@
    1.58  ALTER TABLE nekurak.fotka OWNER TO nekurak;
    1.59  
    1.60  --
    1.61 --- TOC entry 1947 (class 0 OID 0)
    1.62 +-- TOC entry 1948 (class 0 OID 0)
    1.63  -- Dependencies: 1608
    1.64  -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.65  --
    1.66 @@ -157,7 +157,7 @@
    1.67  
    1.68  
    1.69  --
    1.70 --- TOC entry 1948 (class 0 OID 0)
    1.71 +-- TOC entry 1949 (class 0 OID 0)
    1.72  -- Dependencies: 1608
    1.73  -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.74  --
    1.75 @@ -182,7 +182,7 @@
    1.76  
    1.77  --
    1.78  -- TOC entry 1613 (class 1259 OID 35278)
    1.79 --- Dependencies: 1897 1898 10
    1.80 +-- Dependencies: 1898 1899 10
    1.81  -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    1.82  --
    1.83  
    1.84 @@ -198,7 +198,7 @@
    1.85  ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
    1.86  
    1.87  --
    1.88 --- TOC entry 1951 (class 0 OID 0)
    1.89 +-- TOC entry 1952 (class 0 OID 0)
    1.90  -- Dependencies: 1613
    1.91  -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.92  --
    1.93 @@ -209,7 +209,7 @@
    1.94  
    1.95  
    1.96  --
    1.97 --- TOC entry 1952 (class 0 OID 0)
    1.98 +-- TOC entry 1953 (class 0 OID 0)
    1.99  -- Dependencies: 1613
   1.100  -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.101  --
   1.102 @@ -236,21 +236,20 @@
   1.103  
   1.104  --
   1.105  -- TOC entry 1617 (class 1259 OID 35398)
   1.106 --- Dependencies: 1901 10
   1.107 +-- Dependencies: 1902 10
   1.108  -- Name: kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.109  --
   1.110  
   1.111  CREATE TABLE kategorie (
   1.112      id integer DEFAULT nextval('kategorie_seq'::regclass) NOT NULL,
   1.113 -    nazev character varying(32) NOT NULL,
   1.114 -    popis character varying(255)
   1.115 +    nazev character varying(32) NOT NULL
   1.116  );
   1.117  
   1.118  
   1.119  ALTER TABLE nekurak.kategorie OWNER TO nekurak;
   1.120  
   1.121  --
   1.122 --- TOC entry 1955 (class 0 OID 0)
   1.123 +-- TOC entry 1956 (class 0 OID 0)
   1.124  -- Dependencies: 1617
   1.125  -- Name: TABLE kategorie; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.126  --
   1.127 @@ -259,6 +258,16 @@
   1.128  
   1.129  
   1.130  --
   1.131 +-- TOC entry 1957 (class 0 OID 0)
   1.132 +-- Dependencies: 1617
   1.133 +-- Name: COLUMN kategorie.nazev; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.134 +--
   1.135 +
   1.136 +COMMENT ON COLUMN kategorie.nazev IS 'jen pro info při přímé práci s SQL
   1.137 +aplikace bere názvy a popisy kategorií z lokalizačního souboru (na základě ID kategorie)';
   1.138 +
   1.139 +
   1.140 +--
   1.141  -- TOC entry 1614 (class 1259 OID 35333)
   1.142  -- Dependencies: 10
   1.143  -- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
   1.144 @@ -275,7 +284,7 @@
   1.145  
   1.146  --
   1.147  -- TOC entry 1615 (class 1259 OID 35376)
   1.148 --- Dependencies: 1899 1900 10
   1.149 +-- Dependencies: 1900 1901 10
   1.150  -- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.151  --
   1.152  
   1.153 @@ -292,7 +301,7 @@
   1.154  ALTER TABLE nekurak.komentar OWNER TO nekurak;
   1.155  
   1.156  --
   1.157 --- TOC entry 1958 (class 0 OID 0)
   1.158 +-- TOC entry 1960 (class 0 OID 0)
   1.159  -- Dependencies: 1615
   1.160  -- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.161  --
   1.162 @@ -301,7 +310,7 @@
   1.163  
   1.164  
   1.165  --
   1.166 --- TOC entry 1959 (class 0 OID 0)
   1.167 +-- TOC entry 1961 (class 0 OID 0)
   1.168  -- Dependencies: 1615
   1.169  -- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.170  --
   1.171 @@ -310,7 +319,7 @@
   1.172  
   1.173  
   1.174  --
   1.175 --- TOC entry 1960 (class 0 OID 0)
   1.176 +-- TOC entry 1962 (class 0 OID 0)
   1.177  -- Dependencies: 1615
   1.178  -- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.179  --
   1.180 @@ -336,7 +345,7 @@
   1.181  
   1.182  --
   1.183  -- TOC entry 1602 (class 1259 OID 35049)
   1.184 --- Dependencies: 1890 1891 10
   1.185 +-- Dependencies: 1890 1891 1892 10
   1.186  -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.187  --
   1.188  
   1.189 @@ -351,14 +360,16 @@
   1.190      mesto character varying(64),
   1.191      spravce character varying(64),
   1.192      sirka double precision,
   1.193 -    delka double precision
   1.194 +    delka double precision,
   1.195 +    stav character(1),
   1.196 +    CONSTRAINT stav_tg CHECK (((stav = ANY (ARRAY['k'::bpchar, 'n'::bpchar, 'o'::bpchar, 'c'::bpchar])) OR (stav IS NULL)))
   1.197  );
   1.198  
   1.199  
   1.200  ALTER TABLE nekurak.podnik OWNER TO nekurak;
   1.201  
   1.202  --
   1.203 --- TOC entry 1963 (class 0 OID 0)
   1.204 +-- TOC entry 1965 (class 0 OID 0)
   1.205  -- Dependencies: 1602
   1.206  -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.207  --
   1.208 @@ -367,6 +378,19 @@
   1.209  
   1.210  
   1.211  --
   1.212 +-- TOC entry 1966 (class 0 OID 0)
   1.213 +-- Dependencies: 1602
   1.214 +-- Name: CONSTRAINT stav_tg ON podnik; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.215 +--
   1.216 +
   1.217 +COMMENT ON CONSTRAINT stav_tg ON podnik IS 'k = kuřácký
   1.218 +n = nekuřácký
   1.219 +o = oddělené části (důkladně)
   1.220 +c = částečně kuřácký (špatně oddělené, považujeme za kuřácký)
   1.221 +NULL = neznámý stav';
   1.222 +
   1.223 +
   1.224 +--
   1.225  -- TOC entry 1618 (class 1259 OID 35404)
   1.226  -- Dependencies: 10
   1.227  -- Name: podnik_kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.228 @@ -395,7 +419,7 @@
   1.229  ALTER TABLE nekurak.role OWNER TO nekurak;
   1.230  
   1.231  --
   1.232 --- TOC entry 1966 (class 0 OID 0)
   1.233 +-- TOC entry 1969 (class 0 OID 0)
   1.234  -- Dependencies: 1605
   1.235  -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.236  --
   1.237 @@ -420,7 +444,7 @@
   1.238  
   1.239  --
   1.240  -- TOC entry 1604 (class 1259 OID 35091)
   1.241 --- Dependencies: 1892 1893 10
   1.242 +-- Dependencies: 1893 1894 10
   1.243  -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.244  --
   1.245  
   1.246 @@ -438,7 +462,7 @@
   1.247  ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
   1.248  
   1.249  --
   1.250 --- TOC entry 1969 (class 0 OID 0)
   1.251 +-- TOC entry 1972 (class 0 OID 0)
   1.252  -- Dependencies: 1604
   1.253  -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.254  --
   1.255 @@ -461,7 +485,7 @@
   1.256  ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
   1.257  
   1.258  --
   1.259 --- TOC entry 1971 (class 0 OID 0)
   1.260 +-- TOC entry 1974 (class 0 OID 0)
   1.261  -- Dependencies: 1606
   1.262  -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.263  --
   1.264 @@ -470,7 +494,7 @@
   1.265  
   1.266  
   1.267  --
   1.268 --- TOC entry 1917 (class 2606 OID 35227)
   1.269 +-- TOC entry 1918 (class 2606 OID 35227)
   1.270  -- Dependencies: 1609 1609
   1.271  -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.272  --
   1.273 @@ -480,7 +504,7 @@
   1.274  
   1.275  
   1.276  --
   1.277 --- TOC entry 1913 (class 2606 OID 35190)
   1.278 +-- TOC entry 1914 (class 2606 OID 35190)
   1.279  -- Dependencies: 1608 1608
   1.280  -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.281  --
   1.282 @@ -490,7 +514,7 @@
   1.283  
   1.284  
   1.285  --
   1.286 --- TOC entry 1915 (class 2606 OID 35204)
   1.287 +-- TOC entry 1916 (class 2606 OID 35204)
   1.288  -- Dependencies: 1608 1608 1608
   1.289  -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.290  --
   1.291 @@ -500,7 +524,7 @@
   1.292  
   1.293  
   1.294  --
   1.295 --- TOC entry 1920 (class 2606 OID 35284)
   1.296 +-- TOC entry 1921 (class 2606 OID 35284)
   1.297  -- Dependencies: 1613 1613
   1.298  -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.299  --
   1.300 @@ -510,7 +534,7 @@
   1.301  
   1.302  
   1.303  --
   1.304 --- TOC entry 1925 (class 2606 OID 35403)
   1.305 +-- TOC entry 1926 (class 2606 OID 35403)
   1.306  -- Dependencies: 1617 1617
   1.307  -- Name: kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.308  --
   1.309 @@ -520,7 +544,7 @@
   1.310  
   1.311  
   1.312  --
   1.313 --- TOC entry 1923 (class 2606 OID 35385)
   1.314 +-- TOC entry 1924 (class 2606 OID 35385)
   1.315  -- Dependencies: 1615 1615
   1.316  -- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.317  --
   1.318 @@ -530,7 +554,7 @@
   1.319  
   1.320  
   1.321  --
   1.322 --- TOC entry 1927 (class 2606 OID 35408)
   1.323 +-- TOC entry 1928 (class 2606 OID 35408)
   1.324  -- Dependencies: 1618 1618 1618
   1.325  -- Name: podnik_kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.326  --
   1.327 @@ -540,7 +564,7 @@
   1.328  
   1.329  
   1.330  --
   1.331 --- TOC entry 1903 (class 2606 OID 35058)
   1.332 +-- TOC entry 1904 (class 2606 OID 35058)
   1.333  -- Dependencies: 1602 1602
   1.334  -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.335  --
   1.336 @@ -550,7 +574,7 @@
   1.337  
   1.338  
   1.339  --
   1.340 --- TOC entry 1909 (class 2606 OID 35105)
   1.341 +-- TOC entry 1910 (class 2606 OID 35105)
   1.342  -- Dependencies: 1605 1605
   1.343  -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.344  --
   1.345 @@ -560,7 +584,7 @@
   1.346  
   1.347  
   1.348  --
   1.349 --- TOC entry 1905 (class 2606 OID 35098)
   1.350 +-- TOC entry 1906 (class 2606 OID 35098)
   1.351  -- Dependencies: 1604 1604
   1.352  -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.353  --
   1.354 @@ -570,7 +594,7 @@
   1.355  
   1.356  
   1.357  --
   1.358 --- TOC entry 1907 (class 2606 OID 35100)
   1.359 +-- TOC entry 1908 (class 2606 OID 35100)
   1.360  -- Dependencies: 1604 1604
   1.361  -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.362  --
   1.363 @@ -580,7 +604,7 @@
   1.364  
   1.365  
   1.366  --
   1.367 --- TOC entry 1911 (class 2606 OID 35137)
   1.368 +-- TOC entry 1912 (class 2606 OID 35137)
   1.369  -- Dependencies: 1606 1606 1606
   1.370  -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.371  --
   1.372 @@ -590,7 +614,7 @@
   1.373  
   1.374  
   1.375  --
   1.376 --- TOC entry 1918 (class 1259 OID 35291)
   1.377 +-- TOC entry 1919 (class 1259 OID 35291)
   1.378  -- Dependencies: 1613
   1.379  -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.380  --
   1.381 @@ -599,7 +623,7 @@
   1.382  
   1.383  
   1.384  --
   1.385 --- TOC entry 1921 (class 1259 OID 35309)
   1.386 +-- TOC entry 1922 (class 1259 OID 35309)
   1.387  -- Dependencies: 1613
   1.388  -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.389  --
   1.390 @@ -608,7 +632,7 @@
   1.391  
   1.392  
   1.393  --
   1.394 --- TOC entry 1937 (class 2620 OID 35125)
   1.395 +-- TOC entry 1938 (class 2620 OID 35125)
   1.396  -- Dependencies: 1604 65
   1.397  -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
   1.398  --
   1.399 @@ -620,8 +644,8 @@
   1.400  
   1.401  
   1.402  --
   1.403 --- TOC entry 1931 (class 2606 OID 35191)
   1.404 --- Dependencies: 1608 1602 1902
   1.405 +-- TOC entry 1932 (class 2606 OID 35191)
   1.406 +-- Dependencies: 1903 1608 1602
   1.407  -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.408  --
   1.409  
   1.410 @@ -630,8 +654,8 @@
   1.411  
   1.412  
   1.413  --
   1.414 --- TOC entry 1932 (class 2606 OID 35285)
   1.415 --- Dependencies: 1602 1902 1613
   1.416 +-- TOC entry 1933 (class 2606 OID 35285)
   1.417 +-- Dependencies: 1903 1602 1613
   1.418  -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.419  --
   1.420  
   1.421 @@ -640,8 +664,8 @@
   1.422  
   1.423  
   1.424  --
   1.425 --- TOC entry 1933 (class 2606 OID 35386)
   1.426 --- Dependencies: 1615 1602 1902
   1.427 +-- TOC entry 1934 (class 2606 OID 35386)
   1.428 +-- Dependencies: 1615 1602 1903
   1.429  -- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.430  --
   1.431  
   1.432 @@ -650,8 +674,8 @@
   1.433  
   1.434  
   1.435  --
   1.436 --- TOC entry 1934 (class 2606 OID 35391)
   1.437 --- Dependencies: 1615 1906 1604
   1.438 +-- TOC entry 1935 (class 2606 OID 35391)
   1.439 +-- Dependencies: 1907 1604 1615
   1.440  -- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.441  --
   1.442  
   1.443 @@ -660,8 +684,8 @@
   1.444  
   1.445  
   1.446  --
   1.447 --- TOC entry 1936 (class 2606 OID 35414)
   1.448 --- Dependencies: 1924 1618 1617
   1.449 +-- TOC entry 1937 (class 2606 OID 35414)
   1.450 +-- Dependencies: 1618 1925 1617
   1.451  -- Name: podnik_kategorie_kategorie_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.452  --
   1.453  
   1.454 @@ -670,8 +694,8 @@
   1.455  
   1.456  
   1.457  --
   1.458 --- TOC entry 1935 (class 2606 OID 35409)
   1.459 --- Dependencies: 1618 1902 1602
   1.460 +-- TOC entry 1936 (class 2606 OID 35409)
   1.461 +-- Dependencies: 1903 1602 1618
   1.462  -- Name: podnik_kategorie_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.463  --
   1.464  
   1.465 @@ -680,8 +704,8 @@
   1.466  
   1.467  
   1.468  --
   1.469 --- TOC entry 1928 (class 2606 OID 35178)
   1.470 --- Dependencies: 1602 1604 1906
   1.471 +-- TOC entry 1929 (class 2606 OID 35178)
   1.472 +-- Dependencies: 1602 1604 1907
   1.473  -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.474  --
   1.475  
   1.476 @@ -690,8 +714,8 @@
   1.477  
   1.478  
   1.479  --
   1.480 --- TOC entry 1929 (class 2606 OID 35138)
   1.481 --- Dependencies: 1605 1908 1606
   1.482 +-- TOC entry 1930 (class 2606 OID 35138)
   1.483 +-- Dependencies: 1909 1606 1605
   1.484  -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.485  --
   1.486  
   1.487 @@ -700,8 +724,8 @@
   1.488  
   1.489  
   1.490  --
   1.491 --- TOC entry 1930 (class 2606 OID 35143)
   1.492 --- Dependencies: 1604 1606 1906
   1.493 +-- TOC entry 1931 (class 2606 OID 35143)
   1.494 +-- Dependencies: 1907 1604 1606
   1.495  -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.496  --
   1.497  
   1.498 @@ -710,7 +734,7 @@
   1.499  
   1.500  
   1.501  --
   1.502 --- TOC entry 1940 (class 0 OID 0)
   1.503 +-- TOC entry 1941 (class 0 OID 0)
   1.504  -- Dependencies: 10
   1.505  -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
   1.506  --
   1.507 @@ -722,7 +746,7 @@
   1.508  
   1.509  
   1.510  --
   1.511 --- TOC entry 1943 (class 0 OID 0)
   1.512 +-- TOC entry 1944 (class 0 OID 0)
   1.513  -- Dependencies: 1610
   1.514  -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.515  --
   1.516 @@ -734,7 +758,7 @@
   1.517  
   1.518  
   1.519  --
   1.520 --- TOC entry 1945 (class 0 OID 0)
   1.521 +-- TOC entry 1946 (class 0 OID 0)
   1.522  -- Dependencies: 1609
   1.523  -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
   1.524  --
   1.525 @@ -746,7 +770,7 @@
   1.526  
   1.527  
   1.528  --
   1.529 --- TOC entry 1946 (class 0 OID 0)
   1.530 +-- TOC entry 1947 (class 0 OID 0)
   1.531  -- Dependencies: 1607
   1.532  -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.533  --
   1.534 @@ -758,7 +782,7 @@
   1.535  
   1.536  
   1.537  --
   1.538 --- TOC entry 1949 (class 0 OID 0)
   1.539 +-- TOC entry 1950 (class 0 OID 0)
   1.540  -- Dependencies: 1608
   1.541  -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
   1.542  --
   1.543 @@ -770,7 +794,7 @@
   1.544  
   1.545  
   1.546  --
   1.547 --- TOC entry 1950 (class 0 OID 0)
   1.548 +-- TOC entry 1951 (class 0 OID 0)
   1.549  -- Dependencies: 1612
   1.550  -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.551  --
   1.552 @@ -782,7 +806,7 @@
   1.553  
   1.554  
   1.555  --
   1.556 --- TOC entry 1953 (class 0 OID 0)
   1.557 +-- TOC entry 1954 (class 0 OID 0)
   1.558  -- Dependencies: 1613
   1.559  -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
   1.560  --
   1.561 @@ -794,7 +818,7 @@
   1.562  
   1.563  
   1.564  --
   1.565 --- TOC entry 1954 (class 0 OID 0)
   1.566 +-- TOC entry 1955 (class 0 OID 0)
   1.567  -- Dependencies: 1616
   1.568  -- Name: kategorie_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.569  --
   1.570 @@ -806,7 +830,7 @@
   1.571  
   1.572  
   1.573  --
   1.574 --- TOC entry 1956 (class 0 OID 0)
   1.575 +-- TOC entry 1958 (class 0 OID 0)
   1.576  -- Dependencies: 1617
   1.577  -- Name: kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
   1.578  --
   1.579 @@ -818,7 +842,7 @@
   1.580  
   1.581  
   1.582  --
   1.583 --- TOC entry 1957 (class 0 OID 0)
   1.584 +-- TOC entry 1959 (class 0 OID 0)
   1.585  -- Dependencies: 1614
   1.586  -- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.587  --
   1.588 @@ -830,7 +854,7 @@
   1.589  
   1.590  
   1.591  --
   1.592 --- TOC entry 1961 (class 0 OID 0)
   1.593 +-- TOC entry 1963 (class 0 OID 0)
   1.594  -- Dependencies: 1615
   1.595  -- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
   1.596  --
   1.597 @@ -842,7 +866,7 @@
   1.598  
   1.599  
   1.600  --
   1.601 --- TOC entry 1962 (class 0 OID 0)
   1.602 +-- TOC entry 1964 (class 0 OID 0)
   1.603  -- Dependencies: 1601
   1.604  -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.605  --
   1.606 @@ -854,7 +878,7 @@
   1.607  
   1.608  
   1.609  --
   1.610 --- TOC entry 1964 (class 0 OID 0)
   1.611 +-- TOC entry 1967 (class 0 OID 0)
   1.612  -- Dependencies: 1602
   1.613  -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
   1.614  --
   1.615 @@ -866,7 +890,7 @@
   1.616  
   1.617  
   1.618  --
   1.619 --- TOC entry 1965 (class 0 OID 0)
   1.620 +-- TOC entry 1968 (class 0 OID 0)
   1.621  -- Dependencies: 1618
   1.622  -- Name: podnik_kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
   1.623  --
   1.624 @@ -878,7 +902,7 @@
   1.625  
   1.626  
   1.627  --
   1.628 --- TOC entry 1967 (class 0 OID 0)
   1.629 +-- TOC entry 1970 (class 0 OID 0)
   1.630  -- Dependencies: 1605
   1.631  -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
   1.632  --
   1.633 @@ -890,7 +914,7 @@
   1.634  
   1.635  
   1.636  --
   1.637 --- TOC entry 1968 (class 0 OID 0)
   1.638 +-- TOC entry 1971 (class 0 OID 0)
   1.639  -- Dependencies: 1603
   1.640  -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.641  --
   1.642 @@ -902,7 +926,7 @@
   1.643  
   1.644  
   1.645  --
   1.646 --- TOC entry 1970 (class 0 OID 0)
   1.647 +-- TOC entry 1973 (class 0 OID 0)
   1.648  -- Dependencies: 1604
   1.649  -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
   1.650  --
   1.651 @@ -914,7 +938,7 @@
   1.652  
   1.653  
   1.654  --
   1.655 --- TOC entry 1972 (class 0 OID 0)
   1.656 +-- TOC entry 1975 (class 0 OID 0)
   1.657  -- Dependencies: 1606
   1.658  -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
   1.659  --
   1.660 @@ -925,7 +949,7 @@
   1.661  GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
   1.662  
   1.663  
   1.664 --- Completed on 2011-01-08 19:54:50 CET
   1.665 +-- Completed on 2011-01-11 15:26:23 CET
   1.666  
   1.667  --
   1.668  -- PostgreSQL database dump complete