From [[http://codingtip.blogspot.com/2013/08/mysql-column-type-Yii-migration.html]]\\

Column types array that Yii supports for MySQL
<code php>
 public $columnTypes=array(
  'pk' => 'int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY',
  'string' => 'varchar(255)',
  'text' => 'text',
  'integer' => 'int(11)',
  'float' => 'float',
  'decimal' => 'decimal',
  'datetime' => 'datetime',
  'timestamp' => 'timestamp',
  'time' => 'time',
  'date' => 'date',
  'binary' => 'blob',
  'boolean' => 'tinyint(1)',
  'money' => 'decimal(19,4)',
 );
</code>

where
  * **pk**: an auto-incremental primary key type, will be converted into "int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY"
  * **string**: string type, will be converted into "varchar(255)"
  * **text**: a long string type, will be converted into "text"
  * **integer**: integer type, will be converted into "int(11)"
  * **float**: float number type, will be converted into "float"
  * **decimal**: decimal number type, will be converted into "decimal"
  * **datetime**: datetime type, will be converted into "datetime"
  * **timestamp**: timestamp type, will be converted into "timestamp"
  * **time**: time type, will be converted into "time"
  * **date**: date type, will be converted into "date"
  * **boolean**: boolean type, will be converted into "tinyint(1)"
  * **binary**: binary data type, will be converted into "blob"
  * **money**: will be converted into decimal(19,4)

