There are a number of possibilities including versioning scripts; repeatable scripts; and SQL callback scripts for invoking at various points during the process. For now, we’re just looking at versioning scripts.<\/p>\n
\n
$ ls -l sql\/*.sql
-rw-rw-r-- 1 colin colin 64 Jun 12 14:35 sql\/V4__other_objects.sql
-rw-rw-r-- 1 colin colin 80 Jun 12 14:35 sql\/V5__limbs.sql
-rw-rw-r-- 1 colin colin 62 Jun 12 14:36 sql\/V6__test_table2.sql
$<\/pre>\n<\/div>\n
Note: it may be tricky to remember that the name convention requires a double-underscore (“dunder”) between the version number and the file name!<\/p>\n
Now, if we run the “info” verb:<\/p>\n
\n
Flyway 4.2.0 by Boxfuse
Database: jdbc:mysql:\/\/localhost:3306\/cookbook (MySQL 5.7)
+---------+--------------------------+---------------------+---------+
| Version | Description | Installed on | State |
+---------+--------------------------+---------------------+---------+
| 4 | other objects | | <Baseln |
| 5 | Baseline prior to Flyway | 2017-06-12 14:23:41 | Success |
| 6 | test table2 | | Pending |
+---------+--------------------------+---------------------+---------+
$<\/pre>\n<\/div>\n
Flyway detects this information from a) the script file naming convention, and b) the contents of the schema_version table in the target DB.<\/p>\n
Questions:<\/p>\n
![\"image\"](\"http:\/\/www.spacefold.com\/colin\/morethanfour\/wp-content\/uploads\/image_3.png\" "\\"image\\"")
<\/p>\n