1.1 --- a/sql/schéma.sql Wed Jun 09 15:53:52 2010 +0200
1.2 +++ b/sql/schéma.sql Sat Jan 08 20:18:27 2011 +0100
1.3 @@ -2,7 +2,7 @@
1.4 -- PostgreSQL database dump
1.5 --
1.6
1.7 --- Started on 2010-06-09 15:52:26 CEST
1.8 +-- Started on 2011-01-08 19:54:48 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 1926 (class 0 OID 0)
1.17 +-- TOC entry 1941 (class 0 OID 0)
1.18 -- Dependencies: 366
1.19 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.20 --
1.21 @@ -46,7 +46,7 @@
1.22
1.23 --
1.24 -- TOC entry 65 (class 1255 OID 35124)
1.25 --- Dependencies: 10 406
1.26 +-- Dependencies: 411 10
1.27 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
1.28 --
1.29
1.30 @@ -64,7 +64,7 @@
1.31 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
1.32
1.33 --
1.34 --- TOC entry 1927 (class 0 OID 0)
1.35 +-- TOC entry 1942 (class 0 OID 0)
1.36 -- Dependencies: 65
1.37 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
1.38 --
1.39 @@ -73,7 +73,7 @@
1.40
1.41
1.42 --
1.43 --- TOC entry 1605 (class 1259 OID 35223)
1.44 +-- TOC entry 1610 (class 1259 OID 35223)
1.45 -- Dependencies: 10
1.46 -- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.47 --
1.48 @@ -92,8 +92,8 @@
1.49 SET default_with_oids = false;
1.50
1.51 --
1.52 --- TOC entry 1604 (class 1259 OID 35205)
1.53 --- Dependencies: 1888 10
1.54 +-- TOC entry 1609 (class 1259 OID 35205)
1.55 +-- Dependencies: 1896 10
1.56 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.57 --
1.58
1.59 @@ -107,16 +107,16 @@
1.60 ALTER TABLE nekurak.clanek OWNER TO nekurak;
1.61
1.62 --
1.63 --- TOC entry 1929 (class 0 OID 0)
1.64 --- Dependencies: 1604
1.65 +-- TOC entry 1944 (class 0 OID 0)
1.66 +-- Dependencies: 1609
1.67 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.68 --
1.69
1.70 -COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah, (XúHTML.';
1.71 +COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah (XHTML).';
1.72
1.73
1.74 --
1.75 --- TOC entry 1602 (class 1259 OID 35183)
1.76 +-- TOC entry 1607 (class 1259 OID 35183)
1.77 -- Dependencies: 10
1.78 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.79 --
1.80 @@ -132,8 +132,8 @@
1.81 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
1.82
1.83 --
1.84 --- TOC entry 1603 (class 1259 OID 35185)
1.85 --- Dependencies: 1886 1887 10
1.86 +-- TOC entry 1608 (class 1259 OID 35185)
1.87 +-- Dependencies: 1894 1895 10
1.88 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.89 --
1.90
1.91 @@ -148,8 +148,8 @@
1.92 ALTER TABLE nekurak.fotka OWNER TO nekurak;
1.93
1.94 --
1.95 --- TOC entry 1932 (class 0 OID 0)
1.96 --- Dependencies: 1603
1.97 +-- TOC entry 1947 (class 0 OID 0)
1.98 +-- Dependencies: 1608
1.99 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.100 --
1.101
1.102 @@ -157,8 +157,8 @@
1.103
1.104
1.105 --
1.106 --- TOC entry 1933 (class 0 OID 0)
1.107 --- Dependencies: 1603
1.108 +-- TOC entry 1948 (class 0 OID 0)
1.109 +-- Dependencies: 1608
1.110 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.111 --
1.112
1.113 @@ -166,7 +166,7 @@
1.114
1.115
1.116 --
1.117 --- TOC entry 1607 (class 1259 OID 35250)
1.118 +-- TOC entry 1612 (class 1259 OID 35250)
1.119 -- Dependencies: 10
1.120 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.121 --
1.122 @@ -181,8 +181,8 @@
1.123 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
1.124
1.125 --
1.126 --- TOC entry 1608 (class 1259 OID 35278)
1.127 --- Dependencies: 1889 1890 10
1.128 +-- TOC entry 1613 (class 1259 OID 35278)
1.129 +-- Dependencies: 1897 1898 10
1.130 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.131 --
1.132
1.133 @@ -198,8 +198,8 @@
1.134 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
1.135
1.136 --
1.137 --- TOC entry 1936 (class 0 OID 0)
1.138 --- Dependencies: 1608
1.139 +-- TOC entry 1951 (class 0 OID 0)
1.140 +-- Dependencies: 1613
1.141 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.142 --
1.143
1.144 @@ -209,8 +209,8 @@
1.145
1.146
1.147 --
1.148 --- TOC entry 1937 (class 0 OID 0)
1.149 --- Dependencies: 1608
1.150 +-- TOC entry 1952 (class 0 OID 0)
1.151 +-- Dependencies: 1613
1.152 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.153 --
1.154
1.155 @@ -220,7 +220,46 @@
1.156
1.157
1.158 --
1.159 --- TOC entry 1609 (class 1259 OID 35333)
1.160 +-- TOC entry 1616 (class 1259 OID 35396)
1.161 +-- Dependencies: 10
1.162 +-- Name: kategorie_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.163 +--
1.164 +
1.165 +CREATE SEQUENCE kategorie_seq
1.166 + INCREMENT BY 1
1.167 + NO MAXVALUE
1.168 + NO MINVALUE
1.169 + CACHE 1;
1.170 +
1.171 +
1.172 +ALTER TABLE nekurak.kategorie_seq OWNER TO nekurak;
1.173 +
1.174 +--
1.175 +-- TOC entry 1617 (class 1259 OID 35398)
1.176 +-- Dependencies: 1901 10
1.177 +-- Name: kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.178 +--
1.179 +
1.180 +CREATE TABLE kategorie (
1.181 + id integer DEFAULT nextval('kategorie_seq'::regclass) NOT NULL,
1.182 + nazev character varying(32) NOT NULL,
1.183 + popis character varying(255)
1.184 +);
1.185 +
1.186 +
1.187 +ALTER TABLE nekurak.kategorie OWNER TO nekurak;
1.188 +
1.189 +--
1.190 +-- TOC entry 1955 (class 0 OID 0)
1.191 +-- Dependencies: 1617
1.192 +-- Name: TABLE kategorie; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.193 +--
1.194 +
1.195 +COMMENT ON TABLE kategorie IS 'Kategorie podniku';
1.196 +
1.197 +
1.198 +--
1.199 +-- TOC entry 1614 (class 1259 OID 35333)
1.200 -- Dependencies: 10
1.201 -- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.202 --
1.203 @@ -235,8 +274,8 @@
1.204 ALTER TABLE nekurak.komentar_seq OWNER TO nekurak;
1.205
1.206 --
1.207 --- TOC entry 1610 (class 1259 OID 35376)
1.208 --- Dependencies: 1891 1892 10
1.209 +-- TOC entry 1615 (class 1259 OID 35376)
1.210 +-- Dependencies: 1899 1900 10
1.211 -- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.212 --
1.213
1.214 @@ -253,8 +292,8 @@
1.215 ALTER TABLE nekurak.komentar OWNER TO nekurak;
1.216
1.217 --
1.218 --- TOC entry 1940 (class 0 OID 0)
1.219 --- Dependencies: 1610
1.220 +-- TOC entry 1958 (class 0 OID 0)
1.221 +-- Dependencies: 1615
1.222 -- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.223 --
1.224
1.225 @@ -262,8 +301,8 @@
1.226
1.227
1.228 --
1.229 --- TOC entry 1941 (class 0 OID 0)
1.230 --- Dependencies: 1610
1.231 +-- TOC entry 1959 (class 0 OID 0)
1.232 +-- Dependencies: 1615
1.233 -- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.234 --
1.235
1.236 @@ -271,8 +310,8 @@
1.237
1.238
1.239 --
1.240 --- TOC entry 1942 (class 0 OID 0)
1.241 --- Dependencies: 1610
1.242 +-- TOC entry 1960 (class 0 OID 0)
1.243 +-- Dependencies: 1615
1.244 -- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.245 --
1.246
1.247 @@ -281,7 +320,7 @@
1.248
1.249
1.250 --
1.251 --- TOC entry 1596 (class 1259 OID 35019)
1.252 +-- TOC entry 1601 (class 1259 OID 35019)
1.253 -- Dependencies: 10
1.254 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.255 --
1.256 @@ -296,8 +335,8 @@
1.257 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
1.258
1.259 --
1.260 --- TOC entry 1597 (class 1259 OID 35049)
1.261 --- Dependencies: 1882 1883 10
1.262 +-- TOC entry 1602 (class 1259 OID 35049)
1.263 +-- Dependencies: 1890 1891 10
1.264 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.265 --
1.266
1.267 @@ -319,8 +358,8 @@
1.268 ALTER TABLE nekurak.podnik OWNER TO nekurak;
1.269
1.270 --
1.271 --- TOC entry 1945 (class 0 OID 0)
1.272 --- Dependencies: 1597
1.273 +-- TOC entry 1963 (class 0 OID 0)
1.274 +-- Dependencies: 1602
1.275 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.276 --
1.277
1.278 @@ -328,7 +367,21 @@
1.279
1.280
1.281 --
1.282 --- TOC entry 1600 (class 1259 OID 35101)
1.283 +-- TOC entry 1618 (class 1259 OID 35404)
1.284 +-- Dependencies: 10
1.285 +-- Name: podnik_kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.286 +--
1.287 +
1.288 +CREATE TABLE podnik_kategorie (
1.289 + podnik integer NOT NULL,
1.290 + kategorie integer NOT NULL
1.291 +);
1.292 +
1.293 +
1.294 +ALTER TABLE nekurak.podnik_kategorie OWNER TO nekurak;
1.295 +
1.296 +--
1.297 +-- TOC entry 1605 (class 1259 OID 35101)
1.298 -- Dependencies: 10
1.299 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.300 --
1.301 @@ -342,8 +395,8 @@
1.302 ALTER TABLE nekurak.role OWNER TO nekurak;
1.303
1.304 --
1.305 --- TOC entry 1947 (class 0 OID 0)
1.306 --- Dependencies: 1600
1.307 +-- TOC entry 1966 (class 0 OID 0)
1.308 +-- Dependencies: 1605
1.309 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.310 --
1.311
1.312 @@ -351,7 +404,7 @@
1.313
1.314
1.315 --
1.316 --- TOC entry 1598 (class 1259 OID 35080)
1.317 +-- TOC entry 1603 (class 1259 OID 35080)
1.318 -- Dependencies: 10
1.319 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.320 --
1.321 @@ -366,8 +419,8 @@
1.322 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
1.323
1.324 --
1.325 --- TOC entry 1599 (class 1259 OID 35091)
1.326 --- Dependencies: 1884 1885 10
1.327 +-- TOC entry 1604 (class 1259 OID 35091)
1.328 +-- Dependencies: 1892 1893 10
1.329 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.330 --
1.331
1.332 @@ -385,8 +438,8 @@
1.333 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
1.334
1.335 --
1.336 --- TOC entry 1950 (class 0 OID 0)
1.337 --- Dependencies: 1599
1.338 +-- TOC entry 1969 (class 0 OID 0)
1.339 +-- Dependencies: 1604
1.340 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.341 --
1.342
1.343 @@ -394,7 +447,7 @@
1.344
1.345
1.346 --
1.347 --- TOC entry 1601 (class 1259 OID 35106)
1.348 +-- TOC entry 1606 (class 1259 OID 35106)
1.349 -- Dependencies: 10
1.350 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.351 --
1.352 @@ -408,8 +461,8 @@
1.353 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
1.354
1.355 --
1.356 --- TOC entry 1952 (class 0 OID 0)
1.357 --- Dependencies: 1601
1.358 +-- TOC entry 1971 (class 0 OID 0)
1.359 +-- Dependencies: 1606
1.360 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.361 --
1.362
1.363 @@ -417,8 +470,8 @@
1.364
1.365
1.366 --
1.367 --- TOC entry 1908 (class 2606 OID 35227)
1.368 --- Dependencies: 1604 1604
1.369 +-- TOC entry 1917 (class 2606 OID 35227)
1.370 +-- Dependencies: 1609 1609
1.371 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.372 --
1.373
1.374 @@ -427,8 +480,8 @@
1.375
1.376
1.377 --
1.378 --- TOC entry 1904 (class 2606 OID 35190)
1.379 --- Dependencies: 1603 1603
1.380 +-- TOC entry 1913 (class 2606 OID 35190)
1.381 +-- Dependencies: 1608 1608
1.382 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.383 --
1.384
1.385 @@ -437,8 +490,8 @@
1.386
1.387
1.388 --
1.389 --- TOC entry 1906 (class 2606 OID 35204)
1.390 --- Dependencies: 1603 1603 1603
1.391 +-- TOC entry 1915 (class 2606 OID 35204)
1.392 +-- Dependencies: 1608 1608 1608
1.393 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.394 --
1.395
1.396 @@ -447,8 +500,8 @@
1.397
1.398
1.399 --
1.400 --- TOC entry 1911 (class 2606 OID 35284)
1.401 --- Dependencies: 1608 1608
1.402 +-- TOC entry 1920 (class 2606 OID 35284)
1.403 +-- Dependencies: 1613 1613
1.404 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.405 --
1.406
1.407 @@ -457,8 +510,18 @@
1.408
1.409
1.410 --
1.411 --- TOC entry 1914 (class 2606 OID 35385)
1.412 --- Dependencies: 1610 1610
1.413 +-- TOC entry 1925 (class 2606 OID 35403)
1.414 +-- Dependencies: 1617 1617
1.415 +-- Name: kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.416 +--
1.417 +
1.418 +ALTER TABLE ONLY kategorie
1.419 + ADD CONSTRAINT kategorie_pk PRIMARY KEY (id);
1.420 +
1.421 +
1.422 +--
1.423 +-- TOC entry 1923 (class 2606 OID 35385)
1.424 +-- Dependencies: 1615 1615
1.425 -- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.426 --
1.427
1.428 @@ -467,8 +530,18 @@
1.429
1.430
1.431 --
1.432 --- TOC entry 1894 (class 2606 OID 35058)
1.433 --- Dependencies: 1597 1597
1.434 +-- TOC entry 1927 (class 2606 OID 35408)
1.435 +-- Dependencies: 1618 1618 1618
1.436 +-- Name: podnik_kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.437 +--
1.438 +
1.439 +ALTER TABLE ONLY podnik_kategorie
1.440 + ADD CONSTRAINT podnik_kategorie_pk PRIMARY KEY (podnik, kategorie);
1.441 +
1.442 +
1.443 +--
1.444 +-- TOC entry 1903 (class 2606 OID 35058)
1.445 +-- Dependencies: 1602 1602
1.446 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.447 --
1.448
1.449 @@ -477,8 +550,8 @@
1.450
1.451
1.452 --
1.453 --- TOC entry 1900 (class 2606 OID 35105)
1.454 --- Dependencies: 1600 1600
1.455 +-- TOC entry 1909 (class 2606 OID 35105)
1.456 +-- Dependencies: 1605 1605
1.457 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.458 --
1.459
1.460 @@ -487,8 +560,8 @@
1.461
1.462
1.463 --
1.464 --- TOC entry 1896 (class 2606 OID 35098)
1.465 --- Dependencies: 1599 1599
1.466 +-- TOC entry 1905 (class 2606 OID 35098)
1.467 +-- Dependencies: 1604 1604
1.468 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.469 --
1.470
1.471 @@ -497,8 +570,8 @@
1.472
1.473
1.474 --
1.475 --- TOC entry 1898 (class 2606 OID 35100)
1.476 --- Dependencies: 1599 1599
1.477 +-- TOC entry 1907 (class 2606 OID 35100)
1.478 +-- Dependencies: 1604 1604
1.479 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.480 --
1.481
1.482 @@ -507,8 +580,8 @@
1.483
1.484
1.485 --
1.486 --- TOC entry 1902 (class 2606 OID 35137)
1.487 --- Dependencies: 1601 1601 1601
1.488 +-- TOC entry 1911 (class 2606 OID 35137)
1.489 +-- Dependencies: 1606 1606 1606
1.490 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.491 --
1.492
1.493 @@ -517,8 +590,8 @@
1.494
1.495
1.496 --
1.497 --- TOC entry 1909 (class 1259 OID 35291)
1.498 --- Dependencies: 1608
1.499 +-- TOC entry 1918 (class 1259 OID 35291)
1.500 +-- Dependencies: 1613
1.501 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
1.502 --
1.503
1.504 @@ -526,8 +599,8 @@
1.505
1.506
1.507 --
1.508 --- TOC entry 1912 (class 1259 OID 35309)
1.509 --- Dependencies: 1608
1.510 +-- TOC entry 1921 (class 1259 OID 35309)
1.511 +-- Dependencies: 1613
1.512 -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
1.513 --
1.514
1.515 @@ -535,8 +608,8 @@
1.516
1.517
1.518 --
1.519 --- TOC entry 1922 (class 2620 OID 35125)
1.520 --- Dependencies: 1599 65
1.521 +-- TOC entry 1937 (class 2620 OID 35125)
1.522 +-- Dependencies: 1604 65
1.523 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
1.524 --
1.525
1.526 @@ -547,8 +620,8 @@
1.527
1.528
1.529 --
1.530 --- TOC entry 1918 (class 2606 OID 35191)
1.531 --- Dependencies: 1893 1597 1603
1.532 +-- TOC entry 1931 (class 2606 OID 35191)
1.533 +-- Dependencies: 1608 1602 1902
1.534 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.535 --
1.536
1.537 @@ -557,8 +630,8 @@
1.538
1.539
1.540 --
1.541 --- TOC entry 1919 (class 2606 OID 35285)
1.542 --- Dependencies: 1597 1608 1893
1.543 +-- TOC entry 1932 (class 2606 OID 35285)
1.544 +-- Dependencies: 1602 1902 1613
1.545 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.546 --
1.547
1.548 @@ -567,8 +640,8 @@
1.549
1.550
1.551 --
1.552 --- TOC entry 1920 (class 2606 OID 35386)
1.553 --- Dependencies: 1610 1893 1597
1.554 +-- TOC entry 1933 (class 2606 OID 35386)
1.555 +-- Dependencies: 1615 1602 1902
1.556 -- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.557 --
1.558
1.559 @@ -577,8 +650,8 @@
1.560
1.561
1.562 --
1.563 --- TOC entry 1921 (class 2606 OID 35391)
1.564 --- Dependencies: 1599 1897 1610
1.565 +-- TOC entry 1934 (class 2606 OID 35391)
1.566 +-- Dependencies: 1615 1906 1604
1.567 -- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.568 --
1.569
1.570 @@ -587,8 +660,28 @@
1.571
1.572
1.573 --
1.574 --- TOC entry 1915 (class 2606 OID 35178)
1.575 --- Dependencies: 1599 1897 1597
1.576 +-- TOC entry 1936 (class 2606 OID 35414)
1.577 +-- Dependencies: 1924 1618 1617
1.578 +-- Name: podnik_kategorie_kategorie_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.579 +--
1.580 +
1.581 +ALTER TABLE ONLY podnik_kategorie
1.582 + ADD CONSTRAINT podnik_kategorie_kategorie_fk FOREIGN KEY (kategorie) REFERENCES kategorie(id) ON DELETE CASCADE;
1.583 +
1.584 +
1.585 +--
1.586 +-- TOC entry 1935 (class 2606 OID 35409)
1.587 +-- Dependencies: 1618 1902 1602
1.588 +-- Name: podnik_kategorie_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.589 +--
1.590 +
1.591 +ALTER TABLE ONLY podnik_kategorie
1.592 + ADD CONSTRAINT podnik_kategorie_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id) ON DELETE CASCADE;
1.593 +
1.594 +
1.595 +--
1.596 +-- TOC entry 1928 (class 2606 OID 35178)
1.597 +-- Dependencies: 1602 1604 1906
1.598 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.599 --
1.600
1.601 @@ -597,8 +690,8 @@
1.602
1.603
1.604 --
1.605 --- TOC entry 1916 (class 2606 OID 35138)
1.606 --- Dependencies: 1600 1601 1899
1.607 +-- TOC entry 1929 (class 2606 OID 35138)
1.608 +-- Dependencies: 1605 1908 1606
1.609 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.610 --
1.611
1.612 @@ -607,8 +700,8 @@
1.613
1.614
1.615 --
1.616 --- TOC entry 1917 (class 2606 OID 35143)
1.617 --- Dependencies: 1599 1897 1601
1.618 +-- TOC entry 1930 (class 2606 OID 35143)
1.619 +-- Dependencies: 1604 1606 1906
1.620 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.621 --
1.622
1.623 @@ -617,7 +710,7 @@
1.624
1.625
1.626 --
1.627 --- TOC entry 1925 (class 0 OID 0)
1.628 +-- TOC entry 1940 (class 0 OID 0)
1.629 -- Dependencies: 10
1.630 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
1.631 --
1.632 @@ -629,8 +722,8 @@
1.633
1.634
1.635 --
1.636 --- TOC entry 1928 (class 0 OID 0)
1.637 --- Dependencies: 1605
1.638 +-- TOC entry 1943 (class 0 OID 0)
1.639 +-- Dependencies: 1610
1.640 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.641 --
1.642
1.643 @@ -641,8 +734,8 @@
1.644
1.645
1.646 --
1.647 --- TOC entry 1930 (class 0 OID 0)
1.648 --- Dependencies: 1604
1.649 +-- TOC entry 1945 (class 0 OID 0)
1.650 +-- Dependencies: 1609
1.651 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
1.652 --
1.653
1.654 @@ -653,8 +746,8 @@
1.655
1.656
1.657 --
1.658 --- TOC entry 1931 (class 0 OID 0)
1.659 --- Dependencies: 1602
1.660 +-- TOC entry 1946 (class 0 OID 0)
1.661 +-- Dependencies: 1607
1.662 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.663 --
1.664
1.665 @@ -665,8 +758,8 @@
1.666
1.667
1.668 --
1.669 --- TOC entry 1934 (class 0 OID 0)
1.670 --- Dependencies: 1603
1.671 +-- TOC entry 1949 (class 0 OID 0)
1.672 +-- Dependencies: 1608
1.673 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
1.674 --
1.675
1.676 @@ -677,8 +770,8 @@
1.677
1.678
1.679 --
1.680 --- TOC entry 1935 (class 0 OID 0)
1.681 --- Dependencies: 1607
1.682 +-- TOC entry 1950 (class 0 OID 0)
1.683 +-- Dependencies: 1612
1.684 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.685 --
1.686
1.687 @@ -689,8 +782,8 @@
1.688
1.689
1.690 --
1.691 --- TOC entry 1938 (class 0 OID 0)
1.692 --- Dependencies: 1608
1.693 +-- TOC entry 1953 (class 0 OID 0)
1.694 +-- Dependencies: 1613
1.695 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
1.696 --
1.697
1.698 @@ -701,8 +794,32 @@
1.699
1.700
1.701 --
1.702 --- TOC entry 1939 (class 0 OID 0)
1.703 --- Dependencies: 1609
1.704 +-- TOC entry 1954 (class 0 OID 0)
1.705 +-- Dependencies: 1616
1.706 +-- Name: kategorie_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.707 +--
1.708 +
1.709 +REVOKE ALL ON SEQUENCE kategorie_seq FROM PUBLIC;
1.710 +REVOKE ALL ON SEQUENCE kategorie_seq FROM nekurak;
1.711 +GRANT ALL ON SEQUENCE kategorie_seq TO nekurak;
1.712 +GRANT USAGE ON SEQUENCE kategorie_seq TO nekurak_web;
1.713 +
1.714 +
1.715 +--
1.716 +-- TOC entry 1956 (class 0 OID 0)
1.717 +-- Dependencies: 1617
1.718 +-- Name: kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
1.719 +--
1.720 +
1.721 +REVOKE ALL ON TABLE kategorie FROM PUBLIC;
1.722 +REVOKE ALL ON TABLE kategorie FROM nekurak;
1.723 +GRANT ALL ON TABLE kategorie TO nekurak;
1.724 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE kategorie TO nekurak_web;
1.725 +
1.726 +
1.727 +--
1.728 +-- TOC entry 1957 (class 0 OID 0)
1.729 +-- Dependencies: 1614
1.730 -- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.731 --
1.732
1.733 @@ -713,8 +830,8 @@
1.734
1.735
1.736 --
1.737 --- TOC entry 1943 (class 0 OID 0)
1.738 --- Dependencies: 1610
1.739 +-- TOC entry 1961 (class 0 OID 0)
1.740 +-- Dependencies: 1615
1.741 -- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
1.742 --
1.743
1.744 @@ -725,8 +842,8 @@
1.745
1.746
1.747 --
1.748 --- TOC entry 1944 (class 0 OID 0)
1.749 --- Dependencies: 1596
1.750 +-- TOC entry 1962 (class 0 OID 0)
1.751 +-- Dependencies: 1601
1.752 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.753 --
1.754
1.755 @@ -737,8 +854,8 @@
1.756
1.757
1.758 --
1.759 --- TOC entry 1946 (class 0 OID 0)
1.760 --- Dependencies: 1597
1.761 +-- TOC entry 1964 (class 0 OID 0)
1.762 +-- Dependencies: 1602
1.763 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
1.764 --
1.765
1.766 @@ -749,8 +866,20 @@
1.767
1.768
1.769 --
1.770 --- TOC entry 1948 (class 0 OID 0)
1.771 --- Dependencies: 1600
1.772 +-- TOC entry 1965 (class 0 OID 0)
1.773 +-- Dependencies: 1618
1.774 +-- Name: podnik_kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
1.775 +--
1.776 +
1.777 +REVOKE ALL ON TABLE podnik_kategorie FROM PUBLIC;
1.778 +REVOKE ALL ON TABLE podnik_kategorie FROM nekurak;
1.779 +GRANT ALL ON TABLE podnik_kategorie TO nekurak;
1.780 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik_kategorie TO nekurak_web;
1.781 +
1.782 +
1.783 +--
1.784 +-- TOC entry 1967 (class 0 OID 0)
1.785 +-- Dependencies: 1605
1.786 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
1.787 --
1.788
1.789 @@ -761,8 +890,8 @@
1.790
1.791
1.792 --
1.793 --- TOC entry 1949 (class 0 OID 0)
1.794 --- Dependencies: 1598
1.795 +-- TOC entry 1968 (class 0 OID 0)
1.796 +-- Dependencies: 1603
1.797 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.798 --
1.799
1.800 @@ -773,8 +902,8 @@
1.801
1.802
1.803 --
1.804 --- TOC entry 1951 (class 0 OID 0)
1.805 --- Dependencies: 1599
1.806 +-- TOC entry 1970 (class 0 OID 0)
1.807 +-- Dependencies: 1604
1.808 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
1.809 --
1.810
1.811 @@ -785,8 +914,8 @@
1.812
1.813
1.814 --
1.815 --- TOC entry 1953 (class 0 OID 0)
1.816 --- Dependencies: 1601
1.817 +-- TOC entry 1972 (class 0 OID 0)
1.818 +-- Dependencies: 1606
1.819 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
1.820 --
1.821
1.822 @@ -796,7 +925,7 @@
1.823 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
1.824
1.825
1.826 --- Completed on 2010-06-09 15:52:28 CEST
1.827 +-- Completed on 2011-01-08 19:54:50 CET
1.828
1.829 --
1.830 -- PostgreSQL database dump complete