Creating a table in MySQL using IntelliJ IDEA - why is the wrong query being generated?

Question

MySQL

I watch a video lesson (link with timecode: https://youtu.be/DclLJt8zDWk?t=2285). A person makes a table in MySQL through IntelliJ IDEA, he generates an SQL script:

I repeat after him thoroughly, add the same fields, but I generate a different script:

1. What is the problem? Why is different code generated?
2. In addition, this SQL script does not want to be executed. Why does IntelliJ generate code that is not executable?
3. Why is everything in lowercase?

Answer 1

Why such a code is created I will not say, but I can say why it does not work. First, an index is created on the field, then it tries to create a primary key on the same field. Remove the index creation and try the script again.

Answer 2

Finger to the sky
1. You already have a table and you are trying to re-create it
2. Because it is very difficult to make a full proof
3. Read the manuals for your DBMS - there is an answer why