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