25 lines
1.2 KiB
C#
25 lines
1.2 KiB
C#
|
namespace Weee.Migrations
|
|||
|
|
{
|
|||
|
|
using System;
|
|||
|
|
using System.Data.Entity.Migrations;
|
|||
|
|
|
|||
|
|
public partial class addParameterColumns : DbMigration
|
|||
|
|
{
|
|||
|
|
public override void Up()
|
|||
|
|
{
|
|||
|
|
AddColumn("dbo.LCARiskAssmtSurveyForm_MaterialC3Emission", "ParameterValue", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCARiskAssmtSurveyForm_MaterialC3Emission", "ParameterDescription", c => c.String(nullable:true, unicode:true));
|
|||
|
|
AddColumn("dbo.LCARiskAssmtSurveyForm_EmployeeCommuting", "ParameterValue", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCARiskAssmtSurveyForm_MaterialTransport", "ParameterValue", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public override void Down()
|
|||
|
|
{
|
|||
|
|
DropColumn("dbo.LCARiskAssmtSurveyForm_MaterialTransport", "ParameterValue");
|
|||
|
|
DropColumn("dbo.LCARiskAssmtSurveyForm_EmployeeCommuting", "ParameterValue");
|
|||
|
|
DropColumn("dbo.LCARiskAssmtSurveyForm_MaterialC3Emission", "ParameterDescription");
|
|||
|
|
DropColumn("dbo.LCARiskAssmtSurveyForm_MaterialC3Emission", "ParameterValue");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|