sql/schéma.sql
author František Kučera <franta-hg@frantovo.cz>
Wed, 28 Apr 2010 01:52:23 +0200
changeset 117 607fbe95edda
parent 115 b278b6b2d552
child 118 1c52b1a4a18a
permissions -rw-r--r--
hack: přidána místní IPv6 adresa produkčního serveru.
     1 --
     2 -- PostgreSQL database dump
     3 --
     4 
     5 -- Started on 2010-04-28 00:33:47 CEST
     6 
     7 SET statement_timeout = 0;
     8 SET client_encoding = 'UTF8';
     9 SET standard_conforming_strings = off;
    10 SET check_function_bodies = false;
    11 SET client_min_messages = warning;
    12 SET escape_string_warning = off;
    13 
    14 --
    15 -- TOC entry 10 (class 2615 OID 35015)
    16 -- Name: nekurak; Type: SCHEMA; Schema: -; Owner: nekurak
    17 --
    18 
    19 CREATE SCHEMA nekurak;
    20 
    21 
    22 ALTER SCHEMA nekurak OWNER TO nekurak;
    23 
    24 SET search_path = nekurak, pg_catalog;
    25 
    26 --
    27 -- TOC entry 366 (class 1247 OID 35086)
    28 -- Dependencies: 367 10
    29 -- Name: email; Type: DOMAIN; Schema: nekurak; Owner: nekurak
    30 --
    31 
    32 CREATE DOMAIN email AS character varying(255)
    33 	CONSTRAINT email_regexp CHECK (((VALUE)::text ~ '^[_a-zA-Z0-9\\.\\-]+@[_a-zA-Z0-9\\.\\-]+\\.[a-zA-Z]{2,4}$'::text));
    34 
    35 
    36 ALTER DOMAIN nekurak.email OWNER TO nekurak;
    37 
    38 --
    39 -- TOC entry 1913 (class 0 OID 0)
    40 -- Dependencies: 366
    41 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
    42 --
    43 
    44 COMMENT ON DOMAIN email IS 'e-mailová adresa';
    45 
    46 
    47 --
    48 -- TOC entry 65 (class 1255 OID 35124)
    49 -- Dependencies: 402 10
    50 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
    51 --
    52 
    53 CREATE FUNCTION bezny_uzivatel() RETURNS trigger
    54     LANGUAGE plpgsql
    55     AS $$BEGIN
    56 INSERT INTO uzivatel_role 
    57 (role, prezdivka) 
    58 VALUES
    59 ('bezny', new.prezdivka);
    60 RETURN new;
    61 END;$$;
    62 
    63 
    64 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
    65 
    66 --
    67 -- TOC entry 1914 (class 0 OID 0)
    68 -- Dependencies: 65
    69 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
    70 --
    71 
    72 COMMENT ON FUNCTION bezny_uzivatel() IS 'Každému novému uživateli dáme automaticky roli „bezny“.';
    73 
    74 
    75 --
    76 -- TOC entry 1601 (class 1259 OID 35223)
    77 -- Dependencies: 10
    78 -- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
    79 --
    80 
    81 CREATE SEQUENCE clanek_seq
    82     INCREMENT BY 1
    83     NO MAXVALUE
    84     NO MINVALUE
    85     CACHE 1;
    86 
    87 
    88 ALTER TABLE nekurak.clanek_seq OWNER TO nekurak;
    89 
    90 SET default_tablespace = '';
    91 
    92 SET default_with_oids = false;
    93 
    94 --
    95 -- TOC entry 1600 (class 1259 OID 35205)
    96 -- Dependencies: 1882 10
    97 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
    98 --
    99 
   100 CREATE TABLE clanek (
   101     id integer DEFAULT nextval('clanek_seq'::regclass) NOT NULL,
   102     nadpis character varying(255) NOT NULL,
   103     text text
   104 );
   105 
   106 
   107 ALTER TABLE nekurak.clanek OWNER TO nekurak;
   108 
   109 --
   110 -- TOC entry 1916 (class 0 OID 0)
   111 -- Dependencies: 1600
   112 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
   113 --
   114 
   115 COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah, (XúHTML.';
   116 
   117 
   118 --
   119 -- TOC entry 1598 (class 1259 OID 35183)
   120 -- Dependencies: 10
   121 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
   122 --
   123 
   124 CREATE SEQUENCE fotka_seq
   125     START WITH 1
   126     INCREMENT BY 1
   127     NO MAXVALUE
   128     NO MINVALUE
   129     CACHE 1;
   130 
   131 
   132 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
   133 
   134 --
   135 -- TOC entry 1599 (class 1259 OID 35185)
   136 -- Dependencies: 1880 1881 10
   137 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   138 --
   139 
   140 CREATE TABLE fotka (
   141     id integer DEFAULT nextval('fotka_seq'::regclass) NOT NULL,
   142     podnik integer NOT NULL,
   143     popis character varying(255),
   144     poradi integer DEFAULT 0 NOT NULL
   145 );
   146 
   147 
   148 ALTER TABLE nekurak.fotka OWNER TO nekurak;
   149 
   150 --
   151 -- TOC entry 1919 (class 0 OID 0)
   152 -- Dependencies: 1599
   153 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
   154 --
   155 
   156 COMMENT ON TABLE fotka IS 'Fotka podniku.';
   157 
   158 
   159 --
   160 -- TOC entry 1920 (class 0 OID 0)
   161 -- Dependencies: 1599
   162 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
   163 --
   164 
   165 COMMENT ON COLUMN fotka.poradi IS 'Pořadí fotky v rámci daného podniku.';
   166 
   167 
   168 --
   169 -- TOC entry 1603 (class 1259 OID 35250)
   170 -- Dependencies: 10
   171 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
   172 --
   173 
   174 CREATE SEQUENCE hlasovani_seq
   175     INCREMENT BY 1
   176     NO MAXVALUE
   177     NO MINVALUE
   178     CACHE 1;
   179 
   180 
   181 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
   182 
   183 --
   184 -- TOC entry 1604 (class 1259 OID 35278)
   185 -- Dependencies: 1883 1884 10
   186 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   187 --
   188 
   189 CREATE TABLE hlasovani (
   190     id integer DEFAULT nextval('hlasovani_seq'::regclass) NOT NULL,
   191     podnik integer NOT NULL,
   192     hlas boolean NOT NULL,
   193     datum date DEFAULT now() NOT NULL,
   194     ip_adresa character varying(255) NOT NULL
   195 );
   196 
   197 
   198 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
   199 
   200 --
   201 -- TOC entry 1923 (class 0 OID 0)
   202 -- Dependencies: 1604
   203 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
   204 --
   205 
   206 COMMENT ON COLUMN hlasovani.id IS 'V této tabulce v princupu ID nepotřebujeme,
   207 protože nebudeme adresovat konkrétní záznamy (a i kdyby, můžeme použít OID).
   208 Ale číselné ID se nám bude hodit pro rychlejší nalezení posledního hlasu od dané IP adresy.';
   209 
   210 
   211 --
   212 -- TOC entry 1924 (class 0 OID 0)
   213 -- Dependencies: 1604
   214 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
   215 --
   216 
   217 COMMENT ON COLUMN hlasovani.hlas IS 'Má být tento podnik nekuřácký?
   218 true = nekuřácký
   219 false = kouření povoleno';
   220 
   221 
   222 --
   223 -- TOC entry 1592 (class 1259 OID 35019)
   224 -- Dependencies: 10
   225 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
   226 --
   227 
   228 CREATE SEQUENCE podnik_seq
   229     INCREMENT BY 1
   230     NO MAXVALUE
   231     NO MINVALUE
   232     CACHE 1;
   233 
   234 
   235 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
   236 
   237 --
   238 -- TOC entry 1593 (class 1259 OID 35049)
   239 -- Dependencies: 1876 1877 10
   240 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   241 --
   242 
   243 CREATE TABLE podnik (
   244     id integer DEFAULT nextval('podnik_seq'::regclass) NOT NULL,
   245     nazev character varying(255) NOT NULL,
   246     popis character varying(255),
   247     url character varying(255),
   248     datum timestamp with time zone DEFAULT now(),
   249     ulice character varying(64),
   250     cislo_popisne integer,
   251     mesto character varying(64),
   252     spravce character varying(64),
   253     sirka double precision,
   254     delka double precision
   255 );
   256 
   257 
   258 ALTER TABLE nekurak.podnik OWNER TO nekurak;
   259 
   260 --
   261 -- TOC entry 1927 (class 0 OID 0)
   262 -- Dependencies: 1593
   263 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
   264 --
   265 
   266 COMMENT ON COLUMN podnik.spravce IS 'Přezdívka uživatele, který je správcem tohoto podniku (zadal ho do systému nebo správcovství později dostal)';
   267 
   268 
   269 --
   270 -- TOC entry 1596 (class 1259 OID 35101)
   271 -- Dependencies: 10
   272 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   273 --
   274 
   275 CREATE TABLE role (
   276     kod character varying(16) NOT NULL,
   277     popis character varying(255)
   278 );
   279 
   280 
   281 ALTER TABLE nekurak.role OWNER TO nekurak;
   282 
   283 --
   284 -- TOC entry 1929 (class 0 OID 0)
   285 -- Dependencies: 1596
   286 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
   287 --
   288 
   289 COMMENT ON TABLE role IS 'Role (skupiny) uživatelů ~ oprávnění';
   290 
   291 
   292 --
   293 -- TOC entry 1594 (class 1259 OID 35080)
   294 -- Dependencies: 10
   295 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
   296 --
   297 
   298 CREATE SEQUENCE uzivatel_seq
   299     INCREMENT BY 1
   300     NO MAXVALUE
   301     NO MINVALUE
   302     CACHE 1;
   303 
   304 
   305 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
   306 
   307 --
   308 -- TOC entry 1595 (class 1259 OID 35091)
   309 -- Dependencies: 1878 1879 10
   310 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   311 --
   312 
   313 CREATE TABLE uzivatel (
   314     id integer DEFAULT nextval('uzivatel_seq'::regclass) NOT NULL,
   315     prezdivka character varying(64) NOT NULL,
   316     heslo character varying(512) NOT NULL,
   317     jmeno character varying(64),
   318     prijmeni character varying(64),
   319     email character varying(255),
   320     datum timestamp with time zone DEFAULT now() NOT NULL
   321 );
   322 
   323 
   324 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
   325 
   326 --
   327 -- TOC entry 1932 (class 0 OID 0)
   328 -- Dependencies: 1595
   329 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
   330 --
   331 
   332 COMMENT ON COLUMN uzivatel.prezdivka IS 'Uživatelské jméno';
   333 
   334 
   335 --
   336 -- TOC entry 1597 (class 1259 OID 35106)
   337 -- Dependencies: 10
   338 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace: 
   339 --
   340 
   341 CREATE TABLE uzivatel_role (
   342     role character varying(16) NOT NULL,
   343     prezdivka character varying(64) NOT NULL
   344 );
   345 
   346 
   347 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
   348 
   349 --
   350 -- TOC entry 1934 (class 0 OID 0)
   351 -- Dependencies: 1597
   352 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
   353 --
   354 
   355 COMMENT ON TABLE uzivatel_role IS 'Přiřazení uživatelských rolí (skupin).';
   356 
   357 
   358 --
   359 -- TOC entry 1900 (class 2606 OID 35227)
   360 -- Dependencies: 1600 1600
   361 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   362 --
   363 
   364 ALTER TABLE ONLY clanek
   365     ADD CONSTRAINT clanek_pk PRIMARY KEY (id);
   366 
   367 
   368 --
   369 -- TOC entry 1896 (class 2606 OID 35190)
   370 -- Dependencies: 1599 1599
   371 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   372 --
   373 
   374 ALTER TABLE ONLY fotka
   375     ADD CONSTRAINT fotka_pk PRIMARY KEY (id);
   376 
   377 
   378 --
   379 -- TOC entry 1898 (class 2606 OID 35204)
   380 -- Dependencies: 1599 1599 1599
   381 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   382 --
   383 
   384 ALTER TABLE ONLY fotka
   385     ADD CONSTRAINT fotka_poradi_uq UNIQUE (popis, poradi);
   386 
   387 
   388 --
   389 -- TOC entry 1903 (class 2606 OID 35284)
   390 -- Dependencies: 1604 1604
   391 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   392 --
   393 
   394 ALTER TABLE ONLY hlasovani
   395     ADD CONSTRAINT hlasovani_pk PRIMARY KEY (id);
   396 
   397 
   398 --
   399 -- TOC entry 1886 (class 2606 OID 35058)
   400 -- Dependencies: 1593 1593
   401 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   402 --
   403 
   404 ALTER TABLE ONLY podnik
   405     ADD CONSTRAINT podnik_pk PRIMARY KEY (id);
   406 
   407 
   408 --
   409 -- TOC entry 1892 (class 2606 OID 35105)
   410 -- Dependencies: 1596 1596
   411 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   412 --
   413 
   414 ALTER TABLE ONLY role
   415     ADD CONSTRAINT skupina_pk PRIMARY KEY (kod);
   416 
   417 
   418 --
   419 -- TOC entry 1888 (class 2606 OID 35098)
   420 -- Dependencies: 1595 1595
   421 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   422 --
   423 
   424 ALTER TABLE ONLY uzivatel
   425     ADD CONSTRAINT uzivatel_pk PRIMARY KEY (id);
   426 
   427 
   428 --
   429 -- TOC entry 1890 (class 2606 OID 35100)
   430 -- Dependencies: 1595 1595
   431 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   432 --
   433 
   434 ALTER TABLE ONLY uzivatel
   435     ADD CONSTRAINT uzivatel_prezdivka_uq UNIQUE (prezdivka);
   436 
   437 
   438 --
   439 -- TOC entry 1894 (class 2606 OID 35137)
   440 -- Dependencies: 1597 1597 1597
   441 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   442 --
   443 
   444 ALTER TABLE ONLY uzivatel_role
   445     ADD CONSTRAINT uzivatel_role_pk PRIMARY KEY (role, prezdivka);
   446 
   447 
   448 --
   449 -- TOC entry 1901 (class 1259 OID 35291)
   450 -- Dependencies: 1604
   451 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace: 
   452 --
   453 
   454 CREATE INDEX hlasovani_ip_idx ON hlasovani USING btree (ip_adresa);
   455 
   456 
   457 --
   458 -- TOC entry 1909 (class 2620 OID 35125)
   459 -- Dependencies: 65 1595
   460 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
   461 --
   462 
   463 CREATE TRIGGER uzivatel_insert
   464     AFTER INSERT ON uzivatel
   465     FOR EACH ROW
   466     EXECUTE PROCEDURE bezny_uzivatel();
   467 
   468 
   469 --
   470 -- TOC entry 1907 (class 2606 OID 35191)
   471 -- Dependencies: 1599 1593 1885
   472 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   473 --
   474 
   475 ALTER TABLE ONLY fotka
   476     ADD CONSTRAINT fotka_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id) ON DELETE CASCADE;
   477 
   478 
   479 --
   480 -- TOC entry 1908 (class 2606 OID 35285)
   481 -- Dependencies: 1885 1604 1593
   482 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   483 --
   484 
   485 ALTER TABLE ONLY hlasovani
   486     ADD CONSTRAINT hlasovani_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id) ON DELETE CASCADE;
   487 
   488 
   489 --
   490 -- TOC entry 1904 (class 2606 OID 35178)
   491 -- Dependencies: 1593 1889 1595
   492 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   493 --
   494 
   495 ALTER TABLE ONLY podnik
   496     ADD CONSTRAINT podnik_uzivatel_fk FOREIGN KEY (spravce) REFERENCES uzivatel(prezdivka) ON DELETE SET NULL;
   497 
   498 
   499 --
   500 -- TOC entry 1905 (class 2606 OID 35138)
   501 -- Dependencies: 1597 1891 1596
   502 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   503 --
   504 
   505 ALTER TABLE ONLY uzivatel_role
   506     ADD CONSTRAINT uzivatel_role_role_fk FOREIGN KEY (role) REFERENCES role(kod) ON UPDATE CASCADE ON DELETE CASCADE;
   507 
   508 
   509 --
   510 -- TOC entry 1906 (class 2606 OID 35143)
   511 -- Dependencies: 1889 1595 1597
   512 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   513 --
   514 
   515 ALTER TABLE ONLY uzivatel_role
   516     ADD CONSTRAINT uzivatel_role_uzivatel_fk FOREIGN KEY (prezdivka) REFERENCES uzivatel(prezdivka) ON UPDATE CASCADE ON DELETE CASCADE;
   517 
   518 
   519 --
   520 -- TOC entry 1912 (class 0 OID 0)
   521 -- Dependencies: 10
   522 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
   523 --
   524 
   525 REVOKE ALL ON SCHEMA nekurak FROM PUBLIC;
   526 REVOKE ALL ON SCHEMA nekurak FROM nekurak;
   527 GRANT ALL ON SCHEMA nekurak TO nekurak;
   528 GRANT USAGE ON SCHEMA nekurak TO nekurak_web;
   529 
   530 
   531 --
   532 -- TOC entry 1915 (class 0 OID 0)
   533 -- Dependencies: 1601
   534 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   535 --
   536 
   537 REVOKE ALL ON SEQUENCE clanek_seq FROM PUBLIC;
   538 REVOKE ALL ON SEQUENCE clanek_seq FROM nekurak;
   539 GRANT ALL ON SEQUENCE clanek_seq TO nekurak;
   540 GRANT USAGE ON SEQUENCE clanek_seq TO nekurak_web;
   541 
   542 
   543 --
   544 -- TOC entry 1917 (class 0 OID 0)
   545 -- Dependencies: 1600
   546 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
   547 --
   548 
   549 REVOKE ALL ON TABLE clanek FROM PUBLIC;
   550 REVOKE ALL ON TABLE clanek FROM nekurak;
   551 GRANT ALL ON TABLE clanek TO nekurak;
   552 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE clanek TO nekurak_web;
   553 
   554 
   555 --
   556 -- TOC entry 1918 (class 0 OID 0)
   557 -- Dependencies: 1598
   558 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   559 --
   560 
   561 REVOKE ALL ON SEQUENCE fotka_seq FROM PUBLIC;
   562 REVOKE ALL ON SEQUENCE fotka_seq FROM nekurak;
   563 GRANT ALL ON SEQUENCE fotka_seq TO nekurak;
   564 GRANT USAGE ON SEQUENCE fotka_seq TO nekurak_web;
   565 
   566 
   567 --
   568 -- TOC entry 1921 (class 0 OID 0)
   569 -- Dependencies: 1599
   570 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
   571 --
   572 
   573 REVOKE ALL ON TABLE fotka FROM PUBLIC;
   574 REVOKE ALL ON TABLE fotka FROM nekurak;
   575 GRANT ALL ON TABLE fotka TO nekurak;
   576 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE fotka TO nekurak_web;
   577 
   578 
   579 --
   580 -- TOC entry 1922 (class 0 OID 0)
   581 -- Dependencies: 1603
   582 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   583 --
   584 
   585 REVOKE ALL ON SEQUENCE hlasovani_seq FROM PUBLIC;
   586 REVOKE ALL ON SEQUENCE hlasovani_seq FROM nekurak;
   587 GRANT ALL ON SEQUENCE hlasovani_seq TO nekurak;
   588 GRANT USAGE ON SEQUENCE hlasovani_seq TO nekurak_web;
   589 
   590 
   591 --
   592 -- TOC entry 1925 (class 0 OID 0)
   593 -- Dependencies: 1604
   594 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
   595 --
   596 
   597 REVOKE ALL ON TABLE hlasovani FROM PUBLIC;
   598 REVOKE ALL ON TABLE hlasovani FROM nekurak;
   599 GRANT ALL ON TABLE hlasovani TO nekurak;
   600 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE hlasovani TO nekurak_web;
   601 
   602 
   603 --
   604 -- TOC entry 1926 (class 0 OID 0)
   605 -- Dependencies: 1592
   606 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   607 --
   608 
   609 REVOKE ALL ON SEQUENCE podnik_seq FROM PUBLIC;
   610 REVOKE ALL ON SEQUENCE podnik_seq FROM nekurak;
   611 GRANT ALL ON SEQUENCE podnik_seq TO nekurak;
   612 GRANT USAGE ON SEQUENCE podnik_seq TO nekurak_web;
   613 
   614 
   615 --
   616 -- TOC entry 1928 (class 0 OID 0)
   617 -- Dependencies: 1593
   618 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
   619 --
   620 
   621 REVOKE ALL ON TABLE podnik FROM PUBLIC;
   622 REVOKE ALL ON TABLE podnik FROM nekurak;
   623 GRANT ALL ON TABLE podnik TO nekurak;
   624 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik TO nekurak_web;
   625 
   626 
   627 --
   628 -- TOC entry 1930 (class 0 OID 0)
   629 -- Dependencies: 1596
   630 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
   631 --
   632 
   633 REVOKE ALL ON TABLE role FROM PUBLIC;
   634 REVOKE ALL ON TABLE role FROM nekurak;
   635 GRANT ALL ON TABLE role TO nekurak;
   636 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE role TO nekurak_web;
   637 
   638 
   639 --
   640 -- TOC entry 1931 (class 0 OID 0)
   641 -- Dependencies: 1594
   642 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   643 --
   644 
   645 REVOKE ALL ON SEQUENCE uzivatel_seq FROM PUBLIC;
   646 REVOKE ALL ON SEQUENCE uzivatel_seq FROM nekurak;
   647 GRANT ALL ON SEQUENCE uzivatel_seq TO nekurak;
   648 GRANT USAGE ON SEQUENCE uzivatel_seq TO nekurak_web;
   649 
   650 
   651 --
   652 -- TOC entry 1933 (class 0 OID 0)
   653 -- Dependencies: 1595
   654 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
   655 --
   656 
   657 REVOKE ALL ON TABLE uzivatel FROM PUBLIC;
   658 REVOKE ALL ON TABLE uzivatel FROM nekurak;
   659 GRANT ALL ON TABLE uzivatel TO nekurak;
   660 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel TO nekurak_web;
   661 
   662 
   663 --
   664 -- TOC entry 1935 (class 0 OID 0)
   665 -- Dependencies: 1597
   666 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
   667 --
   668 
   669 REVOKE ALL ON TABLE uzivatel_role FROM PUBLIC;
   670 REVOKE ALL ON TABLE uzivatel_role FROM nekurak;
   671 GRANT ALL ON TABLE uzivatel_role TO nekurak;
   672 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
   673 
   674 
   675 -- Completed on 2010-04-28 00:33:49 CEST
   676 
   677 --
   678 -- PostgreSQL database dump complete
   679 --
   680