$ CREATE DATABASE hotel_booking;

$ use hotel_booking;

$ CREATE TABLE users (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR (255) NOT NULL,
    email VARCHAR (255) NOT NULL
    );

$ CREATE TABLE rooms (
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    room_number INT NOT NULL,
    room_price FLOAT NOT NULL,
    category VARCHAR (255) NOT NULL,
    description VARCHAR (255) NOT NULL
    );  

$ CREATE TABLE booking (
      id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
      final_price FLOAT NOT NULL,
      date VARCHAR (255) NOT NULL,
      user_id INT NOT NULL,
      FOREIGN KEY (user_id) REFERENCES users(id) 
      );

$ CREATE TABLE orders (
   id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
   booking_id INT NOT NULL,
   room_id INT NOT NULL,
   FOREIGN KEY (booking_id) REFERENCES booking(id),
   FOREIGN KEY (room_id) REFERENCES rooms(id),
   breakfast boolean not null default 0,
   cleaning boolean not null default 0
   );

$ INSERT INTO `users` VALUES 
    (5,'Anton','[email protected]'),
    (6,'Oleg','[email protected]'),
    (7,'Artur','[email protected]'),
    (8,'Katya','[email protected]');

$ INSERT INTO `rooms` VALUES 
    (3,101,50,'1 person','1 bad ; TV; SP4;'),
    (4,102,100,'2 persons','1 bad ; TV; SP4;'),
    (5,103,150,'2 persons','2 bad ; TV; SP4;'),
    (6,201,200,'lux','2 bad ; TV; SP4;'),
    (7,202,350,'lux','2 bad ; 2TV; SP4;'),
    (8,204,500,'presedent lux','4 bad; 2 bathrooms; 3 TV;'),
    (9,301,100,'1 person','1 bad ; TV; SP4;'),
    (10,302,250,'presedent lux','2 bad ; TV; SP4;');

$ INSERT INTO `booking` VALUES (1,0,5,'12.12.2012');

$ INSERT INTO `orders` VALUES (1,1,3,1,0);

$ mvn spring-boot:run