πŸ› οΈInstallation

  1. Run the m_vehicleshop.sql

CREATE TABLE IF NOT EXISTS `m_vehicleshop` (
  `carID` int(11) NOT NULL AUTO_INCREMENT,
  `carName` varchar(255) NOT NULL,
  `carLabel` varchar(255) DEFAULT NULL,
  `carPrice` decimal(10,2) NOT NULL,
  `carStock` int(11) NOT NULL,
  `carCategory` varchar(50) NOT NULL,
  `carImage` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`carID`)
) ENGINE=InnoDB AUTO_INCREMENT=710 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE IF NOT EXISTS `m_vehicleshop_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codeName` varchar(100) DEFAULT NULL,
  `vehicleName` varchar(100) DEFAULT NULL,
  `redeemed` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE IF NOT EXISTS `m_vehicleshop_sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `car` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `price` decimal(20,6) NOT NULL DEFAULT 0.000000,
  `citizenid` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  1. qb-core/shared/jobs.lua

Last updated