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

-- 
-- Struktura tabulky `pujcovna`
-- 

CREATE TABLE `pujcovna` (
  `id` int(11) NOT NULL auto_increment,
  `zakazka_id` int(11) NOT NULL,
  `datum` date NOT NULL,
  `datum_pr_vraceni` date NOT NULL,
  `datum_vraceni` date NOT NULL,
  `text` varchar(255) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;

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

-- 
-- Struktura tabulky `pujcovna_nastaveni`
-- 

CREATE TABLE `pujcovna_nastaveni` (
  `id` int(11) NOT NULL auto_increment,
  `id_skladu` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;