app/DoctrineMigrations/Version202412132200000.php line 1

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