docker pull flyway/flyway
flyway.conf :
flyway.driver=com.mysql.jdbc.Driver
flyway.url=jdbc:mysql://172.29.64.1:6606/coba
flyway.user=root
flyway.password=telo
folder sql :
V1__buat_table_pertama.sql :
CREATE TABLE `t_coba` ( `id` int NOT NULL, `nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
V2__buat_table_kedua.sql :
CREATE TABLE `t_coba2` (
`id` int NOT NULL,
`nama` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
V3__alter_set_autinc.sql :
ALTER TABLE `t_coba` MODIFY `id` int NOT NULL auto_increment;
ALTER TABLE `t_coba2` MODIFY `id` int NOT NULL auto_increment;
docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway info
docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway validate
docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway repair
docker run --rm -v J:\\coba-docker-flyway\\sql:/flyway/sql -v J:\\coba-docker-flyway\\conf:/flyway/conf flyway/flyway migation