📅SQL

• To ensure the vehicle shop stocking system works as intended you must run or import the SQL file provided in the folder [SQL] to your database. Failure to do so will result in errors when using the vehicle shop

CREATE TABLE IF NOT EXISTS `vehicleshop_stock` (
  `shop_name` varchar(50) NOT NULL,
  `vehicle_model` varchar(50) NOT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `total_sold` int(11) NOT NULL DEFAULT 0,
  `last_modified_by_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`shop_name`, `vehicle_model`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;