ZeNUAfkW

1CREATE TABLE IF NOT EXISTS profile_public_data
2(
3    idProfile INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4    login VARCHAR(64),
5    name VARCHAR(45),
6    lastName VARCHAR(45),
7    location VARCHAR(45),
8    is_active BOOLEAN DEFAULT false,
9    age TINYINT,
10    photo VARCHAR(45),
11    PRIMARY KEY(idProfile)
12);
13
14CREATE TABLE IF NOT EXISTS profile_private_data
15(
16    idProfile INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
17    CONSTRAINT fk_idProfile 
18            FOREIGN KEY(idProfile) 
19            REFERENCES `profile_public_data`(idProfile)
20                ON DELETE SET NULL 
21                ON UPDATE SET NULL,
22    email VARCHAR(45),
23    password VARCHAR(45),
24    PRIMARY KEY(idProfile)
25);