-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Hostitel: localhost
-- Vygenerované:: 22.Apr, 2009 - 00:56
-- Verzia serveru: 5.0.45
-- Verzia PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáza: `kpf_db`
--

-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_author`
--

CREATE TABLE IF NOT EXISTS `kpf_author` (
  `aid` bigint(6) NOT NULL auto_increment,
  `login` varchar(20) collate latin2_czech_cs default NULL,
  `heslo` varchar(50) collate latin2_czech_cs NOT NULL default '',
  `meno` varchar(20) collate latin2_czech_cs NOT NULL default '',
  `priezvisko` varchar(30) collate latin2_czech_cs NOT NULL default '',
  `afotka` varchar(200) collate latin2_czech_cs NOT NULL default 'author.jpg',
  `mail` varchar(30) collate latin2_czech_cs default NULL,
  `rss_clanok` int(1) default '0',
  `rss_body` int(1) default '0',
  `rss_fotka` int(1) default '0',
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs PACK_KEYS=0 AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_author`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_clanky`
--

CREATE TABLE IF NOT EXISTS `kpf_clanky` (
  `cid` bigint(6) NOT NULL auto_increment,
  `aid` bigint(6) default NULL,
  `nadpis` varchar(35) collate latin2_czech_cs default NULL,
  `perex` text collate latin2_czech_cs,
  `text` text collate latin2_czech_cs,
  `kategoria` text collate latin2_czech_cs,
  `cas` datetime default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_clanky`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_clanky_photos`
--

CREATE TABLE IF NOT EXISTS `kpf_clanky_photos` (
  `cfid` bigint(4) NOT NULL auto_increment,
  `aid` bigint(6) default NULL,
  `cid` bigint(6) default NULL,
  `kde` varchar(200) character set latin2 collate latin2_czech_cs default NULL,
  PRIMARY KEY  (`cfid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_clanky_photos`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_forum_photos`
--

CREATE TABLE IF NOT EXISTS `kpf_forum_photos` (
  `fid` bigint(4) NOT NULL auto_increment,
  `meno` varchar(20) collate utf8_czech_ci NOT NULL,
  `nazov` varchar(200) collate utf8_czech_ci default NULL,
  `pridane` datetime default NULL,
  PRIMARY KEY  (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_forum_photos`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_hodnot`
--

CREATE TABLE IF NOT EXISTS `kpf_hodnot` (
  `hid` bigint(6) NOT NULL auto_increment,
  `aid` bigint(6) NOT NULL,
  `id` bigint(4) default NULL,
  `body` tinyint(1) default '0',
  `text` text collate latin2_czech_cs NOT NULL,
  `cas` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs PACK_KEYS=0 AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_hodnot`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_photos`
--

CREATE TABLE IF NOT EXISTS `kpf_photos` (
  `id` bigint(4) NOT NULL auto_increment,
  `aid` bigint(6) NOT NULL,
  `foto` varchar(200) collate latin2_czech_cs NOT NULL default '',
  `nazov` varchar(200) collate latin2_czech_cs default NULL,
  `kategoria` text collate latin2_czech_cs,
  `index` mediumint(5) default '0',
  `tech` text collate latin2_czech_cs,
  `pozn` text collate latin2_czech_cs,
  `pridane` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `foto` (`foto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_photos`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_sutaze`
--

CREATE TABLE IF NOT EXISTS `kpf_sutaze` (
  `sid` bigint(4) NOT NULL auto_increment,
  `aid` bigint(6) NOT NULL,
  `nadpis` varchar(35) collate utf8_czech_ci default NULL,
  `kategoria` text character set latin2 collate latin2_czech_cs,
  `organizator` varchar(50) collate utf8_czech_ci default NULL,
  `kontakt` varchar(50) collate utf8_czech_ci default NULL,
  `termin` varchar(12) collate utf8_czech_ci default NULL,
  `tema` text collate utf8_czech_ci,
  `popis` text collate utf8_czech_ci,
  `poplatok` varchar(10) collate utf8_czech_ci default NULL,
  `cas` datetime default NULL,
  PRIMARY KEY  (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_sutaze`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_tema_hodnot`
--

CREATE TABLE IF NOT EXISTS `kpf_tema_hodnot` (
  `hid` bigint(6) NOT NULL auto_increment,
  `aid` bigint(6) NOT NULL,
  `id` bigint(4) default NULL,
  `body` tinyint(1) default '0',
  `text` text collate latin2_czech_cs NOT NULL,
  `cas` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs PACK_KEYS=0 AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_tema_hodnot`
--


-- --------------------------------------------------------

--
-- Štruktúra tabulky pre tabulku `kpf_tema_photos`
--

CREATE TABLE IF NOT EXISTS `kpf_tema_photos` (
  `id` bigint(4) NOT NULL auto_increment,
  `aid` bigint(6) NOT NULL,
  `foto` varchar(200) collate latin2_czech_cs NOT NULL default '',
  `nazov` varchar(200) collate latin2_czech_cs default NULL,
  `kategoria` text collate latin2_czech_cs,
  `body` mediumint(5) default '0',
  `tech` text collate latin2_czech_cs,
  `pozn` text collate latin2_czech_cs,
  `pridane` datetime default '0000-00-00 00:00:00',
  `tema` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `foto` (`foto`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;

--
-- Stahujem dáta pre tabulku `kpf_tema_photos`
--