SQL

Execute these queries in your database

CREATE TABLE IF NOT EXISTS `origen_masterjob` (
  `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT 'ERROR',
  `label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT 'ERROR',
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT 'shop',
  `level` int(11) NOT NULL DEFAULT 0,
  `experience` int(11) NOT NULL DEFAULT 0,
  `money` int(11) NOT NULL DEFAULT 0,
  `open` int(1) NOT NULL DEFAULT 0,
  `skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '{}',
  `grades` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `players` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `npcs` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]' CHECK (json_valid(`npcs`)),
  `markers` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `missions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `vehicles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `stats` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT '[]',
  `allowed_items` longtext NOT NULL DEFAULT '[]',
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE IF NOT EXISTS `origen_masterjob_bills` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `concepts` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '[]',
  `price` int(11) DEFAULT 0,
  `job` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `payed` int(1) DEFAULT 0,
  `date` timestamp NULL DEFAULT current_timestamp(),
  `months` int(11) DEFAULT 0,
  `reportid` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE IF NOT EXISTS `origen_masterjob_documents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `businessid` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `author` varchar(255) NOT NULL DEFAULT '',
  `date` timestamp NULL DEFAULT current_timestamp(),
  `images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '[]',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE IF NOT EXISTS `origen_masterjob_notes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `documentid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_spanish_ci DEFAULT '',
  `date` timestamp NULL DEFAULT current_timestamp(),
  `fixed` int(1) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

CREATE TABLE IF NOT EXISTS `origen_masterjob_garage` (
	`id` VARCHAR(50) NOT NULL DEFAULT 'ERROR' COLLATE 'utf8mb3_general_ci',
	`garage` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`plate` VARCHAR(50) NOT NULL DEFAULT 'ERROR' COLLATE 'utf8mb3_general_ci',
	`mods` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`state` INT(1) NULL DEFAULT '0',
	`citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`model` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`plate`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;

-- ESX only metadata errors
CREATE TABLE `origen_metadata` (
	`id` VARCHAR(55) NOT NULL COLLATE 'utf8mb3_general_ci',
	`data` LONGTEXT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;