Version20190328134353.php 586 B

123456789101112131415161718192021222324252627
  1. <?php
  2. namespace Application\Migrations;
  3. use Doctrine\DBAL\Migrations\AbstractMigration;
  4. use Doctrine\DBAL\Schema\Schema;
  5. /**
  6. * Update workflow_id in onu table
  7. */
  8. class Version20190328134353 extends AbstractMigration
  9. {
  10. /**
  11. * @param Schema $schema
  12. */
  13. public function up(Schema $schema)
  14. {
  15. $this->addSql('SET FOREIGN_KEY_CHECKS=0; UPDATE workflow SET id = 2 WHERE name = "onu_workflow"; UPDATE onu SET workflow_id = 2; SET FOREIGN_KEY_CHECKS=1;');
  16. }
  17. /**
  18. * @param Schema $schema
  19. */
  20. public function down(Schema $schema)
  21. {
  22. }
  23. }