CREATE TABLE `okokgasstation_stores`(
`store_name` varchar(255) NOT NULL,
`store_id` varchar(255) NOT NULL PRIMARY KEY,
`owner` varchar(255) NULL DEFAULT NULL,
`owner_name` varchar(255) NULL DEFAULT NULL,
`money` varchar(255) NOT NULL,
`business_price` varchar(255) NOT NULL,
`gas_price` DECIMAL(10, 2) NOT NULL DEFAULT 2.00,
`current_stock` varchar(255) NOT NULL,
`max_stock` varchar(255) NOT NULL,
`employees` longtext NULL,
`vehicles` longtext NULL,
`inactivity_date` varchar(255) DEFAULT NULL
);
CREATE TABLE `okokgasstation_orders`(
`id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`store_id` varchar(255) NOT NULL,
`liters` varchar(255) NOT NULL,
`vehicle` varchar(255) NOT NULL,
`long_vehicle` varchar(255) NOT NULL,
`reward` varchar(255) NOT NULL,
`in_progress` varchar(255) NOT NULL,
`employee_name` varchar(255) NOT NULL,
`employee_id` varchar(255) NOT NULL
);
CREATE TABLE `okokgasstation_saleshistory`(
`store_id` varchar(255) NOT NULL,
`buyer_id` varchar(255) NOT NULL,
`buyer_name` varchar(255) NOT NULL,
`liters` varchar(255) NOT NULL,
`price` varchar(255) NOT NULL,
`date` varchar(255) NOT NULL
);
exports['okokGasStation']:GetFuel(vehicle)
exports['okokGasStation']:SetFuel(vehicle, fuel)
exports['okokGasStation']:AddGasStationFuel(gasStationID, fuel)
exports['okokGasStation']:RemoveGasStationFuel(gasStationID, fuel)
