MembershipFees

Complexity

Total Complexity

2

Size/Duplication

Total Lines	23
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	10	1
A	up()	0	10	1

<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class MembershipFees extends AbstractMigration {
  public function up(): void {
    $this->execute("UPDATE guild_ranks SET guild_fee=135 WHERE id=1");
    $this->execute("UPDATE guild_ranks SET guild_fee=110 WHERE id=2");
    $this->execute("UPDATE guild_ranks SET guild_fee=75 WHERE id=3");
    $this->execute("UPDATE guild_ranks SET guild_fee=50 WHERE id=4");

    $this->execute("UPDATE order_ranks SET order_fee=150 WHERE id=1");
    $this->execute("UPDATE order_ranks SET order_fee=125 WHERE id=2");
    $this->execute("UPDATE order_ranks SET order_fee=90 WHERE id=3");
    $this->execute("UPDATE order_ranks SET order_fee=65 WHERE id=4");
  }

  public function down(): void {
    $this->execute("UPDATE guild_ranks SET guild_fee=135 WHERE id=4");
    $this->execute("UPDATE guild_ranks SET guild_fee=110 WHERE id=3");
    $this->execute("UPDATE guild_ranks SET guild_fee=75 WHERE id=2");
    $this->execute("UPDATE guild_ranks SET guild_fee=50 WHERE id=1");

    $this->execute("UPDATE order_ranks SET order_fee=150 WHERE id=4");
    $this->execute("UPDATE order_ranks SET order_fee=125 WHERE id=3");
    $this->execute("UPDATE order_ranks SET order_fee=90 WHERE id=2");
    $this->execute("UPDATE order_ranks SET order_fee=65 WHERE id=1");
  }
}
?>