Syncing changes

Now that we have a base schema file from our previous recipe, let's do a few changes in our database and schema file and apply those changes.

Getting ready

Set up the profiles table and Profile model, as described in the previous recipe. Then generate a starting migration using the schema console:

$ Console/cake schema generate

You can check whether the schema was generated correctly using the following command:

$ Console/cake schema view

How to do it...

Perform the following steps:

1. Let's make some changes to our profiles table. Change the length of the title column to 100 characters, and add a new column to store the published date of our profiles with the following SQL statement:

   ALTER TABLE profiles CHANGE COLUMN title title VARCHAR(100) NOT NULL, ADD COLUMN date_published DATETIME NULL AFTER modified;

2. We'll update our schema file with those changes as follows:

   $ Console/cake schema generate
   Welcome to CakePHP v2.5.2 Console
   -------------------------------------------------...