Version Numbers

When Generating Migrations the newly created classes are generated with the name Version{date} with {date} having a YmdHis format. This format is important as it allows the migrations to be correctly ordered.

Starting with version 1.5 when loading migration classes, Doctrine does a sort($versions, SORT_STRING) on version numbers. This can cause problems with custom version numbers:

1<?php $versions = [ 'Version1', 'Version2', // ... 'Version10', ]; sort($versions, SORT_STRING); var_dump($versions); /* array(3) { [0] => string(8) "Version1" [1] => string(9) "Version10" [2] => string(8) "Version2" } */
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23

The custom version numbers above end up out of order which may cause damage to a database.

It is strongly recommended that the Version{date} migration class name format is used and that the various tools for generating migrations are used.

Should some custom migration numbers be necessary, keeping the version number the same length as the date format (14 total characters) and padding it to the left with zeros should work.

1<?php $versions = [ 'Version00000000000001', 'Version00000000000002', // ... 'Version00000000000010', 'Version20180107070000', // generated version ]; sort($versions, SORT_STRING); var_dump($versions); /* array(4) { [0] => string(21) "Version00000000000001" [1] => string(21) "Version00000000000002" [2] => string(21) "Version00000000000010" [3] => string(21) "Version20180107070000" } */
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

Please note that migrating to this new, zero-padded format may require manual version table intervention if the versions have previously been applied.

Next Chapter: Integrations