# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Vendredi 03 Septembre 2004 à 17:38
# Version du serveur: 3.23.54
# Version de PHP: 4.2.3
# 
# Base de données: `tournois_tennis`
# 

#
# Contenu de la table `categorie`
#

INSERT INTO categorie (id_categorie, age, tournoi, sexe, limite, avencement) VALUES (1, 35, 1, 'm', 0, 19),
(2, 35, 1, 'f', 0, 19),
(3, 999, 1, 'm', 0, 19),
(4, 999, 1, 'f', 0, 19),
(5, 999, 2, 'm', 0, 37),
(6, 10, 3, 'm', 0, 19),
(7, 10, 3, 'f', 0, 19),
(8, 12, 3, 'm', 0, 19),
(9, 12, 3, 'f', 0, 19),
(10, 14, 3, 'm', 0, 19),
(11, 14, 3, 'f', 0, 19),
(12, 35, 4, 'm', 0, 0),
(14, 35, 4, 'f', 0, 19),
(15, 999, 4, 'm', 0, 13),
(16, 999, 4, 'f', 0, 0),
(17, 10, 5, 'm', 0, 19),
(18, 10, 5, 'f', 0, 19),
(19, 12, 5, 'm', 0, 19),
(20, 12, 5, 'f', 0, 19),
(21, 14, 5, 'm', 0, 19),
(22, 14, 5, 'f', 0, 19),
(23, 16, 5, 'm', 0, 19),
(24, 16, 5, 'f', 0, 19),
(25, 35, 6, 'm', 0, 16),
(26, 35, 6, 'f', 0, 19),
(27, 999, 6, 'm', 0, 19),
(28, 999, 6, 'f', 0, 19),
(29, 999, 7, 'm', 21, 37),
(30, 999, 8, 'b', 21, 37),
(31, 12, 9, 'm', 0, 19),
(32, 12, 9, 'f', 0, 19),
(33, 14, 9, 'm', 0, 19),
(34, 14, 9, 'f', 0, 19),
(35, 12, 10, 'f', 0, 19),
(36, 12, 10, 'm', 0, 19),
(37, 10, 10, 'f', 0, 19),
(38, 10, 10, 'm', 0, 19),
(39, 14, 10, 'f', 0, 19),
(40, 14, 10, 'm', 0, 19),
(41, 16, 10, 'f', 0, 19),
(42, 16, 10, 'm', 0, 19),
(43, 999, 11, 'm', 0, 19),
(44, 999, 11, 'f', 0, 19),
(45, 35, 11, 'm', 0, 19),
(46, 35, 11, 'f', 0, 19),
(47, 16, 12, 'm', 0, 19),
(48, 16, 12, 'f', 0, 19),
(49, 14, 12, 'm', 0, 19),
(50, 14, 12, 'f', 0, 19);

#
# Contenu de la table `club`
#

INSERT INTO club (id_club, nom, numero_fft, telephone, nb_cours) VALUES (1, 'TCAL BEGARD', '05220355', '01 96 45 31 78', 1),
(4, 'TC TREGUIER', '05220449', '02 96 92 26 39', 1),
(2, 'TC LANNION', '05220214', '02 96 37 60 99', 1),
(5, 'ASPTT LANNION', '05220003', '02 96 05 83 90', 1),
(3, 'TC TREGASTEL', '05220264', '02 96 15 31 54', 5),
(6, 'TC TREBERDEN', '05220012', '02 96 23 65 37', 1),
(7, 'AC PENVENAN', '05220393', NULL, 4),
(8, 'TCM PERROS', '05220398', '02 96 23 01 33', 1),
(9, 'TC PAIMPOL', '05220005', '02 96 55 74 13', 1);

#
# Contenu de la table `horaire`
#

INSERT INTO horaire (id_horaire, heure, jour, inscription) VALUES (1, '12h00', 'mer-2004-25-08', 0),
(2, '13h30', 'mer-2004-25-08', 0),
(3, '18h00', 'ven-2004-27-08', 0),
(4, '19h30', 'ven-2004-27-08', 0),
(5, '12h00', 'mer-2004-25-08', 0),
(6, '13h30', 'mer-2004-25-08', 0),
(7, '18h00', 'ven-2004-27-08', 0),
(8, '19h30', 'ven-2004-27-08', 0),
(9, '12h00', 'ven-2005-15-07', 0),
(10, '15h00', 'ven-2005-15-07', 0),
(11, '13h30', 'sam-2005-16-07', 0);

#
# Contenu de la table `inscription`
#

