-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Neděle 16. května 2010, 15:39
-- Verze MySQL: 5.1.37
-- Verze PHP: 5.3.0

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

--
-- Databáze: `ucitel`
--

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

--
-- Struktura tabulky `ulohy_menu`
--

DROP TABLE IF EXISTS `ulohy_menu`;
CREATE TABLE IF NOT EXISTS `ulohy_menu` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent` smallint(5) unsigned NOT NULL,
  `text` varchar(30) COLLATE utf8_czech_ci NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci COMMENT='Menu' AUTO_INCREMENT=27 ;

--
-- Vypisuji data pro tabulku `ulohy_menu`
--

INSERT INTO `ulohy_menu` (`id`, `parent`, `text`) VALUES
(3, 0, 'podlahy'),
(4, 0, 'okna'),
(5, 0, 'kontakt'),
(6, 2, 'dřevěné'),
(7, 2, 'železné'),
(8, 2, 'PVC'),
(9, 6, 'modřín'),
(10, 6, 'smrk'),
(11, 6, 'borovice'),
(12, 7, 'nerez'),
(1, 0, 'o nás'),
(2, 0, 'dveře'),
(16, 3, 'kámen'),
(15, 3, 'dřevo'),
(17, 3, 'PVC'),
(18, 3, 'koberec'),
(19, 18, 'červený'),
(20, 18, 'zelený'),
(21, 18, 'modrý'),
(22, 18, 'hnědý'),
(23, 4, 'dřevo'),
(24, 4, 'hliník'),
(25, 4, 'plas'),
(26, 4, 'síť');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
