class ChangeScoringMusicChallenge < ActiveRecord::Migration[5.1]
  def change
    execute "update submissions set score = 0, score_secondary = 0 where challenge_id = 12;"
    execute "update submissions set score = 28.5914468, score_secondary = 31.01892051 where id = 3530;"
execute "update submissions set score = 28.17302633, score_secondary = 30.62651468 where id = 3532;"
execute "update submissions set score = 27.08935975, score_secondary = 29.55906082 where id = 3535;"
execute "update submissions set score = 26.66686415, score_secondary = 31.21847482 where id = 3691;"
execute "update submissions set score = 26.16985886, score_secondary = 28.84992084 where id = 3553;"
execute "update submissions set score = 25.19893089, score_secondary = 28.13354755 where id = 3561;"
execute "update submissions set score = 25.11440898, score_secondary = 27.82040745 where id = 3560;"
execute "update submissions set score = 24.77473122, score_secondary = 28.04321417 where id = 3590;"
execute "update submissions set score = 24.71000294, score_secondary = 28.61153066 where id = 3713;"
execute "update submissions set score = 24.65579773, score_secondary = 27.83050709 where id = 3637;"
execute "update submissions set score = 24.56981238, score_secondary = 27.74638437 where id = 3615;"
execute "update submissions set score = 24.26332089, score_secondary = 27.09305757 where id = 3572;"
execute "update submissions set score = 24.16927564, score_secondary = 27.23279425 where id = 3645;"
execute "update submissions set score = 24.06720834, score_secondary = 28.46923938 where id = 3770;"
execute "update submissions set score = 23.89336119, score_secondary = 28.3848418 where id = 3677;"
execute "update submissions set score = 23.83506335, score_secondary = 26.56630798 where id = 3552;"
execute "update submissions set score = 23.58911123, score_secondary = 26.74347868 where id = 3642;"
execute "update submissions set score = 23.53506346, score_secondary = 26.45487431 where id = 3612;"
execute "update submissions set score = 23.18226779, score_secondary = 27.41649535 where id = 3757;"
execute "update submissions set score = 22.85437491, score_secondary = 28.15111975 where id = 3809;"
execute "update submissions set score = 21.96280861, score_secondary = 25.48663822 where id = 3636;"
execute "update submissions set score = 21.94769148, score_secondary = 28.27886306 where id = 3864;"
execute "update submissions set score = 21.77959159, score_secondary = 26.73455342 where id = 3755;"
execute "update submissions set score = 21.5996016, score_secondary = 24.68951763 where id = 3616;"
execute "update submissions set score = 21.42547762, score_secondary = 24.52826819 where id = 3611;"
execute "update submissions set score = 21.27048715, score_secondary = 27.08805088 where id = 3776;"
execute "update submissions set score = 21.03306512, score_secondary = 25.55093141 where id = 3777;"
execute "update submissions set score = 20.94626911, score_secondary = 26.6471807 where id = 3786;"
execute "update submissions set score = 20.9076571, score_secondary = 26.66485266 where id = 3796;"
execute "update submissions set score = 20.859975, score_secondary = 24.31971162 where id = 3647;"
execute "update submissions set score = 20.84903571, score_secondary = 25.28679022 where id = 3758;"
execute "update submissions set score = 20.51494993, score_secondary = 24.73902373 where id = 3712;"
execute "update submissions set score = 20.32458984, score_secondary = 25.72323085 where id = 3768;"
execute "update submissions set score = 20.31915925, score_secondary = 25.38643545 where id = 3811;"
execute "update submissions set score = 20.06376928, score_secondary = 23.46321571 where id = 3618;"
execute "update submissions set score = 20.01864472, score_secondary = 23.63602835 where id = 3656;"
execute "update submissions set score = 19.96176823, score_secondary = 24.0148388 where id = 3706;"
execute "update submissions set score = 19.92079828, score_secondary = 25.26875057 where id = 3727;"
execute "update submissions set score = 19.79981439, score_secondary = 25.65385057 where id = 3787;"
execute "update submissions set score = 19.20136394, score_secondary = 23.97026128 where id = 3725;"
execute "update submissions set score = 19.14989446, score_secondary = 24.47718642 where id = 3784;"
execute "update submissions set score = 18.90055869, score_secondary = 26.39633565 where id = 3857;"
execute "update submissions set score = 18.73160856, score_secondary = 22.50224129 where id = 3617;"
execute "update submissions set score = 18.69074798, score_secondary = 23.51442466 where id = 3766;"
execute "update submissions set score = 18.62019255, score_secondary = 24.8406921 where id = 3815;"
execute "update submissions set score = 18.40842395, score_secondary = 21.68704812 where id = 3599;"
execute "update submissions set score = 18.02455784, score_secondary = 22.9757841 where id = 3788;"
execute "update submissions set score = 17.9334457, score_secondary = 22.67111452 where id = 3724;"
execute "update submissions set score = 17.86682399, score_secondary = 22.74590906 where id = 3754;"
execute "update submissions set score = 17.53861071, score_secondary = 21.73938846 where id = 3649;"
execute "update submissions set score = 17.48168798, score_secondary = 24.52134209 where id = 3871;"
execute "update submissions set score = 17.27917903, score_secondary = 21.83453031 where id = 3743;"
execute "update submissions set score = 16.9138665, score_secondary = 23.38382654 where id = 3816;"
execute "update submissions set score = 16.59354791, score_secondary = 20.69529045 where id = 3646;"
execute "update submissions set score = 16.31573786, score_secondary = 20.60128461 where id = 3722;"
execute "update submissions set score = 15.50603782, score_secondary = 21.366705 where id = 3798;"
execute "update submissions set score = 14.84664894, score_secondary = 20.10006384 where id = 3763;"
execute "update submissions set score = 14.46233175, score_secondary = 21.69057162 where id = 3808;"
execute "update submissions set score = 14.13811451, score_secondary = 20.19819701 where id = 3779;"
execute "update submissions set score = 13.60381041, score_secondary = 19.98649045 where id = 3813;"
execute "update submissions set score = 13.47183215, score_secondary = 18.06408087 where id = 3594;"
execute "update submissions set score = 13.12898916, score_secondary = 17.81947066 where id = 3598;"
execute "update submissions set score = 12.35522942, score_secondary = 19.01771004 where id = 3812;"
execute "update submissions set score = 10.78058632, score_secondary = 19.23857998 where id = 3870;"
execute "update submissions set score = 10.52194287, score_secondary = 17.6555709 where id = 3820;"
execute "update submissions set score = 5.308858886, score_secondary = 16.73299958 where id = 3876;"
execute "update submissions set score = 5.182851254, score_secondary = 13.44769638 where id = 3821;"
  end
end
