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');

PreviousInstallation NextExports

Last updated 6 months ago

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');