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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
|
CREATE TABLE `clubs_tb` (
`id_club` smallint(5) unsigned NOT NULL auto_increment,
`nom_club` varchar(80) NOT NULL,
`ab_club` varchar(6) NOT NULL,
`ville_club` varchar(40) NOT NULL,
PRIMARY KEY (`id_club`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Contenu de la table `clubs_tb`
--
INSERT INTO `clubs_tb` VALUES(1, 'association de la jeunesse auxerroise', 'AJA', 'auxerre');
INSERT INTO `clubs_tb` VALUES(2, 'football club des girondins de bordeaux', 'FCGB', 'bordeaux');
INSERT INTO `clubs_tb` VALUES(3, 'stade malherbe caen calvados basse-normandie', 'SMC', 'caen');
INSERT INTO `clubs_tb` VALUES(4, 'grenoble foot 38', 'GF38', 'grenoble');
INSERT INTO `clubs_tb` VALUES(5, 'le havre athletic club football', 'HAC', 'le havre');
INSERT INTO `clubs_tb` VALUES(6, 'le mans union club 72', 'MUC72', 'le mans');
INSERT INTO `clubs_tb` VALUES(7, 'lille olympique sporting club lille metropole', 'LOSC', 'lille');
INSERT INTO `clubs_tb` VALUES(8, 'football club lorient-bretagne sud', 'FCL', 'lorient');
INSERT INTO `clubs_tb` VALUES(9, 'olympique lyonnais', 'OL', 'lyon');
INSERT INTO `clubs_tb` VALUES(10, 'olympique de marseille', 'OM', 'marseille');
INSERT INTO `clubs_tb` VALUES(11, 'association sportive de monaco football', 'ASM', 'monaco');
INSERT INTO `clubs_tb` VALUES(12, 'association sportive nancy-lorraine', 'ASNL', 'nancy');
INSERT INTO `clubs_tb` VALUES(13, 'football club de nantes', 'FCNA', 'nantes');
INSERT INTO `clubs_tb` VALUES(14, 'olympique gymnaste club nice cote d azur', 'OGCN', 'nice');
INSERT INTO `clubs_tb` VALUES(15, 'paris-saint-germain football club', 'PSG', 'paris');
INSERT INTO `clubs_tb` VALUES(16, 'stade rennais football club', 'SR', 'rennes');
INSERT INTO `clubs_tb` VALUES(17, 'association sportive de saint-etienne loire', 'ASSE', 'st-etienne');
INSERT INTO `clubs_tb` VALUES(18, 'football club de sochaux-montbeliard', 'FCSM', 'sochaux');
INSERT INTO `clubs_tb` VALUES(19, 'toulouse football club', 'TFC', 'toulouse');
INSERT INTO `clubs_tb` VALUES(20, 'valenciennes football club', 'VA', 'valenciennes');
INSERT INTO `clubs_tb` VALUES(24, 'racing club de lens', 'RCL', 'lens');
INSERT INTO `clubs_tb` VALUES(23, 'football club de metz', 'FCM', 'metz');
-- --------------------------------------------------------
--
-- Structure de la table `matchs_tb`
--
CREATE TABLE `matchs_tb` (
`id_match` smallint(5) unsigned NOT NULL auto_increment,
`buts_dom` tinyint(2) unsigned NOT NULL,
`buts_ext` tinyint(2) unsigned NOT NULL,
`journee` tinyint(2) unsigned NOT NULL,
`id_club_dom` smallint(5) unsigned NOT NULL,
`id_club_ext` smallint(5) unsigned NOT NULL,
`id_saison` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id_match`),
KEY `id_club_dom` (`id_club_dom`,`id_club_ext`,`id_saison`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=374 ;
--
-- Contenu de la table `matchs_tb`
--
INSERT INTO `matchs_tb` VALUES(1, 4, 4, 1, 16, 10, 1);
INSERT INTO `matchs_tb` VALUES(2, 0, 1, 1, 6, 8, 1);
INSERT INTO `matchs_tb` VALUES(3, 2, 1, 1, 1, 13, 1);
INSERT INTO `matchs_tb` VALUES(4, 1, 0, 1, 11, 15, 1);
INSERT INTO `matchs_tb` VALUES(5, 1, 0, 1, 20, 17, 1);
INSERT INTO `matchs_tb` VALUES(6, 2, 1, 1, 2, 3, 1);
INSERT INTO `matchs_tb` VALUES(9, 0, 0, 1, 12, 7, 1);
INSERT INTO `matchs_tb` VALUES(10, 1, 0, 1, 5, 14, 1); |
Partager