CREATE USER 'helmes'@'localhost'
  IDENTIFIED BY 'bootcamp';
CREATE DATABASE bookings;
GRANT ALL ON bookings.* TO 'helmes'@'localhost';
FLUSH PRIVILEGES;

USE bookings;
CREATE TABLE booking (
  ID INT(11) AUTO_INCREMENT NOT NULL,
  GARAGE VARCHAR(16) NOT NULL,
  VEHICLETYPE VARCHAR(16) NOT NULL,
  STARTDATETIME VARCHAR(16) NOT NULL,
  ENDDATETIME VARCHAR(16) NOT NULL,
  LICENCEPLATE VARCHAR(9) NOT NULL,
  PHONE INT(11) NOT NULL,
  TYREHOTEL BOOLEAN,
  COMMENT VARCHAR(255),
  CANCELDATETIME VARCHAR(16),

  PRIMARY KEY (ID)
)
  DEFAULT CHARACTER SET utf8
  COLLATE utf8_unicode_ci
  ENGINE = InnoDB;

CREATE TABLE garage (
  ID INT AUTO_INCREMENT NOT NULL,
  NAME VARCHAR(15) NOT NULL,
  ADDRESS VARCHAR(200) NOT NULL,
  TYRESTORAGE BOOLEAN,

  PRIMARY KEY (ID)
)
  DEFAULT CHARACTER SET utf8
  COLLATE utf8_unicode_ci
  ENGINE = InnoDB;