DROP TABLE IF EXISTS `contact`;
CREATE TABLE `contact` (
  `PK_contact_id` int NOT NULL,
  `nom_contact` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_contact` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone_contact` varchar(220) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sujet_contact` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_contact` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_contact` datetime NOT NULL,
  `actif_contact` int NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


ALTER TABLE `contact`
  ADD PRIMARY KEY (`PK_contact_id`),
  ADD KEY `date_contact` (`date_contact`),
  ADD KEY `actif_contact` (`actif_contact`);


ALTER TABLE `contact`
  MODIFY `PK_contact_id` int NOT NULL AUTO_INCREMENT;
COMMIT;