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

Struktura databáze pro Hesla na rok 2009, převzatá do databáze na Hesla pro rok 2010.

-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Pátek 13. března 2009, 18:31
-- Verze MySQL: 5.0.51
-- Verze PHP: 5.2.6-1+lenny2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Databáze: `hes10stru`
--

-- --------------------------------------------------------
--
-- Struktura tabulky `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;


-- --------------------------------------------------------
--
-- Struktura tabulky `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;

-- --------------------------------------------------------
--
-- Struktura tabulky `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;

-- --------------------------------------------------------
--
-- Struktura tabulky `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(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`date`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------
--
-- Struktura tabulky `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(20) collate utf8_czech_ci NOT NULL,
  `intro` varchar(30) collate utf8_czech_ci default NULL,
  `text` varchar(255) collate utf8_czech_ci NOT NULL,
  PRIMARY KEY  (`date`,`which`,`transl`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------
--
-- Struktura tabulky `reading`
--

CREATE TABLE IF NOT EXISTS `reading` (
  `sel` tinyint(1) NOT NULL,
  `date` date NOT NULL,
  `which` set('SR','CR','WP','Ev','Ep','Ps','Peri','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;

-- --------------------------------------------------------
--
-- Struktura tabulky `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(255) collate utf8_czech_ci default NULL,
  PRIMARY KEY  (`date`,`which`,`lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;