zend-blog-3-backend
40 строк · 2.1 Кб
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 Version20240809184435 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 users ADD gender SMALLINT DEFAULT 1 NOT NULL COMMENT \'1: male, 2: female\'');
21$this->addSql('ALTER TABLE user_extra_info ADD user_agent_id INT DEFAULT NULL, ADD ip_long INT UNSIGNED DEFAULT NULL, ADD ip_addr VARCHAR(15) DEFAULT NULL');
22$this->addSql('ALTER TABLE user_extra_info ADD CONSTRAINT FK_F89334A5D499950B FOREIGN KEY (user_agent_id) REFERENCES tracking_agent (id) ON DELETE SET NULL');
23$this->addSql('ALTER TABLE user_extra_info ADD CONSTRAINT FK_F89334A528F0F5E7 FOREIGN KEY (ip_long) REFERENCES geo_location (ip_long) ON DELETE SET NULL');
24$this->addSql('CREATE INDEX IDX_F89334A5D499950B ON user_extra_info (user_agent_id)');
25$this->addSql('CREATE INDEX IDX_F89334A528F0F5E7 ON user_extra_info (ip_long)');
26}
27
28public function down(Schema $schema): void
29{
30// this down() migration is auto-generated, please modify it to your needs
31$this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
32
33$this->addSql('ALTER TABLE user_extra_info DROP FOREIGN KEY FK_F89334A5D499950B');
34$this->addSql('ALTER TABLE user_extra_info DROP FOREIGN KEY FK_F89334A528F0F5E7');
35$this->addSql('DROP INDEX IDX_F89334A5D499950B ON user_extra_info');
36$this->addSql('DROP INDEX IDX_F89334A528F0F5E7 ON user_extra_info');
37$this->addSql('ALTER TABLE user_extra_info DROP user_agent_id, DROP ip_long, DROP ip_addr');
38$this->addSql('ALTER TABLE users DROP gender');
39}
40}
41