zend-blog-3-backend
32 строки · 1.4 Кб
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 Version20211219205322 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 comments ADD tree_left_key INT UNSIGNED DEFAULT NULL, ADD tree_right_key INT UNSIGNED DEFAULT NULL, ADD tree_depth INT UNSIGNED DEFAULT 1 NOT NULL');
21$this->addSql('ALTER TABLE category ADD tree_left_key INT UNSIGNED DEFAULT NULL, ADD tree_right_key INT UNSIGNED DEFAULT NULL, ADD tree_depth INT UNSIGNED DEFAULT 1 NOT NULL');
22}
23
24public function down(Schema $schema): void
25{
26// this down() migration is auto-generated, please modify it to your needs
27$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
28
29$this->addSql('ALTER TABLE category DROP tree_left_key, DROP tree_right_key, DROP tree_depth');
30$this->addSql('ALTER TABLE comments DROP tree_left_key, DROP tree_right_key, DROP tree_depth');
31}
32}
33