> For the complete documentation index, see [llms.txt](https://docs.wise-scripts.vip/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.wise-scripts.vip/scripts/wise-garage/database.md).

# Database

{% hint style="danger" %}
ONLY USE THIS if it does not install it **AUTOMATICALLY**
{% endhint %}

> If there are already tables existing, delete those with
>
> ```sql
> DROP TABLE IF EXISTS `owned_vehicles`;
> DROP TABLE IF EXISTS `player_vehicles`;
> ```

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