Version20171019134932.php 771 B

123456789101112131415161718192021222324252627282930313233
  1. <?php
  2. namespace Application\Migrations;
  3. use Doctrine\DBAL\Migrations\AbstractMigration;
  4. use Doctrine\DBAL\Schema\Schema;
  5. /**
  6. * Auto-generated Migration: Please modify to your needs!
  7. */
  8. class Version20171019134932 extends AbstractMigration
  9. {
  10. /**
  11. * @param Schema $schema
  12. */
  13. public function up(Schema $schema)
  14. {
  15. // this up() migration is auto-generated, please modify it to your needs
  16. $base = 1;
  17. $initial = 2;
  18. $this->addsql("UPDATE onu SET tenancy_id = " . $initial . " WHERE isnull(tenancy_id) or tenancy_id = " . $base);
  19. }
  20. /**
  21. * @param Schema $schema
  22. */
  23. public function down(Schema $schema)
  24. {
  25. // this down() migration is auto-generated, please modify it to your needs
  26. }
  27. }