-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-13
-- http://www.phpmyadmin.net
-- 
-- Host: mysql.ic.cz
-- Generation Time: Jul 26, 2010 at 01:17 AM
-- Server version: 4.10.0
-- PHP Version: 5.2.0-8+etch16
-- 
-- Database: `ty_hviezdoslav`
-- 

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

-- 
-- Table structure for table `autori`
-- 

CREATE TABLE `autori` (
  `id_autor` int(11) NOT NULL auto_increment,
  `meno` varchar(20) NOT NULL,
  `priezvisko` varchar(30) NOT NULL,
  PRIMARY KEY  (`id_autor`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=27 ;

-- 
-- Dumping data for table `autori`
-- 

INSERT INTO `autori` (`id_autor`, `meno`, `priezvisko`) VALUES 
(7, 'radko', 'glinsky'),
(8, 'rado', 'g'),
(9, 'radko', 'g'),
(10, 'r', 'g'),
(11, 'ľščťžýáíé', 'ľščťžýáíé'),
(12, 'rg_512', 'rg_215'),
(13, 'korunni', 'pomaranc'),
(14, 'more', 'sekec'),
(15, 'fkjhsjh', 'jdhfj'),
(21, 'gsd', 'adf'),
(17, 'dfasd', 'gdga'),
(20, 'jozef', 'glinsky'),
(19, 'a', 'b'),
(22, 'ondras', 'machula'),
(23, 'JG', 'jdhfj'),
(24, 'radkoxxx', 'glinsky'),
(25, 'meno', 'priezvisko'),
(26, 'rado', 'glinsky');

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

-- 
-- Table structure for table `beletria`
-- 

CREATE TABLE `beletria` (
  `id_beletria` int(11) NOT NULL auto_increment,
  `nazov` varchar(40) default NULL,
  `vyd` varchar(20) default NULL,
  `cena` int(11) default NULL,
  `obrazok` varchar(30) default NULL,
  `popis` text,
  PRIMARY KEY  (`id_beletria`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `beletria`
-- 

INSERT INTO `beletria` (`id_beletria`, `nazov`, `vyd`, `cena`, `obrazok`, `popis`) VALUES 
(1, 'A muz ti vladnout bude', 'IKAR', 177, 'img/AMuzTiVladnoutBude.jpg', 'nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...'),
(2, 'At si holky poplacou', 'abonent', 160, 'img/AtSiHolkyPoplacou.jpg', 'nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...'),
(3, 'Andel s dablem v tele', 'Mlada fronta', 257, 'img/ansdvtel.jpg', 'nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...nejaky zvlasny text co len tak tu ma bejt vole...');

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

-- 
-- Table structure for table `cas`
-- 

CREATE TABLE `cas` (
  `t` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `cas`
-- 

INSERT INTO `cas` (`t`) VALUES 
('0000-00-00'),
('0000-00-00');

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

-- 
-- Table structure for table `cislo_objed`
-- 

CREATE TABLE `cislo_objed` (
  `id_cislo_objed` int(11) NOT NULL auto_increment,
  `id_users` int(11) NOT NULL,
  `meno` varchar(30) NOT NULL,
  `priezvisko` varchar(30) NOT NULL,
  `ulica` varchar(30) NOT NULL,
  `cislo_domu` varchar(15) NOT NULL,
  `mesto` varchar(30) NOT NULL,
  `psc` varchar(10) NOT NULL,
  `telefon` varchar(30) default NULL,
  `email` varchar(50) default NULL,
  `datum` date NOT NULL,
  `poznamka` text,
  PRIMARY KEY  (`id_cislo_objed`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- 
-- Dumping data for table `cislo_objed`
-- 

INSERT INTO `cislo_objed` (`id_cislo_objed`, `id_users`, `meno`, `priezvisko`, `ulica`, `cislo_domu`, `mesto`, `psc`, `telefon`, `email`, `datum`, `poznamka`) VALUES 
(13, 3, 'alfa', 'biotreska', 'zhorela', '11', 'ano', '0101', '', '', '0000-00-00', ''),
(10, 4, 'exa', 'kratoxvil', 'a', 'b', 'c', 'd', '', '', '0000-00-00', NULL),
(11, 6, 'admin', 'adminovy', 'adminovska', 'adminovske', 'adminovsko', 'adm', '0000', 'admin@admin.ad', '0000-00-00', 'ja som admin more'),
(12, 9, 'a', 'b', 'c', 'd', 'e', '08', '', '', '0000-00-00', 'dobry den	\r\n			\r\n		'),
(14, 3, 'HMMM', 'hmmmm', 'ľščťž', '23', 'áýžéíúäô', '098', '5689 87', 'sjdfjs@fkjds.sk', '0000-00-00', 'dgfdfhfg\r\n		');

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

-- 
-- Table structure for table `knihy`
-- 

CREATE TABLE `knihy` (
  `id_kniha` int(11) NOT NULL auto_increment,
  `nazov` varchar(50) NOT NULL,
  `cena` int(11) NOT NULL,
  `obrazok` varchar(30) default NULL,
  `id_autor` int(11) NOT NULL,
  `id_zaner` int(11) NOT NULL,
  `id_vyd` int(11) default NULL,
  `rok_vyd` int(11) default NULL,
  `kropis` text,
  `dlopis` text,
  `novinka` varchar(3) default 'nie',
  `akcia` varchar(3) default 'nie',
  `uvod` varchar(3) default 'nie',
  PRIMARY KEY  (`id_kniha`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=57 ;

-- 
-- Dumping data for table `knihy`
-- 

INSERT INTO `knihy` (`id_kniha`, `nazov`, `cena`, `obrazok`, `id_autor`, `id_zaner`, `id_vyd`, `rok_vyd`, `kropis`, `dlopis`, `novinka`, `akcia`, `uvod`) VALUES 
(2, 'nazov', 456, 'ja3.jpg', 7, 9, 27, 2001, 'strucny opis knihy																					', 'fjdsfjdsfjds jdfkjdskjfdsjgjkd shgkhdsfkhdsff fksdj  sdkhf kdshfksdh fdshf kadshfklsdh fkdshf kdshfdshfhskfh sdkfhskd fkdsh fdshfdshfjhsdg jkdsh kjdhgfdhgfrhf kjdsnbvflui yriasdf asdl fs djf kjkjsd kjsdh kh hfdjh fkjhfaesfowefjdsnhfhewf sdk gertadsbfvdshf ti;uqperkew jhf	\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'nie', 'nie', 'nie'),
(41, 'zmena_nazov', 1498, '28.jpg', 23, 1, 27, 2008, 'video														', 'LALALALALALA jasdhfjkjkh sddhsfsdhkj hsdkfhkshf kjshfjds hhdsjvh jgfoirjum cj;olidj nvoierf msjkcne roifvhdc nfhkd hvcfuer hciuerhcf uienhfclkiqe	jasdhfjkjkh sddhsfsdhkj hsdkfhkshf kjshfjds hhdsjvh jgfoirjum cj;olidj nvoierf msjkcne roifvhdc nfhkd hvcfuer hciuerhcf uienhfclkiqe	jasdhfjkjkh sddhsfsdhkj hsdkfhkshf kjshfjds hhdsjvh jgfoirjum cj;olidj nvoierf msjkcne roifvhdc nfhkd hvcfuer hciuerhcf uienhfclkiqe	jasdhfjkjkh sddhsfsdhkj hsdkfhkshf kjshfjds hhdsjvh jgfoirjum cj;olidj nvoierf msjkcne roifvhdc nfhkd hvcfuer hciuerhcf uienhfclkiqe	jasdhfjkjkh sddhsfsdhkj hsdkfhkshf kjshfjds hhdsjvh jgfoirjum cj;olidj nvoierf msjkcne roifvhdc nfhkd hvcfuer hciuerhcf uienhfclkiqe	\r\n		\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'nie', 'nie', 'a'),
(53, 'skuska', 1111, '28.jpg', 20, 6, 28, 8985, 'toto je strucny popis		', 'toooosdkljf lkasjf lksdj fkljsdfjsdkljflsadjfkasjdfjsdkfjsdkjfjfdjsfjdsfjdskjf\r\nsdjf\r\ndjf\r\ndsjf\r\ndsjjfkdjfkjdsklfjds\r\nfsdjfkldsjfkljdkjf\r\ndsjgjdslfjdskjfkdk djfksdj fksd fkdsj fljsadfj\r\nsfksd lkfj skf js\r\n jfk 	\r\n		', 'nie', 'a', 'nie'),
(10, 'pokus1', 456, 'ja2.jpg', 26, 1, 22, 78, 'velmi dobra knizka fjdsfjdsfj kjdskjfdsjgjkd 							', 'fjdsfjdsfjds jdfkjdskjfdsjgjkd shgkhdsfkhdsff fksdj  sdkhf kdshfksdh fdshf kadshfklsdh fkdshf kdshfdshfhskfh sdkfhskd fkdsh fdshfdshfjhsdg jkdsh kjdhgfdhgfrhf kjdsnbvflui yriasdf asdl fs djf kjkjsd kjsdh kh hfdjh fkjhfaesfowefjdsnhfhewf sdk gertadsbfvdshf ti;uqperkew jhf	\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'nie', 'nie', 'nie'),
(11, 'pokus2', 456, '852.jpg', 26, 1, 27, 2010, 'toto je strucny opis', 'toto je ddddddddlllllllhhyyyyyyy opis		\r\n			\r\n		', 'ano', 'ano', 'a'),
(38, 'pokus3', 4565, 'hurnak1.png', 26, 1, 27, 2100, '																																		', '	\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'ano', 'nie', 'a'),
(37, 'pokus4', 456, '2.jpg', 26, 1, 21, 2000, 'to je velmi dobra knizka						', 'ľščťžýáíéľščťžýáíéľščťžýáíé	\r\n			\r\n			\r\n			\r\n			\r\n		', 'ano', 'nie', 'a'),
(39, 'kniha-novinka', 678, '4.jpg', 25, 10, 27, 2008, 'toto by mala byt novinka												', 'toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala byt novinka toto by mala toto by mala byt novinka toto by mala byt novinkatoto by mala byt novinkatoto by mala byt novinka toto by mala byt novinka  toto by mala byt novinka byt novinka 	\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'nie', 'ano', 'nie'),
(46, 'pokus', 555, '1640.jpg', 9, 1, 21, 555, 'strucny						', 'dlhy	\r\n			\r\n			\r\n		', 'nie', 'a', 'nie'),
(54, 'hruscak', 56, '982.jpg', 21, 14, 26, 0, 'dfkljsadlkfjasd										', 'jdhnkj jfkljdh shdfgh kdhg khkj gk dhgkjdh gkdh kvh dfkjhdfgh hg k ghkahdfkahs kjakjdsh kjhdskhkhdkk k kdsh fkjhs ksdh kdsh gksh fasjrfioweuofi xcklvao;jfoweufo ievkldfogiuqeoit akfasj flasjufoiuwe8oitg hkjv;aolsjufoweu f\r\n			\r\n			\r\n		', 'a', 'nie', 'nie'),
(55, 'nazov knihy', 7, 'ja2.jpg', 19, 10, 29, 100, 'popis				', 'dddddddddddllllllllllllllhhhhhhhhhhhhyyyyyyyyyyyy popiiis	\r\n			\r\n		', 'nie', 'nie', 'a'),
(52, 'neznamy', 8, '1.jpg', 19, 1, 27, 0, '																', '	\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n			\r\n		', 'nie', 'nie', 'nie');

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

-- 
-- Table structure for table `kosik`
-- 

CREATE TABLE `kosik` (
  `id_kosik` int(11) NOT NULL auto_increment,
  `id_users` int(11) NOT NULL,
  `id_kniha` int(11) NOT NULL,
  `pocet` int(11) default '1',
  PRIMARY KEY  (`id_kosik`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=46 ;

-- 
-- Dumping data for table `kosik`
-- 

INSERT INTO `kosik` (`id_kosik`, `id_users`, `id_kniha`, `pocet`) VALUES 
(36, 1, 11, 6),
(29, 7, 37, 2),
(4, 5, 37, 5),
(6, 5, 37, 4),
(37, 1, 54, 1),
(45, 6, 11, 3),
(44, 6, 41, 2);

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

-- 
-- Table structure for table `objednavky`
-- 

CREATE TABLE `objednavky` (
  `id_objednavky` int(11) NOT NULL auto_increment,
  `id_cislo_objed` int(11) NOT NULL,
  `id_kniha` int(11) NOT NULL,
  `pocet` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id_objednavky`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

-- 
-- Dumping data for table `objednavky`
-- 

INSERT INTO `objednavky` (`id_objednavky`, `id_cislo_objed`, `id_kniha`, `pocet`) VALUES 
(13, 14, 41, 1),
(12, 13, 38, 1),
(5, 10, 41, 2),
(6, 10, 11, 1),
(7, 11, 39, 5),
(11, 13, 10, 3),
(9, 11, 46, 3),
(10, 12, 11, 2);

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `id_users` int(11) NOT NULL auto_increment,
  `login` varchar(30) NOT NULL,
  `heslo` varchar(32) NOT NULL,
  `meno` varchar(30) default NULL,
  `priezvisko` varchar(30) default NULL,
  `ulica` varchar(30) default NULL,
  `cislo_domu` varchar(15) default NULL,
  `mesto` varchar(30) default NULL,
  `psc` varchar(10) default NULL,
  `telefon` varchar(30) default NULL,
  `email` varchar(50) default NULL,
  PRIMARY KEY  (`id_users`),
  UNIQUE KEY `login` (`login`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `users`
-- 

INSERT INTO `users` (`id_users`, `login`, `heslo`, `meno`, `priezvisko`, `ulica`, `cislo_domu`, `mesto`, `psc`, `telefon`, `email`) VALUES 
(1, 'rado', 'rado', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, 'abeceda', 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, 'alfabiotreska', 'alfa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, 'exa', 'blesmrt', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 'ivo', 'verba', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 'admin', 'otecko', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 'macko puf', 'puf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 'alfonz', 'alfonz', 'alfonz', 'bednar', 'neviem', 'dajake', 'hmmm', '09101', '123456', 'neznamy@daco.sk'),
(9, 'oco', 'oco', '', '', '', '', '', '', '', ''),
(10, 'алло', 'алло', '', '', '', '', '', '', '', '');

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

-- 
-- Table structure for table `vyd`
-- 

CREATE TABLE `vyd` (
  `id_vyd` int(11) NOT NULL auto_increment,
  `vyd` varchar(30) NOT NULL,
  PRIMARY KEY  (`id_vyd`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;

-- 
-- Dumping data for table `vyd`
-- 

INSERT INTO `vyd` (`id_vyd`, `vyd`) VALUES 
(21, 'lalala'),
(22, 'lelele'),
(23, 'lelele'),
(29, 'fff'),
(28, 'jdnfjds'),
(26, 'nezname'),
(27, 'daff');

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

-- 
-- Table structure for table `zanre`
-- 

CREATE TABLE `zanre` (
  `id_zaner` int(11) NOT NULL auto_increment,
  `zaner` varchar(31) NOT NULL,
  PRIMARY KEY  (`id_zaner`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

-- 
-- Dumping data for table `zanre`
-- 

INSERT INTO `zanre` (`id_zaner`, `zaner`) VALUES 
(1, 'Beletria a krásná literatúra'),
(2, 'Historia, Biografia'),
(3, 'Romány'),
(4, 'Poézia'),
(5, 'Detská literatúra'),
(6, 'Náboženská literatúra'),
(7, 'Fantasy a Sci-fi'),
(8, 'Detektivky a thrillery'),
(9, 'Encyklopedie, Náučná literatúra'),
(10, 'Učebnice, Slovníky'),
(11, 'Cudzojazyčná literatúra'),
(12, 'Bývanie, Záhrada'),
(13, 'Šport, Životný štýl'),
(14, 'Kuchárky'),
(15, 'Mapy, Sprievodcovia'),
(16, 'Hobby, Hry, Zábava');