Kategorie podniků (hospoda, bar, kavárna atd.)
authorFrantišek Kučera <franta-hg@frantovo.cz>
Sat, 08 Jan 2011 20:18:27 +0100
changeset 154bf21a4abea9b
parent 153 c84a3e3c8a46
child 155 0a2943a82c82
Kategorie podniků (hospoda, bar, kavárna atd.)
- datový model (tabulky kategorie a podnik_kategorie)
- entity a mapování
- zobrazování formou štítků ve výpisu podniků
html/index.html
html/styl.css
java/nekurak.net-ear/nbproject/project.properties
java/nekurak.net-ejb/nbproject/project.properties
java/nekurak.net-ejb/src/conf/Kategorie.hbm.xml
java/nekurak.net-ejb/src/conf/Podnik.hbm.xml
java/nekurak.net-lib/nbproject/build-impl.xml
java/nekurak.net-lib/nbproject/genfiles.properties
java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Kategorie.java
java/nekurak.net-lib/src/cz/frantovo/nekurak/dto/Podnik.java
java/nekurak.net-web/src/java/cz/frantovo/nekurak/web/FunkceEL.java
java/nekurak.net-web/web/WEB-INF/casti/uvod.jsp
java/nekurak.net-web/web/WEB-INF/nekurakFunkce.tld
java/nekurak.net-web/web/WEB-INF/tags/nekurak/fotkyPodniku.tag
java/nekurak.net-web/web/styl.css
sql/schéma.sql
     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&amp;podnik=143">111</a></h2><p></p><p>Adresa:<br />&#160;
     1.8 -		0<br /></p></div><div class="podnik"><h2><a href="?akce=detail&amp;podnik=141">x</a></h2><p>x</p><p>Adresa:<br />x&#160;
     1.9 +		<div class="podnik">
    1.10 +			<h2><a href="?akce=detail&amp;podnik=143">111</a></h2>
    1.11 +			<p></p>
    1.12 +			<p>Adresa:<br />&#160;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&amp;podnik=141">x</a></h2><p>x</p><p>Adresa:<br />x&#160;
    1.21  		1<br />x</p><p><a href="x">www stránka</a></p></div><div class="podnik"><h2><a href="?akce=detail&amp;podnik=140">fsda</a></h2><p>fsd</p><p>Adresa:<br />fsd&#160;
    1.22  		1<br />fsad</p><p><a href="fsd">www stránka</a></p></div><div class="podnik"><h2><a href="?akce=detail&amp;podnik=135">Test</a></h2><p>Pokus</p><p>Adresa:<br />Ulice&#160;
    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;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