Example of a CakePHP Migration that changes the database schema

20101208130030_rename_inventories_added_fields.php

<?php
/**
 * @author Eric Shelley <[email protected]>
 */
class M20101208130030 extends CakeMigration
{
    /**
     * Migration description
     *
     * @var string
     * @access public
     */
    public $description = 'Rename inventories added_on and added_by fields to created standard';

    /**
     * Before migration callback
     *
     * @param string $direction, up or down direction of migration process
     * @return boolean Should process continue
     * @access public
     */
    public function before($direction)
    {
        switch ($direction) {
        case 'up':
            echo "Going up...\n";
            $Inventory = $this->generateModel('Inventory');
            $Inventory->query(<<<PGSQL
                ALTER TABLE inventories RENAME COLUMN added_by TO created_by;
                ALTER TABLE inventories RENAME COLUMN added_on TO created;
PGSQL
            );
            echo "\nCompleted successfully\n\n";
            break;
        case 'down':
            // No down b/c I'm correcting data
            break;
        }
        return true;
    }
}
?>