Projekt: Hesla Jednoty bratrské/2011/hes struct.sql

Z Wikiverzity
Skočit na navigaci Skočit na vyhledávání

Projekt: Hesla Jednoty bratrské/2011/hes struct.sql

Struktura databáze hes11[editovat]

-- STRUKTURA databáze HES?? ---

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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 */;


-- --------------------------------------------------------
--
-- Struktura tabulky 'comment'
--

DROP TABLE IF EXISTS comment;
CREATE TABLE IF NOT EXISTS `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 default NULL,
  `text` varchar(80) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`date`,lang)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Anniversaries etc.';

-- --------------------------------------------------------
--
-- Struktura tabulky 'day'
--

DROP TABLE IF EXISTS day;
CREATE TABLE IF NOT EXISTS `day` (
  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';

-- --------------------------------------------------------
--
-- Struktura tabulky 'dayname'
--

DROP TABLE IF EXISTS dayname;
CREATE TABLE IF NOT EXISTS 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"';

-- --------------------------------------------------------
--
-- Struktura tabulky 'drittetext'
--

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

-- --------------------------------------------------------
--
-- Struktura tabulky 'losung'
--

DROP TABLE IF EXISTS losung;
CREATE TABLE IF NOT EXISTS losung (
  sel tinyint(1) NOT NULL,
  `date` date NOT NULL,
  which set('OT','NT','YEAR','MONTH','sunday','holiday','important','week') 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(25) collate utf8_czech_ci NOT NULL,
  intro varchar(30) collate utf8_czech_ci default NULL,
  `text` varchar(500) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`date`,which,transl)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='The verse of losung and its attributes';

-- --------------------------------------------------------
--
-- Struktura tabulky 'reading'
--

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

-- --------------------------------------------------------
--
-- Struktura tabulky 'song'
--

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

-- --------------------------------------------------------
--
-- Struktura tabulky 'import'
--

DROP TABLE IF EXISTS import;
CREATE TABLE IF NOT EXISTS import (
  MonSpruch_Bibeltext varchar(400) collate utf8_czech_ci default NULL,	# Monat Spruch -- text
  MonSpruch_Stelle varchar(30) collate utf8_czech_ci default NULL,	  -- odkaz
  MonSpruch_Quelle varchar(10) collate utf8_czech_ci default NULL,	  -- překlad
  Ft1_Feiertag varchar(80) collate utf8_czech_ci default NULL,		# 1. svátek
  Ft1_Bibeltext varchar(400) collate utf8_czech_ci default NULL,	  -- text
  Ft1_Stelle varchar(30) collate utf8_czech_ci default NULL,		  -- odkaz
  Ft1_Quelle varchar(10) collate utf8_czech_ci default NULL,		  -- překlad
  Ft1_Angaben varchar(140) collate utf8_czech_ci default NULL,		  -- přívěšky
  Ft2_Feiertag varchar(80) collate utf8_czech_ci default NULL,		# 2. svátek
  Ft2_Bibeltext varchar(400) collate utf8_czech_ci default NULL,	  -- text
  Ft2_Stelle varchar(30) collate utf8_czech_ci default NULL,		  -- odkaz
  Ft2_Quelle varchar(10) collate utf8_czech_ci default NULL,		  -- překlad
  Ft2_Angaben varchar(160) collate utf8_czech_ci default NULL,		  -- přívěšky
  Datum date NOT NULL default '0000-00-00',				# Datum 
  Los_Nummer int(4) default NULL,					# LOSUNG -- ref. číslo
  Los_Vortext varchar(60) collate utf8_czech_ci default NULL,		  -- intro
  Los_Bibeltext varchar(400) collate utf8_czech_ci default NULL,	  -- text
  Los_Stelle varchar(30) collate utf8_czech_ci default NULL,		  -- odkaz
  Los_Quelle varchar(10) collate utf8_czech_ci default NULL,		  -- překlad
  Lt_Vortext varchar(60) collate utf8_czech_ci default NULL,		# Lehrtext -- intro
  Lt_Bibeltext varchar(400) collate utf8_czech_ci default NULL,		  -- text
  Lt_Stelle varchar(30) collate utf8_czech_ci default NULL,		  -- odkaz
  Lt_Quelle varchar(10) collate utf8_czech_ci default NULL,		  -- překlad
  Bibellese_1 varchar(50) collate utf8_czech_ci default NULL,		# 1. čtení
  Bibellese_2 varchar(50) collate utf8_czech_ci default NULL,		# 2. čtení
  Gedenktage_Ek varchar(180) collate utf8_czech_ci default NULL,	# pamětní den Ekumenický
  Gedenktage_Ebu varchar(180) collate utf8_czech_ci default NULL,	# Pamětní den JB
  Dt_Text varchar(500) collate utf8_czech_ci default NULL,		# Dritte text
  Dt_Quelle varchar(240) collate utf8_czech_ci default NULL,		  -- zdroj
  Dt_Gesangbuch varchar(500) collate utf8_czech_ci default NULL,	  -- zpěvník
  Dt_Autor varchar(70) collate utf8_czech_ci default NULL,		  -- autor
  PRIMARY KEY  (Datum)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Import from MSaccess .mdb';