06-mysql

CREATE TABLE `categories` (
`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
`category` VARCHAR(45) NOT NULL,
`daily_rate` DECIMAL NOT NULL,
`weekly_rate` DECIMAL NOT NULL,
`monthly_rate` DECIMAL NOT NULL,
`weekend_rate` DECIMAL NOT NULL
);

CREATE TABLE `cars` (
`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
`plate_number` VARCHAR(45) NOT NULL,
`make, model` VARCHAR(45) NOT NULL,
`car_year` INT NOT NULL,
`category_id` INT NOT NULL,
`doors, picture` BLOB NULL,
`car_condition` VARCHAR(45) NOT NULL,
`available` TINYINT NOT NULL
);

CREATE TABLE `employees` (
`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
`first_name` VARCHAR(45) NOT NULL,
`last_name` VARCHAR(45) NOT NULL,
`title` VARCHAR(45) NOT NULL,
`notes` VARCHAR(45) NULL
);

CREATE TABLE `customers` (
`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
`driver_licence_number` VARCHAR(45) NOT NULL,
`full_name` VARCHAR(45) NOT NULL,
`address` VARCHAR(45) NOT NULL,
`city` VARCHAR(45) NOT NULL,
`zip_code` INT NOT NULL,
`notes` VARCHAR(200) NULL
);

CREATE TABLE `rental_orders` (
`id` INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
`employee_id` INT NOT NULL,
`customer_id` INT NOT NULL,
`car_id` INT NOT NULL,
`car_condition` VARCHAR(45) NOT NULL,
`tank_level` VARCHAR(45) NOT NULL,
`kilometrage_start` INT NOT NULL,
`kilometrage_end` INT NOT NULL,
`total_kilometrage` INT NOT NULL,
`start_date` DATE NOT NULL,
`end_date` DATE NOT NULL,
`total_days` INT NOT NULL,
`rate_applied` DOUBLE NOT NULL,
`tax_rate` DOUBLE NOT NULL,
`order_status` TINYINT NOT NULL,
`notes` VARCHAR(200) NULL
);

INSERT INTO `categories` (`id`, `category`, `daily_rate`, `weekly_rate`, `monthly_rate`, `weekend_rate`) VALUES
('1', 'text', '105.2', '105.2', '105.2', '105.2'),
('2', 'text', '105.2', '105.2', '105.2', '105.2'),
('3', 'text', '105.2', '105.2', '105.2', '105.2');

INSERT INTO `cars` (`id`, `plate_number`, `make, model`, `car_year`, `category_id`, `car_condition`, `available`) VALUES
('1', 'text', 'text', '1980', '1980', 'ok', '1'),
('2', 'text', 'text', '1980', '1980', 'ok', '1'),
('3', 'text', 'text', '1980', '1980', 'ok', '1');

INSERT INTO `employees` (`id`, `first_name`, `last_name`, `title`, `notes`) VALUES
('1', 'text', 'text', 'text', 'text'),
('2', 'text', 'text', 'text', 'text'),
('3', 'text', 'text', 'text', 'text');

INSERT INTO `customers` (`id`, `driver_licence_number`, `full_name`, `address`, `city`, `zip_code`, `notes`) VALUES
('1', 'text', 'text', 'text', 'text', '123', 'text'),
('2', 'text', 'text', 'text', 'text', '123', 'text'),
('3', 'text', 'text', 'text', 'text', '123', 'text');

INSERT INTO `rental_orders` (`id`, `employee_id`, `customer_id`, `car_id`, `car_condition`, `tank_level`, `kilometrage_start`, `kilometrage_end`, `total_kilometrage`, `start_date`, `end_date`, `total_days`, `rate_applied`, `tax_rate`, `order_status`, `notes`) VALUES
('1', '123', '123', '123', 'text', 'text', '123', '123', '123', '1980-10-10', '1980-10-10', '123', '123.3', '123.3', '1', 'text'),
('2', '123', '123', '123', 'text', 'text', '123', '123', '123', '1980-10-10', '1980-10-10', '123', '123.3', '123.3', '1', 'text'),
('3', '123', '123', '123', 'text', 'text', '123', '123', '123', '1980-10-10', '1980-10-10', '123', '123.3', '123.3', '1', 'text');