VM4bRAJm

1
2CREATE TABLE IF NOT EXISTS `lottery` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `coins` int(11) NOT NULL DEFAULT '2500',
5  `last_winner` varchar(255) NOT NULL DEFAULT 'None',
6  `last_won` int(11) NOT NULL DEFAULT '0',
7  `rollover` enum('true','false') NOT NULL DEFAULT 'false',
8  PRIMARY KEY (`id`)
9) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
10
11--
12-- Dumping data for table `lottery`
13--
14
15INSERT INTO `lottery` (`id`, `coins`, `last_winner`, `last_won`, `rollover`) VALUES
16(1, 500, 'None1', 0, 'true');
17
18
19CREATE TABLE IF NOT EXISTS `lottery_tickets` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `username` varchar(255) NOT NULL DEFAULT 'None',
22  `num` text NOT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
25
26--
27-- Dumping data for table `lottery_tickets`
28--
29
30INSERT INTO `lottery_tickets` (`id`, `username`, `num`) VALUES
31(1, 'Divide', '190'),
32(2, 'Divide', '190'),
33(3, 'Divide', '190');