migrations/Version20240326130042.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 Version20240326130042 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         $this->addSql(
  23.             'ALTER TABLE health_report_submission_files
  24.             DROP FOREIGN KEY FK_8371AB18825015F'
  25.         );
  26.         $this->addSql('DROP INDEX IDX_8371AB18825015F ON health_report_submission_files');
  27.         $this->addSql(
  28.             'ALTER TABLE health_report_submission_files
  29.             CHANGE health_report_submissions_id health_report_submission_id INT UNSIGNED NOT NULL'
  30.         );
  31.         $this->addSql(
  32.             'ALTER TABLE health_report_submission_files
  33.             ADD CONSTRAINT FK_8371AB1E4CB9BD6 FOREIGN KEY (health_report_submission_id)
  34.             REFERENCES health_report_submissions (id)
  35.             ON DELETE CASCADE'
  36.         );
  37.         $this->addSql(
  38.             'CREATE INDEX IDX_8371AB1E4CB9BD6
  39.             ON health_report_submission_files (health_report_submission_id)'
  40.         );
  41.     }
  43.     public function down(Schema $schema): void
  44.     {
  45.         // this down() migration is auto-generated, please modify it to your needs
  46.         $this->addSql(
  47.             'ALTER TABLE health_report_submission_files DROP FOREIGN KEY FK_8371AB1E4CB9BD6'
  48.         );
  49.         $this->addSql(
  50.             'DROP INDEX IDX_8371AB1E4CB9BD6 ON health_report_submission_files'
  51.         );
  52.         $this->addSql(
  53.             'ALTER TABLE health_report_submission_files
  54.             CHANGE health_report_submission_id health_report_submissions_id INT UNSIGNED NOT NULL'
  55.         );
  56.         $this->addSql(
  57.             'ALTER TABLE health_report_submission_files
  58.             ADD CONSTRAINT FK_8371AB18825015F FOREIGN KEY (health_report_submissions_id)
  59.             REFERENCES health_report_submissions (id) ON UPDATE NO ACTION ON DELETE CASCADE'
  60.         );
  61.         $this->addSql(
  62.             'CREATE INDEX IDX_8371AB18825015F
  63.             ON health_report_submission_files (health_report_submissions_id)'
  64.         );
  65.     }
  66. }