you'll get several errors if you actually run those statements in mysql

in the first one, IDENTITY is invalid for mysql

in the second one, ORDER is a reserved word, so you cannot name your table this without escaping it with backticks, and the foreign key declaration won't work because you forgot to include the StoreID column in the table, and you also didn't say which table it references

you'll get several errors if you actually run those statements in mysql

in the first one, IDENTITY is invalid for mysql

in the second one, ORDER is a reserved word, so you cannot name your table this without escaping it with backticks, and the foreign key declaration won't work because you forgot to include the StoreID column in the table, and you also didn't say which table it references

Thankyou, sorry i did notice that stupid slip up for the table referencing. I'm not sure what you mean by the IDENTITY being invalid. I hate to bother you further but is there an easy explanation for that?