migrations/Version20220808085501.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace CoreMigrations;
  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 Version20220808085501 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 INDEX deleted_at ON accounting_bundle__account (deleted_at)');
  24.         $this->addSql('CREATE INDEX created_at ON accounting_bundle__account (created_at)');
  25.         $this->addSql('CREATE INDEX updated_at ON accounting_bundle__account (updated_at)');
  26.         $this->addSql('CREATE FULLTEXT INDEX content ON accounting_bundle__account_translations (content)');
  27.         $this->addSql('CREATE INDEX deleted_at ON accounting_bundle__customer_account (deleted_at)');
  28.         $this->addSql('CREATE INDEX created_at ON accounting_bundle__customer_account (created_at)');
  29.         $this->addSql('CREATE INDEX updated_at ON accounting_bundle__customer_account (updated_at)');
  30.         $this->addSql('CREATE INDEX deleted_at ON accounting_bundle__product_account (deleted_at)');
  31.         $this->addSql('CREATE INDEX created_at ON accounting_bundle__product_account (created_at)');
  32.         $this->addSql('CREATE INDEX updated_at ON accounting_bundle__product_account (updated_at)');
  33.         $this->addSql('CREATE INDEX is_active ON categories_bundle__category (is_active)');
  34.         $this->addSql('CREATE INDEX deleted_at ON categories_bundle__category (deleted_at)');
  35.         $this->addSql('CREATE INDEX created_at ON categories_bundle__category (created_at)');
  36.         $this->addSql('CREATE INDEX updated_at ON categories_bundle__category (updated_at)');
  37.         $this->addSql('CREATE INDEX is_default ON categories_bundle__category_product (is_default)');
  38.         $this->addSql('CREATE INDEX deleted_at ON categories_bundle__category_product (deleted_at)');
  39.         $this->addSql('CREATE INDEX created_at ON categories_bundle__category_product (created_at)');
  40.         $this->addSql('CREATE INDEX updated_at ON categories_bundle__category_product (updated_at)');
  41.         $this->addSql('CREATE FULLTEXT INDEX content ON categories_bundle__category_translations (content)');
  42.         $this->addSql('CREATE INDEX deleted_at ON crm_bundle__opportunity (deleted_at)');
  43.         $this->addSql('CREATE INDEX updated_at ON crm_bundle__opportunity (updated_at)');
  44.         $this->addSql('CREATE INDEX deleted_at ON crm_bundle__opportunity_activity (deleted_at)');
  45.         $this->addSql('CREATE INDEX created_at ON crm_bundle__opportunity_activity (created_at)');
  46.         $this->addSql('CREATE INDEX updated_at ON crm_bundle__opportunity_activity (updated_at)');
  47.         $this->addSql('CREATE INDEX deleted_at ON crm_bundle__opportunity_document (deleted_at)');
  48.         $this->addSql('CREATE INDEX created_at ON crm_bundle__opportunity_document (created_at)');
  49.         $this->addSql('CREATE INDEX updated_at ON crm_bundle__opportunity_document (updated_at)');
  50.         $this->addSql('CREATE INDEX deleted_at ON crm_bundle__opportunity_state (deleted_at)');
  51.         $this->addSql('CREATE INDEX created_at ON crm_bundle__opportunity_state (created_at)');
  52.         $this->addSql('CREATE INDEX updated_at ON crm_bundle__opportunity_state (updated_at)');
  53.         $this->addSql('CREATE FULLTEXT INDEX content ON crm_bundle__opportunity_state_translations (content)');
  54.         $this->addSql('CREATE INDEX deleted_at ON crm_bundle__recommendation_type (deleted_at)');
  55.         $this->addSql('CREATE INDEX created_at ON crm_bundle__recommendation_type (created_at)');
  56.         $this->addSql('CREATE INDEX updated_at ON crm_bundle__recommendation_type (updated_at)');
  57.         $this->addSql('CREATE FULLTEXT INDEX content ON crm_bundle__recommendation_type_translations (content)');
  58.         $this->addSql('CREATE INDEX name ON customers_bundle__customer (name)');
  59.         $this->addSql('CREATE INDEX firstname ON customers_bundle__customer (firstname)');
  60.         $this->addSql('CREATE INDEX lastname ON customers_bundle__customer (lastname)');
  61.         $this->addSql('CREATE INDEX postcode ON customers_bundle__customer (postcode)');
  62.         $this->addSql('CREATE INDEX city ON customers_bundle__customer (city)');
  63.         $this->addSql('CREATE INDEX phone ON customers_bundle__customer (phone)');
  64.         $this->addSql('CREATE INDEX phone_mobile ON customers_bundle__customer (phone_mobile)');
  65.         $this->addSql('CREATE INDEX email ON customers_bundle__customer (email)');
  66.         $this->addSql('CREATE INDEX deleted_at ON customers_bundle__customer (deleted_at)');
  67.         $this->addSql('CREATE INDEX created_at ON customers_bundle__customer (created_at)');
  68.         $this->addSql('CREATE INDEX updated_at ON customers_bundle__customer (updated_at)');
  69.         $this->addSql('CREATE INDEX name ON customers_bundle__customer_group (name)');
  70.         $this->addSql('CREATE INDEX deleted_at ON customers_bundle__customer_group (deleted_at)');
  71.         $this->addSql('CREATE INDEX created_at ON customers_bundle__customer_group (created_at)');
  72.         $this->addSql('CREATE INDEX updated_at ON customers_bundle__customer_group (updated_at)');
  73.         $this->addSql('CREATE FULLTEXT INDEX content ON customers_bundle__customer_group_translations (content)');
  74.         $this->addSql('CREATE INDEX name ON customers_bundle__customer_type (name)');
  75.         $this->addSql('CREATE INDEX deleted_at ON customers_bundle__customer_type (deleted_at)');
  76.         $this->addSql('CREATE INDEX created_at ON customers_bundle__customer_type (created_at)');
  77.         $this->addSql('CREATE INDEX updated_at ON customers_bundle__customer_type (updated_at)');
  78.         $this->addSql('CREATE FULLTEXT INDEX content ON customers_bundle__customer_type_translations (content)');
  79.         $this->addSql('CREATE INDEX status_name ON import_products_bundle__import (status_name)');
  80.         $this->addSql('CREATE INDEX nb_products_success ON import_products_bundle__import (nb_products_success)');
  81.         $this->addSql('CREATE INDEX nb_products_error ON import_products_bundle__import (nb_products_error)');
  82.         $this->addSql('CREATE INDEX deleted_at ON import_products_bundle__import (deleted_at)');
  83.         $this->addSql('CREATE INDEX created_at ON import_products_bundle__import (created_at)');
  84.         $this->addSql('CREATE INDEX updated_at ON import_products_bundle__import (updated_at)');
  85.         $this->addSql('CREATE INDEX deleted_at ON import_products_bundle__import_error (deleted_at)');
  86.         $this->addSql('CREATE INDEX created_at ON import_products_bundle__import_error (created_at)');
  87.         $this->addSql('CREATE INDEX updated_at ON import_products_bundle__import_error (updated_at)');
  88.         $this->addSql('CREATE INDEX source ON labels_bundle__label (source)');
  89.         $this->addSql('CREATE INDEX attribute ON labels_bundle__label (attribute)');
  90.         $this->addSql('CREATE INDEX deleted_at ON labels_bundle__label (deleted_at)');
  91.         $this->addSql('CREATE INDEX created_at ON labels_bundle__label (created_at)');
  92.         $this->addSql('CREATE INDEX updated_at ON labels_bundle__label (updated_at)');
  93.         $this->addSql('CREATE FULLTEXT INDEX content ON labels_bundle__label_translations (content)');
  94.         $this->addSql('CREATE INDEX deleted_at ON labels_bundle__printer (deleted_at)');
  95.         $this->addSql('CREATE INDEX created_at ON labels_bundle__printer (created_at)');
  96.         $this->addSql('CREATE INDEX updated_at ON labels_bundle__printer (updated_at)');
  97.         $this->addSql('CREATE INDEX is_default ON labels_bundle__template (is_default)');
  98.         $this->addSql('CREATE INDEX deleted_at ON labels_bundle__template (deleted_at)');
  99.         $this->addSql('CREATE INDEX created_at ON labels_bundle__template (created_at)');
  100.         $this->addSql('CREATE INDEX updated_at ON labels_bundle__template (updated_at)');
  101.         $this->addSql('CREATE INDEX deleted_at ON manufacturing_bundle__product_options (deleted_at)');
  102.         $this->addSql('CREATE INDEX created_at ON manufacturing_bundle__product_options (created_at)');
  103.         $this->addSql('CREATE INDEX updated_at ON manufacturing_bundle__product_options (updated_at)');
  104.         $this->addSql('CREATE INDEX deleted_at ON product_returns_bundle__converted_document (deleted_at)');
  105.         $this->addSql('CREATE INDEX created_at ON product_returns_bundle__converted_document (created_at)');
  106.         $this->addSql('CREATE INDEX updated_at ON product_returns_bundle__converted_document (updated_at)');
  107.         $this->addSql('CREATE INDEX reference ON product_returns_bundle__product_return (reference)');
  108.         $this->addSql('CREATE INDEX deleted_at ON product_returns_bundle__product_return (deleted_at)');
  109.         $this->addSql('CREATE INDEX updated_at ON product_returns_bundle__product_return (updated_at)');
  110.         $this->addSql('CREATE INDEX created_at ON product_returns_bundle__product_return_line (created_at)');
  111.         $this->addSql('CREATE INDEX updated_at ON product_returns_bundle__product_return_line (updated_at)');
  112.         $this->addSql('CREATE INDEX deleted_at ON product_returns_bundle__product_return_line (deleted_at)');
  113.         $this->addSql('CREATE INDEX deleted_at ON product_returns_bundle__return_state (deleted_at)');
  114.         $this->addSql('CREATE INDEX created_at ON product_returns_bundle__return_state (created_at)');
  115.         $this->addSql('CREATE INDEX updated_at ON product_returns_bundle__return_state (updated_at)');
  116.         $this->addSql('CREATE FULLTEXT INDEX content ON product_returns_bundle__return_state_translations (content)');
  117.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__attribute (deleted_at)');
  118.         $this->addSql('CREATE INDEX created_at ON products_bundle__attribute (created_at)');
  119.         $this->addSql('CREATE INDEX updated_at ON products_bundle__attribute (updated_at)');
  120.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__attribute_group (deleted_at)');
  121.         $this->addSql('CREATE INDEX created_at ON products_bundle__attribute_group (created_at)');
  122.         $this->addSql('CREATE INDEX updated_at ON products_bundle__attribute_group (updated_at)');
  123.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__attribute_group_translations (content)');
  124.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__attribute_translations (content)');
  125.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__brand (deleted_at)');
  126.         $this->addSql('CREATE INDEX created_at ON products_bundle__brand (created_at)');
  127.         $this->addSql('CREATE INDEX updated_at ON products_bundle__brand (updated_at)');
  128.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__declination (deleted_at)');
  129.         $this->addSql('CREATE INDEX created_at ON products_bundle__declination (created_at)');
  130.         $this->addSql('CREATE INDEX updated_at ON products_bundle__declination (updated_at)');
  131.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__declination_attribute (deleted_at)');
  132.         $this->addSql('CREATE INDEX created_at ON products_bundle__declination_attribute (created_at)');
  133.         $this->addSql('CREATE INDEX updated_at ON products_bundle__declination_attribute (updated_at)');
  134.         $this->addSql('CREATE INDEX is_active ON products_bundle__eco_part (is_active)');
  135.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__eco_part (deleted_at)');
  136.         $this->addSql('CREATE INDEX created_at ON products_bundle__eco_part (created_at)');
  137.         $this->addSql('CREATE INDEX updated_at ON products_bundle__eco_part (updated_at)');
  138.         $this->addSql('CREATE INDEX is_active ON products_bundle__eco_part_group (is_active)');
  139.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__eco_part_group (deleted_at)');
  140.         $this->addSql('CREATE INDEX created_at ON products_bundle__eco_part_group (created_at)');
  141.         $this->addSql('CREATE INDEX updated_at ON products_bundle__eco_part_group (updated_at)');
  142.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__eco_part_group_translations (content)');
  143.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__eco_part_translations (content)');
  144.         $this->addSql('CREATE INDEX is_active ON products_bundle__product (is_active)');
  145.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__product (deleted_at)');
  146.         $this->addSql('CREATE INDEX created_at ON products_bundle__product (created_at)');
  147.         $this->addSql('CREATE INDEX updated_at ON products_bundle__product (updated_at)');
  148.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__product_translations (content)');
  149.         $this->addSql('CREATE INDEX is_active ON products_bundle__product_type (is_active)');
  150.         $this->addSql('CREATE INDEX deleted_at ON products_bundle__product_type (deleted_at)');
  151.         $this->addSql('CREATE INDEX created_at ON products_bundle__product_type (created_at)');
  152.         $this->addSql('CREATE INDEX updated_at ON products_bundle__product_type (updated_at)');
  153.         $this->addSql('CREATE FULLTEXT INDEX content ON products_bundle__product_type_translations (content)');
  154.         $this->addSql('CREATE INDEX is_active ON sales_bundle__additional_pdf (is_active)');
  155.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__additional_pdf (deleted_at)');
  156.         $this->addSql('CREATE INDEX created_at ON sales_bundle__additional_pdf (created_at)');
  157.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__additional_pdf (updated_at)');
  158.         $this->addSql('CREATE INDEX is_active ON sales_bundle__bank (is_active)');
  159.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__bank (deleted_at)');
  160.         $this->addSql('CREATE INDEX created_at ON sales_bundle__bank (created_at)');
  161.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__bank (updated_at)');
  162.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__credit_note (deleted_at)');
  163.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__credit_note (updated_at)');
  164.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__credit_note_line (deleted_at)');
  165.         $this->addSql('CREATE INDEX created_at ON sales_bundle__credit_note_line (created_at)');
  166.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__credit_note_line (updated_at)');
  167.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__customer_options (deleted_at)');
  168.         $this->addSql('CREATE INDEX created_at ON sales_bundle__customer_options (created_at)');
  169.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__customer_options (updated_at)');
  170.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__delivery_note (deleted_at)');
  171.         $this->addSql('CREATE INDEX created_at ON sales_bundle__delivery_note (created_at)');
  172.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__delivery_note (updated_at)');
  173.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__delivery_note_line (deleted_at)');
  174.         $this->addSql('CREATE INDEX created_at ON sales_bundle__delivery_note_line (created_at)');
  175.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__delivery_note_line (updated_at)');
  176.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__document_payment (deleted_at)');
  177.         $this->addSql('CREATE INDEX created_at ON sales_bundle__document_payment (created_at)');
  178.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__document_payment (updated_at)');
  179.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__invoice (deleted_at)');
  180.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__invoice (updated_at)');
  181.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__invoice_line (deleted_at)');
  182.         $this->addSql('CREATE INDEX created_at ON sales_bundle__invoice_line (created_at)');
  183.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__invoice_line (updated_at)');
  184.         $this->addSql('CREATE INDEX is_active ON sales_bundle__line_type (is_active)');
  185.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__line_type (deleted_at)');
  186.         $this->addSql('CREATE INDEX created_at ON sales_bundle__line_type (created_at)');
  187.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__line_type (updated_at)');
  188.         $this->addSql('CREATE FULLTEXT INDEX content ON sales_bundle__line_type_translations (content)');
  189.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__order (deleted_at)');
  190.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__order (updated_at)');
  191.         $this->addSql('CREATE INDEX created_at ON sales_bundle__order_history (created_at)');
  192.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__order_history (updated_at)');
  193.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__order_line (deleted_at)');
  194.         $this->addSql('CREATE INDEX created_at ON sales_bundle__order_line (created_at)');
  195.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__order_line (updated_at)');
  196.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__order_state (deleted_at)');
  197.         $this->addSql('CREATE INDEX created_at ON sales_bundle__order_state (created_at)');
  198.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__order_state (updated_at)');
  199.         $this->addSql('CREATE FULLTEXT INDEX content ON sales_bundle__order_state_translations (content)');
  200.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__payment (deleted_at)');
  201.         $this->addSql('CREATE INDEX created_at ON sales_bundle__payment (created_at)');
  202.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__payment (updated_at)');
  203.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__payment_method (deleted_at)');
  204.         $this->addSql('CREATE INDEX created_at ON sales_bundle__payment_method (created_at)');
  205.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__payment_method (updated_at)');
  206.         $this->addSql('CREATE FULLTEXT INDEX content ON sales_bundle__payment_method_translations (content)');
  207.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__payment_term (deleted_at)');
  208.         $this->addSql('CREATE INDEX created_at ON sales_bundle__payment_term (created_at)');
  209.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__payment_term (updated_at)');
  210.         $this->addSql('CREATE FULLTEXT INDEX content ON sales_bundle__payment_term_translations (content)');
  211.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__quotation (deleted_at)');
  212.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__quotation (updated_at)');
  213.         $this->addSql('CREATE INDEX deleted_at ON sales_bundle__quotation_line (deleted_at)');
  214.         $this->addSql('CREATE INDEX created_at ON sales_bundle__quotation_line (created_at)');
  215.         $this->addSql('CREATE INDEX updated_at ON sales_bundle__quotation_line (updated_at)');
  216.         $this->addSql('CREATE INDEX is_active ON shipments_bundle__burst (is_active)');
  217.         $this->addSql('CREATE INDEX deleted_at ON shipments_bundle__burst (deleted_at)');
  218.         $this->addSql('CREATE INDEX created_at ON shipments_bundle__burst (created_at)');
  219.         $this->addSql('CREATE INDEX updated_at ON shipments_bundle__burst (updated_at)');
  220.         $this->addSql('CREATE INDEX deleted_at ON shipments_bundle__carrier (deleted_at)');
  221.         $this->addSql('CREATE INDEX created_at ON shipments_bundle__carrier (created_at)');
  222.         $this->addSql('CREATE INDEX updated_at ON shipments_bundle__carrier (updated_at)');
  223.         $this->addSql('CREATE INDEX deleted_at ON shipments_bundle__order_options (deleted_at)');
  224.         $this->addSql('CREATE INDEX created_at ON shipments_bundle__order_options (created_at)');
  225.         $this->addSql('CREATE INDEX updated_at ON shipments_bundle__order_options (updated_at)');
  226.         $this->addSql('CREATE INDEX deleted_at ON shipments_bundle__printer (deleted_at)');
  227.         $this->addSql('CREATE INDEX created_at ON shipments_bundle__printer (created_at)');
  228.         $this->addSql('CREATE INDEX updated_at ON shipments_bundle__printer (updated_at)');
  229.         $this->addSql('CREATE INDEX deleted_at ON shipments_bundle__time_delta (deleted_at)');
  230.         $this->addSql('CREATE INDEX created_at ON shipments_bundle__time_delta (created_at)');
  231.         $this->addSql('CREATE INDEX updated_at ON shipments_bundle__time_delta (updated_at)');
  232.         $this->addSql('CREATE FULLTEXT INDEX content ON shipments_bundle__time_delta_translations (content)');
  233.         $this->addSql('CREATE INDEX name ON stocks_bundle__date_type (name)');
  234.         $this->addSql('CREATE INDEX long_name ON stocks_bundle__date_type (long_name)');
  235.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__date_type (deleted_at)');
  236.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__date_type (created_at)');
  237.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__date_type (updated_at)');
  238.         $this->addSql('CREATE FULLTEXT INDEX content ON stocks_bundle__date_type_translations (content)');
  239.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__location (deleted_at)');
  240.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__location (created_at)');
  241.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__location (updated_at)');
  242.         $this->addSql('ALTER TABLE stocks_bundle__location RENAME INDEX warehouse_id TO IDX_A4AB83FF5080ECDE');
  243.         $this->addSql('DROP INDEX product_id ON stocks_bundle__product_configuration');
  244.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__product_configuration (deleted_at)');
  245.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__product_configuration (created_at)');
  246.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__product_configuration (updated_at)');
  247.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__stock_location (deleted_at)');
  248.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_location (created_at)');
  249.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_location (updated_at)');
  250.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX location_id TO IDX_BBA57E0664D218E');
  251.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX sub_location_id TO IDX_BBA57E06E3B45410');
  252.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX date_type_id TO IDX_BBA57E06FCAB8B6E');
  253.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX stock_product_id TO IDX_BBA57E06EBCD91F6');
  254.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__stock_movement (deleted_at)');
  255.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_movement (created_at)');
  256.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_movement (updated_at)');
  257.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX stock_movement_reason_id TO IDX_11E6623AD0E7D5DE');
  258.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX stock_quantity_id TO IDX_11E6623AA145ECC8');
  259.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX location_id TO IDX_11E6623A64D218E');
  260.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX sub_location_id TO IDX_11E6623AE3B45410');
  261.         $this->addSql('CREATE INDEX name ON stocks_bundle__stock_movement_reason (name)');
  262.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__stock_movement_reason (deleted_at)');
  263.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_movement_reason (created_at)');
  264.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_movement_reason (updated_at)');
  265.         $this->addSql('CREATE FULLTEXT INDEX content ON stocks_bundle__stock_movement_reason_translations (content)');
  266.         $this->addSql('DROP INDEX order_line_id ON stocks_bundle__stock_order_line');
  267.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_order_line (created_at)');
  268.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_order_line (updated_at)');
  269.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line RENAME INDEX stock_product_id TO IDX_C168A566EBCD91F6');
  270.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_order_line_location (created_at)');
  271.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_order_line_location (updated_at)');
  272.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line_location RENAME INDEX stock_order_line_id TO IDX_DF6712FE3F9EF6ED');
  273.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line_location RENAME INDEX stock_location_id TO IDX_DF6712FED98387BA');
  274.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__stock_product (deleted_at)');
  275.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_product (created_at)');
  276.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_product (updated_at)');
  277.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX product_id TO IDX_3D03C4604584665A');
  278.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX declination_id TO IDX_3D03C4609941A932');
  279.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX warehouse_id TO IDX_3D03C4605080ECDE');
  280.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__stock_quantity (deleted_at)');
  281.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__stock_quantity (created_at)');
  282.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__stock_quantity (updated_at)');
  283.         $this->addSql('ALTER TABLE stocks_bundle__stock_quantity RENAME INDEX currency_id TO IDX_7AC8E1FB38248176');
  284.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__sub_location (deleted_at)');
  285.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__sub_location (created_at)');
  286.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__sub_location (updated_at)');
  287.         $this->addSql('ALTER TABLE stocks_bundle__sub_location RENAME INDEX location_id TO IDX_69B6540664D218E');
  288.         $this->addSql('CREATE INDEX deleted_at ON stocks_bundle__warehouse (deleted_at)');
  289.         $this->addSql('CREATE INDEX created_at ON stocks_bundle__warehouse (created_at)');
  290.         $this->addSql('CREATE INDEX updated_at ON stocks_bundle__warehouse (updated_at)');
  291.         $this->addSql('CREATE INDEX is_default ON suppliers_bundle__product_supplier (is_default)');
  292.         $this->addSql('CREATE INDEX deleted_at ON suppliers_bundle__product_supplier (deleted_at)');
  293.         $this->addSql('CREATE INDEX created_at ON suppliers_bundle__product_supplier (created_at)');
  294.         $this->addSql('CREATE INDEX updated_at ON suppliers_bundle__product_supplier (updated_at)');
  295.         $this->addSql('CREATE INDEX is_active ON suppliers_bundle__supplier (is_active)');
  296.         $this->addSql('CREATE INDEX deleted_at ON suppliers_bundle__supplier (deleted_at)');
  297.         $this->addSql('CREATE INDEX created_at ON suppliers_bundle__supplier (created_at)');
  298.         $this->addSql('CREATE INDEX updated_at ON suppliers_bundle__supplier (updated_at)');
  299.         $this->addSql('CREATE INDEX deleted_at ON suppliers_bundle__supplier_address (deleted_at)');
  300.         $this->addSql('CREATE INDEX created_at ON suppliers_bundle__supplier_address (created_at)');
  301.         $this->addSql('CREATE INDEX updated_at ON suppliers_bundle__supplier_address (updated_at)');
  302.         $this->addSql('CREATE INDEX deleted_at ON suppliers_bundle__supplier_contact (deleted_at)');
  303.         $this->addSql('CREATE INDEX created_at ON suppliers_bundle__supplier_contact (created_at)');
  304.         $this->addSql('CREATE INDEX updated_at ON suppliers_bundle__supplier_contact (updated_at)');
  305.         $this->addSql('CREATE INDEX deleted_at ON suppliers_bundle__supplier_type (deleted_at)');
  306.         $this->addSql('CREATE INDEX created_at ON suppliers_bundle__supplier_type (created_at)');
  307.         $this->addSql('CREATE INDEX updated_at ON suppliers_bundle__supplier_type (updated_at)');
  308.         $this->addSql('CREATE FULLTEXT INDEX content ON suppliers_bundle__supplier_type_translations (content)');
  309.         $this->addSql('CREATE INDEX reference ON suppliers_orders_bundle__receipt_note (reference)');
  310.         $this->addSql('CREATE INDEX deleted_at ON suppliers_orders_bundle__receipt_note (deleted_at)');
  311.         $this->addSql('CREATE INDEX created_at ON suppliers_orders_bundle__receipt_note (created_at)');
  312.         $this->addSql('CREATE INDEX updated_at ON suppliers_orders_bundle__receipt_note (updated_at)');
  313.         $this->addSql('CREATE INDEX deleted_at ON suppliers_orders_bundle__receipt_note_line (deleted_at)');
  314.         $this->addSql('CREATE INDEX created_at ON suppliers_orders_bundle__receipt_note_line (created_at)');
  315.         $this->addSql('CREATE INDEX updated_at ON suppliers_orders_bundle__receipt_note_line (updated_at)');
  316.         $this->addSql('CREATE INDEX reference ON suppliers_orders_bundle__supplier_order (reference)');
  317.         $this->addSql('CREATE INDEX internal_reference ON suppliers_orders_bundle__supplier_order (internal_reference)');
  318.         $this->addSql('CREATE INDEX external_reference ON suppliers_orders_bundle__supplier_order (external_reference)');
  319.         $this->addSql('CREATE INDEX total_amount ON suppliers_orders_bundle__supplier_order (total_amount)');
  320.         $this->addSql('CREATE INDEX deleted_at ON suppliers_orders_bundle__supplier_order (deleted_at)');
  321.         $this->addSql('CREATE INDEX validated_at ON suppliers_orders_bundle__supplier_order (validated_at)');
  322.         $this->addSql('CREATE INDEX created_at ON suppliers_orders_bundle__supplier_order (created_at)');
  323.         $this->addSql('CREATE INDEX updated_at ON suppliers_orders_bundle__supplier_order (updated_at)');
  324.         $this->addSql('CREATE INDEX deleted_at ON suppliers_orders_bundle__supplier_order_line (deleted_at)');
  325.         $this->addSql('CREATE INDEX created_at ON suppliers_orders_bundle__supplier_order_line (created_at)');
  326.         $this->addSql('CREATE INDEX updated_at ON suppliers_orders_bundle__supplier_order_line (updated_at)');
  327.     }
  329.     public function down(Schema $schema): void
  330.     {
  331.         // this down() migration is auto-generated, please modify it to your needs
  332.         $this->addSql('DROP INDEX deleted_at ON accounting_bundle__account');
  333.         $this->addSql('DROP INDEX created_at ON accounting_bundle__account');
  334.         $this->addSql('DROP INDEX updated_at ON accounting_bundle__account');
  335.         $this->addSql('DROP INDEX content ON accounting_bundle__account_translations');
  336.         $this->addSql('DROP INDEX deleted_at ON accounting_bundle__customer_account');
  337.         $this->addSql('DROP INDEX created_at ON accounting_bundle__customer_account');
  338.         $this->addSql('DROP INDEX updated_at ON accounting_bundle__customer_account');
  339.         $this->addSql('DROP INDEX deleted_at ON accounting_bundle__product_account');
  340.         $this->addSql('DROP INDEX created_at ON accounting_bundle__product_account');
  341.         $this->addSql('DROP INDEX updated_at ON accounting_bundle__product_account');
  342.         $this->addSql('DROP INDEX is_active ON categories_bundle__category');
  343.         $this->addSql('DROP INDEX deleted_at ON categories_bundle__category');
  344.         $this->addSql('DROP INDEX created_at ON categories_bundle__category');
  345.         $this->addSql('DROP INDEX updated_at ON categories_bundle__category');
  346.         $this->addSql('DROP INDEX is_default ON categories_bundle__category_product');
  347.         $this->addSql('DROP INDEX deleted_at ON categories_bundle__category_product');
  348.         $this->addSql('DROP INDEX created_at ON categories_bundle__category_product');
  349.         $this->addSql('DROP INDEX updated_at ON categories_bundle__category_product');
  350.         $this->addSql('DROP INDEX content ON categories_bundle__category_translations');
  351.         $this->addSql('DROP INDEX deleted_at ON crm_bundle__opportunity');
  352.         $this->addSql('DROP INDEX updated_at ON crm_bundle__opportunity');
  353.         $this->addSql('DROP INDEX deleted_at ON crm_bundle__opportunity_activity');
  354.         $this->addSql('DROP INDEX created_at ON crm_bundle__opportunity_activity');
  355.         $this->addSql('DROP INDEX updated_at ON crm_bundle__opportunity_activity');
  356.         $this->addSql('DROP INDEX deleted_at ON crm_bundle__opportunity_document');
  357.         $this->addSql('DROP INDEX created_at ON crm_bundle__opportunity_document');
  358.         $this->addSql('DROP INDEX updated_at ON crm_bundle__opportunity_document');
  359.         $this->addSql('DROP INDEX deleted_at ON crm_bundle__opportunity_state');
  360.         $this->addSql('DROP INDEX created_at ON crm_bundle__opportunity_state');
  361.         $this->addSql('DROP INDEX updated_at ON crm_bundle__opportunity_state');
  362.         $this->addSql('DROP INDEX content ON crm_bundle__opportunity_state_translations');
  363.         $this->addSql('DROP INDEX deleted_at ON crm_bundle__recommendation_type');
  364.         $this->addSql('DROP INDEX created_at ON crm_bundle__recommendation_type');
  365.         $this->addSql('DROP INDEX updated_at ON crm_bundle__recommendation_type');
  366.         $this->addSql('DROP INDEX content ON crm_bundle__recommendation_type_translations');
  367.         $this->addSql('DROP INDEX name ON customers_bundle__customer');
  368.         $this->addSql('DROP INDEX firstname ON customers_bundle__customer');
  369.         $this->addSql('DROP INDEX lastname ON customers_bundle__customer');
  370.         $this->addSql('DROP INDEX postcode ON customers_bundle__customer');
  371.         $this->addSql('DROP INDEX city ON customers_bundle__customer');
  372.         $this->addSql('DROP INDEX phone ON customers_bundle__customer');
  373.         $this->addSql('DROP INDEX phone_mobile ON customers_bundle__customer');
  374.         $this->addSql('DROP INDEX email ON customers_bundle__customer');
  375.         $this->addSql('DROP INDEX deleted_at ON customers_bundle__customer');
  376.         $this->addSql('DROP INDEX created_at ON customers_bundle__customer');
  377.         $this->addSql('DROP INDEX updated_at ON customers_bundle__customer');
  378.         $this->addSql('DROP INDEX name ON customers_bundle__customer_group');
  379.         $this->addSql('DROP INDEX deleted_at ON customers_bundle__customer_group');
  380.         $this->addSql('DROP INDEX created_at ON customers_bundle__customer_group');
  381.         $this->addSql('DROP INDEX updated_at ON customers_bundle__customer_group');
  382.         $this->addSql('DROP INDEX content ON customers_bundle__customer_group_translations');
  383.         $this->addSql('DROP INDEX name ON customers_bundle__customer_type');
  384.         $this->addSql('DROP INDEX deleted_at ON customers_bundle__customer_type');
  385.         $this->addSql('DROP INDEX created_at ON customers_bundle__customer_type');
  386.         $this->addSql('DROP INDEX updated_at ON customers_bundle__customer_type');
  387.         $this->addSql('DROP INDEX content ON customers_bundle__customer_type_translations');
  388.         $this->addSql('DROP INDEX status_name ON import_products_bundle__import');
  389.         $this->addSql('DROP INDEX nb_products_success ON import_products_bundle__import');
  390.         $this->addSql('DROP INDEX nb_products_error ON import_products_bundle__import');
  391.         $this->addSql('DROP INDEX deleted_at ON import_products_bundle__import');
  392.         $this->addSql('DROP INDEX created_at ON import_products_bundle__import');
  393.         $this->addSql('DROP INDEX updated_at ON import_products_bundle__import');
  394.         $this->addSql('DROP INDEX deleted_at ON import_products_bundle__import_error');
  395.         $this->addSql('DROP INDEX created_at ON import_products_bundle__import_error');
  396.         $this->addSql('DROP INDEX updated_at ON import_products_bundle__import_error');
  397.         $this->addSql('DROP INDEX source ON labels_bundle__label');
  398.         $this->addSql('DROP INDEX attribute ON labels_bundle__label');
  399.         $this->addSql('DROP INDEX deleted_at ON labels_bundle__label');
  400.         $this->addSql('DROP INDEX created_at ON labels_bundle__label');
  401.         $this->addSql('DROP INDEX updated_at ON labels_bundle__label');
  402.         $this->addSql('DROP INDEX content ON labels_bundle__label_translations');
  403.         $this->addSql('DROP INDEX deleted_at ON labels_bundle__printer');
  404.         $this->addSql('DROP INDEX created_at ON labels_bundle__printer');
  405.         $this->addSql('DROP INDEX updated_at ON labels_bundle__printer');
  406.         $this->addSql('DROP INDEX is_default ON labels_bundle__template');
  407.         $this->addSql('DROP INDEX deleted_at ON labels_bundle__template');
  408.         $this->addSql('DROP INDEX created_at ON labels_bundle__template');
  409.         $this->addSql('DROP INDEX updated_at ON labels_bundle__template');
  410.         $this->addSql('DROP INDEX deleted_at ON manufacturing_bundle__product_options');
  411.         $this->addSql('DROP INDEX created_at ON manufacturing_bundle__product_options');
  412.         $this->addSql('DROP INDEX updated_at ON manufacturing_bundle__product_options');
  413.         $this->addSql('DROP INDEX deleted_at ON product_returns_bundle__converted_document');
  414.         $this->addSql('DROP INDEX created_at ON product_returns_bundle__converted_document');
  415.         $this->addSql('DROP INDEX updated_at ON product_returns_bundle__converted_document');
  416.         $this->addSql('DROP INDEX reference ON product_returns_bundle__product_return');
  417.         $this->addSql('DROP INDEX deleted_at ON product_returns_bundle__product_return');
  418.         $this->addSql('DROP INDEX updated_at ON product_returns_bundle__product_return');
  419.         $this->addSql('DROP INDEX created_at ON product_returns_bundle__product_return_line');
  420.         $this->addSql('DROP INDEX updated_at ON product_returns_bundle__product_return_line');
  421.         $this->addSql('DROP INDEX deleted_at ON product_returns_bundle__product_return_line');
  422.         $this->addSql('DROP INDEX deleted_at ON product_returns_bundle__return_state');
  423.         $this->addSql('DROP INDEX created_at ON product_returns_bundle__return_state');
  424.         $this->addSql('DROP INDEX updated_at ON product_returns_bundle__return_state');
  425.         $this->addSql('DROP INDEX content ON product_returns_bundle__return_state_translations');
  426.         $this->addSql('DROP INDEX deleted_at ON products_bundle__attribute');
  427.         $this->addSql('DROP INDEX created_at ON products_bundle__attribute');
  428.         $this->addSql('DROP INDEX updated_at ON products_bundle__attribute');
  429.         $this->addSql('DROP INDEX deleted_at ON products_bundle__attribute_group');
  430.         $this->addSql('DROP INDEX created_at ON products_bundle__attribute_group');
  431.         $this->addSql('DROP INDEX updated_at ON products_bundle__attribute_group');
  432.         $this->addSql('DROP INDEX content ON products_bundle__attribute_group_translations');
  433.         $this->addSql('DROP INDEX content ON products_bundle__attribute_translations');
  434.         $this->addSql('DROP INDEX deleted_at ON products_bundle__brand');
  435.         $this->addSql('DROP INDEX created_at ON products_bundle__brand');
  436.         $this->addSql('DROP INDEX updated_at ON products_bundle__brand');
  437.         $this->addSql('DROP INDEX deleted_at ON products_bundle__declination');
  438.         $this->addSql('DROP INDEX created_at ON products_bundle__declination');
  439.         $this->addSql('DROP INDEX updated_at ON products_bundle__declination');
  440.         $this->addSql('DROP INDEX deleted_at ON products_bundle__declination_attribute');
  441.         $this->addSql('DROP INDEX created_at ON products_bundle__declination_attribute');
  442.         $this->addSql('DROP INDEX updated_at ON products_bundle__declination_attribute');
  443.         $this->addSql('DROP INDEX is_active ON products_bundle__eco_part');
  444.         $this->addSql('DROP INDEX deleted_at ON products_bundle__eco_part');
  445.         $this->addSql('DROP INDEX created_at ON products_bundle__eco_part');
  446.         $this->addSql('DROP INDEX updated_at ON products_bundle__eco_part');
  447.         $this->addSql('DROP INDEX is_active ON products_bundle__eco_part_group');
  448.         $this->addSql('DROP INDEX deleted_at ON products_bundle__eco_part_group');
  449.         $this->addSql('DROP INDEX created_at ON products_bundle__eco_part_group');
  450.         $this->addSql('DROP INDEX updated_at ON products_bundle__eco_part_group');
  451.         $this->addSql('DROP INDEX content ON products_bundle__eco_part_group_translations');
  452.         $this->addSql('DROP INDEX content ON products_bundle__eco_part_translations');
  453.         $this->addSql('DROP INDEX is_active ON products_bundle__product');
  454.         $this->addSql('DROP INDEX deleted_at ON products_bundle__product');
  455.         $this->addSql('DROP INDEX created_at ON products_bundle__product');
  456.         $this->addSql('DROP INDEX updated_at ON products_bundle__product');
  457.         $this->addSql('DROP INDEX content ON products_bundle__product_translations');
  458.         $this->addSql('DROP INDEX is_active ON products_bundle__product_type');
  459.         $this->addSql('DROP INDEX deleted_at ON products_bundle__product_type');
  460.         $this->addSql('DROP INDEX created_at ON products_bundle__product_type');
  461.         $this->addSql('DROP INDEX updated_at ON products_bundle__product_type');
  462.         $this->addSql('DROP INDEX content ON products_bundle__product_type_translations');
  463.         $this->addSql('DROP INDEX is_active ON sales_bundle__additional_pdf');
  464.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__additional_pdf');
  465.         $this->addSql('DROP INDEX created_at ON sales_bundle__additional_pdf');
  466.         $this->addSql('DROP INDEX updated_at ON sales_bundle__additional_pdf');
  467.         $this->addSql('DROP INDEX is_active ON sales_bundle__bank');
  468.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__bank');
  469.         $this->addSql('DROP INDEX created_at ON sales_bundle__bank');
  470.         $this->addSql('DROP INDEX updated_at ON sales_bundle__bank');
  471.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__credit_note');
  472.         $this->addSql('DROP INDEX updated_at ON sales_bundle__credit_note');
  473.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__credit_note_line');
  474.         $this->addSql('DROP INDEX created_at ON sales_bundle__credit_note_line');
  475.         $this->addSql('DROP INDEX updated_at ON sales_bundle__credit_note_line');
  476.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__customer_options');
  477.         $this->addSql('DROP INDEX created_at ON sales_bundle__customer_options');
  478.         $this->addSql('DROP INDEX updated_at ON sales_bundle__customer_options');
  479.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__delivery_note');
  480.         $this->addSql('DROP INDEX created_at ON sales_bundle__delivery_note');
  481.         $this->addSql('DROP INDEX updated_at ON sales_bundle__delivery_note');
  482.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__delivery_note_line');
  483.         $this->addSql('DROP INDEX created_at ON sales_bundle__delivery_note_line');
  484.         $this->addSql('DROP INDEX updated_at ON sales_bundle__delivery_note_line');
  485.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__document_payment');
  486.         $this->addSql('DROP INDEX created_at ON sales_bundle__document_payment');
  487.         $this->addSql('DROP INDEX updated_at ON sales_bundle__document_payment');
  488.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__invoice');
  489.         $this->addSql('DROP INDEX updated_at ON sales_bundle__invoice');
  490.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__invoice_line');
  491.         $this->addSql('DROP INDEX created_at ON sales_bundle__invoice_line');
  492.         $this->addSql('DROP INDEX updated_at ON sales_bundle__invoice_line');
  493.         $this->addSql('DROP INDEX is_active ON sales_bundle__line_type');
  494.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__line_type');
  495.         $this->addSql('DROP INDEX created_at ON sales_bundle__line_type');
  496.         $this->addSql('DROP INDEX updated_at ON sales_bundle__line_type');
  497.         $this->addSql('DROP INDEX content ON sales_bundle__line_type_translations');
  498.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__order');
  499.         $this->addSql('DROP INDEX updated_at ON sales_bundle__order');
  500.         $this->addSql('DROP INDEX created_at ON sales_bundle__order_history');
  501.         $this->addSql('DROP INDEX updated_at ON sales_bundle__order_history');
  502.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__order_line');
  503.         $this->addSql('DROP INDEX created_at ON sales_bundle__order_line');
  504.         $this->addSql('DROP INDEX updated_at ON sales_bundle__order_line');
  505.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__order_state');
  506.         $this->addSql('DROP INDEX created_at ON sales_bundle__order_state');
  507.         $this->addSql('DROP INDEX updated_at ON sales_bundle__order_state');
  508.         $this->addSql('DROP INDEX content ON sales_bundle__order_state_translations');
  509.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__payment');
  510.         $this->addSql('DROP INDEX created_at ON sales_bundle__payment');
  511.         $this->addSql('DROP INDEX updated_at ON sales_bundle__payment');
  512.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__payment_method');
  513.         $this->addSql('DROP INDEX created_at ON sales_bundle__payment_method');
  514.         $this->addSql('DROP INDEX updated_at ON sales_bundle__payment_method');
  515.         $this->addSql('DROP INDEX content ON sales_bundle__payment_method_translations');
  516.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__payment_term');
  517.         $this->addSql('DROP INDEX created_at ON sales_bundle__payment_term');
  518.         $this->addSql('DROP INDEX updated_at ON sales_bundle__payment_term');
  519.         $this->addSql('DROP INDEX content ON sales_bundle__payment_term_translations');
  520.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__quotation');
  521.         $this->addSql('DROP INDEX updated_at ON sales_bundle__quotation');
  522.         $this->addSql('DROP INDEX deleted_at ON sales_bundle__quotation_line');
  523.         $this->addSql('DROP INDEX created_at ON sales_bundle__quotation_line');
  524.         $this->addSql('DROP INDEX updated_at ON sales_bundle__quotation_line');
  525.         $this->addSql('DROP INDEX is_active ON shipments_bundle__burst');
  526.         $this->addSql('DROP INDEX deleted_at ON shipments_bundle__burst');
  527.         $this->addSql('DROP INDEX created_at ON shipments_bundle__burst');
  528.         $this->addSql('DROP INDEX updated_at ON shipments_bundle__burst');
  529.         $this->addSql('DROP INDEX deleted_at ON shipments_bundle__carrier');
  530.         $this->addSql('DROP INDEX created_at ON shipments_bundle__carrier');
  531.         $this->addSql('DROP INDEX updated_at ON shipments_bundle__carrier');
  532.         $this->addSql('DROP INDEX deleted_at ON shipments_bundle__order_options');
  533.         $this->addSql('DROP INDEX created_at ON shipments_bundle__order_options');
  534.         $this->addSql('DROP INDEX updated_at ON shipments_bundle__order_options');
  535.         $this->addSql('DROP INDEX deleted_at ON shipments_bundle__printer');
  536.         $this->addSql('DROP INDEX created_at ON shipments_bundle__printer');
  537.         $this->addSql('DROP INDEX updated_at ON shipments_bundle__printer');
  538.         $this->addSql('DROP INDEX deleted_at ON shipments_bundle__time_delta');
  539.         $this->addSql('DROP INDEX created_at ON shipments_bundle__time_delta');
  540.         $this->addSql('DROP INDEX updated_at ON shipments_bundle__time_delta');
  541.         $this->addSql('DROP INDEX content ON shipments_bundle__time_delta_translations');
  542.         $this->addSql('DROP INDEX name ON stocks_bundle__date_type');
  543.         $this->addSql('DROP INDEX long_name ON stocks_bundle__date_type');
  544.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__date_type');
  545.         $this->addSql('DROP INDEX created_at ON stocks_bundle__date_type');
  546.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__date_type');
  547.         $this->addSql('DROP INDEX content ON stocks_bundle__date_type_translations');
  548.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__location');
  549.         $this->addSql('DROP INDEX created_at ON stocks_bundle__location');
  550.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__location');
  551.         $this->addSql('ALTER TABLE stocks_bundle__location RENAME INDEX idx_a4ab83ff5080ecde TO warehouse_id');
  552.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__product_configuration');
  553.         $this->addSql('DROP INDEX created_at ON stocks_bundle__product_configuration');
  554.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__product_configuration');
  555.         $this->addSql('CREATE INDEX product_id ON stocks_bundle__product_configuration (product_id)');
  556.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__stock_location');
  557.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_location');
  558.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_location');
  559.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX idx_bba57e06fcab8b6e TO date_type_id');
  560.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX idx_bba57e0664d218e TO location_id');
  561.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX idx_bba57e06ebcd91f6 TO stock_product_id');
  562.         $this->addSql('ALTER TABLE stocks_bundle__stock_location RENAME INDEX idx_bba57e06e3b45410 TO sub_location_id');
  563.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__stock_movement');
  564.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_movement');
  565.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_movement');
  566.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX idx_11e6623a64d218e TO location_id');
  567.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX idx_11e6623ad0e7d5de TO stock_movement_reason_id');
  568.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX idx_11e6623aa145ecc8 TO stock_quantity_id');
  569.         $this->addSql('ALTER TABLE stocks_bundle__stock_movement RENAME INDEX idx_11e6623ae3b45410 TO sub_location_id');
  570.         $this->addSql('DROP INDEX name ON stocks_bundle__stock_movement_reason');
  571.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__stock_movement_reason');
  572.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_movement_reason');
  573.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_movement_reason');
  574.         $this->addSql('DROP INDEX content ON stocks_bundle__stock_movement_reason_translations');
  575.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_order_line');
  576.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_order_line');
  577.         $this->addSql('CREATE INDEX order_line_id ON stocks_bundle__stock_order_line (order_line_id)');
  578.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line RENAME INDEX idx_c168a566ebcd91f6 TO stock_product_id');
  579.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_order_line_location');
  580.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_order_line_location');
  581.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line_location RENAME INDEX idx_df6712fed98387ba TO stock_location_id');
  582.         $this->addSql('ALTER TABLE stocks_bundle__stock_order_line_location RENAME INDEX idx_df6712fe3f9ef6ed TO stock_order_line_id');
  583.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__stock_product');
  584.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_product');
  585.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_product');
  586.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX idx_3d03c4609941a932 TO declination_id');
  587.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX idx_3d03c4604584665a TO product_id');
  588.         $this->addSql('ALTER TABLE stocks_bundle__stock_product RENAME INDEX idx_3d03c4605080ecde TO warehouse_id');
  589.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__stock_quantity');
  590.         $this->addSql('DROP INDEX created_at ON stocks_bundle__stock_quantity');
  591.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__stock_quantity');
  592.         $this->addSql('ALTER TABLE stocks_bundle__stock_quantity RENAME INDEX idx_7ac8e1fb38248176 TO currency_id');
  593.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__sub_location');
  594.         $this->addSql('DROP INDEX created_at ON stocks_bundle__sub_location');
  595.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__sub_location');
  596.         $this->addSql('ALTER TABLE stocks_bundle__sub_location RENAME INDEX idx_69b6540664d218e TO location_id');
  597.         $this->addSql('DROP INDEX deleted_at ON stocks_bundle__warehouse');
  598.         $this->addSql('DROP INDEX created_at ON stocks_bundle__warehouse');
  599.         $this->addSql('DROP INDEX updated_at ON stocks_bundle__warehouse');
  600.         $this->addSql('DROP INDEX is_default ON suppliers_bundle__product_supplier');
  601.         $this->addSql('DROP INDEX deleted_at ON suppliers_bundle__product_supplier');
  602.         $this->addSql('DROP INDEX created_at ON suppliers_bundle__product_supplier');
  603.         $this->addSql('DROP INDEX updated_at ON suppliers_bundle__product_supplier');
  604.         $this->addSql('DROP INDEX is_active ON suppliers_bundle__supplier');
  605.         $this->addSql('DROP INDEX deleted_at ON suppliers_bundle__supplier');
  606.         $this->addSql('DROP INDEX created_at ON suppliers_bundle__supplier');
  607.         $this->addSql('DROP INDEX updated_at ON suppliers_bundle__supplier');
  608.         $this->addSql('DROP INDEX deleted_at ON suppliers_bundle__supplier_address');
  609.         $this->addSql('DROP INDEX created_at ON suppliers_bundle__supplier_address');
  610.         $this->addSql('DROP INDEX updated_at ON suppliers_bundle__supplier_address');
  611.         $this->addSql('DROP INDEX deleted_at ON suppliers_bundle__supplier_contact');
  612.         $this->addSql('DROP INDEX created_at ON suppliers_bundle__supplier_contact');
  613.         $this->addSql('DROP INDEX updated_at ON suppliers_bundle__supplier_contact');
  614.         $this->addSql('DROP INDEX deleted_at ON suppliers_bundle__supplier_type');
  615.         $this->addSql('DROP INDEX created_at ON suppliers_bundle__supplier_type');
  616.         $this->addSql('DROP INDEX updated_at ON suppliers_bundle__supplier_type');
  617.         $this->addSql('DROP INDEX content ON suppliers_bundle__supplier_type_translations');
  618.         $this->addSql('DROP INDEX reference ON suppliers_orders_bundle__receipt_note');
  619.         $this->addSql('DROP INDEX deleted_at ON suppliers_orders_bundle__receipt_note');
  620.         $this->addSql('DROP INDEX created_at ON suppliers_orders_bundle__receipt_note');
  621.         $this->addSql('DROP INDEX updated_at ON suppliers_orders_bundle__receipt_note');
  622.         $this->addSql('DROP INDEX deleted_at ON suppliers_orders_bundle__receipt_note_line');
  623.         $this->addSql('DROP INDEX created_at ON suppliers_orders_bundle__receipt_note_line');
  624.         $this->addSql('DROP INDEX updated_at ON suppliers_orders_bundle__receipt_note_line');
  625.         $this->addSql('DROP INDEX reference ON suppliers_orders_bundle__supplier_order');
  626.         $this->addSql('DROP INDEX internal_reference ON suppliers_orders_bundle__supplier_order');
  627.         $this->addSql('DROP INDEX external_reference ON suppliers_orders_bundle__supplier_order');
  628.         $this->addSql('DROP INDEX total_amount ON suppliers_orders_bundle__supplier_order');
  629.         $this->addSql('DROP INDEX deleted_at ON suppliers_orders_bundle__supplier_order');
  630.         $this->addSql('DROP INDEX validated_at ON suppliers_orders_bundle__supplier_order');
  631.         $this->addSql('DROP INDEX created_at ON suppliers_orders_bundle__supplier_order');
  632.         $this->addSql('DROP INDEX updated_at ON suppliers_orders_bundle__supplier_order');
  633.         $this->addSql('DROP INDEX deleted_at ON suppliers_orders_bundle__supplier_order_line');
  634.         $this->addSql('DROP INDEX created_at ON suppliers_orders_bundle__supplier_order_line');
  635.         $this->addSql('DROP INDEX updated_at ON suppliers_orders_bundle__supplier_order_line');
  636.     }
  637. }