SQL

This SQL file must be inserted when setting up the script. Ensure that you use the appropriate database for your framework.

QBCore

ALTER TABLE `player_vehicles` ADD COLUMN IF NOT EXISTS `vin` INT(1) DEFAULT 0;

ESX

ALTER TABLE `owned_vehicles` ADD COLUMN IF NOT EXISTS `vin` INT(1) DEFAULT 0;

CREATE TABLE IF NOT EXISTS `origen_boosting` (
	`identifier` varchar(100) NOT NULL,
	`name` varchar(50) NOT NULL,
	`experience` int(11) NOT NULL DEFAULT 0,
	`history` longtext NOT NULL DEFAULT '{}',
	`saved` longtext NOT NULL DEFAULT '{}',
	PRIMARY KEY (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `origen_boosting_contracts` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`label` VARCHAR(50) NOT NULL DEFAULT 'ContractName' COLLATE 'utf8mb4_general_ci',
	`vehicle` LONGTEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`guards` INT(11) NOT NULL DEFAULT '0',
	`weapon` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
	`reward` INT(11) NOT NULL DEFAULT '0',
	`experience` INT(11) NOT NULL DEFAULT '0',
	`category` VARCHAR(2) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
	`difficulty` INT(11) NOT NULL DEFAULT '0',
	`vin` INT(11) NOT NULL DEFAULT '0',
	`price` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB AUTO_INCREMENT=18;


CREATE TABLE `origen_boosting_market` (
	`id` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
	`seller` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`expire_at` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`data` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb3_general_ci' ENGINE=InnoDB;