Your sequence of foreign key dependencies is corrupt. You need to create table c before you create table b. Dropping table a, which is referenced by ON DELETE CASCADE, implies deleting all rows of the referencing table b, which has unresolved foreign key restraints due to table c not yet existing. Always create your object (referenced) tables before creating your relation (referencing) tables.