migrations/Version20250809131517.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 Version20250809131517 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 content_recommendation (id INT AUTO_INCREMENT NOT NULL, product_id INT DEFAULT NULL, recommended JSON DEFAULT NULL, state INT NOT NULL, notes LONGTEXT DEFAULT NULL, deleted DATETIME DEFAULT NULL, deleted_by VARCHAR(255) DEFAULT NULL, created DATETIME NOT NULL, creator VARCHAR(255) NOT NULL, modified DATETIME NOT NULL, modified_by VARCHAR(255) NOT NULL, uuid VARCHAR(50) NOT NULL, UNIQUE INDEX UNIQ_29D9DE06D17F50A6 (uuid), INDEX IDX_29D9DE064584665A (product_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('ALTER TABLE content_recommendation ADD CONSTRAINT FK_29D9DE064584665A FOREIGN KEY (product_id) REFERENCES product (id) ON DELETE CASCADE');
  25. $this->addSql('ALTER TABLE `order` CHANGE cart cart JSON NOT NULL');
  26. $this->addSql('ALTER TABLE payment CHANGE user_data user_data JSON NOT NULL, CHANGE sent_data sent_data JSON NOT NULL, CHANGE received_data received_data JSON DEFAULT NULL, CHANGE credit_card_received_data credit_card_received_data JSON DEFAULT NULL');
  27. $this->addSql('ALTER TABLE post CHANGE content content JSON NOT NULL');
  28. $this->addSql('ALTER TABLE post_translations CHANGE content content JSON NOT NULL');
  29. $this->addSql('ALTER TABLE product_search CHANGE titles titles JSON NOT NULL, CHANGE slugs slugs JSON NOT NULL, CHANGE specs specs JSON DEFAULT NULL');
  30. $this->addSql('ALTER TABLE project CHANGE data data JSON NOT NULL');
  31. $this->addSql('ALTER TABLE shipping_zone_price CHANGE configuration configuration JSON NOT NULL');
  32. $this->addSql('ALTER TABLE user CHANGE roles roles JSON NOT NULL');
  33. }
  35. public function down(Schema $schema): void
  36. {
  37. // this down() migration is auto-generated, please modify it to your needs
  38. $this->addSql('ALTER TABLE content_recommendation DROP FOREIGN KEY FK_29D9DE064584665A');
  39. $this->addSql('DROP TABLE content_recommendation');
  40. $this->addSql('ALTER TABLE `order` CHANGE cart cart JSON NOT NULL COLLATE `utf8mb4_bin`');
  41. $this->addSql('ALTER TABLE payment CHANGE user_data user_data JSON NOT NULL COLLATE `utf8mb4_bin`, CHANGE sent_data sent_data JSON NOT NULL COLLATE `utf8mb4_bin`, CHANGE received_data received_data JSON DEFAULT NULL COLLATE `utf8mb4_bin`, CHANGE credit_card_received_data credit_card_received_data JSON DEFAULT NULL COLLATE `utf8mb4_bin`');
  42. $this->addSql('ALTER TABLE post CHANGE content content JSON NOT NULL COLLATE `utf8mb4_bin`');
  43. $this->addSql('ALTER TABLE post_translations CHANGE content content JSON NOT NULL COLLATE `utf8mb4_bin`');
  44. $this->addSql('ALTER TABLE product_search CHANGE titles titles JSON NOT NULL COLLATE `utf8mb4_bin`, CHANGE slugs slugs JSON NOT NULL COLLATE `utf8mb4_bin`, CHANGE specs specs JSON DEFAULT NULL COLLATE `utf8mb4_bin`');
  45. $this->addSql('ALTER TABLE project CHANGE data data JSON NOT NULL COLLATE `utf8mb4_bin`');
  46. $this->addSql('ALTER TABLE shipping_zone_price CHANGE configuration configuration JSON NOT NULL COLLATE `utf8mb4_bin`');
  47. $this->addSql('ALTER TABLE `user` CHANGE roles roles JSON NOT NULL COLLATE `utf8mb4_bin`');
  48. }
  49. }