using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace TaskManager.EntityFramework.Migrations
{
///
public partial class z202506090004 : Migration
{
///
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(32)",
maxLength: 32,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32);
migrationBuilder.AlterColumn(
name: "SerialNumber",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(10)",
maxLength: 10,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10);
migrationBuilder.AlterColumn(
name: "QuantityMeet",
table: "SUPPLIER_CON_PO",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "PurchaseOrder",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(50)",
maxLength: 50,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(10)",
maxLength: 10,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10);
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(32)",
maxLength: 32,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32);
migrationBuilder.AlterColumn(
name: "StartMonth",
table: "SUPPLIER_CON_MMRP",
type: "CHAR(7)",
maxLength: 7,
nullable: true,
oldClrType: typeof(string),
oldType: "CHAR(7)",
oldMaxLength: 7);
migrationBuilder.AlterColumn(
name: "ReleaseEdition",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(32)",
maxLength: 32,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32);
migrationBuilder.AlterColumn(
name: "QuantityMeet6",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet5",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet4",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet3",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet2",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet1",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "PlantId",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(64)",
maxLength: 64,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(64)",
oldMaxLength: 64);
migrationBuilder.AlterColumn(
name: "MaterialCode",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(50)",
maxLength: 50,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(10)",
maxLength: 10,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10);
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(32)",
maxLength: 32,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32);
migrationBuilder.AlterColumn(
name: "ReleaseEdition",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(32)",
maxLength: 32,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32);
migrationBuilder.AlterColumn(
name: "QuantityMeet9",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet8",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet7",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet6",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet5",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet4",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet3",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet2",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet12",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet11",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet10",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "QuantityMeet1",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: true,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5);
migrationBuilder.AlterColumn(
name: "PlantId",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(64)",
maxLength: 64,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(64)",
oldMaxLength: 64);
migrationBuilder.AlterColumn(
name: "MaterialCode",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(50)",
maxLength: 50,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(10)",
maxLength: 10,
nullable: true,
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10);
}
///
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(32)",
maxLength: 32,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "SerialNumber",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(10)",
maxLength: 10,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet",
table: "SUPPLIER_CON_PO",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "PurchaseOrder",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(50)",
maxLength: 50,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_PO",
type: "VARCHAR(10)",
maxLength: 10,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(32)",
maxLength: 32,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "StartMonth",
table: "SUPPLIER_CON_MMRP",
type: "CHAR(7)",
maxLength: 7,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "CHAR(7)",
oldMaxLength: 7,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "ReleaseEdition",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(32)",
maxLength: 32,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet6",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet5",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet4",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet3",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet2",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet1",
table: "SUPPLIER_CON_MMRP",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "PlantId",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(64)",
maxLength: 64,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(64)",
oldMaxLength: 64,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "MaterialCode",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(50)",
maxLength: 50,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_MMRP",
type: "VARCHAR(10)",
maxLength: 10,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "SupplierCode",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(32)",
maxLength: 32,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "ReleaseEdition",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(32)",
maxLength: 32,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(32)",
oldMaxLength: 32,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet9",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet8",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet7",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet6",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet5",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet4",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet3",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet2",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet12",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet11",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet10",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "QuantityMeet1",
table: "SUPPLIER_CON_DATE",
type: "DECIMAL(16,5)",
precision: 16,
scale: 5,
nullable: false,
defaultValue: 0m,
oldClrType: typeof(decimal),
oldType: "DECIMAL(16,5)",
oldPrecision: 16,
oldScale: 5,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "PlantId",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(64)",
maxLength: 64,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(64)",
oldMaxLength: 64,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "MaterialCode",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(50)",
maxLength: 50,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(50)",
oldMaxLength: 50,
oldNullable: true);
migrationBuilder.AlterColumn(
name: "FeedbackResults",
table: "SUPPLIER_CON_DATE",
type: "VARCHAR(10)",
maxLength: 10,
nullable: false,
defaultValue: "",
oldClrType: typeof(string),
oldType: "VARCHAR(10)",
oldMaxLength: 10,
oldNullable: true);
}
}
}