1.1 --- a/sql/schéma.sql Sat Jan 08 20:18:27 2011 +0100
1.2 +++ b/sql/schéma.sql Fri Jan 14 18:49:43 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