joelmoss / cakephp-db-migrations

Database migrations shell for CakePHP. NO LONGER MAINTAINED HERE. MOVED TO http://codaset.com/joelmoss/cakephp-db-migrations

This URL has Read+Write access

cakephp-db-migrations / CHANGELOG
raw normal view history
8fa6c05b » joel@joelmoss.info 2008-02-01 Initial import 1 ==== Migrate.php Changelog (started as of v3.0) ====
2
1379a0f4 » joelmoss 2008-10-07 Added support for table pre... 3 v 4.0 - Oct 7, 2008
4 [*] errr... lots of fixes ;)
5
8f6002d9 » joelmoss 2008-05-25 Preping CHANGELOG for RC1 6 v 4.0 RC1 - May 25, 2008
a409e17d » joelmoss 2008-05-21 Fixed bug with old style ve... 7 [*] Fixed bug with old style version numbers
ccce00a6 » joelmoss 2008-05-22 Fixed bug where fkeys were ... 8 [*] Fixed bug where fkeys were trying to be created with auto_increment
db297f76 » joelmoss 2008-05-22 Can now specify whether to ... 9 [+] Can now specify whether to use Cake's UUID for the ID column within migration files. Example: "id: uuid"
10 [+] Can now pass "id: false" within migration file, and no ID column will be created.
11 [-] Deprecated "no_id: true" in favour of "id: false"
95a3c83f » joelmoss 2008-05-22 Fixed typo 12 [*] ID column is now correctly set as Primary Key when using UUID type.
6006d472 » joelmoss 2008-05-22 Added support for MySQL spe... 13 [+] Added support for MySQL specific table options (comments, engine/type, collate and charset)
a409e17d » joelmoss 2008-05-21 Fixed bug with old style ve... 14
8f6002d9 » joelmoss 2008-05-25 Preping CHANGELOG for RC1 15 v 4.0 Beta 1 - May 20, 2008
3ff270f9 » joelmoss 2008-05-20 First beta release of Migra... 16 [+] Version numbers now use timestamps so as to minimize conflicts
17 [+] Now supports interleaved migrations;
18 when migrating up, will run migrations that have not yet been run, and will ignore any non-run migrations when running down.
19 [+] Added info option (cake migrate info), which shows information on migrations
20 [+] Can now specify version number when running up/down, thus allowing you to only run the up/down block of a specific migration
21 [+] Schema table name is now customizable
22 [+] Now supports PHP arrays in migration files
23
ef8ebca4 » joel@joelmoss.info 2008-02-28 Upgrading to latest versions 24 v 3.7 - Feb 28 2008
3ff270f9 » joelmoss 2008-05-20 First beta release of Migra... 25 [*] Removed back ticks from table name when changing migration version, as they caused errors when using SQLITE.
ef8ebca4 » joel@joelmoss.info 2008-02-28 Upgrading to latest versions 26 [+] Now supports Cake's UUID columns
27
8fa6c05b » joel@joelmoss.info 2008-02-01 Initial import 28 v 3.6 - Jan 30 2008
29 [+] added the ability to generate migrations based on existing DB tables.
30 Thanks and credit go to Daniel Vecchiato (http://www.4webby.com) for his Yammy! shell.
31 [*] moved datasource definitions before DB is connected
32 [*] replaced Cake's alias up() function with PHP's strtoupper()
33 [+] added aliases for integer and boolean column types: int and bool
34 [+] added 'rename_field' action
35 [+] added 'rename_table' action
36
37 v 3.5 - Oct 23 2007
db297f76 » joelmoss 2008-05-22 Can now specify whether to ... 38 [+] new column type (fkey) added. Example:
39 type: fkey # creates column 'type_id' as integer and with an index
8fa6c05b » joel@joelmoss.info 2008-02-01 Initial import 40 [+] added sample YAML when generating
41 [+] can now generate a create_table migration file automatically by running 'cake migrate generate create table_name'
42 [+] can now create migration file for the Cake sessions table. Just run "cake migrate generate sessions".
43 [+] added 'gen' and 'g' method aliases for 'generate'
44 [*] now works with CakePHP 1.2 Pre-Beta
45
46 v 3.4 - Aug 5 2007
47 [*] fixed bug in 'all' command which was not migrating up in the correct order
48 [*] fixed and refactored 'add_columns' migration code
49 [*] fixed 'alter_column' migration code (it now works!)
50 [+] can now rename fields as part of the 'alter_column' migration instructions. Simply specify 'new_name: the_new_name_of_the_field'
51 [+] can now migrate to a specific version by simply appending the version number to the 'cake migrate' command
52 [-] deprecated '-v' switch, and 'version' and 'v' methods as ways of specifying the version
53
54 v 3.3 - Jul 29 2007
55 [*] a little cleanup and refactoring, including more detailed and friendly output
56 [*] added more comments and documentation
57 [+] migration file numbering now uses three digits starting from 001
58 [+] added new 'version' and 'v' method as an alternative to the '-v' switch
59 [+] can now generate migration files as generator shell is now deprecated.
60 [+] can now run all migrations from the current version down, up to the latest version
61 [+] can now use shortened YAML when specifying column properties
62 Examples:
63 name: [string, 32, not_null] # will create a string(varchar) column with length 32 and not null
db297f76 » joelmoss 2008-05-22 Can now specify whether to ... 64 no_dates: true # no date columns will be created
8fa6c05b » joel@joelmoss.info 2008-02-01 Initial import 65
66 v 3.2
67 [+] refactored (again!) to work with the new Cake console
68 [+] default type is now 'string', which means that a 'text(255)' column can be created without specifying the type
69 [+] can now specify 'fkey' or 'fkeys' as a column name, then passing one or more foreign key names
70 Examples:
71 fkey: user # an integer column will be created called 'user_id'
72 fkeys: [user, group] # two integer columns will be created called 'user_id' and 'group_id'
73
74 v 3.1
75 [+] can now parse and run PHP code within migration files
76 [+] added string type. any column with a type of 'string' without a length set will default to varchar(255)
77 [+] automatically detects any column name ending with '_id' as an integer
78
79 v 3.0
80 [+] refactored as a bake2 task compatible with CakePHP 1.2
81
82
83
84 ==== Fixtures.php Changelog (started as of v3.0) ====
85
ef8ebca4 » joel@joelmoss.info 2008-02-28 Upgrading to latest versions 86 v 3.5 - Feb 28 2008
87 [+] Fixtures can now be named, and referenced in foreign keys
88 [+] If 'created' column exists in model, and it is not referenced in fixture, then the current datetime will automatically be entered.
89 [+] Now supports Cake's UUID columns
8fa6c05b » joel@joelmoss.info 2008-02-01 Initial import 90 [*] Fixed instantiation of fixture helpers.
91
92 v 3.4 - Jan 30 2008
93 [+] Introduced Fixture Helpers.
94 [*] moved datasource definitions before DB is connected
95 [+] added 'g' alias for 'generate' method
96
97 v 3.3
98 [+] can now generate fixture files as generator shell is now deprecated.
99 [+] added 'f' method allowing you tin specify which fixture files you want to run
100 [*] fixed bug that interpreted '0' as NOW
101
102 v 3.2
103 [+] refactored (again!) to work wth the new Cake console
104 [+] options/variables no longer have to be passed as part of the command. You will be prompted if they are missing.
105
106 v 3.1
107
108 [+] can now parse and run PHP code within migration files
109 [+] specifying 'all' instead of the table name will run all defined fixtures
110
111 v 3.0
112 [+] refactored as a bake2 task compatible with CakePHP 1.2
113
114