demo20230512/Migrations/202212060744182_ProductLCAAddAllocation.cs

43 lines
2.7 KiB
C#
Raw Permalink Normal View History

2023-05-12 10:20:28 +08:00
namespace Weee.Migrations
{
using System;
using System.Data.Entity.Migrations;
public partial class ProductLCAAddAllocation : DbMigration
{
public override void Up()
{
AddColumn("dbo.ProductLCA", "ProductAllocationWorkHour", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationPowerUsage", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationWaterUsage", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationWaste", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationWasteWater", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationWasteTransport", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationVehicle", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationGasolineEquipment", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationKitchen", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationFireEquipment", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationRefrigerant", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationSteamUsage", c => c.Int(nullable: false, defaultValue: -1));
AddColumn("dbo.ProductLCA", "ProductAllocationOtherCompound", c => c.Int(nullable: false, defaultValue: -1));
}
public override void Down()
{
DropColumn("dbo.ProductLCA", "ProductAllocationOtherCompound");
DropColumn("dbo.ProductLCA", "ProductAllocationSteamUsage");
DropColumn("dbo.ProductLCA", "ProductAllocationRefrigerant");
DropColumn("dbo.ProductLCA", "ProductAllocationFireEquipment");
DropColumn("dbo.ProductLCA", "ProductAllocationKitchen");
DropColumn("dbo.ProductLCA", "ProductAllocationGasolineEquipment");
DropColumn("dbo.ProductLCA", "ProductAllocationVehicle");
DropColumn("dbo.ProductLCA", "ProductAllocationWasteTransport");
DropColumn("dbo.ProductLCA", "ProductAllocationWasteWater");
DropColumn("dbo.ProductLCA", "ProductAllocationWaste");
DropColumn("dbo.ProductLCA", "ProductAllocationWaterUsage");
DropColumn("dbo.ProductLCA", "ProductAllocationPowerUsage");
DropColumn("dbo.ProductLCA", "ProductAllocationWorkHour");
}
}
}