migrations/Version20220318181141.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 Version20220318181141 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 catalogue_constructeur (id INT AUTO_INCREMENT NOT NULL, type VARCHAR(255) NOT NULL, libelle VARCHAR(255) NOT NULL, ref VARCHAR(255) NOT NULL, grille VARCHAR(255) DEFAULT NULL, prix NUMERIC(10, 2) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE catalogue_fournisseur (id INT AUTO_INCREMENT NOT NULL, libelle VARCHAR(255) NOT NULL, ref VARCHAR(255) NOT NULL, prix NUMERIC(10, 2) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE commande (id INT AUTO_INCREMENT NOT NULL, ref VARCHAR(255) NOT NULL, created_at DATE NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE constructeur (id INT AUTO_INCREMENT NOT NULL, libelle VARCHAR(255) NOT NULL, code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE demande (id INT AUTO_INCREMENT NOT NULL, ref VARCHAR(255) NOT NULL, created_at DATE NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE etat (id INT AUTO_INCREMENT NOT NULL, libelle VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE fournisseur (id INT AUTO_INCREMENT NOT NULL, libelle VARCHAR(255) NOT NULL, code VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. }
  32. public function down(Schema $schema): void
  33. {
  34. // this down() migration is auto-generated, please modify it to your needs
  35. $this->addSql('DROP TABLE catalogue_constructeur');
  36. $this->addSql('DROP TABLE catalogue_fournisseur');
  37. $this->addSql('DROP TABLE commande');
  38. $this->addSql('DROP TABLE constructeur');
  39. $this->addSql('DROP TABLE demande');
  40. $this->addSql('DROP TABLE etat');
  41. $this->addSql('DROP TABLE fournisseur');
  42. $this->addSql('ALTER TABLE adresse CHANGE voie voie VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  43. $this->addSql('ALTER TABLE contrat CHANGE ref_contrat ref_contrat VARCHAR(255) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  44. $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`');
  45. $this->addSql('ALTER TABLE inventaire 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`');
  46. $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`');
  47. $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`');
  48. $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`');
  49. $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`');
  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`, CHANGE code_site code_site VARCHAR(255) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  51. $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`');
  52. $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`');
  53. $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`');
  54. $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`');
  55. }
  56. }