zend-blog-3-backend
32 строки · 1.2 Кб
1<?php
2
3declare(strict_types=1);4
5namespace Application\Migrations;6
7use Doctrine\DBAL\Schema\Schema;8use Doctrine\Migrations\AbstractMigration;9
10/**
11* Auto-generated Migration: Please modify to your needs!
12*/
13final class Version20220202064937 extends AbstractMigration14{
15public function up(Schema $schema): void16{17// this up() migration is auto-generated, please modify it to your needs18$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');19
20$this->addSql('ALTER TABLE comments ADD last_update_copy DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');21$this->addSql('UPDATE comments SET last_update = time_created WHERE last_update < time_created');22$this->addSql('UPDATE comments SET last_update_copy = last_update');23}24
25public function down(Schema $schema): void26{27// this down() migration is auto-generated, please modify it to your needs28$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');29
30$this->addSql('ALTER TABLE comments DROP last_update_copy');31}32}
33