CREATE TABLE IF NOT EXISTS `Liste_Paris` (
  `Id_PARI` int(255) NOT NULL AUTO_INCREMENT,
  `Titre_PARI` varchar(255) NOT NULL,
  `Id_Createur` int(255) NOT NULL,
  `Desc_PARI` varchar(255) DEFAULT NULL,
  `Date_Creation` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `Date_butoir` datetime NOT NULL,
  `Date_Cloture` datetime DEFAULT NULL,
  `Source_PARI` varchar(255) DEFAULT NULL,
  `Statut_PARI` enum('IN PROGRESS','ENDED') NOT NULL DEFAULT 'IN PROGRESS',
  `End_PARI` enum('POUR','CONTRE') DEFAULT NULL,
  PRIMARY KEY (`Id_PARI`)
)

CREATE TABLE IF NOT EXISTS `Mise_Paris` (
  `Id_PARI` int(255) NOT NULL,
  `id_Miseur` int(255) NOT NULL,
  `Date_MISE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `Montant_MISE` int(100) NOT NULL,
  `Reason_MISE` varchar(255) NOT NULL,
  PRIMARY KEY (`Id_PARI`,`id_Miseur`)
)

CREATE TABLE IF NOT EXISTS `Tchatcheurs` (
  `id_Tchatcheur` int(255) NOT NULL AUTO_INCREMENT,
  `nom_Tchatcheur` varchar(255) NOT NULL,
  `login_Tchatcheur` varchar(255) NOT NULL,
  `pwd_Tchatcheur` varchar(255) NOT NULL,
  `mojo_Tchatcheur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_Tchatcheur`)
)

CREATE TABLE IF NOT EXISTS `Events_Paris` (
  `idEvent` int(255) NOT NULL AUTO_INCREMENT,
  `idTchatcheur` int(255) NOT NULL,
  `idPari` int(255) NOT NULL,
  `TypeAction` enum('betorder','createbet','endbet') NOT NULL,
  PRIMARY KEY (`idEvent`)
)

SELECT e.idEvent, e.idTchatcheur, e.idPari, e.TypeAction, m.DATE_MISE, m.Reason_MISE, l.Titre_PARI, l.Date_Creation, l.Date_Cloture 
			FROM Events_Paris e
			LEFT JOIN Mise_Paris m
			ON e.idPari = m.id_PARI
			LEFT JOIN Liste_Paris l
			ON e.idPari = l.id_PARI
			ORDER BY idEvent DESC 
			LIMIT 0,5