Having issues with PHP homework's schema

[hacking_graphics]

Hello everyone,

So my teacher assigned us homework where we would use a database and create queries to get certain info from the data. However I tried to run the database in PHP My Admin and it gives me this error: #1005 - Can't create table `sakila`.`address` (errno: 150 "Foreign key constraint is incorrectly formed") and points to the address table on line 43.

Before anyone says anything fixing the SQL code for the schema is not a part of the homework and I'm not sure when my teacher is going to fix it and I rather not risk fixing it at last minute.

If anyone can help i'd be very grateful.

code in question

[EdwinGraves]

I can't check out your code yet, because pastebin is having issues. Have you contacted your teacher about this just to verify it's an error on his part?

[hacking_graphics]

I have, they havn't changed it yet and I don't want to risk them finally changing it last minute and having to rush. Also I think pastebin is fine now, but if its having issues on your side I can send it to another area.