-- phpMyAdmin SQL Dump
-- version 4.2.9
-- http://www.phpmyadmin.net
--
-- Počítač: 127.0.0.1:3306
-- Vytvořeno: Čtv 30. říj 2014, 14:31
-- Verze serveru: 5.5.39
-- Verze PHP: 5.4.33

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databáze: `ruz76`
--

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

--
-- Struktura tabulky `file_events`
--

CREATE TABLE `file_events` (
`id` int(10) unsigned NOT NULL,
  `file_id` int(10) unsigned NOT NULL,
  `event_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

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

--
-- Struktura tabulky `komentare`
--

CREATE TABLE `komentare` (
`id` bigint(20) unsigned NOT NULL,
  `id_prispevek` int(11) NOT NULL,
  `nazev` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `obsah` text COLLATE utf8_czech_ci NOT NULL,
  `datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `komentare`
--

INSERT INTO `komentare` (`id`, `id_prispevek`, `nazev`, `obsah`, `datum`) VALUES
(8, 0, 'Toto je komentář', 'Aj aj aj', '2014-10-30 14:20:35'),
(2, 1, 'K1  k P1', 'Komentář 1 k Příspěvku 1', '2014-10-16 13:15:57'),
(3, 1, 'K2  k P1', 'Komentář 2 k Příspěvku 1', '2014-10-16 13:16:09'),
(4, 2, 'K1  k P2', 'Komentář 1 k Příspěvku 2', '2014-10-16 13:16:54'),
(5, 2, 'K2  k P2', 'Komentář 2 k Příspěvku 2', '2014-10-16 13:17:07'),
(6, 3, 'K1  k P3', 'Komentář 1 k Příspěvku 3', '2014-10-16 13:17:26'),
(7, 3, 'K2  k P3', 'Komentář 2 k Příspěvku 3', '2014-10-16 13:17:41'),
(9, 0, 'sdfgsdg', 'sdfsdf', '2014-10-30 14:22:24'),
(10, 5, 'AAA', 'AAAA', '2014-10-30 14:28:27'),
(11, 5, 'AAAAAA', 'asfsdfsdf', '2014-10-30 14:31:11');

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

--
-- Struktura tabulky `prispevky`
--

CREATE TABLE `prispevky` (
`id` bigint(20) unsigned NOT NULL,
  `nazev` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `obsah` text COLLATE utf8_czech_ci NOT NULL,
  `datum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `prispevky`
--

INSERT INTO `prispevky` (`id`, `nazev`, `obsah`, `datum`) VALUES
(1, 'P1', 'P1 text', '2014-10-16 13:14:13'),
(2, 'P2', 'P2 text', '2014-10-16 13:14:23'),
(3, 'P3', 'P text', '2014-10-16 13:14:36'),
(4, 'Kecy v peci', 'Welcome to The Uniform Server Zero default start splash page. This page and every other file are being served by Apache. Information can be found in folder UniServerdocs. Additional support for Zero can be found on the Wiki.', '2014-10-30 13:17:53'),
(5, 'Plky i klky', ' 28 down vote\r\n	\r\n\r\nIf you do not want to change your HTML structure you can also do by adding text-align: center; to the wrapper element and a display: inline-block; to the centered element.', '2014-10-30 14:20:15');

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

--
-- Struktura tabulky `test`
--

CREATE TABLE `test` (
`id` bigint(20) unsigned NOT NULL,
  `jmeno` varchar(33) COLLATE utf8_czech_ci NOT NULL,
  `prijmeni` varchar(33) COLLATE utf8_czech_ci NOT NULL,
  `vek` tinyint(3) unsigned NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `test`
--

INSERT INTO `test` (`id`, `jmeno`, `prijmeni`, `vek`) VALUES
(2, 'Karel', 'Vomáčka', 25),
(1, 'Pepa', 'Horák', 30),
(3, 'Karel', 'Strejček', 0),
(4, 'Karel', 'Osel', 255),
(5, 'Karel', 'Osel', 255),
(6, 'Karel', 'Osel', 255),
(7, 'Karel', 'Osel', 255),
(8, '', '', 0),
(9, '', '', 0),
(10, '', '', 0),
(11, 'Lojza', 'Koláček', 55);

--
-- Klíče pro exportované tabulky
--

--
-- Klíče pro tabulku `file_events`
--
ALTER TABLE `file_events`
 ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `komentare`
--
ALTER TABLE `komentare`
 ADD UNIQUE KEY `id` (`id`);

--
-- Klíče pro tabulku `prispevky`
--
ALTER TABLE `prispevky`
 ADD UNIQUE KEY `id` (`id`);

--
-- Klíče pro tabulku `test`
--
ALTER TABLE `test`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `file_events`
--
ALTER TABLE `file_events`
MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `komentare`
--
ALTER TABLE `komentare`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT pro tabulku `prispevky`
--
ALTER TABLE `prispevky`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT pro tabulku `test`
--
ALTER TABLE `test`
MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=12;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
