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( 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( name: "PALLETTYPE", table: "WCS_TASK", type: "int", nullable: false, oldClrType: typeof(short), oldType: "smallint"); migrationBuilder.AddColumn( name: "DestPosition_1", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "DestPosition_2", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "Finish_1", table: "WCS_RGV521", type: "bit", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "Finish_2", table: "WCS_RGV521", type: "bit", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "PH_Status_1", table: "WCS_RGV521", type: "bit", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "PRIORITY_1", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "PRIORITY_2", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "RES1_2", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "RES2_1", table: "WCS_RGV521", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "TaskID_1", table: "WCS_RGV521", type: "int", nullable: false, defaultValue: 0); migrationBuilder.AddColumn( name: "DestPosition_1", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "DestPosition_2", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "PRIORITY_1", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "PRIORITY_2", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "RES1_1", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "RES1_2", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "RES2_1", table: "WCS_RGV520", type: "smallint", nullable: false, defaultValue: (short)0); migrationBuilder.AddColumn( name: "TaskID_1", table: "WCS_RGV520", type: "int", nullable: false, defaultValue: 0); } } }