82 lines
2.7 KiB
C#
82 lines
2.7 KiB
C#
using System;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
|
|
namespace GWMS.Data.Migrations
|
|
{
|
|
public partial class AddOrderDefQty : Migration
|
|
{
|
|
protected override void Up(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.AddColumn<double>(
|
|
name: "OrderQtyStd",
|
|
table: "PlantDetail",
|
|
type: "double",
|
|
nullable: false,
|
|
defaultValue: 0.0);
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "PlantDetail",
|
|
keyColumn: "PlantId",
|
|
keyValue: 1,
|
|
column: "OrderQtyStd",
|
|
value: 18000.0);
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "PlantDetail",
|
|
keyColumn: "PlantId",
|
|
keyValue: 2,
|
|
column: "OrderQtyStd",
|
|
value: 18000.0);
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "PlantDetail",
|
|
keyColumn: "PlantId",
|
|
keyValue: 3,
|
|
column: "OrderQtyStd",
|
|
value: 18000.0);
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "PlantDetail",
|
|
keyColumn: "PlantId",
|
|
keyValue: 4,
|
|
column: "OrderQtyStd",
|
|
value: 18000.0);
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Transporter",
|
|
keyColumn: "TransporterId",
|
|
keyValue: 1,
|
|
column: "PositionUpdated",
|
|
value: new DateTime(2021, 8, 6, 18, 20, 35, 347, DateTimeKind.Local).AddTicks(1664));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Transporter",
|
|
keyColumn: "TransporterId",
|
|
keyValue: 2,
|
|
column: "PositionUpdated",
|
|
value: new DateTime(2021, 8, 6, 18, 20, 35, 347, DateTimeKind.Local).AddTicks(2482));
|
|
}
|
|
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
|
{
|
|
migrationBuilder.DropColumn(
|
|
name: "OrderQtyStd",
|
|
table: "PlantDetail");
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Transporter",
|
|
keyColumn: "TransporterId",
|
|
keyValue: 1,
|
|
column: "PositionUpdated",
|
|
value: new DateTime(2021, 8, 6, 15, 40, 12, 341, DateTimeKind.Local).AddTicks(9521));
|
|
|
|
migrationBuilder.UpdateData(
|
|
table: "Transporter",
|
|
keyColumn: "TransporterId",
|
|
keyValue: 2,
|
|
column: "PositionUpdated",
|
|
value: new DateTime(2021, 8, 6, 15, 40, 12, 341, DateTimeKind.Local).AddTicks(9901));
|
|
}
|
|
}
|
|
}
|