> 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/rageui-esx/atebexshop/installation/etape-3.md).

# Etape 3

{% hint style="danger" %}
Veuillez ajouter le code SQL pour assurer le bon fonctionnement de la ressource.
{% endhint %}

Voici les tables SQL à ajouter dans votre base de données.

***

## Insert tables SQL

<details>

<summary>tebex_accounts.sql</summary>

```sql
CREATE TABLE `tebex_accounts` (
  `name` varchar(255) NOT NULL,
  `license` varchar(50) NOT NULL DEFAULT '0',
  `fivem` varchar(50) NOT NULL DEFAULT '0',
  `vip` tinyint(4) NOT NULL DEFAULT 0,
  `points` int(11) NOT NULL DEFAULT 0,
  `expiration` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `tebex_accounts`
  ADD PRIMARY KEY (`license`);
```

</details>

<details>

<summary>tebex_players_wallet.sql</summary>

```sql
CREATE TABLE `tebex_players_wallet` (
  `id` int(11) NOT NULL,
  `identifiers` varchar(255) NOT NULL,
  `transaction` text DEFAULT NULL,
  `price` text NOT NULL,
  `currency` text DEFAULT NULL,
  `points` int(11) NOT NULL,
  `date` varchar(255) NOT NULL COMMENT 'Date de l''achat'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `tebex_players_wallet`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tebex_players_wallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
```

</details>