CwYhvPzY

1Error 1215: Cannot add foreign key constraints
2	
3CREATE TABLE IF NOT EXISTS ProfilePublicData
4(
5    idProfile INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
6    login VARCHAR(64),
7    name VARCHAR(45),
8    lastName VARCHAR(45),
9    location VARCHAR(45),
10    age TINYINT,
11    photo VARCHAR(45),
12    PRIMARY KEY(idProfile)
13);
14
15CREATE TABLE IF NOT EXISTS ProfilePrivateData
16(
17    idProfile INT(11) UNSIGNED NOT NULL,
18    CONSTRAINT fkIdProfile 
19            FOREIGN KEY(idProfile) 
20            REFERENCES `ProfilePublicData`(idProfile)
21                ON DELETE CASCADE 
22                ON UPDATE CASCADE, 
23    email VARCHAR(45),
24    password VARCHAR(45),
25    PRIMARY KEY(idProfile)
26);
27CREATE  TABLE IF NOT EXISTS Authorizations
28(
29    idAuthorization INT(11) UNSIGNED NOT NULL PRIMARY KEY,
30    email VARCHAR(45) NOT NULL,
31    CONSTRAINT fkPrivateDataProfile
32            FOREIGN KEY(email) 
33            REFERENCES `ProfilePrivateData`(email)            
34                ON DELETE CASCADE 
35                ON UPDATE CASCADE, 
36     systemStatus ENUM ('ONLINE','OFFLINE','DELETED'),
37    `dateTimeStart` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
38    `dateTimeRequest` DATETIME
39);