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); } } }