Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: Migration V3__crate_table_topico.sql failed
SQL State : HY004
Error Code : 50004
Message : Unknown data type: "BIGNIT"; SQL statement:
create table topico(
id bigint not null auto_increment,
titulo varchar(50) not null,
mensagem varchar(200) not null ,
data_criacao datetime not null ,
status varchar(50) not null ,
curso_id bigint not null,
autor_id bignit not null,
primary key(id),
foreign key(curso_id) references curso(id),
foreign key(autor_id) references usuario(id)
) [50004-200]
Location : db/migration/V3__crate_table_topico.sql (/home/marianavieira/kotlinStudy/project_alura/Alura/target/classes/db/migration/V3__crate_table_topico.sql)
Line : 1
Statement : create table topico(
id bigint not null auto_increment,
titulo varchar(50) not null,
mensagem varchar(200) not null ,
data_criacao datetime not null ,
status varchar(50) not null ,
curso_id bigint not null,
autor_id bignit not null,
primary key(id),
foreign key(curso_id) references curso(id),
foreign key(autor_id) references usuario(id)
)
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:275) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:222) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:126) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:69) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.lambda$execute$0(SqlMigrationExecutor.java:58) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:27) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:57) ~[flyway-core-8.0.5.jar:na]
at org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:374) ~[flyway-core-8.0.5.jar:na]
... 42 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: Unknown data type: "BIGNIT"; SQL statement:
create table topico(
id bigint not null auto_increment,
titulo varchar(50) not null,
mensagem varchar(200) not null ,
data_criacao datetime not null ,
status varchar(50) not null ,
curso_id bigint not null,
autor_id bignit not null,
primary key(id),
foreign key(curso_id) references curso(id),
foreign key(autor_id) references usuario(id)
) [50004-200]
