Database

ONLY USE THIS if it does not install it AUTOMATICALLY

If there are already tables existing, delete those with

DROP TABLE IF EXISTS `owned_vehicles`;
DROP TABLE IF EXISTS `player_vehicles`;

-- USE THIS FOR ESX
ALTER TABLE owned_vehicles ADD COLUMN (
    `favorite` TINYINT(1) DEFAULT 0,
    `nickname` VARCHAR(25) DEFAULT 'NONE',
    `job` VARCHAR(25) DEFAULT NULL,
    `garage` VARCHAR(25) DEFAULT NULL,
    `state` INT(10) DEFAULT 1
);

-- USE THIS FOR QB_CORE
ALTER TABLE player_vehicles ADD COLUMN (
    `favorite` TINYINT(1) DEFAULT '0',
    `nickname` VARCHAR(25) DEFAULT 'NONE',
    `job` VARCHAR(25) DEFAULT NULL
);