Column Types

CakePHP DB Migrations supports a number of column/field types. Most are self explanatory, but a few might need some explaining.

    string
    text
    integer | int
    blob
    boolean | bool
    float
    date
    time
    timestamp | datetime
    fkey | fkeys

Here is an example of how you would use these types in conjunction with other attributes:

UP:
  add_field:
    users:
      last_name:
        type: string
        length: 10
DOWN:
  drop_field:
    users: last_name

Or better still, use the shortened format:

UP:
  add_field:
    users:
      last_name: 10
DOWN:
  drop_field:
    users: last_name

Because 'string' is the default type, we don't need to specify it. But if we want 'last_name' to a integer with a limit of 5 (some people might!), do this:

UP:
  add_field:
    users:
      last_name: [int, 5]
DOWN:
  drop_field:
    users: last_name