> For the complete documentation index, see [llms.txt](https://docs.okokscripts.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.okokscripts.io/scripts/okokshop.md).

# okokShop

[**YouTube Video**](https://www.youtube.com/watch?v=S2G-hvwyMnE)

## **Installation Guide**

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

```sql
CREATE TABLE `okokshop_stores`(
    `store_name` varchar(255) NOT NULL,
    `store_id` varchar(255) NOT NULL PRIMARY KEY,
    `owner` varchar(255) NULL DEFAULT NULL,
    `owner_name` varchar(255) NULL DEFAULT NULL,
    `money` varchar(255) NOT NULL,
    `business_price` varchar(255) NOT NULL,
    `current_stock` varchar(255) NOT NULL,
    `max_stock` varchar(255) NOT NULL,
    `employees` longtext NULL,
    `items` longtext NULL,
    `inactivity_date` varchar(255) DEFAULT NULL
);

CREATE TABLE `okokshop_orders`(
    `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `store_id` varchar(255) NOT NULL,
    `item` varchar(255) NOT NULL,
    `label` varchar(255) NOT NULL,
    `amount` varchar(255) NOT NULL,
    `reward` varchar(255) NOT NULL,
    `in_progress` varchar(255) NOT NULL,
    `employee_name` varchar(255) NOT NULL,
    `employee_id` varchar(255) NOT NULL
);

CREATE TABLE `okokshop_saleshistory`(
    `store_id` varchar(255) NOT NULL,
    `buyer_id` varchar(255) NOT NULL,
    `buyer_name` varchar(255) NOT NULL,
    `item` varchar(255) NOT NULL,
    `amount` varchar(255) NOT NULL,
    `price` varchar(255) NOT NULL,
    `date` varchar(255) NOT NULL
);
```

### Set the Discord Webhook URL (to enable logs)

Navigate to the `sv_utils.lua` file and paste the webhook URL in the line 2.

[How to create a Discord Webhook URL](https://ahsda89sgdh18923asd.gitbook.io/main/others/discord-webhook)

### 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/>