· 6 years ago · May 04, 2019, 10:02 PM
1CREATE TABLE IF NOT EXISTS Players(
2 id INT(6) AUTO_INCREMENT PRIMARY KEY,
3 name VARCHAR(16) UNIQUE NOT NULL,
4 mail VARCHAR(56) UNIQUE NOT NULL,
5 password_hash(255) NOT NULL
6);
7CREATE TABLE IF NOT EXISTS Bans(
8 FOREIGN KEY(Id) REFERENCES Players(id),
9 date DATETIME NOT NULL
10);