namespace Weee.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class addColumnsOtherCompounds : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "ingredientName", c => c.String(unicode:false, nullable:false, maxLength:200, defaultValue:""));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "warmGasType", c => c.Int(nullable:true));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "paraSource", c => c.String(nullable:true, maxLength:30, unicode:true));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "CH4Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue:0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "CO2Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "HFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "N2OValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "NF3Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "PFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "SF6Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "ingredientName", c => c.String(unicode: false, nullable: false, maxLength: 200, defaultValue: ""));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "warmGasType", c => c.Int(nullable: true));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "paraSource", c => c.String(nullable: true, maxLength: 30, unicode: true));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "CH4Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "CO2Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "HFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "N2OValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "NF3Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "PFCsValue", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
            AddColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "SF6Value", c => c.Decimal(nullable: false, precision: 24, scale: 12, defaultValue: 0));
        }
        
        public override void Down()
        {
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "SF6Value");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "PFCsValue");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "NF3Value");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "N2OValue");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "HFCsValue");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "CO2Value");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "CH4Value");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "paraSource");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "warmGasType");
            DropColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "ingredientName");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "SF6Value");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "PFCsValue");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "NF3Value");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "N2OValue");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "HFCsValue");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "CO2Value");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "CH4Value");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "paraSource");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "warmGasType");
            DropColumn("dbo.OrganizationLCAFabSurveyForm_OtherCompounds", "ingredientName");
        }
    }
}