Estava criando o banco de dados através do proprio intelij e me deparei com esse erro:
Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation
Detected failed migration to version 1 (criar tabela medico).
Please remove any half-completed changes then run repair to fix the schema history.
Need more flexibility with validation rules? Learn more: https://rd.gt/3AbJUZE
2023-09-04T09:38:20.974-03:00 INFO 90365 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2023-09-04T09:38:21.014-03:00 INFO 90365 --- [ restartedMain] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2023-09-04T09:38:21.020-03:00 INFO 90365 --- [ restartedMain] o.apache.catalina.core.StandardService : Stopping service [Tomcat]
2023-09-04T09:38:21.045-03:00 INFO 90365 --- [ restartedMain] .s.b.a.l.ConditionEvaluationReportLogger :
Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
2023-09-04T09:38:21.069-03:00 ERROR 90365 --- [ restartedMain] o.s.boot.SpringApplication : Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Validate failed: Migrations have failed validation
Detected failed migration to version 1 (criar tabela medico).
Please remove any half-completed changes then run repair to fix the schema history.
e esse eh meu código:
create table medicos(
id bigint not null auto_increment,
nome varchar(100) not null,
email varchar(100) not null unique,
crm varchar(6) not null unique,
especialidade varchar(100) not null,
logradouro varchar(100) not null,
bairro varchar(100) not null,
cep varchar(9) not null,
complemento varchar(100),
numero varchar(20),
uf char(2) not null,
cidade varchar(100) not null,
primary key(id))
alguem consegue dar um help?
