 CREATE DATABASE IF NOT EXISTS pattsdb;
+
 CREATE TABLE `pattsdb`.`User`
 	(
 	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

	`mysqlUser` VARCHAR(45) NOT NULL,
	PRIMARY KEY (`id`)
	);
CREATE TABLE `pattsdb`.`Client` 
	(
	`id` INT SIGNED NOT NULL AUTO_INCREMENT,
	`state` BIT NOT NULL,
	`firstName` VARCHAR(45) NOT NULL,
	`lastName` VARCHAR(45) NOT NULL,
	PRIMARY KEY (`id`)
	);
CREATE TABLE `pattsdb`.`TaskType` 
	(
	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,

	`startTime` DATETIME NOT NULL,
	`endTime` DATETIME NULL,
	PRIMARY KEY(`id`)
	);

CREATE USER 'patts'@'%' IDENTIFIED BY 'patts';
GRANT ALL PRIVILEGES ON *.* TO 'patts'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
INSERT INTO pattsdb.User VALUES(1,1,'Patts','Admin','patts');