-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 24, 2025 at 10:10 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

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 */;

--
-- Database: `cas rugby`
--

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

--
-- Table structure for table `arbitre`
--

CREATE TABLE `arbitre` (
  `idArbitre` int(11) NOT NULL,
  `nomArbitre` varchar(50) NOT NULL,
  `prenomArbitre` varchar(50) NOT NULL,
  `comiteArbitre` varchar(30) NOT NULL,
  `dateNaissanceArbitre` date NOT NULL,
  `isInternational` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `arbitre`
--

INSERT INTO `arbitre` (`idArbitre`, `nomArbitre`, `prenomArbitre`, `comiteArbitre`, `dateNaissanceArbitre`, `isInternational`) VALUES
(3000, 'BLASCO-BAQUE', 'Vincent', 'Occitanie', '1984-06-25', 0),
(3001, 'BROUSSET', 'Pierre', 'Occitanie', '1989-01-15', 1),
(3002, 'CARDONA', 'Laurent', 'Nouvelle-Aquitaine', '1977-06-22', 0),
(3003, 'CASTAIGNEDE', 'Julien', 'Inconnu', '1988-01-09', 0),
(3004, 'CAYRE', 'Ludovic', 'Nouvelle-Aquitaine', '1989-01-04', 1),
(3005, 'CHALON', 'Maxime', 'Nouvelle-Aquitaine', '1978-07-23', 0),
(3006, 'CHARABAS', 'Thomas', 'Inconnu', '1989-03-10', 0),
(3007, 'DESCOTTES', 'Adrien', 'Auvergne-Rhône-Alpes', '1980-06-03', 0),
(3008, 'DUFORT', 'Jonathan', 'Inconnu', '1987-09-07', 0),
(3009, 'GARCES', 'Jérôme', 'Inconnu', '1973-10-24', 1),
(3010, 'GASNIER', 'Jonathan', 'Occitanie', '1983-05-10', 0),
(3011, 'GAUZERE', 'Pascal', 'Inconnu', '1977-04-23', 0),
(3012, 'LAFON', 'Cyril', 'Inconnu', '1974-05-18', 0),
(3013, 'MARCHAT', 'Cédric', 'Inconnu', '1978-10-09', 0),
(3014, 'MINERY', 'Sébastien', 'Nouvelle-Aquitaine', '1980-05-26', 0),
(3015, 'NUCHY', 'Pierre-Baptiste', 'Nouvelle-Aquitaine', '1991-05-04', 0),
(3016, 'POITE', 'Romain', 'Occitanie', '1975-09-14', 1),
(3017, 'PRADERIE', 'Vivien', 'Occitanie', '1987-11-28', 0),
(3018, 'RAMOS', 'Luc', 'Inconnu', '1991-02-14', 0),
(3019, 'RAYNAL', 'Mathieu', 'Occitanie', '1981-08-09', 1),
(3020, 'ROZIER', 'Jérémy', 'Ile-De-France', '1991-02-25', 1),
(3021, 'RUIZ', 'Alexandre', 'Occitanie', '1987-03-24', 0),
(3022, 'TRAININI', 'Tual', 'Inconnu', '1985-06-11', 0),
(3023, 'MARBOT', 'Adrien', 'Inconnu', '1982-07-23', 0),
(3024, 'ROUSSELET', 'Benoit', 'Inconnu', '1993-06-06', 0),
(3025, 'WOODTHORPE', 'Anthony', 'Angleterre', '1970-01-01', 1),
(3026, 'AMASHUKELI', 'Nika', 'Géorgie', '1994-09-18', 1),
(3027, 'URRUZMENDI', 'Evan', 'Nouvelle-Aquitaine', '1996-02-19', 0),
(3028, 'BRALLEY', 'Kevin ', 'Occitanie', '1995-03-11', 0),
(3029, 'SCHNEIDER', 'Damian', 'Argentine', '1991-10-11', 1);

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

--
-- Table structure for table `entraineur`
--

CREATE TABLE `entraineur` (
  `idEnt` int(11) NOT NULL,
  `nomEnt` varchar(25) DEFAULT NULL,
  `prenomEnt` varchar(25) DEFAULT NULL,
  `isPrincipalEnt` tinyint(1) DEFAULT NULL,
  `idNation` int(11) NOT NULL,
  `idEquipe` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `entraineur`
--

INSERT INTO `entraineur` (`idEnt`, `nomEnt`, `prenomEnt`, `isPrincipalEnt`, `idNation`, `idEquipe`) VALUES
(10100, 'clermont', 'entraineurPrincipal', 1, 14, 1),
(10200, 'castres', 'entraineurPrincipal', 1, 14, 2),
(10300, 'brive', 'entraineurPrincipal', 1, 14, 3),
(10400, 'lyon', 'entraineurPrincipal', 1, 14, 4),
(10500, 'montpellier', 'entraineurPrincipal', 1, 14, 5),
(10600, 'colombes', 'entraineurPrincipal', 1, 14, 6),
(10700, 'toulon', 'entraineurPrincipal', 1, 14, 7),
(10800, 'pau', 'entraineurPrincipal', 1, 14, 8),
(10900, 'paris', 'entraineurPrincipal', 1, 14, 9),
(11000, 'la-rochelle', 'entraineurPrincipal', 1, 14, 10),
(11100, 'toulouse', 'entraineurPrincipal', 1, 14, 11),
(11101, 'Lacroix', 'Didier', 0, 14, 11),
(11102, 'Bouilhou', 'Jean', 0, 14, 11),
(11103, 'Kaino', 'Jerome', 0, 19, 11),
(11104, 'Lacombe', 'Virgile', 0, 14, 11),
(11105, 'Melé', 'David', 0, 14, 11),
(11106, 'Mola', 'Ugo', 0, 14, 11),
(11107, 'Poitrenaud', 'Clément', 0, 14, 11),
(11108, 'Thuery', 'Laurent', 0, 14, 11),
(11200, 'agen', 'entraineurPrincipal', 1, 14, 12),
(11300, 'bordeaux-begles', 'entraineurPrincipal', 1, 14, 13),
(11400, 'bayonne', 'entraineurPrincipal', 1, 14, 14),
(11500, 'grenoble', 'entraineurPrincipal', 1, 14, 15),
(11600, 'perpignan', 'entraineurPrincipal', 1, 14, 16),
(11700, 'oyonnax', 'entraineurPrincipal', 1, 14, 17),
(11800, 'biarritz', 'entraineurPrincipal', 1, 14, 18),
(11900, 'vannes', 'entraineurPrincipal', 1, 14, 19);

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

--
-- Table structure for table `equipe`
--

CREATE TABLE `equipe` (
  `idEquipe` int(11) NOT NULL,
  `libEquipe` varchar(25) DEFAULT NULL,
  `couleursEquipe` varchar(50) DEFAULT NULL,
  `anneeCreationEquipe` int(11) DEFAULT NULL,
  `stadeEquipe` varchar(25) DEFAULT NULL,
  `domaineEquipe` varchar(50) DEFAULT NULL,
  `isActiveEquipe` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `equipe`
--

INSERT INTO `equipe` (`idEquipe`, `libEquipe`, `couleursEquipe`, `anneeCreationEquipe`, `stadeEquipe`, `domaineEquipe`, `isActiveEquipe`) VALUES
(1, 'ASM Clermont', 'Jaune et Bleu', 1911, 'Stade Marcel Michelin', 'asm.fr', 1),
(2, 'Castres Olympique', 'Bleu et blanc', 1898, 'Stade Pierre Fabre', 'co.fr', 1),
(3, 'CA Brive-Corrèze', 'Noir et blanc', 1912, 'Stade Amédée Domenech', 'cabc.fr', 0),
(4, 'Lyon LOU', 'Rouge et noir', 1896, 'Matmut Stadium Gerland', 'lou.fr', 1),
(5, 'Montpellier Hérault Rugby', 'Bleu et blanc', 1986, 'GGL Stadium', 'mhr.fr', 1),
(6, 'Racing 92', 'Ciel et blanc', NULL, 'Paris La Défense Arena', 'r92.fr', 1),
(7, 'Rugby Club Toulonnais', 'Rouge et noir', 1908, 'Stade Mayol', 'rct.fr', 1),
(8, 'Section Paloise', 'Vert et blanc', 1902, 'Stade du Hameau', 'sp.fr', 1),
(9, 'Stade Français', 'Rouge et bleu', 1883, 'Stade Jean Bouin', 'sf.fr', 1),
(10, 'Stade Rochelais', 'Jaune et Noir', 1898, 'Stade Marcel Deflandre', 'sr.fr', 1),
(11, 'Stade Toulousain', 'Rouge et noir', 1890, 'Stade Ernest Wallon', 'st.fr', 1),
(12, 'SU Agen', 'Blanc et bleu', 1908, 'Stade Armandie', 'sua.fr', 0),
(13, 'Union Bordeaux-Bègles', 'Bordeaux et blanc', 1907, 'Stade Chaban-Delmas', 'ubb.fr', 1),
(14, 'Aviron Bayonnais', 'Ciel et blanc', 1904, 'Stade Jean Dauger', 'ab.fr', 1),
(15, 'FC Grenoble Rugby', 'Rouge, bleu et blanc', 1892, 'Stade des Alpes', 'fcgr.fr', 0),
(16, 'USA Perpignan', 'Sang et or', 1902, 'Stade Aimé Giral', 'usap.fr', 1),
(17, 'US Oyonnax', 'Rouge et noir', 1909, 'Stade Charles Mathon', 'uso.fr', 0),
(18, 'Biarritz OPB', 'Rouge et blanc', 1913, 'Parc des sports Aguiléra', 'bopb.fr', 0),
(19, 'Rugby Club Vannetais', 'Marine et blanc', 1950, 'Stade de la Rabine', 'rcv.fr', 1);

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

--
-- Table structure for table `equivalencePoste`
--

CREATE TABLE `equivalencePoste` (
  `idPosteOrigine` int(11) NOT NULL,
  `idPosteDeRemplacement` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `joueur`
--

CREATE TABLE `joueur` (
  `idJoueur` int(11) NOT NULL,
  `nomJoueur` varchar(25) DEFAULT NULL,
  `prenomJoueur` varchar(25) DEFAULT NULL,
  `tailleJoueur` int(11) DEFAULT NULL,
  `poidsJoueur` int(11) DEFAULT NULL,
  `ageJoueur` int(11) DEFAULT NULL,
  `idPoste` int(11) NOT NULL,
  `idEquipe` int(11) NOT NULL,
  `idNation` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `joueur`
--

INSERT INTO `joueur` (`idJoueur`, `nomJoueur`, `prenomJoueur`, `tailleJoueur`, `poidsJoueur`, `ageJoueur`, `idPoste`, `idEquipe`, `idNation`) VALUES
(100, 'clermont', 'capitaine', 200, 100, 30, 1, 1, 14),
(200, 'castres', 'capitaine', 200, 100, 30, 1, 2, 14),
(300, 'brive', 'capitaine', 200, 100, 30, 1, 3, 14),
(400, 'lyon', 'capitaine', 200, 100, 30, 1, 4, 14),
(500, 'montpellier', 'capitaine', 200, 100, 30, 1, 5, 14),
(600, 'colombes', 'capitaine', 200, 100, 30, 1, 6, 14),
(700, 'toulon', 'capitaine', 200, 100, 30, 1, 7, 14),
(800, 'pau', 'capitaine', 200, 100, 30, 1, 8, 14),
(900, 'paris', 'capitaine', 200, 100, 30, 1, 9, 14),
(1000, 'la-rochelle', 'capitaine', 200, 100, 30, 1, 10, 14),
(1100, 'toulouse', 'capitaine', 200, 100, 30, 1, 11, 14),
(1101, 'Ainuu', 'David', 197, 132, 25, 5, 11, 12),
(1102, 'Aldegheri', 'Dorian', 200, 102, 31, 5, 11, 14),
(1103, 'Baille', 'Cyril', 195, 79, 31, 5, 11, 14),
(1104, 'Bertrand', 'Benjamin', 207, 102, NULL, 5, 11, 14),
(1105, 'Laulala', 'Nepo', 175, 78, 33, 5, 11, 19),
(1106, 'Merkler Perez', 'Joel', 185, 97, 23, 5, 11, 11),
(1107, 'Neti', 'Rodrigue', 200, 99, 29, 5, 11, 14),
(1108, 'Reilhes', 'Hugo', 186, 79, 23, 5, 11, 14),
(1109, 'Cramont', 'Guillaume', 204, 108, 24, 6, 11, 14),
(1110, 'Hawkes', 'Malachi', 175, 120, 22, 6, 11, 5),
(1111, 'Lacombre', 'Thomas', 198, NULL, 20, 6, 11, 14),
(1112, 'Marchand', 'Julien', 190, 120, 29, 6, 11, 14),
(1113, 'Mauvaka', 'Peato', 176, 121, 27, 6, 11, 14),
(1114, 'Arnold', 'Richie', 177, 106, 34, 4, 11, 5),
(1115, 'Brennan', 'Joshua', 200, 134, 23, 4, 11, 33),
(1116, 'Elias', 'Efrain', 175, 105, 20, 4, 11, 4),
(1117, 'Flament', 'Thibaud', 204, 111, 27, 4, 11, 14),
(1118, 'Meafou', 'Emmanuel', 178, 135, 26, 4, 11, 5),
(1119, 'Verge', 'Clement', 180, 100, 23, 4, 11, 14),
(1120, 'Banos', 'Léo', 181, 103, 22, 9, 11, 14),
(1121, 'Castro-Ferreira', 'Mathis', 192, 126, 20, 9, 11, 14),
(1122, 'Cros', 'François', 203, 122, 29, 9, 11, 14),
(1123, 'Jelonch', 'Anthony', 204, 127, 28, 9, 11, 14),
(1124, 'Jouanny', 'Lomig', 193, 107, 20, 9, 11, 14),
(1125, 'Ntamack', 'Théo', 193, 125, 22, 9, 11, 14),
(1126, 'Placines', 'Alban', 198, 108, 31, 9, 11, 14),
(1127, 'Roumat', 'Alexandre', 186, 131, 27, 9, 11, 14),
(1128, 'Willis', 'Jack', 192, 125, 28, 9, 11, 3),
(1129, 'Daroque', 'Simon', 207, 112, NULL, 3, 11, 14),
(1130, 'Dupont', 'Antoine', 187, 79, 28, 3, 11, 14),
(1131, 'Graou', 'Paul', 182, 85, 27, 3, 11, 14),
(1132, 'Saito', 'Naoto', 201, 83, 27, 3, 11, 27),
(1133, 'Delpy', 'Valentin', 190, 75, 21, 2, 11, 14),
(1134, 'Ntamack', 'Romain', 206, 106, 25, 2, 11, 14),
(1135, 'Bituniyata', 'Setareki', 199, 134, 29, 7, 11, 13),
(1136, 'Delibes', 'Dimitri', 207, 75, 25, 7, 11, 14),
(1137, 'Epee', 'Nelson', 204, 84, 23, 7, 11, 14),
(1138, 'Lebel', 'Matthis', 187, 91, 25, 7, 11, 14),
(1139, 'Ahki', 'Pita', 190, NULL, 32, 8, 11, 19),
(1140, 'Barassi', 'Pierre-louis', 185, 100, 26, 8, 11, 14),
(1141, 'Chocobares', 'Santiago', 189, 91, 25, 8, 11, 4),
(1142, 'Costes', 'Paul', 204, 104, 21, 8, 11, 14),
(1143, 'Pouzelgues', 'Celian', 202, 111, NULL, 8, 11, 14),
(1144, 'Capuozzo', 'Ange', NULL, 85, 25, 1, 11, 17),
(1145, 'Gourgues', 'Kalvin', 197, 114, NULL, 1, 11, 14),
(1146, 'Kinghorn', 'Blair', 195, 99, 27, 1, 11, 10),
(1147, 'Mallía', 'Juan Cruz', NULL, 130, 28, 1, 11, 4),
(1148, 'Ramos', 'Thomas', 204, 91, 29, 1, 11, 14),
(1149, 'Remue', 'Matias', 197, 129, NULL, 1, 11, 14),
(1200, 'agen', 'capitaine', 200, 100, 30, 1, 12, 14),
(1300, 'bordeaux-begles', 'capitaine', 200, 100, 30, 1, 13, 14),
(1400, 'bayonne', 'capitaine', 200, 100, 30, 1, 14, 14),
(1500, 'grenoble', 'capitaine', 200, 100, 30, 1, 15, 14),
(1600, 'perpignan', 'capitaine', 200, 100, 30, 1, 16, 14),
(1700, 'oyonnax', 'capitaine', 200, 100, 30, 1, 17, 14),
(1800, 'biarritz', 'capitaine', 200, 100, 30, 1, 18, 14),
(1900, 'vannes', 'capitaine', 200, 100, 30, 1, 19, 14);

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

--
-- Table structure for table `journee`
--

CREATE TABLE `journee` (
  `numJournee` varchar(3) NOT NULL,
  `premiereDateJournee` date NOT NULL,
  `typeJournee` varchar(1) NOT NULL COMMENT 'A : phase aller R : phase retour'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `journee`
--

INSERT INTO `journee` (`numJournee`, `premiereDateJournee`, `typeJournee`) VALUES
('J01', '2024-09-07', 'A'),
('J02', '2024-09-14', 'A'),
('J03', '2024-09-21', 'A'),
('J04', '2024-09-28', 'A'),
('J05', '2024-10-05', 'A'),
('J06', '2024-10-12', 'A'),
('J07', '2024-10-19', 'A'),
('J08', '2024-10-26', 'A'),
('J09', '2024-11-02', 'A'),
('J10', '2024-11-23', 'A'),
('J11', '2024-11-30', 'A'),
('J12', '2024-12-21', 'A'),
('J13', '2024-12-28', 'A'),
('J14', '2025-01-04', 'R'),
('J15', '2025-01-25', 'R'),
('J16', '2025-02-15', 'R'),
('J17', '2025-02-22', 'R'),
('J18', '2025-03-01', 'R'),
('J19', '2025-03-22', 'R'),
('J20', '2025-03-29', 'R'),
('J21', '2025-04-19', 'R'),
('J22', '2025-04-26', 'R'),
('J23', '2025-05-10', 'R'),
('J24', '2025-05-17', 'R'),
('J25', '2025-05-31', 'R'),
('J26', '2025-06-07', 'R');

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

--
-- Table structure for table `marquer`
--

CREATE TABLE `marquer` (
  `idJoueur` int(11) NOT NULL,
  `idPoint` int(11) NOT NULL,
  `numJournee` varchar(3) NOT NULL,
  `numMatch` int(11) NOT NULL,
  `nombre` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `matchRugby`
--

CREATE TABLE `matchRugby` (
  `numJournee` varchar(3) NOT NULL,
  `numMatch` int(11) NOT NULL,
  `dateHeureMatch` datetime DEFAULT NULL,
  `stadeMatch` varchar(50) NOT NULL,
  `isDelocalise` tinyint(1) NOT NULL,
  `idEquipeLocale` int(11) NOT NULL,
  `scoreLocaux` int(11) DEFAULT NULL,
  `idEquipeVisiteuse` int(11) NOT NULL,
  `scoreVisiteurs` int(11) NOT NULL,
  `idArbitre` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `matchRugby`
--

INSERT INTO `matchRugby` (`numJournee`, `numMatch`, `dateHeureMatch`, `stadeMatch`, `isDelocalise`, `idEquipeLocale`, `scoreLocaux`, `idEquipeVisiteuse`, `scoreVisiteurs`, `idArbitre`) VALUES
('J01', 1, '2024-09-07 14:30:00', 'Stade Jean Dauger', 0, 14, 21, 16, 19, 3018),
('J01', 2, '2024-09-07 16:30:00', 'Stade Marcel Michelin', 0, 1, 39, 8, 7, 3017),
('J01', 3, '2024-09-07 16:30:00', 'Stade Pierre Fabre', 0, 2, 31, 6, 28, 3024),
('J01', 4, '2024-09-07 16:30:00', 'GGL Stadium', 0, 5, 22, 4, 26, 3020),
('J01', 5, '2024-09-07 21:05:00', 'Stade Chaban-Delmas', 0, 13, 46, 9, 26, 3000),
('J01', 6, '2024-09-08 17:00:00', 'Stade Marcel Deflandre', 0, 10, 19, 7, 15, 3004),
('J01', 7, '2024-09-08 21:05:00', 'Stade de la rabine', 0, 19, 18, 11, 43, 3023),
('J02', 1, '2024-09-14 14:30:00', 'Stade Mayol', 0, 7, 30, 2, 28, 3027),
('J02', 2, '2024-09-14 14:30:00', 'Stade Jean Bouin', 0, 9, 34, 19, 31, 3024),
('J02', 3, '2024-09-14 16:30:00', 'Paris La D?fense Arena', 0, 6, 33, 1, 20, 3010),
('J02', 4, '2024-09-14 16:30:00', 'Stade du Hameau', 0, 8, 51, 14, 29, 3004),
('J02', 5, '2024-09-14 16:30:00', 'Stade Aim? Giral', 0, 16, 7, 5, 26, 3017),
('J02', 6, '2024-09-14 21:05:00', 'Matmut Stadium Gerland', 0, 4, 28, 13, 26, 3028),
('J02', 7, '2024-09-15 21:05:00', 'Stade Ernest Wallon', 0, 11, 35, 10, 27, 3018),
('J03', 1, '2024-09-21 14:30:00', 'GGL Stadium', 0, 5, 11, 11, 20, 3010),
('J03', 2, '2024-09-21 16:30:00', 'Stade Marcel Michelin', 0, 1, 26, 14, 10, 3000),
('J03', 3, '2024-09-21 16:30:00', 'Stade Pierre Fabre', 0, 2, 27, 16, 12, 3023),
('J03', 4, '2024-09-21 16:30:00', 'Stade de la rabine', 0, 19, 30, 4, 20, 3006),
('J03', 5, '2024-09-21 16:30:00', 'Stade Marcel Deflandre', 0, 10, 49, 8, 25, 3020),
('J03', 6, '2024-09-21 21:05:00', 'Stade Chaban-Delmas', 0, 13, 52, 6, 34, 3018),
('J03', 7, '2024-09-22 21:05:00', 'Stade Jean Bouin', 0, 9, 10, 7, 14, 3001),
('J04', 1, '2024-09-28 14:30:00', 'Stade Aim? Giral', 0, 16, 33, 1, 3, 3004),
('J04', 2, '2024-09-28 16:30:00', 'Stade Jean Dauger', 0, 14, 28, 5, 27, 3001),
('J04', 3, '2024-09-28 16:30:00', 'Matmut Stadium Gerland', 0, 4, 40, 2, 38, 3017),
('J04', 4, '2024-09-28 16:30:00', 'Paris La D?fense Arena', 0, 6, 16, 10, 17, 3006),
('J04', 5, '2024-09-28 16:30:00', 'Stade Mayol', 0, 7, 54, 19, 19, 3028),
('J04', 6, '2024-09-28 21:05:00', 'Stade du Hameau', 0, 8, 30, 9, 16, 3018),
('J04', 7, '2024-09-29 21:05:00', 'Stade Ernest Wallon', 0, 11, 12, 13, 16, 3022),
('J05', 1, '2024-10-05 14:30:00', 'Stade de la rabine', 0, 19, 24, 6, 27, 3022),
('J05', 2, '2024-10-05 16:30:00', 'Stade Jean Bouin', 0, 9, 29, 5, 20, 3015),
('J05', 3, '2024-10-05 16:30:00', 'Stade Marcel Deflandre', 0, 10, 43, 4, 22, 3010),
('J05', 4, '2024-10-05 16:30:00', 'Stade Chaban-Delmas', 0, 13, 30, 14, 27, 3024),
('J05', 5, '2024-10-05 16:30:00', 'Stade Aim? Giral', 0, 16, 11, 8, 10, 3001),
('J05', 6, '2024-10-05 21:05:00', 'Stade Pierre Fabre', 0, 2, 28, 11, 23, 3004),
('J05', 7, '2024-10-06 21:05:00', 'Stade Marcel Michelin', 0, 1, 19, 7, 18, 3023),
('J06', 1, '2024-10-12 14:30:00', 'Stade Dominique Duvauchelle', 1, 6, 22, 7, 6, 3001),
('J06', 2, '2024-10-12 16:30:00', 'Estadio Municipal de Anoeta', 1, 14, 37, 10, 7, 3018),
('J06', 3, '2024-10-12 16:30:00', 'GGL Stadium', 0, 5, 26, 19, 24, 3020),
('J06', 4, '2024-10-12 16:30:00', 'Stade du Hameau', 0, 8, 33, 2, 26, 3023),
('J06', 5, '2024-10-12 16:30:00', 'Stade Chaban-Delmas', 0, 13, 66, 16, 12, 3027),
('J06', 6, '2024-10-12 21:05:00', 'Stade Ernest Wallon', 0, 11, 48, 1, 14, 3015),
('J06', 7, '2024-10-13 21:05:00', 'Matmut Stadium Gerland', 0, 4, 35, 9, 3, 3004),
('J07', 1, '2024-10-19 14:30:00', 'Stade Jean Dauger', 0, 14, 32, 6, 15, 3000),
('J07', 2, '2024-10-19 16:30:00', 'Stade Marcel Michelin', 0, 1, 55, 19, 33, 3017),
('J07', 3, '2024-10-19 16:30:00', 'Stade Pierre Fabre', 0, 2, 35, 9, 13, 3010),
('J07', 4, '2024-10-19 16:30:00', 'Stade Mayol', 0, 7, 30, 5, 17, 3018),
('J07', 5, '2024-10-19 16:30:00', 'Stade Aim? Giral', 0, 16, 29, 4, 26, 3006),
('J07', 6, '2024-10-19 21:05:00', 'Stade du Hameau', 0, 8, 14, 11, 22, 3004),
('J07', 7, '2024-10-20 21:05:00', 'Stade Marcel Deflandre', 0, 10, 32, 13, 22, 3022),
('J08', 1, '2024-10-26 14:30:00', 'Stade Chaban-Delmas', 0, 13, 19, 8, 6, 3024),
('J08', 2, '2024-10-26 16:30:00', 'Matmut Stadium Gerland', 0, 4, 38, 14, 49, 3015),
('J08', 3, '2024-10-26 16:30:00', 'GGL Stadium', 0, 5, 16, 10, 0, 3001),
('J08', 4, '2024-10-26 16:30:00', 'Paris La D?fense Arena', 0, 6, 30, 16, 23, 3028),
('J08', 5, '2024-10-26 16:30:00', 'Stade de la rabine', 0, 19, 34, 2, 28, 3018),
('J08', 6, '2024-10-26 21:05:00', 'Stade Jean Bouin', 0, 9, 36, 1, 6, 3006),
('J08', 7, '2024-10-27 21:05:00', 'Stadium Municipal', 1, 11, 57, 7, 5, 3020),
('J09', 1, '2024-11-02 14:30:00', 'Stade Marcel Michelin', 0, 1, 32, 13, 27, 3023),
('J09', 2, '2024-11-02 16:30:00', 'Stade Pierre Fabre', 0, 2, 30, 5, 26, 3000),
('J09', 3, '2024-11-02 16:30:00', 'Stade Mayol', 0, 7, 21, 4, 10, 3027),
('J09', 4, '2024-11-02 16:30:00', 'Stade du Hameau', 0, 8, 23, 6, 33, 3022),
('J09', 5, '2024-11-02 16:30:00', 'Stade Aim? Giral', 0, 16, 32, 19, 13, 3004),
('J09', 6, '2024-11-02 21:05:00', 'Stade Marcel Deflandre', 0, 10, 35, 9, 18, 3029),
('J09', 7, '2024-11-03 21:05:00', 'Stade Jean Dauger', 0, 14, 12, 11, 8, 3028),
('J10', 1, '2024-11-23 14:30:00', 'Stade Mayol', 0, 7, 39, 14, 19, 3010),
('J10', 2, '2024-11-23 16:30:00', 'Stade Pierre Fabre', 0, 2, 28, 10, 24, 3023),
('J10', 3, '2024-11-23 16:30:00', 'Matmut Stadium Gerland', 0, 4, 22, 1, 30, 3017),
('J10', 4, '2024-11-23 16:30:00', 'GGL Stadium', 0, 5, 30, 8, 3, 3015),
('J10', 5, '2024-11-23 16:30:00', 'Stade Ernest Wallon', 0, 11, 41, 16, 9, 3006),
('J10', 6, '2024-11-23 21:05:00', 'Stade de la rabine', 0, 19, 29, 13, 37, 3024),
('J10', 7, '2024-11-24 21:05:00', 'Stade Jean Bouin', 0, 9, 40, 6, 24, 3000),
('J11', 1, '2024-11-30 14:30:00', 'Paris La D?fense Arena', 0, 6, 17, 11, 21, 3001),
('J11', 2, '2024-11-30 16:30:00', 'Stade Marcel Michelin', 0, 1, 54, 2, 10, 3015),
('J11', 3, '2024-11-30 16:30:00', 'Stade du Hameau', 0, 8, 29, 4, 15, 3000),
('J11', 4, '2024-11-30 16:30:00', 'Stade Marcel Deflandre', 0, 10, 14, 19, 23, 3020),
('J11', 5, '2024-11-30 16:30:00', 'Stade Chaban-Delmas', 0, 13, 9, 5, 6, 3006),
('J11', 6, '2024-11-30 21:05:00', 'Stade Aim? Giral', 0, 16, 13, 7, 22, 3028),
('J11', 7, '2024-12-01 21:05:00', 'Stade Jean Dauger', 0, 14, 21, 9, 13, 3004),
('J12', 1, '2024-12-21 14:30:00', 'Stade Marcel Deflandre', 0, 10, 20, 1, 15, 3001),
('J12', 2, '2024-12-21 16:30:00', 'GGL Stadium', 0, 5, 21, 6, 17, 3022),
('J12', 3, '2024-12-21 16:30:00', 'Stade Mayol', 0, 7, 56, 8, 25, 3020),
('J12', 4, '2024-12-21 16:30:00', 'Stade de la rabine', 0, 19, 21, 14, 27, 3028),
('J12', 5, '2024-12-21 16:30:00', 'Stade Jean Bouin', 0, 9, 24, 16, 7, 3018),
('J12', 6, '2024-12-21 21:05:00', 'Stade Pierre Fabre', 0, 2, 3, 13, 13, 3004),
('J12', 7, '2024-12-22 21:05:00', 'Matmut Stadium Gerland', 0, 4, 17, 11, 17, 3023),
('J13', 1, '2024-12-28 14:00:00', 'Stade du Hameau', 0, 8, 48, 19, 24, 3010),
('J13', 2, '2024-12-28 16:00:00', 'Stade Jean Dauger', 0, 14, 33, 2, 12, 3024),
('J13', 3, '2024-12-28 18:00:00', 'Stade Marcel Michelin', 0, 1, 18, 5, 22, 3006),
('J13', 4, '2024-12-28 21:05:00', 'Stade Chaban-Delmas', 0, 13, 21, 7, 17, 3001),
('J13', 5, '2024-12-29 16:00:00', 'Paris La D?fense Arena', 0, 6, 25, 4, 25, 3017),
('J13', 6, '2024-12-29 18:00:00', 'Stade Aim? Giral', 0, 16, 21, 10, 13, 3000),
('J13', 7, '2024-12-29 21:05:00', 'Stade Ernest Wallon', 0, 11, 38, 9, 23, 3027);

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

--
-- Table structure for table `nationalite`
--

CREATE TABLE `nationalite` (
  `idNation` int(11) NOT NULL,
  `libNation` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `nationalite`
--

INSERT INTO `nationalite` (`idNation`, `libNation`) VALUES
(1, 'Afrique du Sud'),
(2, 'Allemagne'),
(3, 'Angleterre'),
(4, 'Argentine'),
(5, 'Australie'),
(6, 'Cameroun'),
(7, 'Canada'),
(8, 'Colombie'),
(9, 'Côte d\'Ivoire'),
(10, 'Ecosse'),
(11, 'Espagne'),
(12, 'Etats-Unis'),
(13, 'Fidji'),
(14, 'France'),
(15, 'Géorgie'),
(16, 'Irlande'),
(17, 'Italie'),
(18, 'Moldavie'),
(19, 'Nouvelle-Zelande'),
(20, 'Pays-Bas'),
(21, 'Pays de Galles'),
(22, 'Portugal'),
(23, 'Roumanie'),
(24, 'Samoa'),
(25, 'Tonga'),
(26, 'Uruguay'),
(27, 'Japon'),
(28, 'Namibie'),
(29, 'Sénégal'),
(30, 'Congo'),
(31, 'Belgique'),
(32, 'Zimbabwe'),
(33, 'Eire');

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

--
-- Table structure for table `partenaire`
--

CREATE TABLE `partenaire` (
  `idPartenaire` int(11) NOT NULL,
  `libPartenaire` varchar(50) DEFAULT NULL,
  `typePartenaire` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `partenaire`
--

INSERT INTO `partenaire` (`idPartenaire`, `libPartenaire`, `typePartenaire`) VALUES
(1, 'Ville de Clermont-Ferrand', 'V'),
(2, 'Ville de Castres', 'V'),
(3, 'Ville de Brive', 'V'),
(4, 'Ville de Lyon', 'V'),
(5, 'Ville de Montpellier', 'V'),
(6, 'Ville de Colombes', 'V'),
(7, 'Ville de Toulon', 'V'),
(8, 'Ville de Pau', 'V'),
(9, 'Ville de Paris', 'V'),
(10, 'Ville de La Rochelle', 'V'),
(11, 'Ville de Toulouse', 'V'),
(12, 'Ville d\'Agen', 'V'),
(13, 'Ville de Bordeaux', 'V'),
(14, 'Ville de Bègles', 'V'),
(15, 'Ville de Grenoble', 'V'),
(16, 'Ville de Perpignan', 'V'),
(17, 'Ville d\'Oyonnax', 'V'),
(18, 'Ville de Biarritz', 'V'),
(19, 'Ville de Bayonne', 'V'),
(20, 'Région Auvergne Rhône Alpes', 'R'),
(21, 'Région Ile de France', 'R'),
(22, 'Région Nouvelle Aquitaine', 'R'),
(23, 'Région Occitanie', 'R'),
(24, 'Région Provence Alpes Côte d\'Azur', 'R'),
(25, 'Conseil départemental du Puy-de-Dôme', 'D'),
(26, 'Conseil départemental de l\'Ain', 'D'),
(27, 'Conseil départemental de Charente-Maritime', 'D'),
(28, 'Conseil départemental de Corrèze', 'D'),
(29, 'Conseil départemental de Gironde', 'D'),
(30, 'Conseil départemental de Haute Garonne', 'D'),
(31, 'Conseil départemental des Hauts-de-Seine', 'D'),
(32, 'Conseil départemental de l\'Hérault', 'D'),
(33, 'Conseil départemental de l\'Isère', 'D'),
(34, 'Conseil départemental du Lot-et-Garonne', 'D'),
(35, 'Conseil départemental de Paris', 'D'),
(36, 'Conseil départemental des Pyrénées-Atlantique', 'D'),
(37, 'Conseil départemental des Pyrénées-Orientales', 'D'),
(38, 'Conseil départemental du Rhône', 'D'),
(39, 'Conseil départemental du Tarn', 'D'),
(40, 'Conseil départemental du Var', 'D'),
(41, 'Nike', 'E'),
(42, 'Adidas', 'E'),
(43, 'Puma', 'E'),
(44, 'Le Coq Sportif', 'E'),
(45, 'Macron', 'E'),
(46, 'Kappa', 'E'),
(47, 'Michelin', 'S'),
(48, 'Laboratoires Pierre Fabre', 'S'),
(49, 'Derichebourg', 'S'),
(50, 'Matmut', 'S'),
(51, 'Altrad', 'S'),
(52, 'Vital', 'S'),
(53, 'Syneris', 'S'),
(54, 'Total Energies', 'S'),
(55, 'Talan', 'S'),
(56, 'Cafés Merling', 'S'),
(57, 'Airbus', 'S'),
(58, 'Citya', 'S'),
(59, 'Arkéa', 'S'),
(60, 'Keolis', 'S'),
(61, 'MBway', 'S'),
(62, 'Azura', 'S'),
(63, 'Vittel', 'S'),
(64, 'Eiffage', 'S'),
(65, 'Force XV', 'E'),
(66, 'Errea', 'E'),
(67, 'Ville de Vannes', 'V'),
(68, 'Conseil départemental du Morbihan', 'D'),
(69, 'Région Bretagne', 'R'),
(70, 'Brets', 'S'),
(71, 'Armor Fruits', 'S');

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

--
-- Table structure for table `partenariat`
--

CREATE TABLE `partenariat` (
  `idEquipe` int(11) NOT NULL,
  `idPartenaire` int(11) NOT NULL,
  `montantPartenariat` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `partenariat`
--

INSERT INTO `partenariat` (`idEquipe`, `idPartenaire`, `montantPartenariat`) VALUES
(1, 1, 100000),
(1, 20, 100000),
(1, 25, 100000),
(1, 45, 0),
(1, 47, 100000),
(2, 2, 100000),
(2, 23, 100000),
(2, 39, 100000),
(2, 46, 0),
(2, 48, 100000),
(3, 3, 100000),
(3, 22, 100000),
(3, 28, 100000),
(3, 42, 0),
(3, 49, 100000),
(4, 4, 100000),
(4, 20, 100000),
(4, 38, 100000),
(4, 45, 0),
(4, 50, 100000),
(5, 5, 100000),
(5, 23, 100000),
(5, 32, 100000),
(5, 44, 0),
(5, 51, 100000),
(6, 6, 100000),
(6, 21, 100000),
(6, 31, 100000),
(6, 41, 0),
(6, 52, 100000),
(7, 7, 100000),
(7, 24, 100000),
(7, 40, 100000),
(7, 41, 0),
(7, 53, 100000),
(8, 8, 100000),
(8, 22, 100000),
(8, 36, 100000),
(8, 45, 0),
(8, 54, 100000),
(9, 9, 100000),
(9, 21, 100000),
(9, 35, 100000),
(9, 46, 0),
(9, 55, 100000),
(10, 10, 100000),
(10, 22, 100000),
(10, 27, 100000),
(10, 42, 0),
(10, 56, 100000),
(11, 11, 100000),
(11, 23, 100000),
(11, 30, 100000),
(11, 41, 0),
(11, 57, 100000),
(12, 12, 100000),
(12, 22, 100000),
(12, 34, 100000),
(12, 58, 100000),
(12, 66, 0),
(13, 13, 100000),
(13, 14, 100000),
(13, 22, 100000),
(13, 29, 100000),
(13, 46, 0),
(13, 59, 100000),
(14, 19, 100000),
(14, 22, 100000),
(14, 36, 100000),
(14, 46, 0),
(14, 60, 100000),
(15, 15, 100000),
(15, 20, 100000),
(15, 33, 100000),
(15, 46, 0),
(15, 61, 100000),
(16, 16, 100000),
(16, 23, 100000),
(16, 37, 100000),
(16, 42, 0),
(16, 62, 100000),
(17, 17, 100000),
(17, 20, 100000),
(17, 26, 100000),
(17, 63, 100000),
(17, 65, 0),
(18, 18, 100000),
(18, 22, 100000),
(18, 36, 100000),
(18, 45, 0),
(18, 64, 100000),
(19, 44, 0),
(19, 67, 100000),
(19, 68, 100000),
(19, 69, 100000),
(19, 70, 100000),
(19, 71, 100000);

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

--
-- Table structure for table `Point`
--

CREATE TABLE `Point` (
  `idPoint` int(11) NOT NULL,
  `libPoint` varchar(25) DEFAULT NULL,
  `valeurPoint` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `Point`
--

INSERT INTO `Point` (`idPoint`, `libPoint`, `valeurPoint`) VALUES
(1, 'Essai', 5),
(2, 'Transformation', 2),
(3, 'Pénalité', 3),
(4, 'Drop', 3),
(5, 'Essai de pénalité', 7);

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

--
-- Table structure for table `poste`
--

CREATE TABLE `poste` (
  `idPoste` int(11) NOT NULL,
  `libPoste` varchar(25) DEFAULT NULL,
  `typePoste` varchar(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `poste`
--

INSERT INTO `poste` (`idPoste`, `libPoste`, `typePoste`) VALUES
(1, 'Arrière', 'R'),
(2, 'Demi d\'ouverture', 'C'),
(3, 'Demi de mélée', 'C'),
(4, 'Deuxième ligne', 'V'),
(5, 'Pilier', 'V'),
(6, 'Talonneur', 'V'),
(7, 'Trois-quarts aile', 'R'),
(8, 'Trois-quarts centre', 'R'),
(9, 'Troisième ligne', 'V');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `arbitre`
--
ALTER TABLE `arbitre`
  ADD PRIMARY KEY (`idArbitre`);

--
-- Indexes for table `entraineur`
--
ALTER TABLE `entraineur`
  ADD PRIMARY KEY (`idEnt`),
  ADD KEY `idNation` (`idNation`),
  ADD KEY `idEquipe` (`idEquipe`);

--
-- Indexes for table `equipe`
--
ALTER TABLE `equipe`
  ADD PRIMARY KEY (`idEquipe`);

--
-- Indexes for table `equivalencePoste`
--
ALTER TABLE `equivalencePoste`
  ADD PRIMARY KEY (`idPosteOrigine`,`idPosteDeRemplacement`),
  ADD KEY `equivalencePoste_poste0_FK` (`idPosteDeRemplacement`);

--
-- Indexes for table `joueur`
--
ALTER TABLE `joueur`
  ADD PRIMARY KEY (`idJoueur`),
  ADD KEY `idPoste` (`idPoste`),
  ADD KEY `idEquipe` (`idEquipe`),
  ADD KEY `idNation` (`idNation`);

--
-- Indexes for table `journee`
--
ALTER TABLE `journee`
  ADD PRIMARY KEY (`numJournee`);

--
-- Indexes for table `marquer`
--
ALTER TABLE `marquer`
  ADD PRIMARY KEY (`idJoueur`,`idPoint`,`numJournee`,`numMatch`),
  ADD KEY `marquer_Point0_FK` (`idPoint`),
  ADD KEY `marquer_matchRugby1_FK` (`numJournee`,`numMatch`);

--
-- Indexes for table `matchRugby`
--
ALTER TABLE `matchRugby`
  ADD PRIMARY KEY (`numJournee`,`numMatch`),
  ADD KEY `matchRugby_equipe0_FK` (`idEquipeLocale`),
  ADD KEY `matchRugby_equipe1_FK` (`idEquipeVisiteuse`),
  ADD KEY `matchRugby_arbitre2_FK` (`idArbitre`);

--
-- Indexes for table `nationalite`
--
ALTER TABLE `nationalite`
  ADD PRIMARY KEY (`idNation`);

--
-- Indexes for table `partenaire`
--
ALTER TABLE `partenaire`
  ADD PRIMARY KEY (`idPartenaire`);

--
-- Indexes for table `partenariat`
--
ALTER TABLE `partenariat`
  ADD PRIMARY KEY (`idEquipe`,`idPartenaire`),
  ADD KEY `idPartenaire` (`idPartenaire`);

--
-- Indexes for table `Point`
--
ALTER TABLE `Point`
  ADD PRIMARY KEY (`idPoint`);

--
-- Indexes for table `poste`
--
ALTER TABLE `poste`
  ADD PRIMARY KEY (`idPoste`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `entraineur`
--
ALTER TABLE `entraineur`
  MODIFY `idEnt` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11901;

--
-- AUTO_INCREMENT for table `equipe`
--
ALTER TABLE `equipe`
  MODIFY `idEquipe` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `joueur`
--
ALTER TABLE `joueur`
  MODIFY `idJoueur` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1901;

--
-- AUTO_INCREMENT for table `nationalite`
--
ALTER TABLE `nationalite`
  MODIFY `idNation` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `partenaire`
--
ALTER TABLE `partenaire`
  MODIFY `idPartenaire` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT for table `Point`
--
ALTER TABLE `Point`
  MODIFY `idPoint` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `poste`
--
ALTER TABLE `poste`
  MODIFY `idPoste` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `entraineur`
--
ALTER TABLE `entraineur`
  ADD CONSTRAINT `entraineur_ibfk_1` FOREIGN KEY (`idNation`) REFERENCES `nationalite` (`idNation`),
  ADD CONSTRAINT `entraineur_ibfk_2` FOREIGN KEY (`idEquipe`) REFERENCES `equipe` (`idEquipe`);

--
-- Constraints for table `equivalencePoste`
--
ALTER TABLE `equivalencePoste`
  ADD CONSTRAINT `equivalencePoste_poste0_FK` FOREIGN KEY (`idPosteDeRemplacement`) REFERENCES `poste` (`idPoste`),
  ADD CONSTRAINT `equivalencePoste_poste_FK` FOREIGN KEY (`idPosteOrigine`) REFERENCES `poste` (`idPoste`);

--
-- Constraints for table `joueur`
--
ALTER TABLE `joueur`
  ADD CONSTRAINT `joueur_ibfk_1` FOREIGN KEY (`idPoste`) REFERENCES `poste` (`idPoste`),
  ADD CONSTRAINT `joueur_ibfk_2` FOREIGN KEY (`idEquipe`) REFERENCES `equipe` (`idEquipe`),
  ADD CONSTRAINT `joueur_ibfk_3` FOREIGN KEY (`idNation`) REFERENCES `nationalite` (`idNation`);

--
-- Constraints for table `marquer`
--
ALTER TABLE `marquer`
  ADD CONSTRAINT `marquer_Point0_FK` FOREIGN KEY (`idPoint`) REFERENCES `Point` (`idPoint`),
  ADD CONSTRAINT `marquer_joueur_FK` FOREIGN KEY (`idJoueur`) REFERENCES `joueur` (`idJoueur`),
  ADD CONSTRAINT `marquer_matchRugby1_FK` FOREIGN KEY (`numJournee`,`numMatch`) REFERENCES `matchRugby` (`numJournee`, `numMatch`);

--
-- Constraints for table `matchRugby`
--
ALTER TABLE `matchRugby`
  ADD CONSTRAINT `matchRugby_arbitre2_FK` FOREIGN KEY (`idArbitre`) REFERENCES `arbitre` (`idArbitre`),
  ADD CONSTRAINT `matchRugby_equipe0_FK` FOREIGN KEY (`idEquipeLocale`) REFERENCES `equipe` (`idEquipe`),
  ADD CONSTRAINT `matchRugby_equipe1_FK` FOREIGN KEY (`idEquipeVisiteuse`) REFERENCES `equipe` (`idEquipe`),
  ADD CONSTRAINT `matchRugby_journee_FK` FOREIGN KEY (`numJournee`) REFERENCES `journee` (`numJournee`);

--
-- Constraints for table `partenariat`
--
ALTER TABLE `partenariat`
  ADD CONSTRAINT `partenariat_ibfk_1` FOREIGN KEY (`idEquipe`) REFERENCES `equipe` (`idEquipe`),
  ADD CONSTRAINT `partenariat_ibfk_2` FOREIGN KEY (`idPartenaire`) REFERENCES `partenaire` (`idPartenaire`);
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 */;
