CREATE TABLE usuarios (
id BIGINT NOT NULL AUTO_INCREMENT,
login VARCHAR(100) NOT NULL,
contrasena VARCHAR(255) NOT NULL
PRIMARY KEY(id)
);
Me arrojo error:
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/flyway/autoconfigure/FlywayAutoConfiguration$FlywayConfiguration.class]: Failed to execute script V6__create_table_usuarios.sql
------------------------------------------------------
SQL State : 42000
Error Code : 1064
Message : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(id)
)' at line 5
Location : db/migration/V6__create_table_usuarios.sql (C:\Users\Usuario\OneDrive\Desktop\curso_alura\alura-25\api2\target\classes\db\migration\V6__create_table_usuarios.sql)
Line : 1
Statement : Run Flyway with -X option to see the actual statement causing the problem
Lo pude solucionar borrando la version 6 en flyway y cambiandola por:
CREATE TABLE usuarios (
id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
login VARCHAR(100) NOT NULL,
contrasena VARCHAR(255) NOT NULL
);
