CREATE TABLE `issues` ( `branchcode` varchar(10) DEFAULT NULL COMMENT 'foreign key, linking to the branches table for the location the item was checked out', Yeah, a comment is nice. But there is still no FK !