1  <?php
 2  
 3  declare(strict_types=1);
 4  
 5  namespace DoctrineMigrations;
 6  
 7  use Doctrine\DBAL\Schema\Schema;
 8  use Doctrine\Migrations\AbstractMigration;
 9  
10  /**
11   * Auto-generated Migration: Please modify to your needs!
12   */
13  final class Version20240113013727 extends AbstractMigration
14  {
15      public function getDescription(): string
16      {
17          return '';
18      }
19  
20      public function up(Schema $schema): void
21      {
22          // this up() migration is auto-generated, please modify it to your needs
23          $this->addSql('ALTER TABLE server ADD COLUMN name VARCHAR(255) DEFAULT NULL');
24      }
25  
26      public function down(Schema $schema): void
27      {
28          // this down() migration is auto-generated, please modify it to your needs
29          $this->addSql('CREATE TEMPORARY TABLE __temp__server AS SELECT id, crc32server, added, updated, online, host, port FROM server');
30          $this->addSql('DROP TABLE server');
31          $this->addSql('CREATE TABLE server (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, crc32server BIGINT NOT NULL, added BIGINT NOT NULL, updated BIGINT NOT NULL, online BIGINT NOT NULL, host VARCHAR(255) NOT NULL, port INTEGER NOT NULL)');
32          $this->addSql('INSERT INTO server (id, crc32server, added, updated, online, host, port) SELECT id, crc32server, added, updated, online, host, port FROM __temp__server');
33          $this->addSql('DROP TABLE __temp__server');
34      }
35  }