
--
-- Tabel structuur voor tabel `lottery`
-- 

CREATE TABLE IF NOT EXISTS `lottery` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(225) default '',
`active` tinyint(1) default '1',
`ticketprice` mediumint(11) default '100000',
`ticketssold` mediumint(11) default '0',
`pot` bigint(11) default '0',
`winner` varchar(16) default 'Niemand',
`winner-login` varchar(16) default '',
`start` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `lottery`
-- 

INSERT INTO `lottery` (`id`, `name`, `active`, `ticketprice`, `ticketssold`, `pot`, `winner`, `winner-login`, `start`) VALUES
(37, 'Lottery 37', 1, 100000, 0, 0, 'Niemand', '', '2008-04-30 17:37:46');