-- Adminer 4.8.1 MySQL 5.7.27-0ubuntu0.16.04.1 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `events`;
CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8_czech_ci NOT NULL,
  `category` enum('koncert','predstaveni','prednaska','sport','jine') COLLATE utf8_czech_ci NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `description` text COLLATE utf8_czech_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

INSERT INTO `events` (`id`, `title`, `category`, `date`, `time`, `description`, `created_at`) VALUES
(1,	'Koncert',	'koncert',	'2026-03-26',	'13:00:00',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra convallis hendrerit. Suspendisse luctus facilisis felis nec ultrices. Donec iaculis blandit urna ac vulputate.',	'2026-03-03 08:28:52'),
(2,	'Fotbalový zápas',	'sport',	'2026-04-23',	'14:00:00',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra convallis hendrerit. Suspendisse luctus facilisis felis nec ultrices. Donec iaculis blandit urna ac vulputate.',	'2026-03-03 08:16:40'),
(3,	'Divadelní hra',	'predstaveni',	'2026-03-06',	'19:30:00',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra convallis hendrerit. Suspendisse luctus facilisis felis nec ultrices. Donec iaculis blandit urna ac vulputate.',	'2026-03-03 08:18:30'),
(4,	'Školní přednáška',	'prednaska',	'2026-05-01',	'10:40:00',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra convallis hendrerit. Suspendisse luctus facilisis felis nec ultrices. Donec iaculis blandit urna ac vulputate.',	'2026-03-03 08:22:57'),
(5,	'Narozeninová oslava - soukromá akce',	'jine',	'2026-05-17',	'14:00:00',	'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra convallis hendrerit. Suspendisse luctus facilisis felis nec ultrices. Donec iaculis blandit urna ac vulputate.',	'2026-03-03 08:23:36');

-- 2026-03-31 06:59:09
