> For the complete documentation index, see [llms.txt](https://needforscript.gitbook.io/needforscripts/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://needforscript.gitbook.io/needforscripts/our-scripts/jobs/installation.md).

# Installation

### Prerequisites

Before installing the NFS Jobs Script, ensure you have the following dependencies:

#### Required Dependencies

📦[ **ox\_lib**](https://github.com/overextended/ox_lib)

🌉 [**bl\_bridge**](https://github.com/Byte-Labs-Studio/bl_bridge)

***

### 📦 Installation Steps

#### 1. Dependencies Installation

* Install[ **ox\_lib**](https://github.com/overextended/ox_lib)
* Install[ **bl\_bridge**](https://github.com/Byte-Labs-Studio/bl_bridge)
* Ensure your framework is up to date

#### 2. Database Setup &#x20;

**📃 SQL Table**

Execute the following SQL queries in your database:

```sql
CREATE TABLE IF NOT EXISTS `nfs_jobs` (
  `id` varchar(32) NOT NULL,
  `owner_id` varchar(64) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `category` varchar(64) DEFAULT NULL,
  `type` varchar(64) DEFAULT NULL,
  `due_date` bigint(20) DEFAULT NULL,
  `number_of_applicants` int(11) NOT NULL DEFAULT 0,
  `pay_rate` decimal(10,2) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `banner` text DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `phone_number` varchar(32) DEFAULT NULL,
  `location` text DEFAULT NULL,
  `questions` text DEFAULT NULL,
  `public` tinyint(1) DEFAULT NULL,
  `status` enum('draft','open','closed') NOT NULL DEFAULT 'open',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_owner_id` (`owner_id`),
  KEY `idx_due_date` (`due_date`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

```

🚨 **Important Notes**

* Ensure your database user has permissions to create and modify tables
* Backup your database before installation
* Run these queries in your server's database

#### 3. Script Installation

1. Download the NFS Jobs Script  from your [keymaster portal granted assets](https://portal.cfx.re/login)
2. Place in your resources folder
3. Add to your server.cfg or resources.cfg
4. Add bl\_bridge convars to your server.cfg with your server options

```lua
# Frameworks 'ox' | 'qb' | 'esx' | 'qbx'
setr bl:framework 'qb'

# Inventories 'ox' | 'qb' | 'esx' | 'ps' | 'qs' | 'origen' | 'none'
setr bl:inventory 'ox'

# Context 'ox' | 'qb'
setr bl:context 'ox'

# Target 'ox' | 'qb'
setr bl:target 'ox'

# Progress 'ox' | 'qb'
setr bl:progressbar 'ox'

# Radial 'ox' | 'qb'
setr bl:radial 'ox'

# Notification 'ox' | 'qb' | 'esx'
setr bl:notify 'ox'

# TextUI 'ox' | 'qb' | 'esx'
setr bl:textui 'ox'
```

***

### Need Help?

* Check our [**Discord support channel**](https://discord.com/invite/e6978cg73k)
* Review the comprehensive **documentation**

***

### ✅ Installation Checklist

* [ ] Install ox\_lib
* [ ] Install bl\_bridge
* [ ] Create SQL tables
* [ ] Place script in resources and start it on your .cfg file
* [ ] Configure settings
* [ ] Restart server
