Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
CRAP | |
0.00% |
0 / 38 |
Version20150716110827 | |
0.00% |
0 / 1 |
|
0.00% |
0 / 2 |
20 | |
0.00% |
0 / 38 |
up | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 32 |
|||
down | |
0.00% |
0 / 1 |
6 | |
0.00% |
0 / 6 |
<?php | |
namespace DoctrineMigrations; | |
use Doctrine\DBAL\Migrations\AbstractMigration; | |
use Doctrine\DBAL\Schema\Schema; | |
/** | |
* Auto-generated Migration: Please modify to your needs! | |
*/ | |
class Version20150716110827 extends AbstractMigration | |
{ | |
const NAME = 'dtb_csv'; | |
/** | |
* @param Schema $schema | |
*/ | |
public function up(Schema $schema) | |
{ | |
// this up() migration is auto-generated, please modify it to your needs | |
if ($schema->hasTable(self::NAME)) { | |
return true; | |
} | |
$table = $schema->createTable(self::NAME); | |
$table->addColumn('csv_id', 'integer', array( | |
'autoincrement' => true, | |
)); | |
$table->addColumn('csv_type', 'smallint', array('NotNull' => true)); | |
$table->addColumn('entity_name', 'text', array('NotNull' => true)); | |
$table->addColumn('field_name', 'text', array('NotNull' => true)); | |
$table->addColumn('reference_field_name', 'text', array('NotNull' => false)); | |
$table->addColumn('disp_name', 'text', array('NotNull' => false)); | |
$table->addColumn('rank', 'smallint', array('NotNull' => true)); | |
$table->addColumn('enable_flg', 'smallint', array('NotNull' => true)); | |
$table->addColumn('creator_id', 'integer', array('NotNull' => true)); | |
$table->addColumn('create_date', 'datetime', array('NotNull' => true)); | |
$table->addColumn('update_date', 'datetime', array('NotNull' => true)); | |
$table->setPrimaryKey(array('csv_id')); | |
$targetTable = $schema->getTable('mtb_csv_type'); | |
$table->addForeignKeyConstraint( | |
$targetTable, | |
array('csv_type'), | |
array('id') | |
); | |
$targetTable = $schema->getTable('dtb_member'); | |
$table->addForeignKeyConstraint( | |
$targetTable, | |
array('creator_id'), | |
array('member_id') | |
); | |
} | |
/** | |
* @param Schema $schema | |
*/ | |
public function down(Schema $schema) | |
{ | |
// this down() migration is auto-generated, please modify it to your needs | |
if (!$schema->hasTable(self::NAME)) { | |
return true; | |
} | |
$schema->dropTable(self::NAME); | |
} | |
} |