Installation Guide
Execute the Below in your Database and its all Done!!
Step 1: SQL Modifications
Instructions
CREATE TABLE `rental_vehicles` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`location` INT(11) NOT NULL,
`citizenid` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`vehicle` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`plate` VARCHAR(50) NOT NULL COLLATE 'utf8mb3_general_ci',
`mods` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin',
`rate` INT(11) NULL DEFAULT '0',
`rented` TINYINT(1) NOT NULL DEFAULT '0',
`rent_period` DATE NULL DEFAULT NULL,
`renter` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=28
;
CREATE TABLE `vehiclerentals` (
`location` INT(11) NOT NULL,
`owned` INT(11) NULL DEFAULT NULL,
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`label` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
`date_purchased` DATE NULL DEFAULT NULL,
`level` INT(11) NULL DEFAULT NULL,
`price` INT(11) NULL DEFAULT NULL,
`funds` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`location`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;Step 2: Configure the Config.lua File
Config.lua FileLast updated