migrations/Version20230515081119.php line 1

Open in your IDE?
  1. <?php
  3. /* @noinspection PhpUnused */
  5. declare(strict_types=1);
  7. namespace DoctrineMigrations;
  9. use Doctrine\DBAL\Schema\Schema;
  10. use Doctrine\Migrations\AbstractMigration;
  12. /**
  13.  * Auto-generated Migration: Please modify to your needs!
  14.  *
  15.  * @package API
  16.  * @internal
  17.  */
  18. final class Version20230515081119 extends AbstractMigration
  19. {
  21.     public function down(Schema $schema): void
  22.     {
  23.         // this down() migration is auto-generated, please modify it to your needs
  24.     }
  26.     public function getDescription(): string
  27.     {
  28.         return
  29.             "- Altering entries of databaseTables of status from ints to ENUMS.\n" .
  30.             "- Altered columns: oim_measures.status, oim_case_tasks.status, .\n" .
  31.             "  oim_measures.status";
  32.     }
  34.     public function up(Schema $schema): void
  35.     {
  36.         // this up() migration is auto-generated, please modify it to your needs
  37.         // start oim_measures
  38.         $this->addSql(
  39.             '
  40.                 UPDATE oim_measures
  41.                 SET status = "ONGOING"
  42.                 WHERE status = "0"
  43.                 OR status = ""
  44.             '
  45.         );
  46.         $this->addSql(
  47.             '
  48.                 UPDATE oim_measures
  49.                 SET status = "SUCCESSFULL"
  50.                 WHERE status = "1"
  51.             '
  52.         );
  53.         $this->addSql(
  54.             '
  55.                 UPDATE oim_measures
  56.                 SET status = "NOT_SUCCESSFULL"
  57.                 WHERE status = "2"
  58.             '
  59.         );
  60.         // END oim_measueres
  61.         //START oim_case_tasks
  62.         $this->addSql(
  63.             '
  64.                 UPDATE oim_case_tasks
  65.                 SET status = "OPEN"
  66.                 WHERE status = "0"
  67.                 OR status = ""
  68.             '
  69.         );
  70.         $this->addSql(
  71.             '
  72.                 UPDATE oim_case_tasks
  73.                 SET status = "RUNNING"
  74.                 WHERE status = "1"
  75.             '
  76.         );
  77.         $this->addSql(
  78.             '
  79.                 UPDATE oim_case_tasks
  80.                 SET status = "DONE"
  81.                 WHERE status = "2"
  82.             '
  83.         );
  85.         //END oim_case_tasks
  86.     }
  88. }