MMORPG Initial Review

IMAGE: https://pasteboard.co/HBT90Bx.png

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------
-- Schema schema_test
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema schema_test
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `schema_test` DEFAULT CHARACTER SET utf8 ;
USE `schema_test` ;

-- -----------------------------------------------------
-- Table `schema_test`.`Users`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Users` (
  `User_Index` INT NOT NULL AUTO_INCREMENT,
  `User_Username` VARCHAR(64) NOT NULL,
  `User_Name` VARCHAR(64) NOT NULL,
  `User_Email` VARCHAR(255) NOT NULL,
  `User_Password` VARCHAR(64) NOT NULL,
  `User_Modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `User_Created` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`User_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Sects`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Sects` (
  `Sect_Index` INT NOT NULL AUTO_INCREMENT,
  `Sect_Name` VARCHAR(64) NOT NULL,
  `Sect_Social_Status` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`Sect_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Trades`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Trades` (
  `Trade_Index` INT NOT NULL AUTO_INCREMENT,
  `Trade_Name` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`Trade_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Stats`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Stats` (
  `Stat_Index` INT NOT NULL AUTO_INCREMENT,
  `Stat_Name` VARCHAR(64) NOT NULL,
  `Stat_Proficiency` FLOAT NOT NULL,
  PRIMARY KEY (`Stat_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Vector3`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Vector3` (
  `Vector3_Index` INT NOT NULL,
  `Vector3_X` FLOAT NOT NULL,
  `Vector3_Y` FLOAT NOT NULL,
  `Vector3_Z` FLOAT NOT NULL,
  PRIMARY KEY (`Vector3_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Transforms`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Transforms` (
  `Transform_Index` INT NOT NULL,
  `Transform_Position` INT NOT NULL,
  `Transform_Euler_Rotation` INT NOT NULL,
  `Transform_Scale` INT NOT NULL,
  PRIMARY KEY (`Transform_Index`, `Transform_Scale`, `Transform_Euler_Rotation`, `Transform_Position`),
  INDEX `fk_Transform_Position_idx` (`Transform_Position` ASC) ,
  INDEX `fk_Transform_Euler_Rotation_idx` (`Transform_Euler_Rotation` ASC) ,
  INDEX `fk_Transform_Scale_idx` (`Transform_Scale` ASC) ,
  CONSTRAINT `fk_Transform_Position`
    FOREIGN KEY (`Transform_Position`)
    REFERENCES `schema_test`.`Vector3` (`Vector3_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Transform_Euler_Rotation`
    FOREIGN KEY (`Transform_Euler_Rotation`)
    REFERENCES `schema_test`.`Vector3` (`Vector3_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Transform_Scale`
    FOREIGN KEY (`Transform_Scale`)
    REFERENCES `schema_test`.`Vector3` (`Vector3_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Characters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Characters` (
  `Character_Index` INT NOT NULL AUTO_INCREMENT,
  `Character_Stats` INT NOT NULL,
  `Character_Transform` INT NOT NULL,
  `Character_Name` VARCHAR(64) NOT NULL,
  `Character_Sect` INT NOT NULL,
  `Character_Trade` INT NULL,
  PRIMARY KEY (`Character_Index`, `Character_Stats`, `Character_Transform`),
  INDEX `fk_Characters_Sect_idx` (`Character_Sect` ASC) ,
  INDEX `fk_Characters_Trade_idx` (`Character_Trade` ASC) ,
  INDEX `fk_Characters_Stats_idx` (`Character_Stats` ASC) ,
  INDEX `fk_Characters_Transform_idx` (`Character_Transform` ASC) ,
  CONSTRAINT `fk_Characters_Sect`
    FOREIGN KEY (`Character_Sect`)
    REFERENCES `schema_test`.`Sects` (`Sect_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters_Trade`
    FOREIGN KEY (`Character_Trade`)
    REFERENCES `schema_test`.`Trades` (`Trade_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters_Stats`
    FOREIGN KEY (`Character_Stats`)
    REFERENCES `schema_test`.`Stats` (`Stat_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters_Transform`
    FOREIGN KEY (`Character_Transform`)
    REFERENCES `schema_test`.`Transforms` (`Transform_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Communities`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Communities` (
  `Community_Index` INT NOT NULL AUTO_INCREMENT,
  `Community_Transform` INT NOT NULL,
  `Community_Name` VARCHAR(64) NOT NULL,
  `Community_Predominant_Sect` INT NOT NULL,
  PRIMARY KEY (`Community_Index`, `Community_Transform`),
  INDEX `fk_Communities_Predominant_Sect1_idx` (`Community_Predominant_Sect` ASC) ,
  INDEX `fk_Communities_Transform_idx` (`Community_Transform` ASC) ,
  CONSTRAINT `fk_Communities_Predominant_Sect1`
    FOREIGN KEY (`Community_Predominant_Sect`)
    REFERENCES `schema_test`.`Sects` (`Sect_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Communities_Transform`
    FOREIGN KEY (`Community_Transform`)
    REFERENCES `schema_test`.`Transforms` (`Transform_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Professions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Professions` (
  `Profession_Index` INT NOT NULL AUTO_INCREMENT,
  `Professions_Trade` INT NOT NULL,
  `Profession_Name` VARCHAR(64) NOT NULL,
  `Profession_Proficiency` FLOAT NOT NULL,
  PRIMARY KEY (`Profession_Index`, `Professions_Trade`),
  INDEX `fk_Professions_Trade_idx` (`Professions_Trade` ASC) ,
  CONSTRAINT `fk_Professions_Trade`
    FOREIGN KEY (`Professions_Trade`)
    REFERENCES `schema_test`.`Trades` (`Trade_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Building_Classifications`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Building_Classifications` (
  `Building_Classifications_Index` INT NOT NULL,
  `Building_Classifications_Name` VARCHAR(64) NOT NULL,
  PRIMARY KEY (`Building_Classifications_Index`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Buildings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Buildings` (
  `Building_Index` INT NOT NULL AUTO_INCREMENT,
  `Building_Owner` INT NOT NULL,
  `Building_Classification` INT NOT NULL,
  `Building_Transform` INT NOT NULL,
  `Buildings_Trade` INT NULL,
  PRIMARY KEY (`Building_Index`, `Building_Owner`, `Building_Classification`, `Building_Transform`),
  INDEX `fk_Buildings_Trade_idx` (`Buildings_Trade` ASC) ,
  INDEX `fk_Buildings_Owner_idx` (`Building_Owner` ASC) ,
  INDEX `fk_Buildings_Building_Classification_idx` (`Building_Classification` ASC) ,
  INDEX `fk_Buildings_Transform_idx` (`Building_Transform` ASC) ,
  CONSTRAINT `fk_Buildings_Trade`
    FOREIGN KEY (`Buildings_Trade`)
    REFERENCES `schema_test`.`Trades` (`Trade_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Buildings_Owner`
    FOREIGN KEY (`Building_Owner`)
    REFERENCES `schema_test`.`Characters` (`Character_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Buildings_Building_Classification`
    FOREIGN KEY (`Building_Classification`)
    REFERENCES `schema_test`.`Building_Classifications` (`Building_Classifications_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Buildings_Position`
    FOREIGN KEY (`Building_Transform`)
    REFERENCES `schema_test`.`Transforms` (`Transform_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Trades-Professions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Trades-Professions` (
  `Trades_Trade_Index` INT NOT NULL,
  `Professions_Profession_Index` INT NOT NULL,
  `Professions_Professions_Trade` INT NOT NULL,
  PRIMARY KEY (`Trades_Trade_Index`, `Professions_Profession_Index`, `Professions_Professions_Trade`),
  INDEX `fk_Trades-Professions_Professions1_idx` (`Professions_Profession_Index` ASC, `Professions_Professions_Trade` ASC) ,
  INDEX `fk_Trades-Professions_Trades1_idx` (`Trades_Trade_Index` ASC) ,
  CONSTRAINT `fk_Trades-Professions_Trades1`
    FOREIGN KEY (`Trades_Trade_Index`)
    REFERENCES `schema_test`.`Trades` (`Trade_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Trades-Professions_Professions1`
    FOREIGN KEY (`Professions_Profession_Index` , `Professions_Professions_Trade`)
    REFERENCES `schema_test`.`Professions` (`Profession_Index` , `Professions_Trade`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Characters-Buildings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Characters-Buildings` (
  `Characters_Character_Index` INT NOT NULL,
  `Characters_Character_Stats` INT NOT NULL,
  `Characters_Character_Transform` INT NOT NULL,
  `Buildings_Building_Index` INT NOT NULL,
  `Buildings_Building_Owner` INT NOT NULL,
  `Buildings_Building_Classification` INT NOT NULL,
  `Buildings_Building_Transform` INT NOT NULL,
  PRIMARY KEY (`Characters_Character_Index`, `Characters_Character_Stats`, `Characters_Character_Transform`, `Buildings_Building_Index`, `Buildings_Building_Owner`, `Buildings_Building_Classification`, `Buildings_Building_Transform`),
  INDEX `fk_Characters-Buildings_Buildings1_idx` (`Buildings_Building_Index` ASC, `Buildings_Building_Owner` ASC, `Buildings_Building_Classification` ASC, `Buildings_Building_Transform` ASC) ,
  INDEX `fk_Characters-Buildings_Characters1_idx` (`Characters_Character_Index` ASC, `Characters_Character_Stats` ASC, `Characters_Character_Transform` ASC) ,
  CONSTRAINT `fk_Characters-Buildings_Characters1`
    FOREIGN KEY (`Characters_Character_Index` , `Characters_Character_Stats` , `Characters_Character_Transform`)
    REFERENCES `schema_test`.`Characters` (`Character_Index` , `Character_Stats` , `Character_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters-Buildings_Buildings1`
    FOREIGN KEY (`Buildings_Building_Index` , `Buildings_Building_Owner` , `Buildings_Building_Classification` , `Buildings_Building_Transform`)
    REFERENCES `schema_test`.`Buildings` (`Building_Index` , `Building_Owner` , `Building_Classification` , `Building_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Characters-Professions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Characters-Professions` (
  `Characters_Character_Index` INT NOT NULL,
  `Characters_Character_Stats` INT NOT NULL,
  `Characters_Character_Transform` INT NOT NULL,
  `Professions_Profession_Index` INT NOT NULL,
  `Professions_Professions_Trade` INT NOT NULL,
  PRIMARY KEY (`Characters_Character_Index`, `Characters_Character_Stats`, `Characters_Character_Transform`, `Professions_Profession_Index`, `Professions_Professions_Trade`),
  INDEX `fk_Characters-Professions_Professions1_idx` (`Professions_Profession_Index` ASC, `Professions_Professions_Trade` ASC) ,
  INDEX `fk_Characters-Professions_Characters1_idx` (`Characters_Character_Index` ASC, `Characters_Character_Stats` ASC, `Characters_Character_Transform` ASC) ,
  CONSTRAINT `fk_Characters-Professions_Characters1`
    FOREIGN KEY (`Characters_Character_Index` , `Characters_Character_Stats` , `Characters_Character_Transform`)
    REFERENCES `schema_test`.`Characters` (`Character_Index` , `Character_Stats` , `Character_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters-Professions_Professions1`
    FOREIGN KEY (`Professions_Profession_Index` , `Professions_Professions_Trade`)
    REFERENCES `schema_test`.`Professions` (`Profession_Index` , `Professions_Trade`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Characters-Communities`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Characters-Communities` (
  `Characters_Character_Index` INT NOT NULL,
  `Characters_Character_Stats` INT NOT NULL,
  `Characters_Character_Transform` INT NOT NULL,
  `Communities_Community_Index` INT NOT NULL,
  `Communities_Community_Transform` INT NOT NULL,
  PRIMARY KEY (`Characters_Character_Index`, `Characters_Character_Stats`, `Characters_Character_Transform`, `Communities_Community_Index`, `Communities_Community_Transform`),
  INDEX `fk_Characters-Communities_Communities1_idx` (`Communities_Community_Index` ASC, `Communities_Community_Transform` ASC) ,
  INDEX `fk_Characters-Communities_Characters1_idx` (`Characters_Character_Index` ASC, `Characters_Character_Stats` ASC, `Characters_Character_Transform` ASC) ,
  CONSTRAINT `fk_Characters-Communities_Characters1`
    FOREIGN KEY (`Characters_Character_Index` , `Characters_Character_Stats` , `Characters_Character_Transform`)
    REFERENCES `schema_test`.`Characters` (`Character_Index` , `Character_Stats` , `Character_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Characters-Communities_Communities1`
    FOREIGN KEY (`Communities_Community_Index` , `Communities_Community_Transform`)
    REFERENCES `schema_test`.`Communities` (`Community_Index` , `Community_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Users-Characters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Users-Characters` (
  `Users_User_Index` INT NOT NULL,
  `Characters_Character_Index` INT NOT NULL,
  `Characters_Character_Stats` INT NOT NULL,
  `Characters_Character_Transform` INT NOT NULL,
  PRIMARY KEY (`Users_User_Index`, `Characters_Character_Index`, `Characters_Character_Stats`, `Characters_Character_Transform`),
  INDEX `fk_Users-Characters_Characters1_idx` (`Characters_Character_Index` ASC, `Characters_Character_Stats` ASC, `Characters_Character_Transform` ASC) ,
  INDEX `fk_Users-Characters_Users1_idx` (`Users_User_Index` ASC) ,
  CONSTRAINT `fk_Users-Characters_Users1`
    FOREIGN KEY (`Users_User_Index`)
    REFERENCES `schema_test`.`Users` (`User_Index`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Users-Characters_Characters1`
    FOREIGN KEY (`Characters_Character_Index` , `Characters_Character_Stats` , `Characters_Character_Transform`)
    REFERENCES `schema_test`.`Characters` (`Character_Index` , `Character_Stats` , `Character_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Communities-Buildings`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Communities-Buildings` (
  `Communities_Community_Index` INT NOT NULL,
  `Communities_Community_Transform` INT NOT NULL,
  `Buildings_Building_Index` INT NOT NULL,
  `Buildings_Building_Owner` INT NOT NULL,
  `Buildings_Building_Classification` INT NOT NULL,
  `Buildings_Building_Transform` INT NOT NULL,
  PRIMARY KEY (`Communities_Community_Index`, `Communities_Community_Transform`, `Buildings_Building_Index`, `Buildings_Building_Owner`, `Buildings_Building_Classification`, `Buildings_Building_Transform`),
  INDEX `fk_Communities-Buildings_Buildings1_idx` (`Buildings_Building_Index` ASC, `Buildings_Building_Owner` ASC, `Buildings_Building_Classification` ASC, `Buildings_Building_Transform` ASC) ,
  INDEX `fk_Communities-Buildings_Communities1_idx` (`Communities_Community_Index` ASC, `Communities_Community_Transform` ASC) ,
  CONSTRAINT `fk_Communities-Buildings_Communities1`
    FOREIGN KEY (`Communities_Community_Index` , `Communities_Community_Transform`)
    REFERENCES `schema_test`.`Communities` (`Community_Index` , `Community_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Communities-Buildings_Buildings1`
    FOREIGN KEY (`Buildings_Building_Index` , `Buildings_Building_Owner` , `Buildings_Building_Classification` , `Buildings_Building_Transform`)
    REFERENCES `schema_test`.`Buildings` (`Building_Index` , `Building_Owner` , `Building_Classification` , `Building_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `schema_test`.`Communities-Available-Professions`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `schema_test`.`Communities-Available-Professions` (
  `Communities_Community_Index` INT NOT NULL,
  `Communities_Community_Transform` INT NOT NULL,
  `Professions_Profession_Index` INT NOT NULL,
  `Professions_Professions_Trade` INT NOT NULL,
  PRIMARY KEY (`Communities_Community_Index`, `Communities_Community_Transform`, `Professions_Profession_Index`, `Professions_Professions_Trade`),
  INDEX `fk_Communities-Professions_Professions1_idx` (`Professions_Profession_Index` ASC, `Professions_Professions_Trade` ASC) ,
  INDEX `fk_Communities-Professions_Communities1_idx` (`Communities_Community_Index` ASC, `Communities_Community_Transform` ASC) ,
  CONSTRAINT `fk_Communities-Professions_Communities1`
    FOREIGN KEY (`Communities_Community_Index` , `Communities_Community_Transform`)
    REFERENCES `schema_test`.`Communities` (`Community_Index` , `Community_Transform`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `fk_Communities-Professions_Professions1`
    FOREIGN KEY (`Professions_Profession_Index` , `Professions_Professions_Trade`)
    REFERENCES `schema_test`.`Professions` (`Profession_Index` , `Professions_Trade`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;

USE `schema_test` ;

-- -----------------------------------------------------
-- procedure Login
-- -----------------------------------------------------

DELIMITER $$
USE `schema_test`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Login`(IN `inUsername` VARCHAR(64), IN `inPassword` VARCHAR(64))
    READS SQL DATA
BEGIN
    IF NOT EXISTS (SELECT * FROM users WHERE User_Username=inUsername AND User_Password=inPassword) THEN
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Login Failed';
    END IF;
END$$

DELIMITER ;

-- -----------------------------------------------------
-- procedure Register
-- -----------------------------------------------------

DELIMITER $$
USE `schema_test`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `Register`(IN inName VARCHAR(64), IN inUsername VARCHAR(64), IN inEmail VARCHAR(255), IN inPassword VARCHAR(64))
BEGIN
    IF NOT EXISTS (SELECT User_Username FROM users WHERE User_Username=inUsername) THEN
        INSERT INTO users (User_Name, User_Username, User_Email, User_Password) VALUES (inName, inUsername, inEmail, inPassword);
    ELSE
        SIGNAL SQLSTATE '45000'
        SET MESSAGE_TEXT = 'Username is Already Taken';
    END IF;
END$$

DELIMITER ;

GRANT ALL ON `schema_test`.* TO 'account_test';
GRANT SELECT ON TABLE `schema_test`.* TO 'account_test';
GRANT SELECT, INSERT, TRIGGER ON TABLE `schema_test`.* TO 'account_test';
GRANT SELECT, INSERT, TRIGGER, UPDATE, DELETE ON TABLE `schema_test`.* TO 'account_test';
GRANT ALTER ROUTINE, EXECUTE ON PROCEDURE `schema_test`.`Login` TO 'account_test'@'%' WITH GRANT OPTION;
GRANT ALL ON `schema_test`.* TO 'root';
GRANT SELECT ON TABLE `schema_test`.* TO 'root';
GRANT SELECT, INSERT, TRIGGER ON TABLE `schema_test`.* TO 'root';
GRANT SELECT, INSERT, TRIGGER, UPDATE, DELETE ON TABLE `schema_test`.* TO 'root';
GRANT ALTER ROUTINE, EXECUTE ON PROCEDURE `schema_test`.`Login` TO 'root'@'%' WITH GRANT OPTION;

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;