DBdump_structure.sql

-- phpMyAdmin SQL Dump
-- version 3.4.10.1deb1
-- http://www.phpmyadmin.net
--
-- Client: 195.83.142.10:3306
-- Généré le : Ven 13 Février 2015 à 00:15
-- Version du serveur: 5.5.40
-- Version de PHP: 5.3.10-1ubuntu3.15

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
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 utf8 */;

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

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

--
-- Structure de la table `aEtudie`
--

CREATE TABLE IF NOT EXISTS `aEtudie` (
  `idPromo` int(50) NOT NULL,
  `idDepartement` int(50) NOT NULL,
  `idPersonne` int(50) NOT NULL,
  `idDiplomeDUT` int(50) NOT NULL,
  PRIMARY KEY (`idPromo`,`idDepartement`,`idPersonne`,`idDiplomeDUT`),
  KEY `idDiplomeDUT` (`idDiplomeDUT`),
  KEY `idPersonne` (`idPersonne`),
  KEY `idDepartement` (`idDepartement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `aEtudie`:
--   `idDepartement`
--       `departementIUT` -> `idDepartement`
--   `idPromo`
--       `promotion` -> `idPromo`
--   `idDiplomeDUT`
--       `diplomeDUT` -> `idDiplomeDUT`
--   `idPersonne`
--       `ancien` -> `idPersonne`
--

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

--
-- Structure de la table `ancien`
--

CREATE TABLE IF NOT EXISTS `ancien` (
  `idPersonne` int(50) NOT NULL,
  `sexe` varchar(5) DEFAULT NULL,
  `idParent` int(50) DEFAULT NULL,
  `dateNaissance` date DEFAULT NULL,
  `adresse1` varchar(50) DEFAULT NULL,
  `adresse2` varchar(50) DEFAULT NULL,
  `codePostal` varchar(5) DEFAULT NULL,
  `ville` varchar(20) DEFAULT NULL,
  `pays` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `imageProfil` longblob,
  `imageTrombi` longblob,
  PRIMARY KEY (`idPersonne`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `ancien`:
--   `idParent`
--       `parents` -> `idParent`
--   `idPersonne`
--       `personne` -> `idPersonne`
--

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

--
-- Structure de la table `aParticipe`
--

CREATE TABLE IF NOT EXISTS `aParticipe` (
  `idPersonne` int(50) NOT NULL,
  `idEvenement` int(50) NOT NULL,
  PRIMARY KEY (`idPersonne`,`idEvenement`),
  KEY `idEvenement` (`idEvenement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `aParticipe`:
--   `idEvenement`
--       `evenement` -> `idEvenement`
--   `idPersonne`
--       `ancien` -> `idPersonne`
--

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

--
-- Structure de la table `appartientGroupe`
--

CREATE TABLE IF NOT EXISTS `appartientGroupe` (
  `idGroupe` int(11) NOT NULL,
  `idPersonne` int(11) NOT NULL,
  PRIMARY KEY (`idGroupe`,`idPersonne`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `codeAPE`
--

CREATE TABLE IF NOT EXISTS `codeAPE` (
  `code` varchar(5) NOT NULL,
  `libelle` varchar(150) NOT NULL DEFAULT 'Aucun libelle',
  PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `commentaires`
--

CREATE TABLE IF NOT EXISTS `commentaires` (
  `idCom` int(11) NOT NULL AUTO_INCREMENT,
  `idPersonne` int(11) NOT NULL,
  `idPost` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `contenu` text NOT NULL,
  PRIMARY KEY (`idCom`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

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

--
-- Structure de la table `compte`
--

CREATE TABLE IF NOT EXISTS `compte` (
  `idCompte` int(50) NOT NULL AUTO_INCREMENT,
  `idProfil` int(50) NOT NULL,
  `idPersonne` int(50) NOT NULL,
  `ndc` varchar(50) NOT NULL,
  `mdp` varchar(60) NOT NULL,
  PRIMARY KEY (`idCompte`),
  KEY `idPersonne` (`idPersonne`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1090 ;

--
-- RELATIONS POUR LA TABLE `compte`:
--   `idProfil`
--       `typeProfil` -> `idProfil`
--   `idPersonne`
--       `personne` -> `idPersonne`
--

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

--
-- Structure de la table `departementIUT`
--

CREATE TABLE IF NOT EXISTS `departementIUT` (
  `idDepartement` int(50) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) NOT NULL,
  `sigle` varchar(10) NOT NULL,
  PRIMARY KEY (`idDepartement`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

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

--
-- Structure de la table `diplomeDUT`
--

CREATE TABLE IF NOT EXISTS `diplomeDUT` (
  `idDiplomeDUT` int(50) NOT NULL AUTO_INCREMENT,
  `idDepartement` int(50) NOT NULL,
  `libelle` varchar(50) NOT NULL,
  `sigle` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`idDiplomeDUT`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- RELATIONS POUR LA TABLE `diplomeDUT`:
--   `idDepartement`
--       `departementIUT` -> `idDepartement`
--

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

--
-- Structure de la table `diplomePostDUT`
--

CREATE TABLE IF NOT EXISTS `diplomePostDUT` (
  `idDiplomePost` int(50) NOT NULL AUTO_INCREMENT,
  `idDomaine` int(50) NOT NULL,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`idDiplomePost`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- RELATIONS POUR LA TABLE `diplomePostDUT`:
--   `idDomaine`
--       `domaine` -> `idDomaine`
--

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

--
-- Structure de la table `disposeDe`
--

CREATE TABLE IF NOT EXISTS `disposeDe` (
  `idProfil` int(50) NOT NULL,
  `idDroit` int(50) NOT NULL,
  `idPage` int(50) NOT NULL,
  PRIMARY KEY (`idProfil`,`idDroit`,`idPage`),
  KEY `idDroit` (`idDroit`),
  KEY `idPage` (`idPage`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `disposeDe`:
--   `idProfil`
--       `typeProfil` -> `idProfil`
--   `idDroit`
--       `droits` -> `idDroit`
--   `idPage`
--       `page` -> `idPage`
--

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

--
-- Structure de la table `domaine`
--

CREATE TABLE IF NOT EXISTS `domaine` (
  `idDomaine` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`idDomaine`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

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

--
-- Structure de la table `droits`
--

CREATE TABLE IF NOT EXISTS `droits` (
  `idDroit` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`idDroit`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

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

--
-- Structure de la table `entreprise`
--

CREATE TABLE IF NOT EXISTS `entreprise` (
  `idEntreprise` int(50) NOT NULL AUTO_INCREMENT,
  `codeAPE` varchar(50) NOT NULL,
  `nom` varchar(50) NOT NULL,
  `adresse1` varchar(50) NOT NULL,
  `adresse2` varchar(50) NOT NULL,
  `codePostal` varchar(50) NOT NULL,
  `ville` varchar(50) NOT NULL,
  `cedex` varchar(50) NOT NULL,
  `pays` varchar(50) NOT NULL,
  `telephone` varchar(10) NOT NULL,
  PRIMARY KEY (`idEntreprise`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- RELATIONS POUR LA TABLE `entreprise`:
--   `codeAPE`
--       `codeAPE` -> `code`
--

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

--
-- Structure de la table `estSpecialise`
--

CREATE TABLE IF NOT EXISTS `estSpecialise` (
  `idPersonne` int(50) NOT NULL,
  `idSpe` int(50) NOT NULL,
  PRIMARY KEY (`idPersonne`,`idSpe`),
  KEY `idSpe` (`idSpe`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `estSpecialise`:
--   `idSpe`
--       `specialisation` -> `idSpe`
--   `idPersonne`
--       `ancien` -> `idPersonne`
--

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

--
-- Structure de la table `etablissement`
--

CREATE TABLE IF NOT EXISTS `etablissement` (
  `idEtablissement` int(50) NOT NULL AUTO_INCREMENT,
  `nom` varchar(80) NOT NULL,
  `adresse1` varchar(50) DEFAULT NULL,
  `adresse2` varchar(50) DEFAULT NULL,
  `codePostal` varchar(50) DEFAULT NULL,
  `ville` varchar(50) DEFAULT NULL,
  `pays` varchar(50) DEFAULT NULL,
  `fax` varchar(20) DEFAULT NULL,
  `web` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`idEtablissement`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

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

--
-- Structure de la table `evenement`
--

CREATE TABLE IF NOT EXISTS `evenement` (
  `idEvenement` int(50) NOT NULL AUTO_INCREMENT,
  `idTypeEvenement` int(50) NOT NULL,
  `nom` varchar(30) NOT NULL,
  `commentaire` text,
  `date` date DEFAULT NULL,
  PRIMARY KEY (`idEvenement`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- RELATIONS POUR LA TABLE `evenement`:
--   `idTypeEvenement`
--       `typeEvenement` -> `idTypeEvenement`
--

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

--
-- Structure de la table `groupes`
--

CREATE TABLE IF NOT EXISTS `groupes` (
  `idGroupe` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(15) NOT NULL,
  `idCreateur` int(11) NOT NULL,
  `type` varchar(15) NOT NULL,
  PRIMARY KEY (`idGroupe`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

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

--
-- Structure de la table `messages`
--

CREATE TABLE IF NOT EXISTS `messages` (
  `id_message` int(11) NOT NULL AUTO_INCREMENT,
  `date_message` varchar(20) NOT NULL,
  `id_ancien_destinataire` int(11) NOT NULL,
  `id_ancien_expediteur` int(11) NOT NULL,
  `objet` varchar(200) NOT NULL,
  `message` varchar(500) NOT NULL,
  `lu` int(11) NOT NULL,
  PRIMARY KEY (`id_message`),
  KEY `id_ancien_destinataire` (`id_ancien_destinataire`),
  KEY `id_ancien_expediteur` (`id_ancien_expediteur`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;

--
-- RELATIONS POUR LA TABLE `messages`:
--   `id_ancien_destinataire`
--       `personne` -> `idPersonne`
--   `id_ancien_expediteur`
--       `personne` -> `idPersonne`
--

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

--
-- Structure de la table `newsletter`
--

CREATE TABLE IF NOT EXISTS `newsletter` (
  `idPersonne` int(11) NOT NULL,
  PRIMARY KEY (`idPersonne`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- RELATIONS POUR LA TABLE `newsletter`:
--   `idPersonne`
--       `personne` -> `idPersonne`
--

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

--
-- Structure de la table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `idPage` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`idPage`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=79 ;

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

--
-- Structure de la table `parents`
--

CREATE TABLE IF NOT EXISTS `parents` (
  `idParent` int(50) NOT NULL AUTO_INCREMENT,
  `adresse1` varchar(20) DEFAULT NULL,
  `adresse2` varchar(20) DEFAULT NULL,
  `codePostale` varchar(5) DEFAULT NULL,
  `ville` varchar(20) DEFAULT NULL,
  `pays` varchar(20) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`idParent`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Structure de la table `personne`
--

CREATE TABLE IF NOT EXISTS `personne` (
  `idPersonne` int(50) NOT NULL AUTO_INCREMENT,
  `nomUsage` varchar(50) DEFAULT NULL,
  `nomPatronymique` varchar(50) NOT NULL,
  `prenom` varchar(50) NOT NULL,
  `mail` varchar(50) NOT NULL,
  PRIMARY KEY (`idPersonne`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1102 ;

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

--
-- Structure de la table `possede`
--

CREATE TABLE IF NOT EXISTS `possede` (
  `idPersonne` int(50) NOT NULL,
  `idDiplomePost` int(50) NOT NULL,
  `idEtablissement` int(50) NOT NULL,
  `resultat` int(2) NOT NULL,
  `dateDeb` date NOT NULL,
  `dateFin` date NOT NULL,
  PRIMARY KEY (`idPersonne`,`idDiplomePost`,`idEtablissement`),
  KEY `idDiplomePost` (`idDiplomePost`),
  KEY `idEtablissement` (`idEtablissement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `possede`:
--   `idPersonne`
--       `ancien` -> `idPersonne`
--   `idDiplomePost`
--       `diplomePostDUT` -> `idDiplomePost`
--   `idEtablissement`
--       `etablissement` -> `idEtablissement`
--

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

--
-- Structure de la table `poste`
--

CREATE TABLE IF NOT EXISTS `poste` (
  `idPoste` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`idPoste`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Structure de la table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `idPost` int(11) NOT NULL AUTO_INCREMENT,
  `idPersonne` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `contenu` text NOT NULL,
  `approuve` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`idPost`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

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

--
-- Structure de la table `prefere`
--

CREATE TABLE IF NOT EXISTS `prefere` (
  `idPersonne` int(50) NOT NULL,
  `idTypeEvenement` int(50) NOT NULL,
  PRIMARY KEY (`idPersonne`,`idTypeEvenement`),
  KEY `idTypeEvenement` (`idTypeEvenement`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `prefere`:
--   `idPersonne`
--       `ancien` -> `idPersonne`
--   `idTypeEvenement`
--       `typeEvenement` -> `idTypeEvenement`
--

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

--
-- Structure de la table `promotion`
--

CREATE TABLE IF NOT EXISTS `promotion` (
  `idPromo` int(50) NOT NULL AUTO_INCREMENT,
  `annee` year(4) NOT NULL,
  PRIMARY KEY (`idPromo`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

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

--
-- Structure de la table `publieGroupe`
--

CREATE TABLE IF NOT EXISTS `publieGroupe` (
  `idGroupe` int(11) NOT NULL,
  `idPost` int(11) NOT NULL,
  PRIMARY KEY (`idGroupe`,`idPost`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `specialisation`
--

CREATE TABLE IF NOT EXISTS `specialisation` (
  `idSpe` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(20) NOT NULL,
  `idTypeSpe` int(5) NOT NULL,
  PRIMARY KEY (`idSpe`),
  KEY `idTypeSpe` (`idTypeSpe`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- RELATIONS POUR LA TABLE `specialisation`:
--   `idTypeSpe`
--       `typeSpecialisation` -> `idTypeSpe`
--

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

--
-- Structure de la table `travaille`
--

CREATE TABLE IF NOT EXISTS `travaille` (
  `idPersonne` int(50) NOT NULL,
  `idPoste` int(50) NOT NULL,
  `idEntreprise` int(50) NOT NULL,
  `dateEmbaucheDeb` date NOT NULL,
  `dateEmbaucheFin` date DEFAULT NULL,
  PRIMARY KEY (`idPersonne`,`idPoste`,`idEntreprise`,`dateEmbaucheDeb`),
  KEY `idPoste` (`idPoste`),
  KEY `idEntreprise` (`idEntreprise`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- RELATIONS POUR LA TABLE `travaille`:
--   `idPersonne`
--       `ancien` -> `idPersonne`
--   `idPoste`
--       `poste` -> `idPoste`
--   `idEntreprise`
--       `entreprise` -> `idEntreprise`
--

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

--
-- Structure de la table `typeEvenement`
--

CREATE TABLE IF NOT EXISTS `typeEvenement` (
  `idTypeEvenement` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) NOT NULL,
  PRIMARY KEY (`idTypeEvenement`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Structure de la table `typeProfil`
--

CREATE TABLE IF NOT EXISTS `typeProfil` (
  `idProfil` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`idProfil`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

--
-- Structure de la table `typeSpecialisation`
--

CREATE TABLE IF NOT EXISTS `typeSpecialisation` (
  `idTypeSpe` int(50) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(20) NOT NULL,
  PRIMARY KEY (`idTypeSpe`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `aEtudie`
--
ALTER TABLE `aEtudie`
  ADD CONSTRAINT `aEtudie_ibfk_6` FOREIGN KEY (`idDepartement`) REFERENCES `departementIUT` (`idDepartement`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `aEtudie_ibfk_1` FOREIGN KEY (`idPromo`) REFERENCES `promotion` (`idPromo`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `aEtudie_ibfk_4` FOREIGN KEY (`idDiplomeDUT`) REFERENCES `diplomeDUT` (`idDiplomeDUT`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `aEtudie_ibfk_5` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `ancien`
--
ALTER TABLE `ancien`
  ADD CONSTRAINT `ancien_ibfk_1` FOREIGN KEY (`idPersonne`) REFERENCES `personne` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `aParticipe`
--
ALTER TABLE `aParticipe`
  ADD CONSTRAINT `aParticipe_ibfk_2` FOREIGN KEY (`idEvenement`) REFERENCES `evenement` (`idEvenement`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `aParticipe_ibfk_3` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `compte`
--
ALTER TABLE `compte`
  ADD CONSTRAINT `compte_ibfk_1` FOREIGN KEY (`idPersonne`) REFERENCES `personne` (`idPersonne`) ON UPDATE CASCADE;

--
-- Contraintes pour la table `disposeDe`
--
ALTER TABLE `disposeDe`
  ADD CONSTRAINT `disposeDe_ibfk_1` FOREIGN KEY (`idProfil`) REFERENCES `typeProfil` (`idProfil`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `disposeDe_ibfk_2` FOREIGN KEY (`idDroit`) REFERENCES `droits` (`idDroit`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `disposeDe_ibfk_3` FOREIGN KEY (`idPage`) REFERENCES `page` (`idPage`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `estSpecialise`
--
ALTER TABLE `estSpecialise`
  ADD CONSTRAINT `estSpecialise_ibfk_2` FOREIGN KEY (`idSpe`) REFERENCES `specialisation` (`idSpe`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `estSpecialise_ibfk_3` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_ibfk_3` FOREIGN KEY (`id_ancien_destinataire`) REFERENCES `personne` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `messages_ibfk_4` FOREIGN KEY (`id_ancien_expediteur`) REFERENCES `personne` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `possede`
--
ALTER TABLE `possede`
  ADD CONSTRAINT `possede_ibfk_1` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `possede_ibfk_2` FOREIGN KEY (`idDiplomePost`) REFERENCES `diplomePostDUT` (`idDiplomePost`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `possede_ibfk_3` FOREIGN KEY (`idEtablissement`) REFERENCES `etablissement` (`idEtablissement`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `prefere`
--
ALTER TABLE `prefere`
  ADD CONSTRAINT `prefere_ibfk_1` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`),
  ADD CONSTRAINT `prefere_ibfk_2` FOREIGN KEY (`idTypeEvenement`) REFERENCES `typeEvenement` (`idTypeEvenement`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Contraintes pour la table `travaille`
--
ALTER TABLE `travaille`
  ADD CONSTRAINT `travaille_ibfk_1` FOREIGN KEY (`idPersonne`) REFERENCES `ancien` (`idPersonne`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `travaille_ibfk_2` FOREIGN KEY (`idPoste`) REFERENCES `poste` (`idPoste`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `travaille_ibfk_3` FOREIGN KEY (`idEntreprise`) REFERENCES `entreprise` (`idEntreprise`) ON DELETE CASCADE ON UPDATE CASCADE;

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