ESX SQL

CREATE TABLE IF NOT EXISTS `origen_parking` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `owner` varchar(50) DEFAULT NULL,
  `parkedBy` varchar(50) DEFAULT NULL,
  `plate` varchar(50) DEFAULT NULL,
  `model` varchar(50) NOT NULL DEFAULT '',
  `hash` varchar(50) DEFAULT NULL,
  `coords` longtext NOT NULL,
  `type` varchar(50) DEFAULT NULL,
  `mods` longtext DEFAULT NULL,
  `lastUpdate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `plate` (`plate`),
  KEY `license` (`owner`) USING BTREE,
  KEY `parkedBy` (`parkedBy`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

Last updated