migrations/Version20260721065217.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 Version20260721065217 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return '';
  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('CREATE TABLE channel_configuration_dsf_services (channel_configuration_id INT NOT NULL, service_id INT NOT NULL, INDEX IDX_24EA11C4A493463 (channel_configuration_id), INDEX IDX_24EA11CED5CA9E6 (service_id), PRIMARY KEY(channel_configuration_id, service_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE file_admin_channel_user_data_agreement (id INT NOT NULL, status VARCHAR(255) DEFAULT NULL, refusal_reason VARCHAR(255) DEFAULT NULL, signed_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE file_admin_channel_user_data_document (id INT NOT NULL, channel_user_data_id VARCHAR(36) NOT NULL, document_issued_date DATE NOT NULL, last_notified_at DATE DEFAULT NULL, INDEX IDX_1D42B0D523887597 (channel_user_data_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('ALTER TABLE channel_configuration_dsf_services ADD CONSTRAINT FK_24EA11C4A493463 FOREIGN KEY (channel_configuration_id) REFERENCES channel_configuration (id) ON DELETE CASCADE');
  27. $this->addSql('ALTER TABLE channel_configuration_dsf_services ADD CONSTRAINT FK_24EA11CED5CA9E6 FOREIGN KEY (service_id) REFERENCES channel_services (id) ON DELETE CASCADE');
  28. $this->addSql('ALTER TABLE file_admin_channel_user_data_agreement ADD CONSTRAINT FK_617F834CBF396750 FOREIGN KEY (id) REFERENCES file (id) ON DELETE CASCADE');
  29. $this->addSql('ALTER TABLE file_admin_channel_user_data_document ADD CONSTRAINT FK_1D42B0D523887597 FOREIGN KEY (channel_user_data_id) REFERENCES channel_user_data_admin (id) ON DELETE CASCADE');
  30. $this->addSql('ALTER TABLE file_admin_channel_user_data_document ADD CONSTRAINT FK_1D42B0D5BF396750 FOREIGN KEY (id) REFERENCES file (id) ON DELETE CASCADE');
  32. // Moves data from "certificate" to abstract "document"
  33. $this->addSql('
  34. INSERT INTO file_admin_channel_user_data_document (
  35. id,
  36. channel_user_data_id,
  37. document_issued_date,
  38. last_notified_at
  39. )
  40. SELECT
  41. certificate.id,
  42. certificate.channel_user_data_id,
  43. DATE(file.created_at),
  44. NULL
  45. FROM file_admin_channel_user_data_certificate certificate
  46. INNER JOIN file ON file.id = certificate.id
  47. ');
  49. $this->addSql('ALTER TABLE file_admin_channel_user_data_certificate DROP FOREIGN KEY FK_73B71E8F23887597');
  50. $this->addSql('DROP INDEX IDX_73B71E8F23887597 ON file_admin_channel_user_data_certificate');
  51. $this->addSql('DROP INDEX UNIQ_73B71E8F23887597F2C76A50 ON file_admin_channel_user_data_certificate');
  52. $this->addSql('ALTER TABLE file_admin_channel_user_data_certificate DROP channel_user_data_id');
  53. }
  55. public function down(Schema $schema): void
  56. {
  57. // this down() migration is auto-generated, please modify it to your needs
  58. $this->addSql('ALTER TABLE channel_configuration_dsf_services DROP FOREIGN KEY FK_24EA11C4A493463');
  59. $this->addSql('ALTER TABLE channel_configuration_dsf_services DROP FOREIGN KEY FK_24EA11CED5CA9E6');
  60. $this->addSql('ALTER TABLE file_admin_channel_user_data_agreement DROP FOREIGN KEY FK_617F834CBF396750');
  61. $this->addSql('ALTER TABLE file_admin_channel_user_data_document DROP FOREIGN KEY FK_1D42B0D523887597');
  62. $this->addSql('ALTER TABLE file_admin_channel_user_data_document DROP FOREIGN KEY FK_1D42B0D5BF396750');
  63. $this->addSql('ALTER TABLE file_admin_channel_user_data_certificate ADD channel_user_data_id VARCHAR(36) DEFAULT NULL');
  64. $this->addSql('UPDATE file_admin_channel_user_data_certificate certificate INNER JOIN file_admin_channel_user_data_document document ON document.id = certificate.id SET certificate.channel_user_data_id = document.channel_user_data_id');
  65. $this->addSql('ALTER TABLE file_admin_channel_user_data_certificate MODIFY channel_user_data_id VARCHAR(36) NOT NULL');
  66. $this->addSql('DROP TABLE channel_configuration_dsf_services');
  67. $this->addSql('DROP TABLE file_admin_channel_user_data_agreement');
  68. $this->addSql('DROP TABLE file_admin_channel_user_data_document');
  69. $this->addSql('ALTER TABLE file_admin_channel_user_data_certificate ADD CONSTRAINT FK_73B71E8F23887597 FOREIGN KEY (channel_user_data_id) REFERENCES channel_user_data_admin (id) ON DELETE CASCADE');
  70. $this->addSql('CREATE INDEX IDX_73B71E8F23887597 ON file_admin_channel_user_data_certificate (channel_user_data_id)');
  71. $this->addSql('CREATE UNIQUE INDEX UNIQ_73B71E8F23887597F2C76A50 ON file_admin_channel_user_data_certificate (channel_user_data_id, certificate_type)');
  72. }
  73. }