-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le :  jeu. 02 mai 2019 à 11:56
-- Version du serveur :  5.7.19
-- Version de PHP :  7.1.9

START TRANSACTION;



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

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

--
-- Structure de la table `associationpartie`
--

Create database bddv11;
use bddv11;

CREATE TABLE IF NOT EXISTS `associationpartie` (
  `idAssociation` int(11) NOT NULL AUTO_INCREMENT,
  `idPartie` int(11) DEFAULT NULL,
  `idPosition` int(11) DEFAULT NULL,
  `idTemps` int(11) DEFAULT NULL,
  `idValidation` int(11) DEFAULT NULL,
  `idObstacle` int(11) NOT NULL,
  PRIMARY KEY (`idAssociation`),
  KEY `AssociationTOtemps` (`idTemps`),
  KEY `AssociationTOvalidation` (`idValidation`),
  KEY `idPartie` (`idPartie`),
  KEY `IDX_F88B61CC158FCEAE` (`idPosition`),
  KEY `idObstacle` (`idObstacle`)
) ENGINE=InnoDB AUTO_INCREMENT=293 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `associationpartie` (`idAssociation`, `idPartie`, `idPosition`, `idTemps`, `idValidation`, `idObstacle`) VALUES
(53, 30, 1, 8, 3, 4),
(54, 30, 2, 11, 1, 4),
(55, 30, 3, 2, 9, 8),
(56, 30, 4, 10, 11, 1),
(57, 30, 5, 10, 4, 1),
(58, 30, 6, 6, 7, 3),
(59, 30, 7, 3, 6, 1),
(60, 30, 8, 11, 12, 1),
(61, 30, 9, 2, 1, 1),
(62, 30, 10, 13, 8, 7),
(63, 30, 11, 7, 5, 6),
(64, 30, 12, 3, 2, 13),
(65, 31, 1, 4, 7, 13),
(66, 31, 2, 6, 3, 2),
(67, 31, 3, 10, 4, 4),
(68, 31, 4, 12, 1, 7),
(69, 31, 5, 9, 9, 11),
(70, 31, 6, 6, 2, 4),
(71, 31, 7, 8, 12, 12),
(72, 31, 8, 1, 1, 1),
(73, 31, 9, 5, 12, 5),
(74, 31, 10, 3, 10, 13),
(75, 31, 11, 7, 1, 1),
(76, 31, 12, 10, 11, 9),
(113, 59, 1, 4, 7, 13),
(114, 59, 2, 6, 3, 2),
(115, 59, 3, 10, 4, 4),
(116, 59, 4, 12, 1, 7),
(117, 59, 5, 9, 9, 11),
(118, 59, 6, 6, 2, 4),
(119, 59, 7, 8, 12, 12),
(120, 59, 8, 1, 1, 1),
(121, 59, 9, 5, 12, 5),
(122, 59, 10, 3, 10, 13),
(123, 59, 11, 7, 1, 1),
(124, 59, 12, 10, 11, 9),
(125, 38, 1, 4, 7, 13),
(126, 38, 2, 6, 3, 2),
(127, 38, 3, 10, 4, 4),
(128, 38, 4, 12, 1, 7),
(129, 38, 5, 9, 9, 11),
(130, 38, 6, 6, 2, 4),
(131, 38, 7, 8, 12, 12),
(132, 38, 8, 1, 1, 1),
(133, 38, 9, 5, 12, 5),
(134, 38, 10, 3, 10, 13),
(135, 38, 11, 7, 1, 1),
(136, 38, 12, 10, 11, 9),
(137, 73, 1, 4, 7, 13),
(138, 73, 2, 6, 3, 2),
(139, 73, 3, 10, 4, 4),
(140, 73, 4, 12, 1, 7),
(141, 73, 5, 9, 9, 11),
(142, 73, 6, 6, 2, 4),
(143, 73, 7, 8, 12, 12),
(144, 73, 8, 1, 1, 1),
(145, 73, 9, 5, 12, 5),
(146, 73, 10, 3, 10, 13),
(147, 73, 11, 7, 1, 1),
(148, 73, 12, 10, 11, 9),
(149, 66, 1, 4, 7, 13),
(150, 66, 2, 6, 3, 2),
(151, 66, 3, 10, 4, 4),
(152, 66, 4, 12, 1, 7),
(153, 66, 5, 9, 9, 11),
(154, 66, 6, 6, 2, 4),
(155, 66, 7, 8, 12, 12),
(156, 66, 8, 1, 1, 1),
(157, 66, 9, 5, 12, 5),
(158, 66, 10, 3, 10, 13),
(159, 66, 11, 7, 1, 1),
(160, 66, 12, 10, 11, 9),
(161, 80, 1, 4, 7, 13),
(162, 80, 2, 6, 3, 2),
(163, 80, 3, 10, 4, 4),
(164, 80, 4, 12, 1, 7),
(165, 80, 5, 9, 9, 11),
(166, 80, 6, 6, 2, 4),
(167, 80, 7, 8, 12, 12),
(168, 80, 8, 1, 1, 1),
(169, 80, 9, 5, 12, 5),
(170, 80, 10, 3, 10, 13),
(171, 80, 11, 7, 1, 1),
(172, 80, 12, 10, 11, 9),
(173, 45, 1, 4, 7, 13),
(174, 45, 2, 6, 3, 2),
(175, 45, 3, 10, 4, 4),
(176, 45, 4, 12, 1, 7),
(177, 45, 5, 9, 9, 11),
(178, 45, 6, 6, 2, 4),
(179, 45, 7, 8, 12, 12),
(180, 45, 8, 1, 1, 1),
(181, 45, 9, 5, 12, 5),
(182, 45, 10, 3, 10, 13),
(183, 45, 11, 7, 1, 1),
(184, 45, 12, 10, 11, 9),
(185, 52, 1, 4, 7, 13),
(186, 52, 2, 6, 3, 2),
(187, 52, 3, 10, 4, 4),
(188, 52, 4, 12, 1, 7),
(189, 52, 5, 9, 9, 11),
(190, 52, 6, 6, 2, 4),
(191, 52, 7, 8, 12, 12),
(192, 52, 8, 1, 1, 1),
(193, 52, 9, 5, 12, 5),
(194, 52, 10, 3, 10, 13),
(195, 52, 11, 7, 1, 1),
(196, 52, 12, 10, 11, 9),
(197, 32, 1, 4, 7, 13),
(198, 32, 2, 6, 3, 2),
(199, 32, 3, 10, 4, 4),
(200, 32, 4, 12, 1, 7),
(201, 32, 5, 9, 9, 11),
(202, 32, 6, 6, 2, 4),
(203, 32, 7, 8, 12, 12),
(204, 32, 8, 1, 1, 1),
(205, 32, 9, 5, 12, 5),
(206, 32, 10, 3, 10, 13),
(207, 32, 11, 7, 1, 1),
(208, 32, 12, 10, 11, 9),
(209, 39, 1, 4, 7, 13),
(210, 39, 2, 6, 3, 2),
(211, 39, 3, 10, 4, 4),
(212, 39, 4, 12, 1, 7),
(213, 39, 5, 9, 9, 11),
(214, 39, 6, 6, 2, 4),
(215, 39, 7, 8, 12, 12),
(216, 39, 8, 1, 1, 1),
(217, 39, 9, 5, 12, 5),
(218, 39, 10, 3, 10, 13),
(219, 39, 11, 7, 1, 1),
(220, 39, 12, 10, 11, 9),
(221, 46, 1, 4, 7, 13),
(222, 46, 2, 6, 3, 2),
(223, 46, 3, 10, 4, 4),
(224, 46, 4, 12, 1, 7),
(225, 46, 5, 9, 9, 11),
(226, 46, 6, 6, 2, 4),
(227, 46, 7, 8, 12, 12),
(228, 46, 8, 1, 1, 1),
(229, 46, 9, 5, 12, 5),
(230, 46, 10, 3, 10, 13),
(231, 46, 11, 7, 1, 1),
(232, 46, 12, 10, 11, 9),
(233, 74, 1, 4, 7, 13),
(234, 74, 2, 6, 3, 2),
(235, 74, 3, 10, 4, 4),
(236, 74, 4, 12, 1, 7),
(237, 74, 5, 9, 9, 11),
(238, 74, 6, 6, 2, 4),
(239, 74, 7, 8, 12, 12),
(240, 74, 8, 1, 1, 1),
(241, 74, 9, 5, 12, 5),
(242, 74, 10, 3, 10, 13),
(243, 74, 11, 7, 1, 1),
(244, 74, 12, 10, 11, 9),
(245, 67, 1, 4, 7, 13),
(246, 67, 2, 6, 3, 2),
(247, 67, 3, 10, 4, 4),
(248, 67, 4, 12, 1, 7),
(249, 67, 5, 9, 9, 11),
(250, 67, 6, 6, 2, 4),
(251, 67, 7, 8, 12, 12),
(252, 67, 8, 1, 1, 1),
(253, 67, 9, 5, 12, 5),
(254, 67, 10, 3, 10, 13),
(255, 67, 11, 7, 1, 1),
(256, 67, 12, 10, 11, 9),
(257, 60, 1, 4, 7, 13),
(258, 60, 2, 6, 3, 2),
(259, 60, 3, 10, 4, 4),
(260, 60, 4, 12, 1, 7),
(261, 60, 5, 9, 9, 11),
(262, 60, 6, 6, 2, 4),
(263, 60, 7, 8, 12, 12),
(264, 60, 8, 1, 1, 1),
(265, 60, 9, 5, 12, 5),
(266, 60, 10, 3, 10, 13),
(267, 60, 11, 7, 1, 1),
(268, 60, 12, 10, 11, 9),
(269, 53, 1, 4, 7, 13),
(270, 53, 2, 6, 3, 2),
(271, 53, 3, 10, 4, 4),
(272, 53, 4, 12, 1, 7),
(273, 53, 5, 9, 9, 11),
(274, 53, 6, 6, 2, 4),
(275, 53, 7, 8, 12, 12),
(276, 53, 8, 1, 1, 1),
(277, 53, 9, 5, 12, 5),
(278, 53, 10, 3, 10, 13),
(279, 53, 11, 7, 1, 1),
(280, 53, 12, 10, 11, 9),
(281, 81, 1, 4, 7, 13),
(282, 81, 2, 6, 3, 2),
(283, 81, 3, 10, 4, 4),
(284, 81, 4, 12, 1, 7),
(285, 81, 5, 9, 9, 11),
(286, 81, 6, 6, 2, 4),
(287, 81, 7, 8, 12, 12),
(288, 81, 8, 1, 1, 1),
(289, 81, 9, 5, 12, 5),
(290, 81, 10, 3, 10, 13),
(291, 81, 11, 7, 1, 1),
(292, 81, 12, 10, 11, 9);

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

