zend-blog-3-backend
36 строк · 1.3 Кб
1<?php
2
3namespace Application\Migrations;4
5use Doctrine\DBAL\Schema\Schema;6use Doctrine\Migrations\AbstractMigration;7
8/**
9* Auto-generated Migration: Please modify to your needs!
10*/
11class Version20150721233323 extends AbstractMigration12{
13/**14* @param Schema $schema
15*/
16public function up(Schema $schema): void17{18// this up() migration is auto-generated, please modify it to your needs19$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');20
21$this->addSql('ALTER TABLE users DROP ip_addr, CHANGE time_last last_login DATETIME DEFAULT NULL');22$this->addSql('ALTER TABLE users ADD login_count INT NOT NULL AFTER last_login');23}24
25/**26* @param Schema $schema
27*/
28public function down(Schema $schema): void29{30// this down() migration is auto-generated, please modify it to your needs31$this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');32
33$this->addSql('ALTER TABLE users ADD ip_addr VARCHAR(15) DEFAULT NULL, CHANGE last_login time_last DATETIME DEFAULT NULL');34$this->addSql('ALTER TABLE users DROP login_count');35}36}
37