π οΈInstallation
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;qb-core/shared/jobs.lua
Last updated