migrations/Version20211104080824.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace Application\Migrations;
  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 Version20211104080824 extends AbstractMigration
  14. {
  15.     public function up(Schema $schema): void
  16.     {
  17.         // this up() migration is auto-generated, please modify it to your needs
  18.         $this->abortIf('mysql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'mysql\'.');
  20.         $this->addSql('ALTER TABLE substance_category ADD abbreviation VARCHAR(255) NOT NULL');
  21.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'OtherGO' WHERE `substance_category`.`id` = 1");
  22.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'TDAE' WHERE `substance_category`.`id` = 2");
  23.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'VHGO' WHERE `substance_category`.`id` = 3");
  24.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'SRGO' WHERE `substance_category`.`id` = 4");
  25.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Petrolatum' WHERE `substance_category`.`id` = 5");
  26.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'LBO' WHERE `substance_category`.`id` = 6");
  27.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Bitumen' WHERE `substance_category`.`id` = 7");
  28.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Slackwax' WHERE `substance_category`.`id` = 8");
  29.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Naphtha' WHERE `substance_category`.`id` = 9");
  30.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'HFO' WHERE `substance_category`.`id` = 10");
  31.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Kerosine' WHERE `substance_category`.`id` = 11");
  32.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'CrackedGO' WHERE `substance_category`.`id` = 12");
  33.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Paraffinwax' WHERE `substance_category`.`id` = 14");
  34.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'UATO' WHERE `substance_category`.`id` = 15");
  35.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'UDAE' WHERE `substance_category`.`id` = 17");
  36.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'RAE' WHERE `substance_category`.`id` = 18");
  37.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'MK1' WHERE `substance_category`.`id` = 19");
  38.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Footsoil' WHERE `substance_category`.`id` = 20");
  39.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'OxiAsph' WHERE `substance_category`.`id` = 21");
  40.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'Sulfur' WHERE `substance_category`.`id` = 22");
  41.         $this->addSql("UPDATE `substance_category` SET `abbreviation` = 'HRBO' WHERE `substance_category`.`id` = 23");
  42.     }
  44.     public function down(Schema $schema): void
  45.     {
  46.         // this down() migration is auto-generated, please modify it to your needs
  47.         $this->abortIf('mysql' !== $this->connection->getDatabasePlatform()->getName(), 'Migration can only be executed safely on \'mysql\'.');
  49.         $this->addSql('ALTER TABLE substance_category DROP abbreviation');
  50.     }
  51. }