OrigenNetwork
Docs
DocsScriptsorigen_garagesInstallation

Installation · origen_garages

1. SQL

Run db/database.sql to create the core tables:

sql
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;

2. Framework SQL patch

Run the file that matches your framework — this adds two columns to your vehicle table:

QBCore / QBX — db/qb.sql

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

ESX — db/esx.sql

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

3. server.cfg

text
ensure origen_garages
Previous
Dependencies