Book Image

CakePHP 2 Application Cookbook

By : James Watts, Cake Software Foundation, Inc.
Book Image

CakePHP 2 Application Cookbook

By: James Watts, Cake Software Foundation, Inc.

Overview of this book

Table of Contents (20 chapters)
CakePHP 2 Application Cookbook
Credits
Foreword
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

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
    -------------------------------------------------...