Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.
This script includes an essential database required for its operation.You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.
ESX/QB
sql
DROPTABLE IF EXISTS `dispatch_callsigns`;
CREATE TABLE IF NOTEXISTS `dispatch_callsigns` (
`identifier` varchar(46) NOT NULL,
`callsign` varchar(50) NOT NULL,
PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_cameras`;
CREATE TABLE IF NOTEXISTS `dispatch_cameras` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(25) DEFAULTNULL,
`model` varchar(50) NOT NULL,
`coords` varchar(255) NOT NULL,
`type` varchar(50) DEFAULTNULL,
`metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_jail_database`;
CREATE TABLE IF NOTEXISTS `dispatch_jail_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_identifier` varchar(255) NOT NULL,
`jail_reason` varchar(255) NOT NULL,
`jail_time` int(11) NOT NULL,
`jail_start` timestampNOT NULLDEFAULTcurrent_timestamp(),
`jail_end` timestampNULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
DROPTABLE IF EXISTS `dispatch_mdt_bolos`;
CREATE TABLE IF NOTEXISTS `dispatch_mdt_bolos` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULTNULL,
`jobtype` varchar(25) DEFAULT'police',
`title` varchar(50) DEFAULTNULL,
`content` mediumtext DEFAULTNULL,
`officers_involved` text DEFAULTNULL,
`createdAt` varchar(50) DEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=22DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_mdt_convictions`;
CREATE TABLE IF NOTEXISTS `dispatch_mdt_convictions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULTNULL,
`charges` text DEFAULTNULL,
`warrant` varchar(50) DEFAULTNULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_mdt_data`;
CREATE TABLE IF NOTEXISTS `dispatch_mdt_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(46) DEFAULTNULL,
`tags` text NOT NULL,
`jobtype` varchar(25) DEFAULT'police',
`pfp` text DEFAULTNULL,
`notes` mediumtext DEFAULTNULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_mdt_incidents`;
CREATE TABLE IF NOTEXISTS `dispatch_mdt_incidents` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`CreatorName` varchar(50) DEFAULTNULL,
`jobtype` varchar(25) DEFAULT'police',
`title` varchar(50) DEFAULTNULL,
`content` mediumtext DEFAULTNULL,
`citizens_involved` text DEFAULTNULL,
`criminals_involved` text DEFAULTNULL,
`officers_involved` text DEFAULTNULL,
`createdAt` varchar(50) DEFAULTNULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_players_database`;
CREATE TABLE IF NOTEXISTS `dispatch_players_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` longtext NOT NULL,
`datatype` varchar(1200) NOT NULLDEFAULT'undefinedData',
`dataobj` longtext NOT NULL,
`createdAt` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROPTABLE IF EXISTS `dispatch_vehicle_database`;
CREATE TABLE IF NOTEXISTS `dispatch_vehicle_database` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`datatype` varchar(50) DEFAULTNULL,
`by` varchar(50) DEFAULTNULL,
`plate` varchar(50) NOT NULL,
`data` longtext DEFAULTNULL,
`createdAt` varchar(150) DEFAULTNULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;