sAEEHmz8

1CREATE TABLE IF NOT EXISTS Users
2(
3    ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
4    username varchar(10) NOT NULL,
5    pass varchar(12) NOT NULL,
6    mail varchar(35) NOT NULL,
7    profile_id int NOT NULL 
8);
9
10CREATE TABLE IF NOT EXISTS Profiles
11(
12    ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
13    nick varchar(10) NOT NULL,
14    id_game int NOT NULL
15);
16
17CREATE TABLE IF NOT EXISTS Game
18(
19    ID int NOT NULL PRIMARY KEY AUTO_INCREMENT,
20    id_res int NOT NULL,
21    id_army int NOT NULL,
22    id_guild int NOT NULL,
23    id_build int NOT NULL
24);