Spring Boot 2 Flyway集成

快速入门

pom.xml添加flyway依赖

<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-core</artifactId>
    <version>7.15.0</version>
</dependency>

application.yml添加配置

spring:
  flyway:
    enabled: true  #激活flyway

resources资源目录下添加sql脚本db/migration/mysql/V1.0__baseline.sql

SET NAMES utf8mb4;
SET
FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for api_info
-- ----------------------------
DROP TABLE IF EXISTS `api_info`;
CREATE TABLE `api_info`
(
    `api_id`                  varchar(64) NOT NULL COMMENT 'API ID',
    `api_code`                varchar(64) NULL DEFAULT NULL COMMENT '接口编码',
    PRIMARY KEY (`api_id`) USING BTREE
) COMMENT = '接口信息';

FAQ

Caused by: org.flywaydb.core.api.FlywayException: Unsupported Database: MySQL 5.7

flyway 8+不支持MySQL 5.7，需要降级flyway-core版本到7.15.0。