<dependency>
 <groupId>org.flywaydb</groupId>
 <artifactId>flyway-core</artifactId>
</dependency>
<dependency>
 <groupId>mysql</groupId>
 <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
 <groupId>org.springframework.boot</groupId>
 <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

#腳本命名規(guī)則 V<VERSION>__<NAME>.sql，P<VERSION>__<NAME>.sql。V代表只執(zhí)行一次，P代表可以執(zhí)行多次
#VERSION代表數(shù)據(jù)庫腳本版本，NAME代表數(shù)據(jù)名稱。

#這里使用V1_test.sql，腳本內(nèi)容如下所示。

DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
 `id` int(11) NOT NULL,
 `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

INSERT INTO `role` VALUES (1, '1');

#指定數(shù)據(jù)庫腳本為UTF-8, flyway的配置有很多，有興趣的小伙伴可以去看下
spring.flyway.encoding=utf-8

#如果原來的數(shù)據(jù)庫不為空，則需要設(shè)置
spring.flyway.baseline-on-migrate=true

#設(shè)置數(shù)據(jù)庫起始版本為0，默認(rèn)為1。如果你寫的sql腳本version小于等于起始版本則不會執(zhí)行。
spring.flyway.baseline-version=0

#數(shù)據(jù)源配置
spring.datasource.url=jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456

#spring-boot-dependencies 導(dǎo)入了flyway，mysql依賴。
#spring-boot-autoconfigure 中導(dǎo)入了FlywayAutoConfiguration自動配置類