migrations/Version20231009121553.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 Version20231009121553 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 `crm_clients_additional_verification_files` (id INT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, file_id INT NOT NULL, code VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_D5F083AC19EB6921 (client_id), INDEX IDX_D5F083AC93CB796C (file_id), INDEX crm_clients_additional_verification_files_custom_idx (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24.         $this->addSql('ALTER TABLE `crm_clients_additional_verification_files` ADD CONSTRAINT FK_D5F083AC19EB6921 FOREIGN KEY (client_id) REFERENCES `crm_clients` (id)');
  25.         $this->addSql('ALTER TABLE `crm_clients_additional_verification_files` ADD CONSTRAINT FK_D5F083AC93CB796C FOREIGN KEY (file_id) REFERENCES `system_media` (id)');
  26.         $this->addSql('CREATE INDEX control_additional_cars_custom_idx ON control_additional_cars (car_number, car_number_latin)');
  27.         $this->addSql('CREATE INDEX control_individual_costs_cars_custom_idx ON control_individual_costs_cars (car_number, car_number_latin)');
  28.         $this->addSql('CREATE INDEX crm_agreements_custom_idx ON crm_agreements (number)');
  29.         $this->addSql('CREATE INDEX crm_calculations_custom_idx ON crm_calculations (car_number)');
  30.         $this->addSql('CREATE INDEX crm_calls_custom_idx ON crm_calls (external_call_id)');
  31.         $this->addSql('CREATE INDEX crm_cars_custom_idx ON crm_cars (name, car_number)');
  32.         $this->addSql('CREATE INDEX crm_clients_custom_idx ON crm_clients (phone, inn)');
  33.         $this->addSql('CREATE INDEX crm_clients_files_custom_idx ON crm_clients_files (code)');
  34.         $this->addSql('CREATE INDEX crm_clients_options_custom_idx ON crm_clients_options (code)');
  35.         $this->addSql('CREATE INDEX crm_contracts_custom_idx ON crm_contracts (number, car_number)');
  36.         $this->addSql('CREATE INDEX crm_equipments_applications_custom_idx ON crm_equipments_applications (car_number)');
  37.         $this->addSql('CREATE INDEX crm_payments_custom_idx ON crm_payments (number)');
  38.         $this->addSql('CREATE INDEX crm_printable_providers_custom_idx ON crm_printable_providers (object_class, task_class)');
  39.         $this->addSql('CREATE INDEX list_bonus_transaction_types_custom_idx ON list_bonus_transaction_types (code)');
  40.         $this->addSql('CREATE INDEX list_bonus_types_custom_idx ON list_bonus_types (code)');
  41.         $this->addSql('CREATE INDEX list_call_states_custom_idx ON list_call_states (code)');
  42.         $this->addSql('CREATE INDEX list_call_types_custom_idx ON list_call_types (code)');
  43.         $this->addSql('CREATE INDEX list_car_brands_custom_idx ON list_car_brands (code_autoria, code_opendata_bot)');
  44.         $this->addSql('CREATE INDEX list_car_models_custom_idx ON list_car_models (code_autoria, code_opendata_bot)');
  45.         $this->addSql('CREATE INDEX list_car_types_custom_idx ON list_car_types (code_autoria)');
  46.         $this->addSql('CREATE INDEX list_car_usage_reasons_custom_idx ON list_car_usage_reasons (code)');
  47.         $this->addSql('CREATE INDEX list_car_usage_types_custom_idx ON list_car_usage_types (code)');
  48.         $this->addSql('CREATE INDEX list_document_types_custom_idx ON list_document_types (oscpv_code)');
  49.         $this->addSql('CREATE INDEX list_exchange_rates_custom_idx ON list_exchange_rates (currency)');
  50.         $this->addSql('CREATE INDEX list_fuel_types_custom_idx ON list_fuel_types (code_autoria, code_opendata_bot)');
  51.         $this->addSql('CREATE INDEX list_insurance_products_custom_idx ON list_insurance_products (code)');
  52.         $this->addSql('CREATE INDEX list_message_events_custom_idx ON list_message_events (code)');
  53.         $this->addSql('CREATE INDEX list_message_types_custom_idx ON list_message_types (code)');
  54.         $this->addSql('CREATE INDEX list_payment_types_custom_idx ON list_payment_types (service_code)');
  55.         $this->addSql('CREATE INDEX list_sources_custom_idx ON list_sources (external_code)');
  56.         $this->addSql('CREATE INDEX list_task_types_custom_idx ON list_task_types (code)');
  57.         $this->addSql('CREATE INDEX list_tracking_systems_custom_idx ON list_tracking_systems (service_code)');
  58.         $this->addSql('CREATE INDEX list_verification_types_custom_idx ON list_verification_types (external_code)');
  59.         $this->addSql('CREATE INDEX oscpv_calculations_custom_idx ON oscpv_calculations (car_number)');
  60.         $this->addSql('CREATE INDEX oscpv_contracts_custom_idx ON oscpv_contracts (number, car_number)');
  61.         $this->addSql('CREATE INDEX oscpv_payments_custom_idx ON oscpv_payments (number)');
  62.         $this->addSql('CREATE INDEX service_event_log_types_custom_idx ON service_event_log_types (code)');
  63.     }
  65.     public function down(Schema $schema): void
  66.     {
  67.         // this down() migration is auto-generated, please modify it to your needs
  68.         $this->addSql('ALTER TABLE `crm_clients_additional_verification_files` DROP FOREIGN KEY FK_D5F083AC19EB6921');
  69.         $this->addSql('ALTER TABLE `crm_clients_additional_verification_files` DROP FOREIGN KEY FK_D5F083AC93CB796C');
  70.         $this->addSql('DROP TABLE `crm_clients_additional_verification_files`');
  71.         $this->addSql('DROP INDEX list_car_usage_reasons_custom_idx ON `list_car_usage_reasons`');
  72.         $this->addSql('DROP INDEX oscpv_contracts_custom_idx ON `oscpv_contracts`');
  73.         $this->addSql('DROP INDEX control_additional_cars_custom_idx ON `control_additional_cars`');
  74.         $this->addSql('DROP INDEX list_exchange_rates_custom_idx ON `list_exchange_rates`');
  75.         $this->addSql('DROP INDEX oscpv_payments_custom_idx ON `oscpv_payments`');
  76.         $this->addSql('DROP INDEX list_call_types_custom_idx ON `list_call_types`');
  77.         $this->addSql('DROP INDEX list_verification_types_custom_idx ON `list_verification_types`');
  78.         $this->addSql('DROP INDEX list_bonus_types_custom_idx ON `list_bonus_types`');
  79.         $this->addSql('DROP INDEX control_individual_costs_cars_custom_idx ON `control_individual_costs_cars`');
  80.         $this->addSql('DROP INDEX list_sources_custom_idx ON `list_sources`');
  81.         $this->addSql('DROP INDEX crm_agreements_custom_idx ON `crm_agreements`');
  82.         $this->addSql('DROP INDEX crm_calculations_custom_idx ON `crm_calculations`');
  83.         $this->addSql('DROP INDEX list_call_states_custom_idx ON `list_call_states`');
  84.         $this->addSql('DROP INDEX crm_equipments_applications_custom_idx ON `crm_equipments_applications`');
  85.         $this->addSql('DROP INDEX list_car_types_custom_idx ON `list_car_types`');
  86.         $this->addSql('DROP INDEX crm_clients_files_custom_idx ON `crm_clients_files`');
  87.         $this->addSql('DROP INDEX service_event_log_types_custom_idx ON `service_event_log_types`');
  88.         $this->addSql('DROP INDEX crm_cars_custom_idx ON `crm_cars`');
  89.         $this->addSql('DROP INDEX list_message_events_custom_idx ON `list_message_events`');
  90.         $this->addSql('DROP INDEX list_tracking_systems_custom_idx ON `list_tracking_systems`');
  91.         $this->addSql('DROP INDEX crm_calls_custom_idx ON `crm_calls`');
  92.         $this->addSql('DROP INDEX crm_printable_providers_custom_idx ON `crm_printable_providers`');
  93.         $this->addSql('DROP INDEX crm_clients_options_custom_idx ON `crm_clients_options`');
  94.         $this->addSql('DROP INDEX crm_contracts_custom_idx ON `crm_contracts`');
  95.         $this->addSql('DROP INDEX list_car_models_custom_idx ON `list_car_models`');
  96.         $this->addSql('DROP INDEX list_car_brands_custom_idx ON `list_car_brands`');
  97.         $this->addSql('DROP INDEX crm_clients_custom_idx ON `crm_clients`');
  98.         $this->addSql('DROP INDEX list_task_types_custom_idx ON `list_task_types`');
  99.         $this->addSql('DROP INDEX list_message_types_custom_idx ON `list_message_types`');
  100.         $this->addSql('DROP INDEX list_car_usage_types_custom_idx ON `list_car_usage_types`');
  101.         $this->addSql('DROP INDEX crm_payments_custom_idx ON `crm_payments`');
  102.         $this->addSql('DROP INDEX list_bonus_transaction_types_custom_idx ON `list_bonus_transaction_types`');
  103.         $this->addSql('DROP INDEX list_document_types_custom_idx ON `list_document_types`');
  104.         $this->addSql('DROP INDEX list_payment_types_custom_idx ON `list_payment_types`');
  105.         $this->addSql('DROP INDEX oscpv_calculations_custom_idx ON `oscpv_calculations`');
  106.         $this->addSql('DROP INDEX list_insurance_products_custom_idx ON `list_insurance_products`');
  107.         $this->addSql('DROP INDEX list_fuel_types_custom_idx ON `list_fuel_types`');
  108.     }
  109. }