I am proud to announce the immediate availability of Cake DB Migrations V2.0.
This new version has been rewritten with portability in mind and now supports a list of database engines as long as your arm. The new features and changes are as follows:
- Now supports mutiple database engines with the help of Pear's MDB2
- Simplified YAML migration files
- Fully supports adding/dropping and altering fields
- Supports the following field types: text, integer, blob, boolean, float, date, time, timestamp(datetime)
- Ability to create primary key and unique indexes on new and existing fields
- Script moved to the main Cake Vendors directory, so no need to touch your Cake core
- Supports multiple Cake applications in the same way as Bake.php does
- Works out of the box
What is Cake DB Migrations
Cake DB Migrations is a port of the very useful Ruby on Rails Migrations functionaility. Cake Migrations allow you to use Cake to define changes to your database schema, making it possible to use a version control system to keep things synchronised with the actual code.
This has many uses, including: