> For the complete documentation index, see [llms.txt](https://ahero-fivem-shop.gitbook.io/ahero.fivem-shop-gtav/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://ahero-fivem-shop.gitbook.io/ahero.fivem-shop-gtav/ui/acandidature-ui/installation/etape-2.md).

# Etape 2

## Ajout du SQL

```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;
```