INSERT INTO inscription (id_inscription, joueur, joueur_double, categorie) VALUES (1, 1, 0, '27'),
(2, 1, 0, '25'),
(3, 2, 0, '27'),
(4, 3, 0, '27'),
(5, 3, 0, '25'),
(6, 5, 0, '28'),
(7, 5, 0, '34'),
(8, 6, 0, '28'),
(9, 7, 0, '32'),
(10, 8, 0, '32'),
(11, 9, 0, '32'),
(12, 9, 0, '34'),
(13, 10, 0, '32'),
(14, 11, 0, '27'),
(15, 12, 0, '27'),
(16, 13, 0, '27'),
(17, 14, 0, '27'),
(18, 15, 0, '27'),
(19, 15, 0, '25'),
(20, 16, 0, '27'),
(21, 17, 0, '27'),
(22, 18, 0, '27'),
(23, 19, 0, '27'),
(24, 19, 0, '25'),
(25, 20, 0, '27'),
(26, 20, 0, '25'),
(27, 21, 0, '31'),
(28, 22, 0, '31'),
(29, 23, 0, '31'),
(30, 24, 0, '33'),
(31, 25, 0, '33'),
(32, 26, 0, '33'),
(33, 27, 0, '31'),
(34, 28, 0, '33'),
(35, 29, 0, '31'),
(36, 30, 0, '31'),
(37, 30, 0, '33'),
(38, 31, 0, '25'),
(39, 32, 0, '26'),
(40, 33, 0, '27'),
(41, 34, 0, '31'),
(42, 34, 0, '33'),
(43, 35, 0, '27'),
(44, 35, 0, '33'),
(45, 36, 0, '27'),
(46, 37, 0, '27'),
(47, 37, 0, '25'),
(48, 38, 0, '32'),
(49, 38, 0, '34'),
(50, 39, 0, '25'),
(51, 40, 0, '31'),
(52, 41, 0, '27'),
(53, 42, 0, '27'),
(54, 43, 0, '28'),
(55, 43, 0, '26'),
(56, 44, 0, '27'),
(57, 44, 0, '25'),
(58, 45, 0, '31'),
(59, 45, 0, '33'),
(60, 46, 0, '27'),
(61, 47, 0, '27'),
(62, 48, 0, '26'),
(63, 49, 0, '31'),
(64, 50, 0, '28'),
(65, 51, 0, '28'),
(66, 52, 0, '27'),
(67, 53, 0, '27'),
(68, 54, 0, '27'),
(69, 55, 0, '33'),
(70, 56, 0, '31'),
(71, 57, 0, '33'),
(72, 59, 0, '27'),
(73, 60, 0, '27'),
(74, 61, 0, '32'),
(75, 62, 0, '34'),
(76, 63, 0, '27'),
(77, 63, 0, '25'),
(78, 64, 0, '27'),
(79, 65, 0, '25'),
(80, 66, 0, '25'),
(81, 67, 0, '27'),
(82, 68, 0, '33'),
(83, 69, 0, '31'),
(84, 70, 0, '27'),
(85, 71, 0, '27'),
(86, 71, 0, '25'),
(87, 72, 0, '27'),
(88, 72, 0, '25'),
(89, 73, 0, '33'),
(90, 74, 0, '27'),
(91, 75, 0, '27'),
(92, 76, 0, '27'),
(93, 77, 0, '27'),
(94, 79, 0, '27'),
(95, 80, 0, '27'),
(96, 81, 0, '31'),
(97, 82, 0, '33'),
(98, 83, 0, '31'),
(99, 84, 0, '31'),
(100, 85, 0, '27'),
(101, 86, 0, '33'),
(102, 87, 0, '27'),
(103, 88, 0, '27'),
(104, 89, 0, '33'),
(105, 90, 0, '25'),
(106, 91, 0, '27'),
(107, 92, 0, '28'),
(108, 93, 0, '27'),
(109, 93, 0, '25'),
(110, 94, 0, '27'),
(111, 95, 0, '27'),
(112, 96, 0, '27'),
(113, 97, 0, '28'),
(114, 98, 0, '34'),
(115, 99, 0, '27'),
(116, 100, 0, '33'),
(117, 101, 0, '27'),
(118, 102, 0, '27'),
(119, 103, 0, '27'),
(120, 104, 0, '25'),
(121, 105, 0, '25'),
(122, 107, 0, '31'),
(123, 108, 0, '27'),
(124, 108, 0, '25'),
(125, 110, 0, '28'),
(126, 111, 0, '27'),
(127, 112, 0, '33'),
(128, 113, 0, '27'),
(129, 114, 0, '33'),
(130, 115, 0, '26'),
(131, 116, 0, '27'),
(132, 117, 0, '27'),
(133, 118, 0, '33'),
(134, 119, 0, '28'),
(135, 120, 0, '34'),
(136, 121, 0, '28'),
(137, 122, 0, '27'),
(138, 123, 0, '28'),
(139, 123, 0, '34'),
(140, 125, 0, '25'),
(141, 126, 0, '27'),
(142, 127, 0, '28'),
(143, 127, 0, '26'),
(144, 128, 0, '25'),
(145, 129, 0, '33'),
(146, 130, 0, '25'),
(147, 131, 0, '27'),
(148, 132, 0, '34'),
(149, 133, 0, '28'),
(150, 133, 0, '26'),
(151, 134, 0, '28'),
(152, 135, 0, '27'),
(153, 136, 0, '27'),
(154, 137, 0, '33'),
(155, 138, 0, '25'),
(156, 139, 0, '27'),
(157, 140, 0, '25'),
(158, 141, 0, '27'),
(159, 142, 0, '28'),
(160, 143, 0, '28'),
(161, 143, 0, '26'),
(162, 144, 0, '26'),
(163, 145, 0, '31'),
(164, 145, 0, '33'),
(165, 146, 0, '28'),
(166, 146, 0, '26'),
(167, 147, 0, '28'),
(168, 147, 0, '26'),
(169, 148, 0, '28'),
(170, 149, 0, '27'),
(171, 150, 0, '27'),
(172, 151, 0, '27'),
(173, 152, 0, '28'),
(174, 153, 0, '33'),
(175, 154, 0, '28'),
(176, 155, 0, '27'),
(177, 156, 0, '25'),
(178, 157, 0, '25'),
(179, 158, 0, '27'),
(180, 158, 0, '25'),
(181, 159, 0, '26'),
(182, 160, 0, '25'),
(183, 161, 0, '26'),
(184, 162, 0, '28'),
(185, 163, 0, '27'),
(186, 164, 0, '27'),
(187, 165, 0, '27'),
(188, 166, 0, '27'),
(189, 167, 0, '27'),
(190, 168, 0, '27'),
(191, 169, 0, '25'),
(192, 170, 0, '25'),
(193, 171, 0, '28'),
(194, 172, 0, '27'),
(195, 173, 0, '27'),
(196, 174, 0, '27'),
(197, 175, 0, '33'),
(198, 176, 0, '27'),
(199, 177, 0, '27'),
(200, 178, 0, '28'),
(201, 179, 0, '28'),
(202, 1, 0, '12'),
(203, 3, 0, '12'),
(204, 15, 0, '12'),
(205, 19, 0, '12'),
(206, 20, 0, '12'),
(207, 31, 0, '12'),
(208, 32, 0, '14'),
(209, 37, 0, '12'),
(210, 39, 0, '12'),
(211, 43, 0, '14'),
(212, 44, 0, '12'),
(213, 48, 0, '14'),
(214, 63, 0, '12'),
(215, 65, 0, '12'),
(216, 66, 0, '12'),
(217, 71, 0, '12'),
(218, 72, 0, '12'),
(219, 90, 0, '12'),
(220, 93, 0, '12'),
(221, 104, 0, '12'),
(222, 105, 0, '12'),
(223, 108, 0, '12'),
(224, 115, 0, '14'),
(225, 125, 0, '12'),
(226, 127, 0, '14'),
(227, 128, 0, '12'),
(228, 130, 0, '12'),
(229, 133, 0, '14'),
(230, 138, 0, '12'),
(231, 140, 0, '12'),
(232, 143, 0, '14'),
(233, 144, 0, '14'),
(234, 146, 0, '14'),
(235, 147, 0, '14'),
(236, 156, 0, '12'),
(237, 157, 0, '12'),
(238, 158, 0, '12'),
(239, 159, 0, '14'),
(240, 160, 0, '12'),
(241, 161, 0, '14'),
(242, 169, 0, '12'),
(243, 170, 0, '12'),
(244, 1, 0, '15'),
(245, 2, 0, '15'),
(246, 3, 0, '15'),
(247, 5, 0, '16'),
(248, 5, 0, '22'),
(249, 6, 0, '16'),
(250, 7, 0, '20'),
(251, 8, 0, '20'),
(252, 9, 0, '20'),
(253, 9, 0, '22'),
(254, 10, 0, '20'),
(255, 11, 0, '15'),
(256, 12, 0, '15'),
(257, 13, 0, '15'),
(258, 14, 0, '15'),
(259, 15, 0, '15'),
(260, 16, 0, '15'),
(261, 17, 0, '15'),
(262, 18, 0, '15'),
(263, 19, 0, '15'),
(264, 20, 0, '15'),
(265, 21, 0, '19'),
(266, 22, 0, '19'),
(267, 23, 0, '17'),
(268, 23, 0, '19'),
(269, 24, 0, '21'),
(270, 25, 0, '21'),
(271, 26, 0, '21'),
(272, 27, 0, '19'),
(273, 28, 0, '21'),
(274, 29, 0, '19'),
(275, 30, 0, '19'),
(276, 30, 0, '21'),
(277, 33, 0, '15'),
(278, 34, 0, '19'),
(279, 34, 0, '21'),
(280, 35, 0, '15'),
(281, 35, 0, '21'),
(282, 36, 0, '15'),
(283, 37, 0, '15'),
(284, 38, 0, '20'),
(285, 38, 0, '22'),
(286, 40, 0, '19'),
(287, 41, 0, '15'),
(288, 42, 0, '15'),
(289, 43, 0, '16'),
(290, 44, 0, '15'),
(291, 45, 0, '19'),
(292, 45, 0, '21'),
(293, 46, 0, '15'),
(294, 47, 0, '15'),
(295, 49, 0, '17'),
(296, 49, 0, '19'),
(297, 50, 0, '16'),
(298, 51, 0, '16'),
(299, 52, 0, '15'),
(300, 53, 0, '15'),
(301, 54, 0, '15'),
(302, 55, 0, '21'),
(303, 56, 0, '19'),
(304, 57, 0, '21'),
(305, 59, 0, '15'),
(306, 60, 0, '15'),
(307, 61, 0, '20'),
(308, 62, 0, '22'),
(309, 63, 0, '15'),
(310, 64, 0, '15'),
(311, 67, 0, '15'),
(312, 68, 0, '21'),
(313, 69, 0, '17'),
(314, 69, 0, '19'),
(315, 70, 0, '15'),
(316, 71, 0, '15'),
(317, 72, 0, '15'),
(318, 73, 0, '21'),
(319, 74, 0, '15'),
(320, 75, 0, '15'),
(321, 76, 0, '15'),
(322, 77, 0, '15'),
(323, 79, 0, '15'),
(324, 80, 0, '15'),
(325, 81, 0, '19'),
(326, 82, 0, '21'),
(327, 83, 0, '19'),
(328, 84, 0, '19'),
(329, 85, 0, '15'),
(330, 86, 0, '21'),
(331, 87, 0, '15'),
(332, 88, 0, '15'),
(333, 89, 0, '21'),
(334, 91, 0, '15'),
(335, 92, 0, '16'),
(336, 93, 0, '15'),
(337, 94, 0, '15'),
(338, 95, 0, '15'),
(339, 96, 0, '15'),
(340, 97, 0, '16'),
(341, 98, 0, '22'),
(342, 99, 0, '15'),
(343, 100, 0, '21'),
(344, 101, 0, '15'),
(345, 102, 0, '15'),
(346, 103, 0, '15'),
(347, 107, 0, '19'),
(348, 108, 0, '15'),
(349, 110, 0, '16'),
(350, 111, 0, '15'),
(351, 112, 0, '21'),
(352, 113, 0, '15'),
(353, 114, 0, '21'),
(354, 116, 0, '15'),
(355, 117, 0, '15'),
(356, 118, 0, '21'),
(357, 119, 0, '16'),
(358, 120, 0, '22'),
(359, 121, 0, '16'),
(360, 122, 0, '15'),
(361, 123, 0, '16'),
(362, 123, 0, '22'),
(363, 124, 0, '17'),
(364, 126, 0, '15'),
(365, 127, 0, '16'),
(366, 129, 0, '21'),
(367, 131, 0, '15'),
(368, 132, 0, '22'),
(369, 133, 0, '16'),
(370, 134, 0, '16'),
(371, 135, 0, '15'),
(372, 136, 0, '15'),
(373, 137, 0, '21'),
(374, 139, 0, '15'),
(375, 141, 0, '15'),
(376, 142, 0, '16'),
(377, 143, 0, '16'),
(378, 145, 0, '19'),
(379, 145, 0, '21'),
(380, 146, 0, '16'),
(381, 147, 0, '16'),
(382, 148, 0, '16'),
(383, 149, 0, '15'),
(384, 150, 0, '15'),
(385, 151, 0, '15'),
(386, 152, 0, '16'),
(387, 153, 0, '21'),
(388, 154, 0, '16'),
(389, 155, 0, '15'),
(390, 158, 0, '15'),
(391, 162, 0, '16'),
(392, 163, 0, '15'),
(393, 164, 0, '15'),
(394, 165, 0, '15'),
(395, 166, 0, '15'),
(396, 167, 0, '15'),
(397, 168, 0, '15'),
(398, 171, 0, '16'),
(399, 172, 0, '15'),
(400, 173, 0, '15'),
(401, 174, 0, '15'),
(402, 175, 0, '21'),
(403, 176, 0, '15'),
(404, 177, 0, '15'),
(405, 178, 0, '16'),
(406, 179, 0, '16');

