-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-13
-- http://www.phpmyadmin.net
-- 
-- Pota: localhost
-- Vygenerovno: tvrtek 07. ervna 2012, 22:58
-- Verze MySQL: 5.0.32
-- Verze PHP: 5.2.0-8+etch16
-- 
-- Databze: `rmgassql2`
-- 

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

-- 
-- Struktura tabulky `jidelnicek`
-- 

CREATE TABLE `jidelnicek` (
  `id_jidelnicek` int(11) NOT NULL auto_increment,
  `2_cena` int(11) NOT NULL default '72',
  `3_cena` int(11) NOT NULL default '72',
  `4_cena` int(11) NOT NULL default '72',
  `5_cena` int(11) NOT NULL default '72',
  `2_polevka` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_polevka` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_polevka` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_polevka` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_hlavni` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_hlavni` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_hlavni` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_hlavni` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_priloha` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_priloha` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_priloha` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_priloha` varchar(255) collate cp1250_czech_cs NOT NULL,
  `tyden_od` date NOT NULL,
  `2_menu1` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_menu2` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_menu3` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_menu4` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_menu1` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_menu2` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_menu3` varchar(255) collate cp1250_czech_cs NOT NULL,
  `3_menu4` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_menu1` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_menu2` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_menu3` varchar(255) collate cp1250_czech_cs NOT NULL,
  `4_menu4` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_menu1` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_menu2` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_menu3` varchar(255) collate cp1250_czech_cs NOT NULL,
  `5_menu4` varchar(255) collate cp1250_czech_cs NOT NULL,
  `2_pocet` int(11) NOT NULL,
  `3_pocet` int(11) NOT NULL,
  `4_pocet` int(11) NOT NULL,
  `5_pocet` int(11) NOT NULL,
  `2_cena1` int(11) NOT NULL,
  `2_cena2` int(11) NOT NULL,
  `2_cena3` int(11) NOT NULL,
  `2_cena4` int(11) NOT NULL,
  `3_cena1` int(11) NOT NULL,
  `3_cena2` int(11) NOT NULL,
  `3_cena3` int(11) NOT NULL,
  `3_cena4` int(11) NOT NULL,
  `4_cena1` int(11) NOT NULL,
  `4_cena2` int(11) NOT NULL,
  `4_cena3` int(11) NOT NULL,
  `4_cena4` int(11) NOT NULL,
  `5_cena1` int(11) NOT NULL,
  `5_cena2` int(11) NOT NULL,
  `5_cena3` int(11) NOT NULL,
  `5_cena4` int(11) NOT NULL,
  PRIMARY KEY  (`id_jidelnicek`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs AUTO_INCREMENT=2 ;

-- 
-- Vypisuji data pro tabulku `jidelnicek`
-- 

INSERT INTO `jidelnicek` (`id_jidelnicek`, `2_cena`, `3_cena`, `4_cena`, `5_cena`, `2_polevka`, `3_polevka`, `4_polevka`, `5_polevka`, `2_hlavni`, `3_hlavni`, `4_hlavni`, `5_hlavni`, `2_priloha`, `3_priloha`, `4_priloha`, `5_priloha`, `tyden_od`, `2_menu1`, `2_menu2`, `2_menu3`, `2_menu4`, `3_menu1`, `3_menu2`, `3_menu3`, `3_menu4`, `4_menu1`, `4_menu2`, `4_menu3`, `4_menu4`, `5_menu1`, `5_menu2`, `5_menu3`, `5_menu4`, `2_pocet`, `3_pocet`, `4_pocet`, `5_pocet`, `2_cena1`, `2_cena2`, `2_cena3`, `2_cena4`, `3_cena1`, `3_cena2`, `3_cena3`, `3_cena4`, `4_cena1`, `4_cena2`, `4_cena3`, `4_cena4`, `5_cena1`, `5_cena2`, `5_cena3`, `5_cena4`) VALUES 
(1, 72, 72, 72, 72, 'Kyselice', 'Slepi vvar s nudlemi', 'Selsk s klobsou', 'Frankfurtsk s prkem', '', '', '', '', '', '', '', '', '2012-03-20', '110g Kuec pltek zapeen s broskv a srem, re', '', '', '', '100g Svkov na smetan, houskov knedlk', '', '', '', '150g Peen kuec stehno, kuskus', '', '', '', '  170g Rakousk knedlk s povidly, sypan mkem', '100g Smaen niva, sedlck brambory, tatarka', '', '', 1, 1, 1, 2, 75, 72, 72, 72, 77, 72, 72, 72, 75, 72, 72, 72, 69, 72, 72, 72);

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

-- 
-- Struktura tabulky `maily`
-- 

CREATE TABLE `maily` (
  `id_mail` int(11) NOT NULL auto_increment,
  `mail` varchar(255) collate cp1250_czech_cs NOT NULL,
  PRIMARY KEY  (`id_mail`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs AUTO_INCREMENT=32 ;

-- 
-- Vypisuji data pro tabulku `maily`
-- 

INSERT INTO `maily` (`id_mail`, `mail`) VALUES 
(26, 'i.vrlova@rmgas.cz'),
(25, 'ladakriz@centrum.cz'),
(24, 'bernkopfova.dagmar@seznam.cz'),
(23, 'david.vorac@gmail.com'),
(27, 'spectrazlin@spectrazlin.cz'),
(28, 'info@elko-hvozdna.cz'),
(30, 'gotech@gotech.cz'),
(31, 'kunovsky@kalina.cz');

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

-- 
-- Struktura tabulky `novinky`
-- 

CREATE TABLE `novinky` (
  `id_novinky` int(11) NOT NULL auto_increment,
  `1_nadpis` varchar(255) collate cp1250_czech_cs NOT NULL,
  `1_text` text collate cp1250_czech_cs NOT NULL,
  PRIMARY KEY  (`id_novinky`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs AUTO_INCREMENT=3 ;

-- 
-- Vypisuji data pro tabulku `novinky`
-- 

INSERT INTO `novinky` (`id_novinky`, `1_nadpis`, `1_text`) VALUES 
(2, 'Speciln nabdka na vkend 17.3. - 18.3. 2012 ', '150g PORT-HAUS Smaen esnekov zek z prav hovz svkov              145,-      \r<br>150g Svkov ezy s drbemi jtry                                         155,-      \r<br>');

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

-- 
-- Struktura tabulky `users`
-- 

CREATE TABLE `users` (
  `id_login` int(11) NOT NULL auto_increment,
  `login` varchar(255) collate cp1250_czech_cs NOT NULL,
  `pass` varchar(255) collate cp1250_czech_cs NOT NULL,
  PRIMARY KEY  (`id_login`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1250 COLLATE=cp1250_czech_cs AUTO_INCREMENT=2 ;

-- 
-- Vypisuji data pro tabulku `users`
-- 

INSERT INTO `users` (`id_login`, `login`, `pass`) VALUES 
(1, 'elkojidelnicek', 'fbecefd808a0c28fde0c82f57fdfc744');
