Projekt: Hesla Jednoty bratrské/2011/hes11.sql

Projekt: Hesla Jednoty bratrské/2011/hes11.sql

-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny3
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Sobota 06. února 2010, 13:41
-- Verze MySQL: 5.0.51
-- Verze PHP: 5.2.6-1+lenny4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: 'hes11'
--

-- --------------------------------------------------------

--
-- Struktura tabulky '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 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'
--

CREATE TABLE `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'
--

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"';

-- --------------------------------------------------------

--
-- Struktura tabulky 'drittetext'
--

CREATE TABLE 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'
--

CREATE TABLE 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'
--

CREATE TABLE 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'
--

CREATE TABLE 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';