app/DoctrineMigrations/Version202412132200000.php line 1

Open in your IDE?
  1. <?php
  2. declare(strict_types=1);
  3. namespace DoctrineMigrations;
  4. use Doctrine\DBAL\Schema\Schema;
  5. use Doctrine\Migrations\AbstractMigration;
  6. final class Version202412132200000 extends AbstractMigration
  7. {
  8.     public function up(Schema $schema): void
  9.     {
  10.         $this->addSql("
  11.             INSERT INTO dtb_csv (
  12.                 csv_type_id,
  13.                 entity_name,
  14.                 field_name,
  15.                 reference_field_name,
  16.                 disp_name,
  17.                 sort_no,
  18.                 enabled,
  19.                 create_date,
  20.                 update_date,
  21.                 discriminator_type
  22.             )
  23.             VALUES
  24.             -- メーカーID
  25.             (
  26.                 1,
  27.                 'Eccube\\Entity\\Product',
  28.                 'Maker',
  29.                 'id',
  30.                 'メーカー(ID)',
  31.                 31,
  32.                 1,
  33.                 CURRENT_TIMESTAMP,
  34.                 CURRENT_TIMESTAMP,
  35.                 'csv'
  36.             ),
  37.             -- メーカー名(日本語)
  38.             (
  39.                 1,
  40.                 'Eccube\\Entity\\Product',
  41.                 'Maker',
  42.                 'name_jp',
  43.                 'メーカー名(全角カタカナ)',
  44.                 32,
  45.                 1,
  46.                 CURRENT_TIMESTAMP,
  47.                 CURRENT_TIMESTAMP,
  48.                 'csv'
  49.             ),
  50.             -- メーカー名(英語)
  51.             (
  52.                 1,
  53.                 'Eccube\\Entity\\Product',
  54.                 'Maker',
  55.                 'name_en',
  56.                 'メーカー名(半角英字)',
  57.                 33,
  58.                 1,
  59.                 CURRENT_TIMESTAMP,
  60.                 CURRENT_TIMESTAMP,
  61.                 'csv'
  62.             )
  63.         ");
  64.     }
  65.     public function down(Schema $schema): void
  66.     {
  67.         $this->addSql("
  68.             DELETE FROM dtb_csv 
  69.             WHERE entity_name = 'Eccube\\Entity\\Product'
  70.             AND field_name = 'Maker'
  71.             AND reference_field_name IN ('id', 'name_jp', 'name_en')
  72.             AND csv_type_id = 1
  73.         ");
  74.     }
  75. }