MySQL ERROR 1215（HY000）：无法添加外键约束

I have looked everywhere about this error and seen plenty of examples and still i cant figure out whats wrong with my script. Im sorry if this is a common issue but searching about it hasnt helped me so far. Here goes the script:I have looked everywhere about this error and s