-- Adminer 4.8.1 MySQL 11.1.2-MariaDB-1:11.1.2+maria~ubu2204 dump

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

SET NAMES utf8mb4;

CREATE DATABASE `kriz_slovnik_cz` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `kriz_slovnik_cz`;

CREATE TABLE `processing` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `href` varchar(255) NOT NULL,
  `state` varchar(60) NOT NULL DEFAULT 'PLANNED',
  `error` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `processing` (`href`, `state`, `error`) VALUES
('slova-na-zz/',	'PLANNED',	NULL),
('slova-na-z/',	'PLANNED',	NULL),
('slova-na-y/',	'PLANNED',	NULL),
('slova-na-x/',	'PLANNED',	NULL),
('slova-na-w/',	'PLANNED',	NULL),
('/slova-na-v/',	'PLANNED',	NULL),
('/slova-na-uu/',	'PLANNED',	NULL),
('/slova-na-u/',	'PLANNED',	NULL),
('/slova-na-tt/',	'PLANNED',	NULL),
('/slova-na-t/',	'PLANNED',	NULL),
('/slova-na-ss/',	'PLANNED',	NULL),
('/slova-na-s/',	'PLANNED',	NULL),
('/slova-na-rr/',	'PLANNED',	NULL),
('/slova-na-r/',	'PLANNED',	NULL),
('/slova-na-q/',	'PLANNED',	NULL),
('/slova-na-p/',	'PLANNED',	NULL),
('/slova-na-oo/',	'PLANNED',	NULL),
('/slova-na-o/',	'PLANNED',	NULL),
('/slova-na-nn/',	'PLANNED',	NULL),
('/slova-na-n/',	'PLANNED',	NULL),
('/slova-na-m/',	'PLANNED',	NULL),
('/slova-na-l/',	'PLANNED',	NULL),
('/slova-na-k/',	'PLANNED',	NULL),
('/slova-na-j/',	'PLANNED',	NULL),
('/slova-na-ii/',	'PLANNED',	NULL),
('/slova-na-i/',	'PLANNED',	NULL),
('/slova-na-ch/',	'PLANNED',	NULL),
('/slova-na-h/',	'PLANNED',	NULL),
('/slova-na-g/',	'PLANNED',	NULL),
('/slova-na-f/',	'PLANNED',	NULL),
('/slova-na-ee/',	'PLANNED',	NULL),
('/slova-na-e/',	'PLANNED',	NULL),
('/slova-na-dd/',	'PLANNED',	NULL),
('/slova-na-d/',	'PLANNED',	NULL),
('/slova-na-cc/',	'PLANNED',	NULL),
('/slova-na-c/',	'PLANNED',	NULL),
('/slova-na-b/',	'PLANNED',	NULL),
('/slova-na-aa/',	'PLANNED',	NULL),
('/slova-na-a/',	'PLANNED',	NULL);

CREATE TABLE `words` (
  `keyword` varchar(60) NOT NULL,
  `desc` varchar(255) NOT NULL,
  `href` varchar(255) NOT NULL,
  KEY `keyword` (`keyword`),
  KEY `href` (`href`),
  KEY `desc` (`desc`),
  FULLTEXT KEY `desc_fulltext` (`desc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


-- 2023-09-09 15:06:44
