Projekt: Hesla Jednoty bratrské/2022/hes-stru.sql

Struktura MySQL databáze hes22.sql pro Hesla na rok 2022:

-- Adminer 4.6.3 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';

DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `histdatetxt` varchar(20) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `text` varchar(150) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`date`,`lang`,`histdatetxt`),
  KEY `date_lang` (`date`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Anniversaries etc.';


DROP TABLE IF EXISTS `comment_uni`;
CREATE TABLE `comment_uni` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(100) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`lang`,`date`),
  KEY `date` (`date`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Anniversaries etc.';


DROP TABLE IF EXISTS `day`;
CREATE TABLE `day` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `dow` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `seq` smallint(3) NOT NULL DEFAULT '0',
  `which` enum('sunday','holiday','holiday2','important','week') COLLATE utf8_czech_ci NOT NULL,
  `nr` int(11) DEFAULT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(60) COLLATE utf8_czech_ci NOT NULL,
  `meaning` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `src` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`lang`,`seq`),
  KEY `seq_lang` (`seq`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='sundays, holidays and other important days';


DROP TABLE IF EXISTS `day10decs`;
CREATE TABLE `day10decs` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `which` set('sunday','holiday','important','week') COLLATE utf8_czech_ci NOT NULL,
  `nr` int(11) DEFAULT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(60) COLLATE utf8_czech_ci NOT NULL,
  `meaning` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `src` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`date`,`which`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='sundays, holidays and other important days';


DROP TABLE IF EXISTS `dayname`;
CREATE TABLE `dayname` (
  `date` date NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(20) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`date`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Day names to be displayed, e.g. "23. sobota"';


DROP TABLE IF EXISTS `day_cs`;
CREATE TABLE `day_cs` (
  `sq` smallint(3) NOT NULL,
  `text_de` varchar(60) COLLATE utf8_czech_ci NOT NULL DEFAULT '',
  `sel` tinyint(1) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `which` enum('week','sunday','holiday','holiday2','important') COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(60) COLLATE utf8_czech_ci NOT NULL,
  `meaning` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `src` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`sq`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='sundays, holidays and other important days';


DROP TABLE IF EXISTS `drittetext`;
CREATE TABLE `drittetext` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `source` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `song` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `author` varchar(70) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` varchar(600) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`lang`,`date`),
  KEY `date` (`date`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Dritte text';


DROP TABLE IF EXISTS `import`;
CREATE TABLE `import` (
  `Nr` smallint(3) NOT NULL AUTO_INCREMENT,
  `Datum` date NOT NULL,
  `MonSpruch_Bibeltext` varchar(400) COLLATE utf8_czech_ci DEFAULT NULL,
  `MonSpruch_Stelle` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `MonSpruch_Quelle` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `Gedenktage_Ek` varchar(180) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Feiertag` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Bibeltext` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Stelle` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Quelle` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Feiertag` varchar(100) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Bibeltext` varchar(400) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Stelle` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Quelle` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `Los_Nummer` int(4) DEFAULT NULL,
  `Los_Vortext` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `Los_Bibeltext` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `Los_Stelle` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Los_Quelle` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `Lt_Vortext` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `Lt_Bibeltext` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `Lt_Stelle` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Lt_Quelle` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `Dt_Text` varchar(600) COLLATE utf8_czech_ci DEFAULT NULL,
  `Dt_Gesangbuch` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `Dt_Autor` varchar(70) COLLATE utf8_czech_ci DEFAULT NULL,
  `Dt_Quelle` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  `Bibellese_1` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `Bibellese_2` varchar(60) COLLATE utf8_czech_ci DEFAULT NULL,
  `Gedenktage_Ebu` varchar(180) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Lied` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Psalm` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Ev` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Ep` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_AT` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Pr` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Bl` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Lied` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Psalm` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Ev` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Ep` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_AT` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Pr` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft2_Bl` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `Ft1_Pr_Reihe` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`Datum`),
  UNIQUE KEY `Nr` (`Nr`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Import from MSaccess .mdb';


DROP TABLE IF EXISTS `losung`;
CREATE TABLE `losung` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `seq` smallint(6) NOT NULL,
  `which` enum('YEAR','MONTH','week','sunday','holiday','important','OT','NT') COLLATE utf8_czech_ci NOT NULL,
  `nr` int(4) DEFAULT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `transl` varchar(6) COLLATE utf8_czech_ci NOT NULL,
  `source` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  `intro` varchar(50) COLLATE utf8_czech_ci DEFAULT NULL,
  `text` varchar(500) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`lang`,`date`,`seq`,`which`,`transl`),
  KEY `date_seq_which_lang_transl` (`date`,`seq`,`which`,`lang`,`transl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='The verse of losung and its attributes';


DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
  `date` date NOT NULL,
  `text` varchar(500) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


DROP TABLE IF EXISTS `phpmysqlautobackup`;
CREATE TABLE `phpmysqlautobackup` (
  `id` int(11) NOT NULL,
  `version` varchar(6) COLLATE utf8_czech_ci DEFAULT NULL,
  `time_last_run` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


DROP TABLE IF EXISTS `quote`;
CREATE TABLE `quote` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `which` enum('YEAR','MONTH','week','sunday','holiday','important','OT','NT') COLLATE utf8_czech_ci NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `transl` varchar(6) COLLATE utf8_czech_ci NOT NULL,
  `source` varchar(50) COLLATE utf8_czech_ci NOT NULL,
  `text` varchar(500) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`date`,`which`,`lang`,`transl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Quote';


DROP TABLE IF EXISTS `reading`;
CREATE TABLE `reading` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `seq` varchar(3) COLLATE utf8_czech_ci NOT NULL,
  `which` enum('SR','CR','Ev','Ep','WP','Ps','Pr','PF','DL','x1','x2','x3','Pr2','AT','Bl') COLLATE utf8_czech_ci NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `source` varchar(80) COLLATE utf8_czech_ci NOT NULL,
  PRIMARY KEY (`lang`,`date`,`seq`,`which`),
  KEY `date_seq_which_lang` (`date`,`seq`,`which`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Bible reading';


DROP TABLE IF EXISTS `seq`;
CREATE TABLE `seq` (
  `ori` smallint(3) NOT NULL DEFAULT '0',
  `cs` smallint(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ori`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;


DROP TABLE IF EXISTS `song`;
CREATE TABLE `song` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `seq` smallint(3) NOT NULL DEFAULT '0',
  `which` enum('Ld','WL','Ld2','WL2') COLLATE utf8_czech_ci NOT NULL,
  `lang` varchar(2) COLLATE utf8_czech_ci NOT NULL,
  `book` varchar(10) COLLATE utf8_czech_ci DEFAULT NULL,
  `nr` varchar(20) COLLATE utf8_czech_ci DEFAULT NULL,
  `strophe` int(11) DEFAULT NULL,
  `strophe2` int(11) DEFAULT NULL,
  `text` varchar(600) COLLATE utf8_czech_ci DEFAULT NULL,
  PRIMARY KEY (`lang`,`date`,`seq`,`which`),
  KEY `date_seq_which_lang` (`date`,`seq`,`which`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Songs: Lied, WochenLied';


-- 2021-01-21 09:37:00