Version20220306104047.php 2.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. declare(strict_types=1);
  3. namespace DoctrineMigrations;
  4. use Doctrine\DBAL\Schema\Schema;
  5. use Doctrine\Migrations\AbstractMigration;
  6. /**
  7. * Auto-generated Migration: Please modify to your needs!
  8. */
  9. final class Version20220306104047 extends AbstractMigration
  10. {
  11. public function getDescription(): string
  12. {
  13. return '';
  14. }
  15. public function up(Schema $schema): void
  16. {
  17. // this up() migration is auto-generated, please modify it to your needs
  18. }
  19. public function down(Schema $schema): void
  20. {
  21. // this down() migration is auto-generated, please modify it to your needs
  22. $this->addSql('ALTER TABLE commentaire CHANGE contenu contenu TINYTEXT DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  23. $this->addSql('ALTER TABLE film CHANGE titre titre VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE lien lien VARCHAR(191) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE information information LONGTEXT DEFAULT NULL COLLATE `utf8mb4_unicode_ci`');
  24. $this->addSql('ALTER TABLE genre CHANGE name name VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  25. $this->addSql('ALTER TABLE media_video CHANGE type type VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE identif identif VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  26. $this->addSql('ALTER TABLE realisateur CHANGE nom_complet nom_complet VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`');
  27. $this->addSql('ALTER TABLE user CHANGE username username VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE prenom prenom VARCHAR(191) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE nom nom VARCHAR(191) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE mail mail VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE password password VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE token token VARCHAR(191) NOT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE salt salt VARCHAR(191) DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, CHANGE roles roles LONGTEXT NOT NULL COLLATE `utf8mb4_unicode_ci` COMMENT \'(DC2Type:array)\'');
  28. }
  29. }