YG-MW-WCS/Projects/永冠/WCS.Service/Migrations/20210709044558_7-9-1.cs

using Microsoft.EntityFrameworkCore.Migrations;

namespace WCS.Service.Migrations
{
    public partial class _791 : Migration
    {
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn(
                name: "DestPosition_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "DestPosition_2",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "Finish_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "Finish_2",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "PH_Status_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "PRIORITY_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "PRIORITY_2",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "RES1_2",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "RES2_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "TaskID_1",
                table: "WCS_RGV521");

            migrationBuilder.DropColumn(
                name: "DestPosition_1",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "DestPosition_2",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "PRIORITY_1",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "PRIORITY_2",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "RES1_1",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "RES1_2",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "RES2_1",
                table: "WCS_RGV520");

            migrationBuilder.DropColumn(
                name: "TaskID_1",
                table: "WCS_RGV520");

            migrationBuilder.RenameColumn(
                name: "ToSition_2",
                table: "WCS_RGV521",
                newName: "ToSition");

            migrationBuilder.RenameColumn(
                name: "ToSition_1",
                table: "WCS_RGV521",
                newName: "PH_Status");

            migrationBuilder.RenameColumn(
                name: "TaskType_2",
                table: "WCS_RGV521",
                newName: "TaskType");

            migrationBuilder.RenameColumn(
                name: "TaskType_1",
                table: "WCS_RGV521",
                newName: "StartPosition");

            migrationBuilder.RenameColumn(
                name: "TaskID_2",
                table: "WCS_RGV521",
                newName: "TaskID");

            migrationBuilder.RenameColumn(
                name: "StartPosition_2",
                table: "WCS_RGV521",
                newName: "RES2");

            migrationBuilder.RenameColumn(
                name: "StartPosition_1",
                table: "WCS_RGV521",
                newName: "PRIORITY");

            migrationBuilder.RenameColumn(
                name: "RES2_2",
                table: "WCS_RGV521",
                newName: "DestPosition");

            migrationBuilder.RenameColumn(
                name: "PH_Status_2",
                table: "WCS_RGV521",
                newName: "Finish");

            migrationBuilder.RenameColumn(
                name: "Trigger_2",
                table: "WCS_RGV520",
                newName: "Trigger");

            migrationBuilder.RenameColumn(
                name: "Trigger_1",
                table: "WCS_RGV520",
                newName: "TaskType");

            migrationBuilder.RenameColumn(
                name: "TaskType_2",
                table: "WCS_RGV520",
                newName: "StartPosition");

            migrationBuilder.RenameColumn(
                name: "TaskType_1",
                table: "WCS_RGV520",
                newName: "RES1");

            migrationBuilder.RenameColumn(
                name: "TaskID_2",
                table: "WCS_RGV520",
                newName: "TaskID");

            migrationBuilder.RenameColumn(
                name: "StartPosition_2",
                table: "WCS_RGV520",
                newName: "PRIORITY");

            migrationBuilder.RenameColumn(
                name: "StartPosition_1",
                table: "WCS_RGV520",
                newName: "FinishedACK");

            migrationBuilder.RenameColumn(
                name: "RES2_2",
                table: "WCS_RGV520",
                newName: "DestPosition");

            migrationBuilder.AlterColumn<short>(
                name: "PALLETTYPE",
                table: "WCS_TASK",
                type: "smallint",
                nullable: false,
                oldClrType: typeof(int),
                oldType: "int");
        }

        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.RenameColumn(
                name: "ToSition",
                table: "WCS_RGV521",
                newName: "ToSition_2");

            migrationBuilder.RenameColumn(
                name: "TaskType",
                table: "WCS_RGV521",
                newName: "TaskType_2");

            migrationBuilder.RenameColumn(
                name: "TaskID",
                table: "WCS_RGV521",
                newName: "TaskID_2");

            migrationBuilder.RenameColumn(
                name: "StartPosition",
                table: "WCS_RGV521",
                newName: "TaskType_1");

            migrationBuilder.RenameColumn(
                name: "RES2",
                table: "WCS_RGV521",
                newName: "StartPosition_2");

            migrationBuilder.RenameColumn(
                name: "PRIORITY",
                table: "WCS_RGV521",
                newName: "StartPosition_1");

            migrationBuilder.RenameColumn(
                name: "PH_Status",
                table: "WCS_RGV521",
                newName: "ToSition_1");

            migrationBuilder.RenameColumn(
                name: "Finish",
                table: "WCS_RGV521",
                newName: "PH_Status_2");

            migrationBuilder.RenameColumn(
                name: "DestPosition",
                table: "WCS_RGV521",
                newName: "RES2_2");

            migrationBuilder.RenameColumn(
                name: "Trigger",
                table: "WCS_RGV520",
                newName: "Trigger_2");

            migrationBuilder.RenameColumn(
                name: "TaskType",
                table: "WCS_RGV520",
                newName: "Trigger_1");

            migrationBuilder.RenameColumn(
                name: "TaskID",
                table: "WCS_RGV520",
                newName: "TaskID_2");

            migrationBuilder.RenameColumn(
                name: "StartPosition",
                table: "WCS_RGV520",
                newName: "TaskType_2");

            migrationBuilder.RenameColumn(
                name: "RES1",
                table: "WCS_RGV520",
                newName: "TaskType_1");

            migrationBuilder.RenameColumn(
                name: "PRIORITY",
                table: "WCS_RGV520",
                newName: "StartPosition_2");

            migrationBuilder.RenameColumn(
                name: "FinishedACK",
                table: "WCS_RGV520",
                newName: "StartPosition_1");

            migrationBuilder.RenameColumn(
                name: "DestPosition",
                table: "WCS_RGV520",
                newName: "RES2_2");

            migrationBuilder.AlterColumn<int>(
                name: "PALLETTYPE",
                table: "WCS_TASK",
                type: "int",
                nullable: false,
                oldClrType: typeof(short),
                oldType: "smallint");

            migrationBuilder.AddColumn<short>(
                name: "DestPosition_1",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "DestPosition_2",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<bool>(
                name: "Finish_1",
                table: "WCS_RGV521",
                type: "bit",
                nullable: false,
                defaultValue: false);

            migrationBuilder.AddColumn<bool>(
                name: "Finish_2",
                table: "WCS_RGV521",
                type: "bit",
                nullable: false,
                defaultValue: false);

            migrationBuilder.AddColumn<bool>(
                name: "PH_Status_1",
                table: "WCS_RGV521",
                type: "bit",
                nullable: false,
                defaultValue: false);

            migrationBuilder.AddColumn<short>(
                name: "PRIORITY_1",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "PRIORITY_2",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "RES1_2",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "RES2_1",
                table: "WCS_RGV521",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<int>(
                name: "TaskID_1",
                table: "WCS_RGV521",
                type: "int",
                nullable: false,
                defaultValue: 0);

            migrationBuilder.AddColumn<short>(
                name: "DestPosition_1",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "DestPosition_2",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "PRIORITY_1",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "PRIORITY_2",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "RES1_1",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "RES1_2",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<short>(
                name: "RES2_1",
                table: "WCS_RGV520",
                type: "smallint",
                nullable: false,
                defaultValue: (short)0);

            migrationBuilder.AddColumn<int>(
                name: "TaskID_1",
                table: "WCS_RGV520",
                type: "int",
                nullable: false,
                defaultValue: 0);
        }
    }
}