π§ Installation
Prerequisites
Required Dependencies
π¦ Installation Steps
1. Dependencies Installation
2. Database Setup
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;
3. Script Installation
Need Help?
β
Installation Checklist
Last updated
