migrations/Version20220320141155.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 Version20220320141155 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 facture (id INT AUTO_INCREMENT NOT NULL, etat_id INT NOT NULL, ref VARCHAR(255) NOT NULL, created_at DATE NOT NULL, INDEX IDX_FE866410D5E86FF (etat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE ligne_facture (id INT AUTO_INCREMENT NOT NULL, facture_id INT DEFAULT NULL, libelle_produit VARCHAR(255) NOT NULL, prix_produit NUMERIC(10, 2) NOT NULL, quantite_produit INT NOT NULL, tva NUMERIC(10, 2) NOT NULL, INDEX IDX_611F5A297F2DEE08 (facture_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE livraison (id INT AUTO_INCREMENT NOT NULL, commande_id INT DEFAULT NULL, etat_id INT DEFAULT NULL, ref VARCHAR(255) NOT NULL, created_at DATE NOT NULL, suivi VARCHAR(255) DEFAULT NULL, INDEX IDX_A60C9F1F82EA2E54 (commande_id), INDEX IDX_A60C9F1FD5E86FF (etat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE mode_paiement (id INT AUTO_INCREMENT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE paiement (id INT AUTO_INCREMENT NOT NULL, user_id INT DEFAULT NULL, facture_id INT NOT NULL, mode_paiement_id INT NOT NULL, etat_id INT NOT NULL, montant NUMERIC(10, 2) NOT NULL, created_at DATE NOT NULL, INDEX IDX_B1DC7A1EA76ED395 (user_id), INDEX IDX_B1DC7A1E7F2DEE08 (facture_id), INDEX IDX_B1DC7A1E438F5B63 (mode_paiement_id), INDEX IDX_B1DC7A1ED5E86FF (etat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE tva (id INT AUTO_INCREMENT NOT NULL, taux NUMERIC(10, 2) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('ALTER TABLE facture ADD CONSTRAINT FK_FE866410D5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  30. $this->addSql('ALTER TABLE ligne_facture ADD CONSTRAINT FK_611F5A297F2DEE08 FOREIGN KEY (facture_id) REFERENCES facture (id)');
  31. $this->addSql('ALTER TABLE livraison ADD CONSTRAINT FK_A60C9F1F82EA2E54 FOREIGN KEY (commande_id) REFERENCES commande (id)');
  32. $this->addSql('ALTER TABLE livraison ADD CONSTRAINT FK_A60C9F1FD5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  33. $this->addSql('ALTER TABLE paiement ADD CONSTRAINT FK_B1DC7A1EA76ED395 FOREIGN KEY (user_id) REFERENCES user (id)');
  34. $this->addSql('ALTER TABLE paiement ADD CONSTRAINT FK_B1DC7A1E7F2DEE08 FOREIGN KEY (facture_id) REFERENCES facture (id)');
  35. $this->addSql('ALTER TABLE paiement ADD CONSTRAINT FK_B1DC7A1E438F5B63 FOREIGN KEY (mode_paiement_id) REFERENCES mode_paiement (id)');
  36. $this->addSql('ALTER TABLE paiement ADD CONSTRAINT FK_B1DC7A1ED5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  37. $this->addSql('ALTER TABLE catalogue_constructeur ADD tva_id INT DEFAULT NULL, ADD constructeur_id INT DEFAULT NULL, ADD etat_id INT NOT NULL');
  38. $this->addSql('ALTER TABLE catalogue_constructeur ADD CONSTRAINT FK_81F250B34D79775F FOREIGN KEY (tva_id) REFERENCES tva (id)');
  39. $this->addSql('ALTER TABLE catalogue_constructeur ADD CONSTRAINT FK_81F250B38815B605 FOREIGN KEY (constructeur_id) REFERENCES constructeur (id)');
  40. $this->addSql('ALTER TABLE catalogue_constructeur ADD CONSTRAINT FK_81F250B3D5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  41. $this->addSql('CREATE INDEX IDX_81F250B34D79775F ON catalogue_constructeur (tva_id)');
  42. $this->addSql('CREATE INDEX IDX_81F250B38815B605 ON catalogue_constructeur (constructeur_id)');
  43. $this->addSql('CREATE INDEX IDX_81F250B3D5E86FF ON catalogue_constructeur (etat_id)');
  44. $this->addSql('ALTER TABLE catalogue_fournisseur ADD tva_id INT DEFAULT NULL, ADD catalogue_constructeur_id INT NOT NULL, ADD etat_id INT NOT NULL, ADD fournisseur_id INT NOT NULL');
  45. $this->addSql('ALTER TABLE catalogue_fournisseur ADD CONSTRAINT FK_6CE0A3A24D79775F FOREIGN KEY (tva_id) REFERENCES tva (id)');
  46. $this->addSql('ALTER TABLE catalogue_fournisseur ADD CONSTRAINT FK_6CE0A3A248514B9C FOREIGN KEY (catalogue_constructeur_id) REFERENCES catalogue_constructeur (id)');
  47. $this->addSql('ALTER TABLE catalogue_fournisseur ADD CONSTRAINT FK_6CE0A3A2D5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  48. $this->addSql('ALTER TABLE catalogue_fournisseur ADD CONSTRAINT FK_6CE0A3A2670C757F FOREIGN KEY (fournisseur_id) REFERENCES fournisseur (id)');
  49. $this->addSql('CREATE INDEX IDX_6CE0A3A24D79775F ON catalogue_fournisseur (tva_id)');
  50. $this->addSql('CREATE INDEX IDX_6CE0A3A248514B9C ON catalogue_fournisseur (catalogue_constructeur_id)');
  51. $this->addSql('CREATE INDEX IDX_6CE0A3A2D5E86FF ON catalogue_fournisseur (etat_id)');
  52. $this->addSql('CREATE INDEX IDX_6CE0A3A2670C757F ON catalogue_fournisseur (fournisseur_id)');
  53. $this->addSql('ALTER TABLE commande ADD etat_id INT NOT NULL, ADD fournisseur_id INT NOT NULL');
  54. $this->addSql('ALTER TABLE commande ADD CONSTRAINT FK_6EEAA67DD5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  55. $this->addSql('ALTER TABLE commande ADD CONSTRAINT FK_6EEAA67D670C757F FOREIGN KEY (fournisseur_id) REFERENCES fournisseur (id)');
  56. $this->addSql('CREATE INDEX IDX_6EEAA67DD5E86FF ON commande (etat_id)');
  57. $this->addSql('CREATE INDEX IDX_6EEAA67D670C757F ON commande (fournisseur_id)');
  58. $this->addSql('ALTER TABLE demande ADD etat_id INT NOT NULL');
  59. $this->addSql('ALTER TABLE demande ADD CONSTRAINT FK_2694D7A5D5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  60. $this->addSql('CREATE INDEX IDX_2694D7A5D5E86FF ON demande (etat_id)');
  61. $this->addSql('ALTER TABLE inventaire ADD demande_id INT DEFAULT NULL, ADD commande_id INT DEFAULT NULL, ADD catalogue_constructeur_id INT DEFAULT NULL, ADD catalogue_fournisseur_id INT DEFAULT NULL, ADD etat_id INT NOT NULL');
  62. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E080E95E18 FOREIGN KEY (demande_id) REFERENCES demande (id)');
  63. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E082EA2E54 FOREIGN KEY (commande_id) REFERENCES commande (id)');
  64. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E048514B9C FOREIGN KEY (catalogue_constructeur_id) REFERENCES catalogue_constructeur (id)');
  65. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E0999D4100 FOREIGN KEY (catalogue_fournisseur_id) REFERENCES catalogue_fournisseur (id)');
  66. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E0D5E86FF FOREIGN KEY (etat_id) REFERENCES etat (id)');
  67. $this->addSql('CREATE INDEX IDX_338920E080E95E18 ON inventaire (demande_id)');
  68. $this->addSql('CREATE INDEX IDX_338920E082EA2E54 ON inventaire (commande_id)');
  69. $this->addSql('CREATE INDEX IDX_338920E048514B9C ON inventaire (catalogue_constructeur_id)');
  70. $this->addSql('CREATE INDEX IDX_338920E0999D4100 ON inventaire (catalogue_fournisseur_id)');
  71. $this->addSql('CREATE INDEX IDX_338920E0D5E86FF ON inventaire (etat_id)');
  72. }
  74. public function down(Schema $schema): void
  75. {
  76. // this down() migration is auto-generated, please modify it to your needs
  77. $this->addSql('ALTER TABLE ligne_facture DROP FOREIGN KEY FK_611F5A297F2DEE08');
  78. $this->addSql('ALTER TABLE paiement DROP FOREIGN KEY FK_B1DC7A1E7F2DEE08');
  79. $this->addSql('ALTER TABLE paiement DROP FOREIGN KEY FK_B1DC7A1E438F5B63');
  80. $this->addSql('ALTER TABLE catalogue_constructeur DROP FOREIGN KEY FK_81F250B34D79775F');
  81. $this->addSql('ALTER TABLE catalogue_fournisseur DROP FOREIGN KEY FK_6CE0A3A24D79775F');
  82. $this->addSql('DROP TABLE facture');
  83. $this->addSql('DROP TABLE ligne_facture');
  84. $this->addSql('DROP TABLE livraison');
  85. $this->addSql('DROP TABLE mode_paiement');
  86. $this->addSql('DROP TABLE paiement');
  87. $this->addSql('DROP TABLE tva');
  88. $this->addSql('ALTER TABLE adresse CHANGE voie voie VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  89. $this->addSql('ALTER TABLE catalogue_constructeur DROP FOREIGN KEY FK_81F250B38815B605');
  90. $this->addSql('ALTER TABLE catalogue_constructeur DROP FOREIGN KEY FK_81F250B3D5E86FF');
  91. $this->addSql('DROP INDEX IDX_81F250B34D79775F ON catalogue_constructeur');
  92. $this->addSql('DROP INDEX IDX_81F250B38815B605 ON catalogue_constructeur');
  93. $this->addSql('DROP INDEX IDX_81F250B3D5E86FF ON catalogue_constructeur');
  94. $this->addSql('ALTER TABLE catalogue_constructeur DROP tva_id, DROP constructeur_id, DROP etat_id, CHANGE type type VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE ref ref VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE grille grille VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  95. $this->addSql('ALTER TABLE catalogue_fournisseur DROP FOREIGN KEY FK_6CE0A3A248514B9C');
  96. $this->addSql('ALTER TABLE catalogue_fournisseur DROP FOREIGN KEY FK_6CE0A3A2D5E86FF');
  97. $this->addSql('ALTER TABLE catalogue_fournisseur DROP FOREIGN KEY FK_6CE0A3A2670C757F');
  98. $this->addSql('DROP INDEX IDX_6CE0A3A24D79775F ON catalogue_fournisseur');
  99. $this->addSql('DROP INDEX IDX_6CE0A3A248514B9C ON catalogue_fournisseur');
  100. $this->addSql('DROP INDEX IDX_6CE0A3A2D5E86FF ON catalogue_fournisseur');
  101. $this->addSql('DROP INDEX IDX_6CE0A3A2670C757F ON catalogue_fournisseur');
  102. $this->addSql('ALTER TABLE catalogue_fournisseur DROP tva_id, DROP catalogue_constructeur_id, DROP etat_id, DROP fournisseur_id, CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE ref ref VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  103. $this->addSql('ALTER TABLE commande DROP FOREIGN KEY FK_6EEAA67DD5E86FF');
  104. $this->addSql('ALTER TABLE commande DROP FOREIGN KEY FK_6EEAA67D670C757F');
  105. $this->addSql('DROP INDEX IDX_6EEAA67DD5E86FF ON commande');
  106. $this->addSql('DROP INDEX IDX_6EEAA67D670C757F ON commande');
  107. $this->addSql('ALTER TABLE commande DROP etat_id, DROP fournisseur_id, CHANGE ref ref VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  108. $this->addSql('ALTER TABLE constructeur CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code code VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  109. $this->addSql('ALTER TABLE contrat CHANGE ref_contrat ref_contrat VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  110. $this->addSql('ALTER TABLE demande DROP FOREIGN KEY FK_2694D7A5D5E86FF');
  111. $this->addSql('DROP INDEX IDX_2694D7A5D5E86FF ON demande');
  112. $this->addSql('ALTER TABLE demande DROP etat_id, CHANGE ref ref VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  113. $this->addSql('ALTER TABLE equipement CHANGE type_equipement type_equipement VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE categorie categorie VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE sous_categorie sous_categorie VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE libelle libelle VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE ref_equipement ref_equipement VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE url_photo url_photo VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE responsable responsable VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE sn_chassis sn_chassis VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE sn_carrossage sn_carrossage VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE commentaire commentaire VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE no_parc no_parc VARCHAR(10) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  114. $this->addSql('ALTER TABLE etat CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE type type VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  115. $this->addSql('ALTER TABLE fournisseur CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code code VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  116. $this->addSql('ALTER TABLE inventaire DROP FOREIGN KEY FK_338920E080E95E18');
  117. $this->addSql('ALTER TABLE inventaire DROP FOREIGN KEY FK_338920E082EA2E54');
  118. $this->addSql('ALTER TABLE inventaire DROP FOREIGN KEY FK_338920E048514B9C');
  119. $this->addSql('ALTER TABLE inventaire DROP FOREIGN KEY FK_338920E0999D4100');
  120. $this->addSql('ALTER TABLE inventaire DROP FOREIGN KEY FK_338920E0D5E86FF');
  121. $this->addSql('DROP INDEX IDX_338920E080E95E18 ON inventaire');
  122. $this->addSql('DROP INDEX IDX_338920E082EA2E54 ON inventaire');
  123. $this->addSql('DROP INDEX IDX_338920E048514B9C ON inventaire');
  124. $this->addSql('DROP INDEX IDX_338920E0999D4100 ON inventaire');
  125. $this->addSql('DROP INDEX IDX_338920E0D5E86FF ON inventaire');
  126. $this->addSql('ALTER TABLE inventaire DROP demande_id, DROP commande_id, DROP catalogue_constructeur_id, DROP catalogue_fournisseur_id, DROP etat_id, CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE type type VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE grille grille VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE observation observation VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE url_photo url_photo VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  127. $this->addSql('ALTER TABLE maintenance CHANGE commentaire commentaire VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE contrat contrat VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  128. $this->addSql('ALTER TABLE operation CHANGE type_operation type_operation VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE categorie categorie VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE sous_categorie sous_categorie VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code_operation code_operation VARCHAR(10) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE libelle libelle VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  129. $this->addSql('ALTER TABLE pays CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code_iso code_iso VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  130. $this->addSql('ALTER TABLE reset_password_request CHANGE selector selector VARCHAR(20) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE hashed_token hashed_token VARCHAR(100) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  131. $this->addSql('ALTER TABLE site CHANGE libelle libelle VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE adr adr VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE tel tel VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE fax fax VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE courriel courriel VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code_site code_site VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  132. $this->addSql('ALTER TABLE societe CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE code_societe code_societe VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  133. $this->addSql('ALTER TABLE user CHANGE email email VARCHAR(180) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE password password VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE username username VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  134. $this->addSql('ALTER TABLE utilisateur CHANGE nom nom VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE prenom prenom VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE tel tel VARCHAR(10) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE courriel courriel VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  135. $this->addSql('ALTER TABLE ville CHANGE libelle libelle VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE cp cp VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  136. }
  137. }