#
# Contenu de la table `joueur`
#

INSERT INTO joueur (id_joueur, numero_fft, classement, nom, prenom, annee, sexe, portable, fixe, e_mail, moyen_paiement, solde) VALUES (1, '3792964L', 16, 'BLANCHE', 'Joel', 1960, 'm', '0660927639', '', '\r\n', 'espece', 0),
(2, '9216140T', 17, 'CALVARIN', 'Mathieu', 1988, 'm', '0671482138', '', '\r\n', 'espece', 0),
(3, '6107321S', 13, 'CHAREAU', 'François', 1960, 'm', '0607825697', '', '\r\n', 'espece', 0),
(4, '3014713L', 18, 'CHAREAU', 'PAUL', 1993, 'm', '06.07.82.56.97', '', '\r\n', 'espece', 0),
(5, '2432703S', 13, 'CHAREAU', 'Marie', 1990, 'f', '0607825697', '', '\r\n', 'espece', 0),
(6, '9477159J', 7, 'L HEGARAT', 'Lucie', 1988, 'f', '06 26 68 73 74', '', '\r\n', 'espece', 0),
(7, '4962438D', 18, 'PEZRON', 'Juliette', 1992, 'f', '06.15.71.61.98', '', '\r\n', 'espece', 0),
(8, '2288277G', 18, 'PLATEL PARIS', 'Clémentine', 1993, 'f', '', '02.96.23.89.03', '\r\n', 'espece', 0),
(9, '4353588K', 18, 'LAUDREN', 'Cécile', 1992, 'f', '', '0296238746', '\r\n', 'espece', 0),
(10, '4297210E', 18, 'CHAREAU', 'Hélène', 1995, 'f', '06.07.82.56.97', '', '\r\n', 'espece', 0),
(11, '8020092R', 7, 'GIARD CLOLUS', 'Lucas', 1989, 'm', '', '02.96.23.85.34', '\r\n', 'espece', 0),
(12, '3924494D', 16, 'LANGE', 'Alexandre', 1979, 'm', '06.63.29.79.11', '', '\r\n', 'espece', 0),
(13, '3306047D', 16, 'LANGE', 'Christophe', 1988, 'm', '', '02.96.91.81.29', '\r\n', 'espece', 0),
(14, '1693487W', 8, 'LE BERRE', 'Emeric', 1977, 'm', '0603242124', '', '\r\n', 'espece', 0),
(15, '2320213V', 10, 'LELAY', 'Erwan', 1959, 'm', '0611629077', '02.96.54.19.30', '\r\n', 'espece', 0),
(16, '2320659E', 17, 'LE LANNOU', 'Romain', 1988, 'm', '', '0296153377', '\r\n', 'espece', 0),
(17, '4173113S', 17, 'SOUBIEUX', 'Benjamin', 1989, 'm', '', '0296231065', '\r\n', 'espece', 0),
(18, '4082418K', 12, 'VADON', 'Amaury', 1987, 'm', '0610516656', '', '\r\n', 'espece', 0),
(19, '2333477M', 13, 'PRAT', 'Eric', 1967, 'm', '0687923544', '', '\r\n', 'espece', 0),
(20, '4429531G', 17, 'WESSE', 'Jean Pierre', 1947, 'm', '', '02.96.19.60.47', '\r\n', 'espece', 0),
(21, '4039107H', 18, 'LAUDREN', 'Hugo', 1993, 'm', '', '02.96.23.87.46', '\r\n', 'espece', 0),
(22, '2544043N', 18, 'GRANGE', 'Maxime', 1992, 'm', '06.60.50.87.77', '', '\r\n', 'espece', 0),
(23, '2274535V', 18, 'MORIN', 'Arthur', 1994, 'm', '0679575148', '0296451135', '\r\n', 'espece', 0),
(24, '4960402R', 18, 'RISPAL', 'Rémi', 1990, 'm', '', '0296912519', '\r\n', 'espece', 0),
(25, '2853670P', 17, 'OOGHE', 'Joris', 1991, 'm', '', '0296154681', '\r\n', 'espece', 0),
(26, '1339701W', 18, 'RECEVEUR', 'Ethienne', 1991, 'm', '', '', '\r\n', 'espece', 0),
(27, '2541157B', 18, 'RECEVEUR', 'Nils', 1993, 'm', '', '', '\r\n', 'espece', 0),
(28, '3721209S', 16, 'GADALA', 'Max', 1991, 'm', '0611560023', '', '\r\n', 'espece', 0),
(29, '3721210T', 15, 'GADALA', 'Antoine', 1992, 'm', '', '', '\r\n', 'espece', 0),
(30, '4151501A', 14, 'LE BIVIC', 'Mathieu', 1992, 'm', '', '', '\r\n', 'espece', 0),
(31, '6977223M', 13, 'QUEGUINER', 'Guy', 1938, 'm', '', '', '\r\n', 'espece', 0),
(32, '6977224N', 12, 'QUEGUINER', 'Annick', 1942, 'f', '0616074809', '', '\r\n', 'espece', 0),
(33, '1378626F', 12, 'FARAGGI', 'Olivier', 1988, 'm', '', '0296238296', '\r\n', 'espece', 0),
(34, '2578000Y', 18, 'BOULET', 'Timothé', 1992, 'm', '', '0296238296', '\r\n', 'espece', 0),
(35, '4700411S', 18, 'TOSANI', 'César', 1991, 'm', '0620283796', '0296919536', '\r\n', 'espece', 0),
(36, '', 16, 'HELLEGOUARCH', 'Christophe', 1988, 'm', '0674138687', '', '\r\n', 'espece', 0),
(37, '6279663V', 16, 'ANDRIEUX', 'Michel', 1951, 'm', '', '', '\r\n', 'espece', 0),
(38, '', 18, 'JOURNEAUX', 'Morgane', 1992, 'f', '', '', '\r\n', 'espece', 0),
(39, '4151177Y', 18, 'FONTAINE', 'Jean Pierre', 1946, 'm', '', '', '\r\n', 'espece', 0),
(40, '', 18, 'BOLELLI', 'Louis', 1992, 'm', '', '0296234714', '\r\n', 'espece', 0),
(41, '', 6, 'MATHOREZ', 'Arthur', 1982, 'm', '', '', '\r\n', 'espece', 0),
(42, '4150702G', 14, 'DELOUIS', 'Nicolas', 1977, 'm', '0611489107', '', '\r\n', 'espece', 0),
(43, '0704716V', 14, 'LEFEVRE', 'Jacqueline', 1945, 'f', '', '0296925569', '\r\n', 'espece', 0),
(44, '0483926F', 9, 'GUITON', 'David', 1966, 'm', '', '', '\r\n', 'espece', 0),
(45, '', 18, 'GUITON', 'Jules', 1992, 'm', '0680307805', '0296919672', '\r\n', 'espece', 0),
(46, '', 1, 'TILLY', 'Stephane', 1979, 'm', '0684432712', '', '\r\n', 'espece', 0),
(47, '4789664F', 18, 'GUILLOT', 'Clement', 1981, 'm', '', '', '\r\n', 'espece', 0),
(48, '5713087B', 13, 'LE CAM', 'Françoise', 1946, 'f', '', '', '\r\n', 'espece', 0),
(49, '4954015Y', 18, 'SALOU', 'Erwan', 1994, 'm', '', '0296430976', '\r\n', 'espece', 0),
(50, '6180715T', 3, 'TEJEDOR', 'Marie Annick', 1980, 'f', '', '', '\r\n', 'espece', 0),
(51, '3045145P', 13, 'JANCERT', 'Amelie', 1979, 'f', '0668362200', '', '\r\n', 'espece', 0),
(52, '8462933P', 10, 'ROTH', 'Yannick', 1987, 'm', '', '0296912721', '\r\n', 'espece', 0),
(53, '4937381T', 18, 'GREGOIRE', 'Arnaud', 1975, 'm', '0663852212', '', '\r\n', 'espece', 0),
(54, '1693305Y', 15, 'LOYER', 'Philippe', 1988, 'm', '0680085024', '', '\r\n', 'espece', 0),
(55, '', 18, 'LE DAUPHIN', 'Guirec', 1989, 'm', '', '', '\r\n', 'espece', 0),
(56, '', 18, 'MARREC', 'Damien', 1992, 'm', '', '0296230844', '\r\n', 'espece', 0),
(57, '3043105X', 12, 'THIEURY', 'Nicolas', 1990, 'm', '', '', '\r\n', 'espece', 0),
(58, '', 16, 'VUYLSTEKER', 'Jean Jacques', 1938, 'm', '', '0296912168', '\r\n', 'espece', 0),
(59, '4762769X', 18, 'VUYLSTECKER', 'Martin', 1989, 'm', '', '0296912168', '\r\n', 'espece', 0),
(60, '5708032G', 5, 'LE MORZADEC', 'Pierre', 1972, 'm', '', '', '\r\n', 'espece', 0),
(61, '3124260J', 18, 'GHISOLFI', 'Laure', 1993, 'f', '', '', '\r\n', 'espece', 0),
(62, '2544745B', 18, 'GHISOLFI', 'Claire', 1991, 'f', '', '', '\r\n', 'espece', 0),
(63, '4762726A', 18, 'LEMOINE', 'Christophe', 1966, 'm', '', '0296916571', '\r\n', 'espece', 0),
(64, '', 15, 'LEMIERE', 'Charlie', 1987, 'm', '', '', '\r\n', 'espece', 0),
(65, '', 12, 'ANDRE', 'Bernard', 1947, 'm', '', '', '\r\n', 'espece', 0),
(66, '5071042B', 13, 'QUEMPER', 'Francois', 1979, 'm', '', '', '\r\n', 'espece', 0),
(67, '3922463W', 18, 'OLIVA', 'François', 1987, 'm', '', '0296154447', '\r\n', 'espece', 0),
(68, '2358835A', 15, 'HAYS', 'Cesar', 1990, 'm', '', '', '\r\n', 'espece', 0),
(69, '2914789Y', 18, 'HAYS', 'Marceau', 1993, 'm', '0615449164', '', '\r\n', 'espece', 0),
(70, '4761610M', 18, 'BERNARD', 'Cyrille', 1975, 'm', '0603511165', '', '\r\n', 'espece', 0),
(71, '4151115F', 11, 'OUBRERIE', 'Olivier', 1962, 'm', '', '', '\r\n', 'espece', 0),
(72, '3504081H', 8, 'DARRORT', 'Vincent', 1969, 'm', '', '', '\r\n', 'espece', 0),
(73, '3821566A', 18, 'DEMARQUAY', 'Jonathan', 1991, 'm', '0680089867', '', '\r\n', 'espece', 0),
(74, '5775226V', 1, 'FONTAINE', 'David', 1968, 'm', '', '', '\r\n', 'espece', 0),
(75, '1693196E', 15, 'LE MAILLOT', 'Samuel', 1977, 'm', '', '', '\r\n', 'espece', 0),
(76, '5656335P', 7, 'HAMELIN', 'Gregory', 1970, 'm', '0681933343', '', '\r\n', 'espece', 0),
(77, '1073924H', 10, 'MARC', 'Charly', 1988, 'm', '0686776073', '0296437683', '\r\n', 'espece', 0),
(78, '5962937C', 6, 'LE MONNIER', 'Cedric', 1979, 'm', '0684511562', '', '\r\n', 'espece', 0),
(79, '', 8, 'BURLE', 'Cedric', 1979, 'm', '0682036582', '', '\r\n', 'espece', 0),
(80, '', 8, 'BURLET', 'Nicolas', 1979, 'm', '0663350828', '', '\r\n', 'espece', 0),
(81, '', 14, 'ANCELY', 'Pierre', 1992, 'm', '', '', '\r\n', 'espece', 0),
(82, '', 12, 'LAIGNELOT', 'Remi', 1991, 'm', '', '', '\r\n', 'espece', 0),
(83, '', 16, 'PUJOL JACOMI', 'Remi', 1992, 'm', '', '', '\r\n', 'espece', 0),
(84, '', 15, 'MERCIER', 'Quentin', 1979, 'm', '', '', '\r\n', 'espece', 0),
(85, '', 14, 'VIDAL', 'Raphael', 1987, 'm', '0616902339', '', '\r\n', 'espece', 0),
(86, '', 13, 'LACROIX', 'Jonathan', 1990, 'm', '', '', '\r\n', 'espece', 0),
(87, '', 12, 'VILLEROUX', 'Thomas', 1988, 'm', '0616902339', '', '\r\n', 'espece', 0),
(88, '9280920F', 14, 'THIEURMEL', 'Thomas', 1986, 'm', '', '0296464575', '\r\n', 'espece', 0),
(89, '', 14, 'CORNUDET', 'Valerian', 1991, 'm', '', '', '\r\n', 'espece', 0),
(90, '', 11, 'CORNUDET', 'Yves', 1955, 'm', '', '', '\r\n', 'espece', 0),
(91, '4222945G', 16, 'CHEVALIER', 'Patrick', 1955, 'm', '', '', '\r\n', 'espece', 0),
(92, '4222927M', 16, 'CHEVALIER', 'Sophie', 1983, 'f', '', '', '\r\n', 'espece', 0),
(93, '5565480J', 9, 'JEZEQUEL', 'Yves', 1961, 'm', '', '', '\r\n', 'espece', 0),
(94, '2854692A', 18, 'BOUESSEL-DUBOURG', 'Audren', 1988, 'm', '0608761771', '', '\r\n', 'espece', 0),
(95, '3506690U', 14, 'BOUESSEL-DUBOURG', 'Malo', 1960, 'm', '0612606970', '', '\r\n', 'espece', 0),
(96, '3506681J', 14, 'BOUESSEL-DUBOURG', 'Gwendal', 1986, 'm', '0612606970', '', '\r\n', 'espece', 0),
(97, '2854708T', 15, 'BOUESSEL-DUBOURG', 'Sophie', 1960, 'f', '', '', '\r\n', 'espece', 0),
(98, '2854691Z', 18, 'BOUESSEL-DUBOURG', 'Lila', 1991, 'f', '', '', '\r\n', 'espece', 0),
(99, '5043567M', 18, 'JOUVE', 'Olivier', 1989, 'm', '0671754357', '0296234125', '\r\n', 'espece', 0),
(100, '4167641U', 18, 'LEBRANCHU', 'Quentin', 1990, 'm', '', '', '\r\n', 'espece', 0),
(101, '9257445P', 10, 'LE MAILLOT', 'Pierrick', 1980, 'm', '', '', '\r\n', 'espece', 0),
(102, '3307308Z', 15, 'TANGUY', 'Vincent', 1987, 'm', '0666427441', '0298674238', '\r\n', 'espece', 0),
(103, '7892163M', 12, 'NICARD', 'Stephane', 1975, 'm', '', '0296154996', '\r\n', 'espece', 0),
(104, '', 13, 'LE SAGE', 'Jean', 1954, 'm', '', '', '\r\n', 'espece', 0),
(105, '5603106G', 16, 'CARMES', 'Paul', 1979, 'm', '', '', '\r\n', 'espece', 0),
(106, '', 12, 'DE PENGUERN', 'Tugdual', 1990, 'm', '', '', '\r\n', 'espece', 0),
(107, '', 16, 'JUNET', 'Louis', 1994, 'm', '', '', '\r\n', 'espece', 0),
(108, '8951844P', 13, 'TALLAGRAND', 'Thierry', 1959, 'm', '0607148216', '', '\r\n', 'cheque', 0),
(109, '', 11, 'JUNET', 'Paul', 1988, 'm', '', '', '\r\n', 'espece', 0),
(110, '3927526Z', 9, 'MEYER', 'Mireille', 1987, 'f', '', '', '\r\n', 'espece', 0),
(111, '4541828U', 18, 'BRIEND', 'Nicolas', 1987, 'm', '', '0296231213', '\r\n', 'espece', 0),
(112, '', 17, 'MENDES', 'Alexi', 1991, 'm', '', '', '\r\n', 'espece', 0),
(113, '4761625D', 18, 'LEROUX', 'Devrig', 1975, 'm', '0688171615', '', '\r\n', 'espece', 0),
(114, '3531883C', 16, 'BEAUVERGER', 'Gaetan', 1991, 'm', '', '', '\r\n', 'espece', 0),
(115, '', 11, 'BROUILLARD', 'Monique', 1948, 'f', '', '', '\r\n', 'espece', 0),
(116, '2076614N', 14, 'LOUVEL', 'Remi', 1988, 'm', '', '0296484001', '\r\n', 'espece', 0),
(117, '4150591L', 14, 'PHAM-HUNG', 'Romain', 1989, 'm', '', '0296489219', '\r\n', 'espece', 0),
(118, '0158091M', 13, 'MEZERETTE', 'Karl', 1990, 'm', '', '0296372310', '\r\n', 'espece', 0),
(119, '5600621F', 5, 'LE ROLLAND', 'Anne-Frédérique', 1969, 'f', '0668831357', '', '\r\n', 'espece', 0),
(120, '3531558Z', 16, 'AUDRY', 'Erika', 1991, 'f', '', '0296916382', '\r\n', 'espece', 0),
(121, '3531557Y', 18, 'AUDRY', 'Solveig', 1988, 'f', '', '', '\r\n', 'espece', 0),
(122, '', 8, 'GOURIOU', 'Yves', 1965, 'm', '', '0296234760', '\r\n', 'espece', 0),
(123, '', 16, 'GOURIOU', 'Morgane', 1991, 'f', '', '0296234760', '\r\n', 'espece', 0),
(124, '', 18, 'THIEURY', 'Charles', 1994, 'm', '0682235789', '', '\r\n', 'espece', 0),
(125, '3704958C', 16, 'THIEURY', 'François', 1961, 'm', '0682235789', '', '\r\n', 'espece', 0),
(126, '4534091J', 18, 'LE DU', 'Yohann', 1982, 'm', '0620274567', '', '\r\n', 'espece', 0),
(127, '6548745A', 15, 'REPPERT', 'Daniele', 1956, 'f', '0689047979', '', '\r\n', 'espece', 0),
(128, '2319697J', 13, 'SOUSA', 'Emmanuel', 1968, 'm', '', '', '\r\n', 'espece', 0),
(129, '', 15, 'MASSON', 'Ronan', 1991, 'm', '', '0296480784', '\r\n', 'espece', 0),
(130, '', 15, 'MASSON', 'Patrick', 1957, 'm', '', '0296480784', '\r\n', 'espece', 0),
(131, '2323627F', 12, 'BUREL', 'Guillaume', 1984, 'm', '0672528737', '', '\r\n', 'espece', 0),
(132, '3306036S', 18, 'BONNY', 'Charlotte', 1991, 'f', '', '', '\r\n', 'espece', 0),
(133, '3306043Z', 16, 'BONNY', 'Nathalie', 1968, 'f', '0675681169', '0296159069', '\r\n', 'espece', 0),
(134, '8208448A', 8, 'COURTEL', 'Julie', 1985, 'f', '0682006680', '0296463444', '\r\n', 'espece', 0),
(135, '2878459J', 12, 'VOURCH', 'Mathieu', 1989, 'm', '', '', '\r\n', 'espece', 0),
(136, '0480567E', 14, 'BOURGES', 'Thomas', 1985, 'm', '', '', '\r\n', 'espece', 0),
(137, '3530964D', 17, 'BOUBENNEC', 'Mathieu', 1993, 'm', '', '0296389557', '\r\n', 'espece', 0),
(138, '1953171L', 14, 'KUNTZMANN', 'Michel', 1950, 'm', '', '', '\r\n', 'espece', 0),
(139, '5627198U', 5, 'CHEYMOL', 'Patrick', 1972, 'm', '0662819903', '', '\r\n', 'espece', 0),
(140, '4944840A', 18, 'FRANCOIS', 'Patrick', 1952, 'm', '', '', '\r\n', 'espece', 0),
(141, '8566221J', 12, 'PASCO', 'Eric', 1979, 'm', '0682923718', '', '\r\n', 'espece', 0),
(142, '', 8, 'MARTIN', 'Emilie', 1979, 'f', '', '', '\r\n', 'espece', 0),
(143, '', 13, 'LENAOURES', 'Claire', 1979, 'f', '', '0296156448', '\r\n', 'espece', 0),
(144, '8204571L', 13, 'BIENVENUT', 'Florence', 1979, 'f', '', '0296151872', '\r\n', 'espece', 0),
(145, '', 13, 'GRANDPIERRE', 'Gautier', 1979, 'm', '0674352479', '', '\r\n', 'espece', 0),
(146, '', 12, 'GRANDPIERRE', 'Josiane', 1979, 'f', '', '', '\r\n', 'espece', 0),
(147, '', 16, 'MARTIN', 'Marie-Christine', 1979, 'f', '', '0296154297', '\r\n', 'espece', 0),
(148, '1921793E', 9, 'THERENCY', 'Priska', 1979, 'f', '0672228264', '', '\r\n', 'espece', 0),
(149, '', 9, 'ROUDET', 'Olivier', 1978, 'm', '', '', '\r\n', 'espece', 0),
(150, '', 10, 'QUIGNON', 'Clément', 1979, 'm', '', '', '\r\n', 'espece', 0),
(151, '4535689W', 18, 'PEZRON', 'Sébastien', 1987, 'm', '', '0296232607', '\r\n', 'espece', 0),
(152, '7466741X', 9, 'LE MOUHAER', 'Marie', 1984, 'f', '', '0296924671', '\r\n', 'espece', 0),
(153, '', 12, 'FAMEL', 'Lambert', 1991, 'm', '', '', '\r\n', 'espece', 0),
(154, '', 13, 'LANDOIS', 'Julie', 1980, 'f', '', '', '\r\n', 'espece', 0),
(155, '', 18, 'BASSE', 'Antoine', 1979, 'm', '0660928874', '', '\r\n', 'espece', 0),
(156, '', 11, 'RICARD', 'Jacques', 1979, 'm', '', '0296239311', '\r\n', 'espece', 0),
(157, '0480684G', 14, 'THEVENON', 'Hervé', 1979, 'm', '0622731465', '0296996585', '\r\n', 'espece', 0),
(158, '5821014N', 10, 'GARGAN', 'Gaby', 1979, 'm', '', '0296053943', '\r\n', 'espece', 0),
(159, '', 11, 'LE COUTELLER', 'Henriette', 1979, 'f', '', '', '\r\n', 'espece', 0),
(160, '', 15, 'LE GAOUYAT', 'Yvon', 1979, 'm', '', '', '\r\n', 'espece', 0),
(161, '', 10, 'LE GAOUYAT', 'Odile', 1979, 'f', '0663776943', '0296914451', '\r\n', 'espece', 0),
(162, '', 6, 'LE GAOUYAT', 'Caroline', 1979, 'f', '', '', '\r\n', 'espece', 0),
(163, '', 18, 'X', '', 1979, 'm', '', '', '\r\n', 'espece', 0),
(164, '', 18, 'Y', '', 1979, 'm', '', '', '\r\n', 'espece', 0),
(165, '', 18, 'Z', '', 1979, 'm', '', '', '\r\n', 'espece', 0),
(166, '8567004K', 9, 'FLOCH', 'Julien', 1981, 'm', '0661124274', '', '\r\n', 'espece', 0),
(167, '', 12, 'LEGAUD', 'Nicolas', 1979, 'm', '', '', '\r\n', 'espece', 0),
(168, '5595111S', 3, 'DOLLO', 'Loic', 1979, 'm', '0662248273', '', '\r\n', 'espece', 0),
(169, '5633469K', 14, 'COUDRIN', 'Jean Roland', 1945, 'm', '', '', '\r\n', 'espece', 0),
(170, '', 11, 'NICOL', 'Daniel', 1979, 'm', '', '', '\r\n', 'espece', 0),
(171, '', 5, 'FURET', 'Aurélie', 1979, 'f', '', '', '\r\n', 'espece', 0),
(172, '', 12, 'LE CHEVALIER', 'Yann', 1979, 'm', '', '', '\r\n', 'espece', 0),
(173, '', 12, 'LE CHEVALIER', '', 1979, 'm', '', '', '\r\n', 'espece', 0),
(174, '', 6, 'GALPIN', 'Martin', 1979, 'm', '', '', '\r\n', 'espece', 0),
(175, '', 13, 'GALPIN', 'Clément', 1979, 'm', '', '', '\r\n', 'espece', 0),
(176, '5897887W', 4, 'PLAZA', 'Christophe', 1979, 'm', '', '', '\r\n', 'cheque', 0),
(177, '', 6, 'ARNAUD', 'Tristan', 1984, 'm', '', '', '\r\n', 'espece', 0),
(178, '', 3, 'LE QUEMENER', 'Sylvie', 1979, 'f', '', '', '\r\n', 'espece', 0),
(179, '', 10, 'JERON', 'Véronique', 1979, 'f', '0689095149', '0296702054', '\r\n', 'espece', 0),
(182, '0000002b', 18, 'janvier', 'senior', 1954, 'm', '02-xx-xx-xx-xx', '', '', 'cheque', 0),
(181, '0000001a', 15, 'janvier', 'jerome', 1982, 'm', '', '06-42-36-58-12', '', 'cheque', 0),
(180, '5660707S', 11, 'clec\\\\\\\'h', 'vincent', 1969, 'm', '0611122277', '', 'cdc-callac@wanadoo.fr', 'cheque', 0);

