# Installation

{% hint style="info" %}
Installing this resource is like any other resource only verified that you have the required dependencies
{% endhint %}

## Step 1

Connect via this site: <https://keymaster.fivem.net/> with your CFX account to which your purchase was made on the store <https://www.var-fivem.com/>

## Step 2

<figure><img src="https://4276650587-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FVpsT0CEZ6FFjUJ4WIhHY%2Fuploads%2F9VLJQrER0vR95r1E5YVB%2Fimage.png?alt=media&#x26;token=a96d3707-655a-41ce-901a-016a4e1feb5d" alt=""><figcaption><p>Go to the Granted Assets category and download the most recent version of the Bank</p></figcaption></figure>

## Step 3

Add the SQL file to your database

```sql
CREATE TABLE `bank_user` (
  `id` varchar(36) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `beneficiaries` longtext DEFAULT '{}',
  `iban` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE `bank_user`
  ADD PRIMARY KEY (`email`);

CREATE TABLE `bank_transactions` (
  `id` int(11) NOT NULL,
  `receiver_identifier` varchar(255) DEFAULT NULL,
  `receiver_name` varchar(255) DEFAULT NULL,
  `receiver_email` varchar(255) DEFAULT NULL,
  `sender_identifier` varchar(255) DEFAULT NULL,
  `sender_name` varchar(255) DEFAULT NULL,
  `sender_email` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `value` int(50) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

ALTER TABLE `bank_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

CREATE TABLE `societies` (
  `id` int(11) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `society_name` varchar(255) DEFAULT NULL,
  `value` int(50) DEFAULT NULL,
  `iban` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

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

ALTER TABLE `societies`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;
```

## Step 4

Once the download is complete, unzip the file and drag it into the resources folder of your server

{% hint style="warning" %}
If you added the resource while your server was already running, remember to do the refresh command and then ensure the resource
{% endhint %}

```powershell
refresh
```

```
ensure Var-Bank
```
