CREATE SCHEMA `company`;
USE `company`;

--
-- Table structure for table `department`
--
CREATE TABLE `department` (
  `department_name` varchar(100) NOT NULL,
  `department_location` varchar(100) NOT NULL,
  PRIMARY KEY (`department_name`)
);

INSERT INTO department (department_name, department_location) VALUES ('Operations', 'Hilversum');
INSERT INTO department (department_name, department_location) VALUES ('Support', 'Amsterdam');
INSERT INTO department (department_name, department_location) VALUES ('Management', 'Almere');
INSERT INTO department (department_name, department_location) VALUES ('Documentation', 'Gouda');

CREATE USER 'userCompany'@'localhost' IDENTIFIED BY 'userCompanyPW';
GRANT ALL PRIVILEGES ON company.* TO 'userCompany'@'localhost';
FLUSH PRIVILEGES;