CREATE TABLE IF NOT EXISTS `lottery` (  `lotofund` int(30) NOT NULL DEFAULT '0',
`tickets` int(30) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `lottery` (`lotofund`, `tickets`) VALUES (0, 0);

CREATE TABLE IF NOT EXISTS `lottery_players` (
`user` int(30) NOT NULL DEFAULT '0',
`tickets` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

CREATE TABLE IF NOT EXISTS `lotowinners` (
`user` int(20) NOT NULL DEFAULT '0',
`amountwon` int(50) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

CREATE TABLE IF NOT EXISTS `lottery_config` (
`ticketprice` int(30) NOT NULL DEFAULT '0',
`maxtickets` int(30) NOT NULL DEFAULT '0',
`pagedisable` enum('Yes','No') NOT NULL DEFAULT 'No'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `lottery_config` (`ticketprice`, `maxtickets`, `pagedisable`) VALUES (1000, 10, 'No');

ALTER TABLE `users` ADD `tickets` INT(30) NOT NULL DEFAULT 0;