app/DoctrineMigrations/Version20250917000000.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.  * 兄弟設定でのスクール表示制御のためのマイグレーション
  12.  * A学校でB学校、C学校のみを兄弟設定リストに表示する機能を追加
  13.  */
  14. final class Version20250917000000 extends AbstractMigration
  15. {
  16.     public function getDescription(): string
  17.     {
  18.         return '兄弟設定でのスクール表示制御テーブル (dtb_school_brother_display) を追加';
  19.     }
  21.     public function up(Schema $schema): void
  22.     {
  23.         $schemaManager = $this->connection->createSchemaManager();
  24.         
  25.         // テーブルが存在しない場合のみ作成
  26.         if (!$schemaManager->tablesExist(['dtb_school_brother_display'])) {
  27.             // 兄弟設定表示制御テーブルを作成
  28.             $this->addSql('CREATE TABLE dtb_school_brother_display (
  29.                 id INT AUTO_INCREMENT NOT NULL,
  30.                 base_school_id INT UNSIGNED NOT NULL,
  31.                 target_school_id INT UNSIGNED NOT NULL,
  32.                 PRIMARY KEY(id),
  33.                 UNIQUE INDEX unique_school_pair (base_school_id, target_school_id),
  34.                 INDEX IDX_school_brother_display_base_school (base_school_id),
  35.                 INDEX IDX_school_brother_display_target_school (target_school_id)
  36.             ) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_general_ci` ENGINE = InnoDB');
  38.             // 外部キー制約を追加
  39.             $this->addSql('ALTER TABLE dtb_school_brother_display 
  40.                 ADD CONSTRAINT FK_school_brother_display_base_school 
  41.                 FOREIGN KEY (base_school_id) REFERENCES dtb_school (school_id) ON DELETE CASCADE');
  42.             
  43.             $this->addSql('ALTER TABLE dtb_school_brother_display 
  44.                 ADD CONSTRAINT FK_school_brother_display_target_school 
  45.                 FOREIGN KEY (target_school_id) REFERENCES dtb_school (school_id) ON DELETE CASCADE');
  46.         }
  47.     }
  49.     public function down(Schema $schema): void
  50.     {
  51.         $schemaManager = $this->connection->createSchemaManager();
  52.         
  53.         // テーブルが存在する場合のみ削除
  54.         if ($schemaManager->tablesExist(['dtb_school_brother_display'])) {
  55.             // 外部キー制約を削除
  56.             $this->addSql('ALTER TABLE dtb_school_brother_display DROP FOREIGN KEY FK_school_brother_display_base_school');
  57.             $this->addSql('ALTER TABLE dtb_school_brother_display DROP FOREIGN KEY FK_school_brother_display_target_school');
  58.             
  59.             // テーブルを削除
  60.             $this->addSql('DROP TABLE dtb_school_brother_display');
  61.         }
  62.     }
  63. }