DROP TABLE IF EXISTS `newsletter`;
CREATE TABLE `newsletter` (
  `PK_newsletter_id` int NOT NULL,
  `email` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nom` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(220) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `lng` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`PK_newsletter_id`);


ALTER TABLE `newsletter`
  MODIFY `PK_newsletter_id` int NOT NULL AUTO_INCREMENT;
COMMIT;
