🛠ī¸Installation

Insert the SQL:

CREATE TABLE IF NOT EXISTS `carwashs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `owner` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `wash_location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL,
  `wash_cost` int NOT NULL,
  `water_liter` int DEFAULT NULL,
  `company_balance` int DEFAULT NULL,
  `company_level` int NOT NULL DEFAULT (0),
  `company_price` int DEFAULT NULL,
  `cars_washed` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;


CREATE TABLE IF NOT EXISTS `carwashs_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `storeid` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `vehicle` varchar(50) DEFAULT NULL,
  `price` int DEFAULT NULL,
  `date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;

Last updated