Zobrazování jen schválených podniků, SQL (kategorie, kuřáckost).
1.1 --- a/java/nekurak.net-ejb/src/conf/Podnik.hbm.xml Sat Jan 15 01:24:00 2011 +0100
1.2 +++ b/java/nekurak.net-ejb/src/conf/Podnik.hbm.xml Sat Jan 15 14:27:02 2011 +0100
1.3 @@ -32,5 +32,6 @@
1.4 <property name="sirka" column="sirka"/>
1.5 <property name="delka" column="delka"/>
1.6 <many-to-one name="kurackost" column="kurackost" not-null="true"/>
1.7 + <property name="schvaleny" column="schvaleny"/>
1.8 </class>
1.9 </hibernate-mapping>
1.10 \ No newline at end of file
2.1 --- a/java/nekurak.net-ejb/src/java/cz/frantovo/nekurak/dao/PodnikDAO.java Sat Jan 15 01:24:00 2011 +0100
2.2 +++ b/java/nekurak.net-ejb/src/java/cz/frantovo/nekurak/dao/PodnikDAO.java Sat Jan 15 14:27:02 2011 +0100
2.3 @@ -9,7 +9,6 @@
2.4 import java.util.Collection;
2.5 import java.util.Date;
2.6 import java.util.List;
2.7 -import java.util.Set;
2.8 import javax.ejb.LocalBean;
2.9 import javax.ejb.Stateless;
2.10 import javax.persistence.EntityManager;
2.11 @@ -33,13 +32,16 @@
2.12 HLASOVANI_SELECT
2.13 }
2.14
2.15 + /**
2.16 + * @return schválené podniky
2.17 + */
2.18 public Collection<Podnik> getPodniky() {
2.19 - Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " p ORDER BY datum DESC");
2.20 + Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " p WHERE p.schvaleny = true ORDER BY datum DESC");
2.21 return dotaz.getResultList();
2.22 }
2.23
2.24 /**
2.25 - * @return podniky, které nemají souřadnice (null, null)
2.26 + * @return podniky, které nemají souřadnice (null, null), včetně neschválených
2.27 */
2.28 public Collection<Podnik> getPodnikyBezSouradnic() {
2.29 Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " p WHERE sirka IS NULL AND delka IS NULL");
2.30 @@ -48,16 +50,16 @@
2.31
2.32 /**
2.33 * @param kategorie jedna kategorie
2.34 - * @return podniky určité kategorie
2.35 + * @return podniky určité kategorie (jen schválené)
2.36 */
2.37 public Collection<Podnik> getPodniky(Kategorie kategorie) {
2.38 - Query dotaz = em.createQuery("SELECT p FROM " + DAO.t(Podnik.class) + " p INNER JOIN p.kategorie k WHERE k = :kategorie ORDER BY datum DESC");
2.39 + Query dotaz = em.createQuery("SELECT p FROM " + DAO.t(Podnik.class) + " p INNER JOIN p.kategorie k WHERE k = :kategorie AND p.schvaleny = true ORDER BY datum DESC");
2.40 dotaz.setParameter("kategorie", kategorie);
2.41 return dotaz.getResultList();
2.42 }
2.43
2.44 public Collection<Podnik> getPodniky(Kurackost kurackost) {
2.45 - Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " p WHERE p.kurackost = :kurackost ORDER BY datum DESC");
2.46 + Query dotaz = em.createQuery("FROM " + DAO.t(Podnik.class) + " p WHERE p.kurackost = :kurackost AND p.schvaleny = true ORDER BY datum DESC");
2.47 dotaz.setParameter("kurackost", kurackost);
2.48 return dotaz.getResultList();
2.49 }
3.1 --- a/java/nekurak.net-ejb/src/java/cz/frantovo/nekurak/ejb/PodnikEJB.java Sat Jan 15 01:24:00 2011 +0100
3.2 +++ b/java/nekurak.net-ejb/src/java/cz/frantovo/nekurak/ejb/PodnikEJB.java Sat Jan 15 14:27:02 2011 +0100
3.3 @@ -56,6 +56,11 @@
3.4
3.5 @RolesAllowed("opravneny")
3.6 public void zalozPodnik(Podnik p) {
3.7 + /**
3.8 + * Podnik zakládáme jako neschválený a je potřeba ho dodatečně schválit,
3.9 + * to může udělat jen správce a ne uživatel (TODO)
3.10 + */
3.11 + p.setSchvaleny(false);
3.12 p.setSpravce(ctx.getCallerPrincipal().getName());
3.13 podnikDAO.zaloz(p);
3.14 }
4.1 --- a/java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Podnik.java Sat Jan 15 01:24:00 2011 +0100
4.2 +++ b/java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Podnik.java Sat Jan 15 14:27:02 2011 +0100
4.3 @@ -29,6 +29,7 @@
4.4 private Double sirka;
4.5 private Double delka;
4.6 private Kurackost kurackost = new Kurackost();
4.7 + private boolean schvaleny = false;
4.8
4.9 public Podnik() {
4.10 }
4.11 @@ -180,5 +181,13 @@
4.12 public void setKurackost(Kurackost kurackost) {
4.13 this.kurackost = kurackost;
4.14 }
4.15 +
4.16 + public boolean isSchvaleny() {
4.17 + return schvaleny;
4.18 + }
4.19 +
4.20 + public void setSchvaleny(boolean schvaleny) {
4.21 + this.schvaleny = schvaleny;
4.22 + }
4.23 /** Půdou a sklepem projedete bez nebezpečí. */
4.24 }
5.1 --- a/sql/schéma.sql Sat Jan 15 01:24:00 2011 +0100
5.2 +++ b/sql/schéma.sql Sat Jan 15 14:27:02 2011 +0100
5.3 @@ -2,7 +2,7 @@
5.4 -- PostgreSQL database dump
5.5 --
5.6
5.7 --- Started on 2011-01-11 15:26:21 CET
5.8 +-- Started on 2011-01-15 14:24:29 CET
5.9
5.10 SET statement_timeout = 0;
5.11 SET client_encoding = 'UTF8';
5.12 @@ -36,7 +36,7 @@
5.13 ALTER DOMAIN nekurak.email OWNER TO nekurak;
5.14
5.15 --
5.16 --- TOC entry 1942 (class 0 OID 0)
5.17 +-- TOC entry 1946 (class 0 OID 0)
5.18 -- Dependencies: 366
5.19 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.20 --
5.21 @@ -46,7 +46,7 @@
5.22
5.23 --
5.24 -- TOC entry 65 (class 1255 OID 35124)
5.25 --- Dependencies: 411 10
5.26 +-- Dependencies: 412 10
5.27 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
5.28 --
5.29
5.30 @@ -64,7 +64,7 @@
5.31 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
5.32
5.33 --
5.34 --- TOC entry 1943 (class 0 OID 0)
5.35 +-- TOC entry 1947 (class 0 OID 0)
5.36 -- Dependencies: 65
5.37 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
5.38 --
5.39 @@ -73,7 +73,7 @@
5.40
5.41
5.42 --
5.43 --- TOC entry 1610 (class 1259 OID 35223)
5.44 +-- TOC entry 1611 (class 1259 OID 35223)
5.45 -- Dependencies: 10
5.46 -- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.47 --
5.48 @@ -92,8 +92,8 @@
5.49 SET default_with_oids = false;
5.50
5.51 --
5.52 --- TOC entry 1609 (class 1259 OID 35205)
5.53 --- Dependencies: 1897 10
5.54 +-- TOC entry 1610 (class 1259 OID 35205)
5.55 +-- Dependencies: 1899 10
5.56 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.57 --
5.58
5.59 @@ -107,8 +107,8 @@
5.60 ALTER TABLE nekurak.clanek OWNER TO nekurak;
5.61
5.62 --
5.63 --- TOC entry 1945 (class 0 OID 0)
5.64 --- Dependencies: 1609
5.65 +-- TOC entry 1949 (class 0 OID 0)
5.66 +-- Dependencies: 1610
5.67 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.68 --
5.69
5.70 @@ -116,7 +116,7 @@
5.71
5.72
5.73 --
5.74 --- TOC entry 1607 (class 1259 OID 35183)
5.75 +-- TOC entry 1608 (class 1259 OID 35183)
5.76 -- Dependencies: 10
5.77 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.78 --
5.79 @@ -132,8 +132,8 @@
5.80 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
5.81
5.82 --
5.83 --- TOC entry 1608 (class 1259 OID 35185)
5.84 --- Dependencies: 1895 1896 10
5.85 +-- TOC entry 1609 (class 1259 OID 35185)
5.86 +-- Dependencies: 1897 1898 10
5.87 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.88 --
5.89
5.90 @@ -148,8 +148,8 @@
5.91 ALTER TABLE nekurak.fotka OWNER TO nekurak;
5.92
5.93 --
5.94 --- TOC entry 1948 (class 0 OID 0)
5.95 --- Dependencies: 1608
5.96 +-- TOC entry 1952 (class 0 OID 0)
5.97 +-- Dependencies: 1609
5.98 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.99 --
5.100
5.101 @@ -157,8 +157,8 @@
5.102
5.103
5.104 --
5.105 --- TOC entry 1949 (class 0 OID 0)
5.106 --- Dependencies: 1608
5.107 +-- TOC entry 1953 (class 0 OID 0)
5.108 +-- Dependencies: 1609
5.109 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.110 --
5.111
5.112 @@ -166,7 +166,7 @@
5.113
5.114
5.115 --
5.116 --- TOC entry 1612 (class 1259 OID 35250)
5.117 +-- TOC entry 1613 (class 1259 OID 35250)
5.118 -- Dependencies: 10
5.119 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.120 --
5.121 @@ -181,8 +181,8 @@
5.122 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
5.123
5.124 --
5.125 --- TOC entry 1613 (class 1259 OID 35278)
5.126 --- Dependencies: 1898 1899 10
5.127 +-- TOC entry 1614 (class 1259 OID 35278)
5.128 +-- Dependencies: 1900 1901 10
5.129 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.130 --
5.131
5.132 @@ -198,8 +198,8 @@
5.133 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
5.134
5.135 --
5.136 --- TOC entry 1952 (class 0 OID 0)
5.137 --- Dependencies: 1613
5.138 +-- TOC entry 1956 (class 0 OID 0)
5.139 +-- Dependencies: 1614
5.140 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.141 --
5.142
5.143 @@ -209,8 +209,8 @@
5.144
5.145
5.146 --
5.147 --- TOC entry 1953 (class 0 OID 0)
5.148 --- Dependencies: 1613
5.149 +-- TOC entry 1957 (class 0 OID 0)
5.150 +-- Dependencies: 1614
5.151 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.152 --
5.153
5.154 @@ -220,28 +220,13 @@
5.155
5.156
5.157 --
5.158 --- TOC entry 1616 (class 1259 OID 35396)
5.159 +-- TOC entry 1617 (class 1259 OID 35398)
5.160 -- Dependencies: 10
5.161 --- Name: kategorie_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.162 ---
5.163 -
5.164 -CREATE SEQUENCE kategorie_seq
5.165 - INCREMENT BY 1
5.166 - NO MAXVALUE
5.167 - NO MINVALUE
5.168 - CACHE 1;
5.169 -
5.170 -
5.171 -ALTER TABLE nekurak.kategorie_seq OWNER TO nekurak;
5.172 -
5.173 ---
5.174 --- TOC entry 1617 (class 1259 OID 35398)
5.175 --- Dependencies: 1902 10
5.176 -- Name: kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.177 --
5.178
5.179 CREATE TABLE kategorie (
5.180 - id integer DEFAULT nextval('kategorie_seq'::regclass) NOT NULL,
5.181 + id integer NOT NULL,
5.182 nazev character varying(32) NOT NULL
5.183 );
5.184
5.185 @@ -249,7 +234,7 @@
5.186 ALTER TABLE nekurak.kategorie OWNER TO nekurak;
5.187
5.188 --
5.189 --- TOC entry 1956 (class 0 OID 0)
5.190 +-- TOC entry 1959 (class 0 OID 0)
5.191 -- Dependencies: 1617
5.192 -- Name: TABLE kategorie; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.193 --
5.194 @@ -258,7 +243,7 @@
5.195
5.196
5.197 --
5.198 --- TOC entry 1957 (class 0 OID 0)
5.199 +-- TOC entry 1960 (class 0 OID 0)
5.200 -- Dependencies: 1617
5.201 -- Name: COLUMN kategorie.nazev; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.202 --
5.203 @@ -268,7 +253,7 @@
5.204
5.205
5.206 --
5.207 --- TOC entry 1614 (class 1259 OID 35333)
5.208 +-- TOC entry 1615 (class 1259 OID 35333)
5.209 -- Dependencies: 10
5.210 -- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.211 --
5.212 @@ -283,8 +268,8 @@
5.213 ALTER TABLE nekurak.komentar_seq OWNER TO nekurak;
5.214
5.215 --
5.216 --- TOC entry 1615 (class 1259 OID 35376)
5.217 --- Dependencies: 1900 1901 10
5.218 +-- TOC entry 1616 (class 1259 OID 35376)
5.219 +-- Dependencies: 1902 1903 10
5.220 -- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.221 --
5.222
5.223 @@ -301,8 +286,8 @@
5.224 ALTER TABLE nekurak.komentar OWNER TO nekurak;
5.225
5.226 --
5.227 --- TOC entry 1960 (class 0 OID 0)
5.228 --- Dependencies: 1615
5.229 +-- TOC entry 1963 (class 0 OID 0)
5.230 +-- Dependencies: 1616
5.231 -- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.232 --
5.233
5.234 @@ -310,8 +295,8 @@
5.235
5.236
5.237 --
5.238 --- TOC entry 1961 (class 0 OID 0)
5.239 --- Dependencies: 1615
5.240 +-- TOC entry 1964 (class 0 OID 0)
5.241 +-- Dependencies: 1616
5.242 -- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.243 --
5.244
5.245 @@ -319,8 +304,8 @@
5.246
5.247
5.248 --
5.249 --- TOC entry 1962 (class 0 OID 0)
5.250 --- Dependencies: 1615
5.251 +-- TOC entry 1965 (class 0 OID 0)
5.252 +-- Dependencies: 1616
5.253 -- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.254 --
5.255
5.256 @@ -329,7 +314,30 @@
5.257
5.258
5.259 --
5.260 --- TOC entry 1601 (class 1259 OID 35019)
5.261 +-- TOC entry 1619 (class 1259 OID 35436)
5.262 +-- Dependencies: 10
5.263 +-- Name: kurackost; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.264 +--
5.265 +
5.266 +CREATE TABLE kurackost (
5.267 + id integer NOT NULL,
5.268 + popis character varying(64)
5.269 +);
5.270 +
5.271 +
5.272 +ALTER TABLE nekurak.kurackost OWNER TO nekurak;
5.273 +
5.274 +--
5.275 +-- TOC entry 1967 (class 0 OID 0)
5.276 +-- Dependencies: 1619
5.277 +-- Name: TABLE kurackost; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.278 +--
5.279 +
5.280 +COMMENT ON TABLE kurackost IS 'Kuřáckost podniku – zda se tu kouří, nekouří, nebo jen částečně atd.';
5.281 +
5.282 +
5.283 +--
5.284 +-- TOC entry 1602 (class 1259 OID 35019)
5.285 -- Dependencies: 10
5.286 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.287 --
5.288 @@ -344,8 +352,8 @@
5.289 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
5.290
5.291 --
5.292 --- TOC entry 1602 (class 1259 OID 35049)
5.293 --- Dependencies: 1890 1891 1892 10
5.294 +-- TOC entry 1603 (class 1259 OID 35049)
5.295 +-- Dependencies: 1891 1892 1893 1894 10
5.296 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.297 --
5.298
5.299 @@ -361,16 +369,16 @@
5.300 spravce character varying(64),
5.301 sirka double precision,
5.302 delka double precision,
5.303 - stav character(1),
5.304 - CONSTRAINT stav_tg CHECK (((stav = ANY (ARRAY['k'::bpchar, 'n'::bpchar, 'o'::bpchar, 'c'::bpchar])) OR (stav IS NULL)))
5.305 + kurackost integer DEFAULT 0 NOT NULL,
5.306 + schvaleny boolean DEFAULT false NOT NULL
5.307 );
5.308
5.309
5.310 ALTER TABLE nekurak.podnik OWNER TO nekurak;
5.311
5.312 --
5.313 --- TOC entry 1965 (class 0 OID 0)
5.314 --- Dependencies: 1602
5.315 +-- TOC entry 1970 (class 0 OID 0)
5.316 +-- Dependencies: 1603
5.317 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.318 --
5.319
5.320 @@ -378,19 +386,6 @@
5.321
5.322
5.323 --
5.324 --- TOC entry 1966 (class 0 OID 0)
5.325 --- Dependencies: 1602
5.326 --- Name: CONSTRAINT stav_tg ON podnik; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.327 ---
5.328 -
5.329 -COMMENT ON CONSTRAINT stav_tg ON podnik IS 'k = kuřácký
5.330 -n = nekuřácký
5.331 -o = oddělené části (důkladně)
5.332 -c = částečně kuřácký (špatně oddělené, považujeme za kuřácký)
5.333 -NULL = neznámý stav';
5.334 -
5.335 -
5.336 ---
5.337 -- TOC entry 1618 (class 1259 OID 35404)
5.338 -- Dependencies: 10
5.339 -- Name: podnik_kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.340 @@ -405,7 +400,7 @@
5.341 ALTER TABLE nekurak.podnik_kategorie OWNER TO nekurak;
5.342
5.343 --
5.344 --- TOC entry 1605 (class 1259 OID 35101)
5.345 +-- TOC entry 1606 (class 1259 OID 35101)
5.346 -- Dependencies: 10
5.347 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.348 --
5.349 @@ -419,8 +414,8 @@
5.350 ALTER TABLE nekurak.role OWNER TO nekurak;
5.351
5.352 --
5.353 --- TOC entry 1969 (class 0 OID 0)
5.354 --- Dependencies: 1605
5.355 +-- TOC entry 1973 (class 0 OID 0)
5.356 +-- Dependencies: 1606
5.357 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.358 --
5.359
5.360 @@ -428,7 +423,7 @@
5.361
5.362
5.363 --
5.364 --- TOC entry 1603 (class 1259 OID 35080)
5.365 +-- TOC entry 1604 (class 1259 OID 35080)
5.366 -- Dependencies: 10
5.367 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
5.368 --
5.369 @@ -443,8 +438,8 @@
5.370 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
5.371
5.372 --
5.373 --- TOC entry 1604 (class 1259 OID 35091)
5.374 --- Dependencies: 1893 1894 10
5.375 +-- TOC entry 1605 (class 1259 OID 35091)
5.376 +-- Dependencies: 1895 1896 10
5.377 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.378 --
5.379
5.380 @@ -462,8 +457,8 @@
5.381 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
5.382
5.383 --
5.384 --- TOC entry 1972 (class 0 OID 0)
5.385 --- Dependencies: 1604
5.386 +-- TOC entry 1976 (class 0 OID 0)
5.387 +-- Dependencies: 1605
5.388 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.389 --
5.390
5.391 @@ -471,7 +466,7 @@
5.392
5.393
5.394 --
5.395 --- TOC entry 1606 (class 1259 OID 35106)
5.396 +-- TOC entry 1607 (class 1259 OID 35106)
5.397 -- Dependencies: 10
5.398 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
5.399 --
5.400 @@ -485,8 +480,8 @@
5.401 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
5.402
5.403 --
5.404 --- TOC entry 1974 (class 0 OID 0)
5.405 --- Dependencies: 1606
5.406 +-- TOC entry 1978 (class 0 OID 0)
5.407 +-- Dependencies: 1607
5.408 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
5.409 --
5.410
5.411 @@ -494,8 +489,8 @@
5.412
5.413
5.414 --
5.415 --- TOC entry 1918 (class 2606 OID 35227)
5.416 --- Dependencies: 1609 1609
5.417 +-- TOC entry 1919 (class 2606 OID 35227)
5.418 +-- Dependencies: 1610 1610
5.419 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.420 --
5.421
5.422 @@ -504,8 +499,8 @@
5.423
5.424
5.425 --
5.426 --- TOC entry 1914 (class 2606 OID 35190)
5.427 --- Dependencies: 1608 1608
5.428 +-- TOC entry 1915 (class 2606 OID 35190)
5.429 +-- Dependencies: 1609 1609
5.430 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.431 --
5.432
5.433 @@ -514,8 +509,8 @@
5.434
5.435
5.436 --
5.437 --- TOC entry 1916 (class 2606 OID 35204)
5.438 --- Dependencies: 1608 1608 1608
5.439 +-- TOC entry 1917 (class 2606 OID 35204)
5.440 +-- Dependencies: 1609 1609 1609
5.441 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.442 --
5.443
5.444 @@ -524,8 +519,8 @@
5.445
5.446
5.447 --
5.448 --- TOC entry 1921 (class 2606 OID 35284)
5.449 --- Dependencies: 1613 1613
5.450 +-- TOC entry 1922 (class 2606 OID 35284)
5.451 +-- Dependencies: 1614 1614
5.452 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.453 --
5.454
5.455 @@ -534,7 +529,7 @@
5.456
5.457
5.458 --
5.459 --- TOC entry 1926 (class 2606 OID 35403)
5.460 +-- TOC entry 1927 (class 2606 OID 35403)
5.461 -- Dependencies: 1617 1617
5.462 -- Name: kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.463 --
5.464 @@ -544,8 +539,8 @@
5.465
5.466
5.467 --
5.468 --- TOC entry 1924 (class 2606 OID 35385)
5.469 --- Dependencies: 1615 1615
5.470 +-- TOC entry 1925 (class 2606 OID 35385)
5.471 +-- Dependencies: 1616 1616
5.472 -- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.473 --
5.474
5.475 @@ -554,7 +549,17 @@
5.476
5.477
5.478 --
5.479 --- TOC entry 1928 (class 2606 OID 35408)
5.480 +-- TOC entry 1931 (class 2606 OID 35441)
5.481 +-- Dependencies: 1619 1619
5.482 +-- Name: kurackost_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.483 +--
5.484 +
5.485 +ALTER TABLE ONLY kurackost
5.486 + ADD CONSTRAINT kurackost_pk PRIMARY KEY (id);
5.487 +
5.488 +
5.489 +--
5.490 +-- TOC entry 1929 (class 2606 OID 35408)
5.491 -- Dependencies: 1618 1618 1618
5.492 -- Name: podnik_kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.493 --
5.494 @@ -564,8 +569,8 @@
5.495
5.496
5.497 --
5.498 --- TOC entry 1904 (class 2606 OID 35058)
5.499 --- Dependencies: 1602 1602
5.500 +-- TOC entry 1905 (class 2606 OID 35058)
5.501 +-- Dependencies: 1603 1603
5.502 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.503 --
5.504
5.505 @@ -574,8 +579,8 @@
5.506
5.507
5.508 --
5.509 --- TOC entry 1910 (class 2606 OID 35105)
5.510 --- Dependencies: 1605 1605
5.511 +-- TOC entry 1911 (class 2606 OID 35105)
5.512 +-- Dependencies: 1606 1606
5.513 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.514 --
5.515
5.516 @@ -584,8 +589,8 @@
5.517
5.518
5.519 --
5.520 --- TOC entry 1906 (class 2606 OID 35098)
5.521 --- Dependencies: 1604 1604
5.522 +-- TOC entry 1907 (class 2606 OID 35098)
5.523 +-- Dependencies: 1605 1605
5.524 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.525 --
5.526
5.527 @@ -594,8 +599,8 @@
5.528
5.529
5.530 --
5.531 --- TOC entry 1908 (class 2606 OID 35100)
5.532 --- Dependencies: 1604 1604
5.533 +-- TOC entry 1909 (class 2606 OID 35100)
5.534 +-- Dependencies: 1605 1605
5.535 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.536 --
5.537
5.538 @@ -604,8 +609,8 @@
5.539
5.540
5.541 --
5.542 --- TOC entry 1912 (class 2606 OID 35137)
5.543 --- Dependencies: 1606 1606 1606
5.544 +-- TOC entry 1913 (class 2606 OID 35137)
5.545 +-- Dependencies: 1607 1607 1607
5.546 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
5.547 --
5.548
5.549 @@ -614,8 +619,8 @@
5.550
5.551
5.552 --
5.553 --- TOC entry 1919 (class 1259 OID 35291)
5.554 --- Dependencies: 1613
5.555 +-- TOC entry 1920 (class 1259 OID 35291)
5.556 +-- Dependencies: 1614
5.557 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
5.558 --
5.559
5.560 @@ -623,8 +628,8 @@
5.561
5.562
5.563 --
5.564 --- TOC entry 1922 (class 1259 OID 35309)
5.565 --- Dependencies: 1613
5.566 +-- TOC entry 1923 (class 1259 OID 35309)
5.567 +-- Dependencies: 1614
5.568 -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
5.569 --
5.570
5.571 @@ -632,8 +637,8 @@
5.572
5.573
5.574 --
5.575 --- TOC entry 1938 (class 2620 OID 35125)
5.576 --- Dependencies: 1604 65
5.577 +-- TOC entry 1942 (class 2620 OID 35125)
5.578 +-- Dependencies: 65 1605
5.579 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
5.580 --
5.581
5.582 @@ -644,8 +649,8 @@
5.583
5.584
5.585 --
5.586 --- TOC entry 1932 (class 2606 OID 35191)
5.587 --- Dependencies: 1903 1608 1602
5.588 +-- TOC entry 1936 (class 2606 OID 35191)
5.589 +-- Dependencies: 1904 1603 1609
5.590 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.591 --
5.592
5.593 @@ -654,8 +659,8 @@
5.594
5.595
5.596 --
5.597 --- TOC entry 1933 (class 2606 OID 35285)
5.598 --- Dependencies: 1903 1602 1613
5.599 +-- TOC entry 1937 (class 2606 OID 35285)
5.600 +-- Dependencies: 1614 1603 1904
5.601 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.602 --
5.603
5.604 @@ -664,8 +669,8 @@
5.605
5.606
5.607 --
5.608 --- TOC entry 1934 (class 2606 OID 35386)
5.609 --- Dependencies: 1615 1602 1903
5.610 +-- TOC entry 1938 (class 2606 OID 35386)
5.611 +-- Dependencies: 1904 1603 1616
5.612 -- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.613 --
5.614
5.615 @@ -674,8 +679,8 @@
5.616
5.617
5.618 --
5.619 --- TOC entry 1935 (class 2606 OID 35391)
5.620 --- Dependencies: 1907 1604 1615
5.621 +-- TOC entry 1939 (class 2606 OID 35391)
5.622 +-- Dependencies: 1616 1908 1605
5.623 -- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.624 --
5.625
5.626 @@ -684,8 +689,8 @@
5.627
5.628
5.629 --
5.630 --- TOC entry 1937 (class 2606 OID 35414)
5.631 --- Dependencies: 1618 1925 1617
5.632 +-- TOC entry 1941 (class 2606 OID 35414)
5.633 +-- Dependencies: 1926 1617 1618
5.634 -- Name: podnik_kategorie_kategorie_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.635 --
5.636
5.637 @@ -694,8 +699,8 @@
5.638
5.639
5.640 --
5.641 --- TOC entry 1936 (class 2606 OID 35409)
5.642 --- Dependencies: 1903 1602 1618
5.643 +-- TOC entry 1940 (class 2606 OID 35409)
5.644 +-- Dependencies: 1603 1618 1904
5.645 -- Name: podnik_kategorie_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.646 --
5.647
5.648 @@ -704,8 +709,18 @@
5.649
5.650
5.651 --
5.652 --- TOC entry 1929 (class 2606 OID 35178)
5.653 --- Dependencies: 1602 1604 1907
5.654 +-- TOC entry 1933 (class 2606 OID 35458)
5.655 +-- Dependencies: 1603 1619 1930
5.656 +-- Name: podnik_kurackost_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.657 +--
5.658 +
5.659 +ALTER TABLE ONLY podnik
5.660 + ADD CONSTRAINT podnik_kurackost_fk FOREIGN KEY (kurackost) REFERENCES kurackost(id);
5.661 +
5.662 +
5.663 +--
5.664 +-- TOC entry 1932 (class 2606 OID 35178)
5.665 +-- Dependencies: 1603 1605 1908
5.666 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.667 --
5.668
5.669 @@ -714,8 +729,8 @@
5.670
5.671
5.672 --
5.673 --- TOC entry 1930 (class 2606 OID 35138)
5.674 --- Dependencies: 1909 1606 1605
5.675 +-- TOC entry 1934 (class 2606 OID 35138)
5.676 +-- Dependencies: 1607 1910 1606
5.677 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.678 --
5.679
5.680 @@ -724,8 +739,8 @@
5.681
5.682
5.683 --
5.684 --- TOC entry 1931 (class 2606 OID 35143)
5.685 --- Dependencies: 1907 1604 1606
5.686 +-- TOC entry 1935 (class 2606 OID 35143)
5.687 +-- Dependencies: 1605 1607 1908
5.688 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
5.689 --
5.690
5.691 @@ -734,7 +749,7 @@
5.692
5.693
5.694 --
5.695 --- TOC entry 1941 (class 0 OID 0)
5.696 +-- TOC entry 1945 (class 0 OID 0)
5.697 -- Dependencies: 10
5.698 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
5.699 --
5.700 @@ -746,8 +761,8 @@
5.701
5.702
5.703 --
5.704 --- TOC entry 1944 (class 0 OID 0)
5.705 --- Dependencies: 1610
5.706 +-- TOC entry 1948 (class 0 OID 0)
5.707 +-- Dependencies: 1611
5.708 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.709 --
5.710
5.711 @@ -758,8 +773,8 @@
5.712
5.713
5.714 --
5.715 --- TOC entry 1946 (class 0 OID 0)
5.716 --- Dependencies: 1609
5.717 +-- TOC entry 1950 (class 0 OID 0)
5.718 +-- Dependencies: 1610
5.719 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
5.720 --
5.721
5.722 @@ -770,8 +785,8 @@
5.723
5.724
5.725 --
5.726 --- TOC entry 1947 (class 0 OID 0)
5.727 --- Dependencies: 1607
5.728 +-- TOC entry 1951 (class 0 OID 0)
5.729 +-- Dependencies: 1608
5.730 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.731 --
5.732
5.733 @@ -782,8 +797,8 @@
5.734
5.735
5.736 --
5.737 --- TOC entry 1950 (class 0 OID 0)
5.738 --- Dependencies: 1608
5.739 +-- TOC entry 1954 (class 0 OID 0)
5.740 +-- Dependencies: 1609
5.741 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
5.742 --
5.743
5.744 @@ -794,8 +809,8 @@
5.745
5.746
5.747 --
5.748 --- TOC entry 1951 (class 0 OID 0)
5.749 --- Dependencies: 1612
5.750 +-- TOC entry 1955 (class 0 OID 0)
5.751 +-- Dependencies: 1613
5.752 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.753 --
5.754
5.755 @@ -806,8 +821,8 @@
5.756
5.757
5.758 --
5.759 --- TOC entry 1954 (class 0 OID 0)
5.760 --- Dependencies: 1613
5.761 +-- TOC entry 1958 (class 0 OID 0)
5.762 +-- Dependencies: 1614
5.763 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
5.764 --
5.765
5.766 @@ -818,19 +833,7 @@
5.767
5.768
5.769 --
5.770 --- TOC entry 1955 (class 0 OID 0)
5.771 --- Dependencies: 1616
5.772 --- Name: kategorie_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.773 ---
5.774 -
5.775 -REVOKE ALL ON SEQUENCE kategorie_seq FROM PUBLIC;
5.776 -REVOKE ALL ON SEQUENCE kategorie_seq FROM nekurak;
5.777 -GRANT ALL ON SEQUENCE kategorie_seq TO nekurak;
5.778 -GRANT USAGE ON SEQUENCE kategorie_seq TO nekurak_web;
5.779 -
5.780 -
5.781 ---
5.782 --- TOC entry 1958 (class 0 OID 0)
5.783 +-- TOC entry 1961 (class 0 OID 0)
5.784 -- Dependencies: 1617
5.785 -- Name: kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
5.786 --
5.787 @@ -838,12 +841,12 @@
5.788 REVOKE ALL ON TABLE kategorie FROM PUBLIC;
5.789 REVOKE ALL ON TABLE kategorie FROM nekurak;
5.790 GRANT ALL ON TABLE kategorie TO nekurak;
5.791 -GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE kategorie TO nekurak_web;
5.792 +GRANT SELECT ON TABLE kategorie TO nekurak_web;
5.793
5.794
5.795 --
5.796 --- TOC entry 1959 (class 0 OID 0)
5.797 --- Dependencies: 1614
5.798 +-- TOC entry 1962 (class 0 OID 0)
5.799 +-- Dependencies: 1615
5.800 -- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.801 --
5.802
5.803 @@ -854,8 +857,8 @@
5.804
5.805
5.806 --
5.807 --- TOC entry 1963 (class 0 OID 0)
5.808 --- Dependencies: 1615
5.809 +-- TOC entry 1966 (class 0 OID 0)
5.810 +-- Dependencies: 1616
5.811 -- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
5.812 --
5.813
5.814 @@ -866,8 +869,20 @@
5.815
5.816
5.817 --
5.818 --- TOC entry 1964 (class 0 OID 0)
5.819 --- Dependencies: 1601
5.820 +-- TOC entry 1968 (class 0 OID 0)
5.821 +-- Dependencies: 1619
5.822 +-- Name: kurackost; Type: ACL; Schema: nekurak; Owner: nekurak
5.823 +--
5.824 +
5.825 +REVOKE ALL ON TABLE kurackost FROM PUBLIC;
5.826 +REVOKE ALL ON TABLE kurackost FROM nekurak;
5.827 +GRANT ALL ON TABLE kurackost TO nekurak;
5.828 +GRANT SELECT ON TABLE kurackost TO nekurak_web;
5.829 +
5.830 +
5.831 +--
5.832 +-- TOC entry 1969 (class 0 OID 0)
5.833 +-- Dependencies: 1602
5.834 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.835 --
5.836
5.837 @@ -878,8 +893,8 @@
5.838
5.839
5.840 --
5.841 --- TOC entry 1967 (class 0 OID 0)
5.842 --- Dependencies: 1602
5.843 +-- TOC entry 1971 (class 0 OID 0)
5.844 +-- Dependencies: 1603
5.845 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
5.846 --
5.847
5.848 @@ -890,7 +905,7 @@
5.849
5.850
5.851 --
5.852 --- TOC entry 1968 (class 0 OID 0)
5.853 +-- TOC entry 1972 (class 0 OID 0)
5.854 -- Dependencies: 1618
5.855 -- Name: podnik_kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
5.856 --
5.857 @@ -902,8 +917,8 @@
5.858
5.859
5.860 --
5.861 --- TOC entry 1970 (class 0 OID 0)
5.862 --- Dependencies: 1605
5.863 +-- TOC entry 1974 (class 0 OID 0)
5.864 +-- Dependencies: 1606
5.865 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
5.866 --
5.867
5.868 @@ -914,8 +929,8 @@
5.869
5.870
5.871 --
5.872 --- TOC entry 1971 (class 0 OID 0)
5.873 --- Dependencies: 1603
5.874 +-- TOC entry 1975 (class 0 OID 0)
5.875 +-- Dependencies: 1604
5.876 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
5.877 --
5.878
5.879 @@ -926,8 +941,8 @@
5.880
5.881
5.882 --
5.883 --- TOC entry 1973 (class 0 OID 0)
5.884 --- Dependencies: 1604
5.885 +-- TOC entry 1977 (class 0 OID 0)
5.886 +-- Dependencies: 1605
5.887 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
5.888 --
5.889
5.890 @@ -938,8 +953,8 @@
5.891
5.892
5.893 --
5.894 --- TOC entry 1975 (class 0 OID 0)
5.895 --- Dependencies: 1606
5.896 +-- TOC entry 1979 (class 0 OID 0)
5.897 +-- Dependencies: 1607
5.898 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
5.899 --
5.900
5.901 @@ -949,7 +964,7 @@
5.902 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
5.903
5.904
5.905 --- Completed on 2011-01-11 15:26:23 CET
5.906 +-- Completed on 2011-01-15 14:24:31 CET
5.907
5.908 --
5.909 -- PostgreSQL database dump complete