migrations/Version20230503095815.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 Version20230503095815 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 archive_pack (id INT AUTO_INCREMENT NOT NULL, status_id INT DEFAULT NULL, info LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:json)\', INDEX IDX_A7FB88B86BF700BD (status_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE archive_pack_file_group (archive_pack_id INT NOT NULL, file_group_id INT NOT NULL, INDEX IDX_B9616B743953E8 (archive_pack_id), INDEX IDX_B9616B4F0456DA (file_group_id), PRIMARY KEY(archive_pack_id, file_group_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE archive_pack_file_versions (archive_pack_id INT NOT NULL, file_versions_id INT NOT NULL, INDEX IDX_B1029AA743953E8 (archive_pack_id), INDEX IDX_B1029AAB5EB0BEF (file_versions_id), PRIMARY KEY(archive_pack_id, file_versions_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE archive_pack_file (archive_pack_id INT NOT NULL, file_id INT NOT NULL, INDEX IDX_81372D15743953E8 (archive_pack_id), INDEX IDX_81372D1593CB796C (file_id), PRIMARY KEY(archive_pack_id, file_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE archive_pack_event (id INT AUTO_INCREMENT NOT NULL, archive_pack_id INT NOT NULL, created DATETIME NOT NULL, description VARCHAR(255) DEFAULT NULL, INDEX IDX_4BC95633743953E8 (archive_pack_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE archive_pack_event_sys_archive_status (archive_pack_event_id INT NOT NULL, sys_archive_status_id INT NOT NULL, INDEX IDX_642B0F414E351E74 (archive_pack_event_id), INDEX IDX_642B0F417A519752 (sys_archive_status_id), PRIMARY KEY(archive_pack_event_id, sys_archive_status_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE service_user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', service_key VARCHAR(32) NOT NULL, sql_idc INT NOT NULL, UNIQUE INDEX UNIQ_43D062A5F85E0677 (username), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE sys_archive_status (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(30) NOT NULL, description VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('CREATE TABLE system_parameter (id BIGINT AUTO_INCREMENT NOT NULL, customer_id INT NOT NULL, name VARCHAR(255) NOT NULL, value VARCHAR(255) DEFAULT NULL, INDEX IDX_294899AD9395C3F3 (customer_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('ALTER TABLE archive_pack ADD CONSTRAINT FK_A7FB88B86BF700BD FOREIGN KEY (status_id) REFERENCES sys_archive_status (id)');
  33. $this->addSql('ALTER TABLE archive_pack_file_group ADD CONSTRAINT FK_B9616B743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
  34. $this->addSql('ALTER TABLE archive_pack_file_group ADD CONSTRAINT FK_B9616B4F0456DA FOREIGN KEY (file_group_id) REFERENCES file_group (id) ON DELETE CASCADE');
  35. $this->addSql('ALTER TABLE archive_pack_file_versions ADD CONSTRAINT FK_B1029AA743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
  36. $this->addSql('ALTER TABLE archive_pack_file_versions ADD CONSTRAINT FK_B1029AAB5EB0BEF FOREIGN KEY (file_versions_id) REFERENCES file_versions (id) ON DELETE CASCADE');
  37. $this->addSql('ALTER TABLE archive_pack_file ADD CONSTRAINT FK_81372D15743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
  38. $this->addSql('ALTER TABLE archive_pack_file ADD CONSTRAINT FK_81372D1593CB796C FOREIGN KEY (file_id) REFERENCES file (id) ON DELETE CASCADE');
  39. $this->addSql('ALTER TABLE archive_pack_event ADD CONSTRAINT FK_4BC95633743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id)');
  40. $this->addSql('ALTER TABLE archive_pack_event_sys_archive_status ADD CONSTRAINT FK_642B0F414E351E74 FOREIGN KEY (archive_pack_event_id) REFERENCES archive_pack_event (id) ON DELETE CASCADE');
  41. $this->addSql('ALTER TABLE archive_pack_event_sys_archive_status ADD CONSTRAINT FK_642B0F417A519752 FOREIGN KEY (sys_archive_status_id) REFERENCES sys_archive_status (id) ON DELETE CASCADE');
  42. $this->addSql('ALTER TABLE system_parameter ADD CONSTRAINT FK_294899AD9395C3F3 FOREIGN KEY (customer_id) REFERENCES customer (id)');
  43. $this->addSql('ALTER TABLE file ADD latest_archive_status_id INT DEFAULT NULL, ADD g_nomefile VARCHAR(50) DEFAULT NULL, ADD md5 VARCHAR(32) DEFAULT NULL, ADD md5p7m VARCHAR(32) DEFAULT NULL, ADD pages_number INT DEFAULT NULL, ADD size INT DEFAULT NULL');
  44. $this->addSql('ALTER TABLE file ADD CONSTRAINT FK_8C9F361070BC95B1 FOREIGN KEY (latest_archive_status_id) REFERENCES sys_archive_status (id)');
  45. $this->addSql('CREATE INDEX IDX_8C9F361070BC95B1 ON file (latest_archive_status_id)');
  46. $this->addSql('ALTER TABLE file_drive_permission ADD audit VARCHAR(30) DEFAULT NULL');
  47. }
  49. public function down(Schema $schema): void
  50. {
  51. // this down() migration is auto-generated, please modify it to your needs
  52. $this->addSql('ALTER TABLE file DROP FOREIGN KEY FK_8C9F361070BC95B1');
  53. $this->addSql('ALTER TABLE archive_pack DROP FOREIGN KEY FK_A7FB88B86BF700BD');
  54. $this->addSql('ALTER TABLE archive_pack_file_group DROP FOREIGN KEY FK_B9616B743953E8');
  55. $this->addSql('ALTER TABLE archive_pack_file_group DROP FOREIGN KEY FK_B9616B4F0456DA');
  56. $this->addSql('ALTER TABLE archive_pack_file_versions DROP FOREIGN KEY FK_B1029AA743953E8');
  57. $this->addSql('ALTER TABLE archive_pack_file_versions DROP FOREIGN KEY FK_B1029AAB5EB0BEF');
  58. $this->addSql('ALTER TABLE archive_pack_file DROP FOREIGN KEY FK_81372D15743953E8');
  59. $this->addSql('ALTER TABLE archive_pack_file DROP FOREIGN KEY FK_81372D1593CB796C');
  60. $this->addSql('ALTER TABLE archive_pack_event DROP FOREIGN KEY FK_4BC95633743953E8');
  61. $this->addSql('ALTER TABLE archive_pack_event_sys_archive_status DROP FOREIGN KEY FK_642B0F414E351E74');
  62. $this->addSql('ALTER TABLE archive_pack_event_sys_archive_status DROP FOREIGN KEY FK_642B0F417A519752');
  63. $this->addSql('ALTER TABLE system_parameter DROP FOREIGN KEY FK_294899AD9395C3F3');
  64. $this->addSql('DROP TABLE archive_pack');
  65. $this->addSql('DROP TABLE archive_pack_file_group');
  66. $this->addSql('DROP TABLE archive_pack_file_versions');
  67. $this->addSql('DROP TABLE archive_pack_file');
  68. $this->addSql('DROP TABLE archive_pack_event');
  69. $this->addSql('DROP TABLE archive_pack_event_sys_archive_status');
  70. $this->addSql('DROP TABLE service_user');
  71. $this->addSql('DROP TABLE sys_archive_status');
  72. $this->addSql('DROP TABLE system_parameter');
  73. $this->addSql('DROP INDEX IDX_8C9F361070BC95B1 ON file');
  74. $this->addSql('ALTER TABLE file DROP latest_archive_status_id, DROP g_nomefile, DROP md5, DROP md5p7m, DROP pages_number, DROP size');
  75. $this->addSql('ALTER TABLE file_drive_permission DROP audit');
  76. }
  77. }