namespace Weee.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class sevenWarmGasModification : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.Parameters", "CH4Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.Parameters", "N2OValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.Parameters", "HFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.Parameters", "PFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.Parameters", "SF6Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.Parameters", "NF3Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            DropColumn("dbo.NonYearlyParameterTypes", "CO2");
            DropColumn("dbo.NonYearlyParameterTypes", "CH4");
            DropColumn("dbo.NonYearlyParameterTypes", "N2O");
            DropColumn("dbo.NonYearlyParameterTypes", "HFCs");
            DropColumn("dbo.NonYearlyParameterTypes", "PFCs");
            DropColumn("dbo.NonYearlyParameterTypes", "SF6");
            DropColumn("dbo.NonYearlyParameterTypes", "NF3");
            DropColumn("dbo.YearlyParameterTypes", "CO2");
            DropColumn("dbo.YearlyParameterTypes", "CH4");
            DropColumn("dbo.YearlyParameterTypes", "N2O");
            DropColumn("dbo.YearlyParameterTypes", "HFCs");
            DropColumn("dbo.YearlyParameterTypes", "PFCs");
            DropColumn("dbo.YearlyParameterTypes", "SF6");
            DropColumn("dbo.YearlyParameterTypes", "NF3");
        }
        
        public override void Down()
        {
            AddColumn("dbo.YearlyParameterTypes", "NF3", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "SF6", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "PFCs", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "HFCs", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "N2O", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "CH4", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.YearlyParameterTypes", "CO2", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "NF3", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "SF6", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "PFCs", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "HFCs", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "N2O", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "CH4", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.NonYearlyParameterTypes", "CO2", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            DropColumn("dbo.Parameters", "NF3Value");
            DropColumn("dbo.Parameters", "SF6Value");
            DropColumn("dbo.Parameters", "PFCsValue");
            DropColumn("dbo.Parameters", "HFCsValue");
            DropColumn("dbo.Parameters", "N2OValue");
            DropColumn("dbo.Parameters", "CH4Value");
        }
    }
}