# okokBilling

[**YouTube Video**](https://www.youtube.com/watch?v=9gXfTvyzzEI)

## Installation Guide

In case you had the previous okokBilling version (both ESX & QBCore) execute the code below in your database, otherwise ignore it.

```sql
DROP TABLE okokbilling;
```

#### Execute the following SQL code in your database:

```sql
CREATE TABLE `okokbilling` (
    `id` int NOT NULL AUTO_INCREMENT,
    `ref_id` varchar(10) NOT NULL,
    `receiver_identifier` varchar(255) NOT NULL,
    `receiver_name` varchar(255) NOT NULL,
    `author_identifier` varchar(255) NOT NULL,
    `author_name` varchar(255) NOT NULL,
    `society` varchar(255) NOT NULL,
    `society_name` varchar(255) NOT NULL,
    `item` varchar(255) NOT NULL,
    `invoice_value` int NOT NULL,
    `fees_amount` int NOT NULL,
    `status` varchar(50) NOT NULL,
    `notes` LONGTEXT DEFAULT ' ',
    `sent_date` varchar(255) NOT NULL,
    `limit_pay_date` varchar(255) NOT NULL,
    `paid_date` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
);
```

### Server artifacts

Make sure your server artifacts version is above the **5181**.

* Windows: <https://runtime.fivem.net/artifacts/fivem/build_server_windows/master/>
* Linux: <https://runtime.fivem.net/artifacts/fivem/build_proot_linux/master/>