DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
  `PK_news_id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle_news` varchar(220) COLLATE utf8_unicode_ci NOT NULL,
  `contenu_news` text COLLATE utf8_unicode_ci NOT NULL,
  `image_news` varchar(220) COLLATE utf8_unicode_ci NOT NULL,
  `date_news` date NOT NULL,
  `actif_news` int(1) NOT NULL,
  PRIMARY KEY (`PK_news_id`),
  KEY `actif_news` (`actif_news`),
  KEY `date_news` (`date_news`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

DROP TABLE IF EXISTS `news_traduction`;
CREATE TABLE IF NOT EXISTS `news_traduction` (
  `PK_news_traduction_id` int(11) NOT NULL AUTO_INCREMENT,
  `FK_news_id` int(11) NOT NULL,
  `FK_langues_id` int(11) NOT NULL,
  `libelle_news` varchar(220) COLLATE utf8_unicode_ci NOT NULL,
  `contenu_news` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`PK_news_traduction_id`) USING BTREE,
  KEY `FK_news_id` (`FK_news_id`),
  KEY `FK_langues_id` (`FK_langues_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

COMMIT;
