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
sql
ALTER TABLE
`users`
ADD
IF NOTEXISTS `motorhome_inside` TEXT NULLDEFAULTNULL;
CREATE TABLE IF NOTEXISTS `motorhome_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`plate` VARCHAR(50) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`coords` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`rotation` TEXT NOT NULLDEFAULT''COLLATE'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULLDEFAULT'0',
`created` TIMESTAMPNULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `plate`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOTEXISTS `motorhome` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`plate` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`stash` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`wardrobe` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`charge` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `plate` (`plate`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;
ALTER TABLE `motorhome` ADDCOLUMN IF NOTEXISTS `vaultCodes` LONGTEXT NULLDEFAULTNULL;
CREATE TABLE IF NOTEXISTS `qs_motorhome_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULLDEFAULTNULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULLDEFAULTNULL,
`price` INT(11) NOT NULLDEFAULT'0',
`img` TEXT NULLDEFAULTNULL,
`colorlabel` VARCHAR(255) NULLDEFAULTNULL,
`type` VARCHAR(50) NULLDEFAULTNULL,
`stash` LONGTEXT NULLDEFAULTNULL,
`offset` LONGTEXT NULLDEFAULTNULL,
`colors` LONGTEXT NULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
CREATE TABLE IF NOTEXISTS `qs_motorhome_junk` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`house` VARCHAR(255) NOT NULL,
`model` VARCHAR(255) NOT NULL,
`coords` LONGTEXT NULLDEFAULTNULL,
`created_at` TIMESTAMPNULLDEFAULTCURRENT_TIMESTAMP(),
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_house` (`house`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;
QB
sql
ALTER TABLE
`players`
ADD
IF NOTEXISTS `motorhome_inside` TEXT NULLDEFAULTNULL;
CREATE TABLE IF NOTEXISTS `motorhome_decorations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`plate` VARCHAR(50) NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`creator` VARCHAR(70) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`modelName` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`coords` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`rotation` TEXT NOT NULLDEFAULT''COLLATE'utf8mb3_general_ci',
`inStash` TINYINT(1) NOT NULLDEFAULT'0',
`created` TIMESTAMPNULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `id` (`id`, `plate`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;
CREATE TABLE IF NOTEXISTS `motorhome` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`plate` VARCHAR(50) NOT NULLDEFAULT'0'COLLATE'utf8mb3_general_ci',
`stash` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`wardrobe` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
`charge` TEXT NULLDEFAULTNULLCOLLATE'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `plate` (`plate`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;
ALTER TABLE `motorhome` ADDCOLUMN IF NOTEXISTS `vaultCodes` LONGTEXT NULLDEFAULTNULL;
CREATE TABLE IF NOTEXISTS `qs_motorhome_furnitures` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`creator` VARCHAR(80) NULLDEFAULTNULL,
`category_key` VARCHAR(100) NOT NULL,
`object` VARCHAR(200) NOT NULL,
`label` VARCHAR(255) NOT NULL,
`description` TEXT NULLDEFAULTNULL,
`price` INT(11) NOT NULLDEFAULT'0',
`img` TEXT NULLDEFAULTNULL,
`colorlabel` VARCHAR(255) NULLDEFAULTNULL,
`type` VARCHAR(50) NULLDEFAULTNULL,
`stash` LONGTEXT NULLDEFAULTNULL,
`offset` LONGTEXT NULLDEFAULTNULL,
`colors` LONGTEXT NULLDEFAULTNULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `creator` (`creator`) USING BTREE,
INDEX `category_key` (`category_key`) USING BTREE
)COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;
CREATE TABLE IF NOTEXISTS `qs_motorhome_junk` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`house` VARCHAR(255) NOT NULL,
`model` VARCHAR(255) NOT NULL,
`coords` LONGTEXT NULLDEFAULTNULL,
`created_at` TIMESTAMPNULLDEFAULTCURRENT_TIMESTAMP(),
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_house` (`house`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;