migrations/Version20230426152301.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\DBAL\Types\Types;
  9. use Doctrine\Migrations\AbstractMigration;
  11. final class Version20230426152301 extends AbstractMigration
  12. {
  13.     public function getDescription(): string
  14.     {
  15.         return '';
  16.     }
  18.     public function preUp(Schema $schema): void
  19.     {
  20.         $this->connection->executeQuery('DELETE FROM member_application WHERE original_data_id IS NOT NULL');
  21.     }
  23.     public function up(Schema $schema): void
  24.     {
  25.         $this->skipIf(
  26.             true === $schema->getTable('member_application')->hasColumn('member_application_original_data_id'),
  27.             'The member_application_original_data_id field was already added in the member_application table!'
  28.         );
  30.         $memberApplicationTable = $schema->getTable('member_application');
  31.         if ($memberApplicationTable->hasIndex('uniq_member_application_original_data_id')) {
  32.             $memberApplicationTable->dropIndex('uniq_member_application_original_data_id');
  33.         }
  34.         $memberApplicationTable->dropColumn('original_data_id');
  36.         $originalDataTable = $schema->createTable('member_application_original_data');
  37.         $originalDataTable->addColumn('id', Types::INTEGER, ['notnull' => true]);
  38.         $originalDataTable->addColumn('member_application_id', Types::INTEGER, ['notnull' => true]);
  39.         $originalDataTable->addColumn('health_insurance_id', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  40.         $originalDataTable->addColumn('health_mutual_id', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  41.         $originalDataTable->addColumn('subscription_plan_id', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  42.         $originalDataTable->addColumn('company_id', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  43.         $originalDataTable->addColumn('resource_id', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  44.         $originalDataTable->addColumn('type', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  45.         $originalDataTable->addColumn('last_name', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  46.         $originalDataTable->addColumn('first_name', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  47.         $originalDataTable->addColumn('sex', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  48.         $originalDataTable->addColumn('birth_date', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  49.         $originalDataTable->addColumn('civil_status', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  50.         $originalDataTable->addColumn('civil_status_certificate', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  51.         $originalDataTable->addColumn('social_security_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  52.         $originalDataTable->addColumn('is_previously_cmcm_member', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  53.         $originalDataTable->addColumn('affiliate_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  54.         $originalDataTable->addColumn('phone_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  55.         $originalDataTable->addColumn('mobile_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  56.         $originalDataTable->addColumn('fax_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  57.         $originalDataTable->addColumn('email', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  58.         $originalDataTable->addColumn('iban', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  59.         $originalDataTable->addColumn('financial_institution', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  60.         $originalDataTable->addColumn('has_health_mutual', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  61.         $originalDataTable->addColumn('creditor_identification', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  62.         $originalDataTable->addColumn('mandate_reference', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  63.         $originalDataTable->addColumn('contract_number', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  64.         $originalDataTable->addColumn('comment', Types::TEXT, ['notnull' => false, 'default' => null]);
  65.         $originalDataTable->addColumn('is_all_data_accepted', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  66.         $originalDataTable->addColumn('payment_frequency', Types::STRING, ['length' => 30, 'notnull' => false, 'default' => null]);
  67.         $originalDataTable->addColumn('language', Types::STRING, ['length' => 10, 'notnull' => false, 'default' => null]);
  68.         $originalDataTable->addColumn('address_certificate', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  69.         $originalDataTable->addColumn('has_complementary_health_insurance', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  70.         $originalDataTable->addColumn('complementary_health_insurance_name', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  71.         $originalDataTable->addColumn('complementary_health_insurance_certificate', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  72.         $originalDataTable->addColumn('health_insurance_certificate', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  73.         $originalDataTable->addColumn('bank_certificate', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  74.         $originalDataTable->addColumn('bic', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  75.         $originalDataTable->addColumn('member_ship_start_at', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  76.         $originalDataTable->addColumn('insured_care_start_at', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  77.         $originalDataTable->addColumn('is_general_condition_accepted', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  78.         $originalDataTable->addColumn('is_gdpr_accepted', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  79.         $originalDataTable->addColumn('has_signed_with_company', Types::BOOLEAN, ['notnull' => true, 'default' => false]);
  80.         $originalDataTable->addColumn('created_at', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  81.         $originalDataTable->addColumn('deleted_at', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  82.         $originalDataTable->addColumn('company_employee_identifier', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  83.         $originalDataTable->addColumn('email_confirmed_at', Types::DATETIME_IMMUTABLE, ['notnull' => false, 'default' => null]);
  84.         $originalDataTable->addColumn('house_number', Types::STRING, ['length' => 10, 'notnull' => false, 'default' => null]);
  85.         $originalDataTable->addColumn('street_line', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  86.         $originalDataTable->addColumn('street_line2', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  87.         $originalDataTable->addColumn('postal_code', Types::STRING, ['length' => 10, 'notnull' => false, 'default' => null]);
  88.         $originalDataTable->addColumn('city', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  89.         $originalDataTable->addColumn('country', Types::STRING, ['length' => 255, 'notnull' => false, 'default' => null]);
  90.         $originalDataTable->addColumn('member_application_co_members', Types::JSON, ['notnull' => false, 'default' => null]);
  92.         $originalDataTable->addForeignKeyConstraint('member_application', ['member_application_id'], ['id'], [], 'fk_member_application_id');
  93.         $originalDataTable->addForeignKeyConstraint('health_insurance', ['health_insurance_id'], ['id'], [], 'fk_health_insurance_id');
  94.         $originalDataTable->addForeignKeyConstraint('health_mutual', ['health_mutual_id'], ['id'], [], 'fk_health_mutual_id');
  95.         $originalDataTable->addForeignKeyConstraint('subscription_plan', ['subscription_plan_id'], ['id'], [], 'fk_subscription_plan_id');
  96.         $originalDataTable->addForeignKeyConstraint('company', ['company_id'], ['id'], [], 'fk_company_id');
  98.         $originalDataTable->setPrimaryKey(['id'], 'uniq_member_application_original_data_id');
  99.         $originalDataTable->addUniqueIndex(['resource_id'], 'uniq_member_application_original_data_resource_id');
  100.         $originalDataTable->addUniqueIndex(['member_application_id'], 'uniq_member_application_original_data_member_application_id');
  102.         $memberApplicationTable->addUniqueIndex(['resource_id'], 'uniq_member_application_resource_id');
  103.         $memberApplicationTable->addIndex(['health_insurance_id'], 'uniq_member_application_original_data_health_insurance_id');
  104.         $memberApplicationTable->addIndex(['health_mutual_id'], 'uniq_member_application_original_data_health_mutual_id');
  105.         $memberApplicationTable->addIndex(['subscription_plan_id'], 'uniq_member_application_original_data_subscription_plan_id');
  106.         $memberApplicationTable->addIndex(['company_id'], 'uniq_member_application_original_data_company_id');
  107.     }
  109.     public function down(Schema $schema): void
  110.     {
  111.         // Not handled as update won't be downgraded.
  112. //        $this->skipIf(
  113. //            false === $schema->getTable('member_application')->hasColumn('original_data_id'),
  114. //            'The original_data_id field was already removed from the member_application table!'
  115. //        );
  116. //
  117. //        $schema->getTable('member_application')->dropColumn('original_data_id');
  118. //
  119. //        $schema->getTable('member_application')->dropIndex(
  120. //            'uniq_member_application_original_data_id'
  121. //        );
  122.     }
  123. }