1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| CREATE TABLE IF NOT EXISTS `match` (
`Equipe1` varchar(50) DEFAULT NULL,
`Equipe2` varchar(50) DEFAULT NULL,
`Date` date DEFAULT NULL,
`Journee` int(11) DEFAULT NULL,
`Coteequipe1` float DEFAULT '1',
`Coteequipe2` float DEFAULT '1',
`Cotematchnul` float DEFAULT '1',
`Idmatch` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`Idmatch`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Contenu de la table `match`
--
INSERT INTO `match` (`Equipe1`, `Equipe2`, `Date`, `Journee`, `Coteequipe1`, `Coteequipe2`, `Cotematchnul`, `Idmatch`) VALUES
('Lille', 'Saint Etienne', '2009-12-10', 11, 1, 1, 1, 5),
('Valenciennes', 'Auxerre', '2009-12-15', 11, 1, 1, 1, 6),
('Mans', 'Grenoble', '2009-12-16', 11, 1, 1, 1, 7),
('Lorient', 'Marseille', '2009-12-16', 11, 1, 1, 1, 8),
('Lyon', 'Boulogne', '2009-12-16', 11, 1, 1, 1, 9),
('Monaco', 'Rennes', '2009-12-16', 11, 1, 2, 1, 10),
('Montpellier', 'Bordeaux', '2009-12-16', 11, 1, 1, 1, 11),
('Nancy', 'Nice', '2009-12-16', 11, 1, 1, 1, 12),
('Paris', 'Lens', '2009-12-16', 11, 1, 1, 1, 13),
('Lorient', 'Marseille', '2009-12-16', 11, 1, 1, 1, 14),
('Toulouse', 'Sochaux', '2009-12-12', 11, 1, 1, 1, 15); |
Partager