1.1 --- a/sql/schéma.sql Tue Mar 16 14:13:14 2010 +0100
1.2 +++ b/sql/schéma.sql Mon Apr 12 12:09:45 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: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