--
-- Structure de la table `donneravis`
--

CREATE TABLE IF NOT EXISTS `donneravis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `avis` int(11) NOT NULL,
  `commentaire` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `donneravis` (`id`, `avis`, `commentaire`) VALUES
(1, 1, 'Mauvais'),
(2, 2, 'pas bon'),
(3, 3, 'pas mal'),
(4, 4, 'bon'),
(5, 5, 'très bon'),
(6, 1, 'Horrible experience'),
(7, 2, 'Experience mauvaise'),
(8, 3, 'Experience passable'),
(9, 4, 'Bonne experience !'),
(10, 5, 'Excellente experience !'),
(11, 1, 'Ennuyeux'),
(12, 2, 'Obstacles mals placés'),
(13, 3, 'Bon effort de la part de l\'équipe\r\n'),
(14, 4, 'Superbe équipe !'),
(15, 5, 'Le parcours était génial !'),
(16, 1, 'Oubli d\'obstacles'),
(17, 2, 'J\'ai connu mieux'),
(18, 3, 'Bien mais un peu cher'),
(19, 4, 'Superbe organisation'),
(20, 5, 'Le meilleur que j\'ai essayé !'),
(21, 1, 'Je préfère le bowling'),
(22, 2, 'Nous sommes restés enfermés'),
(23, 3, 'Original'),
(24, 4, 'Equipe au top !'),
(25, 5, 'Je viens tout les jours');

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

--
-- Structure de la table `obstacle`
--

CREATE TABLE IF NOT EXISTS `obstacle` (
  `idObstacle` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idObstacle`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `obstacle` (`idObstacle`, `libelle`) VALUES
