I'm trying to create two foreign keys so that when I delete Gallery_ID 23 in the 'Galleries' table, it automatically deletes it in the 'Clicks' table but it isn't working.
Code:
CREATE TABLE `Galleries` (
`Gallery_ID` INT NOT NULL AUTO_INCREMENT ,
`Gallery_URL` VARCHAR( 255 ) NOT NULL ,
`Category` VARCHAR( 50 ) NOT NULL ,
PRIMARY KEY ( `Gallery_ID` )
);
CREATE TABLE `Trades` (
`Trade_ID` INT NOT NULL AUTO_INCREMENT ,
`Trade_Name` VARCHAR( 255 ) NOT NULL ,
`Trade_URL` VARCHAR( 255 ) NOT NULL ,
`Trade_Domain` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `Trade_ID` )
);
CREATE TABLE `Clicks` (
`Gallery_ID` INT NOT NULL ,
`Trade_ID` INT NOT NULL ,
`Clicks` INT NOT NULL ,
`Used` INT NOT NULL ,
FOREIGN KEY ( `Gallery_ID` ) REFERENCES `Galleries` ( `Gallery_ID` ) ON UPDATE CASCADE ON DELETE CASCADE ,
FOREIGN KEY ( `Trade_ID` ) REFERENCES `Trades` ( `Trade_ID` ) ON UPDATE CASCADE ON DELETE CASCADE
);