CREATE DATABASE IF NOT EXISTS `employees`;
USE `employees`;

CREATE USER IF NOT EXISTS `kata3`@`localhost` IDENTIFIED BY "kata3";
GRANT ALL ON `employees`.* TO `kata3`@`localhost`;
FLUSH PRIVILEGES;

DROP TABLE IF EXISTS Employees;

CREATE TABLE `employees`.`Employees` (
  `id` INT NOT NULL AUTO_INCREMENT ,
  `name` VARCHAR(100) NULL ,
  `surname` VARCHAR(100) NULL ,
  `birth` DATE NULL ,
  `salary` INT NULL ,
  `intern` BIT NULL ,
  PRIMARY KEY (`id`)
);
