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 | |
| } | |
| } |