zend-blog-3-backend

1
<?php
2

3
declare(strict_types=1);
4

5
namespace Application\Migrations;
6

7
use Doctrine\DBAL\Schema\Schema;
8
use Doctrine\Migrations\AbstractMigration;
9

10
/**
11
 * Auto-generated Migration: Please modify to your needs!
12
 */
13
final class Version20200410220309 extends AbstractMigration
14
{
15
    public 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 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)\'');
21
        $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)\'');
22
        $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)\'');
23

24
        $this->addSql('UPDATE posts SET time_created = DATE_ADD(time_created, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND)');
25
        $this->addSql('UPDATE comments SET time_created = DATE_ADD(time_created, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND)');
26
        $this->addSql('UPDATE media_file SET time_created = DATE_ADD(time_created, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND)');
27
        $this->addSql('UPDATE posts SET last_update = DATE_ADD(last_update, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND) WHERE last_update IS NOT NULL');
28
        $this->addSql('UPDATE comments SET last_update = DATE_ADD(last_update, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND) WHERE last_update IS NOT NULL');
29
        $this->addSql('UPDATE media_file SET last_update = DATE_ADD(last_update, INTERVAL TRUNCATE(RAND() * 999, 0) * 1000 MICROSECOND) WHERE last_update IS NOT NULL');
30
    }
31

32
    public function down(Schema $schema): void
33
    {
34
        // this down() migration is auto-generated, please modify it to your needs
35
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
36

37
        $this->addSql('ALTER TABLE comments CHANGE time_created time_created DATETIME NOT NULL, CHANGE last_update last_update DATETIME DEFAULT NULL');
38
        $this->addSql('ALTER TABLE media_file CHANGE time_created time_created DATETIME NOT NULL, CHANGE last_update last_update DATETIME NOT NULL');
39
        $this->addSql('ALTER TABLE posts CHANGE time_created time_created DATETIME NOT NULL, CHANGE last_update last_update DATETIME DEFAULT NULL');
40
    }
41
}
42