1.1 --- a/sql/schéma.sql Wed Apr 28 00:22:40 2010 +0200
1.2 +++ b/sql/schéma.sql Wed Apr 28 00:36:21 2010 +0200
1.3 @@ -2,7 +2,7 @@
1.4 -- PostgreSQL database dump
1.5 --
1.6
1.7 --- Started on 2010-03-16 14:32:22 CET
1.8 +-- Started on 2010-04-28 00:33:47 CEST
1.9
1.10 SET statement_timeout = 0;
1.11 SET client_encoding = 'UTF8';
1.12 @@ -24,8 +24,8 @@
1.13 SET search_path = nekurak, pg_catalog;
1.14
1.15 --
1.16 --- TOC entry 368 (class 1247 OID 35086)
1.17 --- Dependencies: 369 10
1.18 +-- TOC entry 366 (class 1247 OID 35086)
1.19 +-- Dependencies: 367 10
1.20 -- Name: email; Type: DOMAIN; Schema: nekurak; Owner: nekurak
1.21 --
1.22
1.23 @@ -36,8 +36,8 @@
1.24 ALTER DOMAIN nekurak.email OWNER TO nekurak;
1.25
1.26 --
1.27 --- TOC entry 1894 (class 0 OID 0)
1.28 --- Dependencies: 368
1.29 +-- TOC entry 1913 (class 0 OID 0)
1.30 +-- Dependencies: 366
1.31 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.32 --
1.33
1.34 @@ -46,7 +46,7 @@
1.35
1.36 --
1.37 -- TOC entry 65 (class 1255 OID 35124)
1.38 --- Dependencies: 10 395
1.39 +-- Dependencies: 402 10
1.40 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
1.41 --
1.42
1.43 @@ -64,7 +64,7 @@
1.44 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
1.45
1.46 --
1.47 --- TOC entry 1895 (class 0 OID 0)
1.48 +-- TOC entry 1914 (class 0 OID 0)
1.49 -- Dependencies: 65
1.50 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
1.51 --
1.52 @@ -73,7 +73,50 @@
1.53
1.54
1.55 --
1.56 --- TOC entry 1592 (class 1259 OID 35183)
1.57 +-- TOC entry 1601 (class 1259 OID 35223)
1.58 +-- Dependencies: 10
1.59 +-- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.60 +--
1.61 +
1.62 +CREATE SEQUENCE clanek_seq
1.63 + INCREMENT BY 1
1.64 + NO MAXVALUE
1.65 + NO MINVALUE
1.66 + CACHE 1;
1.67 +
1.68 +
1.69 +ALTER TABLE nekurak.clanek_seq OWNER TO nekurak;
1.70 +
1.71 +SET default_tablespace = '';
1.72 +
1.73 +SET default_with_oids = false;
1.74 +
1.75 +--
1.76 +-- TOC entry 1600 (class 1259 OID 35205)
1.77 +-- Dependencies: 1882 10
1.78 +-- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.79 +--
1.80 +
1.81 +CREATE TABLE clanek (
1.82 + id integer DEFAULT nextval('clanek_seq'::regclass) NOT NULL,
1.83 + nadpis character varying(255) NOT NULL,
1.84 + text text
1.85 +);
1.86 +
1.87 +
1.88 +ALTER TABLE nekurak.clanek OWNER TO nekurak;
1.89 +
1.90 +--
1.91 +-- TOC entry 1916 (class 0 OID 0)
1.92 +-- Dependencies: 1600
1.93 +-- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.94 +--
1.95 +
1.96 +COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah, (XúHTML.';
1.97 +
1.98 +
1.99 +--
1.100 +-- TOC entry 1598 (class 1259 OID 35183)
1.101 -- Dependencies: 10
1.102 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.103 --
1.104 @@ -88,13 +131,9 @@
1.105
1.106 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
1.107
1.108 -SET default_tablespace = '';
1.109 -
1.110 -SET default_with_oids = false;
1.111 -
1.112 --
1.113 --- TOC entry 1593 (class 1259 OID 35185)
1.114 --- Dependencies: 1869 1870 10
1.115 +-- TOC entry 1599 (class 1259 OID 35185)
1.116 +-- Dependencies: 1880 1881 10
1.117 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.118 --
1.119
1.120 @@ -109,8 +148,8 @@
1.121 ALTER TABLE nekurak.fotka OWNER TO nekurak;
1.122
1.123 --
1.124 --- TOC entry 1897 (class 0 OID 0)
1.125 --- Dependencies: 1593
1.126 +-- TOC entry 1919 (class 0 OID 0)
1.127 +-- Dependencies: 1599
1.128 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.129 --
1.130
1.131 @@ -118,35 +157,60 @@
1.132
1.133
1.134 --
1.135 --- TOC entry 1898 (class 0 OID 0)
1.136 --- Dependencies: 1593
1.137 +-- TOC entry 1920 (class 0 OID 0)
1.138 +-- Dependencies: 1599
1.139 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.140 --
1.141
1.142 COMMENT ON COLUMN fotka.poradi IS 'Pořadí fotky v rámci daného podniku.';
1.143
1.144
1.145 -SET default_with_oids = true;
1.146 +--
1.147 +-- TOC entry 1603 (class 1259 OID 35250)
1.148 +-- Dependencies: 10
1.149 +-- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.150 +--
1.151 +
1.152 +CREATE SEQUENCE hlasovani_seq
1.153 + INCREMENT BY 1
1.154 + NO MAXVALUE
1.155 + NO MINVALUE
1.156 + CACHE 1;
1.157 +
1.158 +
1.159 +ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
1.160
1.161 --
1.162 --- TOC entry 1587 (class 1259 OID 35068)
1.163 --- Dependencies: 1866 10
1.164 +-- TOC entry 1604 (class 1259 OID 35278)
1.165 +-- Dependencies: 1883 1884 10
1.166 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.167 --
1.168
1.169 CREATE TABLE hlasovani (
1.170 + id integer DEFAULT nextval('hlasovani_seq'::regclass) NOT NULL,
1.171 podnik integer NOT NULL,
1.172 hlas boolean NOT NULL,
1.173 datum date DEFAULT now() NOT NULL,
1.174 - ip_adresa character varying(255)
1.175 + ip_adresa character varying(255) NOT NULL
1.176 );
1.177
1.178
1.179 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
1.180
1.181 --
1.182 --- TOC entry 1900 (class 0 OID 0)
1.183 --- Dependencies: 1587
1.184 +-- TOC entry 1923 (class 0 OID 0)
1.185 +-- Dependencies: 1604
1.186 +-- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.187 +--
1.188 +
1.189 +COMMENT ON COLUMN hlasovani.id IS 'V této tabulce v princupu ID nepotřebujeme,
1.190 +protože nebudeme adresovat konkrétní záznamy (a i kdyby, můžeme použít OID).
1.191 +Ale číselné ID se nám bude hodit pro rychlejší nalezení posledního hlasu od dané IP adresy.';
1.192 +
1.193 +
1.194 +--
1.195 +-- TOC entry 1924 (class 0 OID 0)
1.196 +-- Dependencies: 1604
1.197 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.198 --
1.199
1.200 @@ -156,7 +220,7 @@
1.201
1.202
1.203 --
1.204 --- TOC entry 1585 (class 1259 OID 35019)
1.205 +-- TOC entry 1592 (class 1259 OID 35019)
1.206 -- Dependencies: 10
1.207 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.208 --
1.209 @@ -170,11 +234,9 @@
1.210
1.211 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
1.212
1.213 -SET default_with_oids = false;
1.214 -
1.215 --
1.216 --- TOC entry 1586 (class 1259 OID 35049)
1.217 --- Dependencies: 1864 1865 10
1.218 +-- TOC entry 1593 (class 1259 OID 35049)
1.219 +-- Dependencies: 1876 1877 10
1.220 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.221 --
1.222
1.223 @@ -187,15 +249,17 @@
1.224 ulice character varying(64),
1.225 cislo_popisne integer,
1.226 mesto character varying(64),
1.227 - spravce character varying(64)
1.228 + spravce character varying(64),
1.229 + sirka double precision,
1.230 + delka double precision
1.231 );
1.232
1.233
1.234 ALTER TABLE nekurak.podnik OWNER TO nekurak;
1.235
1.236 --
1.237 --- TOC entry 1903 (class 0 OID 0)
1.238 --- Dependencies: 1586
1.239 +-- TOC entry 1927 (class 0 OID 0)
1.240 +-- Dependencies: 1593
1.241 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.242 --
1.243
1.244 @@ -203,7 +267,7 @@
1.245
1.246
1.247 --
1.248 --- TOC entry 1590 (class 1259 OID 35101)
1.249 +-- TOC entry 1596 (class 1259 OID 35101)
1.250 -- Dependencies: 10
1.251 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.252 --
1.253 @@ -217,8 +281,8 @@
1.254 ALTER TABLE nekurak.role OWNER TO nekurak;
1.255
1.256 --
1.257 --- TOC entry 1905 (class 0 OID 0)
1.258 --- Dependencies: 1590
1.259 +-- TOC entry 1929 (class 0 OID 0)
1.260 +-- Dependencies: 1596
1.261 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.262 --
1.263
1.264 @@ -226,7 +290,7 @@
1.265
1.266
1.267 --
1.268 --- TOC entry 1588 (class 1259 OID 35080)
1.269 +-- TOC entry 1594 (class 1259 OID 35080)
1.270 -- Dependencies: 10
1.271 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
1.272 --
1.273 @@ -241,8 +305,8 @@
1.274 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
1.275
1.276 --
1.277 --- TOC entry 1589 (class 1259 OID 35091)
1.278 --- Dependencies: 1867 1868 10
1.279 +-- TOC entry 1595 (class 1259 OID 35091)
1.280 +-- Dependencies: 1878 1879 10
1.281 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.282 --
1.283
1.284 @@ -260,8 +324,8 @@
1.285 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
1.286
1.287 --
1.288 --- TOC entry 1908 (class 0 OID 0)
1.289 --- Dependencies: 1589
1.290 +-- TOC entry 1932 (class 0 OID 0)
1.291 +-- Dependencies: 1595
1.292 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.293 --
1.294
1.295 @@ -269,7 +333,7 @@
1.296
1.297
1.298 --
1.299 --- TOC entry 1591 (class 1259 OID 35106)
1.300 +-- TOC entry 1597 (class 1259 OID 35106)
1.301 -- Dependencies: 10
1.302 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
1.303 --
1.304 @@ -283,8 +347,8 @@
1.305 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
1.306
1.307 --
1.308 --- TOC entry 1910 (class 0 OID 0)
1.309 --- Dependencies: 1591
1.310 +-- TOC entry 1934 (class 0 OID 0)
1.311 +-- Dependencies: 1597
1.312 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
1.313 --
1.314
1.315 @@ -292,8 +356,18 @@
1.316
1.317
1.318 --
1.319 --- TOC entry 1882 (class 2606 OID 35190)
1.320 --- Dependencies: 1593 1593
1.321 +-- TOC entry 1900 (class 2606 OID 35227)
1.322 +-- Dependencies: 1600 1600
1.323 +-- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.324 +--
1.325 +
1.326 +ALTER TABLE ONLY clanek
1.327 + ADD CONSTRAINT clanek_pk PRIMARY KEY (id);
1.328 +
1.329 +
1.330 +--
1.331 +-- TOC entry 1896 (class 2606 OID 35190)
1.332 +-- Dependencies: 1599 1599
1.333 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.334 --
1.335
1.336 @@ -302,8 +376,8 @@
1.337
1.338
1.339 --
1.340 --- TOC entry 1884 (class 2606 OID 35204)
1.341 --- Dependencies: 1593 1593 1593
1.342 +-- TOC entry 1898 (class 2606 OID 35204)
1.343 +-- Dependencies: 1599 1599 1599
1.344 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.345 --
1.346
1.347 @@ -312,8 +386,18 @@
1.348
1.349
1.350 --
1.351 --- TOC entry 1872 (class 2606 OID 35058)
1.352 --- Dependencies: 1586 1586
1.353 +-- TOC entry 1903 (class 2606 OID 35284)
1.354 +-- Dependencies: 1604 1604
1.355 +-- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.356 +--
1.357 +
1.358 +ALTER TABLE ONLY hlasovani
1.359 + ADD CONSTRAINT hlasovani_pk PRIMARY KEY (id);
1.360 +
1.361 +
1.362 +--
1.363 +-- TOC entry 1886 (class 2606 OID 35058)
1.364 +-- Dependencies: 1593 1593
1.365 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.366 --
1.367
1.368 @@ -322,8 +406,8 @@
1.369
1.370
1.371 --
1.372 --- TOC entry 1878 (class 2606 OID 35105)
1.373 --- Dependencies: 1590 1590
1.374 +-- TOC entry 1892 (class 2606 OID 35105)
1.375 +-- Dependencies: 1596 1596
1.376 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.377 --
1.378
1.379 @@ -332,8 +416,8 @@
1.380
1.381
1.382 --
1.383 --- TOC entry 1874 (class 2606 OID 35098)
1.384 --- Dependencies: 1589 1589
1.385 +-- TOC entry 1888 (class 2606 OID 35098)
1.386 +-- Dependencies: 1595 1595
1.387 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.388 --
1.389
1.390 @@ -342,8 +426,8 @@
1.391
1.392
1.393 --
1.394 --- TOC entry 1876 (class 2606 OID 35100)
1.395 --- Dependencies: 1589 1589
1.396 +-- TOC entry 1890 (class 2606 OID 35100)
1.397 +-- Dependencies: 1595 1595
1.398 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.399 --
1.400
1.401 @@ -352,8 +436,8 @@
1.402
1.403
1.404 --
1.405 --- TOC entry 1880 (class 2606 OID 35137)
1.406 --- Dependencies: 1591 1591 1591
1.407 +-- TOC entry 1894 (class 2606 OID 35137)
1.408 +-- Dependencies: 1597 1597 1597
1.409 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
1.410 --
1.411
1.412 @@ -362,8 +446,17 @@
1.413
1.414
1.415 --
1.416 --- TOC entry 1890 (class 2620 OID 35125)
1.417 --- Dependencies: 1589 65
1.418 +-- TOC entry 1901 (class 1259 OID 35291)
1.419 +-- Dependencies: 1604
1.420 +-- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
1.421 +--
1.422 +
1.423 +CREATE INDEX hlasovani_ip_idx ON hlasovani USING btree (ip_adresa);
1.424 +
1.425 +
1.426 +--
1.427 +-- TOC entry 1909 (class 2620 OID 35125)
1.428 +-- Dependencies: 65 1595
1.429 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
1.430 --
1.431
1.432 @@ -374,8 +467,8 @@
1.433
1.434
1.435 --
1.436 --- TOC entry 1889 (class 2606 OID 35191)
1.437 --- Dependencies: 1871 1586 1593
1.438 +-- TOC entry 1907 (class 2606 OID 35191)
1.439 +-- Dependencies: 1599 1593 1885
1.440 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.441 --
1.442
1.443 @@ -384,8 +477,8 @@
1.444
1.445
1.446 --
1.447 --- TOC entry 1886 (class 2606 OID 35072)
1.448 --- Dependencies: 1587 1871 1586
1.449 +-- TOC entry 1908 (class 2606 OID 35285)
1.450 +-- Dependencies: 1885 1604 1593
1.451 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.452 --
1.453
1.454 @@ -394,8 +487,8 @@
1.455
1.456
1.457 --
1.458 --- TOC entry 1885 (class 2606 OID 35178)
1.459 --- Dependencies: 1875 1589 1586
1.460 +-- TOC entry 1904 (class 2606 OID 35178)
1.461 +-- Dependencies: 1593 1889 1595
1.462 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.463 --
1.464
1.465 @@ -404,8 +497,8 @@
1.466
1.467
1.468 --
1.469 --- TOC entry 1887 (class 2606 OID 35138)
1.470 --- Dependencies: 1590 1591 1877
1.471 +-- TOC entry 1905 (class 2606 OID 35138)
1.472 +-- Dependencies: 1597 1891 1596
1.473 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.474 --
1.475
1.476 @@ -414,8 +507,8 @@
1.477
1.478
1.479 --
1.480 --- TOC entry 1888 (class 2606 OID 35143)
1.481 --- Dependencies: 1591 1589 1875
1.482 +-- TOC entry 1906 (class 2606 OID 35143)
1.483 +-- Dependencies: 1889 1595 1597
1.484 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
1.485 --
1.486
1.487 @@ -424,7 +517,7 @@
1.488
1.489
1.490 --
1.491 --- TOC entry 1893 (class 0 OID 0)
1.492 +-- TOC entry 1912 (class 0 OID 0)
1.493 -- Dependencies: 10
1.494 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
1.495 --
1.496 @@ -436,8 +529,32 @@
1.497
1.498
1.499 --
1.500 --- TOC entry 1896 (class 0 OID 0)
1.501 --- Dependencies: 1592
1.502 +-- TOC entry 1915 (class 0 OID 0)
1.503 +-- Dependencies: 1601
1.504 +-- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.505 +--
1.506 +
1.507 +REVOKE ALL ON SEQUENCE clanek_seq FROM PUBLIC;
1.508 +REVOKE ALL ON SEQUENCE clanek_seq FROM nekurak;
1.509 +GRANT ALL ON SEQUENCE clanek_seq TO nekurak;
1.510 +GRANT USAGE ON SEQUENCE clanek_seq TO nekurak_web;
1.511 +
1.512 +
1.513 +--
1.514 +-- TOC entry 1917 (class 0 OID 0)
1.515 +-- Dependencies: 1600
1.516 +-- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
1.517 +--
1.518 +
1.519 +REVOKE ALL ON TABLE clanek FROM PUBLIC;
1.520 +REVOKE ALL ON TABLE clanek FROM nekurak;
1.521 +GRANT ALL ON TABLE clanek TO nekurak;
1.522 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE clanek TO nekurak_web;
1.523 +
1.524 +
1.525 +--
1.526 +-- TOC entry 1918 (class 0 OID 0)
1.527 +-- Dependencies: 1598
1.528 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.529 --
1.530
1.531 @@ -448,8 +565,8 @@
1.532
1.533
1.534 --
1.535 --- TOC entry 1899 (class 0 OID 0)
1.536 --- Dependencies: 1593
1.537 +-- TOC entry 1921 (class 0 OID 0)
1.538 +-- Dependencies: 1599
1.539 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
1.540 --
1.541
1.542 @@ -460,8 +577,20 @@
1.543
1.544
1.545 --
1.546 --- TOC entry 1901 (class 0 OID 0)
1.547 --- Dependencies: 1587
1.548 +-- TOC entry 1922 (class 0 OID 0)
1.549 +-- Dependencies: 1603
1.550 +-- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.551 +--
1.552 +
1.553 +REVOKE ALL ON SEQUENCE hlasovani_seq FROM PUBLIC;
1.554 +REVOKE ALL ON SEQUENCE hlasovani_seq FROM nekurak;
1.555 +GRANT ALL ON SEQUENCE hlasovani_seq TO nekurak;
1.556 +GRANT USAGE ON SEQUENCE hlasovani_seq TO nekurak_web;
1.557 +
1.558 +
1.559 +--
1.560 +-- TOC entry 1925 (class 0 OID 0)
1.561 +-- Dependencies: 1604
1.562 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
1.563 --
1.564
1.565 @@ -472,8 +601,8 @@
1.566
1.567
1.568 --
1.569 --- TOC entry 1902 (class 0 OID 0)
1.570 --- Dependencies: 1585
1.571 +-- TOC entry 1926 (class 0 OID 0)
1.572 +-- Dependencies: 1592
1.573 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.574 --
1.575
1.576 @@ -484,8 +613,8 @@
1.577
1.578
1.579 --
1.580 --- TOC entry 1904 (class 0 OID 0)
1.581 --- Dependencies: 1586
1.582 +-- TOC entry 1928 (class 0 OID 0)
1.583 +-- Dependencies: 1593
1.584 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
1.585 --
1.586
1.587 @@ -496,8 +625,8 @@
1.588
1.589
1.590 --
1.591 --- TOC entry 1906 (class 0 OID 0)
1.592 --- Dependencies: 1590
1.593 +-- TOC entry 1930 (class 0 OID 0)
1.594 +-- Dependencies: 1596
1.595 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
1.596 --
1.597
1.598 @@ -508,8 +637,8 @@
1.599
1.600
1.601 --
1.602 --- TOC entry 1907 (class 0 OID 0)
1.603 --- Dependencies: 1588
1.604 +-- TOC entry 1931 (class 0 OID 0)
1.605 +-- Dependencies: 1594
1.606 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
1.607 --
1.608
1.609 @@ -520,8 +649,8 @@
1.610
1.611
1.612 --
1.613 --- TOC entry 1909 (class 0 OID 0)
1.614 --- Dependencies: 1589
1.615 +-- TOC entry 1933 (class 0 OID 0)
1.616 +-- Dependencies: 1595
1.617 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
1.618 --
1.619
1.620 @@ -532,8 +661,8 @@
1.621
1.622
1.623 --
1.624 --- TOC entry 1911 (class 0 OID 0)
1.625 --- Dependencies: 1591
1.626 +-- TOC entry 1935 (class 0 OID 0)
1.627 +-- Dependencies: 1597
1.628 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
1.629 --
1.630
1.631 @@ -543,7 +672,7 @@
1.632 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
1.633
1.634
1.635 --- Completed on 2010-03-16 14:32:24 CET
1.636 +-- Completed on 2010-04-28 00:33:49 CEST
1.637
1.638 --
1.639 -- PostgreSQL database dump complete