SQL
ALTER TABLE users ADD `fav_vehs` LONGTEXT;ALTER TABLE players ADD `fav_vehs` LONGTEXT;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 '{}',
PRIMARY KEY (`raceid`) USING BTREE,
KEY `raceid` (`raceid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;
INSERT INTO `origen_race_list` (`raceid`, `route_file`, `route_image`, `category`, `besttimes`) VALUES
(1, 'https://prod.cloud.rockstargames.com/ugc/gta5mission/5131/NoAH41FpvUyay6kP6Q0-1Q/0_0_de.json', 'https://prod.cloud.rockstargames.com/ugc/gta5mission/5131/NoAH41FpvUyay6kP6Q0-1Q/2_0.jpg', 'Metamorfosis', '[{"vehicle":"Krieger","time":290524,"name":"Saaweel","date":"03/13/23"},{"vehicle":"Grotti Turismo R","name":"zKXDEX","date":"08/28/23","time":358180},{"vehicle":"Tezeract","name":"sergiamo33","time":589391,"date":"04/30/23"}]'),
(2, 'https://prod.cloud.rockstargames.com/ugc/gta5mission/5403/8PrF1PzohUGVERk5IH68Ew/0_0_de.json', 'https://prod.cloud.rockstargames.com/ugc/gta5mission/5403/8PrF1PzohUGVERk5IH68Ew/2_0.jpg', 'Acrobáticas', '[{"name":"Saaweel","time":174430,"date":"03/13/23","vehicle":"X80 Proto"},{"vehicle":"Bmw Z4M","name":"zKXDEX","date":"06/21/23","time":250832}]'),
(3, 'https://prod.cloud.rockstargames.com/ugc/gta5mission/4900/OYNdzQ25V0umv4-Ox249Wg/0_0_de.json', 'https://prod.cloud.rockstargames.com/ugc/gta5mission/4900/OYNdzQ25V0umv4-Ox249Wg/2_0.jpg', 'acrobatica', '[{"time":414463,"date":"04/30/23","name":"sergiamo33","vehicle":"Ignus"},{"time":444645,"date":"04/30/23","name":"zKXDEX","vehicle":"Ignus"}]'),
(4, 'https://prod.cloud.rockstargames.com/ugc/gta5mission/3003/Tkrb5GjT8ku5g68vpD7pUA/0_0_pt.json', 'https://prod.cloud.rockstargames.com/ugc/gta5mission/3003/Tkrb5GjT8ku5g68vpD7pUA/2_0.jpg', 'Quasar', '[{"time":59017,"vehicle":"10F ancho","name":"sergiamo33","date":"04/30/23"},{"time":64042,"vehicle":"BR8","name":"zKXDEX","date":"04/30/23"}]'),
(5, 'https://prod.cloud.rockstargames.com/ugc/gta5mission/0582/bCVwqiifsE-JT967RtWSFw/0_0_pt.json', 'https://prod.cloud.rockstargames.com/ugc/gta5mission/0582/bCVwqiifsE-JT967RtWSFw/2_0.jpg', 'Quasar', '[{"date":"04/30/23","time":159287,"name":"zKXDEX","vehicle":"Itali GTB"},{"date":"04/30/23","time":188475,"name":"sergiamo33","vehicle":"Itali GTB"}]');
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;
INSERT INTO `origen_race_stats` (`citizenid`, `level`, `experience`, `frst`, `scnd`, `thrd`, `name`) VALUES ('DBT09736', 0, 1, 1, 0, 0, 'Saaweel');Last updated