-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : lun. 28 mars 2022 à 06:58
-- Version du serveur :  5.7.31
-- Version de PHP : 7.3.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `bd_emftournois`
--

-- --------------------------------------------------------

--
-- Structure de la table `r_equipe_match`
--

DROP TABLE IF EXISTS `r_equipe_match`;
CREATE TABLE IF NOT EXISTS `r_equipe_match` (
  `pk_equipe_match` int(11) NOT NULL AUTO_INCREMENT,
  `fk_equipe` int(11) NOT NULL,
  `fk_match` int(11) NOT NULL,
  `score` int(11) DEFAULT NULL,
  PRIMARY KEY (`pk_equipe_match`),
  KEY `fk_r_equipe_match_t_match` (`fk_match`),
  KEY `fk_r_equipe_match_t_equipe` (`fk_equipe`)
) ENGINE=InnoDB AUTO_INCREMENT=31117 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `r_equipe_match`
--

INSERT INTO `r_equipe_match` (`pk_equipe_match`, `fk_equipe`, `fk_match`, `score`) VALUES
(423, 66, 348, 0),
(424, 68, 348, 3),
(425, 66, 349, 5),
(426, 69, 349, 0),
(427, 66, 350, 4),
(428, 84, 350, 1),
(429, 67, 351, 2),
(430, 68, 351, 1),
(431, 67, 352, 5),
(432, 69, 352, 0),
(433, 67, 353, 0),
(434, 84, 353, 5),
(435, 68, 354, 5),
(436, 69, 354, 0),
(437, 68, 355, 4),
(438, 84, 355, 1),
(439, 69, 356, 0),
(440, 84, 356, 5),
(441, 70, 357, 2),
(442, 71, 357, 3),
(443, 70, 358, 0),
(444, 72, 358, 4),
(445, 70, 359, 5),
(446, 73, 359, 2),
(447, 70, 360, 0),
(448, 85, 360, 3),
(449, 71, 361, 0),
(450, 72, 361, 5),
(451, 71, 362, 4),
(452, 73, 362, 3),
(453, 71, 363, 0),
(454, 85, 363, 5),
(455, 72, 364, 5),
(456, 73, 364, 1),
(457, 72, 365, 1),
(458, 85, 365, 3),
(459, 73, 366, 22),
(460, 85, 366, 6),
(461, 78, 367, 2),
(462, 80, 367, 2),
(463, 78, 368, 7),
(464, 81, 368, 0),
(465, 78, 369, 2),
(466, 86, 369, 3),
(467, 78, 370, 6),
(468, 87, 370, 3),
(469, 80, 371, 6),
(470, 81, 371, 0),
(471, 80, 372, 4),
(472, 86, 372, 3),
(473, 80, 373, 2),
(474, 87, 373, 4),
(475, 81, 374, 0),
(476, 86, 374, 5),
(477, 81, 375, 0),
(478, 87, 375, 6),
(479, 86, 376, 2),
(480, 87, 376, 1),
(481, 74, 377, 0),
(482, 75, 377, 5),
(483, 74, 378, 2),
(484, 76, 378, 7),
(485, 74, 379, 7),
(486, 77, 379, 2),
(487, 74, 380, 5),
(488, 79, 380, 0),
(489, 75, 381, 4),
(490, 76, 381, 3),
(491, 75, 382, 2),
(492, 77, 382, 0),
(493, 75, 383, 2),
(494, 79, 383, 3),
(495, 76, 384, 2),
(496, 77, 384, 2),
(497, 76, 385, 4),
(498, 79, 385, 2),
(499, 77, 386, 3),
(500, 79, 386, 2),
(501, 66, 390, 0),
(502, 67, 390, 1),
(509, 85, 403, 9),
(510, 67, 403, 2),
(511, 86, 404, 2),
(512, 76, 404, 3),
(513, 75, 405, 4),
(514, 78, 405, 6),
(515, 72, 406, 7),
(516, 78, 406, 6),
(517, 85, 407, 2),
(518, 76, 407, 1),
(519, 78, 408, 7),
(520, 76, 408, 1),
(521, 72, 409, 3),
(522, 85, 409, 1),
(523, 90, 423, 1),
(524, 91, 423, 16),
(525, 88, 424, 16),
(526, 95, 424, 1),
(527, 89, 425, 12),
(528, 92, 425, 5),
(529, 93, 426, 0),
(530, 94, 426, 15),
(531, 90, 427, 4),
(532, 88, 427, 15),
(533, 91, 428, 8),
(534, 95, 428, 2),
(535, 89, 429, 12),
(536, 93, 429, 5),
(537, 92, 430, 0),
(538, 94, 430, 24),
(539, 90, 431, 4),
(540, 95, 431, 4),
(541, 91, 432, 15),
(542, 88, 432, 9),
(543, 89, 433, 13),
(544, 94, 433, 11),
(545, 92, 434, 8),
(546, 93, 434, 8),
(577, 88, 450, 1),
(578, 93, 450, 0),
(579, 89, 451, 4),
(580, 90, 451, 0),
(591, 91, 457, 14),
(592, 92, 457, 7),
(593, 94, 458, 23),
(594, 95, 458, 8),
(595, 91, 459, 5),
(596, 94, 459, 7),
(597, 88, 460, 11),
(598, 89, 460, 1),
(599, 94, 461, 17),
(600, 88, 461, 3),
(603, 91, 463, 12),
(604, 89, 463, 7),
(959, 110, 642, 0),
(960, 130, 642, 1),
(961, 125, 643, 5),
(962, 128, 643, 0),
(963, 111, 644, 4),
(964, 130, 644, 3),
(965, 120, 645, 1),
(966, 121, 645, 5),
(967, 121, 646, 1),
(968, 137, 646, 3),
(969, 120, 647, 5),
(970, 109, 647, 3),
(971, 124, 648, 0),
(972, 121, 648, 3),
(973, 137, 649, 3),
(974, 109, 649, 1),
(975, 138, 650, 3),
(976, 128, 650, 2),
(977, 110, 651, 1),
(978, 125, 651, 3),
(979, 111, 652, 6),
(980, 128, 652, 4),
(981, 130, 653, 5),
(982, 125, 653, 2),
(983, 128, 654, 0),
(984, 110, 654, 5),
(985, 130, 655, 4),
(986, 138, 655, 3),
(987, 134, 656, 4),
(988, 120, 656, 0),
(989, 138, 657, 2),
(990, 110, 657, 1),
(991, 109, 658, 1),
(992, 124, 658, 1),
(993, 111, 659, 3),
(994, 110, 659, 1),
(995, 124, 660, 0),
(996, 137, 660, 9),
(997, 125, 661, 2),
(998, 138, 661, 1),
(999, 111, 662, 0),
(1000, 125, 662, 5),
(1001, 134, 663, 1),
(1002, 137, 663, 3),
(1003, 111, 664, 5),
(1004, 138, 664, 0),
(1005, 137, 665, 6),
(1006, 120, 665, 0),
(1007, 109, 666, 2),
(1008, 121, 666, 2),
(1009, 124, 667, 4),
(1010, 120, 667, 4),
(1011, 134, 668, 0),
(1012, 109, 668, 3),
(1013, 134, 669, 1),
(1014, 121, 669, 4),
(1015, 128, 670, 3),
(1016, 130, 670, 3),
(1017, 134, 671, 2),
(1018, 124, 671, 1),
(1045, 111, 675, 8),
(1046, 134, 675, 7),
(1047, 121, 676, 0),
(1048, 130, 676, 9),
(1049, 125, 677, 1),
(1050, 130, 677, 3),
(1051, 111, 678, 4),
(1052, 137, 678, 3),
(1055, 125, 680, 0),
(1056, 137, 680, 0),
(1057, 111, 681, 1),
(1058, 130, 681, 5),
(1059, 143, 682, 2),
(1060, 148, 682, 0),
(1061, 139, 683, 0),
(1062, 147, 683, 2),
(1063, 142, 684, 2),
(1064, 150, 684, 0),
(1065, 149, 685, 0),
(1066, 153, 685, 2),
(1071, 149, 688, 0),
(1072, 150, 688, 2),
(1073, 142, 689, 2),
(1074, 153, 689, 0),
(1075, 139, 690, 0),
(1076, 143, 690, 2),
(1077, 147, 691, 2),
(1078, 148, 691, 0),
(1083, 143, 694, 0),
(1084, 147, 694, 2),
(1085, 139, 695, 2),
(1086, 148, 695, 0),
(1091, 142, 698, 2),
(1092, 149, 698, 0),
(1093, 150, 699, 2),
(1094, 153, 699, 0),
(1107, 153, 706, 2),
(1108, 139, 706, 1),
(1109, 150, 707, 2),
(1110, 148, 707, 0),
(1111, 146, 708, 2),
(1112, 145, 708, 1),
(1113, 143, 709, 2),
(1114, 149, 709, 0),
(1115, 147, 710, 2),
(1116, 153, 710, 0),
(1117, 143, 711, 1),
(1118, 144, 711, 2),
(1119, 152, 712, 2),
(1120, 150, 712, 1),
(1121, 146, 713, 0),
(1122, 142, 713, 2),
(1123, 147, 714, 2),
(1124, 144, 714, 1),
(1125, 142, 715, 2),
(1126, 152, 715, 1),
(1129, 147, 717, 0),
(1130, 142, 717, 2),
(1131, 152, 718, 0),
(1132, 144, 718, 2),
(1140, 156, 720, 5),
(1141, 157, 720, 4),
(1144, 160, 722, 4),
(1145, 157, 722, 3),
(1146, 154, 723, 3),
(1147, 159, 723, 4),
(1148, 156, 724, 1),
(1149, 158, 724, 5),
(1150, 155, 725, 1),
(1151, 159, 725, 6),
(1152, 160, 726, 2),
(1153, 158, 726, 3),
(1156, 157, 728, 3),
(1157, 158, 728, 2),
(1158, 155, 729, 0),
(1159, 156, 729, 5),
(1160, 160, 730, 1),
(1161, 154, 730, 3),
(1162, 159, 731, 5),
(1163, 156, 731, 1),
(1164, 157, 732, 3),
(1165, 154, 732, 7),
(1166, 155, 733, 0),
(1167, 160, 733, 3),
(1168, 158, 734, 3),
(1169, 154, 734, 2),
(1170, 159, 735, 3),
(1171, 160, 735, 2),
(1172, 157, 736, 3),
(1173, 155, 736, 5),
(1174, 156, 737, 0),
(1175, 160, 737, 5),
(1176, 158, 738, 10),
(1177, 155, 738, 0),
(1178, 159, 739, 2),
(1179, 157, 739, 3),
(1222, 154, 761, 6),
(1223, 155, 761, 2),
(1226, 158, 763, 6),
(1227, 159, 763, 2),
(1228, 154, 764, 7),
(1229, 156, 764, 3),
(1232, 154, 766, 5),
(1233, 159, 766, 0),
(1234, 159, 767, 1),
(1235, 160, 767, 2),
(1236, 158, 768, 5),
(1237, 154, 768, 0),
(1312, 163, 809, 2),
(1313, 164, 809, 0),
(1314, 165, 810, 2),
(1315, 161, 810, 4),
(1316, 162, 811, 1),
(1317, 163, 811, 2),
(1320, 166, 813, 2),
(1321, 170, 813, 3),
(1322, 167, 814, 4),
(1323, 168, 814, 0),
(1324, 169, 815, 0),
(1325, 166, 815, 3),
(1326, 170, 816, 1),
(1327, 167, 816, 1),
(1328, 168, 817, 1),
(1329, 169, 817, 4),
(1330, 166, 818, 3),
(1331, 167, 818, 5),
(1332, 170, 819, 3),
(1333, 168, 819, 0),
(1334, 169, 820, 3),
(1335, 167, 820, 1),
(1336, 166, 821, 5),
(1337, 168, 821, 0),
(1338, 170, 822, 4),
(1339, 169, 822, 1),
(1340, 161, 823, 4),
(1341, 162, 823, 3),
(1342, 164, 824, 2),
(1343, 165, 824, 1),
(1344, 161, 825, 5),
(1345, 163, 825, 1),
(1346, 162, 826, 3),
(1347, 164, 826, 2),
(1348, 165, 827, 2),
(1349, 163, 827, 2),
(1350, 161, 828, 4),
(1351, 164, 828, 2),
(1352, 162, 829, 1),
(1353, 165, 829, 2),
(1354, 163, 830, 4),
(1355, 176, 830, 1),
(1356, 161, 831, 5),
(1357, 176, 831, 0),
(1358, 162, 832, 2),
(1359, 176, 832, 2),
(1360, 164, 833, 5),
(1361, 176, 833, 0),
(1362, 165, 834, 5),
(1363, 176, 834, 0),
(1364, 161, 835, 3),
(1365, 169, 835, 2),
(1366, 167, 836, 6),
(1367, 165, 836, 4),
(1368, 163, 837, 2),
(1369, 166, 837, 3),
(1370, 170, 838, 6),
(1371, 164, 838, 7),
(1372, 161, 839, 1),
(1373, 167, 839, 5),
(1374, 166, 840, 7),
(1375, 164, 840, 1),
(1376, 161, 841, 0),
(1377, 164, 841, 0),
(1378, 167, 842, 1),
(1379, 166, 842, 6),
(1382, 185, 844, 2),
(1383, 177, 844, 4),
(1384, 182, 845, 2),
(1385, 187, 845, 8),
(1386, 182, 846, 2),
(1387, 187, 846, 4),
(1388, 185, 847, 3),
(1389, 177, 847, 1),
(1396, 182, 851, 1),
(1397, 177, 851, 12),
(1404, 177, 855, 2),
(1405, 187, 855, 7),
(1408, 212, 857, 2),
(1409, 211, 857, 1),
(1410, 213, 858, 3),
(1411, 210, 858, 2),
(1412, 213, 859, 6),
(1413, 215, 859, 1),
(1414, 212, 860, 2),
(1415, 210, 860, 3),
(1416, 211, 861, 1),
(1417, 213, 861, 3),
(1418, 215, 862, 0),
(1419, 210, 862, 5),
(1420, 212, 863, 3),
(1421, 213, 863, 3),
(1422, 215, 864, 0),
(1423, 211, 864, 5),
(1424, 210, 865, 3),
(1425, 211, 865, 0),
(1426, 212, 866, 2),
(1427, 215, 866, 2),
(1428, 207, 867, 0),
(1429, 208, 867, 2),
(1430, 209, 868, 2),
(1431, 214, 868, 2),
(1432, 214, 869, 5),
(1433, 207, 869, 1),
(1434, 208, 870, 4),
(1435, 209, 870, 1),
(1436, 209, 871, 2),
(1437, 207, 871, 0),
(1438, 208, 872, 5),
(1439, 214, 872, 3),
(1440, 213, 874, 4),
(1441, 207, 874, 1),
(1442, 214, 875, 2),
(1443, 212, 875, 3),
(1444, 208, 876, 3),
(1445, 211, 876, 0),
(1446, 210, 877, 0),
(1447, 209, 877, 5),
(1448, 213, 878, 2),
(1449, 212, 878, 3),
(1450, 208, 879, 2),
(1451, 209, 879, 3),
(1452, 212, 880, 7),
(1453, 209, 880, 4),
(1454, 213, 881, 2),
(1455, 208, 881, 1),
(31061, 12004, 12031, 2),
(31062, 12005, 12031, 0),
(31063, 12006, 12032, 0),
(31064, 12007, 12032, 2),
(31065, 12004, 12033, 2),
(31066, 12006, 12033, 0),
(31067, 12005, 12034, 0),
(31068, 12007, 12034, 2),
(31069, 12004, 12035, 0),
(31070, 12007, 12035, 2),
(31071, 12005, 12036, 0),
(31072, 12006, 12036, 2),
(31073, 12008, 12037, 0),
(31074, 12011, 12037, 2),
(31075, 12010, 12038, 2),
(31076, 12009, 12038, 0),
(31077, 12008, 12039, 2),
(31078, 12010, 12039, 0),
(31079, 12011, 12040, 2),
(31080, 12009, 12040, 0),
(31081, 12008, 12041, 0),
(31082, 12009, 12041, 0),
(31083, 12010, 12042, 0),
(31084, 12011, 12042, 0),
(31085, 12013, 12043, 0),
(31086, 12012, 12043, 2),
(31087, 12015, 12044, 0),
(31088, 12014, 12044, 2),
(31089, 12012, 12045, 2),
(31090, 12014, 12045, 0),
(31091, 12013, 12046, 2),
(31092, 12015, 12046, 1),
(31093, 12012, 12047, 0),
(31094, 12015, 12047, 0),
(31095, 12013, 12048, 0),
(31096, 12014, 12048, 0),
(31097, 12017, 12049, 0),
(31098, 12016, 12049, 2),
(31099, 12020, 12050, 1),
(31100, 12019, 12050, 2),
(31101, 12017, 12051, 0),
(31102, 12018, 12051, 2),
(31103, 12016, 12052, 2),
(31104, 12020, 12052, 1),
(31105, 12017, 12053, 0),
(31106, 12020, 12053, 2),
(31107, 12019, 12054, 2),
(31108, 12018, 12054, 0),
(31109, 12016, 12055, 0),
(31110, 12019, 12055, 0),
(31111, 12020, 12056, 0),
(31112, 12018, 12056, 0),
(31113, 12017, 12057, 0),
(31114, 12019, 12057, 2),
(31115, 12016, 12058, 0),
(31116, 12018, 12058, 0);

