Create User Table

user.sql

CREATE TABLE user (
  id INT NOT NULL AUTO_INCREMENT,
  role VARCHAR(15) NOT NULL,
  name VARCHAR(70) NOT NULL,
  email VARCHAR(45) NOT NULL,
  username VARCHAR(11) NOT NULL,
  password VARCHAR(60) NOT NULL,
  phone VARCHAR(11) NULL,
  PRIMARY KEY (id))
ENGINE = InnoDB;