sql/schéma.sql
changeset 85 063871cec626
parent 71 3829d619369c
child 115 b278b6b2d552
     1.1 --- a/sql/schéma.sql	Tue Mar 16 14:13:14 2010 +0100
     1.2 +++ b/sql/schéma.sql	Tue Mar 23 16:11:07 2010 +0100
     1.3 @@ -2,7 +2,7 @@
     1.4  -- PostgreSQL database dump
     1.5  --
     1.6  
     1.7 --- Started on 2010-03-16 14:11:16 CET
     1.8 +-- Started on 2010-03-16 14:32:22 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 1892 (class 0 OID 0)
    1.17 +-- TOC entry 1894 (class 0 OID 0)
    1.18  -- Dependencies: 368
    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: 395 10
    1.26 +-- Dependencies: 10 395
    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 1893 (class 0 OID 0)
    1.35 +-- TOC entry 1895 (class 0 OID 0)
    1.36  -- Dependencies: 65
    1.37  -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.38  --
    1.39 @@ -109,7 +109,7 @@
    1.40  ALTER TABLE nekurak.fotka OWNER TO nekurak;
    1.41  
    1.42  --
    1.43 --- TOC entry 1895 (class 0 OID 0)
    1.44 +-- TOC entry 1897 (class 0 OID 0)
    1.45  -- Dependencies: 1593
    1.46  -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.47  --
    1.48 @@ -118,7 +118,7 @@
    1.49  
    1.50  
    1.51  --
    1.52 --- TOC entry 1896 (class 0 OID 0)
    1.53 +-- TOC entry 1898 (class 0 OID 0)
    1.54  -- Dependencies: 1593
    1.55  -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.56  --
    1.57 @@ -145,7 +145,7 @@
    1.58  ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
    1.59  
    1.60  --
    1.61 --- TOC entry 1898 (class 0 OID 0)
    1.62 +-- TOC entry 1900 (class 0 OID 0)
    1.63  -- Dependencies: 1587
    1.64  -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.65  --
    1.66 @@ -194,7 +194,7 @@
    1.67  ALTER TABLE nekurak.podnik OWNER TO nekurak;
    1.68  
    1.69  --
    1.70 --- TOC entry 1901 (class 0 OID 0)
    1.71 +-- TOC entry 1903 (class 0 OID 0)
    1.72  -- Dependencies: 1586
    1.73  -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.74  --
    1.75 @@ -217,7 +217,7 @@
    1.76  ALTER TABLE nekurak.role OWNER TO nekurak;
    1.77  
    1.78  --
    1.79 --- TOC entry 1903 (class 0 OID 0)
    1.80 +-- TOC entry 1905 (class 0 OID 0)
    1.81  -- Dependencies: 1590
    1.82  -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.83  --
    1.84 @@ -260,7 +260,7 @@
    1.85  ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
    1.86  
    1.87  --
    1.88 --- TOC entry 1906 (class 0 OID 0)
    1.89 +-- TOC entry 1908 (class 0 OID 0)
    1.90  -- Dependencies: 1589
    1.91  -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
    1.92  --
    1.93 @@ -283,7 +283,7 @@
    1.94  ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
    1.95  
    1.96  --
    1.97 --- TOC entry 1908 (class 0 OID 0)
    1.98 +-- TOC entry 1910 (class 0 OID 0)
    1.99  -- Dependencies: 1591
   1.100  -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
   1.101  --
   1.102 @@ -302,6 +302,16 @@
   1.103  
   1.104  
   1.105  --
   1.106 +-- TOC entry 1884 (class 2606 OID 35204)
   1.107 +-- Dependencies: 1593 1593 1593
   1.108 +-- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.109 +--
   1.110 +
   1.111 +ALTER TABLE ONLY fotka
   1.112 +    ADD CONSTRAINT fotka_poradi_uq UNIQUE (popis, poradi);
   1.113 +
   1.114 +
   1.115 +--
   1.116  -- TOC entry 1872 (class 2606 OID 35058)
   1.117  -- Dependencies: 1586 1586
   1.118  -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace: 
   1.119 @@ -352,8 +362,8 @@
   1.120  
   1.121  
   1.122  --
   1.123 --- TOC entry 1888 (class 2620 OID 35125)
   1.124 --- Dependencies: 65 1589
   1.125 +-- TOC entry 1890 (class 2620 OID 35125)
   1.126 +-- Dependencies: 1589 65
   1.127  -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
   1.128  --
   1.129  
   1.130 @@ -364,8 +374,8 @@
   1.131  
   1.132  
   1.133  --
   1.134 --- TOC entry 1887 (class 2606 OID 35191)
   1.135 --- Dependencies: 1871 1593 1586
   1.136 +-- TOC entry 1889 (class 2606 OID 35191)
   1.137 +-- Dependencies: 1871 1586 1593
   1.138  -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.139  --
   1.140  
   1.141 @@ -374,8 +384,8 @@
   1.142  
   1.143  
   1.144  --
   1.145 --- TOC entry 1884 (class 2606 OID 35072)
   1.146 --- Dependencies: 1871 1586 1587
   1.147 +-- TOC entry 1886 (class 2606 OID 35072)
   1.148 +-- Dependencies: 1587 1871 1586
   1.149  -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.150  --
   1.151  
   1.152 @@ -384,7 +394,7 @@
   1.153  
   1.154  
   1.155  --
   1.156 --- TOC entry 1883 (class 2606 OID 35178)
   1.157 +-- TOC entry 1885 (class 2606 OID 35178)
   1.158  -- Dependencies: 1875 1589 1586
   1.159  -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.160  --
   1.161 @@ -394,7 +404,7 @@
   1.162  
   1.163  
   1.164  --
   1.165 --- TOC entry 1885 (class 2606 OID 35138)
   1.166 +-- TOC entry 1887 (class 2606 OID 35138)
   1.167  -- Dependencies: 1590 1591 1877
   1.168  -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.169  --
   1.170 @@ -404,7 +414,7 @@
   1.171  
   1.172  
   1.173  --
   1.174 --- TOC entry 1886 (class 2606 OID 35143)
   1.175 +-- TOC entry 1888 (class 2606 OID 35143)
   1.176  -- Dependencies: 1591 1589 1875
   1.177  -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
   1.178  --
   1.179 @@ -414,7 +424,7 @@
   1.180  
   1.181  
   1.182  --
   1.183 --- TOC entry 1891 (class 0 OID 0)
   1.184 +-- TOC entry 1893 (class 0 OID 0)
   1.185  -- Dependencies: 10
   1.186  -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
   1.187  --
   1.188 @@ -426,7 +436,7 @@
   1.189  
   1.190  
   1.191  --
   1.192 --- TOC entry 1894 (class 0 OID 0)
   1.193 +-- TOC entry 1896 (class 0 OID 0)
   1.194  -- Dependencies: 1592
   1.195  -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.196  --
   1.197 @@ -438,7 +448,7 @@
   1.198  
   1.199  
   1.200  --
   1.201 --- TOC entry 1897 (class 0 OID 0)
   1.202 +-- TOC entry 1899 (class 0 OID 0)
   1.203  -- Dependencies: 1593
   1.204  -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
   1.205  --
   1.206 @@ -450,7 +460,7 @@
   1.207  
   1.208  
   1.209  --
   1.210 --- TOC entry 1899 (class 0 OID 0)
   1.211 +-- TOC entry 1901 (class 0 OID 0)
   1.212  -- Dependencies: 1587
   1.213  -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
   1.214  --
   1.215 @@ -462,7 +472,7 @@
   1.216  
   1.217  
   1.218  --
   1.219 --- TOC entry 1900 (class 0 OID 0)
   1.220 +-- TOC entry 1902 (class 0 OID 0)
   1.221  -- Dependencies: 1585
   1.222  -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.223  --
   1.224 @@ -474,7 +484,7 @@
   1.225  
   1.226  
   1.227  --
   1.228 --- TOC entry 1902 (class 0 OID 0)
   1.229 +-- TOC entry 1904 (class 0 OID 0)
   1.230  -- Dependencies: 1586
   1.231  -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
   1.232  --
   1.233 @@ -486,7 +496,7 @@
   1.234  
   1.235  
   1.236  --
   1.237 --- TOC entry 1904 (class 0 OID 0)
   1.238 +-- TOC entry 1906 (class 0 OID 0)
   1.239  -- Dependencies: 1590
   1.240  -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
   1.241  --
   1.242 @@ -498,7 +508,7 @@
   1.243  
   1.244  
   1.245  --
   1.246 --- TOC entry 1905 (class 0 OID 0)
   1.247 +-- TOC entry 1907 (class 0 OID 0)
   1.248  -- Dependencies: 1588
   1.249  -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
   1.250  --
   1.251 @@ -510,7 +520,7 @@
   1.252  
   1.253  
   1.254  --
   1.255 --- TOC entry 1907 (class 0 OID 0)
   1.256 +-- TOC entry 1909 (class 0 OID 0)
   1.257  -- Dependencies: 1589
   1.258  -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
   1.259  --
   1.260 @@ -522,7 +532,7 @@
   1.261  
   1.262  
   1.263  --
   1.264 --- TOC entry 1909 (class 0 OID 0)
   1.265 +-- TOC entry 1911 (class 0 OID 0)
   1.266  -- Dependencies: 1591
   1.267  -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
   1.268  --
   1.269 @@ -533,7 +543,7 @@
   1.270  GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
   1.271  
   1.272  
   1.273 --- Completed on 2010-03-16 14:11:18 CET
   1.274 +-- Completed on 2010-03-16 14:32:24 CET
   1.275  
   1.276  --
   1.277  -- PostgreSQL database dump complete