zend-blog-3-backend
42 строки · 2.7 Кб
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 Version20200411070036 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 tracking CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
21$this->addSql('ALTER TABLE geo_location CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
22$this->addSql('ALTER TABLE tracking_agent CHANGE created_at created_at DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
23$this->addSql('ALTER TABLE tracking_archive CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
24$this->addSql('ALTER TABLE geo_location_city CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
25$this->addSql('ALTER TABLE geo_location_country CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
26$this->addSql('ALTER TABLE users CHANGE time_created time_created DATETIME(3) NOT NULL COMMENT \'(DC2Type:milliseconds_dt)\', CHANGE last_login last_login DATETIME(3) DEFAULT NULL COMMENT \'(DC2Type:milliseconds_dt)\'');
27}
28
29public function down(Schema $schema): void
30{
31// this down() migration is auto-generated, please modify it to your needs
32$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
33
34$this->addSql('ALTER TABLE geo_location CHANGE time_created time_created DATETIME NOT NULL');
35$this->addSql('ALTER TABLE geo_location_city CHANGE time_created time_created DATETIME NOT NULL');
36$this->addSql('ALTER TABLE geo_location_country CHANGE time_created time_created DATETIME NOT NULL');
37$this->addSql('ALTER TABLE tracking CHANGE time_created time_created DATETIME NOT NULL');
38$this->addSql('ALTER TABLE tracking_agent CHANGE created_at created_at DATETIME DEFAULT NULL');
39$this->addSql('ALTER TABLE tracking_archive CHANGE time_created time_created DATETIME NOT NULL');
40$this->addSql('ALTER TABLE users CHANGE time_created time_created DATETIME NOT NULL, CHANGE last_login last_login DATETIME DEFAULT NULL');
41}
42}
43