public function up() { $table = Vote::tableName(); $this->createTable($table, ['answer_id' => $this->integer(), 'user_id' => $this->integer(), 'created_at' => $this->integer()]); MigrationHelper::addForeignKey($table, 'answer_id', Answer::tableName(), 'id', 'CASCADE', 'CASCADE'); MigrationHelper::addForeignKey($table, 'user_id', User::tableName(), 'id', 'SET NULL', 'CASCADE'); }
/** * @return \yii\db\ActiveQuery */ public function getAnswer() { return $this->hasOne(Answer::className(), ['id' => 'answer_id'])->from(['answer' => Answer::tableName()]); }
public function down() { $this->dropTable(Answer::tableName()); }