CreateBSDLE.sql

CREATE SCHEMA IF NOT EXISTS BSDLE;
USE BSDLE;

CREATE TABLE IF NOT EXISTS BRAWLER(
	id INT NOT NULL AUTO_INCREMENT,
    nome VARCHAR(32) NOT NULL UNIQUE,
    genero ENUM('F','M','U','N'),
    raridade ENUM('rare','super rare','epic','mythic','legendary','ultra legendary'),
    regiao  ENUM('starr plaza', 'wild frontier', 'haunted haven',
				 'tomorrowland', 'fairytale kingdom', 'retropolis',
                 'mystic mountain', 'starr gardens', 'water world', 'brawlywood', 'unspecified'),
	tipo ENUM('assasin', 'support', 'controller',
			  'artillery', 'marksman', 'tank', 
              'damage dealer', 'unknown'),
	ano INT,
	PRIMARY KEY (id) 
    );
    
CREATE TABLE IF NOT EXISTS BRAWLER_EMOJIS(
	id INT NOT NULL AUTO_INCREMENT,
	brawlerId INT NOT NULL,
    emoji VARCHAR(10),
    PRIMARY KEY(id),
    FOREIGN KEY (brawlerId) REFERENCES BRAWLER(id) 
);