Installation · origen_races
1. SQL
Run the file that matches your framework.
QBCore / QBX — races-qb.sql
sql
CREATE TABLE IF NOT EXISTS `origen_race_list` (
`raceid` INT(11) NOT NULL AUTO_INCREMENT,
`route_file` VARCHAR(100) DEFAULT NULL,
`route_image` VARCHAR(100) DEFAULT NULL,
`category` VARCHAR(50) DEFAULT NULL,
`besttimes` LONGTEXT DEFAULT '{}',
`max_distancia` INT(11) DEFAULT NULL,
PRIMARY KEY (`raceid`) USING BTREE,
KEY `raceid` (`raceid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;
CREATE TABLE IF NOT EXISTS `origen_race_stats` (
`citizenid` VARCHAR(50) NOT NULL,
`level` INT(11) DEFAULT 1,
`experience` INT(11) DEFAULT 0,
`frst` INT(11) DEFAULT 0,
`scnd` INT(11) DEFAULT 0,
`thrd` INT(11) DEFAULT 0,
`name` VARCHAR(255) DEFAULT NULL,
PRIMARY KEY (`citizenid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
ALTER TABLE players ADD `fav_vehs` LONGTEXT;ESX — races-esx.sql
Same tables as QBCore, with the following difference for the player table patch:
sql
ALTER TABLE users ADD `fav_vehs` LONGTEXT;2. server.cfg
text
ensure origen_races