SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Table structure for table `SUJET`
--

CREATE TABLE IF NOT EXISTS `SUJET` (
  `Sujet` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Sujet`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `SUJET_MESSAGE`
--

CREATE TABLE IF NOT EXISTS `SUJET_MESSAGE` (
  `Sujet` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Message` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Utilisateur` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Sujet`,`Message`,`Utilisateur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `UTILISATEUR`
--

CREATE TABLE IF NOT EXISTS `UTILISATEUR` (
  `Utilisateur` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Pass` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`Utilisateur`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

