# Installation

{% stepper %}
{% step %}

### Download resource from your CFX key

Head to [CFX Portal](https://portal.cfx.re) and download the resource.
{% endstep %}

{% step %}

### Run the SQL query in your DB Server

You will find the query file in the`[SQL]` folder, or if you lost it you can copy it from here:

{% code title="player\_skills.sql" fullWidth="false" %}

```sql
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `player_skills`;
CREATE TABLE `player_skills`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `job` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
  `skill_points` int(11) NULL DEFAULT 0,
  `level` int(4) NOT NULL DEFAULT 0,
  `xp` int(16) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `citizen_id`(`identifier`, `job`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 619 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
```

{% endcode %}

{% endstep %}

{% step %}

### Add all required items and images found in `[requirements]` folder 

You can either use the included images , or your own , but the names have to match the ones given in the included images.
{% endstep %}

{% step %}

### Install Dependencies

> This script requires `ox_lib` & `oxmysql`

{% hint style="info" %}
You have to ensure this script AFTER both dependencies !
{% endhint %}
{% endstep %}

{% step %}

### Add the resource in your server.cfg file

```lua
ensure ip_herb
```

{% endstep %}

{% step %}

### That's it , you can now join your server and make sure everything works!

{% hint style="info" %}
If you have any issues, you can contact us on our [discord](https://discord.gg/KBdcsc3Ep3) !
{% endhint %}
{% endstep %}
{% endstepper %}