create table

CREATE DATABASE `sql4101807` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE TABLE `account` (
  `Id` SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(45) DEFAULT NULL,
  `Firstname` VARCHAR(45) DEFAULT NULL,
  `Lastname` VARCHAR(45) DEFAULT NULL,
  `Email` VARCHAR(45) DEFAULT NULL,
  `Password` VARCHAR(45) DEFAULT NULL,
  `Admin` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

CREATE TABLE `hero` (
  `Id` INT(11) NOT NULL AUTO_INCREMENT,
  `Name` VARCHAR(45) NOT NULL,
  `Gender` INT(11) DEFAULT NULL,
  `Race` VARCHAR(45) NOT NULL,
  `World` VARCHAR(45) DEFAULT NULL,
  `Location` VARCHAR(45) DEFAULT NULL,
  `Level` INT(11) DEFAULT '1',
  `Position_X` INT(10) UNSIGNED DEFAULT NULL,
  `Position_Y` INT(10) UNSIGNED DEFAULT NULL,
  `Position_Z` INT(10) UNSIGNED DEFAULT NULL,
  `Orientation_W` INT(10) UNSIGNED DEFAULT NULL,
  `Orientation_X` INT(10) UNSIGNED DEFAULT NULL,
  `Orientation_Y` INT(10) UNSIGNED DEFAULT NULL,
  `Orientation_Z` INT(10) UNSIGNED DEFAULT NULL,
  `Account_Id` SMALLINT(5) UNSIGNED NOT NULL,
  PRIMARY KEY (`Id`),
  KEY `Hero_Owner` (`Account_Id`),
  CONSTRAINT `Hero_Owner` FOREIGN KEY (`Account_Id`) REFERENCES `account` (`Id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

CREATE TABLE `location` (
  `Id` INT(11) NOT NULL AUTO_INCREMENT,
  `Name` CHAR(50) NOT NULL,
  `Scene` CHAR(50) NOT NULL COMMENT 'Path to scene XML file',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Location can be station, dungeon, planet etc.\r\n';