1.1 --- a/sql/schéma.sql Wed Jun 09 15:51:41 2010 +0200
1.2 +++ b/sql/schéma.sql Wed Jun 09 15:53:52 2010 +0200
1.3 @@ -2,7 +2,7 @@
1.4 -- PostgreSQL database dump
1.5 --
1.6
1.7 --- Started on 2010-04-29 14:41:40 CEST
1.8 +-- Started on 2010-06-09 15:52:26 CEST
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 1914 (class 0 OID 0)
1.17 +-- TOC entry 1926 (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 402
1.26 +-- Dependencies: 10 406
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 1915 (class 0 OID 0)
1.35 +-- TOC entry 1927 (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 1601 (class 1259 OID 35223)
1.44 +-- TOC entry 1605 (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 1600 (class 1259 OID 35205)
1.53 --- Dependencies: 1882 10
1.54 +-- TOC entry 1604 (class 1259 OID 35205)
1.55 +-- Dependencies: 1888 10
1.56 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.57 --
1.58
1.59 @@ -107,8 +107,8 @@
1.60 ALTER TABLE nekurak.clanek OWNER TO nekurak;
1.61
1.62 --
1.63 --- TOC entry 1917 (class 0 OID 0)
1.64 --- Dependencies: 1600
1.65 +-- TOC entry 1929 (class 0 OID 0)
1.66 +-- Dependencies: 1604
1.67 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.68 --
1.69
1.70 @@ -116,7 +116,7 @@
1.71
1.72
1.73 --
1.74 --- TOC entry 1598 (class 1259 OID 35183)
1.75 +-- TOC entry 1602 (class 1259 OID 35183)
1.76 -- Dependencies: 10
1.77 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.78 --
1.79 @@ -132,8 +132,8 @@
1.80 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
1.81
1.82 --
1.83 --- TOC entry 1599 (class 1259 OID 35185)
1.84 --- Dependencies: 1880 1881 10
1.85 +-- TOC entry 1603 (class 1259 OID 35185)
1.86 +-- Dependencies: 1886 1887 10
1.87 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.88 --
1.89
1.90 @@ -148,8 +148,8 @@
1.91 ALTER TABLE nekurak.fotka OWNER TO nekurak;
1.92
1.93 --
1.94 --- TOC entry 1920 (class 0 OID 0)
1.95 --- Dependencies: 1599
1.96 +-- TOC entry 1932 (class 0 OID 0)
1.97 +-- Dependencies: 1603
1.98 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.99 --
1.100
1.101 @@ -157,8 +157,8 @@
1.102
1.103
1.104 --
1.105 --- TOC entry 1921 (class 0 OID 0)
1.106 --- Dependencies: 1599
1.107 +-- TOC entry 1933 (class 0 OID 0)
1.108 +-- Dependencies: 1603
1.109 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.110 --
1.111
1.112 @@ -166,7 +166,7 @@
1.113
1.114
1.115 --
1.116 --- TOC entry 1603 (class 1259 OID 35250)
1.117 +-- TOC entry 1607 (class 1259 OID 35250)
1.118 -- Dependencies: 10
1.119 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.120 --
1.121 @@ -181,8 +181,8 @@
1.122 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
1.123
1.124 --
1.125 --- TOC entry 1604 (class 1259 OID 35278)
1.126 --- Dependencies: 1883 1884 10
1.127 +-- TOC entry 1608 (class 1259 OID 35278)
1.128 +-- Dependencies: 1889 1890 10
1.129 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.130 --
1.131
1.132 @@ -198,8 +198,8 @@
1.133 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
1.134
1.135 --
1.136 --- TOC entry 1924 (class 0 OID 0)
1.137 --- Dependencies: 1604
1.138 +-- TOC entry 1936 (class 0 OID 0)
1.139 +-- Dependencies: 1608
1.140 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.141 --
1.142
1.143 @@ -209,8 +209,8 @@
1.144
1.145
1.146 --
1.147 --- TOC entry 1925 (class 0 OID 0)
1.148 --- Dependencies: 1604
1.149 +-- TOC entry 1937 (class 0 OID 0)
1.150 +-- Dependencies: 1608
1.151 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.152 --
1.153
1.154 @@ -220,7 +220,68 @@
1.155
1.156
1.157 --
1.158 --- TOC entry 1592 (class 1259 OID 35019)
1.159 +-- TOC entry 1609 (class 1259 OID 35333)
1.160 +-- Dependencies: 10
1.161 +-- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.162 +--
1.163 +
1.164 +CREATE SEQUENCE komentar_seq
1.165 + INCREMENT BY 1
1.166 + NO MAXVALUE
1.167 + NO MINVALUE
1.168 + CACHE 1;
1.169 +
1.170 +
1.171 +ALTER TABLE nekurak.komentar_seq OWNER TO nekurak;
1.172 +
1.173 +--
1.174 +-- TOC entry 1610 (class 1259 OID 35376)
1.175 +-- Dependencies: 1891 1892 10
1.176 +-- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.177 +--
1.178 +
1.179 +CREATE TABLE komentar (
1.180 + id integer DEFAULT nextval('komentar_seq'::regclass) NOT NULL,
1.181 + podnik integer NOT NULL,
1.182 + uzivatel character varying(64) NOT NULL,
1.183 + datum timestamp with time zone DEFAULT now() NOT NULL,
1.184 + nadpis character varying(255),
1.185 + komentar text NOT NULL
1.186 +);
1.187 +
1.188 +
1.189 +ALTER TABLE nekurak.komentar OWNER TO nekurak;
1.190 +
1.191 +--
1.192 +-- TOC entry 1940 (class 0 OID 0)
1.193 +-- Dependencies: 1610
1.194 +-- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.195 +--
1.196 +
1.197 +COMMENT ON TABLE komentar IS 'Komentář k podniku';
1.198 +
1.199 +
1.200 +--
1.201 +-- TOC entry 1941 (class 0 OID 0)
1.202 +-- Dependencies: 1610
1.203 +-- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.204 +--
1.205 +
1.206 +COMMENT ON COLUMN komentar.nadpis IS 'vždy jen prostý text';
1.207 +
1.208 +
1.209 +--
1.210 +-- TOC entry 1942 (class 0 OID 0)
1.211 +-- Dependencies: 1610
1.212 +-- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.213 +--
1.214 +
1.215 +COMMENT ON COLUMN komentar.komentar IS 'Vlastní komentář. Vždy jen XHTML – převádíme na něj jak prostý text, tak Texy nebo cokoli jiného.
1.216 +Jedná se o kus validního XML – má kořenový element <div/>';
1.217 +
1.218 +
1.219 +--
1.220 +-- TOC entry 1596 (class 1259 OID 35019)
1.221 -- Dependencies: 10
1.222 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.223 --
1.224 @@ -235,8 +296,8 @@
1.225 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
1.226
1.227 --
1.228 --- TOC entry 1593 (class 1259 OID 35049)
1.229 --- Dependencies: 1876 1877 10
1.230 +-- TOC entry 1597 (class 1259 OID 35049)
1.231 +-- Dependencies: 1882 1883 10
1.232 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.233 --
1.234
1.235 @@ -258,8 +319,8 @@
1.236 ALTER TABLE nekurak.podnik OWNER TO nekurak;
1.237
1.238 --
1.239 --- TOC entry 1928 (class 0 OID 0)
1.240 --- Dependencies: 1593
1.241 +-- TOC entry 1945 (class 0 OID 0)
1.242 +-- Dependencies: 1597
1.243 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.244 --
1.245
1.246 @@ -267,7 +328,7 @@
1.247
1.248
1.249 --
1.250 --- TOC entry 1596 (class 1259 OID 35101)
1.251 +-- TOC entry 1600 (class 1259 OID 35101)
1.252 -- Dependencies: 10
1.253 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.254 --
1.255 @@ -281,8 +342,8 @@
1.256 ALTER TABLE nekurak.role OWNER TO nekurak;
1.257
1.258 --
1.259 --- TOC entry 1930 (class 0 OID 0)
1.260 --- Dependencies: 1596
1.261 +-- TOC entry 1947 (class 0 OID 0)
1.262 +-- Dependencies: 1600
1.263 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.264 --
1.265
1.266 @@ -290,7 +351,7 @@
1.267
1.268
1.269 --
1.270 --- TOC entry 1594 (class 1259 OID 35080)
1.271 +-- TOC entry 1598 (class 1259 OID 35080)
1.272 -- Dependencies: 10
1.273 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.274 --
1.275 @@ -305,8 +366,8 @@
1.276 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
1.277
1.278 --
1.279 --- TOC entry 1595 (class 1259 OID 35091)
1.280 --- Dependencies: 1878 1879 10
1.281 +-- TOC entry 1599 (class 1259 OID 35091)
1.282 +-- Dependencies: 1884 1885 10
1.283 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.284 --
1.285
1.286 @@ -324,8 +385,8 @@
1.287 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
1.288
1.289 --
1.290 --- TOC entry 1933 (class 0 OID 0)
1.291 --- Dependencies: 1595
1.292 +-- TOC entry 1950 (class 0 OID 0)
1.293 +-- Dependencies: 1599
1.294 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.295 --
1.296
1.297 @@ -333,7 +394,7 @@
1.298
1.299
1.300 --
1.301 --- TOC entry 1597 (class 1259 OID 35106)
1.302 +-- TOC entry 1601 (class 1259 OID 35106)
1.303 -- Dependencies: 10
1.304 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.305 --
1.306 @@ -347,8 +408,8 @@
1.307 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
1.308
1.309 --
1.310 --- TOC entry 1935 (class 0 OID 0)
1.311 --- Dependencies: 1597
1.312 +-- TOC entry 1952 (class 0 OID 0)
1.313 +-- Dependencies: 1601
1.314 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.315 --
1.316
1.317 @@ -356,8 +417,8 @@
1.318
1.319
1.320 --
1.321 --- TOC entry 1900 (class 2606 OID 35227)
1.322 --- Dependencies: 1600 1600
1.323 +-- TOC entry 1908 (class 2606 OID 35227)
1.324 +-- Dependencies: 1604 1604
1.325 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.326 --
1.327
1.328 @@ -366,8 +427,8 @@
1.329
1.330
1.331 --
1.332 --- TOC entry 1896 (class 2606 OID 35190)
1.333 --- Dependencies: 1599 1599
1.334 +-- TOC entry 1904 (class 2606 OID 35190)
1.335 +-- Dependencies: 1603 1603
1.336 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.337 --
1.338
1.339 @@ -376,8 +437,8 @@
1.340
1.341
1.342 --
1.343 --- TOC entry 1898 (class 2606 OID 35204)
1.344 --- Dependencies: 1599 1599 1599
1.345 +-- TOC entry 1906 (class 2606 OID 35204)
1.346 +-- Dependencies: 1603 1603 1603
1.347 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.348 --
1.349
1.350 @@ -386,8 +447,8 @@
1.351
1.352
1.353 --
1.354 --- TOC entry 1903 (class 2606 OID 35284)
1.355 --- Dependencies: 1604 1604
1.356 +-- TOC entry 1911 (class 2606 OID 35284)
1.357 +-- Dependencies: 1608 1608
1.358 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.359 --
1.360
1.361 @@ -396,8 +457,18 @@
1.362
1.363
1.364 --
1.365 --- TOC entry 1886 (class 2606 OID 35058)
1.366 --- Dependencies: 1593 1593
1.367 +-- TOC entry 1914 (class 2606 OID 35385)
1.368 +-- Dependencies: 1610 1610
1.369 +-- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.370 +--
1.371 +
1.372 +ALTER TABLE ONLY komentar
1.373 + ADD CONSTRAINT komentar_pk PRIMARY KEY (id);
1.374 +
1.375 +
1.376 +--
1.377 +-- TOC entry 1894 (class 2606 OID 35058)
1.378 +-- Dependencies: 1597 1597
1.379 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.380 --
1.381
1.382 @@ -406,8 +477,8 @@
1.383
1.384
1.385 --
1.386 --- TOC entry 1892 (class 2606 OID 35105)
1.387 --- Dependencies: 1596 1596
1.388 +-- TOC entry 1900 (class 2606 OID 35105)
1.389 +-- Dependencies: 1600 1600
1.390 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.391 --
1.392
1.393 @@ -416,8 +487,8 @@
1.394
1.395
1.396 --
1.397 --- TOC entry 1888 (class 2606 OID 35098)
1.398 --- Dependencies: 1595 1595
1.399 +-- TOC entry 1896 (class 2606 OID 35098)
1.400 +-- Dependencies: 1599 1599
1.401 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.402 --
1.403
1.404 @@ -426,8 +497,8 @@
1.405
1.406
1.407 --
1.408 --- TOC entry 1890 (class 2606 OID 35100)
1.409 --- Dependencies: 1595 1595
1.410 +-- TOC entry 1898 (class 2606 OID 35100)
1.411 +-- Dependencies: 1599 1599
1.412 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.413 --
1.414
1.415 @@ -436,8 +507,8 @@
1.416
1.417
1.418 --
1.419 --- TOC entry 1894 (class 2606 OID 35137)
1.420 --- Dependencies: 1597 1597 1597
1.421 +-- TOC entry 1902 (class 2606 OID 35137)
1.422 +-- Dependencies: 1601 1601 1601
1.423 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.424 --
1.425
1.426 @@ -446,8 +517,8 @@
1.427
1.428
1.429 --
1.430 --- TOC entry 1901 (class 1259 OID 35291)
1.431 --- Dependencies: 1604
1.432 +-- TOC entry 1909 (class 1259 OID 35291)
1.433 +-- Dependencies: 1608
1.434 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
1.435 --
1.436
1.437 @@ -455,8 +526,8 @@
1.438
1.439
1.440 --
1.441 --- TOC entry 1904 (class 1259 OID 35309)
1.442 --- Dependencies: 1604
1.443 +-- TOC entry 1912 (class 1259 OID 35309)
1.444 +-- Dependencies: 1608
1.445 -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
1.446 --
1.447
1.448 @@ -464,8 +535,8 @@
1.449
1.450
1.451 --
1.452 --- TOC entry 1910 (class 2620 OID 35125)
1.453 --- Dependencies: 1595 65
1.454 +-- TOC entry 1922 (class 2620 OID 35125)
1.455 +-- Dependencies: 1599 65
1.456 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
1.457 --
1.458
1.459 @@ -476,8 +547,8 @@
1.460
1.461
1.462 --
1.463 --- TOC entry 1908 (class 2606 OID 35191)
1.464 --- Dependencies: 1599 1885 1593
1.465 +-- TOC entry 1918 (class 2606 OID 35191)
1.466 +-- Dependencies: 1893 1597 1603
1.467 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.468 --
1.469
1.470 @@ -486,8 +557,8 @@
1.471
1.472
1.473 --
1.474 --- TOC entry 1909 (class 2606 OID 35285)
1.475 --- Dependencies: 1885 1604 1593
1.476 +-- TOC entry 1919 (class 2606 OID 35285)
1.477 +-- Dependencies: 1597 1608 1893
1.478 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.479 --
1.480
1.481 @@ -496,8 +567,28 @@
1.482
1.483
1.484 --
1.485 --- TOC entry 1905 (class 2606 OID 35178)
1.486 --- Dependencies: 1889 1595 1593
1.487 +-- TOC entry 1920 (class 2606 OID 35386)
1.488 +-- Dependencies: 1610 1893 1597
1.489 +-- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.490 +--
1.491 +
1.492 +ALTER TABLE ONLY komentar
1.493 + ADD CONSTRAINT komentar_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id);
1.494 +
1.495 +
1.496 +--
1.497 +-- TOC entry 1921 (class 2606 OID 35391)
1.498 +-- Dependencies: 1599 1897 1610
1.499 +-- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.500 +--
1.501 +
1.502 +ALTER TABLE ONLY komentar
1.503 + ADD CONSTRAINT komentar_uzivatel_fk FOREIGN KEY (uzivatel) REFERENCES uzivatel(prezdivka);
1.504 +
1.505 +
1.506 +--
1.507 +-- TOC entry 1915 (class 2606 OID 35178)
1.508 +-- Dependencies: 1599 1897 1597
1.509 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.510 --
1.511
1.512 @@ -506,8 +597,8 @@
1.513
1.514
1.515 --
1.516 --- TOC entry 1906 (class 2606 OID 35138)
1.517 --- Dependencies: 1597 1596 1891
1.518 +-- TOC entry 1916 (class 2606 OID 35138)
1.519 +-- Dependencies: 1600 1601 1899
1.520 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.521 --
1.522
1.523 @@ -516,8 +607,8 @@
1.524
1.525
1.526 --
1.527 --- TOC entry 1907 (class 2606 OID 35143)
1.528 --- Dependencies: 1597 1889 1595
1.529 +-- TOC entry 1917 (class 2606 OID 35143)
1.530 +-- Dependencies: 1599 1897 1601
1.531 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.532 --
1.533
1.534 @@ -526,7 +617,7 @@
1.535
1.536
1.537 --
1.538 --- TOC entry 1913 (class 0 OID 0)
1.539 +-- TOC entry 1925 (class 0 OID 0)
1.540 -- Dependencies: 10
1.541 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
1.542 --
1.543 @@ -538,8 +629,8 @@
1.544
1.545
1.546 --
1.547 --- TOC entry 1916 (class 0 OID 0)
1.548 --- Dependencies: 1601
1.549 +-- TOC entry 1928 (class 0 OID 0)
1.550 +-- Dependencies: 1605
1.551 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.552 --
1.553
1.554 @@ -550,8 +641,8 @@
1.555
1.556
1.557 --
1.558 --- TOC entry 1918 (class 0 OID 0)
1.559 --- Dependencies: 1600
1.560 +-- TOC entry 1930 (class 0 OID 0)
1.561 +-- Dependencies: 1604
1.562 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
1.563 --
1.564
1.565 @@ -562,8 +653,8 @@
1.566
1.567
1.568 --
1.569 --- TOC entry 1919 (class 0 OID 0)
1.570 --- Dependencies: 1598
1.571 +-- TOC entry 1931 (class 0 OID 0)
1.572 +-- Dependencies: 1602
1.573 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.574 --
1.575
1.576 @@ -574,8 +665,8 @@
1.577
1.578
1.579 --
1.580 --- TOC entry 1922 (class 0 OID 0)
1.581 --- Dependencies: 1599
1.582 +-- TOC entry 1934 (class 0 OID 0)
1.583 +-- Dependencies: 1603
1.584 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
1.585 --
1.586
1.587 @@ -586,8 +677,8 @@
1.588
1.589
1.590 --
1.591 --- TOC entry 1923 (class 0 OID 0)
1.592 --- Dependencies: 1603
1.593 +-- TOC entry 1935 (class 0 OID 0)
1.594 +-- Dependencies: 1607
1.595 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.596 --
1.597
1.598 @@ -598,20 +689,44 @@
1.599
1.600
1.601 --
1.602 --- TOC entry 1926 (class 0 OID 0)
1.603 --- Dependencies: 1604
1.604 +-- TOC entry 1938 (class 0 OID 0)
1.605 +-- Dependencies: 1608
1.606 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
1.607 --
1.608
1.609 REVOKE ALL ON TABLE hlasovani FROM PUBLIC;
1.610 REVOKE ALL ON TABLE hlasovani FROM nekurak;
1.611 GRANT ALL ON TABLE hlasovani TO nekurak;
1.612 -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE hlasovani TO nekurak_web;
1.613 +GRANT SELECT,INSERT ON TABLE hlasovani TO nekurak_web;
1.614
1.615
1.616 --
1.617 --- TOC entry 1927 (class 0 OID 0)
1.618 --- Dependencies: 1592
1.619 +-- TOC entry 1939 (class 0 OID 0)
1.620 +-- Dependencies: 1609
1.621 +-- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.622 +--
1.623 +
1.624 +REVOKE ALL ON SEQUENCE komentar_seq FROM PUBLIC;
1.625 +REVOKE ALL ON SEQUENCE komentar_seq FROM nekurak;
1.626 +GRANT ALL ON SEQUENCE komentar_seq TO nekurak;
1.627 +GRANT USAGE ON SEQUENCE komentar_seq TO nekurak_web;
1.628 +
1.629 +
1.630 +--
1.631 +-- TOC entry 1943 (class 0 OID 0)
1.632 +-- Dependencies: 1610
1.633 +-- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
1.634 +--
1.635 +
1.636 +REVOKE ALL ON TABLE komentar FROM PUBLIC;
1.637 +REVOKE ALL ON TABLE komentar FROM nekurak;
1.638 +GRANT ALL ON TABLE komentar TO nekurak;
1.639 +GRANT SELECT,INSERT ON TABLE komentar TO nekurak_web;
1.640 +
1.641 +
1.642 +--
1.643 +-- TOC entry 1944 (class 0 OID 0)
1.644 +-- Dependencies: 1596
1.645 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.646 --
1.647
1.648 @@ -622,8 +737,8 @@
1.649
1.650
1.651 --
1.652 --- TOC entry 1929 (class 0 OID 0)
1.653 --- Dependencies: 1593
1.654 +-- TOC entry 1946 (class 0 OID 0)
1.655 +-- Dependencies: 1597
1.656 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
1.657 --
1.658
1.659 @@ -634,8 +749,8 @@
1.660
1.661
1.662 --
1.663 --- TOC entry 1931 (class 0 OID 0)
1.664 --- Dependencies: 1596
1.665 +-- TOC entry 1948 (class 0 OID 0)
1.666 +-- Dependencies: 1600
1.667 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
1.668 --
1.669
1.670 @@ -646,8 +761,8 @@
1.671
1.672
1.673 --
1.674 --- TOC entry 1932 (class 0 OID 0)
1.675 --- Dependencies: 1594
1.676 +-- TOC entry 1949 (class 0 OID 0)
1.677 +-- Dependencies: 1598
1.678 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.679 --
1.680
1.681 @@ -658,8 +773,8 @@
1.682
1.683
1.684 --
1.685 --- TOC entry 1934 (class 0 OID 0)
1.686 --- Dependencies: 1595
1.687 +-- TOC entry 1951 (class 0 OID 0)
1.688 +-- Dependencies: 1599
1.689 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
1.690 --
1.691
1.692 @@ -670,8 +785,8 @@
1.693
1.694
1.695 --
1.696 --- TOC entry 1936 (class 0 OID 0)
1.697 --- Dependencies: 1597
1.698 +-- TOC entry 1953 (class 0 OID 0)
1.699 +-- Dependencies: 1601
1.700 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
1.701 --
1.702
1.703 @@ -681,7 +796,7 @@
1.704 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
1.705
1.706
1.707 --- Completed on 2010-04-29 14:41:42 CEST
1.708 +-- Completed on 2010-06-09 15:52:28 CEST
1.709
1.710 --
1.711 -- PostgreSQL database dump complete