đ ī¸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