migrations/Version20260603133916.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 Version20260603133916 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return 'Make tc_assets.workstation_id nullable and create tc_assets_checksheet mapping table';
  19. }
  21. public function up(Schema $schema): void
  22. {
  23. $this->addSql('ALTER TABLE tc_assets MODIFY workstation_id INT NULL');
  25. $this->addSql('CREATE TABLE tc_assets_checksheet
  26. (id INT AUTO_INCREMENT NOT NULL,
  27. asset_id INT NOT NULL,
  28. checksheet_id INT NOT NULL,
  29. created_at DATETIME NOT NULL,
  30. PRIMARY KEY (id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('CREATE INDEX IDX_asset_id ON tc_assets_checksheet (asset_id)');
  33. $this->addSql('CREATE INDEX IDX_checksheet_id ON tc_assets_checksheet (checksheet_id)');
  35. $this->addSql('ALTER TABLE tc_assets_checksheet ADD CONSTRAINT FK_tac_asset FOREIGN KEY (asset_id) REFERENCES tc_assets (id)');
  36. $this->addSql('ALTER TABLE tc_assets_checksheet ADD CONSTRAINT FK_tac_checksheet FOREIGN KEY (checksheet_id) REFERENCES tc_checksheet (id)');
  37. }
  39. public function down(Schema $schema): void
  40. {
  41. $this->addSql('ALTER TABLE tc_assets_checksheet DROP FOREIGN KEY FK_tac_asset');
  42. $this->addSql('ALTER TABLE tc_assets_checksheet DROP FOREIGN KEY FK_tac_checksheet');
  43. $this->addSql('DROP TABLE tc_assets_checksheet');
  44. $this->addSql('ALTER TABLE tc_assets MODIFY workstation_id INT NOT NULL');
  45. }
  46. }