zend-blog-3-backend
34 строки · 2.3 Кб
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 Version20220130185648 extends AbstractMigration
14{
15public function up(Schema $schema): void
16{
17// this up() migration is auto-generated, please modify it to your needs
18$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
19
20$this->addSql('ALTER TABLE media_file CHANGE time_created time_created DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
21$this->addSql('ALTER TABLE posts CHANGE time_created time_created DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
22$this->addSql('ALTER TABLE comments CHANGE time_created time_created DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NOW(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
23}
24
25public function down(Schema $schema): void
26{
27// this down() migration is auto-generated, please modify it to your needs
28$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
29
30$this->addSql('ALTER TABLE comments CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
31$this->addSql('ALTER TABLE media_file CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
32$this->addSql('ALTER TABLE posts CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_update last_update DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
33}
34}
35