Can't create table (errno: 150) InnoDB adding foreign key constraints?

You need an index on category_id in the shop table (I see it's part of the primary key, but since it's the second column in the index, it can not be used). The field you are referencing in a foreign key always should be indexed.

Thanks! This solved the problem! – Eugene Aug 25 at 23:00 If this solved the problem then mark the answer as accepted!

– Veseliq Aug 26 at 8:21 Sorry, how do I do that? – Eugene Aug 27 at 15:17 @Eugene read FAQ - how do I ask – Darhazer Aug 28 at 13:01 @Darhazer Your answer was really helpful and I tried to mark your answer as useful but it says I don't have enough reputation. – Eugene Aug 29 at 2:12.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.