namespace video_rental_store.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class Refactoring : DbMigration
    {
        public override void Up()
        {
            Sql("UPDATE MembershipTypes SET SignUpFee = 0 WHERE Id = 1");
            Sql("UPDATE MembershipTypes SET SignUpFee = 30 WHERE Id = 2");
            Sql("UPDATE MembershipTypes SET SignUpFee = 90 WHERE Id = 3");
            Sql("UPDATE MembershipTypes SET SignUpFee = 300 WHERE Id = 4");

            Sql("UPDATE MembershipTypes SET Name = 'Pay as You Go' WHERE Id = 1");
            Sql("UPDATE MembershipTypes SET Name = 'Monthly' WHERE Id = 2");
            Sql("UPDATE MembershipTypes SET Name = 'Quarterly' WHERE Id = 3");
            Sql("UPDATE MembershipTypes SET Name = 'Annual' WHERE Id = 4");
        }
        
        public override void Down()
        {
        }
    }
}
