migrations/Version20250522065458.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  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 Version20250522065458 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return 'Add checksheet_status_id to dp_schedule_log table';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. // this up() migration is auto-generated, please modify it to your needs
  23. $this->addSql(<<<'SQL'
  24. ALTER TABLE dp_schedule_log ADD checksheet_status_id INT DEFAULT NULL
  25. SQL);
  26. $this->addSql(<<<'SQL'
  27. ALTER TABLE dp_schedule_log ADD CONSTRAINT FK_B22799C62D1319DC FOREIGN KEY (checksheet_status_id) REFERENCES tc_tcard_checksheet_status (id)
  28. SQL);
  29. $this->addSql(<<<'SQL'
  30. CREATE INDEX IDX_B22799C62D1319DC ON dp_schedule_log (checksheet_status_id)
  31. SQL);
  32. }
  34. public function down(Schema $schema): void
  35. {
  36. // this down() migration is auto-generated, please modify it to your needs
  37. $this->addSql(<<<'SQL'
  38. ALTER TABLE dp_schedule_log DROP FOREIGN KEY FK_B22799C62D1319DC
  39. SQL);
  40. $this->addSql(<<<'SQL'
  41. DROP INDEX IDX_B22799C62D1319DC ON dp_schedule_log
  42. SQL);
  43. $this->addSql(<<<'SQL'
  44. ALTER TABLE dp_schedule_log DROP checksheet_status_id
  45. SQL);
  46. }
  47. }