Installation

1. Download resource

Download the purchased resource from keymaster - the official site of fivem with purchased resources.

2. Gamebuild

For the resource to work properly, it is recommended to use build 3095.

3. Database

Add the required sql file to your database

If you currently have an owned_vehicles table in your database, read ..., maybe your legacy garage system is compatible with vms_garagesv2 Migration system.

owned_vehicles

If you want to create a new table:

CREATE TABLE IF NOT EXISTS `owned_vehicles` (
  `owner` varchar(80) DEFAULT NULL,
  `company` varchar(50) DEFAULT NULL,
  `plate` varchar(8) DEFAULT NULL,
  `vin` varchar(17) DEFAULT NULL,
  `netid` int(11) DEFAULT NULL,
  `milage` int(11) DEFAULT NULL,
  `vehicle` longtext DEFAULT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'vehicle',
  `garage` varchar(50) DEFAULT NULL,
  `garageSpotID` int(11) DEFAULT NULL,
  `parking_date` int(11) DEFAULT NULL,
  `impound_date` int(11) DEFAULT NULL,
  `impound_data` longtext DEFAULT NULL,
  `insurance` longtext DEFAULT NULL,
  `tuning_data` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

If you want to add the required columns to the current table:

ALTER TABLE `owned_vehicles`
    ADD COLUMN `type` varchar(50) NOT NULL DEFAULT 'vehicle',
    ADD COLUMN `company` varchar(50) DEFAULT NULL,
    ADD COLUMN `vin` varchar(17) DEFAULT NULL,
    ADD COLUMN `netid` int(11) DEFAULT NULL,
    ADD COLUMN `milage` int(11) DEFAULT NULL,
    ADD COLUMN `garage` varchar(50) DEFAULT NULL,
    ADD COLUMN `garageSpotID` int(11) DEFAULT NULL,
    ADD COLUMN `parking_date` int(11) DEFAULT NULL,
    ADD COLUMN `impound_date` int(11) DEFAULT NULL,
    ADD COLUMN `impound_data` longtext DEFAULT NULL,
    ADD COLUMN `insurance` longtext DEFAULT NULL
;
parkings

CREATE TABLE IF NOT EXISTS `parkings` (
  `owner` varchar(100) DEFAULT NULL,
  `ownerName` varchar(220) DEFAULT NULL,
  `parking` varchar(200) NOT NULL,
  `space` int(11) NOT NULL DEFAULT 0,
  `time` bigint(20) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
vms_business

if you are not using vms_stores/vms_tuning/vms_vehicleshopv2, you should create this table:

CREATE TABLE IF NOT EXISTS `vms_business` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `type` varchar(50) NOT NULL DEFAULT '',
  `owner` mediumtext DEFAULT NULL,
  `employees` longtext DEFAULT '{}',
  `stock` longtext DEFAULT '{}',
  `data` longtext DEFAULT '{}',
  `announcements` longtext DEFAULT '{}',
  `orders` longtext DEFAULT '{}',
  `history` longtext DEFAULT '{}'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

If you already have vms_business table, but you don't have history column in your table, you have to import it using this query:

ALTER TABLE `vms_business` ADD COLUMN `history` longtext DEFAULT '{}';

Last updated