guild/console/migrations/m230123_084629_create_project_mark_table.php

34 lines
891 B
PHP
Raw Permalink Normal View History

2023-01-23 17:50:38 +03:00
<?php
use yii\db\Migration;
/**
* Handles the creation of table `{{%project_mark}}`.
*/
class m230123_084629_create_project_mark_table extends Migration
{
/**
* {@inheritdoc}
*/
public function safeUp()
{
$this->createTable('{{%project_mark}}', [
'id' => $this->primaryKey(),
'project_id' => $this->integer(),
'mark_id' => $this->integer(),
]);
$this->addForeignKey('project_mark_project', 'project_mark', 'project_id', 'project', 'id');
$this->addForeignKey('project_mark_mark', 'project_mark', 'mark_id', 'mark', 'id');
}
/**
* {@inheritdoc}
*/
public function safeDown()
{
$this->dropForeignKey('project_mark_project', 'project_mark');
$this->dropForeignKey('project_mark_mark', 'project_mark');
$this->dropTable('{{%project_mark}}');
}
}