Alter Table Yii Migrations

Yii 1.1 General Discussion
1

How we alter Table to add Unique Index?

2

like

ALTER TABLE db.table ADD UNIQUE combineIndex ( column1 , column2 )

how we write above query in YII migrations ?

3

Try this method: http://www.yiiframework.com/doc/api/1.1/CDbMigration#createIndex-detail

Also you can always execute raw sql inside migration:




$this->execute("ALTER TABLE ...");
4

Thanx Andy.