<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
final class Version202412132200000 extends AbstractMigration
{
public function up(Schema $schema): void
{
$this->addSql("
INSERT INTO dtb_csv (
csv_type_id,
entity_name,
field_name,
reference_field_name,
disp_name,
sort_no,
enabled,
create_date,
update_date,
discriminator_type
)
VALUES
-- メーカーID
(
1,
'Eccube\\Entity\\Product',
'Maker',
'id',
'メーカー(ID)',
31,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
),
-- メーカー名(日本語)
(
1,
'Eccube\\Entity\\Product',
'Maker',
'name_jp',
'メーカー名(全角カタカナ)',
32,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
),
-- メーカー名(英語)
(
1,
'Eccube\\Entity\\Product',
'Maker',
'name_en',
'メーカー名(半角英字)',
33,
1,
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
'csv'
)
");
}
public function down(Schema $schema): void
{
$this->addSql("
DELETE FROM dtb_csv
WHERE entity_name = 'Eccube\\Entity\\Product'
AND field_name = 'Maker'
AND reference_field_name IN ('id', 'name_jp', 'name_en')
AND csv_type_id = 1
");
}
}