yii - Create a column with primary key using migrations -
i using migrations in yii create new column with. code works fine however, unsure how set primary key?
this part migration file:
public function up() { $this->addcolumn( 'competition_prizes', 'prize_id', 'int(11) unsigned not null first', ); $this->addprimarykey('pk1', 'competition_prizes', 'prize_id'); } i don't know, how make competition_prizes column primary key.
after addcolumn function add line
$this->addprimarykey('pk1', 'competition_prizes', 'prize_id') make sure there no primary key column in table.
Comments
Post a Comment