-- --------------------------------------------------------

--
-- Structure de la table `t_admin`
--

DROP TABLE IF EXISTS `t_admin`;
CREATE TABLE IF NOT EXISTS `t_admin` (
  `pk_login` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`pk_login`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_admin`
--

INSERT INTO `t_admin` (`pk_login`, `login`, `password`) VALUES
(3, 'studer', 'Ek76.k12'),
(6, 'test', '-3Mf70uRn01s');

-- --------------------------------------------------------

--
-- Structure de la table `t_classe`
--

DROP TABLE IF EXISTS `t_classe`;
CREATE TABLE IF NOT EXISTS `t_classe` (
  `pk_classe` int(11) NOT NULL AUTO_INCREMENT,
  `nom_classe` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`pk_classe`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_classe`
--

INSERT INTO `t_classe` (`pk_classe`, `nom_classe`) VALUES
(1, '1i1'),
(2, '1i2'),
(3, '1A'),
(4, '1E'),
(5, '1L1'),
(6, '1L2'),
(7, '1L3'),
(8, '1L4'),
(9, '1L5'),
(10, '1L6'),
(11, '1L7'),
(12, '1P'),
(13, '2A'),
(14, '2E'),
(15, '2I1'),
(16, '2I2'),
(17, '2L1'),
(18, '2L2'),
(19, '2L3'),
(20, '2L4'),
(21, '2L5'),
(22, '2L6'),
(23, '2L7'),
(24, '2P'),
(25, '3A'),
(26, '3E'),
(27, '3I1'),
(28, '3I2'),
(29, '3L1'),
(30, '3L2'),
(31, '3L3'),
(32, '3L4'),
(33, '3L5'),
(34, '3L6'),
(35, '3P'),
(36, '4A'),
(37, '4E'),
(38, '4I1'),
(39, '4I2'),
(40, '4P'),
(41, 'cm11'),
(42, 'cm12'),
(43, 'cm21'),
(44, 'cm22'),
(45, 'cm31'),
(46, 'cm32'),
(47, 'cm33'),
(48, 'cm41'),
(49, 'cm42'),
(50, 'ECV'),
(51, 'M411'),
(52, 'M412'),
(53, 'M415'),
(54, 'M416'),
(55, 'M453'),
(56, 'M454'),
(57, 'Prof.'),
(58, 'M417'),
(60, '3L7');

-- --------------------------------------------------------

--
-- Structure de la table `t_equipe`
--

DROP TABLE IF EXISTS `t_equipe`;
CREATE TABLE IF NOT EXISTS `t_equipe` (
  `pk_equipe` int(11) NOT NULL AUTO_INCREMENT,
  `nom_equipe` varchar(45) DEFAULT NULL,
  `fk_groupe` int(11) NOT NULL,
  `bonus_equipe` int(11) DEFAULT '0',
  PRIMARY KEY (`pk_equipe`),
  KEY `fk_t_equipe_t_groupe1` (`fk_groupe`)
) ENGINE=InnoDB AUTO_INCREMENT=12021 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_equipe`
--

INSERT INTO `t_equipe` (`pk_equipe`, `nom_equipe`, `fk_groupe`, `bonus_equipe`) VALUES
(66, 'Wild Student', 17, 0),
(67, 'Patrick’s team', 17, 0),
(68, 'Les 2L1-3-5', 17, 0),
(69, 'Colin et les 7 nains', 17, 0),
(70, 'Les fillettes', 18, 0),
(71, 'Sweeties', 18, 0),
(73, 'Les espagnols', 18, 0),
(74, 'Oh die Blondi dert äne ', 20, 0),
(75, 'Gangnam Style', 20, 0),
(76, 'T’es énervé !', 20, 0),
(77, 'UHC 1L4', 20, 0),
(78, 'Scol’As', 19, 0),
(79, 'La main plantée', 20, 0),
(80, 'Skeletor', 19, 0),
(81, 'Bras cassé', 19, 0),
(84, 'Les Gratte-claviers', 17, 0),
(85, 'Papi Chulo', 18, 0),
(86, 'Black Duck', 19, 0),
(87, 'La bénichon', 19, 0),
(88, 'Les 4824', 21, 0),
(89, 'Stroumpflala', 22, 0),
(90, 'Mem-Show-Kuz', 21, 0),
(91, '1000 balles si vous nous battez', 21, 0),
(92, 'La Forche', 22, 0),
(93, 'Les On s\'en fout', 22, 0),
(94, 'West coast', 22, 0),
(95, 'All star junior', 21, 0),
(101, 'REDBULL', 24, 0),
(103, 'Les RHINOS', 26, 0),
(109, 'Les petits culs d\'acier', 35, 0),
(110, 'Les exterminateurs', 31, 0),
(111, 'Scol\'As', 31, 0),
(120, 'Et une caisse de bière  pour la 416', 35, 0),
(121, '2L4', 35, 0),
(124, 'les artistes', 35, 0),
(125, 'Tâlut', 31, 0),
(128, 'Wehityourgoal', 31, 0),
(130, 'Les Bismuth', 31, 0),
(134, 'Rhinos', 35, 0),
(137, 'Dirty Boys', 35, 0),
(138, 'mutige obdachlos ', 31, 0),
(139, 'Schaller Guillaume', 36, -49),
(142, 'Schaller Alain', 36, 60),
(143, 'Clerc Thomas', 36, 52),
(144, 'Studer Nicolas', 36, 35),
(145, 'Riat Fiona', 36, -28),
(146, 'Jelinski Nils', 36, -20),
(147, 'Waeber Laurent', 36, 69),
(148, 'Spat Philippe', 36, -72),
(149, 'Fasel Olivier', 36, -75),
(150, 'Pasquier Julien', 36, 45),
(151, 'Kieu Nguyen Bao', 36, 0),
(152, 'Goetschi Thibaut', 36, 13),
(153, 'Dévaud Guillaume', 36, -30),
(154, 'Team Jaquie & Michel', 37, 0),
(155, 'Les Paccotiers', 37, 0),
(156, '1A-KUNA MATATA', 37, 0),
(157, 'OGC', 37, 0),
(158, 'Le corps en saignant', 37, 0),
(159, 'Les Brazzers de boule', 37, 0),
(160, 'M415', 37, 0),
(161, '\"#Les fils de la Louve\"', 38, 0),
(162, 'Brazzers de boules', 38, 0),
(163, 'Fc Jaquie et Michel', 38, 0),
(164, 'Les guypascaux', 38, 0),
(165, 'OKLM', 38, 0),
(166, 'FC Chuchichästli', 39, 0),
(167, 'Les Galactiques', 39, 0),
(168, 'Les Matures ', 39, 0),
(169, 'Fc Grosse Frappe', 39, 0),
(170, 'Lord Bendtner', 39, 0),
(176, 'les bilingues', 38, 0),
(207, 'HAKUNA MATATA', 46, 0),
(208, 'Les Quepeds', 46, 0),
(209, 'Les bouts de bois ', 46, 0),
(210, 'Chuchichäschtli', 45, 0),
(211, '2A', 45, 0),
(212, 'Le corps en saignant', 45, 0),
(213, 'M453', 45, 0),
(214, 'Error 404', 46, 0),
(215, '415', 45, 0),
(12004, 'Clerc_Thomas', 1002, 0),
(12005, 'nogueira_roberto', 1002, 0),
(12006, 'Loosli_Pius', 1002, 0),
(12007, 'Nguyen_Dang_Khoa', 1002, 0),
(12008, 'Waeber_Laurent', 1003, 0),
(12009, 'jacquat_jonathan', 1003, 0),
(12010, 'Gremaud­_Romain', 1003, 0),
(12011, 'Schaller_Guillaume', 1003, 0),
(12012, 'rossier_jérémie', 1004, 0),
(12013, 'Julien_Pasquier', 1004, 0),
(12014, 'Gurtner_Maxime', 1004, 0),
(12015, 'biolley_valentin', 1004, 0),
(12016, 'Dafflon_Léo', 1005, 0),
(12017, 'Kolly_Gérald', 1005, 0),
(12018, 'clément_maxime', 1005, 0),
(12019, 'studer_nicolas', 1005, 0),
(12020, 'Jelinski_Nils', 1005, 0);

-- --------------------------------------------------------

--
-- Structure de la table `t_equipetransition`
--

DROP TABLE IF EXISTS `t_equipetransition`;
CREATE TABLE IF NOT EXISTS `t_equipetransition` (
  `pk_equipeTransition` int(11) NOT NULL AUTO_INCREMENT,
  `nom_equipeTransition` varchar(45) NOT NULL,
  `email_responsable` varchar(45) NOT NULL,
  `valide` tinyint(1) NOT NULL,
  `mdp` varchar(45) NOT NULL,
  PRIMARY KEY (`pk_equipeTransition`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `t_groupe`
--

DROP TABLE IF EXISTS `t_groupe`;
CREATE TABLE IF NOT EXISTS `t_groupe` (
  `pk_groupe` int(11) NOT NULL AUTO_INCREMENT,
  `nom_groupe` varchar(45) DEFAULT NULL,
  `fk_tournoi` int(11) NOT NULL,
  PRIMARY KEY (`pk_groupe`),
  KEY `fk_t_groupe_t_tournoi1` (`fk_tournoi`)
) ENGINE=InnoDB AUTO_INCREMENT=1006 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_groupe`
--

INSERT INTO `t_groupe` (`pk_groupe`, `nom_groupe`, `fk_tournoi`) VALUES
(31, 'A', 11),
(35, 'B', 11),
(37, 'Groupe A', 13),
(38, 'A', 14),
(39, 'B', 14),
(40, 'Groupe A', 15),
(45, 'A', 17),
(46, 'B', 17),
(1002, 'Groupe A', 18),
(1003, 'Groupe B', 18),
(1004, 'Groupe C', 18),
(1005, 'Groupe D', 18);

-- --------------------------------------------------------

--
-- Structure de la table `t_joueur`
--

DROP TABLE IF EXISTS `t_joueur`;
CREATE TABLE IF NOT EXISTS `t_joueur` (
  `pk_joueur` int(11) NOT NULL AUTO_INCREMENT,
  `nom_joueur` varchar(45) DEFAULT NULL,
  `prenom_joueur` varchar(45) DEFAULT NULL,
  `fk_classe` int(11) DEFAULT NULL,
  `fk_equipe` int(11) NOT NULL,
  PRIMARY KEY (`pk_joueur`),
  KEY `fk_t_joueur_t_classe1` (`fk_classe`),
  KEY `fk_t_joueur_t_equipe1` (`fk_equipe`)
) ENGINE=InnoDB AUTO_INCREMENT=1024 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_joueur`
--

INSERT INTO `t_joueur` (`pk_joueur`, `nom_joueur`, `prenom_joueur`, `fk_classe`, `fk_equipe`) VALUES
(123, 'Davet', 'Josua', 51, 66),
(124, 'Genoud', 'Valérie', 51, 66),
(125, 'Nicolet', 'Vincent', 51, 66),
(126, 'Gaillard', 'Nicolas', 51, 66),
(127, 'Bonneville', 'Quentin', 51, 66),
(128, 'Pache', 'Marius', 51, 66),
(129, 'Pillonel', 'Simon', 51, 66),
(130, 'Perler', 'Vincent', 51, 66),
(131, 'Schaller', 'Thomas', 31, 67),
(132, 'Monney', 'Bastien', 31, 67),
(133, 'Jordan', 'Valentin', 31, 67),
(134, 'Raboud', 'Martin', 31, 67),
(135, 'Lambert', 'Maxime', 31, 67),
(136, 'Demierre', 'Christophe', 31, 67),
(137, 'Guélat', 'Quentin', 31, 67),
(138, 'Overney', 'Paul', 17, 68),
(139, 'Rial', 'Jonathan', 17, 68),
(140, 'Rüeger', 'Tristan', 17, 68),
(141, 'Rolle', 'Jérémy', 19, 68),
(142, 'Stoeckli', 'Jonas', 21, 68),
(143, 'Zamofing', 'Rémi', 1, 69),
(144, 'Rosset', 'Denis', 1, 69),
(145, 'Waeber', 'Gilles', 1, 69),
(146, 'Pasquier', 'Colin', 1, 69),
(147, 'Longchamp', 'Yannick', 1, 69),
(149, 'Savioz', 'Loïc', 1, 69),
(150, 'Garcia', 'Daniel', 52, 70),
(151, 'Equey', 'Jérémie', 52, 70),
(152, 'Repend', 'Benoît', 52, 70),
(153, 'Brügger', 'Jérémy', 52, 70),
(154, 'Guisolan', 'Alain', 52, 70),
(155, 'Berger', 'Adrien', 52, 70),
(156, 'Paiva Pinto', 'Marcio', 52, 70),
(157, 'Hyseni', 'Pajtim', 52, 70),
(158, 'Neuhaus', 'Vincent', 52, 70),
(159, 'Schaller', 'Alain', 34, 71),
(160, 'Savic', 'Dragan', 34, 71),
(161, 'Wenger', 'Roland', 34, 71),
(162, 'Sueur', 'Alain', 34, 71),
(163, 'Nguyen', 'Dang Khoa', 20, 72),
(164, 'Roubaty', 'Marc', 20, 72),
(165, 'Zahno', 'Yann', 20, 72),
(166, 'Chassot', 'Romain', 20, 72),
(167, 'Butty', 'Antoine', 20, 72),
(168, 'Horner', 'Maxime', 20, 72),
(169, 'Hemmer', 'Lucien', 6, 73),
(170, 'Martins Leitao', 'Claudio', 6, 73),
(171, 'Gremaud', 'Joseph', 6, 73),
(172, 'Manixab', 'Kevin', 6, 73),
(173, 'Ferrari', 'Massimo', 6, 73),
(174, 'Mauron', 'Nicolas', 6, 73),
(175, 'Clément', 'Martin', 6, 73),
(176, 'Huber', 'Benjamin', 56, 74),
(177, 'Zysset', 'Maurice', 56, 74),
(178, 'Kessler', 'Phillip', 56, 74),
(179, 'Schaller', 'Sebastian', 56, 74),
(180, 'Blanchard', 'Fabian', 55, 74),
(181, 'Grüenig', 'Jeffrey', 56, 74),
(182, 'Scholl', 'Sandro', 56, 74),
(183, 'Senn', 'Joana', 56, 74),
(184, 'Helfer', 'Florian', 33, 75),
(185, 'Djoric', 'Ivan', 33, 75),
(186, 'Bruchez', 'Gary', 33, 75),
(187, 'Tschopp', 'Bruno', 29, 75),
(188, 'Aebischer', 'Lenny', 29, 75),
(189, 'Pirlet', 'Quentin', 29, 75),
(190, 'Konrad', 'Johannes', 23, 76),
(191, 'Roubaty', 'Fabrice', 23, 76),
(192, 'Weissbaum', 'Christophe', 23, 76),
(193, 'Monney', 'César', 23, 76),
(195, 'Januth', 'Laurin', 23, 76),
(196, 'Fasel', 'Olivier', 23, 76),
(200, 'Wisler', 'François', 8, 77),
(201, 'Vaucher', 'Romain', 8, 77),
(202, 'Ursenbacher', 'Tyll', 8, 77),
(203, 'Schwartz', 'Raphaël', 8, 77),
(204, 'Schröder', 'Yannick', 8, 77),
(205, 'Torche', 'Samuel', 8, 77),
(206, 'Sabatino', 'Fabio', 8, 77),
(207, 'Clerc', 'Thomas', 57, 78),
(208, 'Galley', 'Christophe', 57, 78),
(209, 'Pasquier', 'Julien', 57, 78),
(210, 'Studer', 'Nicolas', 57, 78),
(211, 'Bielmann', 'David', 57, 78),
(212, 'Butty', 'Joé', 18, 79),
(213, 'Di Via', 'Nicolas', 18, 79),
(214, 'Bürgy', 'Louis', 18, 79),
(215, 'Henrieu', 'Yannick', 18, 79),
(216, 'Hilringshaus', 'Lucas', 18, 79),
(217, 'Puthod', 'Loïc', 18, 79),
(218, 'Mauron', 'Jocelyn', 7, 80),
(219, 'Mèller', 'Dylan', 7, 80),
(220, 'Saugy', 'Florent', 7, 80),
(221, 'Pereira Barros', 'Orlando', 7, 80),
(222, 'Pauchard', 'Lucas', 7, 80),
(223, 'Oertle', 'Jimmy', 7, 80),
(224, 'Pittet', 'Raphaël', 7, 80),
(225, 'Santos Ramos', 'Alexandre', 7, 80),
(226, 'Marions', 'Thomas', 7, 80),
(227, 'Mettraux', 'Axel', 7, 80),
(228, 'Brülhardt', 'Sébastien', 5, 81),
(229, 'Feyer', 'Nicolas', 5, 81),
(230, 'Andrey', 'Lucas', 5, 81),
(231, 'Amirthalingam', 'Anoryan', 5, 81),
(232, 'Bulliard', 'Steven', 5, 81),
(234, 'Marro', 'Thomas', 57, 84),
(235, 'Chatagny', 'Laurent', 57, 84),
(236, 'Mettraux', 'Pierre-Alain', 57, 84),
(237, 'Neuhaus', 'Olivier', 57, 84),
(238, 'Waeber', 'Laurent', 57, 84),
(239, 'Ciampone', 'Adrien', 57, 84),
(240, 'Pasquier', 'Julien', 57, 84),
(241, 'Hohl', 'Jonathan', 53, 85),
(242, 'Julmy', 'Steve', 53, 85),
(243, 'Seydoux', 'Maxime', 53, 85),
(244, 'Piller', 'Jérémy', 53, 85),
(245, 'Kelmendi', 'Shpetim', 53, 85),
(246, 'Lizzola', 'Nathan', 53, 85),
(247, 'Geoffrey', 'Geneviève', 53, 86),
(248, 'Stettler', 'Kevin', 53, 86),
(249, 'Burkhard', 'Florian', 53, 86),
(250, 'Ulukütük', 'Serkam', 53, 86),
(251, 'Dos Santos', 'Patrick', 53, 86),
(252, 'Anstett', 'Thierry', 53, 86),
(253, 'Compagnon', 'Dimitri', 22, 87),
(254, 'Peisl', 'Adrien', 22, 87),
(255, 'Pittet', 'Nicolas', 22, 87),
(256, 'Varenne', 'Baptiste', 22, 87),
(257, 'Wenger', 'Olivier', 55, 74),
(258, 'Solliard', 'Caroline', 57, 78),
(259, 'Kohli', 'Isabelle', 57, 78),
(260, 'Grillon', 'Sébastien', 57, 78),
(261, 'Buchler', 'Claude', 57, 78),
(262, 'Carrel', 'François', 57, 78),
(264, 'Berthoud', 'Tristan', 33, 71),
(265, 'Schenker', 'Frédéric', 29, 88),
(266, 'Aebischer', 'Lenny', 29, 88),
(267, 'Pirlet', 'Quentin', 29, 88),
(268, 'Folly', 'Loïc', 29, 88),
(269, 'Gremaud', 'Joseph', 6, 89),
(270, 'Savioz', 'Loïc', 6, 89),
(271, 'Ferrari', 'Massimo', 6, 89),
(272, 'Martins Leitao', 'claudio', 6, 89),
(273, 'Manixab', 'Kevin', 6, 89),
(274, 'Lathemann', 'Nicolas', 6, 89),
(275, 'Stauffer', 'Damien', 19, 91),
(276, 'Albuquerque', 'Danny', 19, 91),
(277, 'Dessonnaz', 'Alexandre', 19, 91),
(278, 'Zayani', 'Karim', 19, 91),
(279, 'Perrottet', 'Luke', 19, 91),
(280, 'Fortunato Portela', 'Ricardo', 17, 92),
(281, 'Vallat', 'Matthieu', 20, 92),
(282, 'Zeidguy', 'Nassim', 21, 92),
(283, 'Overney', 'Paul', 17, 92),
(284, 'varenne', 'Baptiste', 17, 92),
(285, 'Albertini', 'Floriano', 33, 93),
(286, 'Studemann', 'Julien', 33, 93),
(287, 'Müller', 'Thomas', 33, 93),
(288, 'Amirthalingam', 'Anoryan', 5, 90),
(289, 'Gay', 'Jordan', 5, 90),
(290, 'Gonçalves', 'Joël', 5, 90),
(291, 'Brülhardt', 'Sébastien', 5, 90),
(292, 'Almeida', 'Bruno', 5, 90),
(293, 'Julmy', 'Steve', 53, 94),
(294, 'Dos Santos', 'Patrick', 53, 94),
(295, 'Stettler', 'Kevin', 53, 94),
(296, 'Richoz', 'Morgan', 53, 94),
(297, 'Geneviève', 'Geoffrey', 53, 95),
(298, 'Weissbrodt', 'Jean-Philippe', 53, 95),
(299, 'Ulukütük', 'Serkam', 53, 95),
(300, 'Kelmendi', 'Shpetim', 53, 95),
(301, 'Lizzola', 'Nathan', 53, 95),
(302, 'Bruchez', 'Gary', 7, 96),
(303, 'Mike', 'Zaroual', 7, 96),
(304, 'Bruchez', 'Gary', 7, 97),
(305, 'Mike', 'Zaroual', 7, 97),
(306, 'Bruchez', 'Gary', 7, 98),
(307, 'Mike', 'Zaroual', 7, 98),
(308, 'Bruchez', 'Gary', 7, 99),
(309, 'Mike', 'Zaroual', 7, 99),
(310, 'Bruchez', 'Gary', 7, 100),
(311, 'Mike', 'Zaroual', 7, 100),
(312, 'Bruchez', 'Gary', 7, 101),
(313, 'Mike', 'Zaroual', 7, 101),
(314, 'Bruchez', 'Gary', 7, 102),
(315, 'Mike', 'Zaroual', 7, 102),
(316, 'Coquoz', 'Eloi', 1, 103),
(317, 'Coquoz', 'Eloi', 1, 103),
(318, 'Jelinski', 'Arnaud', 1, 103),
(319, 'Hauser', 'Vincent', 1, 103),
(320, 'Crausaz', 'Nicolas', 1, 103),
(321, 'Vonlhanten', 'Damien', 1, 103),
(322, 'Coquoz', 'Eloi', 1, 105),
(323, 'Hauser', 'Vincent', 1, 105),
(324, 'Crausaz', 'Nicolas', 1, 105),
(325, 'Jelinski', 'Arnaud', 1, 105),
(326, 'Magnin', 'Vincent', 1, 105),
(327, 'Coquoz', 'Eloi', 1, 106),
(328, 'Hauser', 'Vincent', 1, 106),
(329, 'Crausaz', 'Nicolas', 1, 106),
(330, 'Jelinski', 'Arnaud', 1, 106),
(331, 'Magnin', 'Vincent', 1, 106),
(332, 'Coquoz', 'Eloi', 1, 107),
(333, 'Hauser', 'Vincent', 1, 107),
(334, 'Crausaz', 'Nicolas', 1, 107),
(335, 'Jelinski', 'Arnaud', 1, 107),
(336, 'Magnin', 'Vincent', 1, 107),
(337, 'Coquoz', 'Eloi', 1, 108),
(338, 'Hauser', 'Vincent', 1, 108),
(339, 'Crausaz', 'Nicolas', 1, 108),
(340, 'Jelinski', 'Arnaud', 1, 108),
(341, 'Magnin', 'Vincent', 1, 108),
(342, 'Jelinski', 'Nils', 6, 109),
(343, 'Nissile', 'Maxime', 6, 109),
(344, 'Favre', 'Alexandre', 6, 109),
(345, 'Roubatti', 'Loris', 6, 109),
(346, 'Suard', 'Anthony', 6, 109),
(347, 'Bartucs', 'Alan', 6, 109),
(348, 'Defferard', 'Laurent', 6, 109),
(349, 'Gay', 'Simon', 6, 109),
(350, 'Pereira Barros', 'Orlando', 19, 110),
(351, 'Bürgy', 'Louis', 19, 110),
(352, 'Mauron', 'Jocelyn', 19, 110),
(353, 'Müller', 'Dylan', 19, 110),
(354, 'Pauchard', 'Lucas', 19, 110),
(355, 'Oertle', 'Jimmy', 19, 110),
(357, 'Coquoz', 'Eloi', 1, 112),
(358, 'Vial', 'Tanguy', 54, 113),
(359, 'Hauser', 'Vincent', 1, 112),
(360, 'Crausaz', 'Nicolas', 1, 112),
(361, 'Huwiler', 'Blaise', 54, 113),
(362, 'Jelinski', 'Arnaud', 1, 112),
(363, 'Folly', 'Justin', 54, 113),
(364, 'Magnin', 'Vincent', 1, 112),
(365, 'Duerst', 'Yannick', 54, 113),
(366, 'Kreienbuhl', 'Dann', 54, 113),
(367, 'Corpataux', 'Luca', 54, 113),
(368, 'Kaster', 'Jeremy', 54, 113),
(369, 'Gobet', 'Julien', 54, 113),
(370, 'Waeber', 'Gilles', 20, 114),
(371, 'Vaucher', 'Romain', 20, 114),
(372, 'Schröder', 'Yannick', 20, 114),
(373, 'Wisler', 'François', 20, 114),
(374, 'Ursenbacher', 'Tyll', 20, 114),
(375, 'Torche', 'Samuel', 20, 114),
(376, 'Zamofing', 'Rémi', 20, 114),
(377, 'Waeber', 'Gilles', 20, 115),
(378, 'Vaucher', 'Romain', 20, 115),
(379, 'Schröder', 'Yannick', 20, 115),
(380, 'Wisler', 'François', 20, 115),
(381, 'Ursenbacher', 'Tyll', 20, 115),
(382, 'Torche', 'Samuel', 20, 115),
(383, 'Zamofing', 'Rémi', 20, 115),
(384, 'Vial', 'Tanguy', 54, 116),
(385, 'Huwiler', 'Blaise', 54, 116),
(386, 'Folly', 'Justin', 54, 116),
(387, 'Duerst', 'Yannick', 54, 116),
(388, 'Kreienbuhl', 'Dann', 54, 116),
(389, 'Corpataux', 'Luca', 54, 116),
(390, 'Kaster', 'Jeremy', 54, 116),
(391, 'Gobet', 'Julien', 54, 116),
(392, 'Coquoz', 'Eloi', 1, 117),
(393, 'Hauser', 'Vincent', 1, 117),
(394, 'Crausaz', 'Nicolas', 1, 117),
(395, 'Jelinski', 'Arnaud', 1, 117),
(396, 'Magnin', 'Vincent', 1, 117),
(397, 'Coquoz', 'Eloi', 1, 118),
(398, 'Vial', 'Tanguy', 54, 119),
(399, 'Hauser', 'Vincent', 1, 118),
(400, 'Crausaz', 'Nicolas', 1, 118),
(401, 'Huwiler', 'Blaise', 54, 119),
(402, 'Jelinski', 'Arnaud', 1, 118),
(403, 'Folly', 'Justin', 54, 119),
(404, 'Magnin', 'Vincent', 1, 118),
(405, 'Duerst', 'Yannick', 54, 119),
(406, 'Kreienbuhl', 'Dann', 54, 119),
(407, 'Corpataux', 'Luca', 54, 119),
(408, 'Kaster', 'Jeremy', 54, 119),
(409, 'Gobet', 'Julien', 54, 119),
(410, 'Vial', 'Tanguy', 54, 120),
(411, 'Coquoz', 'Eloi', 1, 122),
(412, 'Waeber', 'Gilles', 20, 121),
(413, 'Huwiler', 'Blaise', 54, 120),
(414, 'Folly', 'Justin', 54, 120),
(415, 'Vaucher', 'Romain', 20, 121),
(416, 'Hauser', 'Vincent', 1, 122),
(417, 'Duerst', 'Yannick', 54, 120),
(418, 'Schröder', 'Yannick', 20, 121),
(419, 'Crausaz', 'Nicolas', 1, 122),
(420, 'Kreienbuhl', 'Dann', 54, 120),
(421, 'Wisler', 'François', 20, 121),
(422, 'Corpataux', 'Luca', 54, 120),
(423, 'Jelinski', 'Arnaud', 1, 122),
(424, 'Ursenbacher', 'Tyll', 20, 121),
(425, 'Kaster', 'Jeremy', 54, 120),
(426, 'Torche', 'Samuel', 20, 121),
(427, 'Magnin', 'Vincent', 1, 122),
(428, 'Gobet', 'Julien', 54, 120),
(429, 'Zamofing', 'Rémi', 20, 121),
(430, 'Compagnon', 'Dimitri', 34, 125),
(432, 'Stucki', 'Alain', 34, 125),
(433, 'Weissbaum', 'Christophe', 25, 125),
(434, 'Roubaty', 'Fabrice', 26, 125),
(435, 'Bouquet', 'Sebastien', 27, 125),
(436, 'Dauwalder', 'Kelvin', 10, 128),
(438, 'Lipp', 'Lorenz', 10, 128),
(439, 'Freiburghaus', 'Loïc', 10, 128),
(440, 'Krummen', 'Jan', 10, 128),
(441, 'Bezborotko', 'Dmitro', 10, 128),
(442, 'Dauwalder', 'Kelvin', 10, 129),
(443, 'Dauwalder', 'Kelvin', 10, 129),
(444, 'Lipp', 'Lorenz', 10, 129),
(445, 'Freiburghaus', 'Loïc', 10, 129),
(446, 'Krummen', 'Jan', 10, 129),
(447, 'Bezborotko', 'Dmitro', 10, 129),
(448, 'Rolle', 'Jérémy', 31, 130),
(449, 'Overney ', 'Paul', 27, 130),
(450, 'Stoeckli', 'Jonas', 33, 130),
(451, 'Varenne ', 'Baptiste', 27, 130),
(452, 'Jaquet', 'Landry', 28, 130),
(453, 'Rüeger', 'Tristan', 33, 130),
(455, 'Pereira Barros', 'Orlando', 19, 131),
(456, 'Dauwalder', 'Kelvin', 10, 133),
(457, 'Bürgy', 'Louis', 19, 131),
(458, 'Compagnon', 'Dimitri', 34, 135),
(459, 'Coquoz', 'Eloi', 1, 134),
(460, 'Dauwalder', 'Kelvin', 10, 133),
(461, 'Mauron', 'Jocelyn', 19, 131),
(462, 'Lipp', 'Lorenz', 10, 133),
(463, 'Hauser', 'Vincent', 1, 134),
(464, 'Compagnon', 'Dimitri', 34, 135),
(465, 'Müller', 'Dylan', 19, 131),
(466, 'Freiburghaus', 'Loïc', 10, 133),
(467, 'Crausaz', 'Nicolas', 1, 134),
(468, 'Pauchard', 'Lucas', 19, 131),
(469, 'Stucki', 'Alain', 34, 135),
(470, 'Krummen', 'Jan', 10, 133),
(471, 'Weissbaum', 'Christophe', 25, 135),
(472, 'Oertle', 'Jimmy', 19, 131),
(473, 'Jelinski', 'Arnaud', 1, 134),
(474, 'Bezborotko', 'Dmitro', 10, 133),
(475, 'Roubaty', 'Fabrice', 26, 135),
(476, 'Magnin', 'Vincent', 1, 134),
(477, 'Bürgy', 'Louis', 19, 131),
(478, 'Bouquet', 'Sebastien', 27, 135),
(479, 'Waeber', 'Gilles', 20, 136),
(483, 'Vaucher', 'Romain', 20, 136),
(486, 'Schröder', 'Yannick', 20, 136),
(490, 'Wisler', 'François', 20, 136),
(492, 'Ursenbacher', 'Tyll', 20, 136),
(496, 'Torche', 'Samuel', 20, 136),
(498, 'Zamofing', 'Rémi', 20, 136),
(502, 'Studer', 'Nicolas', 57, 111),
(503, 'Prof2', 'Prof2', 57, 111),
(504, 'Prof4', 'Prof4', 57, 111),
(505, 'Prof3', 'Prof3', 57, 111),
(506, 'Dumas', 'Jason', 8, 124),
(507, 'magnin', 'Vincent', 8, 124),
(508, 'Monney', 'Xavier', 8, 124),
(509, 'Nguyen', 'Dang Khoa', 32, 137),
(510, 'Roubaty', 'Marc', 32, 137),
(511, 'Zahno', 'Yann', 32, 137),
(512, 'overney', 'loris', 53, 138),
(513, 'ciampone ', 'adrien', 53, 138),
(514, 'goetschi ', 'thibaud', 53, 138),
(515, 'gremaud ', 'kevin', 53, 138),
(516, 'brugger ', 'benjamin', 53, 138),
(517, 'guerry ', 'baptiste', 53, 138),
(518, 'sauteur ', 'sandrine', 53, 138),
(519, 'Schaller', 'Guilaume', 5, 139),
(520, 'Schaller', 'Alain', 38, 142),
(521, 'Clerc', 'Thomas', 57, 143),
(522, 'Studer', 'Nicolas', 57, 144),
(523, 'Riat', 'Fiona', 42, 145),
(524, 'Jelinski', 'Nils', 6, 146),
(525, 'Waeber', 'Laurent', 57, 147),
(526, 'Spat', 'Philippe', 34, 148),
(527, 'Fasel', 'Olivier', 60, 149),
(528, 'Pasquier', 'Julien', 57, 150),
(529, 'Kieu Nguyen', 'Bao', 23, 151),
(530, 'Goetschi', 'Thibaut', 53, 152),
(531, 'Dévaud', 'Guillaume', 6, 153),
(532, 'Pittet', 'Marco', 54, 154),
(533, 'Ramos', 'Joel', 54, 154),
(534, 'Gugler', 'Karim', 54, 154),
(535, 'Rumo', 'Cyril', 54, 154),
(536, 'Helfer', 'Florian', 54, 154),
(537, 'Lauper', 'Mathias', 54, 154),
(538, 'Mabboux', 'Johnatan', 54, 154),
(539, 'Defferard', 'Arnaud', 3, 156),
(540, 'Juillerat', 'Antoine', 3, 156),
(541, 'Simonet', 'Antoine', 3, 156),
(542, 'Blanc', 'Bastian', 3, 156),
(543, 'Rohrer ', 'Bastian', 3, 156),
(544, 'Rosat ', 'Cedric', 3, 156),
(545, 'Meier', 'Dominik', 3, 156),
(546, 'Vuagniaux', 'Jérôme', 3, 156),
(547, 'Manixab', 'Kevin', 30, 157),
(548, 'Clerc', 'Thomas', 57, 158),
(549, 'Leitao ', 'Claudio', 30, 157),
(550, 'Marro', 'Thomas', 57, 158),
(551, 'Gilliéron', 'Florent', 53, 160),
(552, 'Page', 'Max', 19, 159),
(553, 'Torche', 'Samuel', 32, 157),
(554, 'Vouardoux', 'Grégory', 57, 158),
(555, 'Jordan', 'Olivier', 53, 160),
(556, 'Jelinski', 'Arnaud', 15, 159),
(557, 'Hertling', 'Arnaud', 30, 157),
(558, 'Jonathan', 'Marcucci', 53, 160),
(559, 'Galley', 'Christophe', 57, 158),
(560, 'Corpataux', 'Sam', 15, 159),
(561, 'Gremaud', 'Romain', 30, 157),
(562, 'Studer', 'Nicolas', 57, 158),
(563, 'Damien', 'Ecoffey', 53, 160),
(564, 'Roubaty', 'Loris', 15, 159),
(565, 'Ferrari', 'Massimo', 30, 157),
(566, 'Carrel', 'François', 57, 158),
(567, 'Crausaz', 'Nicolas', 15, 159),
(568, 'Clement', 'Martin', 30, 157),
(569, 'Bielmann', 'David', 57, 158),
(570, 'Sébastien', 'Vorlet', 53, 160),
(571, 'Carvalho', 'David', 30, 157),
(572, 'Hauser', 'Vincent', 15, 159),
(573, 'André', 'Grillo Carvalho', 53, 160),
(574, 'Vincent', 'Roggo', 53, 160),
(575, 'Coquoz', 'Eloi', 15, 159),
(592, 'Hillring', 'Lukas', 39, 164),
(626, 'Butty', 'Joé', 39, 171),
(646, 'Marcucci aka \"Le tailleur\"', 'Jonathan', 53, 161),
(647, 'Jordan aka \"Benito\"', 'Olivier', 53, 161),
(648, 'Bochud aka \" Le Blanc\"', 'Frank', 53, 161),
(649, 'Grilo Carvalho aka \"47\"', 'André', 53, 161),
(650, 'Gilliéron', 'Florent', 53, 161),
(651, 'Jurado aka \"Viet\"', 'Daniel', 53, 161),
(652, 'Wolleb aka \"World Cup\"', 'Baptiste', 53, 161),
(653, 'Ecoffey aka \"Bismark\"', 'Damien', 53, 161),
(654, 'Jelinski', 'Arnaud', 21, 162),
(655, 'Page', 'Max', 19, 162),
(656, 'Gugler', 'Karim', 54, 163),
(657, 'Hauser', 'Vincent', 15, 162),
(659, 'Roubaty', 'Loris', 15, 162),
(660, 'Pittet', 'Marco', 54, 163),
(661, 'Romano', 'Anthony', 15, 162),
(662, 'Ramos', 'Joel', 54, 163),
(663, 'Cohu', 'Remy', 15, 162),
(664, 'Rito', 'Jérôme', 54, 163),
(665, 'Magnin', 'Vincent', 15, 162),
(666, 'Eggertswyler', 'Lucien', 54, 163),
(667, 'Favre', 'Alexandre', 15, 162),
(668, 'Rumo ', 'Cyril', 54, 163),
(669, 'Lauper', 'Matthias', 54, 163),
(670, 'Butty', 'Joé', 39, 164),
(671, 'Ljamalari', 'Sabaudin', 19, 165),
(672, 'Chassot', 'Romain', 39, 164),
(674, 'Sallin', 'Lucas', 39, 164),
(675, 'Osman', 'Salah', 20, 165),
(676, 'Perrottet', 'Luke', 39, 164),
(677, 'Ozturk', 'Velat', 18, 165),
(678, 'Albuquerque', 'Danny', 39, 164),
(679, 'Bueshler', 'Alexandre', 20, 165),
(680, 'Alborghetti', 'Lucas', 39, 164),
(681, 'Alan ', 'Ducimetière', 19, 165),
(682, 'Firat', 'Cemali', 39, 164),
(683, 'Corpateaux', 'Sam', 20, 165),
(684, 'Doudin', 'Yann', 39, 164),
(685, 'Goncalves', 'Joel', 17, 167),
(686, 'Pittet', 'Arnaud', 52, 168),
(688, 'Guillaume ', 'Pillonel', 52, 168),
(689, 'Bartucz', 'Alan', 21, 167),
(690, 'Danijel ', 'Horvat', 52, 168),
(691, 'Adilson', 'Riquelme', 17, 167),
(692, 'Johnatan', 'Kilchoer', 52, 168),
(693, 'Nicolas', 'Crausaz', 15, 167),
(694, 'Schaller', 'Guillaume', 7, 169),
(695, 'Livio', 'Chiorazzo', 52, 168),
(696, 'Repond', 'Jean', 33, 170),
(697, 'Zaroual', 'Ahmed', 15, 167),
(698, 'Aslani ', 'Lirim', 5, 169),
(699, 'Nathalie ', 'Bovigny', 52, 168),
(700, 'Grilo Carvalho', 'David', 30, 170),
(701, 'Kuci', 'Dilan', 17, 167),
(702, 'Hassan', 'Faysal', 5, 169),
(703, 'Pauchard', 'Lucas', 31, 170),
(704, 'Olivier ', 'Wenger', 52, 168),
(705, 'Eloi', 'Coquoz', 18, 167),
(706, 'Morina', 'Arbnor', 5, 169),
(707, 'Laurent ', 'Hey', 52, 168),
(708, 'Mauron', 'Jocelyn', 31, 170),
(709, 'Rohrer', 'Bastian', 7, 169),
(710, 'Zamofing', 'Rémi', 32, 170),
(711, 'Tran', 'Minh Phuc', 7, 169),
(712, 'Schaller', 'Guillaume', 7, 169),
(713, 'Vaucher', 'Romain', 32, 170),
(714, 'Marcucci aka \"Le tailleur\"', 'Jonathan', 53, 171),
(715, 'Jordan aka \"Benito\"', 'Olivier', 53, 171),
(716, 'Bochud aka \" Le Blanc\"', 'Frank', 53, 171),
(717, 'Grilo Carvalho aka \"47\"', 'André', 53, 171),
(718, 'Gilliéron', 'Florent', 53, 171),
(719, 'Jurado aka \"Viet\"', 'Daniel', 53, 171),
(720, 'Wolleb aka \"World Cup\"', 'Baptiste', 53, 171),
(721, 'Ecoffey aka \"Bismark\"', 'Damien', 53, 171),
(723, 'Gugler', 'Karim', 54, 173),
(725, 'Jelinski', 'Arnaud', 21, 174),
(726, 'Ljamalari', 'Sabaudin', 19, 175),
(729, 'Page', 'Max', 19, 174),
(730, 'Ljamalari ', 'Sabaudin', 19, 175),
(731, 'Pittet', 'Marco', 54, 173),
(733, 'Hauser', 'Vincent', 15, 174),
(734, 'Osman', 'Salah', 20, 175),
(735, 'Ramos', 'Joel', 54, 173),
(737, 'Roubaty', 'Loris', 15, 174),
(738, 'Ozturk', 'Velat', 18, 175),
(739, 'Rito', 'Jérôme', 54, 173),
(740, 'Romano', 'Anthony', 15, 174),
(742, 'Eggertswyler', 'Lucien', 54, 173),
(743, 'Bueshler', 'Alexandre', 20, 175),
(744, 'Cohu', 'Remy', 15, 174),
(746, 'Rumo ', 'Cyril', 54, 173),
(747, 'Magnin', 'Vincent', 15, 174),
(749, 'Alan ', 'Ducimetière', 19, 175),
(750, 'Lauper', 'Matthias', 54, 173),
(751, 'Favre', 'Alexandre', 15, 174),
(752, 'Corpateaux', 'Sam', 20, 175),
(760, 'Bakiu', 'Gentian', 56, 166),
(761, 'Schwaller', 'Angelo', 56, 166),
(762, 'Hayoz', 'Tobias', 56, 166),
(763, 'Fasel', 'Marco', 56, 166),
(764, 'Baeriswyl', 'Remo', 56, 166),
(765, 'Kämpfer', 'Marco', 56, 166),
(766, 'Bielmann', 'Dominik', 56, 166),
(767, 'Radulovic', 'Dejan', 55, 176),
(769, 'Akmadic', 'Nihad', 55, 176),
(770, 'Boschung ', 'Lukas', 55, 176),
(771, 'Gobet', 'Claudio', 55, 176),
(772, 'Haymoz', 'Adrian', 55, 176),
(773, 'Herren ', 'Flurin', 55, 176),
(774, 'Guri', 'Ngadhnjim', 55, 176),
(799, 'Pochon', 'Olivier', 57, 188),
(800, 'Mettraux', 'Pierre-Alain', 57, 188),
(801, 'Marro', 'Thomas', 57, 188),
(802, 'Galley', 'Christophe', 57, 188),
(803, 'Kolly', 'Gérald', 57, 188),
(804, 'Carrel', 'François', 57, 188),
(805, 'Clerc', 'Thomas', 57, 188),
(806, 'Clerc', 'Thomas', 57, 188),
(807, 'Grünig', 'Nicolas', 55, 189),
(808, 'Holenweg', 'Mario', 55, 189),
(809, 'Blanchard', 'Maxime', 55, 189),
(810, 'Mauron', 'Emanuel', 55, 189),
(811, 'Krainer', 'Dominic', 55, 189),
(812, 'Schöpfer', 'Carole', 55, 189),
(813, 'Paradis', 'Edith', 55, 189),
(814, 'Grünig', 'Nicolas', 55, 189),
(815, 'Pochon', 'Olivier', 57, 190),
(816, 'Selimi', 'Sylejman', 54, 191),
(817, 'Mettraux', 'Pierre-Alain', 57, 190),
(818, 'Guerry', 'Ludovic', 54, 191),
(819, 'Marro', 'Thomas', 57, 190),
(820, 'Presset', 'Ludovic', 54, 191),
(821, 'Galley', 'Christophe', 57, 190),
(822, 'Fornerod', 'Ilan', 54, 191),
(823, 'Kolly', 'Gérald', 57, 190),
(824, 'Jäggi', 'Ken', 54, 191),
(825, 'Carrel', 'François', 57, 190),
(826, 'Limat', 'Adrien', 54, 191),
(827, 'Clerc', 'Thomas', 57, 190),
(828, 'Demaj', 'Betim', 54, 191),
(829, 'Clerc', 'Thomas', 57, 190),
(830, 'Clément', 'Maxime', 54, 191),
(831, 'Grünig', 'Nicolas', 55, 192),
(832, 'Crausaz', 'Nicolas', 27, 193),
(833, 'Holenweg', 'Mario', 55, 192),
(834, 'Magnin', 'Vincent', 27, 193),
(835, 'Blanchard', 'Maxime', 55, 192),
(836, 'Bartucz', 'Alan', 14, 193),
(837, 'Mauron', 'Emanuel', 55, 192),
(838, 'Coquoz', 'Eloi', 27, 193),
(839, 'Krainer', 'Dominic', 55, 192),
(840, 'Page', 'Max', 14, 193),
(841, 'Steffen', 'Nicolas', 27, 193),
(842, 'Schöpfer', 'Carole', 55, 192),
(843, 'Roubaty', 'Loris', 27, 193),
(844, 'Paradis', 'Edith', 55, 192),
(845, 'Hauser', 'Vincent', 27, 193),
(846, 'Grünig', 'Nicolas', 55, 192),
(847, 'Pochon', 'Olivier', 57, 194),
(848, 'Selimi', 'Sylejman', 54, 195),
(849, 'Mettraux', 'Pierre-Alain', 57, 194),
(850, 'Lemaire', 'Gaetan', 51, 196),
(851, 'Guerry', 'Ludovic', 54, 195),
(852, 'Marro', 'Thomas', 57, 194),
(853, 'Fernandes', 'Rafael', 51, 196),
(854, 'Presset', 'Ludovic', 54, 195),
(855, 'Galley', 'Christophe', 57, 194),
(856, 'Balija', 'Leutrim', 51, 196),
(857, 'Fornerod', 'Ilan', 54, 195),
(858, 'Kolly', 'Gérald', 57, 194),
(859, 'Jäggi', 'Ken', 54, 195),
(860, 'Carrel', 'François', 57, 194),
(861, 'Margueron', 'Alexandre', 51, 196),
(862, 'Limat', 'Adrien', 54, 195),
(863, 'Clerc', 'Thomas', 57, 194),
(864, 'Crausaz', 'Jérome', 51, 196),
(865, 'Demaj', 'Betim', 54, 195),
(866, 'Clerc', 'Thomas', 57, 194),
(867, 'Scyboz', 'Tom', 51, 196),
(868, 'Clément', 'Maxime', 54, 195),
(869, 'Bapst', 'Arnaud', 51, 196),
(870, 'Moes', 'Filipe', 51, 196),
(871, 'Saudan ', 'Dorian', 19, 197),
(872, 'Crausaz', 'Nicolas', 27, 199),
(873, 'Grünig', 'Nicolas', 55, 198),
(874, 'Schaller  ', 'Guillaume', 19, 197),
(875, 'Magnin', 'Vincent', 27, 199),
(876, 'Holenweg', 'Mario', 55, 198),
(877, 'Kenklies', 'Loris', 19, 197),
(878, 'Bartucz', 'Alan', 14, 199),
(879, 'Blanchard', 'Maxime', 55, 198),
(880, 'Rohrer', 'Bastian', 19, 197),
(881, 'Coquoz', 'Eloi', 27, 199),
(882, 'Mauron', 'Emanuel', 55, 198),
(883, 'Meierhofer', 'Dylan', 21, 197),
(884, 'Page', 'Max', 14, 199),
(885, 'Krainer', 'Dominic', 55, 198),
(886, 'Vonlanthen', 'Damien', 19, 197),
(887, 'Steffen', 'Nicolas', 27, 199),
(888, 'Schöpfer', 'Carole', 55, 198),
(889, 'Vonlanthen', 'Damien', 19, 197),
(890, 'Roubaty', 'Loris', 27, 199),
(891, 'Paradis', 'Edith', 55, 198),
(892, 'Grünig', 'Nicolas', 55, 198),
(893, 'Hauser', 'Vincent', 27, 199),
(894, 'Pochon', 'Olivier', 57, 200),
(895, 'Saudan ', 'Dorian', 19, 201),
(896, 'Selimi', 'Sylejman', 54, 202),
(897, 'Mettraux', 'Pierre-Alain', 57, 200),
(898, 'Guerry', 'Ludovic', 54, 202),
(899, 'Schaller  ', 'Guillaume', 19, 201),
(900, 'Presset', 'Ludovic', 54, 202),
(901, 'Marro', 'Thomas', 57, 200),
(902, 'Kenklies', 'Loris', 19, 201),
(903, 'Fornerod', 'Ilan', 54, 202),
(904, 'Galley', 'Christophe', 57, 200),
(905, 'Rohrer', 'Bastian', 19, 201),
(906, 'Kolly', 'Gérald', 57, 200),
(907, 'Jäggi', 'Ken', 54, 202),
(908, 'Carrel', 'François', 57, 200),
(909, 'Meierhofer', 'Dylan', 21, 201),
(910, 'Limat', 'Adrien', 54, 202),
(911, 'Clerc', 'Thomas', 57, 200),
(912, 'Demaj', 'Betim', 54, 202),
(913, 'Vonlanthen', 'Damien', 19, 201),
(914, 'Clerc', 'Thomas', 57, 200),
(915, 'Clément', 'Maxime', 54, 202),
(916, 'Vonlanthen', 'Damien', 19, 201),
(917, 'Grünig', 'Nicolas', 55, 203),
(918, 'Lemaire', 'Gaetan', 51, 205),
(919, 'Crausaz', 'Nicolas', 27, 204),
(920, 'Holenweg', 'Mario', 55, 203),
(921, 'Fernandes', 'Rafael', 51, 205),
(922, 'Magnin', 'Vincent', 27, 204),
(923, 'Blanchard', 'Maxime', 55, 203),
(924, 'Balija', 'Leutrim', 51, 205),
(925, 'Margueron', 'Alexandre', 51, 205),
(926, 'Mauron', 'Emanuel', 55, 203),
(927, 'Bartucz', 'Alan', 14, 204),
(928, 'Crausaz', 'Jérome', 51, 205),
(929, 'Krainer', 'Dominic', 55, 203),
(930, 'Coquoz', 'Eloi', 27, 204),
(931, 'Scyboz', 'Tom', 51, 205),
(932, 'Schöpfer', 'Carole', 55, 203),
(933, 'Bapst', 'Arnaud', 51, 205),
(934, 'Page', 'Max', 14, 204),
(935, 'Moes', 'Filipe', 51, 205),
(936, 'Paradis', 'Edith', 55, 203),
(937, 'Grünig', 'Nicolas', 55, 203),
(938, 'Steffen', 'Nicolas', 27, 204),
(939, 'Roubaty', 'Loris', 27, 204),
(940, 'Hauser', 'Vincent', 27, 204),
(941, 'Pochon', 'Olivier', 57, 206),
(942, 'Mettraux', 'Pierre-Alain', 57, 206),
(943, 'Marro', 'Thomas', 57, 206),
(944, 'Galley', 'Christophe', 57, 206),
(945, 'Kolly', 'Gérald', 57, 206),
(946, 'Carrel', 'François', 57, 206),
(947, 'Clerc', 'Thomas', 57, 206),
(948, 'Clerc', 'Thomas', 57, 206),
(949, 'Saudan ', 'Dorian', 19, 207),
(950, 'Schaller  ', 'Guillaume', 19, 207),
(951, 'Kenklies', 'Loris', 19, 207),
(952, 'Rohrer', 'Bastian', 19, 207),
(953, 'Meierhofer', 'Dylan', 21, 207),
(954, 'Vonlanthen', 'Damien', 19, 207),
(955, 'Vonlanthen', 'Damien', 19, 207),
(956, 'Lemaire', 'Gaetan', 51, 208),
(957, 'Fernandes', 'Rafael', 51, 208),
(958, 'Selimi', 'Sylejman', 54, 209),
(959, 'Balija', 'Leutrim', 51, 208),
(960, 'Guerry', 'Ludovic', 54, 209),
(961, 'Margueron', 'Alexandre', 51, 208),
(962, 'Presset', 'Ludovic', 54, 209),
(963, 'Crausaz', 'Jérome', 51, 208),
(964, 'Fornerod', 'Ilan', 54, 209),
(965, 'Scyboz', 'Tom', 51, 208),
(966, 'Jäggi', 'Ken', 54, 209),
(967, 'Bapst', 'Arnaud', 51, 208),
(968, 'Limat', 'Adrien', 54, 209),
(969, 'Moes', 'Filipe', 51, 208),
(970, 'Demaj', 'Betim', 54, 209),
(971, 'Clément', 'Maxime', 54, 209),
(972, 'Jullierat', 'Antoine', 13, 211),
(973, 'Pochon', 'Olivier', 57, 212),
(974, 'Grünig', 'Nicolas', 55, 213),
(975, 'Rosat', 'Cedric', 13, 211),
(976, 'Mettraux', 'Pierre-Alain', 57, 212),
(977, 'Holenweg', 'Mario', 55, 213),
(978, 'Defferard', 'Arnaud', 13, 211),
(979, 'Crausaz', 'Nicolas', 27, 214),
(980, 'Marro', 'Thomas', 57, 212),
(981, 'Blanchard', 'Maxime', 55, 213),
(982, 'Bugnon', 'Arnaud', 13, 211),
(983, 'Magnin', 'Vincent', 27, 214),
(984, 'Galley', 'Christophe', 57, 212),
(985, 'Mauron', 'Emanuel', 55, 213),
(986, 'Eltschinger', 'Yannic', 13, 211),
(987, 'Kolly', 'Gérald', 57, 212),
(988, 'Krainer', 'Dominic', 55, 213),
(989, 'Carrel', 'François', 57, 212),
(990, 'Bartucz', 'Alan', 14, 214),
(991, 'Schöpfer', 'Carole', 55, 213),
(992, 'Paradis', 'Edith', 55, 213),
(993, 'Coquoz', 'Eloi', 27, 214),
(994, 'Clerc', 'Thomas', 57, 212),
(995, 'Grünig', 'Nicolas', 55, 213),
(996, 'Page', 'Max', 14, 214),
(997, 'Clerc', 'Thomas', 57, 212),
(998, 'Steffen', 'Nicolas', 27, 214),
(999, 'Roubaty', 'Loris', 27, 214),
(1000, 'Hauser', 'Vincent', 27, 214),
(1001, 'Suchet', 'Romain', 53, 215),
(1002, 'bauwens ', 'Antoine', 53, 215),
(1003, 'Comte', 'Olivier', 53, 215),
(1004, 'Comte', 'Olivier', 53, 215),
(1005, 'Sapin', 'Guillaume', 53, 215),
(1006, 'Giroud', 'Pierre', 53, 215),
(1007, 'Clément', 'Maxime', 54, 12018),
(1008, 'Pasquier', 'Julien', 57, 12013),
(1009, 'Nguyen', 'Dang Khoa', 31, 12007),
(1010, 'Kolly', 'Gérald', 57, 12017),
(1011, 'Gurtner', 'Maxime', 16, 12014),
(1012, 'Schaller', 'Guillaume', 19, 12011),
(1013, 'Jelinski', 'Nils', 28, 12020),
(1014, 'Biolley', 'Valentin', 2, 12015),
(1015, 'Loosli', 'Pius', 10, 12006),
(1016, 'Studer', 'Nicolas', 57, 12019),
(1017, 'Gremaud', 'Romain', 40, 12010),
(1018, 'Waeber', 'Laurent', 57, 12008),
(1019, 'Clerc', 'Thomas', 57, 12004),
(1020, 'Nogueira', 'Roberto', 20, 12005),
(1021, 'Jacquat', 'Jonathan', 17, 12009),
(1022, 'Rossier', 'Jérémie', 22, 12012),
(1023, 'Dafflon', 'Léo', 7, 12016);

-- --------------------------------------------------------

--
-- Structure de la table `t_joueurtransition`
--

DROP TABLE IF EXISTS `t_joueurtransition`;
CREATE TABLE IF NOT EXISTS `t_joueurtransition` (
  `pk_joueurTransition` int(11) NOT NULL AUTO_INCREMENT,
  `nom_joueurTransition` varchar(45) NOT NULL,
  `prenom_joueurTransition` varchar(45) NOT NULL,
  `fk_classe` int(11) NOT NULL,
  `fk_equipeTransition` int(11) NOT NULL,
  PRIMARY KEY (`pk_joueurTransition`)
) ENGINE=MyISAM AUTO_INCREMENT=207 DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `t_login`
--

DROP TABLE IF EXISTS `t_login`;
CREATE TABLE IF NOT EXISTS `t_login` (
  `id_login` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_login`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_login`
--

INSERT INTO `t_login` (`id_login`, `user`, `password`) VALUES
(1, 'badoud', 'emf123'),
(2, 'zaroual', 'emf123');

-- --------------------------------------------------------

--
-- Structure de la table `t_match`
--

DROP TABLE IF EXISTS `t_match`;
CREATE TABLE IF NOT EXISTS `t_match` (
  `pk_match` int(11) NOT NULL AUTO_INCREMENT,
  `date_match` date DEFAULT NULL,
  `heure_match` time DEFAULT NULL,
  `eliminatoire` tinyint(1) DEFAULT '0',
  `joue` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`pk_match`)
) ENGINE=InnoDB AUTO_INCREMENT=12059 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_match`
--

INSERT INTO `t_match` (`pk_match`, `date_match`, `heure_match`, `eliminatoire`, `joue`) VALUES
(347, '2012-10-29', '12:10:00', 0, 1),
(348, '2012-10-29', '12:55:00', 0, 1),
(349, '2012-11-12', '12:40:00', 0, 1),
(350, '2012-10-30', '12:10:00', 0, 1),
(351, '2012-11-06', '12:55:00', 0, 1),
(352, '2012-11-06', '12:10:00', 0, 1),
(353, '2012-11-12', '12:25:00', 0, 1),
(354, '2012-10-29', '12:25:00', 0, 1),
(355, '2012-11-08', '12:25:00', 0, 1),
(356, '2012-11-06', '12:40:00', 0, 1),
(357, '2012-11-07', '12:55:00', 0, 1),
(358, '2012-11-12', '12:55:00', 0, 1),
(359, '2012-11-12', '12:10:00', 0, 1),
(360, '2012-10-30', '12:40:00', 0, 1),
(361, '2012-10-30', '12:55:00', 0, 1),
(362, '2012-11-05', '12:40:00', 0, 1),
(363, '2012-11-07', '12:25:00', 0, 1),
(364, '2012-10-30', '12:25:00', 0, 1),
(365, '2012-10-29', '12:40:00', 0, 1),
(366, '2012-11-06', '12:25:00', 0, 1),
(367, '2012-11-13', '12:10:00', 0, 1),
(368, '2012-10-31', '12:25:00', 0, 1),
(369, '2012-10-31', '12:55:00', 0, 1),
(370, '2012-11-07', '12:10:00', 0, 1),
(371, '2012-11-08', '12:10:00', 0, 1),
(372, '2012-11-08', '12:55:00', 0, 1),
(373, '2012-10-31', '12:40:00', 0, 1),
(374, '2012-11-13', '12:25:00', 0, 1),
(375, '2012-11-08', '12:40:00', 0, 1),
(376, '2012-10-31', '12:10:00', 0, 1),
(377, '2012-11-05', '12:10:00', 0, 1),
(378, '2012-11-09', '12:25:00', 0, 1),
(379, '2012-11-09', '12:55:00', 0, 1),
(380, '2012-11-13', '12:55:00', 0, 1),
(381, '2012-11-05', '12:25:00', 0, 1),
(382, '2012-11-13', '12:40:00', 0, 1),
(383, '2012-11-09', '12:40:00', 0, 1),
(384, '2012-11-07', '12:40:00', 0, 1),
(385, '2012-11-05', '12:55:00', 0, 1),
(386, '2012-11-09', '12:10:00', 0, 1),
(390, '2012-10-29', '12:10:00', 0, 1),
(402, '2012-11-14', '12:10:00', 1, 1),
(403, '2012-11-14', '12:30:00', 1, 1),
(404, '2012-11-15', '12:10:00', 1, 1),
(405, '2012-11-15', '12:30:00', 1, 1),
(406, '2012-11-19', '12:10:00', 1, 1),
(407, '2012-11-19', '12:30:00', 1, 1),
(408, '2012-11-20', '12:10:00', 2, 1),
(409, '2012-11-20', '12:30:00', 3, 1),
(410, '2012-00-00', '00:00:00', 0, 0),
(411, '2012-00-00', '00:00:00', 0, 0),
(412, '2012-00-00', '00:00:00', 0, 0),
(413, '2012-00-00', '00:00:00', 0, 0),
(414, '2012-00-00', '00:00:00', 0, 0),
(415, '2012-00-00', '00:00:00', 0, 0),
(416, '2012-00-00', '00:00:00', 0, 0),
(417, '2012-00-00', '00:00:00', 0, 0),
(418, '2012-00-00', '00:00:00', 0, 0),
(419, '2012-00-00', '00:00:00', 0, 0),
(420, '2012-00-00', '00:00:00', 0, 0),
(421, '2012-00-00', '00:00:00', 0, 0),
(422, '2012-00-00', '00:00:00', 0, 0),
(423, '2013-04-23', '12:10:00', 0, 1),
(424, '2013-04-23', '12:10:00', 0, 1),
(425, '2013-04-23', '12:30:00', 0, 1),
(426, '2013-04-23', '12:30:00', 0, 1),
(427, '2013-04-24', '12:10:00', 0, 1),
(428, '2013-04-24', '12:10:00', 0, 1),
(429, '2013-04-24', '12:30:00', 0, 1),
(430, '2013-04-24', '12:30:00', 0, 1),
(431, '2013-04-25', '12:10:00', 0, 1),
(432, '2013-04-25', '12:10:00', 0, 1),
(433, '2013-04-25', '12:30:00', 0, 1),
(434, '2013-04-25', '12:30:00', 0, 1),
(435, '2013-04-26', '12:10:00', 1, 1),
(436, '2013-04-26', '12:10:00', 1, 1),
(437, '2013-04-26', '12:30:00', 1, 1),
(438, '2013-04-26', '12:30:00', 1, 1),
(439, '2013-04-29', '12:10:00', 1, 1),
(440, '2013-04-29', '12:10:00', 1, 1),
(441, '2013-04-29', '12:30:00', 2, 1),
(442, '2013-04-29', '12:30:00', 3, 1),
(443, '2013-04-29', '12:30:00', 2, 1),
(444, '2013-04-29', '12:30:00', 3, 1),
(445, '2013-04-26', '12:10:00', 1, 0),
(446, '0000-00-00', '00:00:00', 1, 0),
(447, '0000-00-00', '00:00:00', 1, 0),
(448, '2013-04-26', '12:10:00', 1, 0),
(449, '2013-04-26', '12:10:00', 1, 0),
(450, '2013-04-26', '12:30:00', 1, 0),
(451, '2013-04-26', '12:30:00', 1, 1),
(452, '2013-04-26', '12:10:00', 1, 0),
(453, '2013-04-26', '12:10:00', 1, 0),
(454, '2013-04-26', '12:10:00', 1, 0),
(455, '2013-04-26', '12:10:00', 1, 0),
(456, '2013-04-26', '12:10:00', 1, 0),
(457, '2013-04-26', '12:10:00', 1, 1),
(458, '2013-04-26', '12:10:00', 1, 1),
(459, '2013-04-29', '12:10:00', 1, 1),
(460, '2013-04-29', '12:10:00', 1, 1),
(461, '2013-04-29', '12:30:00', 3, 1),
(462, '2013-04-29', '12:30:00', 3, 0),
(463, '2013-04-29', '12:30:00', 2, 1),
(642, '2013-11-11', '12:10:00', 0, 1),
(643, '2013-11-11', '12:25:00', 0, 1),
(644, '2013-11-11', '12:40:00', 0, 1),
(645, '2013-11-11', '12:55:00', 0, 1),
(646, '2013-11-12', '12:10:00', 0, 1),
(647, '2013-11-12', '12:25:00', 0, 1),
(648, '2013-11-12', '12:40:00', 0, 1),
(649, '2013-11-12', '12:55:00', 0, 1),
(650, '2013-11-13', '12:10:00', 0, 1),
(651, '2013-11-13', '12:25:00', 0, 1),
(652, '2013-11-13', '12:40:00', 0, 1),
(653, '2013-11-13', '12:55:00', 0, 1),
(654, '2013-11-18', '12:10:00', 0, 1),
(655, '2013-11-18', '12:25:00', 0, 1),
(656, '2013-11-18', '12:40:00', 0, 1),
(657, '2013-11-18', '12:55:00', 0, 1),
(658, '2013-11-19', '12:10:00', 0, 1),
(659, '2013-11-19', '12:25:00', 0, 1),
(660, '2013-11-19', '12:40:00', 0, 1),
(661, '2013-11-19', '12:55:00', 0, 1),
(662, '2013-11-20', '12:10:00', 0, 1),
(663, '2013-11-20', '12:25:00', 0, 1),
(664, '2013-11-20', '12:40:00', 0, 1),
(665, '2013-11-20', '12:55:00', 0, 1),
(666, '2013-11-25', '12:10:00', 0, 1),
(667, '2013-11-25', '12:25:00', 0, 1),
(668, '2013-11-25', '12:40:00', 0, 1),
(669, '2013-11-26', '12:10:00', 0, 1),
(670, '2013-11-26', '12:25:00', 0, 1),
(671, '2013-11-26', '12:40:00', 0, 1),
(672, '2013-12-02', '12:15:00', 1, 1),
(673, '2013-11-27', '12:15:00', 1, 0),
(674, '2013-11-27', '12:15:00', 1, 1),
(675, '2013-12-02', '12:35:00', 1, 1),
(676, '2013-11-27', '12:35:00', 1, 1),
(677, '2013-12-03', '12:15:00', 1, 1),
(678, '2013-12-03', '12:35:00', 1, 1),
(679, '2013-12-09', '12:15:00', 2, 0),
(680, '2013-12-09', '12:15:00', 2, 1),
(681, '2013-12-09', '12:35:00', 3, 1),
(682, '2014-03-17', '12:10:00', 0, 1),
(683, '2014-03-17', '12:10:00', 0, 1),
(684, '2014-03-17', '12:10:00', 0, 1),
(685, '2014-03-17', '12:10:00', 0, 1),
(686, '2014-03-18', '12:10:00', 0, 1),
(687, '2014-03-18', '12:10:00', 0, 1),
(688, '2014-03-18', '12:10:00', 0, 1),
(689, '2014-03-18', '12:10:00', 0, 1),
(690, '2014-03-19', '12:10:00', 0, 1),
(691, '2014-03-19', '12:10:00', 0, 1),
(692, '2014-03-19', '12:10:00', 0, 1),
(693, '2014-03-19', '12:10:00', 0, 1),
(694, '2014-03-24', '12:10:00', 0, 1),
(695, '2014-03-24', '12:10:00', 0, 1),
(696, '2014-03-24', '12:30:00', 0, 1),
(697, '2014-03-24', '12:10:00', 0, 1),
(698, '2014-03-25', '12:10:00', 0, 1),
(699, '2014-03-25', '12:10:00', 0, 1),
(700, '2014-03-25', '12:10:00', 0, 1),
(701, '2014-03-25', '12:30:00', 0, 1),
(702, '2014-03-31', '12:10:00', 0, 1),
(703, '2014-03-31', '12:30:00', 0, 1),
(704, '2014-03-31', '12:10:00', 1, 0),
(705, '2014-04-01', '12:10:00', 1, 0),
(706, '2014-04-01', '12:10:00', 1, 1),
(707, '2014-04-01', '12:10:00', 1, 1),
(708, '2014-04-01', '12:25:00', 1, 1),
(709, '2014-04-01', '12:10:00', 1, 1),
(710, '2014-04-02', '12:10:00', 1, 1),
(711, '2014-04-02', '12:10:00', 1, 1),
(712, '2014-04-02', '12:10:00', 1, 1),
(713, '2014-04-02', '12:10:00', 1, 1),
(714, '2014-04-07', '12:10:00', 1, 1),
(715, '2014-04-07', '12:10:00', 1, 1),
(716, '2014-04-08', '12:10:00', 1, 0),
(717, '2014-04-08', '12:10:00', 1, 1),
(718, '2014-04-08', '12:10:00', 1, 1),
(719, '2014-11-04', '12:00:00', 0, 0),
(720, '2014-11-04', '12:20:00', 0, 1),
(721, '2014-11-05', '12:00:00', 0, 0),
(722, '2014-11-05', '12:20:00', 0, 1),
(723, '2014-11-10', '12:00:00', 0, 1),
(724, '2014-11-10', '12:20:00', 0, 1),
(725, '2014-11-11', '12:00:00', 0, 1),
(726, '2014-11-11', '12:20:00', 0, 1),
(727, '2014-11-12', '12:00:00', 0, 0),
(728, '2014-11-12', '12:20:00', 0, 1),
(729, '2014-11-17', '12:00:00', 0, 1),
(730, '2014-11-17', '12:20:00', 0, 1),
(731, '2014-11-18', '12:00:00', 0, 1),
(732, '2014-11-18', '12:20:00', 0, 1),
(733, '2014-11-19', '12:00:00', 0, 1),
(734, '2014-11-19', '12:20:00', 0, 1),
(735, '2014-11-24', '12:00:00', 0, 1),
(736, '2014-11-24', '12:20:00', 0, 1),
(737, '2014-11-25', '12:00:00', 0, 1),
(738, '2014-11-25', '12:20:00', 0, 1),
(739, '2014-11-26', '12:00:00', 0, 1),
(761, '2014-11-12', '12:00:00', 0, 1),
(762, '2014-11-04', '12:00:00', 0, 1),
(763, '2014-11-05', '12:00:00', 0, 1),
(764, '2014-11-04', '12:00:00', 0, 1),
(765, '2014-12-09', '12:00:00', 1, 1),
(766, '2014-12-10', '12:00:00', 1, 1),
(767, '2014-12-15', '12:00:00', 2, 1),
(768, '2014-12-15', '12:25:00', 3, 1),
(769, '0000-00-00', '00:00:00', 0, 0),
(770, '0000-00-00', '00:00:00', 0, 0),
(771, '0000-00-00', '00:00:00', 0, 0),
(772, '2024-10-20', '00:00:12', 0, 0),
(773, '2012-00-00', '00:00:00', 0, 0),
(774, '2012-00-00', '00:00:00', 0, 0),
(775, '2012-00-00', '00:00:00', 0, 0),
(776, '2012-00-00', '00:00:00', 0, 0),
(777, '2012-00-00', '00:00:00', 0, 0),
(778, '2012-00-00', '00:00:00', 0, 0),
(779, '2012-00-00', '00:00:00', 0, 0),
(780, '2012-00-00', '00:00:00', 0, 0),
(781, '2012-00-00', '00:00:00', 0, 0),
(782, '2012-00-00', '00:00:00', 0, 0),
(783, '2012-00-00', '00:00:00', 0, 0),
(784, '2012-00-00', '00:00:00', 0, 0),
(785, '2012-00-00', '00:00:00', 0, 0),
(786, '2012-00-00', '00:00:00', 0, 0),
(787, '2012-00-00', '00:00:00', 0, 0),
(788, '2012-00-00', '00:00:00', 0, 0),
(789, '2012-00-00', '00:00:00', 0, 0),
(790, '2012-00-00', '00:00:00', 0, 0),
(791, '2012-00-00', '00:00:00', 0, 0),
(792, '2012-00-00', '00:00:00', 0, 0),
(793, '2014-01-20', '20:00:00', 0, 1),
(794, '2012-00-00', '00:00:00', 0, 0),
(795, '2012-00-00', '00:00:00', 0, 0),
(796, '2012-00-00', '00:00:00', 0, 0),
(797, '2012-00-00', '00:00:00', 0, 0),
(798, '2012-00-00', '00:00:00', 0, 0),
(799, '2012-00-00', '00:00:00', 0, 0),
(800, '2012-00-00', '00:00:00', 0, 0),
(801, '2012-00-00', '00:00:00', 0, 0),
(802, '2012-00-00', '00:00:00', 0, 0),
(803, '2012-00-00', '00:00:00', 0, 0),
(804, '2014-01-10', '12:00:00', 0, 1),
(805, '0000-00-00', '00:00:00', 0, 1),
(806, '2014-01-08', '12:00:00', 0, 1),
(807, '2015-01-15', '00:00:00', 3, 1),
(808, '2015-02-25', '12:00:00', 0, 0),
(809, '2015-02-25', '12:10:00', 0, 1),
(810, '2015-02-25', '12:25:00', 0, 1),
(811, '2015-03-02', '11:55:00', 0, 1),
(812, '2015-03-02', '12:00:00', 0, 0),
(813, '2015-03-02', '12:25:00', 0, 1),
(814, '2015-03-02', '12:40:00', 0, 1),
(815, '2015-03-04', '12:00:00', 0, 1),
(816, '2015-03-04', '12:15:00', 0, 1),
(817, '2015-03-11', '12:00:00', 0, 1),
(818, '2015-03-11', '12:15:00', 0, 1),
(819, '2015-03-11', '12:30:00', 0, 1),
(820, '2015-03-16', '12:10:00', 0, 1),
(821, '2015-03-18', '12:00:00', 0, 1),
(822, '2015-03-18', '12:15:00', 0, 1),
(823, '2015-02-25', '11:55:00', 0, 1),
(824, '2015-03-04', '12:30:00', 0, 1),
(825, '2015-03-09', '12:10:00', 0, 1),
(826, '2015-03-09', '12:25:00', 0, 1),
(827, '2015-03-09', '12:40:00', 0, 1),
(828, '2015-03-16', '12:25:00', 0, 1),
(829, '2015-03-16', '12:40:00', 0, 1),
(830, '2015-02-25', '12:40:00', 0, 1),
(831, '2015-03-02', '12:10:00', 0, 1),
(832, '2015-03-09', '11:55:00', 0, 1),
(833, '2015-03-16', '11:55:00', 0, 1),
(834, '2015-03-18', '12:30:00', 0, 1),
(835, '2015-03-23', '12:00:00', 1, 1),
(836, '2015-03-23', '12:20:00', 1, 1),
(837, '2015-03-25', '12:00:00', 1, 1),
(838, '2015-03-25', '12:20:00', 1, 1),
(839, '2015-03-30', '12:00:00', 1, 1),
(840, '2015-03-30', '12:20:00', 1, 1),
(841, '2015-04-01', '12:00:00', 2, 1),
(842, '2015-04-01', '12:20:00', 3, 1),
(843, '2012-00-00', '00:00:00', 0, 0),
(844, '2030-10-20', '10:00:00', 0, 1),
(845, '2030-10-20', '10:00:00', 0, 1),
(846, '2030-10-20', '12:00:00', 0, 1),
(847, '2030-10-20', '12:00:00', 0, 1),
(848, '2030-10-20', '16:20:00', 0, 0),
(849, '2015-10-02', '12:00:00', 2, 1),
(850, '2015-10-02', '12:00:00', 2, 0),
(851, '2015-10-02', '12:00:00', 3, 1),
(852, '2015-10-02', '16:00:00', 3, 1),
(853, '2015-10-02', '16:00:00', 3, 0),
(854, '2015-10-02', '14:00:00', 2, 1),
(855, '2015-10-02', '14:00:00', 2, 1),
(856, '2015-10-02', '15:00:00', 2, 0),
(857, '2015-11-03', '12:00:00', 0, 1),
(858, '2015-11-03', '12:15:00', 0, 1),
(859, '2015-11-04', '12:15:00', 0, 1),
(860, '2015-11-04', '12:30:00', 0, 1),
(861, '2015-11-10', '12:00:00', 0, 1),
(862, '2015-11-10', '12:15:00', 0, 1),
(863, '2015-11-11', '12:15:00', 0, 1),
(864, '2015-11-11', '12:30:00', 0, 1),
(865, '2015-11-18', '12:30:00', 0, 1),
(866, '2015-11-24', '12:00:00', 0, 1),
(867, '2015-11-03', '12:30:00', 0, 1),
(868, '2015-11-04', '12:00:00', 0, 1),
(869, '2015-11-10', '12:30:00', 0, 1),
(870, '2015-11-11', '12:00:00', 0, 1),
(871, '2015-11-18', '12:00:00', 0, 1),
(872, '2015-11-18', '12:15:00', 0, 1),
(874, '2015-11-25', '12:00:00', 1, 1),
(875, '2015-11-25', '12:25:00', 1, 1),
(876, '2015-12-01', '12:00:00', 1, 1),
(877, '2015-12-01', '12:25:00', 1, 1),
(878, '2015-12-02', '12:00:00', 1, 1),
(879, '2015-12-02', '12:25:00', 1, 1),
(880, '2015-12-09', '12:25:00', 3, 1),
(881, '2015-12-09', '12:00:00', 2, 1),
(12003, '2012-00-00', '00:00:00', 0, 0),
(12004, '2012-00-00', '00:00:00', 0, 0),
(12005, '2012-00-00', '00:00:00', 0, 0),
(12006, '2012-00-00', '00:00:00', 0, 0),
(12007, '2012-00-00', '00:00:00', 0, 0),
(12008, '2012-00-00', '00:00:00', 0, 0),
(12009, '2012-00-00', '00:00:00', 0, 0),
(12010, '2012-00-00', '00:00:00', 0, 0),
(12011, '2012-00-00', '00:00:00', 0, 0),
(12012, '2012-00-00', '00:00:00', 0, 0),
(12013, '2012-00-00', '00:00:00', 0, 0),
(12014, '2012-00-00', '00:00:00', 0, 0),
(12015, '2012-00-00', '00:00:00', 0, 0),
(12016, '2012-00-00', '00:00:00', 0, 0),
(12017, '2012-00-00', '00:00:00', 0, 0),
(12018, '2012-00-00', '00:00:00', 0, 0),
(12019, '2012-00-00', '00:00:00', 0, 0),
(12020, '2012-00-00', '00:00:00', 0, 0),
(12021, '2012-00-00', '00:00:00', 0, 0),
(12022, '2012-00-00', '00:00:00', 0, 0),
(12023, '2012-00-00', '00:00:00', 0, 0),
(12024, '2012-00-00', '00:00:00', 0, 0),
(12025, '2012-00-00', '00:00:00', 0, 0),
(12026, '2012-00-00', '00:00:00', 0, 0),
(12027, '2012-00-00', '00:00:00', 0, 0),
(12028, '2012-00-00', '00:00:00', 0, 0),
(12029, '2012-00-00', '00:00:00', 0, 0),
(12030, '2012-00-00', '00:00:00', 0, 0),
(12031, '2016-02-15', '12:00:00', 0, 1),
(12032, '2016-02-15', '12:00:00', 0, 1),
(12033, '2016-02-17', '12:00:00', 0, 1),
(12034, '2016-02-17', '12:00:00', 0, 1),
(12035, '2016-02-24', '12:00:00', 0, 1),
(12036, '2016-02-24', '12:00:00', 0, 1),
(12037, '2016-02-15', '12:00:00', 0, 1),
(12038, '2016-02-15', '12:00:00', 0, 1),
(12039, '2016-02-23', '12:00:00', 0, 1),
(12040, '2016-02-23', '12:00:00', 0, 1),
(12041, '2016-03-02', '12:00:00', 0, 0),
(12042, '2016-03-02', '12:00:00', 0, 0),
(12043, '2016-02-16', '12:00:00', 0, 1),
(12044, '2016-02-16', '12:00:00', 0, 1),
(12045, '2016-02-23', '12:00:00', 0, 1),
(12046, '2016-02-23', '12:00:00', 0, 1),
(12047, '2016-03-01', '12:00:00', 0, 0),
(12048, '2016-03-01', '12:00:00', 0, 0),
(12049, '2016-02-16', '12:00:00', 0, 1),
(12050, '2016-02-16', '12:00:00', 0, 1),
(12051, '2016-02-17', '12:00:00', 0, 1),
(12052, '2016-02-17', '12:00:00', 0, 1),
(12053, '2016-02-24', '12:00:00', 0, 1),
(12054, '2016-02-24', '12:00:00', 0, 1),
(12055, '2016-03-01', '12:00:00', 0, 0),
(12056, '2016-03-01', '12:00:00', 0, 0),
(12057, '2016-03-02', '12:00:00', 0, 1),
(12058, '2016-03-02', '12:00:00', 0, 0);

-- --------------------------------------------------------

--
-- Structure de la table `t_news`
--

DROP TABLE IF EXISTS `t_news`;
CREATE TABLE IF NOT EXISTS `t_news` (
  `pk_news` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) DEFAULT NULL,
  `description` varchar(300) DEFAULT NULL,
  `fk_tournoi` int(11) NOT NULL,
  PRIMARY KEY (`pk_news`),
  KEY `fk_t_news_t_tournoi1` (`fk_tournoi`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `t_parameter`
--

DROP TABLE IF EXISTS `t_parameter`;
CREATE TABLE IF NOT EXISTS `t_parameter` (
  `pk_parameter` int(11) NOT NULL AUTO_INCREMENT,
  `NBTerrain` int(11) NOT NULL,
  `NBEQualifie` int(11) NOT NULL,
  PRIMARY KEY (`pk_parameter`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Structure de la table `t_reglement`
--

DROP TABLE IF EXISTS `t_reglement`;
CREATE TABLE IF NOT EXISTS `t_reglement` (
  `pk_reglement` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(90) NOT NULL,
  `version` varchar(45) NOT NULL,
  `date` datetime NOT NULL,
  `type` varchar(45) NOT NULL,
  `fk_tournoi` int(11) NOT NULL,
  PRIMARY KEY (`pk_reglement`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_reglement`
--

INSERT INTO `t_reglement` (`pk_reglement`, `path`, `version`, `date`, `type`, `fk_tournoi`) VALUES
(7, 'http://emftournois-php.emf-infopro.ch/pdf/Badminton.pdf', '2.0', '2016-02-15 00:00:00', 'PDF', 18);

-- --------------------------------------------------------

--
-- Structure de la table `t_statut`
--

DROP TABLE IF EXISTS `t_statut`;
CREATE TABLE IF NOT EXISTS `t_statut` (
  `pk_statut` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(45) NOT NULL,
  PRIMARY KEY (`pk_statut`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_statut`
--

INSERT INTO `t_statut` (`pk_statut`, `nom`) VALUES
(1, 'En préparation'),
(2, 'En cours'),
(3, 'Terminé');

-- --------------------------------------------------------

--
-- Structure de la table `t_tournoi`
--

DROP TABLE IF EXISTS `t_tournoi`;
CREATE TABLE IF NOT EXISTS `t_tournoi` (
  `pk_tournoi` int(11) NOT NULL AUTO_INCREMENT,
  `fk_statut` int(11) DEFAULT NULL,
  `nom_tournoi` varchar(45) DEFAULT NULL,
  `annee_tournoi` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`pk_tournoi`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `t_tournoi`
--

INSERT INTO `t_tournoi` (`pk_tournoi`, `fk_statut`, `nom_tournoi`, `annee_tournoi`) VALUES
(11, 3, 'Unihockey', '2013-2014'),
(13, 3, 'Unihockey', '2014-2015'),
(14, 3, 'Futsal', '2014-2015'),
(17, 3, 'Unihockey', '2015-2016'),
(18, 2, 'Badminton', '2015-2016');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;