<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20230904072717 extends AbstractMigration
{
public function getDescription(): string
{
return '';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
$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');
$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');
$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');
$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');
$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');
$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');
$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');
$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');
$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');
$this->addSql('ALTER TABLE archive_pack ADD CONSTRAINT FK_A7FB88B86BF700BD FOREIGN KEY (status_id) REFERENCES sys_archive_status (id)');
$this->addSql('ALTER TABLE archive_pack_file_group ADD CONSTRAINT FK_B9616B743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_file_group ADD CONSTRAINT FK_B9616B4F0456DA FOREIGN KEY (file_group_id) REFERENCES file_group (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_file_versions ADD CONSTRAINT FK_B1029AA743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_file_versions ADD CONSTRAINT FK_B1029AAB5EB0BEF FOREIGN KEY (file_versions_id) REFERENCES file_versions (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_file ADD CONSTRAINT FK_81372D15743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_file ADD CONSTRAINT FK_81372D1593CB796C FOREIGN KEY (file_id) REFERENCES file (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE archive_pack_event ADD CONSTRAINT FK_4BC95633743953E8 FOREIGN KEY (archive_pack_id) REFERENCES archive_pack (id)');
$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');
$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');
$this->addSql('ALTER TABLE system_parameter ADD CONSTRAINT FK_294899AD9395C3F3 FOREIGN KEY (customer_id) REFERENCES customer (id)');
$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');
$this->addSql('ALTER TABLE file ADD CONSTRAINT FK_8C9F361070BC95B1 FOREIGN KEY (latest_archive_status_id) REFERENCES sys_archive_status (id)');
$this->addSql('CREATE INDEX IDX_8C9F361070BC95B1 ON file (latest_archive_status_id)');
$this->addSql('ALTER TABLE file_drive_permission ADD audit VARCHAR(30) DEFAULT NULL');
$this->addSql('ALTER TABLE notification ADD design VARCHAR(30) NOT NULL, ADD created_at DATETIME NOT NULL, ADD updated_at DATETIME NOT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE file DROP FOREIGN KEY FK_8C9F361070BC95B1');
$this->addSql('ALTER TABLE archive_pack DROP FOREIGN KEY FK_A7FB88B86BF700BD');
$this->addSql('ALTER TABLE archive_pack_file_group DROP FOREIGN KEY FK_B9616B743953E8');
$this->addSql('ALTER TABLE archive_pack_file_group DROP FOREIGN KEY FK_B9616B4F0456DA');
$this->addSql('ALTER TABLE archive_pack_file_versions DROP FOREIGN KEY FK_B1029AA743953E8');
$this->addSql('ALTER TABLE archive_pack_file_versions DROP FOREIGN KEY FK_B1029AAB5EB0BEF');
$this->addSql('ALTER TABLE archive_pack_file DROP FOREIGN KEY FK_81372D15743953E8');
$this->addSql('ALTER TABLE archive_pack_file DROP FOREIGN KEY FK_81372D1593CB796C');
$this->addSql('ALTER TABLE archive_pack_event DROP FOREIGN KEY FK_4BC95633743953E8');
$this->addSql('ALTER TABLE archive_pack_event_sys_archive_status DROP FOREIGN KEY FK_642B0F414E351E74');
$this->addSql('ALTER TABLE archive_pack_event_sys_archive_status DROP FOREIGN KEY FK_642B0F417A519752');
$this->addSql('ALTER TABLE system_parameter DROP FOREIGN KEY FK_294899AD9395C3F3');
$this->addSql('DROP TABLE archive_pack');
$this->addSql('DROP TABLE archive_pack_file_group');
$this->addSql('DROP TABLE archive_pack_file_versions');
$this->addSql('DROP TABLE archive_pack_file');
$this->addSql('DROP TABLE archive_pack_event');
$this->addSql('DROP TABLE archive_pack_event_sys_archive_status');
$this->addSql('DROP TABLE service_user');
$this->addSql('DROP TABLE sys_archive_status');
$this->addSql('DROP TABLE system_parameter');
$this->addSql('DROP INDEX IDX_8C9F361070BC95B1 ON file');
$this->addSql('ALTER TABLE file DROP latest_archive_status_id, DROP g_nomefile, DROP md5, DROP md5p7m, DROP pages_number, DROP size');
$this->addSql('ALTER TABLE file_drive_permission DROP audit');
$this->addSql('ALTER TABLE notification DROP design, DROP created_at, DROP updated_at');
}
}