<?php
declare(strict_types=1);
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
final class Version20220624094301 extends AbstractMigration
{
public function getDescription(): string
{
return 'Game: change type string to int';
}
public function up(Schema $schema): void
{
// this up() migration is auto-generated, please modify it to your needs
// replace empty string with NULL (query added manually)
$this->addSql("
UPDATE
`match`
SET
score1_match = CASE score1_match WHEN '' THEN NULL ELSE score1_match END,
e1tr2_match = CASE e1tr2_match WHEN '' THEN NULL ELSE e1tr2_match END,
e1tt2_match = CASE e1tt2_match WHEN '' THEN NULL ELSE e1tt2_match END,
e1tr3_match = CASE e1tr3_match WHEN '' THEN NULL ELSE e1tr3_match END,
e1tt3_match = CASE e1tt3_match WHEN '' THEN NULL ELSE e1tt3_match END,
e1lfr_match = CASE e1lfr_match WHEN '' THEN NULL ELSE e1lfr_match END,
e1lft_match = CASE e1lft_match WHEN '' THEN NULL ELSE e1lft_match END,
e1ro_match = CASE e1ro_match WHEN '' THEN NULL ELSE e1ro_match END,
e1rd_match = CASE e1rd_match WHEN '' THEN NULL ELSE e1rd_match END,
e1pd_match = CASE e1pd_match WHEN '' THEN NULL ELSE e1pd_match END,
e1in_match = CASE e1in_match WHEN '' THEN NULL ELSE e1in_match END,
e1bp_match = CASE e1bp_match WHEN '' THEN NULL ELSE e1bp_match END,
e1code_match = CASE e1code_match WHEN '' THEN NULL ELSE e1code_match END,
e1f_match = CASE e1f_match WHEN '' THEN NULL ELSE e1f_match END,
e1pts_match = CASE e1pts_match WHEN '' THEN NULL ELSE e1pts_match END,
e1eval_match = CASE e1eval_match WHEN '' THEN NULL ELSE e1eval_match END,
e1fpr_match = CASE e1fpr_match WHEN '' THEN NULL ELSE e1fpr_match END,
e1blka_match = CASE e1blka_match WHEN '' THEN NULL ELSE e1blka_match END,
e1plusminus_match = CASE e1plusminus_match WHEN '' THEN NULL ELSE e1plusminus_match END,
score1_q1_match = CASE score1_q1_match WHEN '' THEN NULL ELSE score1_q1_match END,
score1_q2_match = CASE score1_q2_match WHEN '' THEN NULL ELSE score1_q2_match END,
score1_q3_match = CASE score1_q3_match WHEN '' THEN NULL ELSE score1_q3_match END,
score1_q4_match = CASE score1_q4_match WHEN '' THEN NULL ELSE score1_q4_match END,
score1_ot_match = CASE score1_ot_match WHEN '' OR ' ' THEN NULL ELSE score1_ot_match END,
score2_match = CASE score2_match WHEN '' THEN NULL ELSE score2_match END,
e2tr2_match = CASE e2tr2_match WHEN '' THEN NULL ELSE e2tr2_match END,
e2tt2_match = CASE e2tt2_match WHEN '' THEN NULL ELSE e2tt2_match END,
e2tr3_match = CASE e2tr3_match WHEN '' THEN NULL ELSE e2tr3_match END,
e2tt3_match = CASE e2tt3_match WHEN '' THEN NULL ELSE e2tt3_match END,
e2lfr_match = CASE e2lfr_match WHEN '' THEN NULL ELSE e2lfr_match END,
e2lft_match = CASE e2lft_match WHEN '' THEN NULL ELSE e2lft_match END,
e2ro_match = CASE e2ro_match WHEN '' THEN NULL ELSE e2ro_match END,
e2rd_match = CASE e2rd_match WHEN '' THEN NULL ELSE e2rd_match END,
e2pd_match = CASE e2pd_match WHEN '' THEN NULL ELSE e2pd_match END,
e2in_match = CASE e2in_match WHEN '' THEN NULL ELSE e2in_match END,
e2bp_match = CASE e2bp_match WHEN '' THEN NULL ELSE e2bp_match END,
e2code_match = CASE e2code_match WHEN '' THEN NULL ELSE e2code_match END,
e2f_match = CASE e2f_match WHEN '' THEN NULL ELSE e2f_match END,
e2pts_match = CASE e2pts_match WHEN '' THEN NULL ELSE e2pts_match END,
e2eval_match = CASE e2eval_match WHEN '' THEN NULL ELSE e2eval_match END,
e2fpr_match = CASE e2fpr_match WHEN '' THEN NULL ELSE e2fpr_match END,
e2blka_match = CASE e2blka_match WHEN '' THEN NULL ELSE e2blka_match END,
e2plusminus_match = CASE e2plusminus_match WHEN '' THEN NULL ELSE e2plusminus_match END,
score2_q1_match = CASE score2_q1_match WHEN '' THEN NULL ELSE score2_q1_match END,
score2_q2_match = CASE score2_q2_match WHEN '' THEN NULL ELSE score2_q2_match END,
score2_q3_match = CASE score2_q3_match WHEN '' THEN NULL ELSE score2_q3_match END,
score2_q4_match = CASE score2_q4_match WHEN '' THEN NULL ELSE score2_q4_match END,
score2_ot_match = CASE score2_ot_match WHEN '' OR ' ' THEN NULL ELSE score2_ot_match END;
");
// change the type of the columns
$this->addSql('ALTER TABLE `match` CHANGE score1_match score1_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_match score2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1tr2_match e1tr2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1tt2_match e1tt2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1tr3_match e1tr3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1tt3_match e1tt3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1lfr_match e1lfr_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1lft_match e1lft_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1ro_match e1ro_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1rd_match e1rd_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1pd_match e1pd_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1in_match e1in_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1bp_match e1bp_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1code_match e1code_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1f_match e1f_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1pts_match e1pts_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1eval_match e1eval_match SMALLINT DEFAULT NULL, CHANGE e2tr2_match e2tr2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2tt2_match e2tt2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2tr3_match e2tr3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2tt3_match e2tt3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2lfr_match e2lfr_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2lft_match e2lft_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2ro_match e2ro_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2rd_match e2rd_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2pd_match e2pd_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2in_match e2in_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2bp_match e2bp_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2code_match e2code_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2f_match e2f_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2pts_match e2pts_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2eval_match e2eval_match SMALLINT DEFAULT NULL, CHANGE score1_q1_match score1_q1_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_q1_match score2_q1_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score1_q2_match score1_q2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_q2_match score2_q2_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score1_q3_match score1_q3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_q3_match score2_q3_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score1_q4_match score1_q4_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_q4_match score2_q4_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score1_ot_match score1_ot_match TINYINT UNSIGNED DEFAULT NULL, CHANGE score2_ot_match score2_ot_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1fpr_match e1fpr_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1blka_match e1blka_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e1plusminus_match e1plusminus_match SMALLINT DEFAULT NULL, CHANGE e2fpr_match e2fpr_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2blka_match e2blka_match TINYINT UNSIGNED DEFAULT NULL, CHANGE e2plusminus_match e2plusminus_match SMALLINT DEFAULT NULL');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE `match` CHANGE score1_match score1_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_match score2_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1tr2_match e1tr2_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1tt2_match e1tt2_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1tr3_match e1tr3_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1tt3_match e1tt3_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1lfr_match e1lfr_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1lft_match e1lft_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1ro_match e1ro_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1rd_match e1rd_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1pd_match e1pd_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1in_match e1in_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1bp_match e1bp_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1code_match e1code_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1f_match e1f_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1pts_match e1pts_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1eval_match e1eval_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2tr2_match e2tr2_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2tt2_match e2tt2_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2tr3_match e2tr3_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2tt3_match e2tt3_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2lfr_match e2lfr_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2lft_match e2lft_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2ro_match e2ro_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2rd_match e2rd_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2pd_match e2pd_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2in_match e2in_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2bp_match e2bp_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2code_match e2code_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2f_match e2f_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2pts_match e2pts_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e2eval_match e2eval_match VARCHAR(5) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score1_q1_match score1_q1_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_q1_match score2_q1_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score1_q2_match score1_q2_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_q2_match score2_q2_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score1_q3_match score1_q3_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_q3_match score2_q3_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score1_q4_match score1_q4_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_q4_match score2_q4_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score1_ot_match score1_ot_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE score2_ot_match score2_ot_match VARCHAR(3) CHARACTER SET utf8 DEFAULT NULL COLLATE `utf8_general_ci`, CHANGE e1fpr_match e1fpr_match INT DEFAULT NULL, CHANGE e1blka_match e1blka_match INT DEFAULT NULL, CHANGE e1plusminus_match e1plusminus_match INT DEFAULT NULL, CHANGE e2fpr_match e2fpr_match INT DEFAULT NULL, CHANGE e2blka_match e2blka_match INT DEFAULT NULL, CHANGE e2plusminus_match e2plusminus_match INT DEFAULT NULL');
}
}