I'm currently using MySQL Query Browser to create my database but I seem to be having trouble creating the foreign keys.
The auto-generated code is created below but it throws up an error when executed:
SQL Query
ALTER TABLE projectdatabase.notifications ADD FOREIGN KEY Person_ID (Person_ID)
REFERENCES persons (Person_ID)
ON DELETE CASCADE
ON UPDATE CASCADE;
