 	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
 	`state` BIT NOT NULL,
 	`parentID` INT UNSIGNED NOT NULL,
-	`displayName` VARCHAR(45) NOT NULL,
+	`displayName` VARCHAR(45) CHARACTER SET utf8 NOT NULL,
 	PRIMARY KEY (`id`)
 );
 

	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
 	`state` BIT NOT NULL,
	`isAdmin` BIT NOT NULL,
	`firstName` VARCHAR(45) NOT NULL,
	`lastName` VARCHAR(45) NOT NULL,
	`mysqlUser` VARCHAR(45) NOT NULL,
	PRIMARY KEY (`id`)
);


SET character_set_client = utf8;

CREATE DATABASE IF NOT EXISTS pattsdb;

CREATE TABLE IF NOT EXISTS `pattsdb`.`User`