#
# Contenu de la table `match`
#

INSERT INTO match (id_match, equipe_1, equipe_2, categorie, avencement, tour, ordre, vainqueur, perdant, score, jour, heure) VALUES (207, 'Q191', 'Q192', 15, 13, 3, 0, NULL, NULL, NULL, NULL, NULL),
(206, '256', '244', 15, 13, 2, 15, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(205, '301', '257', 15, 13, 2, 14, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(204, '310', '282', 15, 13, 2, 13, NULL, NULL, NULL, 'sam-2005-09-07', '12h00'),
(203, '320', '283', 15, 13, 2, 12, NULL, NULL, NULL, 'sam-2005-09-07', '12h00'),
(202, '345', '334', 15, 13, 2, 11, 334, 345, '6/1-6/2', 'sam-2005-09-07', '12h00'),
(201, '288', '264', 15, 13, 2, 10, 288, 264, '6/2-4/6-7/6', 'sam-2005-09-07', '12h00'),
(200, '329', 'Q190', 15, 13, 2, 9, NULL, NULL, NULL, 'sam-2005-09-07', '15h00'),
(199, '332', 'Q189', 15, 13, 2, 8, 305, 332, '7/6-6-2', 'sam-2005-09-07', '16h30'),
(198, '338', 'Q188', 15, 13, 2, 7, NULL, NULL, NULL, NULL, NULL),
(197, '339', 'Q187', 15, 13, 2, 6, NULL, NULL, NULL, NULL, NULL),
(196, '354', 'Q186', 15, 13, 2, 5, NULL, NULL, NULL, NULL, NULL),
(195, '355', 'Q185', 15, 13, 2, 4, NULL, NULL, NULL, NULL, NULL),
(194, '372', 'Q184', 15, 13, 2, 3, NULL, NULL, NULL, NULL, NULL),
(193, '246', 'Q183', 15, 13, 2, 2, NULL, NULL, NULL, NULL, NULL),
(192, '263', 'Q182', 15, 13, 2, 1, NULL, NULL, NULL, NULL, NULL),
(191, '348', 'Q181', 15, 13, 2, 0, NULL, NULL, NULL, NULL, NULL),
(190, '294', '280', 15, 13, 1, 9, 294, 280, '6/2-6/3', 'sam-2005-09-07', '9h00'),
(189, '305', '300', 15, 13, 1, 8, 305, 300, '6/4-6/1', 'sam-2005-09-07', '9h00'),
(188, '311', '309', 15, 13, 1, 7, 309, 311, '2/6-6/3-6/3', 'sam-2005-09-07', '9h00'),
(187, '337', '315', 15, 13, 1, 6, NULL, NULL, NULL, 'sam-2005-09-07', '9h00'),
(185, '364', '352', 15, 13, 1, 4, NULL, NULL, NULL, 'sam-2005-09-07', '9h00'),
(183, '245', '392', 15, 13, 1, 2, NULL, NULL, NULL, 'sam-2005-09-07', '9h00'),
(182, '260', '393', 15, 13, 1, 1, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(181, '261', '394', 15, 13, 1, 0, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(184, '389', '385', 15, 13, 1, 3, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(175, '140', '157', 25, 16, 1, 0, NULL, NULL, NULL, NULL, NULL),
(176, '121', '77', 25, 16, 1, 1, NULL, NULL, NULL, NULL, NULL),
(177, '47', '50', 25, 16, 1, 2, NULL, NULL, NULL, NULL, NULL),
(178, '2', '26', 25, 16, 1, 3, NULL, NULL, NULL, NULL, NULL),
(179, 'Q175', 'Q176', 25, 16, 2, 0, NULL, NULL, NULL, NULL, NULL),
(180, 'Q177', 'Q178', 25, 16, 2, 1, NULL, NULL, NULL, NULL, NULL),
(186, '350', '342', 15, 13, 1, 5, NULL, NULL, NULL, 'sam-2005-09-07', '10h30'),
(208, 'Q193', 'Q194', 15, 13, 3, 1, NULL, NULL, NULL, NULL, NULL),
(209, 'Q195', 'Q196', 15, 13, 3, 2, NULL, NULL, NULL, NULL, NULL),
(210, 'Q197', 'Q198', 15, 13, 3, 3, NULL, NULL, NULL, NULL, NULL),
(211, 'Q199', 'Q200', 15, 13, 3, 4, NULL, NULL, NULL, NULL, NULL),
(212, 'Q201', 'Q202', 15, 13, 3, 5, NULL, NULL, NULL, NULL, NULL),
(213, 'Q203', 'Q204', 15, 13, 3, 6, NULL, NULL, NULL, NULL, NULL),
(214, 'Q205', 'Q206', 15, 13, 3, 7, NULL, NULL, NULL, NULL, NULL),
(215, 'Q207', 'Q208', 15, 13, 4, 0, NULL, NULL, NULL, NULL, NULL),
(216, 'Q209', 'Q210', 15, 13, 4, 1, NULL, NULL, NULL, NULL, NULL),
(217, 'Q211', 'Q212', 15, 13, 4, 2, NULL, NULL, NULL, NULL, NULL),
(218, 'Q213', 'Q214', 15, 13, 4, 3, NULL, NULL, NULL, NULL, NULL),
(219, '225', '231', 12, 13, 1, 0, 225, 231, '6/2-6/3', 'dim-2005-10-07', '15h00'),
(220, '222', '214', 12, 13, 1, 1, 214, 222, '2/6-6/1-7/6', 'dim-2005-10-07', '15h00'),
(221, '209', '210', 12, 13, 1, 2, 209, 210, '6/4-6/4', 'dim-2005-10-07', '15h00'),
(222, '202', '206', 12, 13, 1, 3, 206, 202, '6/3-6/3', 'dim-2005-10-07', '15h00'),
(223, '227', 'Q219', 12, 13, 2, 0, NULL, NULL, NULL, 'dim-2005-10-07', '15h00'),
(224, '223', 'Q220', 12, 13, 2, 1, NULL, NULL, NULL, 'dim-2005-10-07', '15h00'),
(225, '221', 'Q221', 12, 13, 2, 2, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(226, '216', 'Q222', 12, 13, 2, 3, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(227, '207', '240', 12, 13, 2, 4, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(228, '205', '228', 12, 13, 2, 5, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(229, '203', '242', 12, 13, 2, 6, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(230, '237', '230', 12, 13, 2, 7, NULL, NULL, NULL, 'dim-2005-10-07', '16h30'),
(231, 'Q223', 'Q224', 12, 13, 3, 0, NULL, NULL, NULL, NULL, NULL),
(232, 'Q225', 'Q226', 12, 13, 3, 1, NULL, NULL, NULL, NULL, NULL),
(233, 'Q227', 'Q228', 12, 13, 3, 2, NULL, NULL, NULL, NULL, NULL),
(234, 'Q229', 'Q230', 12, 13, 3, 3, NULL, NULL, NULL, NULL, NULL),
(235, '370', '359', 16, 0, 1, 0, NULL, NULL, NULL, NULL, NULL),
(236, '386', '381', 16, 0, 1, 1, NULL, NULL, NULL, NULL, NULL),
(237, '382', '369', 16, 0, 1, 2, NULL, NULL, NULL, NULL, NULL),
(238, '349', '361', 16, 0, 1, 3, NULL, NULL, NULL, NULL, NULL),
(239, '406', '335', 16, 0, 1, 4, NULL, NULL, NULL, NULL, NULL),
(240, '380', '365', 16, 0, 1, 5, NULL, NULL, NULL, NULL, NULL),
(241, '388', '340', 16, 0, 1, 6, NULL, NULL, NULL, NULL, NULL),
(242, '377', '289', 16, 0, 1, 7, NULL, NULL, NULL, NULL, NULL),
(243, '247', '298', 16, 0, 1, 8, NULL, NULL, NULL, NULL, NULL),
(244, '405', 'Q235', 16, 0, 2, 0, NULL, NULL, NULL, NULL, NULL),
(245, '297', 'Q236', 16, 0, 2, 1, NULL, NULL, NULL, NULL, NULL),
(246, '398', 'Q237', 16, 0, 2, 2, NULL, NULL, NULL, NULL, NULL),
(247, '357', 'Q238', 16, 0, 2, 3, NULL, NULL, NULL, NULL, NULL),
(248, '391', 'Q239', 16, 0, 2, 4, NULL, NULL, NULL, NULL, NULL),
(249, '249', 'Q240', 16, 0, 2, 5, NULL, NULL, NULL, NULL, NULL),
(250, '376', 'Q241', 16, 0, 2, 6, NULL, NULL, NULL, NULL, NULL),
(251, 'Q242', 'Q243', 16, 0, 2, 7, NULL, NULL, NULL, NULL, NULL),
(252, 'Q244', 'Q245', 16, 0, 3, 0, NULL, NULL, NULL, NULL, NULL),
(253, 'Q246', 'Q247', 16, 0, 3, 1, NULL, NULL, NULL, NULL, NULL),
(254, 'Q248', 'Q249', 16, 0, 3, 2, NULL, NULL, NULL, NULL, NULL),
(255, 'Q250', 'Q251', 16, 0, 3, 3, NULL, NULL, NULL, NULL, NULL),
(256, 'Q252', 'Q253', 16, 0, 4, 0, NULL, NULL, NULL, NULL, NULL),
(257, 'Q254', 'Q255', 16, 0, 4, 1, NULL, NULL, NULL, NULL, NULL),
(258, 'Q231', '217', 12, 0, 1, 0, NULL, NULL, NULL, NULL, NULL),
(259, 'Q232', '219', 12, 0, 1, 1, NULL, NULL, NULL, NULL, NULL),
(260, 'Q233', '236', 12, 0, 1, 2, NULL, NULL, NULL, NULL, NULL),
(261, 'Q234', '204', 12, 0, 1, 3, NULL, NULL, NULL, NULL, NULL),
(262, '215', '243', 12, 0, 1, 4, NULL, NULL, NULL, NULL, NULL),
(263, 'Q258', '238', 12, 0, 2, 0, NULL, NULL, NULL, NULL, NULL),
(264, 'Q259', '212', 12, 0, 2, 1, NULL, NULL, NULL, NULL, NULL),
(265, 'Q260', '220', 12, 0, 2, 2, NULL, NULL, NULL, NULL, NULL),
(266, 'Q261', '218', 12, 0, 2, 3, NULL, NULL, NULL, NULL, NULL),
(267, 'Q263', 'Q264', 12, 0, 3, 0, NULL, NULL, NULL, NULL, NULL),
(268, 'Q265', 'Q266', 12, 0, 3, 1, NULL, NULL, NULL, NULL, NULL),
(269, 'Q267', 'Q268', 12, 0, 4, 0, NULL, NULL, NULL, NULL, NULL);

#
# Contenu de la table `tournoi`
#

INSERT INTO tournoi (id_tournoi, debut, fin, club, type, prix_senior, prix_junior, gains, juge_arbitre, engagement) VALUES (1, '2004-07-03', '2004-07-11', 4, 'adulte', '12', '8', 680, 'Alain Hegaret', 'Gildas Legrand. Imp. Convenant de la mer 22220 Minihi-Treguer Tel.:02 96 92 26 39'),
(2, '2004-07-03', '2004-07-11', 4, 'double', '12', '8', 680, 'Alain Hegaret', 'Gildas Legrand. Imp. Convenant de la mer 22220 Minihi-Treguer Tel.:02 96 92 26 39'),
(3, '2004-07-03', '2004-07-11', 4, 'jeune', NULL, '6', 680, 'Alain Hegaret', 'Gildas Legrand. Imp. Convenant de la mer 22220 Minihi-Treguer Tel.:02 96 92 26 39'),
(4, '2005-07-09', '2005-07-17', 5, 'adulte', '12', '9', 861, 'Alain Begue', 'Alain Begue - 32 rue Tristan Corbiere 22300 Lannion Tel 02 96 37 12 93  ou Club de 17 a 18H du 5 au 10/7'),
(5, '2005-07-09', '2005-07-17', 5, 'jeune', NULL, '6', 861, 'Alain Begue', 'Alain Begue - 32 rue Tristan Corbiere 22300 Lannion Tel 02 96 37 12 93  ou Club de 17 a 18H du 5 au 10/7'),
(6, '2005-07-16', '2005-07-23', 3, 'adulte', '12.5', '8', 1210, 'Louis Gueguen', 'Club: Poul Palud 22730 Tregastel'),
(7, '2005-07-16', '2005-07-23', 3, 'double', '12.5', '8', 1210, 'Louis Gueguen', 'Club: Poul Palud 22730 Tregastel'),
(8, '2005-07-16', '2005-07-23', 3, 'mixte', '12.5', '8', 1210, 'Louis Gueguen', 'Club: Poul Palud 22730 Tregastel'),
(9, '2005-07-16', '2005-07-23', 3, 'jeune', NULL, '5.5', 1210, 'Louis Gueguen', 'Club: Poul Palud 22730 Tregastel'),
(10, '2004-08-07', '2004-08-14', 2, 'jeune', NULL, '7', 0, 'Veronique Jeron', 'TC LANNION - Park nevez rue des cordiers 22300 Lannion .06 70 52 56 66'),
(11, '2004-08-21', '2004-08-29', 1, 'adulte', '11', '6', 750, 'Eugène Briand', 'V Clech: 06 11 12 22 77 , Club , eugene.briand@wanadoo.fr'),
(12, '2004-08-21', '2004-08-29', 1, 'jeune', '11', '6', 750, 'Eugène Briand', 'V Clech: 06 11 12 22 77 , Club , eugene.briand@wanadoo.fr');