-- 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 NAMES utf8mb4;

CREATE TABLE `deadline` (
  `id_deadline` int(11) NOT NULL AUTO_INCREMENT,
  `nazev` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL,
  `predmet` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL,
  `datum_deadline` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `priorita` enum('vysoka','stredni','nizka') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL,
  `stav` enum('hotovo','nedokoncene','pozde') CHARACTER SET utf8mb4 COLLATE utf8mb4_czech_ci NOT NULL,
  `poznamka` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`id_deadline`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


-- 2026-03-31 08:46:12
