1.1 --- a/html/index.html Sun Aug 15 22:47:33 2010 +0200
1.2 +++ b/html/index.html Sat Jan 08 20:18:27 2011 +0100
1.3 @@ -58,8 +58,18 @@
1.4
1.5 </div>
1.6
1.7 - <div class="podnik"><h2><a href="?akce=detail&podnik=143">111</a></h2><p></p><p>Adresa:<br /> 
1.8 - 0<br /></p></div><div class="podnik"><h2><a href="?akce=detail&podnik=141">x</a></h2><p>x</p><p>Adresa:<br />x 
1.9 + <div class="podnik">
1.10 + <h2><a href="?akce=detail&podnik=143">111</a></h2>
1.11 + <p></p>
1.12 + <p>Adresa:<br /> 0<br /></p>
1.13 +
1.14 + <ul class="stitky">
1.15 + <li><a href="#" title="mají tam pivo">hospoda</a></li>
1.16 + <li><a href="#" title="mají tam kafe">kavárna</a></li>
1.17 + </ul>
1.18 + </div>
1.19 +
1.20 + <div class="podnik"><h2><a href="?akce=detail&podnik=141">x</a></h2><p>x</p><p>Adresa:<br />x 
1.21 1<br />x</p><p><a href="x">www stránka</a></p></div><div class="podnik"><h2><a href="?akce=detail&podnik=140">fsda</a></h2><p>fsd</p><p>Adresa:<br />fsd 
1.22 1<br />fsad</p><p><a href="fsd">www stránka</a></p></div><div class="podnik"><h2><a href="?akce=detail&podnik=135">Test</a></h2><p>Pokus</p><p>Adresa:<br />Ulice 
1.23 123<br />Mesto</p><p><a href="google.com">www stránka</a></p></div>
2.1 --- a/html/styl.css Sun Aug 15 22:47:33 2010 +0200
2.2 +++ b/html/styl.css Sat Jan 08 20:18:27 2011 +0100
2.3 @@ -1,3 +1,91 @@
2.4 +ul.stitky {
2.5 + margin: 0;
2.6 + padding: 0 0 32px 0;
2.7 +
2.8 + list-style: none;
2.9 +}
2.10 +
2.11 +ul.stitky li, ul.stitky a {
2.12 + float: left;
2.13 + height: 20px;
2.14 + line-height: 20px;
2.15 + position: relative;
2.16 + font-size: 11px;
2.17 +}
2.18 +
2.19 +ul.stitky a {
2.20 + margin-left: 20px;
2.21 + padding: 0 10px 0 12px;
2.22 + background: silver;
2.23 + color: #666;
2.24 + text-decoration: none;
2.25 + -moz-border-radius-bottomright: 4px;
2.26 + -webkit-border-bottom-right-radius: 4px;
2.27 + border-bottom-right-radius: 4px;
2.28 + -moz-border-radius-topright: 4px;
2.29 + -webkit-border-top-right-radius: 4px;
2.30 + border-top-right-radius: 4px;
2.31 +}
2.32 +
2.33 +ul.stitky a:before {
2.34 + content: "";
2.35 + float: left;
2.36 + position: absolute;
2.37 + top: 0;
2.38 + left: -10px;
2.39 + width: 0;
2.40 + height: 0;
2.41 + border-color: transparent silver transparent transparent;
2.42 + border-style: solid;
2.43 + border-width: 10px 10px 10px 0;
2.44 +}
2.45 +
2.46 +ul.stitky a:after {
2.47 + content: "";
2.48 + position: absolute;
2.49 + top: 9px;
2.50 + left: 0;
2.51 + float: left;
2.52 + width: 4px;
2.53 + height: 4px;
2.54 + -moz-border-radius: 2px;
2.55 + -webkit-border-radius: 2px;
2.56 + border-radius: 2px;
2.57 + background: #fff;
2.58 + -moz-box-shadow: -1px -1px 2px grey;
2.59 + -webkit-box-shadow: -1px -1px 2px grey;
2.60 + box-shadow: -1px -1px 2px #004977;
2.61 +}
2.62 +
2.63 +ul.stitky a:hover{
2.64 + background: #555;
2.65 + color: #ccc;
2.66 +}
2.67 +
2.68 +ul.stitky a:hover:before{
2.69 + border-color:transparent #555 transparent transparent;
2.70 +}
2.71 +
2.72 +
2.73 +
2.74 +
2.75 +
2.76 +
2.77 +
2.78 +
2.79 +
2.80 +
2.81 +
2.82 +
2.83 +
2.84 +
2.85 +
2.86 +
2.87 +
2.88 +
2.89 +
2.90 +
2.91 +
2.92 .chybovaHlaska {
2.93 background-image: url('grafika/dialog-error.png');
2.94 background-repeat: no-repeat;
3.1 --- a/java/nekurak.net-ear/nbproject/project.properties Sun Aug 15 22:47:33 2010 +0200
3.2 +++ b/java/nekurak.net-ear/nbproject/project.properties Sat Jan 08 20:18:27 2011 +0100
3.3 @@ -12,7 +12,7 @@
3.4 j2ee.appclient.mainclass.args=${j2ee.appclient.tool.args}
3.5 j2ee.deploy.on.save=false
3.6 j2ee.platform=1.6
3.7 -j2ee.platform.classpath=
3.8 +j2ee.platform.classpath=${j2ee.server.home}/modules/javax.servlet.jar:${j2ee.server.home}/modules/jstl-impl.jar:${j2ee.server.home}/modules/javax.ejb.jar:${j2ee.server.home}/modules/javax.enterprise.deploy.jar:${j2ee.server.home}/modules/javax.security.jacc.jar:${j2ee.server.home}/modules/bean-validator.jar:${j2ee.server.home}/modules/javax.transaction.jar:${j2ee.server.home}/modules/jsr311-api.jar:${j2ee.server.home}/modules/jsf-api.jar:${j2ee.server.home}/modules/javax.security.auth.message.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jar:${j2ee.server.home}/modules/endorsed/javax.annotation.jar:${j2ee.server.home}/modules/javax.management.j2ee.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api-osgi.jar:${j2ee.server.home}/modules/javax.jms.jar:${j2ee.server.home}/modules/javax.persistence.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl.jar:${j2ee.server.home}/modules/javax.resource.jar:${j2ee.server.home}/modules/weld-osgi-bundle.jar:${j2ee.server.home}/modules/jsf-impl.jar:${j2ee.server.home}/modules/mail.jar
3.9 j2ee.platform.embeddableejb.classpath=${j2ee.server.home}/lib/embedded/glassfish-embedded-static-shell.jar
3.10 j2ee.platform.wscompile.classpath=${j2ee.server.home}/modules/webservices-osgi.jar
3.11 j2ee.platform.wsgen.classpath=${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api-osgi.jar:${j2ee.server.home}/modules/javax.ejb.jar
4.1 --- a/java/nekurak.net-ejb/nbproject/project.properties Sun Aug 15 22:47:33 2010 +0200
4.2 +++ b/java/nekurak.net-ejb/nbproject/project.properties Sat Jan 08 20:18:27 2011 +0100
4.3 @@ -24,7 +24,7 @@
4.4 includes=**
4.5 j2ee.deploy.on.save=false
4.6 j2ee.platform=1.6
4.7 -j2ee.platform.classpath=
4.8 +j2ee.platform.classpath=${j2ee.server.home}/modules/javax.servlet.jar:${j2ee.server.home}/modules/jstl-impl.jar:${j2ee.server.home}/modules/javax.ejb.jar:${j2ee.server.home}/modules/javax.enterprise.deploy.jar:${j2ee.server.home}/modules/javax.security.jacc.jar:${j2ee.server.home}/modules/bean-validator.jar:${j2ee.server.home}/modules/javax.transaction.jar:${j2ee.server.home}/modules/jsr311-api.jar:${j2ee.server.home}/modules/jsf-api.jar:${j2ee.server.home}/modules/javax.security.auth.message.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jar:${j2ee.server.home}/modules/endorsed/javax.annotation.jar:${j2ee.server.home}/modules/javax.management.j2ee.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api-osgi.jar:${j2ee.server.home}/modules/javax.jms.jar:${j2ee.server.home}/modules/javax.persistence.jar:${j2ee.server.home}/modules/javax.servlet.jsp.jstl.jar:${j2ee.server.home}/modules/javax.resource.jar:${j2ee.server.home}/modules/weld-osgi-bundle.jar:${j2ee.server.home}/modules/jsf-impl.jar:${j2ee.server.home}/modules/mail.jar
4.9 j2ee.platform.embeddableejb.classpath=${j2ee.server.home}/lib/embedded/glassfish-embedded-static-shell.jar
4.10 j2ee.platform.wscompile.classpath=${j2ee.server.home}/modules/webservices-osgi.jar
4.11 j2ee.platform.wsgen.classpath=${j2ee.server.home}/modules/webservices-osgi.jar:${j2ee.server.home}/modules/endorsed/webservices-api-osgi.jar:${j2ee.server.home}/modules/jaxb-osgi.jar:${j2ee.server.home}/modules/endorsed/jaxb-api-osgi.jar:${j2ee.server.home}/modules/javax.ejb.jar
5.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
5.2 +++ b/java/nekurak.net-ejb/src/conf/Kategorie.hbm.xml Sat Jan 08 20:18:27 2011 +0100
5.3 @@ -0,0 +1,14 @@
5.4 +<?xml version="1.0"?>
5.5 +<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
5.6 +"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
5.7 +<hibernate-mapping>
5.8 + <class name="cz.frantovo.nekurak.dto.Kategorie" table="kategorie">
5.9 + <id name="id" column="id" type="integer">
5.10 + <generator class="sequence">
5.11 + <param name="sequence">kategorie_seq</param>
5.12 + </generator>
5.13 + </id>
5.14 + <property name="nazev" column="nazev"/>
5.15 + <property name="popis" column="popis"/>
5.16 + </class>
5.17 +</hibernate-mapping>
5.18 \ No newline at end of file
6.1 --- a/java/nekurak.net-ejb/src/conf/Podnik.hbm.xml Sun Aug 15 22:47:33 2010 +0200
6.2 +++ b/java/nekurak.net-ejb/src/conf/Podnik.hbm.xml Sat Jan 08 20:18:27 2011 +0100
6.3 @@ -25,6 +25,10 @@
6.4 <key column="podnik" foreign-key="id"/>
6.5 <one-to-many class="cz.frantovo.nekurak.dto.Komentar"/>
6.6 </set>
6.7 + <set name="kategorie" table="podnik_kategorie" lazy="false">
6.8 + <key column="podnik"/>
6.9 + <many-to-many class="cz.frantovo.nekurak.dto.Kategorie" column="kategorie" order-by="nazev"/>
6.10 + </set>
6.11 <property name="sirka" column="sirka"/>
6.12 <property name="delka" column="delka"/>
6.13
7.1 --- a/java/nekurak.net-lib/nbproject/build-impl.xml Sun Aug 15 22:47:33 2010 +0200
7.2 +++ b/java/nekurak.net-lib/nbproject/build-impl.xml Sat Jan 08 20:18:27 2011 +0100
7.3 @@ -291,15 +291,18 @@
7.4 <attribute default="${build.classes.dir}" name="destdir"/>
7.5 <sequential>
7.6 <fail unless="javac.includes">Must set javac.includes</fail>
7.7 - <pathconvert pathsep="," property="javac.includes.binary">
7.8 + <pathconvert pathsep="${line.separator}" property="javac.includes.binary">
7.9 <path>
7.10 <filelist dir="@{destdir}" files="${javac.includes}"/>
7.11 </path>
7.12 <globmapper from="*.java" to="*.class"/>
7.13 </pathconvert>
7.14 + <tempfile deleteonexit="true" property="javac.includesfile.binary"/>
7.15 + <echo file="${javac.includesfile.binary}" message="${javac.includes.binary}"/>
7.16 <delete>
7.17 - <files includes="${javac.includes.binary}"/>
7.18 + <files includesfile="${javac.includesfile.binary}"/>
7.19 </delete>
7.20 + <delete file="${javac.includesfile.binary}"/>
7.21 </sequential>
7.22 </macrodef>
7.23 </target>
8.1 --- a/java/nekurak.net-lib/nbproject/genfiles.properties Sun Aug 15 22:47:33 2010 +0200
8.2 +++ b/java/nekurak.net-lib/nbproject/genfiles.properties Sat Jan 08 20:18:27 2011 +0100
8.3 @@ -4,5 +4,5 @@
8.4 # This file is used by a NetBeans-based IDE to track changes in generated files such as build-impl.xml.
8.5 # Do not edit this file. You may delete it but then the IDE will never regenerate such files for you.
8.6 nbproject/build-impl.xml.data.CRC32=11ce77af
8.7 -nbproject/build-impl.xml.script.CRC32=40960ef1
8.8 -nbproject/build-impl.xml.stylesheet.CRC32=f33e10ff@1.38.2.45
8.9 +nbproject/build-impl.xml.script.CRC32=827b6ce9
8.10 +nbproject/build-impl.xml.stylesheet.CRC32=229523de@1.38.3.45
9.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
9.2 +++ b/java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Kategorie.java Sat Jan 08 20:18:27 2011 +0100
9.3 @@ -0,0 +1,38 @@
9.4 +package cz.frantovo.nekurak.dto;
9.5 +
9.6 +/**
9.7 + * Kategorie, do které podnik patří.
9.8 + * Např. hospoda, bar, restaurace nebo cukrárna.
9.9 + * Podnik může patřit do více kategorií (měl by patřit alespoň do jedné).
9.10 + * @author fiki
9.11 + */
9.12 +public class Kategorie {
9.13 +
9.14 + private int id;
9.15 + private String nazev;
9.16 + private String popis;
9.17 +
9.18 + public int getId() {
9.19 + return id;
9.20 + }
9.21 +
9.22 + public void setId(int id) {
9.23 + this.id = id;
9.24 + }
9.25 +
9.26 + public String getNazev() {
9.27 + return nazev;
9.28 + }
9.29 +
9.30 + public void setNazev(String název) {
9.31 + this.nazev = název;
9.32 + }
9.33 +
9.34 + public String getPopis() {
9.35 + return popis;
9.36 + }
9.37 +
9.38 + public void setPopis(String popis) {
9.39 + this.popis = popis;
9.40 + }
9.41 +}
10.1 --- a/java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Podnik.java Sun Aug 15 22:47:33 2010 +0200
10.2 +++ b/java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Podnik.java Sat Jan 08 20:18:27 2011 +0100
10.3 @@ -24,6 +24,7 @@
10.4 private String spravce;
10.5 private List<Fotka> fotky = new ArrayList<Fotka>();
10.6 private Set<Komentar> komentare = new HashSet<Komentar>();
10.7 + private Set<Kategorie> kategorie = new HashSet<Kategorie>();
10.8 private Double sirka;
10.9 private Double delka;
10.10
10.11 @@ -138,4 +139,12 @@
10.12 public void setKomentare(Set<Komentar> komentare) {
10.13 this.komentare = komentare;
10.14 }
10.15 +
10.16 + public Set<Kategorie> getKategorie() {
10.17 + return kategorie;
10.18 + }
10.19 +
10.20 + public void setKategorie(Set<Kategorie> kategorie) {
10.21 + this.kategorie = kategorie;
10.22 + }
10.23 }
11.1 --- a/java/nekurak.net-web/src/java/cz/frantovo/nekurak/web/FunkceEL.java Sun Aug 15 22:47:33 2010 +0200
11.2 +++ b/java/nekurak.net-web/src/java/cz/frantovo/nekurak/web/FunkceEL.java Sat Jan 08 20:18:27 2011 +0100
11.3 @@ -1,6 +1,5 @@
11.4 package cz.frantovo.nekurak.web;
11.5
11.6 -import cz.frantovo.nekurak.dto.Podnik;
11.7 import cz.frantovo.nekurak.servlet.Fotky;
11.8 import cz.frantovo.nekurak.util.Komentare;
11.9 import cz.frantovo.nekurak.vyjimky.KomentarovaVyjimka;
11.10 @@ -19,10 +18,6 @@
11.11 return SERVLET + "/" + prostredek + "/" + id + "." + Fotky.PRIPONA;
11.12 }
11.13
11.14 - public static boolean maFotky(Podnik p) {
11.15 - return !p.getFotky().isEmpty();
11.16 - }
11.17 -
11.18 /**
11.19 * @param komentar komentář včetně kořenové značky, XML jako text
11.20 * @return true, pokud vyhovuje XML schématu
12.1 --- a/java/nekurak.net-web/web/WEB-INF/casti/uvod.jsp Sun Aug 15 22:47:33 2010 +0200
12.2 +++ b/java/nekurak.net-web/web/WEB-INF/casti/uvod.jsp Sat Jan 08 20:18:27 2011 +0100
12.3 @@ -4,6 +4,7 @@
12.4 xmlns:fmt="http://java.sun.com/jsp/jstl/fmt"
12.5 xmlns:fn="http://java.sun.com/jsp/jstl/functions"
12.6 xmlns:nk="urn:jsptagdir:/WEB-INF/tags/nekurak"
12.7 + xmlns:nkfn="/WEB-INF/nekurakFunkce"
12.8 version="2.0">
12.9
12.10 <jsp:useBean id="uvod" class="cz.frantovo.nekurak.web.Uvod" scope="request"/>
12.11 @@ -31,6 +32,19 @@
12.12 <c:if test="${p.url != null}">
12.13 <p><a href="${fn:escapeXml(p.url)}"><fmt:message key="uvod.www"/></a></p>
12.14 </c:if>
12.15 +
12.16 + <!-- Kategorie podniku (hospoda, vinárna atd.) -->
12.17 + <c:if test="${!empty p.kategorie}">
12.18 + <ul class="stitky">
12.19 + <c:forEach var="k" items="${p.kategorie}">
12.20 + <li>
12.21 + <a href="?akce=kategorie&amp;id=${k.id}" title="${fn:escapeXml(k.popis)}">
12.22 + <c:out value="${k.nazev}"/>
12.23 + </a>
12.24 + </li>
12.25 + </c:forEach>
12.26 + </ul>
12.27 + </c:if>
12.28 </div>
12.29
12.30 <!-- Hlasování a graf -->
13.1 --- a/java/nekurak.net-web/web/WEB-INF/nekurakFunkce.tld Sun Aug 15 22:47:33 2010 +0200
13.2 +++ b/java/nekurak.net-web/web/WEB-INF/nekurakFunkce.tld Sat Jan 08 20:18:27 2011 +0100
13.3 @@ -11,12 +11,6 @@
13.4 <function-signature>java.lang.String fotka(int, boolean)</function-signature>
13.5 </function>
13.6 <function>
13.7 - <name>maFotky</name>
13.8 - <description>Zda podnik má přiřazené nějaké fotky</description>
13.9 - <function-class>cz.frantovo.nekurak.web.FunkceEL</function-class>
13.10 - <function-signature>boolean maFotky(cz.frantovo.nekurak.dto.Podnik)</function-signature>
13.11 - </function>
13.12 - <function>
13.13 <name>zkontrolujKomentar</name>
13.14 <description>Provede validaci komentáře oproti XML schématu</description>
13.15 <function-class>cz.frantovo.nekurak.web.FunkceEL</function-class>
14.1 --- a/java/nekurak.net-web/web/WEB-INF/tags/nekurak/fotkyPodniku.tag Sun Aug 15 22:47:33 2010 +0200
14.2 +++ b/java/nekurak.net-web/web/WEB-INF/tags/nekurak/fotkyPodniku.tag Sat Jan 08 20:18:27 2011 +0100
14.3 @@ -19,7 +19,7 @@
14.4 <p><img src="grafika/fotkaPodnikuZadne.png" alt="žádné další fotografie"/></p>
14.5 </div>
14.6
14.7 - <c:if test="${nkfn:maFotky(podnik)}">
14.8 + <c:if test="${!empty podnik.fotky}">
14.9 <script type="text/javascript">
14.10 $(document).ready(function(){
14.11 fotkyPodniku.aktivuj(${podnik.id});
15.1 --- a/java/nekurak.net-web/web/styl.css Sun Aug 15 22:47:33 2010 +0200
15.2 +++ b/java/nekurak.net-web/web/styl.css Sat Jan 08 20:18:27 2011 +0100
15.3 @@ -283,3 +283,71 @@
15.4 margin-top: 8px;
15.5 margin-bottom: 8px;
15.6 }
15.7 +
15.8 +ul.stitky {
15.9 + margin: 0;
15.10 + padding: 0 0 32px 0;
15.11 +
15.12 + list-style: none;
15.13 +}
15.14 +
15.15 +ul.stitky li, ul.stitky a {
15.16 + float: left;
15.17 + height: 20px;
15.18 + line-height: 20px;
15.19 + position: relative;
15.20 + font-size: 11px;
15.21 +}
15.22 +
15.23 +ul.stitky a {
15.24 + margin-left: 20px;
15.25 + padding: 0 10px 0 12px;
15.26 + background: silver;
15.27 + color: #666;
15.28 + text-decoration: none;
15.29 + -moz-border-radius-bottomright: 4px;
15.30 + -webkit-border-bottom-right-radius: 4px;
15.31 + border-bottom-right-radius: 4px;
15.32 + -moz-border-radius-topright: 4px;
15.33 + -webkit-border-top-right-radius: 4px;
15.34 + border-top-right-radius: 4px;
15.35 +}
15.36 +
15.37 +ul.stitky a:before {
15.38 + content: "";
15.39 + float: left;
15.40 + position: absolute;
15.41 + top: 0;
15.42 + left: -10px;
15.43 + width: 0;
15.44 + height: 0;
15.45 + border-color: transparent silver transparent transparent;
15.46 + border-style: solid;
15.47 + border-width: 10px 10px 10px 0;
15.48 +}
15.49 +
15.50 +ul.stitky a:after {
15.51 + content: "";
15.52 + position: absolute;
15.53 + top: 9px;
15.54 + left: 0;
15.55 + float: left;
15.56 + width: 4px;
15.57 + height: 4px;
15.58 + -moz-border-radius: 2px;
15.59 + -webkit-border-radius: 2px;
15.60 + border-radius: 2px;
15.61 + background: #fff;
15.62 + -moz-box-shadow: -1px -1px 2px grey;
15.63 + -webkit-box-shadow: -1px -1px 2px grey;
15.64 + box-shadow: -1px -1px 2px #004977;
15.65 +}
15.66 +
15.67 +ul.stitky a:hover{
15.68 + background: #555;
15.69 + color: #ccc;
15.70 +}
15.71 +
15.72 +ul.stitky a:hover:before{
15.73 + border-color:transparent #555 transparent transparent;
15.74 +}
15.75 \ No newline at end of file
16.1 --- a/sql/schéma.sql Sun Aug 15 22:47:33 2010 +0200
16.2 +++ b/sql/schéma.sql Sat Jan 08 20:18:27 2011 +0100
16.3 @@ -2,7 +2,7 @@
16.4 -- PostgreSQL database dump
16.5 --
16.6
16.7 --- Started on 2010-06-09 15:52:26 CEST
16.8 +-- Started on 2011-01-08 19:54:48 CET
16.9
16.10 SET statement_timeout = 0;
16.11 SET client_encoding = 'UTF8';
16.12 @@ -36,7 +36,7 @@
16.13 ALTER DOMAIN nekurak.email OWNER TO nekurak;
16.14
16.15 --
16.16 --- TOC entry 1926 (class 0 OID 0)
16.17 +-- TOC entry 1941 (class 0 OID 0)
16.18 -- Dependencies: 366
16.19 -- Name: DOMAIN email; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.20 --
16.21 @@ -46,7 +46,7 @@
16.22
16.23 --
16.24 -- TOC entry 65 (class 1255 OID 35124)
16.25 --- Dependencies: 10 406
16.26 +-- Dependencies: 411 10
16.27 -- Name: bezny_uzivatel(); Type: FUNCTION; Schema: nekurak; Owner: nekurak
16.28 --
16.29
16.30 @@ -64,7 +64,7 @@
16.31 ALTER FUNCTION nekurak.bezny_uzivatel() OWNER TO nekurak;
16.32
16.33 --
16.34 --- TOC entry 1927 (class 0 OID 0)
16.35 +-- TOC entry 1942 (class 0 OID 0)
16.36 -- Dependencies: 65
16.37 -- Name: FUNCTION bezny_uzivatel(); Type: COMMENT; Schema: nekurak; Owner: nekurak
16.38 --
16.39 @@ -73,7 +73,7 @@
16.40
16.41
16.42 --
16.43 --- TOC entry 1605 (class 1259 OID 35223)
16.44 +-- TOC entry 1610 (class 1259 OID 35223)
16.45 -- Dependencies: 10
16.46 -- Name: clanek_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.47 --
16.48 @@ -92,8 +92,8 @@
16.49 SET default_with_oids = false;
16.50
16.51 --
16.52 --- TOC entry 1604 (class 1259 OID 35205)
16.53 --- Dependencies: 1888 10
16.54 +-- TOC entry 1609 (class 1259 OID 35205)
16.55 +-- Dependencies: 1896 10
16.56 -- Name: clanek; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.57 --
16.58
16.59 @@ -107,16 +107,16 @@
16.60 ALTER TABLE nekurak.clanek OWNER TO nekurak;
16.61
16.62 --
16.63 --- TOC entry 1929 (class 0 OID 0)
16.64 --- Dependencies: 1604
16.65 +-- TOC entry 1944 (class 0 OID 0)
16.66 +-- Dependencies: 1609
16.67 -- Name: TABLE clanek; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.68 --
16.69
16.70 -COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah, (XúHTML.';
16.71 +COMMENT ON TABLE clanek IS 'Článek potažmo stránka – nějaký textový obsah (XHTML).';
16.72
16.73
16.74 --
16.75 --- TOC entry 1602 (class 1259 OID 35183)
16.76 +-- TOC entry 1607 (class 1259 OID 35183)
16.77 -- Dependencies: 10
16.78 -- Name: fotka_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.79 --
16.80 @@ -132,8 +132,8 @@
16.81 ALTER TABLE nekurak.fotka_seq OWNER TO nekurak;
16.82
16.83 --
16.84 --- TOC entry 1603 (class 1259 OID 35185)
16.85 --- Dependencies: 1886 1887 10
16.86 +-- TOC entry 1608 (class 1259 OID 35185)
16.87 +-- Dependencies: 1894 1895 10
16.88 -- Name: fotka; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.89 --
16.90
16.91 @@ -148,8 +148,8 @@
16.92 ALTER TABLE nekurak.fotka OWNER TO nekurak;
16.93
16.94 --
16.95 --- TOC entry 1932 (class 0 OID 0)
16.96 --- Dependencies: 1603
16.97 +-- TOC entry 1947 (class 0 OID 0)
16.98 +-- Dependencies: 1608
16.99 -- Name: TABLE fotka; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.100 --
16.101
16.102 @@ -157,8 +157,8 @@
16.103
16.104
16.105 --
16.106 --- TOC entry 1933 (class 0 OID 0)
16.107 --- Dependencies: 1603
16.108 +-- TOC entry 1948 (class 0 OID 0)
16.109 +-- Dependencies: 1608
16.110 -- Name: COLUMN fotka.poradi; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.111 --
16.112
16.113 @@ -166,7 +166,7 @@
16.114
16.115
16.116 --
16.117 --- TOC entry 1607 (class 1259 OID 35250)
16.118 +-- TOC entry 1612 (class 1259 OID 35250)
16.119 -- Dependencies: 10
16.120 -- Name: hlasovani_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.121 --
16.122 @@ -181,8 +181,8 @@
16.123 ALTER TABLE nekurak.hlasovani_seq OWNER TO nekurak;
16.124
16.125 --
16.126 --- TOC entry 1608 (class 1259 OID 35278)
16.127 --- Dependencies: 1889 1890 10
16.128 +-- TOC entry 1613 (class 1259 OID 35278)
16.129 +-- Dependencies: 1897 1898 10
16.130 -- Name: hlasovani; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.131 --
16.132
16.133 @@ -198,8 +198,8 @@
16.134 ALTER TABLE nekurak.hlasovani OWNER TO nekurak;
16.135
16.136 --
16.137 --- TOC entry 1936 (class 0 OID 0)
16.138 --- Dependencies: 1608
16.139 +-- TOC entry 1951 (class 0 OID 0)
16.140 +-- Dependencies: 1613
16.141 -- Name: COLUMN hlasovani.id; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.142 --
16.143
16.144 @@ -209,8 +209,8 @@
16.145
16.146
16.147 --
16.148 --- TOC entry 1937 (class 0 OID 0)
16.149 --- Dependencies: 1608
16.150 +-- TOC entry 1952 (class 0 OID 0)
16.151 +-- Dependencies: 1613
16.152 -- Name: COLUMN hlasovani.hlas; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.153 --
16.154
16.155 @@ -220,7 +220,46 @@
16.156
16.157
16.158 --
16.159 --- TOC entry 1609 (class 1259 OID 35333)
16.160 +-- TOC entry 1616 (class 1259 OID 35396)
16.161 +-- Dependencies: 10
16.162 +-- Name: kategorie_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.163 +--
16.164 +
16.165 +CREATE SEQUENCE kategorie_seq
16.166 + INCREMENT BY 1
16.167 + NO MAXVALUE
16.168 + NO MINVALUE
16.169 + CACHE 1;
16.170 +
16.171 +
16.172 +ALTER TABLE nekurak.kategorie_seq OWNER TO nekurak;
16.173 +
16.174 +--
16.175 +-- TOC entry 1617 (class 1259 OID 35398)
16.176 +-- Dependencies: 1901 10
16.177 +-- Name: kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.178 +--
16.179 +
16.180 +CREATE TABLE kategorie (
16.181 + id integer DEFAULT nextval('kategorie_seq'::regclass) NOT NULL,
16.182 + nazev character varying(32) NOT NULL,
16.183 + popis character varying(255)
16.184 +);
16.185 +
16.186 +
16.187 +ALTER TABLE nekurak.kategorie OWNER TO nekurak;
16.188 +
16.189 +--
16.190 +-- TOC entry 1955 (class 0 OID 0)
16.191 +-- Dependencies: 1617
16.192 +-- Name: TABLE kategorie; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.193 +--
16.194 +
16.195 +COMMENT ON TABLE kategorie IS 'Kategorie podniku';
16.196 +
16.197 +
16.198 +--
16.199 +-- TOC entry 1614 (class 1259 OID 35333)
16.200 -- Dependencies: 10
16.201 -- Name: komentar_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.202 --
16.203 @@ -235,8 +274,8 @@
16.204 ALTER TABLE nekurak.komentar_seq OWNER TO nekurak;
16.205
16.206 --
16.207 --- TOC entry 1610 (class 1259 OID 35376)
16.208 --- Dependencies: 1891 1892 10
16.209 +-- TOC entry 1615 (class 1259 OID 35376)
16.210 +-- Dependencies: 1899 1900 10
16.211 -- Name: komentar; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.212 --
16.213
16.214 @@ -253,8 +292,8 @@
16.215 ALTER TABLE nekurak.komentar OWNER TO nekurak;
16.216
16.217 --
16.218 --- TOC entry 1940 (class 0 OID 0)
16.219 --- Dependencies: 1610
16.220 +-- TOC entry 1958 (class 0 OID 0)
16.221 +-- Dependencies: 1615
16.222 -- Name: TABLE komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.223 --
16.224
16.225 @@ -262,8 +301,8 @@
16.226
16.227
16.228 --
16.229 --- TOC entry 1941 (class 0 OID 0)
16.230 --- Dependencies: 1610
16.231 +-- TOC entry 1959 (class 0 OID 0)
16.232 +-- Dependencies: 1615
16.233 -- Name: COLUMN komentar.nadpis; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.234 --
16.235
16.236 @@ -271,8 +310,8 @@
16.237
16.238
16.239 --
16.240 --- TOC entry 1942 (class 0 OID 0)
16.241 --- Dependencies: 1610
16.242 +-- TOC entry 1960 (class 0 OID 0)
16.243 +-- Dependencies: 1615
16.244 -- Name: COLUMN komentar.komentar; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.245 --
16.246
16.247 @@ -281,7 +320,7 @@
16.248
16.249
16.250 --
16.251 --- TOC entry 1596 (class 1259 OID 35019)
16.252 +-- TOC entry 1601 (class 1259 OID 35019)
16.253 -- Dependencies: 10
16.254 -- Name: podnik_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.255 --
16.256 @@ -296,8 +335,8 @@
16.257 ALTER TABLE nekurak.podnik_seq OWNER TO nekurak;
16.258
16.259 --
16.260 --- TOC entry 1597 (class 1259 OID 35049)
16.261 --- Dependencies: 1882 1883 10
16.262 +-- TOC entry 1602 (class 1259 OID 35049)
16.263 +-- Dependencies: 1890 1891 10
16.264 -- Name: podnik; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.265 --
16.266
16.267 @@ -319,8 +358,8 @@
16.268 ALTER TABLE nekurak.podnik OWNER TO nekurak;
16.269
16.270 --
16.271 --- TOC entry 1945 (class 0 OID 0)
16.272 --- Dependencies: 1597
16.273 +-- TOC entry 1963 (class 0 OID 0)
16.274 +-- Dependencies: 1602
16.275 -- Name: COLUMN podnik.spravce; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.276 --
16.277
16.278 @@ -328,7 +367,21 @@
16.279
16.280
16.281 --
16.282 --- TOC entry 1600 (class 1259 OID 35101)
16.283 +-- TOC entry 1618 (class 1259 OID 35404)
16.284 +-- Dependencies: 10
16.285 +-- Name: podnik_kategorie; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.286 +--
16.287 +
16.288 +CREATE TABLE podnik_kategorie (
16.289 + podnik integer NOT NULL,
16.290 + kategorie integer NOT NULL
16.291 +);
16.292 +
16.293 +
16.294 +ALTER TABLE nekurak.podnik_kategorie OWNER TO nekurak;
16.295 +
16.296 +--
16.297 +-- TOC entry 1605 (class 1259 OID 35101)
16.298 -- Dependencies: 10
16.299 -- Name: role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.300 --
16.301 @@ -342,8 +395,8 @@
16.302 ALTER TABLE nekurak.role OWNER TO nekurak;
16.303
16.304 --
16.305 --- TOC entry 1947 (class 0 OID 0)
16.306 --- Dependencies: 1600
16.307 +-- TOC entry 1966 (class 0 OID 0)
16.308 +-- Dependencies: 1605
16.309 -- Name: TABLE role; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.310 --
16.311
16.312 @@ -351,7 +404,7 @@
16.313
16.314
16.315 --
16.316 --- TOC entry 1598 (class 1259 OID 35080)
16.317 +-- TOC entry 1603 (class 1259 OID 35080)
16.318 -- Dependencies: 10
16.319 -- Name: uzivatel_seq; Type: SEQUENCE; Schema: nekurak; Owner: nekurak
16.320 --
16.321 @@ -366,8 +419,8 @@
16.322 ALTER TABLE nekurak.uzivatel_seq OWNER TO nekurak;
16.323
16.324 --
16.325 --- TOC entry 1599 (class 1259 OID 35091)
16.326 --- Dependencies: 1884 1885 10
16.327 +-- TOC entry 1604 (class 1259 OID 35091)
16.328 +-- Dependencies: 1892 1893 10
16.329 -- Name: uzivatel; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.330 --
16.331
16.332 @@ -385,8 +438,8 @@
16.333 ALTER TABLE nekurak.uzivatel OWNER TO nekurak;
16.334
16.335 --
16.336 --- TOC entry 1950 (class 0 OID 0)
16.337 --- Dependencies: 1599
16.338 +-- TOC entry 1969 (class 0 OID 0)
16.339 +-- Dependencies: 1604
16.340 -- Name: COLUMN uzivatel.prezdivka; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.341 --
16.342
16.343 @@ -394,7 +447,7 @@
16.344
16.345
16.346 --
16.347 --- TOC entry 1601 (class 1259 OID 35106)
16.348 +-- TOC entry 1606 (class 1259 OID 35106)
16.349 -- Dependencies: 10
16.350 -- Name: uzivatel_role; Type: TABLE; Schema: nekurak; Owner: nekurak; Tablespace:
16.351 --
16.352 @@ -408,8 +461,8 @@
16.353 ALTER TABLE nekurak.uzivatel_role OWNER TO nekurak;
16.354
16.355 --
16.356 --- TOC entry 1952 (class 0 OID 0)
16.357 --- Dependencies: 1601
16.358 +-- TOC entry 1971 (class 0 OID 0)
16.359 +-- Dependencies: 1606
16.360 -- Name: TABLE uzivatel_role; Type: COMMENT; Schema: nekurak; Owner: nekurak
16.361 --
16.362
16.363 @@ -417,8 +470,8 @@
16.364
16.365
16.366 --
16.367 --- TOC entry 1908 (class 2606 OID 35227)
16.368 --- Dependencies: 1604 1604
16.369 +-- TOC entry 1917 (class 2606 OID 35227)
16.370 +-- Dependencies: 1609 1609
16.371 -- Name: clanek_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.372 --
16.373
16.374 @@ -427,8 +480,8 @@
16.375
16.376
16.377 --
16.378 --- TOC entry 1904 (class 2606 OID 35190)
16.379 --- Dependencies: 1603 1603
16.380 +-- TOC entry 1913 (class 2606 OID 35190)
16.381 +-- Dependencies: 1608 1608
16.382 -- Name: fotka_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.383 --
16.384
16.385 @@ -437,8 +490,8 @@
16.386
16.387
16.388 --
16.389 --- TOC entry 1906 (class 2606 OID 35204)
16.390 --- Dependencies: 1603 1603 1603
16.391 +-- TOC entry 1915 (class 2606 OID 35204)
16.392 +-- Dependencies: 1608 1608 1608
16.393 -- Name: fotka_poradi_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.394 --
16.395
16.396 @@ -447,8 +500,8 @@
16.397
16.398
16.399 --
16.400 --- TOC entry 1911 (class 2606 OID 35284)
16.401 --- Dependencies: 1608 1608
16.402 +-- TOC entry 1920 (class 2606 OID 35284)
16.403 +-- Dependencies: 1613 1613
16.404 -- Name: hlasovani_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.405 --
16.406
16.407 @@ -457,8 +510,18 @@
16.408
16.409
16.410 --
16.411 --- TOC entry 1914 (class 2606 OID 35385)
16.412 --- Dependencies: 1610 1610
16.413 +-- TOC entry 1925 (class 2606 OID 35403)
16.414 +-- Dependencies: 1617 1617
16.415 +-- Name: kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.416 +--
16.417 +
16.418 +ALTER TABLE ONLY kategorie
16.419 + ADD CONSTRAINT kategorie_pk PRIMARY KEY (id);
16.420 +
16.421 +
16.422 +--
16.423 +-- TOC entry 1923 (class 2606 OID 35385)
16.424 +-- Dependencies: 1615 1615
16.425 -- Name: komentar_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.426 --
16.427
16.428 @@ -467,8 +530,18 @@
16.429
16.430
16.431 --
16.432 --- TOC entry 1894 (class 2606 OID 35058)
16.433 --- Dependencies: 1597 1597
16.434 +-- TOC entry 1927 (class 2606 OID 35408)
16.435 +-- Dependencies: 1618 1618 1618
16.436 +-- Name: podnik_kategorie_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.437 +--
16.438 +
16.439 +ALTER TABLE ONLY podnik_kategorie
16.440 + ADD CONSTRAINT podnik_kategorie_pk PRIMARY KEY (podnik, kategorie);
16.441 +
16.442 +
16.443 +--
16.444 +-- TOC entry 1903 (class 2606 OID 35058)
16.445 +-- Dependencies: 1602 1602
16.446 -- Name: podnik_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.447 --
16.448
16.449 @@ -477,8 +550,8 @@
16.450
16.451
16.452 --
16.453 --- TOC entry 1900 (class 2606 OID 35105)
16.454 --- Dependencies: 1600 1600
16.455 +-- TOC entry 1909 (class 2606 OID 35105)
16.456 +-- Dependencies: 1605 1605
16.457 -- Name: skupina_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.458 --
16.459
16.460 @@ -487,8 +560,8 @@
16.461
16.462
16.463 --
16.464 --- TOC entry 1896 (class 2606 OID 35098)
16.465 --- Dependencies: 1599 1599
16.466 +-- TOC entry 1905 (class 2606 OID 35098)
16.467 +-- Dependencies: 1604 1604
16.468 -- Name: uzivatel_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.469 --
16.470
16.471 @@ -497,8 +570,8 @@
16.472
16.473
16.474 --
16.475 --- TOC entry 1898 (class 2606 OID 35100)
16.476 --- Dependencies: 1599 1599
16.477 +-- TOC entry 1907 (class 2606 OID 35100)
16.478 +-- Dependencies: 1604 1604
16.479 -- Name: uzivatel_prezdivka_uq; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.480 --
16.481
16.482 @@ -507,8 +580,8 @@
16.483
16.484
16.485 --
16.486 --- TOC entry 1902 (class 2606 OID 35137)
16.487 --- Dependencies: 1601 1601 1601
16.488 +-- TOC entry 1911 (class 2606 OID 35137)
16.489 +-- Dependencies: 1606 1606 1606
16.490 -- Name: uzivatel_role_pk; Type: CONSTRAINT; Schema: nekurak; Owner: nekurak; Tablespace:
16.491 --
16.492
16.493 @@ -517,8 +590,8 @@
16.494
16.495
16.496 --
16.497 --- TOC entry 1909 (class 1259 OID 35291)
16.498 --- Dependencies: 1608
16.499 +-- TOC entry 1918 (class 1259 OID 35291)
16.500 +-- Dependencies: 1613
16.501 -- Name: hlasovani_ip_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
16.502 --
16.503
16.504 @@ -526,8 +599,8 @@
16.505
16.506
16.507 --
16.508 --- TOC entry 1912 (class 1259 OID 35309)
16.509 --- Dependencies: 1608
16.510 +-- TOC entry 1921 (class 1259 OID 35309)
16.511 +-- Dependencies: 1613
16.512 -- Name: hlsovani_datum_idx; Type: INDEX; Schema: nekurak; Owner: nekurak; Tablespace:
16.513 --
16.514
16.515 @@ -535,8 +608,8 @@
16.516
16.517
16.518 --
16.519 --- TOC entry 1922 (class 2620 OID 35125)
16.520 --- Dependencies: 1599 65
16.521 +-- TOC entry 1937 (class 2620 OID 35125)
16.522 +-- Dependencies: 1604 65
16.523 -- Name: uzivatel_insert; Type: TRIGGER; Schema: nekurak; Owner: nekurak
16.524 --
16.525
16.526 @@ -547,8 +620,8 @@
16.527
16.528
16.529 --
16.530 --- TOC entry 1918 (class 2606 OID 35191)
16.531 --- Dependencies: 1893 1597 1603
16.532 +-- TOC entry 1931 (class 2606 OID 35191)
16.533 +-- Dependencies: 1608 1602 1902
16.534 -- Name: fotka_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.535 --
16.536
16.537 @@ -557,8 +630,8 @@
16.538
16.539
16.540 --
16.541 --- TOC entry 1919 (class 2606 OID 35285)
16.542 --- Dependencies: 1597 1608 1893
16.543 +-- TOC entry 1932 (class 2606 OID 35285)
16.544 +-- Dependencies: 1602 1902 1613
16.545 -- Name: hlasovani_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.546 --
16.547
16.548 @@ -567,8 +640,8 @@
16.549
16.550
16.551 --
16.552 --- TOC entry 1920 (class 2606 OID 35386)
16.553 --- Dependencies: 1610 1893 1597
16.554 +-- TOC entry 1933 (class 2606 OID 35386)
16.555 +-- Dependencies: 1615 1602 1902
16.556 -- Name: komentar_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.557 --
16.558
16.559 @@ -577,8 +650,8 @@
16.560
16.561
16.562 --
16.563 --- TOC entry 1921 (class 2606 OID 35391)
16.564 --- Dependencies: 1599 1897 1610
16.565 +-- TOC entry 1934 (class 2606 OID 35391)
16.566 +-- Dependencies: 1615 1906 1604
16.567 -- Name: komentar_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.568 --
16.569
16.570 @@ -587,8 +660,28 @@
16.571
16.572
16.573 --
16.574 --- TOC entry 1915 (class 2606 OID 35178)
16.575 --- Dependencies: 1599 1897 1597
16.576 +-- TOC entry 1936 (class 2606 OID 35414)
16.577 +-- Dependencies: 1924 1618 1617
16.578 +-- Name: podnik_kategorie_kategorie_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.579 +--
16.580 +
16.581 +ALTER TABLE ONLY podnik_kategorie
16.582 + ADD CONSTRAINT podnik_kategorie_kategorie_fk FOREIGN KEY (kategorie) REFERENCES kategorie(id) ON DELETE CASCADE;
16.583 +
16.584 +
16.585 +--
16.586 +-- TOC entry 1935 (class 2606 OID 35409)
16.587 +-- Dependencies: 1618 1902 1602
16.588 +-- Name: podnik_kategorie_podnik_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.589 +--
16.590 +
16.591 +ALTER TABLE ONLY podnik_kategorie
16.592 + ADD CONSTRAINT podnik_kategorie_podnik_fk FOREIGN KEY (podnik) REFERENCES podnik(id) ON DELETE CASCADE;
16.593 +
16.594 +
16.595 +--
16.596 +-- TOC entry 1928 (class 2606 OID 35178)
16.597 +-- Dependencies: 1602 1604 1906
16.598 -- Name: podnik_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.599 --
16.600
16.601 @@ -597,8 +690,8 @@
16.602
16.603
16.604 --
16.605 --- TOC entry 1916 (class 2606 OID 35138)
16.606 --- Dependencies: 1600 1601 1899
16.607 +-- TOC entry 1929 (class 2606 OID 35138)
16.608 +-- Dependencies: 1605 1908 1606
16.609 -- Name: uzivatel_role_role_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.610 --
16.611
16.612 @@ -607,8 +700,8 @@
16.613
16.614
16.615 --
16.616 --- TOC entry 1917 (class 2606 OID 35143)
16.617 --- Dependencies: 1599 1897 1601
16.618 +-- TOC entry 1930 (class 2606 OID 35143)
16.619 +-- Dependencies: 1604 1606 1906
16.620 -- Name: uzivatel_role_uzivatel_fk; Type: FK CONSTRAINT; Schema: nekurak; Owner: nekurak
16.621 --
16.622
16.623 @@ -617,7 +710,7 @@
16.624
16.625
16.626 --
16.627 --- TOC entry 1925 (class 0 OID 0)
16.628 +-- TOC entry 1940 (class 0 OID 0)
16.629 -- Dependencies: 10
16.630 -- Name: nekurak; Type: ACL; Schema: -; Owner: nekurak
16.631 --
16.632 @@ -629,8 +722,8 @@
16.633
16.634
16.635 --
16.636 --- TOC entry 1928 (class 0 OID 0)
16.637 --- Dependencies: 1605
16.638 +-- TOC entry 1943 (class 0 OID 0)
16.639 +-- Dependencies: 1610
16.640 -- Name: clanek_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.641 --
16.642
16.643 @@ -641,8 +734,8 @@
16.644
16.645
16.646 --
16.647 --- TOC entry 1930 (class 0 OID 0)
16.648 --- Dependencies: 1604
16.649 +-- TOC entry 1945 (class 0 OID 0)
16.650 +-- Dependencies: 1609
16.651 -- Name: clanek; Type: ACL; Schema: nekurak; Owner: nekurak
16.652 --
16.653
16.654 @@ -653,8 +746,8 @@
16.655
16.656
16.657 --
16.658 --- TOC entry 1931 (class 0 OID 0)
16.659 --- Dependencies: 1602
16.660 +-- TOC entry 1946 (class 0 OID 0)
16.661 +-- Dependencies: 1607
16.662 -- Name: fotka_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.663 --
16.664
16.665 @@ -665,8 +758,8 @@
16.666
16.667
16.668 --
16.669 --- TOC entry 1934 (class 0 OID 0)
16.670 --- Dependencies: 1603
16.671 +-- TOC entry 1949 (class 0 OID 0)
16.672 +-- Dependencies: 1608
16.673 -- Name: fotka; Type: ACL; Schema: nekurak; Owner: nekurak
16.674 --
16.675
16.676 @@ -677,8 +770,8 @@
16.677
16.678
16.679 --
16.680 --- TOC entry 1935 (class 0 OID 0)
16.681 --- Dependencies: 1607
16.682 +-- TOC entry 1950 (class 0 OID 0)
16.683 +-- Dependencies: 1612
16.684 -- Name: hlasovani_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.685 --
16.686
16.687 @@ -689,8 +782,8 @@
16.688
16.689
16.690 --
16.691 --- TOC entry 1938 (class 0 OID 0)
16.692 --- Dependencies: 1608
16.693 +-- TOC entry 1953 (class 0 OID 0)
16.694 +-- Dependencies: 1613
16.695 -- Name: hlasovani; Type: ACL; Schema: nekurak; Owner: nekurak
16.696 --
16.697
16.698 @@ -701,8 +794,32 @@
16.699
16.700
16.701 --
16.702 --- TOC entry 1939 (class 0 OID 0)
16.703 --- Dependencies: 1609
16.704 +-- TOC entry 1954 (class 0 OID 0)
16.705 +-- Dependencies: 1616
16.706 +-- Name: kategorie_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.707 +--
16.708 +
16.709 +REVOKE ALL ON SEQUENCE kategorie_seq FROM PUBLIC;
16.710 +REVOKE ALL ON SEQUENCE kategorie_seq FROM nekurak;
16.711 +GRANT ALL ON SEQUENCE kategorie_seq TO nekurak;
16.712 +GRANT USAGE ON SEQUENCE kategorie_seq TO nekurak_web;
16.713 +
16.714 +
16.715 +--
16.716 +-- TOC entry 1956 (class 0 OID 0)
16.717 +-- Dependencies: 1617
16.718 +-- Name: kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
16.719 +--
16.720 +
16.721 +REVOKE ALL ON TABLE kategorie FROM PUBLIC;
16.722 +REVOKE ALL ON TABLE kategorie FROM nekurak;
16.723 +GRANT ALL ON TABLE kategorie TO nekurak;
16.724 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE kategorie TO nekurak_web;
16.725 +
16.726 +
16.727 +--
16.728 +-- TOC entry 1957 (class 0 OID 0)
16.729 +-- Dependencies: 1614
16.730 -- Name: komentar_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.731 --
16.732
16.733 @@ -713,8 +830,8 @@
16.734
16.735
16.736 --
16.737 --- TOC entry 1943 (class 0 OID 0)
16.738 --- Dependencies: 1610
16.739 +-- TOC entry 1961 (class 0 OID 0)
16.740 +-- Dependencies: 1615
16.741 -- Name: komentar; Type: ACL; Schema: nekurak; Owner: nekurak
16.742 --
16.743
16.744 @@ -725,8 +842,8 @@
16.745
16.746
16.747 --
16.748 --- TOC entry 1944 (class 0 OID 0)
16.749 --- Dependencies: 1596
16.750 +-- TOC entry 1962 (class 0 OID 0)
16.751 +-- Dependencies: 1601
16.752 -- Name: podnik_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.753 --
16.754
16.755 @@ -737,8 +854,8 @@
16.756
16.757
16.758 --
16.759 --- TOC entry 1946 (class 0 OID 0)
16.760 --- Dependencies: 1597
16.761 +-- TOC entry 1964 (class 0 OID 0)
16.762 +-- Dependencies: 1602
16.763 -- Name: podnik; Type: ACL; Schema: nekurak; Owner: nekurak
16.764 --
16.765
16.766 @@ -749,8 +866,20 @@
16.767
16.768
16.769 --
16.770 --- TOC entry 1948 (class 0 OID 0)
16.771 --- Dependencies: 1600
16.772 +-- TOC entry 1965 (class 0 OID 0)
16.773 +-- Dependencies: 1618
16.774 +-- Name: podnik_kategorie; Type: ACL; Schema: nekurak; Owner: nekurak
16.775 +--
16.776 +
16.777 +REVOKE ALL ON TABLE podnik_kategorie FROM PUBLIC;
16.778 +REVOKE ALL ON TABLE podnik_kategorie FROM nekurak;
16.779 +GRANT ALL ON TABLE podnik_kategorie TO nekurak;
16.780 +GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE podnik_kategorie TO nekurak_web;
16.781 +
16.782 +
16.783 +--
16.784 +-- TOC entry 1967 (class 0 OID 0)
16.785 +-- Dependencies: 1605
16.786 -- Name: role; Type: ACL; Schema: nekurak; Owner: nekurak
16.787 --
16.788
16.789 @@ -761,8 +890,8 @@
16.790
16.791
16.792 --
16.793 --- TOC entry 1949 (class 0 OID 0)
16.794 --- Dependencies: 1598
16.795 +-- TOC entry 1968 (class 0 OID 0)
16.796 +-- Dependencies: 1603
16.797 -- Name: uzivatel_seq; Type: ACL; Schema: nekurak; Owner: nekurak
16.798 --
16.799
16.800 @@ -773,8 +902,8 @@
16.801
16.802
16.803 --
16.804 --- TOC entry 1951 (class 0 OID 0)
16.805 --- Dependencies: 1599
16.806 +-- TOC entry 1970 (class 0 OID 0)
16.807 +-- Dependencies: 1604
16.808 -- Name: uzivatel; Type: ACL; Schema: nekurak; Owner: nekurak
16.809 --
16.810
16.811 @@ -785,8 +914,8 @@
16.812
16.813
16.814 --
16.815 --- TOC entry 1953 (class 0 OID 0)
16.816 --- Dependencies: 1601
16.817 +-- TOC entry 1972 (class 0 OID 0)
16.818 +-- Dependencies: 1606
16.819 -- Name: uzivatel_role; Type: ACL; Schema: nekurak; Owner: nekurak
16.820 --
16.821
16.822 @@ -796,7 +925,7 @@
16.823 GRANT SELECT,INSERT,DELETE,UPDATE ON TABLE uzivatel_role TO nekurak_web;
16.824
16.825
16.826 --- Completed on 2010-06-09 15:52:28 CEST
16.827 +-- Completed on 2011-01-08 19:54:50 CET
16.828
16.829 --
16.830 -- PostgreSQL database dump complete