57 lines
5.0 KiB
C#
57 lines
5.0 KiB
C#
|
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");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|