migrations/Version20220208181101.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 Version20220208181101 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 contrat (id INT AUTO_INCREMENT NOT NULL, ref_contrat VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE contrat_maintenance (id INT AUTO_INCREMENT NOT NULL, contrat_id INT DEFAULT NULL, date_contrat DATE DEFAULT NULL, INDEX IDX_F55976CC1823061F (contrat_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE inventaire (id INT AUTO_INCREMENT NOT NULL, equipement_id INT DEFAULT NULL, site_id INT NOT NULL, libelle VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, grille VARCHAR(255) DEFAULT NULL, observation VARCHAR(255) DEFAULT NULL, url_photo VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_338920E0806F0F5C (equipement_id), INDEX IDX_338920E0F6BD1646 (site_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('ALTER TABLE contrat_maintenance ADD CONSTRAINT FK_F55976CC1823061F FOREIGN KEY (contrat_id) REFERENCES contrat (id)');
  27. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E0806F0F5C FOREIGN KEY (equipement_id) REFERENCES equipement (id)');
  28. $this->addSql('ALTER TABLE inventaire ADD CONSTRAINT FK_338920E0F6BD1646 FOREIGN KEY (site_id) REFERENCES site (id)');
  29. $this->addSql('ALTER TABLE maintenance ADD contrat_maintenance_id INT DEFAULT NULL, ADD inventaire_id INT DEFAULT NULL');
  30. $this->addSql('ALTER TABLE maintenance ADD CONSTRAINT FK_2F84F8E995269DC1 FOREIGN KEY (contrat_maintenance_id) REFERENCES contrat_maintenance (id)');
  31. $this->addSql('ALTER TABLE maintenance ADD CONSTRAINT FK_2F84F8E9CE430A85 FOREIGN KEY (inventaire_id) REFERENCES inventaire (id)');
  32. $this->addSql('CREATE INDEX IDX_2F84F8E995269DC1 ON maintenance (contrat_maintenance_id)');
  33. $this->addSql('CREATE INDEX IDX_2F84F8E9CE430A85 ON maintenance (inventaire_id)');
  34. }
  36. public function down(Schema $schema): void
  37. {
  38. // this down() migration is auto-generated, please modify it to your needs
  39. $this->addSql('ALTER TABLE contrat_maintenance DROP FOREIGN KEY FK_F55976CC1823061F');
  40. $this->addSql('ALTER TABLE maintenance DROP FOREIGN KEY FK_2F84F8E995269DC1');
  41. $this->addSql('ALTER TABLE maintenance DROP FOREIGN KEY FK_2F84F8E9CE430A85');
  42. $this->addSql('DROP TABLE contrat');
  43. $this->addSql('DROP TABLE contrat_maintenance');
  44. $this->addSql('DROP TABLE inventaire');
  45. $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`');
  46. $this->addSql('DROP INDEX IDX_2F84F8E995269DC1 ON maintenance');
  47. $this->addSql('DROP INDEX IDX_2F84F8E9CE430A85 ON maintenance');
  48. $this->addSql('ALTER TABLE maintenance DROP contrat_maintenance_id, DROP inventaire_id, CHANGE commentaire commentaire VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE contrat contrat VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  49. $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`');
  50. $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`');
  51. }
  52. }