/ migrations / Version20240107151414.php
Version20240107151414.php
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 Version20240107151414 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 player (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, crc32server BIGINT NOT NULL, crc32name BIGINT NOT NULL, joined BIGINT NOT NULL, updated BIGINT NOT NULL, online BIGINT NOT NULL, frags BIGINT NOT NULL, name VARCHAR(255) NOT 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('DROP TABLE player'); 30 } 31 }