First off, Old Pendant, sorry about not recognizing you in my last post. Reviewing the thread this morning I realized you were the only one to reply..
I am still toying with the idea of this project but haven't really had the time to devote to it. Just recently rejoined the workforce.
As far as what has been discussed so far.
When I tried creating the:
CREATE TABLE codeNames (
CONSTRAINT FOREIGN KEY boardID REFERENCES allBoards(boardID)
) ENGINE INNODB;
I am not sure if it is the version of MySQL or not that is causing the hangup, but having the constraint line in the create block as you have it, it produced the error posted above.. The formatting went loopy from mySQL to here, but it was entered as you wrote it.
I did manage to pick up a couple more books covering php/mysql so hopefully I can finally grasp things better.