Version20160808110200.php 712 B

1234567891011121314151617181920212223242526272829
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. namespace Application\Migrations\Schema\V110;
  4. use Application\Migrations\AbstractMigrationChamilo;
  5. use Doctrine\DBAL\Schema\Schema;
  6. /**
  7. * Set null to post_parent_id when it is 0 on c_forum_post table
  8. */
  9. class Version20160808110200 extends AbstractMigrationChamilo
  10. {
  11. /**
  12. * @param Schema $schema
  13. */
  14. public function up(Schema $schema)
  15. {
  16. $this->addSql("UPDATE c_forum_post SET post_parent_id = NULL WHERE post_parent_id = 0");
  17. }
  18. /**
  19. * @param Schema $schema
  20. */
  21. public function down(Schema $schema)
  22. {
  23. $this->addSql('UPDATE c_forum_post SET post_parent_id = 0 WHERE post_parent_id = NULL');
  24. }
  25. }