Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 26 |
Version20151110174227 | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
42 | |
0.00% |
0 / 26 |
up | |
0.00% |
0 / 1 |
30 | |
0.00% |
0 / 24 |
|||
down | |
0.00% |
0 / 1 |
2 | |
0.00% |
0 / 2 |
<?php | |
namespace DoctrineMigrations; | |
use Doctrine\DBAL\Migrations\AbstractMigration; | |
use Doctrine\DBAL\Schema\Schema; | |
/** | |
* Auto-generated Migration: Please modify to your needs! | |
*/ | |
class Version20151110174227 extends AbstractMigration | |
{ | |
const DTB_MAIL_HISTORY = 'dtb_mail_history'; | |
const DTB_MEMBER = 'dtb_member'; | |
/** | |
* @param Schema $schema | |
*/ | |
public function up(Schema $schema) | |
{ | |
// this up() migration is auto-generated, please modify it to your needs | |
// dtb_category | |
$t_dtb_mail_history = $schema->getTable(self::DTB_MAIL_HISTORY); | |
$keyName = ''; | |
if($t_dtb_mail_history->hasColumn('creator_id')){ | |
$keys = $t_dtb_mail_history->getForeignKeys(); | |
foreach ($keys as $key) { | |
$column = $key->getColumns(); | |
if ($column[0] == 'creator_id') { | |
$keyName = $key->getName(); | |
break; | |
} | |
} | |
} | |
if (!empty($keyName)) { | |
$t_dtb_mail_history->removeForeignKey($keyName); | |
} | |
$t_dtb_mail_history->changeColumn('creator_id', array('NotNull' => false)); | |
$targetTable = $schema->getTable(self::DTB_MEMBER); | |
$t_dtb_mail_history->addForeignKeyConstraint( | |
$targetTable, | |
array('creator_id'), | |
array('member_id') | |
); | |
} | |
/** | |
* @param Schema $schema | |
*/ | |
public function down(Schema $schema) | |
{ | |
// this up() migration is auto-generated, please modify it to your needs | |
// dtb_category | |
} | |
} |