-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vygenerováno: Ned 28. srp 2011, 11:40
-- Verze MySQL: 5.1.58
-- Verze PHP: 5.3.8-1~dotdeb.2


--
-- Databáze: `beer`
--

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

--
-- Struktura tabulky `user`
--

CREATE TABLE `user` (
  `name` varchar(100) NOT NULL,
  `surname` varchar(100) NOT NULL,
  `pass` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Vypisuji data pro tabulku `user`
--

INSERT INTO `user` VALUES('Roman', 'KrejÄÃ­', '58424a269a7b85d79379440974c68836', 'romankrejci@seznam.cz', '62.245.117.144', '0000-00-00 00:00:00', 4, 1);
INSERT INTO `user` VALUES('roan', 'r', '58424a269a7b85d79379440974c68836', 'danisekk@seznam.cz', '62.245.117.144', '0000-00-00 00:00:00', 6, 0);

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

--
-- Struktura tabulky `vote`
--

CREATE TABLE `vote` (
  `id` int(11) NOT NULL,
  `beer` int(11) NOT NULL,
  `money` int(11) NOT NULL,
  `join_us` tinyint(1) NOT NULL,
  `time_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `beers_count` int(11) NOT NULL,
  `friend` int(11) NOT NULL,
  `barbecue` varchar(1000) NOT NULL,
  `comments` varchar(200) NOT NULL,
  `id_vote` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id_vote`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Vypisuji data pro tabulku `vote`
--

INSERT INTO `vote` VALUES(6, 0, 300, 1, '2005-06-03 15:00:00', 5, 0, 'd', 'd', 4);
INSERT INTO `vote` VALUES(4, 0, 300, 0, '2005-06-03 15:00:00', 5, 0, 'e', 'e', 2);
