[RESOLVED] MySQL foreign key fail errno 121

[lukaz]

http://pastie.org/819963
hi guys,
my code is in the above pastie link, basically the create tables functions work but as soon as the alter table functions try they all fail with errno 121 cannot create table,
Any mysql guru's who know what im doing wrong?
Thanks in advance
Luke

[lukaz]

sorry seems i tried to run the alter tables query twice by accident