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');
 }
示例#2
0
文件: Vote.php 项目: bariew/sitown
 /**
  * @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());
 }