migrations/Version20230201155843.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 Version20230201155843 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 address (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, street VARCHAR(100) NOT NULL, additional_address VARCHAR(150) DEFAULT NULL, additional_address_plus VARCHAR(150) DEFAULT NULL, city VARCHAR(50) NOT NULL, postal_code VARCHAR(5) NOT NULL, floor INT DEFAULT NULL, INDEX IDX_D4E6F81A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE authorized_country (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE authorized_naf (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, naf VARCHAR(5) NOT NULL, INDEX IDX_EE77BD939D419299 (user_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE authorized_sector (id INT AUTO_INCREMENT NOT NULL, service_type_id INT DEFAULT NULL, postal_code VARCHAR(5) NOT NULL, city VARCHAR(100) NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME DEFAULT NULL, latitude VARCHAR(255) DEFAULT NULL, longitude VARCHAR(255) DEFAULT NULL, INDEX IDX_ED9E0B7CAC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE classification_message (id INT AUTO_INCREMENT NOT NULL, tab_transmitter VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE compliment (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, type_id INT DEFAULT NULL, name VARCHAR(50) NOT NULL, start_date DATE NOT NULL, end_date DATE DEFAULT NULL, INDEX IDX_3D54F3359D419299 (user_type_id), INDEX IDX_3D54F335C54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE compliment_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE customer (id INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('CREATE TABLE delivery (id INT AUTO_INCREMENT NOT NULL, sender_id INT DEFAULT NULL, recipient_id INT DEFAULT NULL, requester_id INT NOT NULL, customer_compliment_id INT DEFAULT NULL, delivery_man_compliment_id INT DEFAULT NULL, vehicule_type_id INT DEFAULT NULL, packaging_id INT DEFAULT NULL, payment_id INT DEFAULT NULL, ht_discount DOUBLE PRECISION DEFAULT NULL, total_ht DOUBLE PRECISION DEFAULT NULL, total_option DOUBLE PRECISION DEFAULT NULL, total_ttc DOUBLE PRECISION DEFAULT NULL, customer_note INT DEFAULT NULL, delivery_man_note INT DEFAULT NULL, delivery_totals JSON DEFAULT NULL, is_pro TINYINT(1) NOT NULL, is_send TINYINT(1) NOT NULL, INDEX IDX_3781EC10F624B39D (sender_id), INDEX IDX_3781EC10E92F8F78 (recipient_id), INDEX IDX_3781EC10ED442CF4 (requester_id), INDEX IDX_3781EC107313B5E6 (customer_compliment_id), INDEX IDX_3781EC10E20974CC (delivery_man_compliment_id), INDEX IDX_3781EC10FEA7F9B2 (vehicule_type_id), INDEX IDX_3781EC104E7B3801 (packaging_id), UNIQUE INDEX UNIQ_3781EC104C3A3BB (payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('CREATE TABLE delivery_delivery_man (delivery_id INT NOT NULL, delivery_man_id INT NOT NULL, INDEX IDX_D18E057812136921 (delivery_id), INDEX IDX_D18E0578FD128646 (delivery_man_id), PRIMARY KEY(delivery_id, delivery_man_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  33. $this->addSql('CREATE TABLE delivery_article (id INT AUTO_INCREMENT NOT NULL, delivery_id INT NOT NULL, name VARCHAR(50) NOT NULL, description VARCHAR(255) DEFAULT NULL, weight DOUBLE PRECISION DEFAULT NULL, quantity INT NOT NULL, image VARCHAR(255) DEFAULT NULL, brittle TINYINT(1) NOT NULL, insurance TINYINT(1) NOT NULL, ad_valorem TINYINT(1) NOT NULL, amount DOUBLE PRECISION DEFAULT NULL, round_trip TINYINT(1) NOT NULL, return_description VARCHAR(255) DEFAULT NULL, return_weight DOUBLE PRECISION DEFAULT NULL, return_quantity INT DEFAULT NULL, bar_code VARCHAR(50) DEFAULT NULL, photo VARCHAR(255) DEFAULT NULL, INDEX IDX_824B1B812136921 (delivery_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  34. $this->addSql('CREATE TABLE delivery_history_status (id INT AUTO_INCREMENT NOT NULL, status_id INT NOT NULL, delivery_id INT NOT NULL, created_at DATETIME NOT NULL, INDEX IDX_88239D06BF700BD (status_id), INDEX IDX_88239D012136921 (delivery_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  35. $this->addSql('CREATE TABLE delivery_man (id INT NOT NULL, vehicle_id INT DEFAULT NULL, is_active TINYINT(1) NOT NULL, INDEX IDX_4E0DFC7C545317D1 (vehicle_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  36. $this->addSql('CREATE TABLE delivery_status (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_270C8CCD9D419299 (user_type_id), INDEX IDX_270C8CCDAC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  37. $this->addSql('CREATE TABLE delivery_recipient (id INT AUTO_INCREMENT NOT NULL, message_if_absent VARCHAR(255) DEFAULT NULL, email VARCHAR(180) DEFAULT NULL, details VARCHAR(150) DEFAULT NULL, company_name VARCHAR(50) DEFAULT NULL, opening_time VARCHAR(50) DEFAULT NULL, closing_time VARCHAR(50) DEFAULT NULL, first_name VARCHAR(50) DEFAULT NULL, last_name VARCHAR(50) DEFAULT NULL, phone VARCHAR(10) DEFAULT NULL, street VARCHAR(100) NOT NULL, additional_address VARCHAR(150) DEFAULT NULL, additional_address_plus VARCHAR(150) DEFAULT NULL, city VARCHAR(50) NOT NULL, postal_code VARCHAR(5) NOT NULL, floor INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  38. $this->addSql('CREATE TABLE delivery_sender (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(180) DEFAULT NULL, details VARCHAR(150) DEFAULT NULL, company_name VARCHAR(50) DEFAULT NULL, opening_time VARCHAR(50) DEFAULT NULL, closing_time VARCHAR(50) DEFAULT NULL, first_name VARCHAR(50) DEFAULT NULL, last_name VARCHAR(50) DEFAULT NULL, phone VARCHAR(10) DEFAULT NULL, street VARCHAR(100) NOT NULL, additional_address VARCHAR(150) DEFAULT NULL, additional_address_plus VARCHAR(150) DEFAULT NULL, city VARCHAR(50) NOT NULL, postal_code VARCHAR(5) NOT NULL, floor INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  39. $this->addSql('CREATE TABLE course_status (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, name VARCHAR(50) NOT NULL, INDEX IDX_65119C929D419299 (user_type_id), INDEX IDX_65119C92AC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  40. $this->addSql('CREATE TABLE document (id INT AUTO_INCREMENT NOT NULL, type_id INT NOT NULL, delivery_man_id INT DEFAULT NULL, delivery_article_id INT DEFAULT NULL, display_name VARCHAR(50) NOT NULL, real_name VARCHAR(255) NOT NULL, INDEX IDX_D8698A76C54C8C93 (type_id), INDEX IDX_D8698A76FD128646 (delivery_man_id), INDEX IDX_D8698A766CD111B8 (delivery_article_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  41. $this->addSql('CREATE TABLE document_delivery (document_id INT NOT NULL, delivery_id INT NOT NULL, INDEX IDX_B8401D49C33F7837 (document_id), INDEX IDX_B8401D4912136921 (delivery_id), PRIMARY KEY(document_id, delivery_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  42. $this->addSql('CREATE TABLE equipment (id INT AUTO_INCREMENT NOT NULL, type_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, INDEX IDX_D338D583C54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  43. $this->addSql('CREATE TABLE equipment_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  44. $this->addSql('CREATE TABLE fuel_index (id INT AUTO_INCREMENT NOT NULL, date DATETIME NOT NULL, index_cnr_gazole_pro DOUBLE PRECISION NOT NULL, index_cnr_gazole_excluding_tva DOUBLE PRECISION NOT NULL, index_cnr_fuel DOUBLE PRECISION DEFAULT NULL, price_cnr_gazole_cuve_average_monthly DOUBLE PRECISION NOT NULL, price_cnr_gazole_cuve_end_of_month DOUBLE PRECISION NOT NULL, price_gazole_monthly_average_pump DOUBLE PRECISION NOT NULL, price_gazole_pump_end_of_month DOUBLE PRECISION NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  45. $this->addSql('CREATE TABLE invoice_type (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, doc VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  46. $this->addSql('CREATE TABLE packaging_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  47. $this->addSql('CREATE TABLE packaging (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, packaging_type_id INT DEFAULT NULL, option_type_id INT DEFAULT NULL, sale_price_ht DOUBLE PRECISION NOT NULL, sale_price_ttc DOUBLE PRECISION NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_BF8B0D852DE8FC4E (packaging_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  48. $this->addSql('CREATE TABLE partner (id INT AUTO_INCREMENT NOT NULL, first_name VARCHAR(100) NOT NULL, last_name VARCHAR(100) NOT NULL, iban VARCHAR(34) DEFAULT NULL, bic VARCHAR(8) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  49. $this->addSql('CREATE TABLE partner_price (id INT AUTO_INCREMENT NOT NULL, price_ht DOUBLE PRECISION NOT NULL, price_ttc DOUBLE PRECISION NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME DEFAULT NULL, user_type_id INT NOT NULL, INDEX IDX_D9F48EBC9D419299 (user_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  50. $this->addSql('CREATE TABLE payment (id INT AUTO_INCREMENT NOT NULL, payment_intent_id VARCHAR(255) DEFAULT NULL, payment_intent_status VARCHAR(255) NOT NULL, client_secret VARCHAR(255) DEFAULT NULL, amount DOUBLE PRECISION NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  51. $this->addSql('CREATE TABLE periodicity (id INT AUTO_INCREMENT NOT NULL, durability VARCHAR(255) NOT NULL, delivery_man_self_invoice_coding VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  52. $this->addSql('CREATE TABLE option_type (id INT AUTO_INCREMENT NOT NULL, user1_id INT NOT NULL, user2_id INT NOT NULL, type_id INT NOT NULL, name VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_64D0FDCA56AE248B (user1_id), INDEX IDX_64D0FDCA441B8B65 (user2_id), INDEX IDX_64D0FDCAC54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  53. $this->addSql('CREATE TABLE price_complementary (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, option_rate VARCHAR(255) NOT NULL, option_type_id INT DEFAULT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, rate_ht DOUBLE PRECISION NOT NULL, rate_ttc DOUBLE PRECISION NOT NULL, billing_increase DOUBLE PRECISION NOT NULL, INDEX IDX_C7EE00C69D419299 (user_type_id), INDEX IDX_C7EE00C6AC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  54. $this->addSql('CREATE TABLE price_per_kilometer (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, grid INT NOT NULL, number VARCHAR(255) NOT NULL, slice_kilometer VARCHAR(255) NOT NULL, landing VARCHAR(255) NOT NULL, upper_landing VARCHAR(255) NOT NULL, rate_metric_ht DOUBLE PRECISION NOT NULL, rate_metric_ttc DOUBLE PRECISION NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_B4D76C189D419299 (user_type_id), INDEX IDX_B4D76C18AC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  55. $this->addSql('CREATE TABLE rank_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, min INT NOT NULL, max INT NOT NULL, type INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  56. $this->addSql('CREATE TABLE reason (id INT AUTO_INCREMENT NOT NULL, type_id INT DEFAULT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, reason VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_3BB8880CC54C8C93 (type_id), INDEX IDX_3BB8880C9D419299 (user_type_id), INDEX IDX_3BB8880CAC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  57. $this->addSql('CREATE TABLE reason_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  58. $this->addSql('CREATE TABLE reference_index (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, month VARCHAR(255) DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_56D207119D419299 (user_type_id), INDEX IDX_56D20711AC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  59. $this->addSql('CREATE TABLE reset_password_request (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, selector VARCHAR(20) NOT NULL, hashed_token VARCHAR(100) NOT NULL, requested_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', expires_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_7CE748AA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  60. $this->addSql('CREATE TABLE sector (id INT AUTO_INCREMENT NOT NULL, delivery_man_id INT NOT NULL, postal_code VARCHAR(5) NOT NULL, city VARCHAR(50) NOT NULL, INDEX IDX_4BA3D9E8FD128646 (delivery_man_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  61. $this->addSql('CREATE TABLE service_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, bill_coding VARCHAR(10) DEFAULT NULL, delivery_man_self_invoice_coding VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  62. $this->addSql('CREATE TABLE shop_item_category (id INT AUTO_INCREMENT NOT NULL, item_family_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, article_coding_prefix2 VARCHAR(10) DEFAULT NULL, INDEX IDX_745D4605CF84409A (item_family_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  63. $this->addSql('CREATE TABLE shop_item_family (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, article_coding_prefix1 VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  64. $this->addSql('CREATE TABLE corresponding_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  65. $this->addSql('CREATE TABLE sending_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  66. $this->addSql('CREATE TABLE stream_type (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, sending_type_id INT DEFAULT NULL, corresponding_type_id INT DEFAULT NULL, date_end DATETIME DEFAULT NULL, flux VARCHAR(255) NOT NULL, bill_coding VARCHAR(10) DEFAULT NULL, INDEX IDX_3BC96E8A9D419299 (user_type_id), INDEX IDX_3BC96E8AAC8DE0F (service_type_id), INDEX IDX_3BC96E8A1F5E117B (sending_type_id), INDEX IDX_3BC96E8AB04CE966 (corresponding_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  67. $this->addSql('CREATE TABLE tax (id INT AUTO_INCREMENT NOT NULL, authorized_country_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, taux_percent DOUBLE PRECISION NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_8E81BA76105DE7BE (authorized_country_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  68. $this->addSql('CREATE TABLE triggering_type (id INT AUTO_INCREMENT NOT NULL, classification_message_id INT DEFAULT NULL, triggering VARCHAR(255) NOT NULL, INDEX IDX_32F5AC83D7AFB09 (classification_message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  69. $this->addSql('CREATE TABLE type_document (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  70. $this->addSql('CREATE TABLE urgency_degree (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, emergency VARCHAR(255) NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, bill_coding VARCHAR(10) DEFAULT NULL, billing_increase DOUBLE PRECISION NOT NULL, INDEX IDX_C2B5845A9D419299 (user_type_id), INDEX IDX_C2B5845AAC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  71. $this->addSql('CREATE TABLE `user` (id INT AUTO_INCREMENT NOT NULL, wallet_id INT DEFAULT NULL, uuid BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, civility VARCHAR(5) NOT NULL, birth_date DATE NOT NULL, is_verified TINYINT(1) NOT NULL, know VARCHAR(50) DEFAULT NULL, stripe_customer_id VARCHAR(255) DEFAULT NULL, first_name VARCHAR(50) DEFAULT NULL, last_name VARCHAR(50) DEFAULT NULL, phone VARCHAR(20) DEFAULT NULL, discr VARCHAR(255) NOT NULL, UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), UNIQUE INDEX UNIQ_8D93D649712520F3 (wallet_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  72. $this->addSql('CREATE TABLE user_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, bill_coding VARCHAR(10) DEFAULT NULL, self_invoice_coding VARCHAR(10) DEFAULT NULL, account_definition VARCHAR(2000) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  73. $this->addSql('CREATE TABLE vehicle (id INT AUTO_INCREMENT NOT NULL, type_id INT NOT NULL, motorization_type_id INT DEFAULT NULL, support_weight_id INT DEFAULT NULL, brand VARCHAR(50) DEFAULT NULL, model VARCHAR(50) DEFAULT NULL, ptac DOUBLE PRECISION DEFAULT NULL, registration VARCHAR(10) DEFAULT NULL, INDEX IDX_1B80E486223D4DD3 (motorization_type_id), INDEX IDX_1B80E48683D2AE6A (support_weight_id), INDEX IDX_1B80E486C54C8C93 (type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  74. $this->addSql('CREATE TABLE motorization_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  75. $this->addSql('CREATE TABLE vehicle_family (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  76. $this->addSql('CREATE TABLE support_weight (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  77. $this->addSql('CREATE TABLE energy (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  78. $this->addSql('CREATE TABLE vehicle_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, energy_id INT DEFAULT NULL, vehicle_family_id INT DEFAULT NULL, start_date DATETIME NOT NULL, end_date DATETIME DEFAULT NULL, INDEX IDX_FE43647534E11338 (vehicle_family_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  79. $this->addSql('CREATE TABLE wallet (id INT AUTO_INCREMENT NOT NULL, amount DOUBLE PRECISION NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  80. $this->addSql('CREATE TABLE wallet_history (id INT AUTO_INCREMENT NOT NULL, wallet_id INT NOT NULL, payment_id INT DEFAULT NULL, previous_amount DOUBLE PRECISION NOT NULL, new_amount DOUBLE PRECISION NOT NULL, INDEX IDX_56BB555D712520F3 (wallet_id), UNIQUE INDEX UNIQ_56BB555D4C3A3BB (payment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  81. $this->addSql('CREATE TABLE weather_price (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, weather_option VARCHAR(255) NOT NULL, option_type_id INT DEFAULT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, rate_ht DOUBLE PRECISION NOT NULL, rate_ttc DOUBLE PRECISION NOT NULL, authorized_country_id INT NOT NULL, start_hour VARCHAR(255) DEFAULT NULL, end_hour VARCHAR(255) DEFAULT NULL, INDEX IDX_E38F68DB105DE7BE (authorized_country_id), INDEX IDX_E38F68DB9D419299 (user_type_id), INDEX IDX_E38F68DBAC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  82. $this->addSql('CREATE TABLE weighting (id INT AUTO_INCREMENT NOT NULL, user_type_id INT DEFAULT NULL, service_type_id INT DEFAULT NULL, weighting DOUBLE PRECISION NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_C3AE6B839D419299 (user_type_id), INDEX IDX_C3AE6B83AC8DE0F (service_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  83. $this->addSql('CREATE TABLE messenger_messages (id BIGINT AUTO_INCREMENT NOT NULL, body LONGTEXT NOT NULL, headers LONGTEXT NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL, available_at DATETIME NOT NULL, delivered_at DATETIME DEFAULT NULL, INDEX IDX_75EA56E0FB7336F0 (queue_name), INDEX IDX_75EA56E0E3BD61CE (available_at), INDEX IDX_75EA56E016BA31DB (delivered_at), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  84. $this->addSql('CREATE TABLE broadcast_channel (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  85. $this->addSql('CREATE TABLE email_message (id INT AUTO_INCREMENT NOT NULL, classification_message_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, subject VARCHAR(255) NOT NULL, content MEDIUMTEXT NOT NULL, date_start DATETIME NOT NULL, date_end DATETIME DEFAULT NULL, INDEX IDX_B7D58B03D7AFB09 (classification_message_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  86. $this->addSql('CREATE TABLE email_message_broadcast_channel (email_message_id INT NOT NULL, broadcast_channel_id INT NOT NULL, INDEX IDX_871E4316FFC9E1F6 (email_message_id), INDEX IDX_871E4316F6388094 (broadcast_channel_id), PRIMARY KEY(email_message_id, broadcast_channel_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  87. $this->addSql('ALTER TABLE email_message ADD CONSTRAINT FK_B7D58B03D7AFB09 FOREIGN KEY (classification_message_id) REFERENCES classification_message (id)');
  88. $this->addSql('ALTER TABLE email_message_broadcast_channel ADD CONSTRAINT FK_871E4316FFC9E1F6 FOREIGN KEY (email_message_id) REFERENCES email_message (id) ON DELETE CASCADE');
  89. $this->addSql('ALTER TABLE email_message_broadcast_channel ADD CONSTRAINT FK_871E4316F6388094 FOREIGN KEY (broadcast_channel_id) REFERENCES broadcast_channel (id) ON DELETE CASCADE');
  90. $this->addSql('ALTER TABLE address ADD CONSTRAINT FK_D4E6F81A76ED395 FOREIGN KEY (user_id) REFERENCES `user` (id)');
  91. $this->addSql('ALTER TABLE authorized_naf ADD CONSTRAINT FK_EE77BD939D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  92. $this->addSql('ALTER TABLE authorized_sector ADD CONSTRAINT FK_ED9E0B7CAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  93. $this->addSql('ALTER TABLE compliment ADD CONSTRAINT FK_3D54F3359D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  94. $this->addSql('ALTER TABLE compliment ADD CONSTRAINT FK_3D54F335C54C8C93 FOREIGN KEY (type_id) REFERENCES compliment_type (id)');
  95. $this->addSql('ALTER TABLE customer ADD CONSTRAINT FK_81398E09BF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
  96. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10F624B39D FOREIGN KEY (sender_id) REFERENCES delivery_sender (id)');
  97. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10E92F8F78 FOREIGN KEY (recipient_id) REFERENCES delivery_recipient (id)');
  98. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10ED442CF4 FOREIGN KEY (requester_id) REFERENCES customer (id)');
  99. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC107313B5E6 FOREIGN KEY (customer_compliment_id) REFERENCES compliment (id)');
  100. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10E20974CC FOREIGN KEY (delivery_man_compliment_id) REFERENCES compliment (id)');
  101. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC10FEA7F9B2 FOREIGN KEY (vehicule_type_id) REFERENCES vehicle_type (id)');
  102. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC104E7B3801 FOREIGN KEY (packaging_id) REFERENCES packaging (id)');
  103. $this->addSql('ALTER TABLE delivery ADD CONSTRAINT FK_3781EC104C3A3BB FOREIGN KEY (payment_id) REFERENCES payment (id)');
  104. $this->addSql('ALTER TABLE delivery_delivery_man ADD CONSTRAINT FK_D18E057812136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id) ON DELETE CASCADE');
  105. $this->addSql('ALTER TABLE delivery_delivery_man ADD CONSTRAINT FK_D18E0578FD128646 FOREIGN KEY (delivery_man_id) REFERENCES delivery_man (id) ON DELETE CASCADE');
  106. $this->addSql('ALTER TABLE delivery_article ADD CONSTRAINT FK_824B1B812136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id)');
  107. $this->addSql('ALTER TABLE delivery_history_status ADD CONSTRAINT FK_88239D06BF700BD FOREIGN KEY (status_id) REFERENCES delivery_status (id)');
  108. $this->addSql('ALTER TABLE delivery_history_status ADD CONSTRAINT FK_88239D012136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id)');
  109. $this->addSql('ALTER TABLE delivery_man ADD CONSTRAINT FK_4E0DFC7C545317D1 FOREIGN KEY (vehicle_id) REFERENCES vehicle (id)');
  110. $this->addSql('ALTER TABLE delivery_man ADD CONSTRAINT FK_4E0DFC7CBF396750 FOREIGN KEY (id) REFERENCES `user` (id) ON DELETE CASCADE');
  111. $this->addSql('ALTER TABLE delivery_status ADD CONSTRAINT FK_270C8CCD9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  112. $this->addSql('ALTER TABLE delivery_status ADD CONSTRAINT FK_270C8CCDAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  113. $this->addSql('ALTER TABLE course_status ADD CONSTRAINT FK_65119C929D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  114. $this->addSql('ALTER TABLE course_status ADD CONSTRAINT FK_65119C92AC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  115. $this->addSql('ALTER TABLE document ADD CONSTRAINT FK_D8698A76C54C8C93 FOREIGN KEY (type_id) REFERENCES type_document (id)');
  116. $this->addSql('ALTER TABLE document ADD CONSTRAINT FK_D8698A76FD128646 FOREIGN KEY (delivery_man_id) REFERENCES delivery_man (id)');
  117. $this->addSql('ALTER TABLE document ADD CONSTRAINT FK_D8698A766CD111B8 FOREIGN KEY (delivery_article_id) REFERENCES delivery_article (id)');
  118. $this->addSql('ALTER TABLE document_delivery ADD CONSTRAINT FK_B8401D49C33F7837 FOREIGN KEY (document_id) REFERENCES document (id) ON DELETE CASCADE');
  119. $this->addSql('ALTER TABLE document_delivery ADD CONSTRAINT FK_B8401D4912136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id) ON DELETE CASCADE');
  120. $this->addSql('ALTER TABLE equipment ADD CONSTRAINT FK_D338D583C54C8C93 FOREIGN KEY (type_id) REFERENCES equipment_type (id)');
  121. $this->addSql('ALTER TABLE packaging ADD CONSTRAINT FK_BF8B0D852DE8FC4E FOREIGN KEY (packaging_type_id) REFERENCES packaging_type (id)');
  122. $this->addSql('ALTER TABLE packaging ADD CONSTRAINT FK_BF8B0D85DDB89BE6 FOREIGN KEY (option_type_id) REFERENCES option_type (id)');
  123. $this->addSql('CREATE INDEX IDX_BF8B0D85DDB89BE6 ON packaging (option_type_id)');
  124. $this->addSql('ALTER TABLE price_complementary ADD CONSTRAINT FK_C7EE00C69D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  125. $this->addSql('ALTER TABLE price_complementary ADD CONSTRAINT FK_C7EE00C6AC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  126. $this->addSql('ALTER TABLE price_complementary ADD CONSTRAINT FK_C7EE00C6DDB89BE6 FOREIGN KEY (option_type_id) REFERENCES option_type (id)');
  127. $this->addSql('CREATE INDEX IDX_C7EE00C6DDB89BE6 ON price_complementary (option_type_id)');
  128. $this->addSql('ALTER TABLE option_type ADD CONSTRAINT FK_64D0FDCA56AE248B FOREIGN KEY (user1_id) REFERENCES user_type (id)');
  129. $this->addSql('ALTER TABLE option_type ADD CONSTRAINT FK_64D0FDCA441B8B65 FOREIGN KEY (user2_id) REFERENCES user_type (id)');
  130. $this->addSql('ALTER TABLE option_type ADD CONSTRAINT FK_64D0FDCAC54C8C93 FOREIGN KEY (type_id) REFERENCES service_type (id)');
  131. $this->addSql('ALTER TABLE price_per_kilometer ADD CONSTRAINT FK_B4D76C189D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  132. $this->addSql('ALTER TABLE price_per_kilometer ADD CONSTRAINT FK_B4D76C18AC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  133. $this->addSql('ALTER TABLE reason ADD CONSTRAINT FK_3BB8880CC54C8C93 FOREIGN KEY (type_id) REFERENCES reason_type (id)');
  134. $this->addSql('ALTER TABLE reason ADD CONSTRAINT FK_3BB8880C9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  135. $this->addSql('ALTER TABLE reason ADD CONSTRAINT FK_3BB8880CAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  136. $this->addSql('ALTER TABLE reference_index ADD CONSTRAINT FK_56D207119D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  137. $this->addSql('ALTER TABLE reference_index ADD CONSTRAINT FK_56D20711AC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  138. $this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES `user` (id)');
  139. $this->addSql('ALTER TABLE sector ADD CONSTRAINT FK_4BA3D9E8FD128646 FOREIGN KEY (delivery_man_id) REFERENCES delivery_man (id)');
  140. $this->addSql('ALTER TABLE shop_item_category ADD CONSTRAINT FK_745D4605CF84409A FOREIGN KEY (item_family_id) REFERENCES shop_item_family (id)');
  141. $this->addSql('ALTER TABLE stream_type ADD CONSTRAINT FK_3BC96E8A9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  142. $this->addSql('ALTER TABLE stream_type ADD CONSTRAINT FK_3BC96E8AAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  143. $this->addSql('ALTER TABLE stream_type ADD CONSTRAINT FK_3BC96E8A1F5E117B FOREIGN KEY (sending_type_id) REFERENCES sending_type (id)');
  144. $this->addSql('ALTER TABLE stream_type ADD CONSTRAINT FK_3BC96E8AB04CE966 FOREIGN KEY (corresponding_type_id) REFERENCES corresponding_type (id)');
  145. $this->addSql('ALTER TABLE tax ADD CONSTRAINT FK_8E81BA76105DE7BE FOREIGN KEY (authorized_country_id) REFERENCES authorized_country (id)');
  146. $this->addSql('ALTER TABLE triggering_type ADD CONSTRAINT FK_32F5AC83D7AFB09 FOREIGN KEY (classification_message_id) REFERENCES classification_message (id)');
  147. $this->addSql('ALTER TABLE urgency_degree ADD CONSTRAINT FK_C2B5845A9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  148. $this->addSql('ALTER TABLE urgency_degree ADD CONSTRAINT FK_C2B5845AAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  149. $this->addSql('ALTER TABLE `user` ADD CONSTRAINT FK_8D93D649712520F3 FOREIGN KEY (wallet_id) REFERENCES wallet (id)');
  150. $this->addSql('ALTER TABLE vehicle_type ADD CONSTRAINT FK_FE436475EDDF52D FOREIGN KEY (energy_id) REFERENCES energy (id)');
  151. $this->addSql('ALTER TABLE vehicle_type ADD CONSTRAINT FK_FE43647534E11338 FOREIGN KEY (vehicle_family_id) REFERENCES vehicle_family (id)');
  152. $this->addSql('CREATE INDEX IDX_FE436475EDDF52D ON vehicle_type (energy_id)');
  153. $this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E486C54C8C93 FOREIGN KEY (type_id) REFERENCES vehicle_type (id)');
  154. $this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E486223D4DD3 FOREIGN KEY (motorization_type_id) REFERENCES motorization_type (id)');
  155. $this->addSql('ALTER TABLE vehicle ADD CONSTRAINT FK_1B80E48683D2AE6A FOREIGN KEY (support_weight_id) REFERENCES support_weight (id)');
  156. $this->addSql('ALTER TABLE wallet_history ADD CONSTRAINT FK_56BB555D712520F3 FOREIGN KEY (wallet_id) REFERENCES wallet (id)');
  157. $this->addSql('ALTER TABLE wallet_history ADD CONSTRAINT FK_56BB555D4C3A3BB FOREIGN KEY (payment_id) REFERENCES payment (id)');
  158. $this->addSql('ALTER TABLE weather_price ADD CONSTRAINT FK_E38F68DB9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  159. $this->addSql('ALTER TABLE weather_price ADD CONSTRAINT FK_E38F68DBAC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  160. $this->addSql('ALTER TABLE weather_price ADD CONSTRAINT FK_E38F68DB105DE7BE FOREIGN KEY (authorized_country_id) REFERENCES authorized_country (id)');
  161. $this->addSql('ALTER TABLE weather_price ADD CONSTRAINT FK_E38F68DBDDB89BE6 FOREIGN KEY (option_type_id) REFERENCES option_type (id)');
  162. $this->addSql('CREATE INDEX IDX_E38F68DBDDB89BE6 ON weather_price (option_type_id)');
  163. $this->addSql('ALTER TABLE partner_price ADD CONSTRAINT FK_D9F48EBC9D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  164. $this->addSql('ALTER TABLE weighting ADD CONSTRAINT FK_C3AE6B839D419299 FOREIGN KEY (user_type_id) REFERENCES user_type (id)');
  165. $this->addSql('ALTER TABLE weighting ADD CONSTRAINT FK_C3AE6B83AC8DE0F FOREIGN KEY (service_type_id) REFERENCES service_type (id)');
  166. }
  168. public function down(Schema $schema): void
  169. {
  170. // this down() migration is auto-generated, please modify it to your needs
  171. $this->addSql('ALTER TABLE address DROP FOREIGN KEY FK_D4E6F81A76ED395');
  172. $this->addSql('ALTER TABLE authorized_naf DROP FOREIGN KEY FK_EE77BD939D419299');
  173. $this->addSql('ALTER TABLE authorized_sector DROP FOREIGN KEY FK_ED9E0B7CAC8DE0F');
  174. $this->addSql('ALTER TABLE compliment DROP FOREIGN KEY FK_3D54F3359D419299');
  175. $this->addSql('ALTER TABLE compliment DROP FOREIGN KEY FK_3D54F335C54C8C93');
  176. $this->addSql('ALTER TABLE customer DROP FOREIGN KEY FK_81398E09BF396750');
  177. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10F624B39D');
  178. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10E92F8F78');
  179. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10ED442CF4');
  180. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC107313B5E6');
  181. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10E20974CC');
  182. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC10FEA7F9B2');
  183. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC104E7B3801');
  184. $this->addSql('ALTER TABLE delivery DROP FOREIGN KEY FK_3781EC104C3A3BB');
  185. $this->addSql('ALTER TABLE delivery_delivery_man DROP FOREIGN KEY FK_D18E057812136921');
  186. $this->addSql('ALTER TABLE delivery_delivery_man DROP FOREIGN KEY FK_D18E0578FD128646');
  187. $this->addSql('ALTER TABLE delivery_article DROP FOREIGN KEY FK_824B1B812136921');
  188. $this->addSql('ALTER TABLE delivery_history_status DROP FOREIGN KEY FK_88239D06BF700BD');
  189. $this->addSql('ALTER TABLE delivery_history_status DROP FOREIGN KEY FK_88239D012136921');
  190. $this->addSql('ALTER TABLE delivery_man DROP FOREIGN KEY FK_4E0DFC7C545317D1');
  191. $this->addSql('ALTER TABLE delivery_man DROP FOREIGN KEY FK_4E0DFC7CBF396750');
  192. $this->addSql('ALTER TABLE delivery_status DROP FOREIGN KEY FK_270C8CCD9D419299');
  193. $this->addSql('ALTER TABLE delivery_status DROP FOREIGN KEY FK_270C8CCDAC8DE0F');
  194. $this->addSql('ALTER TABLE course_status DROP FOREIGN KEY FK_65119C929D419299');
  195. $this->addSql('ALTER TABLE course_status DROP FOREIGN KEY FK_65119C92AC8DE0F');
  196. $this->addSql('ALTER TABLE document DROP FOREIGN KEY FK_D8698A76C54C8C93');
  197. $this->addSql('ALTER TABLE document DROP FOREIGN KEY FK_D8698A76FD128646');
  198. $this->addSql('ALTER TABLE document DROP FOREIGN KEY FK_D8698A766CD111B8');
  199. $this->addSql('ALTER TABLE document_delivery DROP FOREIGN KEY FK_B8401D49C33F7837');
  200. $this->addSql('ALTER TABLE document_delivery DROP FOREIGN KEY FK_B8401D4912136921');
  201. $this->addSql('ALTER TABLE equipment DROP FOREIGN KEY FK_D338D583C54C8C93');
  202. $this->addSql('ALTER TABLE packaging DROP FOREIGN KEY FK_BF8B0D852DE8FC4E');
  203. $this->addSql('ALTER TABLE packaging DROP FOREIGN KEY FK_BF8B0D85DDB89BE6');
  204. $this->addSql('DROP INDEX IDX_BF8B0D85DDB89BE6 ON packaging');
  205. $this->addSql('ALTER TABLE price_complementary DROP FOREIGN KEY FK_C7EE00C69D419299');
  206. $this->addSql('ALTER TABLE price_complementary DROP FOREIGN KEY FK_C7EE00C6AC8DE0F');
  207. $this->addSql('ALTER TABLE price_complementary DROP FOREIGN KEY FK_C7EE00C6DDB89BE6');
  208. $this->addSql('DROP INDEX IDX_C7EE00C6DDB89BE6 ON price_complementary');
  209. $this->addSql('ALTER TABLE option_type DROP FOREIGN KEY FK_64D0FDCA56AE248B');
  210. $this->addSql('ALTER TABLE option_type DROP FOREIGN KEY FK_64D0FDCA441B8B65');
  211. $this->addSql('ALTER TABLE option_type DROP FOREIGN KEY FK_64D0FDCAC54C8C93');
  212. $this->addSql('ALTER TABLE price_per_kilometer DROP FOREIGN KEY FK_B4D76C189D419299');
  213. $this->addSql('ALTER TABLE price_per_kilometer DROP FOREIGN KEY FK_B4D76C18AC8DE0F');
  214. $this->addSql('ALTER TABLE reason DROP FOREIGN KEY FK_3BB8880CC54C8C93');
  215. $this->addSql('ALTER TABLE reason DROP FOREIGN KEY FK_3BB8880C9D419299');
  216. $this->addSql('ALTER TABLE reason DROP FOREIGN KEY FK_3BB8880CAC8DE0F');
  217. $this->addSql('ALTER TABLE reference_index DROP FOREIGN KEY FK_56D207119D419299');
  218. $this->addSql('ALTER TABLE reference_index DROP FOREIGN KEY FK_56D20711AC8DE0F');
  219. $this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
  220. $this->addSql('ALTER TABLE sector DROP FOREIGN KEY FK_4BA3D9E8FD128646');
  221. $this->addSql('ALTER TABLE shop_item_category DROP FOREIGN KEY FK_745D4605CF84409A');
  222. $this->addSql('ALTER TABLE stream_type DROP FOREIGN KEY FK_3BC96E8A9D419299');
  223. $this->addSql('ALTER TABLE stream_type DROP FOREIGN KEY FK_3BC96E8AAC8DE0F');
  224. $this->addSql('ALTER TABLE stream_type DROP FOREIGN KEY FK_3BC96E8A1F5E117B');
  225. $this->addSql('ALTER TABLE stream_type DROP FOREIGN KEY FK_3BC96E8AB04CE966');
  226. $this->addSql('ALTER TABLE tax DROP FOREIGN KEY FK_8E81BA76105DE7BE');
  227. $this->addSql('ALTER TABLE triggering_type DROP FOREIGN KEY FK_32F5AC83D7AFB09');
  228. $this->addSql('ALTER TABLE urgency_degree DROP FOREIGN KEY FK_C2B5845A9D419299');
  229. $this->addSql('ALTER TABLE urgency_degree DROP FOREIGN KEY FK_C2B5845AAC8DE0F');
  230. $this->addSql('ALTER TABLE `user` DROP FOREIGN KEY FK_8D93D649712520F3');
  231. $this->addSql('ALTER TABLE vehicle_type DROP FOREIGN KEY FK_FE436475EDDF52D');
  232. $this->addSql('ALTER TABLE vehicle_type DROP FOREIGN KEY FK_FE43647534E11338');
  233. $this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E486C54C8C93');
  234. $this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E486223D4DD3');
  235. $this->addSql('ALTER TABLE vehicle DROP FOREIGN KEY FK_1B80E48683D2AE6A');
  236. $this->addSql('ALTER TABLE wallet_history DROP FOREIGN KEY FK_56BB555D712520F3');
  237. $this->addSql('ALTER TABLE wallet_history DROP FOREIGN KEY FK_56BB555D4C3A3BB');
  238. $this->addSql('ALTER TABLE weather_price DROP FOREIGN KEY FK_E38F68DB9D419299');
  239. $this->addSql('ALTER TABLE weather_price DROP FOREIGN KEY FK_E38F68DBAC8DE0F');
  240. $this->addSql('ALTER TABLE weather_price DROP FOREIGN KEY FK_E38F68DB105DE7BE');
  241. $this->addSql('ALTER TABLE weather_price DROP FOREIGN KEY FK_E38F68DBDDB89BE6');
  242. $this->addSql('DROP INDEX IDX_E38F68DBDDB89BE6 ON weather_price');
  243. $this->addSql('ALTER TABLE weighting DROP FOREIGN KEY FK_C3AE6B839D419299');
  244. $this->addSql('ALTER TABLE weighting DROP FOREIGN KEY FK_C3AE6B83AC8DE0F');
  245. $this->addSql('ALTER TABLE email_message DROP FOREIGN KEY FK_B7D58B03D7AFB09');
  246. $this->addSql('ALTER TABLE email_message_broadcast_channel DROP FOREIGN KEY FK_871E4316FFC9E1F6');
  247. $this->addSql('ALTER TABLE email_message_broadcast_channel DROP FOREIGN KEY FK_871E4316F6388094');
  248. $this->addSql('DROP TABLE address');
  249. $this->addSql('DROP TABLE authorized_country');
  250. $this->addSql('DROP TABLE authorized_naf');
  251. $this->addSql('DROP TABLE authorized_sector');
  252. $this->addSql('DROP TABLE classification_message');
  253. $this->addSql('DROP TABLE compliment');
  254. $this->addSql('DROP TABLE compliment_type');
  255. $this->addSql('DROP TABLE customer');
  256. $this->addSql('DROP TABLE delivery');
  257. $this->addSql('DROP TABLE delivery_delivery_man');
  258. $this->addSql('DROP TABLE delivery_article');
  259. $this->addSql('DROP TABLE delivery_history_status');
  260. $this->addSql('DROP TABLE delivery_man');
  261. $this->addSql('DROP TABLE delivery_status');
  262. $this->addSql('DROP TABLE delivery_recipient');
  263. $this->addSql('DROP TABLE delivery_sender');
  264. $this->addSql('DROP TABLE course_status');
  265. $this->addSql('DROP TABLE document');
  266. $this->addSql('DROP TABLE document_delivery');
  267. $this->addSql('DROP TABLE equipment');
  268. $this->addSql('DROP TABLE equipment_type');
  269. $this->addSql('DROP TABLE fuel_index');
  270. $this->addSql('DROP TABLE invoice_type');
  271. $this->addSql('DROP TABLE packaging');
  272. $this->addSql('DROP TABLE packaging_type');
  273. $this->addSql('DROP TABLE partner');
  274. $this->addSql('DROP TABLE partner_price');
  275. $this->addSql('DROP TABLE payment');
  276. $this->addSql('DROP TABLE periodicity');
  277. $this->addSql('DROP TABLE price_complementary');
  278. $this->addSql('DROP TABLE option_type');
  279. $this->addSql('DROP TABLE price_per_kilometer');
  280. $this->addSql('DROP TABLE rank_type');
  281. $this->addSql('DROP TABLE reason');
  282. $this->addSql('DROP TABLE reason_type');
  283. $this->addSql('DROP TABLE reference_index');
  284. $this->addSql('DROP TABLE reset_password_request');
  285. $this->addSql('DROP TABLE sector');
  286. $this->addSql('DROP TABLE service_type');
  287. $this->addSql('DROP TABLE shop_item_category');
  288. $this->addSql('DROP TABLE shop_item_family');
  289. $this->addSql('DROP TABLE stream_type');
  290. $this->addSql('DROP TABLE corresponding_type');
  291. $this->addSql('DROP TABLE sending_type');
  292. $this->addSql('DROP TABLE tax');
  293. $this->addSql('DROP TABLE triggering_type');
  294. $this->addSql('DROP TABLE type_document');
  295. $this->addSql('DROP TABLE urgency_degree');
  296. $this->addSql('DROP TABLE `user`');
  297. $this->addSql('DROP TABLE user_type');
  298. $this->addSql('DROP TABLE vehicle');
  299. $this->addSql('DROP TABLE vehicle_type');
  300. $this->addSql('DROP TABLE energy');
  301. $this->addSql('DROP TABLE motorization_type');
  302. $this->addSql('DROP TABLE vehicle_family');
  303. $this->addSql('DROP TABLE support_weight');
  304. $this->addSql('DROP TABLE wallet');
  305. $this->addSql('DROP TABLE wallet_history');
  306. $this->addSql('DROP TABLE weather_price');
  307. $this->addSql('DROP TABLE weighting');
  308. $this->addSql('DROP TABLE messenger_messages');
  309. $this->addSql('DROP TABLE email_message');
  310. $this->addSql('DROP TABLE email_message_broadcast_channel');
  311. $this->addSql('DROP TABLE broadcast_channel');
  312. }
  313. }