migrations/Version20250522024104.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 Version20250522024104 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return 'Create 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. CREATE TABLE dp_schedule_log (id INT AUTO_INCREMENT NOT NULL, tcard_id INT DEFAULT NULL, schedule_date DATETIME NOT NULL, schedule_status TINYINT(1) DEFAULT 1 NOT NULL, schedule_event_id VARCHAR(255) DEFAULT NULL, schedule_data LONGTEXT NOT NULL, created_time DATETIME NOT NULL, INDEX tcard_id_idx (tcard_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB
  25. SQL);
  26. $this->addSql(<<<'SQL'
  27. ALTER TABLE dp_schedule_log ADD CONSTRAINT FK_B22799C69A98055D FOREIGN KEY (tcard_id) REFERENCES tc_tcard (id)
  28. SQL);
  29. }
  31. public function down(Schema $schema): void
  32. {
  33. // this down() migration is auto-generated, please modify it to your needs
  34. $this->addSql(<<<'SQL'
  35. ALTER TABLE dp_schedule_log DROP FOREIGN KEY FK_B22799C69A98055D
  36. SQL);
  37. $this->addSql(<<<'SQL'
  38. DROP TABLE dp_schedule_log
  39. SQL);
  40. }
  41. }