我有一个表，它的主键用于其他几个表，并且有几个外键指向其他表。CREATETABLElocation(locationIDINTNOTNULLAUTO_INCREMENTPRIMARYKEY...)ENGINE=InnoDB;CREATETABLEassignment(assignmentIDINTNOTNULLAUTO_INCREMENTPRIMARYKEY,locationIDINTNOTNULL,FOREIGNKEYlocationIDX(locationID)REFERENCESlocation(locationID)...)ENGINE=InnoDB;CREATETABLEa
