<?php declare(strict_types=1); namespace DoctrineMigrations; use Doctrine\DBAL\Schema\Schema; use Doctrine\Migrations\AbstractMigration; /** * Auto-generated Migration: Please modify to your needs! */ final class Version20230927113630 extends AbstractMigration { public function getDescription(): string { return ''; } public function up(Schema $schema): void { // this up() migration is auto-generated, please modify it to your needs $this->addSql('ALTER TABLE `order` CHANGE data data LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', CHANGE change_date change_date DATETIME DEFAULT CURRENT_TIMESTAMP'); $this->addSql('ALTER TABLE product ADD update_time DATETIME DEFAULT CURRENT_TIMESTAMP, DROP change_date'); $this->addSql('ALTER TABLE stock ADD update_time DATETIME DEFAULT CURRENT_TIMESTAMP, DROP change_date'); } public function down(Schema $schema): void { // this down() migration is auto-generated, please modify it to your needs $this->addSql('ALTER TABLE stock ADD change_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, DROP update_time'); $this->addSql('ALTER TABLE product ADD change_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, DROP update_time'); $this->addSql('ALTER TABLE `order` CHANGE data data LONGTEXT NOT NULL COLLATE `utf8mb4_bin`, CHANGE change_date change_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL'); } }