Etape 2

Ajout du SQL

DROP TABLE IF EXISTS `ahero_gestions_candidatures`;
CREATE TABLE IF NOT EXISTS `ahero_gestions_candidatures` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `prenom` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `genre` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `date_naissance` varchar(10) COLLATE utf8mb4_general_ci NOT NULL,
  `telephone` varchar(20) COLLATE utf8mb4_general_ci NOT NULL,
  `description` text COLLATE utf8mb4_general_ci NOT NULL,
  `metier` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `permis_voiture` tinyint(1) NOT NULL DEFAULT '0',
  `permis_moto` tinyint(1) NOT NULL DEFAULT '0',
  `permis_poids_lourd` tinyint(1) NOT NULL DEFAULT '0',
  `notification` tinyint(1) NOT NULL DEFAULT '1',
  `date_submission` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;