 --
 ALTER TABLE `UE`
   ADD CONSTRAINT `fk_id_formation` FOREIGN KEY (`id_formation`) REFERENCES `Formation` (`id_formation`);
-
-/*!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 */;

  `id_formation` int(11) DEFAULT NULL,
  `id_UE` int(11) DEFAULT NULL,
  `privilege` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Contenu de la table `Responsabilite`
--

INSERT INTO `Responsabilite` (`id_resp`, `enseignant`, `intituleResp`, `id_formation`, `id_UE`, `privilege`) VALUES
(4, 'root@root', 'Responsable du departement informatique', NULL, NULL, 2),
(5, 'root@root', 'Responsable UE', NULL, 3, 1),
(6, 'root@root', 'Responsable UE', NULL, 4, 1);

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


CREATE TABLE `Formation` (
  `id_formation` int(11) NOT NULL,
  `nomFormation` varchar(32) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Contenu de la table `Formation`
--

INSERT INTO `Formation` (`id_formation`, `nomFormation`) VALUES
  (1, 'Licence informatique'),
  (2, 'Master Informatique');

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

