app/DoctrineMigrations/Version20260109000000.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11.  * Auto-generated Migration: Please modify to your needs!
  12.  */
  13. final class Version20260109000000 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return 'Add dtb_set_product_tag table for set product tagging feature';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // this up() migration is auto-generated, please modify it to your needs
  23.         if (!$schema->hasTable('dtb_set_product_tag')) {
  24.             $table = $schema->createTable('dtb_set_product_tag');
  25.             $table->addColumn('id', 'integer', ['autoincrement' => true, 'unsigned' => true]);
  26.             $table->addColumn('set_product_id', 'integer', ['unsigned' => true]);
  27.             $table->addColumn('tag_id', 'integer', ['notnull' => false, 'unsigned' => true]);
  28.             $table->addColumn('creator_id', 'integer', ['notnull' => false, 'unsigned' => true]);
  29.             $table->addColumn('create_date', 'datetimetz');
  30.             $table->addColumn('discriminator_type', 'string', ['length' => 255, 'notnull' => false]);
  31.             
  32.             $table->setPrimaryKey(['id']);
  33.             $table->addIndex(['set_product_id'], 'idx_set_product_tag_set_product_id');
  34.             $table->addIndex(['tag_id'], 'idx_set_product_tag_tag_id');
  35.             
  36.             $table->addForeignKeyConstraint('dtb_set_product', ['set_product_id'], ['set_product_id']);
  37.             $table->addForeignKeyConstraint('dtb_tag', ['tag_id'], ['id']);
  38.             $table->addForeignKeyConstraint('dtb_member', ['creator_id'], ['id']);
  39.         }
  40.     }
  42.     public function down(Schema $schema): void
  43.     {
  44.         // this down() migration is auto-generated, please modify it to your needs
  45.         if ($schema->hasTable('dtb_set_product_tag')) {
  46.             $schema->dropTable('dtb_set_product_tag');
  47.         }
  48.     }
  49. }