zend-blog-3-backend
33 строки · 1.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 Version20230530121844 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 tracking ADD is_cdn TINYINT(1) DEFAULT NULL, ADD request_uri VARCHAR(128) DEFAULT NULL');21$this->addSql('UPDATE tracking SET is_cdn = 0');22$this->addSql('ALTER TABLE tracking CHANGE is_cdn is_cdn TINYINT(1) DEFAULT 0 NOT NULL');23$this->addSql('ALTER TABLE tracking ADD status_code SMALLINT DEFAULT NULL');24}25
26public function down(Schema $schema): void27{28// this down() migration is auto-generated, please modify it to your needs29$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');30
31$this->addSql('ALTER TABLE tracking DROP is_cdn, DROP request_uri');32}33}
34