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 Version20240106175257 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('CREATE TABLE online (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, crc32server BIGINT NOT NULL, time BIGINT NOT NULL, total INTEGER NOT NULL, players INTEGER NOT NULL, bots INTEGER NOT NULL)');
24          $this->addSql('CREATE TABLE messenger_messages (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, body CLOB NOT NULL, headers CLOB NOT NULL, queue_name VARCHAR(190) NOT NULL, created_at DATETIME NOT NULL --(DC2Type:datetime_immutable)
25          , available_at DATETIME NOT NULL --(DC2Type:datetime_immutable)
26          , delivered_at DATETIME DEFAULT NULL --(DC2Type:datetime_immutable)
27          )');
28          $this->addSql('CREATE INDEX IDX_75EA56E0FB7336F0 ON messenger_messages (queue_name)');
29          $this->addSql('CREATE INDEX IDX_75EA56E0E3BD61CE ON messenger_messages (available_at)');
30          $this->addSql('CREATE INDEX IDX_75EA56E016BA31DB ON messenger_messages (delivered_at)');
31      }
32  
33      public function down(Schema $schema): void
34      {
35          // this down() migration is auto-generated, please modify it to your needs
36          $this->addSql('DROP TABLE online');
37          $this->addSql('DROP TABLE messenger_messages');
38      }
39  }