migrations/2020/11/Version20201123230539.php line 1

  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. final class Version20201123230539 extends AbstractMigration
  11. {
  12.     public function up(Schema $schema): void
  13.     {
  14.         $this->addSql('CREATE TABLE invoice_draft_email (id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_id)\', created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', invoice_draft_id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_id)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', sent_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', recipients LONGTEXT NOT NULL COMMENT \'(DC2Type:simple_array)\', recipients_cc LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', recipients_bcc LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', message LONGTEXT NOT NULL, INDEX IDX_F7AB9A68B03A8386 (created_by_id), INDEX IDX_F7AB9A68FDDB9F89 (invoice_draft_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  15.         $this->addSql('CREATE TABLE invoice_draft_email_attachment (id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_attachment_id)\', email_id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_id)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', filename VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, INDEX IDX_B5D547FCA832C1C9 (email_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  16.         $this->addSql('CREATE TABLE invoice_draft_email_draft (id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_draft_id)\', created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', invoice_draft_id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_id)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', modified_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', recipients LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', recipients_cc LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', recipients_bcc LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:simple_array)\', message LONGTEXT DEFAULT NULL, INDEX IDX_99B433DFB03A8386 (created_by_id), INDEX IDX_99B433DFFDDB9F89 (invoice_draft_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  17.         $this->addSql('CREATE TABLE invoice_draft_email_draft_attachment (id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_draft_attachment_id)\', email_draft_id BINARY(16) NOT NULL COMMENT \'(DC2Type:invoice_draft_email_draft_id)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', filename VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, INDEX IDX_203032CEE995DA98 (email_draft_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  18.         $this->addSql('ALTER TABLE invoice_draft_email ADD CONSTRAINT FK_F7AB9A68B03A8386 FOREIGN KEY (created_by_id) REFERENCES contact (id)');
  19.         $this->addSql('ALTER TABLE invoice_draft_email ADD CONSTRAINT FK_F7AB9A68FDDB9F89 FOREIGN KEY (invoice_draft_id) REFERENCES invoice_draft (id)');
  20.         $this->addSql('ALTER TABLE invoice_draft_email_attachment ADD CONSTRAINT FK_B5D547FCA832C1C9 FOREIGN KEY (email_id) REFERENCES invoice_draft_email (id)');
  21.         $this->addSql('ALTER TABLE invoice_draft_email_draft ADD CONSTRAINT FK_99B433DFB03A8386 FOREIGN KEY (created_by_id) REFERENCES contact (id)');
  22.         $this->addSql('ALTER TABLE invoice_draft_email_draft ADD CONSTRAINT FK_99B433DFFDDB9F89 FOREIGN KEY (invoice_draft_id) REFERENCES invoice_draft (id)');
  23.         $this->addSql('ALTER TABLE invoice_draft_email_draft_attachment ADD CONSTRAINT FK_203032CEE995DA98 FOREIGN KEY (email_draft_id) REFERENCES invoice_draft_email_draft (id)');
  24.         $this->addSql('ALTER TABLE invoice_draft ADD deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', ADD deleted_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\'');
  25.         $this->addSql('ALTER TABLE invoice_draft ADD CONSTRAINT FK_7BA6C621C76F1F52 FOREIGN KEY (deleted_by_id) REFERENCES contact (id)');
  26.         $this->addSql('CREATE INDEX IDX_7BA6C621C76F1F52 ON invoice_draft (deleted_by_id)');
  27.     }
  29.     public function down(Schema $schema): void
  30.     {
  31.         $this->addSql('ALTER TABLE invoice_draft_email_attachment DROP FOREIGN KEY FK_B5D547FCA832C1C9');
  32.         $this->addSql('ALTER TABLE invoice_draft_email_draft_attachment DROP FOREIGN KEY FK_203032CEE995DA98');
  33.         $this->addSql('DROP TABLE invoice_draft_email');
  34.         $this->addSql('DROP TABLE invoice_draft_email_attachment');
  35.         $this->addSql('DROP TABLE invoice_draft_email_draft');
  36.         $this->addSql('DROP TABLE invoice_draft_email_draft_attachment');
  37.         $this->addSql('ALTER TABLE invoice_draft DROP FOREIGN KEY FK_7BA6C621C76F1F52');
  38.         $this->addSql('DROP INDEX IDX_7BA6C621C76F1F52 ON invoice_draft');
  39.         $this->addSql('ALTER TABLE invoice_draft DROP deleted_by_id, DROP deleted_at');
  40.     }
  41. }