CREATETABLE `okokvehiclesales_stores`(`store_name`varchar(255) NOT NULL,`store_id`varchar(255) NOT NULLPRIMARY KEY,`owner`varchar(255) NULLDEFAULTNULL,`owner_name`varchar(255) NULLDEFAULTNULL,`owner_phone`varchar(255) NULLDEFAULTNULL,`money`varchar(255) NOT NULL,`business_price`varchar(255) NOT NULL,`vehicles_sold_owner`varchar(255) DEFAULT0,`total_earned_owner`varchar(255) DEFAULT0,`vehicles` longtext NULL,`employees` longtext NULL,`inactivity_date`varchar(255) DEFAULTNULL);CREATETABLE `okokvehiclesales_orders`(`id`int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`store_id`varchar(255) NOT NULL,`vehicle`varchar(255) NOT NULL,`price`varchar(255) NOT NULL,`status`varchar(255) NOT NULL,`employee_name`varchar(255) NOT NULL,`employee_id`varchar(255) NOT NULL,`customer_name`varchar(255) NOT NULL,`customer_phone`varchar(255) NOT NULL,`notes`varchar(255) NOT NULL,`date`varchar(255) NOT NULL);CREATETABLE `okokvehiclesales_saleshistory`(`store_id`varchar(255) NOT NULL,`seller_id`varchar(255) NOT NULL,`seller_name`varchar(255) NOT NULL,`vehicle_name`varchar(255) NOT NULL,`plate`varchar(255) NOT NULL,`value`varchar(255) NOT NULL,`date`varchar(255) NOT NULL);CREATETABLE `okokvehiclesales_auctions`(`id`int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,`store_id`varchar(255) NOT NULL,`vehicle`varchar(255) NOT NULL,`plate`varchar(255) NOT NULL,`starting_bid`varchar(255) NOT NULLDEFAULT0,`total_bids`varchar(255) NOT NULLDEFAULT0,`higher_bid`varchar(255) NOT NULLDEFAULT0,`higher_bidder_id`varchar(255) DEFAULTNULL,`higher_bidder_name`varchar(255) DEFAULTNULL,`higher_bidder_phone`varchar(255) DEFAULTNULL,`bidders` longtext NULL);
If using ESX, execute the following code as well:
ALTERTABLE owned_vehicles ADD okokVehicleSalesOwned varchar(255) NOT NULLDEFAULT0;
If using QBCore, execute the following code:
ALTERTABLE player_vehicles ADD okokVehicleSalesOwned varchar(255) NOT NULLDEFAULT0;
Set the Discord Webhook URL (to enable logs)
Navigate to the sv_utils.lua file and paste the webhook URL in the line 2.