gULiakNK

1CREATE TABLE IF NOT EXISTS `emails` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `email` varchar(255) NOT NULL,
4  PRIMARY KEY (`id`)
5) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
6
7-- --------------------------------------------------------
8
9--
10-- Structure de la table `gagnants`
11--
12
13CREATE TABLE IF NOT EXISTS `gagnants` (
14  `id` int(11) NOT NULL AUTO_INCREMENT,
15  `id_email` int(11) NOT NULL,
16  `id_lot` int(11) NOT NULL,
17  PRIMARY KEY (`id`),
18  KEY `id_email` (`id_email`,`id_lot`)
19) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
20
21-- --------------------------------------------------------
22
23--
24-- Structure de la table `lots`
25--
26
27CREATE TABLE IF NOT EXISTS `lots` (
28  `id` int(11) NOT NULL AUTO_INCREMENT,
29  `titre` varchar(255) NOT NULL,
30  `stock` int(11) NOT NULL,
31  `gagnes` int(11) NOT NULL,
32  PRIMARY KEY (`id`)
33) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;