(1, 'vide'),
(2, 'haie'),
(3, 'corde'),
(4, 'poutre'),
(5, 'piscine'),
(6, 'enigme'),
(7, 'trampoline'),
(8, 'tir arc'),
(9, 'toboggan'),
(10, 'tapis course'),
(11, 'escalade'),
(12, 'ballon'),
(13, 'fosse reception');

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

--
-- Structure de la table `operation`
--

CREATE TABLE IF NOT EXISTS `operation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `somme` double NOT NULL,
  `type` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idComptable` int(11) NOT NULL,
  `idjoueurs` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idComptable` (`idComptable`),
  KEY `idjoueurs` (`idjoueurs`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `operation` (`id`, `date`, `somme`, `type`, `idComptable`, `idjoueurs`) VALUES
(1, '2010/01/01', 100, 'credit', 3, 1),
(2, '2014/10/10', 50, 'debit', 3, 2),
(3, '2016/05/25', 25, 'debit', 3, 3),
(4, '2018/12/14', 75, 'credit', 3, 4),
(5, '2015/03/30', 100, 'debit', 3, 5),
(6, '2018/04/10', 100, 'debit', 3, 6),
(7, '2017/10/24', 100, 'credit', 3, 7),
(8, '2013/11/20', 50, 'debit', 3, 8),
(9, '2017/03/30', 75, 'debit', 3, 9),
(10, '2018/05/31', 100, 'credit', 3, 10),
(11, '2019-03-15', 100, 'credit', 3, 1),
(12, '2019-03-16', 50, 'debit', 3, 2),
(13, '2019-03-17', 200, 'credit', 3, 3),
(14, '2019-03-18', 20, 'debit', 3, 4),
(15, '2019-03-19', 500, 'credit', 3, 5),
(16, '2019-03-20', 50, 'debit', 3, 6),
(17, '2019-03-21', 120, 'credit', 3, 7),
(18, '2019-03-22', 30, 'debit', 3, 8),
(19, '2019-03-23', 300, 'credit', 3, 9),
(20, '2019-03-24', 25, 'debit', 3, 10),
(21, '2019-03-25', 140, 'credit', 3, 11),
(22, '2019-03-26', 300, 'debit', 3, 12),
(23, '2019-03-27', 60, 'credit', 3, 13),
(24, '2019-03-28', 100, 'debit', 3, 14),
(25, '2019-03-29', 90, 'credit', 3, 15),
(26, '2019-03-30', 200, 'debit', 3, 16),
(27, '2019-04-01', 130, 'credit', 3, 17),
(28, '2019-04-02', 75, 'debit', 3, 18),
(29, '2019-04-03', 50, 'credit', 3, 19),
(30, '2019-04-04', 200, 'credit', 3, 20),
(31, '2019-04-05', 80, 'debit', 3, 21),
(32, '2019-04-06', 500, 'credit', 3, 22),
(33, '2019-04-07', 120, 'debit', 3, 23),
(34, '2019-04-08', 280, 'credit', 3, 24),
(35, '2018-03-24', 25, 'debit', 3, 11),
(36, '2018-03-25', 140, 'credit', 3, 12),
(37, '2018-03-26', 300, 'debit', 3, 13),
(38, '2018-03-27', 60, 'credit', 3, 14),
(39, '2018-03-28', 100, 'debit', 3, 15),
(40, '2018-03-29', 90, 'credit', 3, 16),
(41, '2018-03-30', 200, 'debit', 3, 17),
(42, '2018-04-01', 130, 'credit', 3, 18),
(43, '2018-04-02', 75, 'debit', 3, 19),
(44, '2018-04-03', 50, 'credit', 3, 20),
(45, '2018-04-04', 200, 'credit', 3, 21),
(46, '2018-04-05', 80, 'debit', 3, 22),
(47, '2018-04-06', 500, 'credit', 3, 23),
(48, '2018-04-07', 120, 'debit', 3, 24);

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

--
-- Structure de la table `partie`
--

CREATE TABLE IF NOT EXISTS `partie` (
  `idPartie` int(11) NOT NULL AUTO_INCREMENT,
  `salle` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `villeP` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dateReservation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `horaire` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nbJoueurs` int(11) NOT NULL,
  `prix` double NOT NULL,
  `idAvis` int(11) DEFAULT NULL,
  `idJoueur` int(11) DEFAULT NULL,
  `idDirecteur` int(11) NOT NULL,
  `idTechnicien` int(11) NOT NULL,
  PRIMARY KEY (`idPartie`),
  UNIQUE KEY `idPartie` (`idPartie`),
  KEY `salle` (`salle`),
  KEY `partieTOjoueur` (`idJoueur`),
  KEY `partieTOavis` (`idAvis`),
  KEY `idDirecteur` (`idDirecteur`),
  KEY `idTechnicien` (`idTechnicien`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `partie` (`idPartie`, `salle`, `villeP`, `dateReservation`, `horaire`, `nbJoueurs`, `prix`, `idAvis`, `idJoueur`, `idDirecteur`, `idTechnicien`) VALUES
(30, 'Cauchemar_Chromatique', 'Annecy', '2018-12-05', '09:30:00', 1, 30, 1, 6, 1, 1),
(31, 'Cauchemar_Chromatique', 'Annecy', '2019-05-25', '12:30:00', 2, 55, 18, 8, 1, 1),
(32, 'Cauchemar_Chromatique', 'Annecy', '2019-05-28', '14:00:00', 3, 80, 4, 12, 1, 1),
(33, 'Cauchemar_Chromatique', 'Annecy', '2019-05-27', '15:30:00', 4, 105, 13, 2, 1, 1),
(34, 'Cauchemar_Chromatique', 'Annecy', '2019-05-28', '17:00:00', 5, 130, 9, 13, 1, 1),
(35, 'Cauchemar_Chromatique', 'Annecy', '2019-05-29', '08:30:00', 6, 155, 11, 9, 1, 1),
(36, 'Cauchemar_Chromatique', 'Annecy', '2019-05-30', '10:00:00', 7, 180, 24, 4, 1, 1),
(37, 'Cauchemar_Chromatique', 'Annecy', '2019-05-31', '12:30:00', 8, 205, 10, 19, 1, 1),
(38, 'Navire', 'Annecy', '2019-05-25', '14:00:00', 1, 30, 7, 17, 1, 1),
(39, 'Navire', 'Annecy', '2019-05-31', '15:30:00', 2, 55, 8, 11, 1, 1),
(40, 'Navire', 'Annecy', '2019-05-27', '17:00:00', 3, 80, 6, 7, 1, 1),
(41, 'Navire', 'Annecy', '2019-05-28', '08:30:00', 4, 105, 17, 5, 1, 1),
(42, 'Navire', 'Annecy', '2019-05-29', '10:00:00', 5, 130, 21, 14, 1, 1),
(43, 'Navire', 'Annecy', '2019-05-30', '12:30:00', 6, 155, 25, 3, 1, 1),
(44, 'Navire', 'Annecy', '2019-05-31', '14:00:00', 7, 180, 20, 20, 1, 1),
(45, 'Ile_Perdue', 'Annecy', '2019-05-25', '17:00:00', 1, 30, 15, 16, 1, 1),
(46, 'Ile_Perdue', 'Annecy', '2019-05-25', '08:30:00', 2, 55, 1, 10, 1, 1),
(47, 'Ile_Perdue', 'Annecy', '2019-05-27', '10:00:00', 3, 80, 22, 18, 1, 1),
(48, 'Ile_Perdue', 'Annecy', '2019-05-28', '12:30:00', 4, 105, 12, 1, 1, 1),
(49, 'Ile_Perdue', 'Annecy', '2019-05-29', '14:00:00', 5, 130, 23, 6, 1, 1),
(50, 'Ile_Perdue', 'Annecy', '2019-05-30', '17:00:00', 6, 155, 16, 15, 1, 1),
(51, 'Ile_Perdue', 'Annecy', '2019-05-31', '08:30:00', 7, 180, 2, 8, 1, 1),
(52, 'Retro', 'Annecy', '2019-05-25', '10:00:00', 8, 205, 3, 12, 1, 1),
(53, 'Retro', 'Annecy', '2019-05-27', '12:30:00', 1, 30, 19, 2, 1, 1),
(54, 'Retro', 'Annecy', '2019-05-27', '14:00:00', 4, 105, 14, 9, 1, 1),
(55, 'Retro', 'Annecy', '2019-05-28', '15:30:00', 5, 130, 5, 4, 1, 1),
(56, 'Retro', 'Annecy', '2019-05-29', '15:30:00', 6, 155, 18, 19, 1, 1),
(57, 'Retro', 'Annecy', '2019-05-30', '17:00:00', 8, 205, 4, 17, 1, 1),
(58, 'Retro', 'Annecy', '2019-05-31', '08:30:00', 1, 30, 13, 11, 1, 1),
(59, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-25', '10:00:00', 2, 55, 9, 7, 1, 1),
(60, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-25', '12:30:00', 3, 80, 11, 5, 1, 1),
(61, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-27', '14:00:00', 4, 105, 24, 14, 1, 1),
(62, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-28', '15:30:00', 5, 130, 10, 3, 1, 1),
(63, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-29', '15:30:00', 6, 155, 7, 20, 1, 1),
(64, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-30', '17:00:00', 7, 180, 8, 16, 1, 1),
(65, 'Tour_Du_Monde', 'Thonons_les_bains', '2019-05-31', '08:30:00', 8, 205, 6, 10, 1, 1),
(66, 'Metropole', 'Thonons_les_bains', '2019-05-25', '10:00:00', 1, 30, 17, 18, 1, 1),
(67, 'Metropole', 'Thonons_les_bains', '2019-05-29', '12:30:00', 2, 55, 21, 1, 1, 1),
(68, 'Metropole', 'Thonons_les_bains', '2019-05-27', '14:00:00', 3, 80, 25, 6, 1, 1),
(69, 'Metropole', 'Thonons_les_bains', '2019-05-28', '15:30:00', 4, 105, 20, 15, 1, 1),
(70, 'Metropole', 'Thonons_les_bains', '2019-05-29', '17:00:00', 6, 155, 15, 8, 1, 1),
(71, 'Metropole', 'Thonons_les_bains', '2019-05-30', '08:30:00', 7, 180, 1, 12, 1, 1),
(72, 'Metropole', 'Thonons_les_bains', '2019-05-31', '10:00:00', 8, 205, 22, 2, 1, 1),
(73, 'Avion', 'Bonneville', '2019-05-25', '14:00:00', 1, 30, 12, 13, 1, 1),
(74, 'Avion', 'Bonneville', '2019-05-30', '15:30:00', 2, 55, 23, 9, 1, 1),
(75, 'Avion', 'Bonneville', '2019-05-27', '17:00:00', 3, 80, 2, 4, 1, 1),
(76, 'Avion', 'Bonneville', '2019-05-28', '08:30:00', 4, 105, 3, 19, 1, 1),
(77, 'Avion', 'Bonneville', '2019-05-29', '10:00:00', 5, 130, 19, 17, 1, 1),
(78, 'Avion', 'Bonneville', '2019-05-30', '12:30:00', 6, 155, 14, 11, 1, 1),
(79, 'Avion', 'Bonneville', '2019-05-31', '12:30:00', 7, 180, 5, 7, 1, 1),
(80, 'Univers', 'Chamonix', '2019-05-25', '14:00:00', 8, 205, 18, 5, 1, 1),
(81, 'Univers', 'Chamonix', '2019-05-27', '17:00:00', 1, 30, 4, 14, 1, 1),
(82, 'Univers', 'Chamonix', '2019-05-27', '08:30:00', 2, 55, 13, 3, 1, 1),
(83, 'Univers', 'Chamonix', '2019-05-28', '10:00:00', 3, 80, 9, 20, 1, 1),
(84, 'Univers', 'Chamonix', '2019-05-29', '12:30:00', 4, 105, 9, 16, 1, 1),
(85, 'Univers', 'Chamonix', '2019-05-30', '14:00:00', 5, 130, 11, 10, 1, 1),
(86, 'Univers', 'Chamonix', '2019-05-31', '15:30:00', 6, 155, 24, 18, 1, 1);

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

--
-- Structure de la table `position`
--

CREATE TABLE IF NOT EXISTS `position` (
  `idPosition` int(11) NOT NULL AUTO_INCREMENT,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`idPosition`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `position` (`idPosition`, `position`) VALUES
(1, 1),
(2, 2),
(3, 3),
(4, 4),
(5, 5),
(6, 6),
(7, 7),
(8, 8),
(9, 9),
(10, 10),
(11, 11),
(12, 12);

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

--
-- Structure de la table `temps`
--

CREATE TABLE IF NOT EXISTS `temps` (
  `idTemps` int(11) NOT NULL AUTO_INCREMENT,
  `libellé` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idTemps`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `temps` (`idTemps`, `libellé`) VALUES
(1, '0-5'),
(2, '5-10'),
(3, '10-15'),
(4, '15-20'),
(5, '20-25'),
(6, '25-30'),
(7, '30-35'),
(8, '35-40'),
(9, '40-45'),
(10, '45-50'),
(11, '50-55'),
(12, '55-60'),
(13, '+60');

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

--
-- Structure de la table `validations`
--

CREATE TABLE IF NOT EXISTS `validations` (
  `idValidation` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`idValidation`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `validations` (`idValidation`, `libelle`) VALUES
(1, '0'),
(2, '1'),
(3, '2'),
(4, '3'),
(5, '4'),
(6, '5'),
(7, '6'),
(8, '7'),
(9, '8'),
(10, '9'),
(11, '10'),
(12, '+10');

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `associationpartie`
--
ALTER TABLE `associationpartie`
  ADD CONSTRAINT `FK_F88B61CC158FCEAE` FOREIGN KEY (`idPosition`) REFERENCES `position` (`idPosition`),
  ADD CONSTRAINT `FK_F88B61CC668AB7A7` FOREIGN KEY (`idPartie`) REFERENCES `partie` (`idPartie`),
  ADD CONSTRAINT `FK_F88B61CC7770F43D` FOREIGN KEY (`idTemps`) REFERENCES `temps` (`idTemps`),
  ADD CONSTRAINT `FK_F88B61CC94584584` FOREIGN KEY (`idValidation`) REFERENCES `validations` (`idValidation`),
  ADD CONSTRAINT `associationpartie_ibfk_1` FOREIGN KEY (`idObstacle`) REFERENCES `obstacle` (`idObstacle`);

--
-- Contraintes pour la table `operation`
--
ALTER TABLE `operation`
  ADD CONSTRAINT `operation_ibfk_1` FOREIGN KEY (`idComptable`) REFERENCES `comptable` (`id`),
  ADD CONSTRAINT `operation_ibfk_2` FOREIGN KEY (`idjoueurs`) REFERENCES `joueurs` (`id`);
COMMIT;

