🛠️Installation

Before you install this code manually you can run the script and the script gona create everything automatic.

CREATE TABLE IF NOT EXISTS `m_tuning_zones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL DEFAULT 'New Zone',
  `coords_x` float NOT NULL DEFAULT 0,
  `coords_y` float NOT NULL DEFAULT 0,
  `coords_z` float NOT NULL DEFAULT 0,
  `radius` float NOT NULL DEFAULT 15,
  `blip_enable` tinyint(1) NOT NULL DEFAULT 1,
  `blip_sprite` int(11) NOT NULL DEFAULT 72,
  `blip_color` int(11) NOT NULL DEFAULT 3,
  `blip_scale` float NOT NULL DEFAULT 0.8,
  `job` text DEFAULT NULL,
  `vehicle_blacklist` text DEFAULT NULL,
  `vehicle_whitelist` text DEFAULT NULL,
  `identifiers` text DEFAULT NULL,
  `allowed_mods` text DEFAULT NULL,
  `free_jobs` text DEFAULT NULL,
  `pending_only` tinyint(1) NOT NULL DEFAULT 0,
  `pending_coords_x` float DEFAULT NULL,
  `pending_coords_y` float DEFAULT NULL,
  `pending_coords_z` float DEFAULT NULL,
  `pending_jobs` text DEFAULT NULL,
  `pending_label` varchar(128) DEFAULT 'Pending Tuning Orders',
  `prices` text DEFAULT NULL,
  `society_pay` tinyint(1) NOT NULL DEFAULT 0,
  `society_pay_job` varchar(64) DEFAULT NULL,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `mechanic_commission` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `m_pending_tuning` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plate` varchar(8) NOT NULL,
  `vehicle_model` varchar(64) DEFAULT NULL,
  `vehicle_label` varchar(128) DEFAULT NULL,
  `player_name` varchar(64) DEFAULT NULL,
  `player_identifier` varchar(128) DEFAULT NULL,
  `zone_index` int(11) DEFAULT NULL,
  `mods_data` longtext NOT NULL,
  `total_cost` int(11) DEFAULT 0,
  `status` varchar(16) DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `m_vehicle_stance` (
  `plate` varchar(8) NOT NULL,
  `stance_data` longtext DEFAULT NULL,
  PRIMARY KEY (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;