migrations/2021/03/Version20210306222210.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 Version20210306222210 extends AbstractMigration
  11. {
  12.     public function up(Schema $schema): void
  13.     {
  14.         $this->addSql('ALTER TABLE contact CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE address_id address_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_address_id)\', CHANGE email_id email_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_email_id)\'');
  15.         $this->addSql('ALTER TABLE contact_access CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_access_id)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE accessor_id accessor_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  16.         $this->addSql('ALTER TABLE contact_address CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_address_id)\'');
  17.         $this->addSql('ALTER TABLE contact_email CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_email_id)\'');
  18.         $this->addSql('ALTER TABLE contact_list CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_list_id)\', CHANGE owned_by_id owned_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  19.         $this->addSql('ALTER TABLE contact_list_entry CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_list_entry_id)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE contact_list_id contact_list_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_list_id)\'');
  20.         $this->addSql('ALTER TABLE contact_list_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_list_permission_id)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE contact_list_id contact_list_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_list_id)\'');
  21.         $this->addSql('ALTER TABLE contact_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_permission_id)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  22.         $this->addSql('ALTER TABLE contact_relationship_company_contact_person CHANGE company_id company_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE contact_person_id contact_person_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  23.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_relationship_customer_supplier_id)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  24.         $this->addSql('ALTER TABLE contact_relationship_employment CHANGE employer_id employer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE employee_id employee_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  25.         $this->addSql('ALTER TABLE document CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:document_id)\', CHANGE owned_by_id owned_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE parent_id parent_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:document_id)\'');
  26.         $this->addSql('ALTER TABLE document_dropbox_cursor CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:document_dropbox_cursor_id)\'');
  27.         $this->addSql('ALTER TABLE document_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:document_permission_id)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE document_id document_id BINARY(16) NOT NULL COMMENT \'(DC2Type:document_id)\'');
  28.         $this->addSql('ALTER TABLE document_template_permission CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  29.         $this->addSql('ALTER TABLE failed_legacy_synchronizer CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:failed_legacy_synchronizer_id)\'');
  30.         $this->addSql('ALTER TABLE invoice CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  31.         $this->addSql('ALTER TABLE invoice_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE modified_by_id modified_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE customer_id customer_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE deleted_by_id deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\'');
  32.         $this->addSql('ALTER TABLE invoice_draft_email CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\'');
  33.         $this->addSql('ALTER TABLE invoice_draft_email_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  34.         $this->addSql('ALTER TABLE invoice_email CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\'');
  35.         $this->addSql('ALTER TABLE invoice_email_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  36.         $this->addSql('ALTER TABLE invoice_payment CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  37.         $this->addSql('ALTER TABLE invoice_repeat_rule CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE updated_by_id updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE deleted_by_id deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  38.         $this->addSql('ALTER TABLE profit_calculation CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:profit_calculation_id)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE associated_contact_id associated_contact_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\'');
  39.         $this->addSql('ALTER TABLE profit_calculation_row CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:profit_calculation_item_id)\', CHANGE table_id table_id BINARY(16) NOT NULL COMMENT \'(DC2Type:profit_calculation_id)\', CHANGE date_time date_time DATETIME NOT NULL');
  40.         $this->addSql('ALTER TABLE user CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:user_id)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE invited_by_id invited_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:contact_id)\'');
  41.         $this->addSql('ALTER TABLE user_invitation CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:user_invitation_id)\', CHANGE invited_by_id invited_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\', CHANGE invited_contact_id invited_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:contact_id)\'');
  42.     }
  44.     public function down(Schema $schema): void
  45.     {
  46.         $this->addSql('ALTER TABLE contact CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE address_id address_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE email_id email_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  47.         $this->addSql('ALTER TABLE contact_access CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE accessor_id accessor_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  48.         $this->addSql('ALTER TABLE contact_address CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  49.         $this->addSql('ALTER TABLE contact_email CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  50.         $this->addSql('ALTER TABLE contact_list CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE owned_by_id owned_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  51.         $this->addSql('ALTER TABLE contact_list_entry CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_list_id contact_list_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  52.         $this->addSql('ALTER TABLE contact_list_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_list_id contact_list_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  53.         $this->addSql('ALTER TABLE contact_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  54.         $this->addSql('ALTER TABLE contact_relationship_company_contact_person CHANGE company_id company_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_person_id contact_person_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  55.         $this->addSql('ALTER TABLE contact_relationship_customer_supplier CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  56.         $this->addSql('ALTER TABLE contact_relationship_employment CHANGE employer_id employer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE employee_id employee_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  57.         $this->addSql('ALTER TABLE document CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE owned_by_id owned_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE parent_id parent_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  58.         $this->addSql('ALTER TABLE document_dropbox_cursor CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  59.         $this->addSql('ALTER TABLE document_permission CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE document_id document_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE authorized_contact_id authorized_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  60.         $this->addSql('ALTER TABLE document_template_permission CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  61.         $this->addSql('ALTER TABLE failed_legacy_synchronizer CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  62.         $this->addSql('ALTER TABLE invoice CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  63.         $this->addSql('ALTER TABLE invoice_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE modified_by_id modified_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE deleted_by_id deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE customer_id customer_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  64.         $this->addSql('ALTER TABLE invoice_draft_email CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  65.         $this->addSql('ALTER TABLE invoice_draft_email_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  66.         $this->addSql('ALTER TABLE invoice_email CHANGE created_by_id created_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  67.         $this->addSql('ALTER TABLE invoice_email_draft CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  68.         $this->addSql('ALTER TABLE invoice_payment CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  69.         $this->addSql('ALTER TABLE invoice_repeat_rule CHANGE created_by_id created_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE updated_by_id updated_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE deleted_by_id deleted_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE supplier_id supplier_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE customer_id customer_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  70.         $this->addSql('ALTER TABLE profit_calculation CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE associated_contact_id associated_contact_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  71.         $this->addSql('ALTER TABLE profit_calculation_row CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE table_id table_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE date_time date_time DATETIME DEFAULT NULL');
  72.         $this->addSql('ALTER TABLE user CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE contact_id contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE invited_by_id invited_by_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  73.         $this->addSql('ALTER TABLE user_invitation CHANGE id id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE invited_by_id invited_by_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\', CHANGE invited_contact_id invited_contact_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid_binary_ordered_time)\'');
  74.     }
  75. }