James, you may have a typo in your SQL, actually in the the frst two
ALTER TABLE statements. You posted:
ALTER TABLE `cardfaces` ADD CONSTRAINT `fk_card_deck` FOREIGN KEY
(`card_id`) references card(`id`);
ALTER TABLE `cards` ADD CONSTRAINT `fk_card_deck` FOREIGN KEY
(`deck_id`) referencesdeck(`i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am curious what I am doing wrong. I am using mysql-5.0.13, on Solaris.
The error I get, on the first alter table, is:
ERROR 1005 (HY000) at line 70: Can't create table
'./FlashcardProto_production/#sql-151_f5d.frm' (errno: 150)
Any help would be ap