migrations/Version20251203122751.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 Version20251203122751 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 basket_item (id INT AUTO_INCREMENT NOT NULL, id_product INT DEFAULT NULL, quantity INT NOT NULL, INDEX IDX_D4943C2BDD7ADDD (id_product), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE blog (id INT AUTO_INCREMENT NOT NULL, auteur_id INT NOT NULL, categorie_id INT NOT NULL, titre VARCHAR(500) NOT NULL, image VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, date_publication DATETIME NOT NULL, nom_auteur VARCHAR(255) NOT NULL, contenu LONGTEXT NOT NULL, statut INT NOT NULL, metatitle VARCHAR(500) DEFAULT NULL, metadescription LONGTEXT DEFAULT NULL, langue INT DEFAULT 0, INDEX IDX_C015514360BB6FE6 (auteur_id), INDEX IDX_C0155143BCF5E72D (categorie_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE blog_tag_blog (id INT AUTO_INCREMENT NOT NULL, blog_id INT NOT NULL, tag_id INT NOT NULL, statut INT NOT NULL, INDEX IDX_5A47CAD2DAE07E97 (blog_id), INDEX IDX_5A47CAD2BAD26311 (tag_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE categorie_blog (id INT AUTO_INCREMENT NOT NULL, nom VARCHAR(255) NOT NULL, statut INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE code_promo (id INT AUTO_INCREMENT NOT NULL, date_expiration DATETIME NOT NULL, percentage INT NOT NULL, type INT DEFAULT NULL, value VARCHAR(255) NOT NULL, status INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE config (id INT AUTO_INCREMENT NOT NULL, nom VARCHAR(255) DEFAULT NULL, val DOUBLE PRECISION DEFAULT NULL, num INT NOT NULL, statut INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE contact_client (id INT AUTO_INCREMENT NOT NULL, email VARCHAR(255) NOT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, address VARCHAR(255) DEFAULT NULL, phone_number VARCHAR(255) DEFAULT NULL, birthday DATETIME DEFAULT NULL, email_type VARCHAR(255) DEFAULT NULL, member_rating INT DEFAULT NULL, optin_time DATETIME DEFAULT NULL, optin_ip VARCHAR(255) DEFAULT NULL, confirm_time DATETIME DEFAULT NULL, confirm_ip VARCHAR(255) DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT NULL, longitude DOUBLE PRECISION DEFAULT NULL, gmtoff INT DEFAULT NULL, dstoff INT DEFAULT NULL, timezone VARCHAR(255) DEFAULT NULL, cc VARCHAR(255) DEFAULT NULL, region VARCHAR(255) DEFAULT NULL, clean_time DATETIME DEFAULT NULL, clean_campaign_title VARCHAR(255) DEFAULT NULL, clean_campaign_id VARCHAR(255) DEFAULT NULL, leid VARCHAR(255) DEFAULT NULL, euid VARCHAR(255) DEFAULT NULL, notes LONGTEXT DEFAULT NULL, tags LONGTEXT DEFAULT NULL, status INT NOT NULL, newsletter INT DEFAULT 0, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE entree_mere (id INT AUTO_INCREMENT NOT NULL, date_entree DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('CREATE TABLE `favorite_product` (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL, INDEX IDX_8E1EAAC3A76ED395 (user_id), INDEX IDX_8E1EAAC34584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('CREATE TABLE info_client (id INT AUTO_INCREMENT NOT NULL, lastname VARCHAR(255) NOT NULL, firstname VARCHAR(255) DEFAULT NULL, mail VARCHAR(255) NOT NULL, delivery_address VARCHAR(35) NOT NULL, delivery_address2 VARCHAR(35) DEFAULT NULL, delivery_address3 VARCHAR(35) DEFAULT NULL, billing_address VARCHAR(35) DEFAULT NULL, billing_address2 VARCHAR(35) DEFAULT NULL, billing_address3 VARCHAR(35) DEFAULT NULL, postal_code VARCHAR(5) NOT NULL, city VARCHAR(255) NOT NULL, phone VARCHAR(255) DEFAULT NULL, billing_postal_code VARCHAR(5) DEFAULT NULL, billing_city VARCHAR(255) DEFAULT NULL, delivery_country_code VARCHAR(10) DEFAULT NULL, delivery_country VARCHAR(255) DEFAULT NULL, billing_country VARCHAR(255) DEFAULT NULL, billing_country_code VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  33. $this->addSql('CREATE TABLE inventaire_fille (id INT AUTO_INCREMENT NOT NULL, mere_id INT NOT NULL, produit_id INT NOT NULL, qte INT NOT NULL, statut INT NOT NULL, INDEX IDX_C8E2342339DEC40E (mere_id), INDEX IDX_C8E23423F347EFB (produit_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  34. $this->addSql('CREATE TABLE inventaire_mere (id INT AUTO_INCREMENT NOT NULL, date_inventaire DATETIME NOT NULL, description LONGTEXT DEFAULT NULL, statut INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  35. $this->addSql('CREATE TABLE mouvement (id INT AUTO_INCREMENT NOT NULL, produit_id INT NOT NULL, date_mouvement DATETIME NOT NULL, entree INT DEFAULT NULL, sortie INT DEFAULT NULL, statut INT NOT NULL, INDEX IDX_5B51FC3EF347EFB (produit_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  36. $this->addSql('CREATE TABLE `order` (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, info_client_id INT DEFAULT NULL, order_type_id INT DEFAULT NULL, payment_type_id INT DEFAULT NULL, parrain_id INT DEFAULT NULL, order_date DATETIME NOT NULL, amount NUMERIC(10, 3) NOT NULL, status INT NOT NULL, note VARCHAR(255) DEFAULT NULL, charge_id VARCHAR(255) DEFAULT NULL, subscription_id VARCHAR(255) DEFAULT NULL, precommande TINYINT(1) DEFAULT NULL, tva DOUBLE PRECISION DEFAULT NULL, frais_livraison NUMERIC(12, 2) DEFAULT NULL, montant_sans_frais_livraison NUMERIC(12, 2) DEFAULT NULL, invoice_path VARCHAR(255) DEFAULT NULL, remise_with_coupon_code NUMERIC(12, 2) DEFAULT NULL, delivery_order_path VARCHAR(255) DEFAULT NULL, coupon_code_value VARCHAR(255) DEFAULT NULL, uploaded_to_ftp TINYINT(1) DEFAULT 0 NOT NULL, INDEX IDX_F5299398A76ED395 (user_id), INDEX IDX_F5299398B49BD41C (info_client_id), INDEX IDX_F5299398333625D8 (order_type_id), INDEX IDX_F5299398DC058279 (payment_type_id), INDEX IDX_F5299398DE2A7A37 (parrain_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  37. $this->addSql('CREATE TABLE order_address (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, address VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, postal_code VARCHAR(255) DEFAULT NULL, latitude VARCHAR(255) DEFAULT NULL, longitude VARCHAR(255) DEFAULT NULL, INDEX IDX_FB34C6CAA76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  38. $this->addSql('CREATE TABLE order_product (id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, order_parent_id INT NOT NULL, price NUMERIC(10, 3) NOT NULL, qty INT NOT NULL, qte_pre_cmd INT DEFAULT NULL, tva NUMERIC(10, 2) DEFAULT NULL, INDEX IDX_2530ADE64584665A (product_id), INDEX IDX_2530ADE6CEFDB188 (order_parent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  39. $this->addSql('CREATE TABLE order_product_surface (id INT AUTO_INCREMENT NOT NULL, order_product_id INT NOT NULL, surface_id INT NOT NULL, qte INT NOT NULL, INDEX IDX_A6914682F65E9B0F (order_product_id), INDEX IDX_A6914682CA11F534 (surface_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  40. $this->addSql('CREATE TABLE order_status (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  41. $this->addSql('CREATE TABLE order_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');
  42. $this->addSql('CREATE TABLE payment_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');
  43. $this->addSql('CREATE TABLE product (id INT AUTO_INCREMENT NOT NULL, id_product_category INT DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, cost NUMERIC(10, 3) NOT NULL, image VARCHAR(255) DEFAULT NULL, precommande TINYINT(1) DEFAULT NULL, apropos LONGTEXT DEFAULT NULL, avertissement LONGTEXT DEFAULT NULL, precautions_emploi LONGTEXT DEFAULT NULL, breve_description LONGTEXT DEFAULT NULL, volume VARCHAR(255) DEFAULT NULL, legende_image VARCHAR(255) DEFAULT NULL, metatitle VARCHAR(255) DEFAULT NULL, metadescription VARCHAR(255) DEFAULT NULL, name_english VARCHAR(255) DEFAULT NULL, breve_description_english LONGTEXT DEFAULT NULL, apropos_english LONGTEXT DEFAULT NULL, description_english LONGTEXT DEFAULT NULL, avertissement_english LONGTEXT DEFAULT NULL, precautions_emploi_english LONGTEXT DEFAULT NULL, langue INT DEFAULT 0, legal_notice LONGTEXT DEFAULT NULL, legal_notice_english LONGTEXT DEFAULT NULL, origin_and_current_production LONGTEXT DEFAULT NULL, origin_and_current_production_english LONGTEXT DEFAULT NULL, usage_tips LONGTEXT DEFAULT NULL, usage_tips_english LONGTEXT DEFAULT NULL, composition_and_precautions_for_use LONGTEXT DEFAULT NULL, composition_and_precautions_for_use_english LONGTEXT DEFAULT NULL, precautions_generales LONGTEXT DEFAULT NULL, precautions_generales_english LONGTEXT DEFAULT NULL, reference_sku VARCHAR(255) DEFAULT NULL, featured TINYINT(1) DEFAULT NULL, tva NUMERIC(5, 2) DEFAULT NULL, is_month_product TINYINT(1) DEFAULT NULL, maj_date DATETIME DEFAULT NULL, status INT DEFAULT NULL, INDEX IDX_D34A04AD2E762687 (id_product_category), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  44. $this->addSql('CREATE TABLE product_category (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, image VARCHAR(255) DEFAULT NULL, image_en VARCHAR(255) DEFAULT NULL, status INT DEFAULT NULL, name_english VARCHAR(255) DEFAULT NULL, description_english VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  45. $this->addSql('CREATE TABLE product_images (id INT AUTO_INCREMENT NOT NULL, product_id INT DEFAULT NULL, image VARCHAR(255) NOT NULL, legende_image VARCHAR(255) DEFAULT NULL, INDEX IDX_8263FFCE4584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  46. $this->addSql('CREATE TABLE product_tracabilite (id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, titre VARCHAR(255) NOT NULL, fichier VARCHAR(255) NOT NULL, statut INT NOT NULL, date_ajout DATETIME DEFAULT NULL, INDEX IDX_D23104954584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  47. $this->addSql('CREATE TABLE production (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, latitude VARCHAR(255) NOT NULL, longitude VARCHAR(255) NOT NULL, radius VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL, numero VARCHAR(255) NOT NULL, document VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_D3EDB1E0F55AE19E (numero), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  48. $this->addSql('CREATE TABLE production_tracabilite (id INT AUTO_INCREMENT NOT NULL, production_id INT NOT NULL, titre VARCHAR(255) NOT NULL, fichier VARCHAR(255) NOT NULL, statut INT NOT NULL, date_ajout DATETIME DEFAULT NULL, INDEX IDX_19A571E2ECC6147F (production_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  49. $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');
  50. $this->addSql('CREATE TABLE surface_reboisement (id INT AUTO_INCREMENT NOT NULL, nom VARCHAR(255) NOT NULL, longitude DOUBLE PRECISION NOT NULL, latitude DOUBLE PRECISION NOT NULL, rayon NUMERIC(12, 2) NOT NULL, nbr_arbres INT NOT NULL, statut INT NOT NULL, date_creation DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  51. $this->addSql('CREATE TABLE tag_blog (id INT AUTO_INCREMENT NOT NULL, nom VARCHAR(255) NOT NULL, statut INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  52. $this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, username VARCHAR(100) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, lastname VARCHAR(255) NOT NULL, firstname VARCHAR(255) DEFAULT NULL, mail VARCHAR(255) NOT NULL, address VARCHAR(255) DEFAULT NULL, phone VARCHAR(255) DEFAULT NULL, signup_date DATETIME NOT NULL, image VARCHAR(255) DEFAULT NULL, newsletter INT DEFAULT 0, UNIQUE INDEX UNIQ_8D93D649F85E0677 (username), UNIQUE INDEX UNIQ_8D93D6495126AC48 (mail), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  53. $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');
  54. $this->addSql('ALTER TABLE basket_item ADD CONSTRAINT FK_D4943C2BDD7ADDD FOREIGN KEY (id_product) REFERENCES product (id)');
  55. $this->addSql('ALTER TABLE blog ADD CONSTRAINT FK_C015514360BB6FE6 FOREIGN KEY (auteur_id) REFERENCES user (id)');
  56. $this->addSql('ALTER TABLE blog ADD CONSTRAINT FK_C0155143BCF5E72D FOREIGN KEY (categorie_id) REFERENCES categorie_blog (id)');
  57. $this->addSql('ALTER TABLE blog_tag_blog ADD CONSTRAINT FK_5A47CAD2DAE07E97 FOREIGN KEY (blog_id) REFERENCES blog (id)');
  58. $this->addSql('ALTER TABLE blog_tag_blog ADD CONSTRAINT FK_5A47CAD2BAD26311 FOREIGN KEY (tag_id) REFERENCES tag_blog (id)');
  59. $this->addSql('ALTER TABLE `favorite_product` ADD CONSTRAINT FK_8E1EAAC3A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  60. $this->addSql('ALTER TABLE `favorite_product` ADD CONSTRAINT FK_8E1EAAC34584665A FOREIGN KEY (product_id) REFERENCES product (id)');
  61. $this->addSql('ALTER TABLE inventaire_fille ADD CONSTRAINT FK_C8E2342339DEC40E FOREIGN KEY (mere_id) REFERENCES inventaire_mere (id)');
  62. $this->addSql('ALTER TABLE inventaire_fille ADD CONSTRAINT FK_C8E23423F347EFB FOREIGN KEY (produit_id) REFERENCES product (id)');
  63. $this->addSql('ALTER TABLE mouvement ADD CONSTRAINT FK_5B51FC3EF347EFB FOREIGN KEY (produit_id) REFERENCES product (id)');
  64. $this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F5299398A76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  65. $this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F5299398B49BD41C FOREIGN KEY (info_client_id) REFERENCES info_client (id)');
  66. $this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F5299398333625D8 FOREIGN KEY (order_type_id) REFERENCES order_type (id)');
  67. $this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F5299398DC058279 FOREIGN KEY (payment_type_id) REFERENCES payment_type (id)');
  68. $this->addSql('ALTER TABLE `order` ADD CONSTRAINT FK_F5299398DE2A7A37 FOREIGN KEY (parrain_id) REFERENCES user (id)');
  69. $this->addSql('ALTER TABLE order_address ADD CONSTRAINT FK_FB34C6CAA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  70. $this->addSql('ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE64584665A FOREIGN KEY (product_id) REFERENCES product (id)');
  71. $this->addSql('ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE6CEFDB188 FOREIGN KEY (order_parent_id) REFERENCES `order` (id)');
  72. $this->addSql('ALTER TABLE order_product_surface ADD CONSTRAINT FK_A6914682F65E9B0F FOREIGN KEY (order_product_id) REFERENCES order_product (id)');
  73. $this->addSql('ALTER TABLE order_product_surface ADD CONSTRAINT FK_A6914682CA11F534 FOREIGN KEY (surface_id) REFERENCES surface_reboisement (id)');
  74. $this->addSql('ALTER TABLE product ADD CONSTRAINT FK_D34A04AD2E762687 FOREIGN KEY (id_product_category) REFERENCES product_category (id)');
  75. $this->addSql('ALTER TABLE product_images ADD CONSTRAINT FK_8263FFCE4584665A FOREIGN KEY (product_id) REFERENCES product (id)');
  76. $this->addSql('ALTER TABLE product_tracabilite ADD CONSTRAINT FK_D23104954584665A FOREIGN KEY (product_id) REFERENCES product (id)');
  77. $this->addSql('ALTER TABLE production_tracabilite ADD CONSTRAINT FK_19A571E2ECC6147F FOREIGN KEY (production_id) REFERENCES production (id)');
  78. $this->addSql('ALTER TABLE reset_password_request ADD CONSTRAINT FK_7CE748AA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  79. }
  81. public function down(Schema $schema): void
  82. {
  83. // this down() migration is auto-generated, please modify it to your needs
  84. $this->addSql('ALTER TABLE basket_item DROP FOREIGN KEY FK_D4943C2BDD7ADDD');
  85. $this->addSql('ALTER TABLE blog DROP FOREIGN KEY FK_C015514360BB6FE6');
  86. $this->addSql('ALTER TABLE blog DROP FOREIGN KEY FK_C0155143BCF5E72D');
  87. $this->addSql('ALTER TABLE blog_tag_blog DROP FOREIGN KEY FK_5A47CAD2DAE07E97');
  88. $this->addSql('ALTER TABLE blog_tag_blog DROP FOREIGN KEY FK_5A47CAD2BAD26311');
  89. $this->addSql('ALTER TABLE `favorite_product` DROP FOREIGN KEY FK_8E1EAAC3A76ED395');
  90. $this->addSql('ALTER TABLE `favorite_product` DROP FOREIGN KEY FK_8E1EAAC34584665A');
  91. $this->addSql('ALTER TABLE inventaire_fille DROP FOREIGN KEY FK_C8E2342339DEC40E');
  92. $this->addSql('ALTER TABLE inventaire_fille DROP FOREIGN KEY FK_C8E23423F347EFB');
  93. $this->addSql('ALTER TABLE mouvement DROP FOREIGN KEY FK_5B51FC3EF347EFB');
  94. $this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F5299398A76ED395');
  95. $this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F5299398B49BD41C');
  96. $this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F5299398333625D8');
  97. $this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F5299398DC058279');
  98. $this->addSql('ALTER TABLE `order` DROP FOREIGN KEY FK_F5299398DE2A7A37');
  99. $this->addSql('ALTER TABLE order_address DROP FOREIGN KEY FK_FB34C6CAA76ED395');
  100. $this->addSql('ALTER TABLE order_product DROP FOREIGN KEY FK_2530ADE64584665A');
  101. $this->addSql('ALTER TABLE order_product DROP FOREIGN KEY FK_2530ADE6CEFDB188');
  102. $this->addSql('ALTER TABLE order_product_surface DROP FOREIGN KEY FK_A6914682F65E9B0F');
  103. $this->addSql('ALTER TABLE order_product_surface DROP FOREIGN KEY FK_A6914682CA11F534');
  104. $this->addSql('ALTER TABLE product DROP FOREIGN KEY FK_D34A04AD2E762687');
  105. $this->addSql('ALTER TABLE product_images DROP FOREIGN KEY FK_8263FFCE4584665A');
  106. $this->addSql('ALTER TABLE product_tracabilite DROP FOREIGN KEY FK_D23104954584665A');
  107. $this->addSql('ALTER TABLE production_tracabilite DROP FOREIGN KEY FK_19A571E2ECC6147F');
  108. $this->addSql('ALTER TABLE reset_password_request DROP FOREIGN KEY FK_7CE748AA76ED395');
  109. $this->addSql('DROP TABLE basket_item');
  110. $this->addSql('DROP TABLE blog');
  111. $this->addSql('DROP TABLE blog_tag_blog');
  112. $this->addSql('DROP TABLE categorie_blog');
  113. $this->addSql('DROP TABLE code_promo');
  114. $this->addSql('DROP TABLE config');
  115. $this->addSql('DROP TABLE contact_client');
  116. $this->addSql('DROP TABLE entree_mere');
  117. $this->addSql('DROP TABLE `favorite_product`');
  118. $this->addSql('DROP TABLE info_client');
  119. $this->addSql('DROP TABLE inventaire_fille');
  120. $this->addSql('DROP TABLE inventaire_mere');
  121. $this->addSql('DROP TABLE mouvement');
  122. $this->addSql('DROP TABLE `order`');
  123. $this->addSql('DROP TABLE order_address');
  124. $this->addSql('DROP TABLE order_product');
  125. $this->addSql('DROP TABLE order_product_surface');
  126. $this->addSql('DROP TABLE order_status');
  127. $this->addSql('DROP TABLE order_type');
  128. $this->addSql('DROP TABLE payment_type');
  129. $this->addSql('DROP TABLE product');
  130. $this->addSql('DROP TABLE product_category');
  131. $this->addSql('DROP TABLE product_images');
  132. $this->addSql('DROP TABLE product_tracabilite');
  133. $this->addSql('DROP TABLE production');
  134. $this->addSql('DROP TABLE production_tracabilite');
  135. $this->addSql('DROP TABLE reset_password_request');
  136. $this->addSql('DROP TABLE surface_reboisement');
  137. $this->addSql('DROP TABLE tag_blog');
  138. $this->addSql('DROP TABLE user');
  139. $this->addSql('DROP TABLE messenger_messages');
  140. }
  141. }