migrations/Version20240312135739.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 Version20240312135739 extends AbstractMigration
  14. {
  15.     public function getDescription(): string
  16.     {
  17.         return '';
  18.     }
  20.     public function up(Schema $schema): void
  21.     {
  22.         // NOTE: COLUMN `health_report_submission_files.health_report_submissions_id`
  23.         // WAS LATER CHANGED TO `health_report_submission_id` (NO 's')
  24.         $this->addSql(
  25.             'CREATE TABLE health_report_submission_files (
  26.                 id INT UNSIGNED AUTO_INCREMENT NOT NULL,
  27.                 health_report_submissions_id INT UNSIGNED NOT NULL,
  28.                 file_name VARCHAR(128) NOT NULL,
  29.                 original_name VARCHAR(128) NOT NULL,
  30.                 INDEX IDX_8371AB18825015F (health_report_submissions_id),
  31.                 PRIMARY KEY(id))
  32.                 DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
  33.         );
  34.         $this->addSql(
  35.             'CREATE TABLE health_report_submissions (
  36.                 id INT UNSIGNED AUTO_INCREMENT NOT NULL,
  37.                 cardio_metabolic_profile_id INT UNSIGNED DEFAULT NULL,
  38.                 user_id INT UNSIGNED NOT NULL,
  39.                 created_at DATETIME NOT NULL,
  40.                 status ENUM(\'PENDING_OCR\', \'EDITABLE\', \'FINAL\')
  41.                     DEFAULT \'PENDING_OCR\' NOT NULL
  42.                     COMMENT \'(DC2Type:health_submission_status_enum_type)\',
  43.                 INDEX IDX_B9DD585D7E454BA8 (cardio_metabolic_profile_id),
  44.                 INDEX IDX_B9DD585DA76ED395 (user_id),
  45.                 PRIMARY KEY(id))
  46.                 DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB'
  47.         );
  48.         $this->addSql(
  49.             'ALTER TABLE health_report_submission_files
  50.             ADD CONSTRAINT FK_8371AB18825015F
  51.             FOREIGN KEY (health_report_submissions_id)
  52.             REFERENCES health_report_submissions (id)
  53.             ON DELETE CASCADE'
  54.         );
  55.         $this->addSql(
  56.             'ALTER TABLE health_report_submissions
  57.             ADD CONSTRAINT FK_B9DD585D7E454BA8
  58.             FOREIGN KEY (cardio_metabolic_profile_id)
  59.             REFERENCES cardiometabolic_profiles (id)
  60.             ON DELETE CASCADE'
  61.         );
  62.         $this->addSql(
  63.             'ALTER TABLE health_report_submissions
  64.             ADD CONSTRAINT FK_B9DD585DA76ED395
  65.             FOREIGN KEY (user_id)
  66.             REFERENCES users (id)
  67.             ON DELETE CASCADE'
  68.         );
  69.     }
  71.     public function down(Schema $schema): void
  72.     {
  73.         // this down() migration is auto-generated, please modify it to your needs
  74.         $this->addSql(
  75.             'ALTER TABLE health_report_submission_files
  76.             DROP FOREIGN KEY FK_8371AB18825015F'
  77.         );
  78.         $this->addSql(
  79.             'ALTER TABLE health_report_submissions
  80.             DROP FOREIGN KEY FK_B9DD585D7E454BA8'
  81.         );
  82.         $this->addSql(
  83.             'ALTER TABLE health_report_submissions
  84.             DROP FOREIGN KEY FK_B9DD585DA76ED395'
  85.         );
  86.         $this->addSql('DROP TABLE health_report_submissions');
  87.         $this->addSql('DROP TABLE health_report_submission_files');
  88.     }
  89. }