SQL: zapomenuté změny ve schématu.
authorFrantišek Kučera <franta-hg@frantovo.cz>
Wed, 28 Apr 2010 00:36:21 +0200
changeset 115b278b6b2d552
parent 114 8bb670b27567
child 116 6d9647a51193
SQL: zapomenuté změny ve schématu.
sql/schéma.sql
     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