Hello!
I'm trying to create an innoDB table with a CHECK constraint:

CREATE TABLE Advises (
advisorSIN INT NOT NULL,
adviseeSIN INT NOT NULL,
PRIMARY KEY (advisorSIN, adviseeSIN),
UNIQUE (adviseeSIN),
FOREIGN KEY (advisorSIN) REFERENCES Employee (SIN) ON DELETE CASCADE,
FOREIGN KEY (adviseeSIN) REFERENCES Employee (SIN) ON DELETE CASCADE,
CHECK ((SELECT A.advisorSIN FROM Advises A WHERE A.adviseeSIN = advisorSIN) <> adviseeSIN) ) TYPE = InnoDB;

But I can't seem to make one. The same table without CHECK works. Any suggestions? Thanks!

Because check are not allowed yet in mysql