39 lines
2.3 KiB
C#
39 lines
2.3 KiB
C#
|
namespace Weee.Migrations
|
|||
|
|
{
|
|||
|
|
using System;
|
|||
|
|
using System.Data.Entity.Migrations;
|
|||
|
|
|
|||
|
|
public partial class add_WasteMaterialFields_to_LCA : DbMigration
|
|||
|
|
{
|
|||
|
|
public override void Up()
|
|||
|
|
{
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTotalQuantity", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialShippingDistance", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTKM1", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialNumOfBarrels", c => c.Int(nullable: false));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialWeight", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialWorkingDays", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTotalOutputKg", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTotalOutputT", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTreatmentPlantShippingDistance", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCAs", "WasteMaterialTKM2", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
AddColumn("dbo.LCARiskAssmtSurveyForm_WasteMaterial", "TotalQuantity", c => c.Decimal(nullable: false, precision: 24, scale: 12));
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public override void Down()
|
|||
|
|
{
|
|||
|
|
DropColumn("dbo.LCARiskAssmtSurveyForm_WasteMaterial", "TotalQuantity");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTKM2");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTreatmentPlantShippingDistance");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTotalOutputT");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTotalOutputKg");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialWorkingDays");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialWeight");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialNumOfBarrels");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTKM1");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialShippingDistance");
|
|||
|
|
DropColumn("dbo.LCAs", "WasteMaterialTotalQuantity");
|
|||
|
|
}
|
|||
|
|
}
|
|||
|
|
}
|