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 `label` VARCHAR(50) NULL DEFAULT NULL,
ADD COLUMN `storedAt` TIMESTAMP NULL DEFAULT NULL;

QBox

ALTER TABLE `player_vehicles` 
ADD COLUMN `label` VARCHAR(50) NULL DEFAULT NULL,
ADD COLUMN `storedAt` TIMESTAMP NULL DEFAULT NULL;

ESX

ALTER TABLE `owned_vehicles` 
ADD COLUMN `label` VARCHAR(50) NULL DEFAULT NULL,
ADD COLUMN `storedAt` TIMESTAMP NULL DEFAULT NULL;

CREATE TABLE `origen_garages` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NOT NULL DEFAULT '',
	`label` VARCHAR(50) NOT NULL DEFAULT '',
	`capacity` INT(5) NULL DEFAULT NULL,
	`interior` LONGTEXT NOT NULL,
	`stayCharge` INT(11) NULL DEFAULT '0',
	`vehicleTypes` LONGTEXT NOT NULL,
	`blip` LONGTEXT NOT NULL,
	`ped` LONGTEXT NOT NULL,
	`dropPoint` LONGTEXT NOT NULL,
	`states` VARCHAR(50) NOT NULL,
	`restrictions` TEXT NOT NULL,
	`spawnPoints` LONGTEXT NOT NULL,
	`shared` BIT(1) NOT NULL,
	`spawner` LONGTEXT NOT NULL,
	`price` INT(11) NULL DEFAULT '0',
	`owner` VARCHAR(50) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
) COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB;

CREATE TABLE `origen_garages_data` (
  `garage_id` int(11) NOT NULL,
  `holders` longtext NOT NULL,
  `furniture` longtext NOT NULL,
  PRIMARY KEY (`garage_id`),
  CONSTRAINT `FK__origen_garages` FOREIGN KEY (`garage_id`) REFERENCES `origen_garages` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;