using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace TaskManager.EntityFramework.Migrations { /// public partial class z202506090005 : Migration { /// protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_PO", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_PO", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_PO", type: "NVARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "SerialNumber", table: "SUPPLIER_CON_PO", type: "NVARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "PurchaseOrder", table: "SUPPLIER_CON_PO", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_PO", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_PO", type: "NVARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "StartMonth", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(7)", maxLength: 7, nullable: true, oldClrType: typeof(string), oldType: "CHAR(7)", oldMaxLength: 7, oldNullable: true); migrationBuilder.AlterColumn( name: "ReleaseEdition", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "PlantId", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(64)", maxLength: 64, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(64)", oldMaxLength: 64, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "MaterialCode", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_MMRP", type: "NVARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "StartDate", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(10)", maxLength: 10, nullable: false, oldClrType: typeof(string), oldType: "CHAR(10)", oldMaxLength: 10); migrationBuilder.AlterColumn( name: "ReleaseEdition", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "PlantId", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(64)", maxLength: 64, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(64)", oldMaxLength: 64, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "MaterialCode", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_DATE", type: "NVARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "VARCHAR(10)", oldMaxLength: 10, oldNullable: true); } /// protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_PO", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_PO", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_PO", type: "VARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "SerialNumber", table: "SUPPLIER_CON_PO", type: "VARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "PurchaseOrder", table: "SUPPLIER_CON_PO", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_PO", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_PO", type: "VARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "StartMonth", table: "SUPPLIER_CON_MMRP", type: "CHAR(7)", maxLength: 7, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(7)", oldMaxLength: 7, oldNullable: true); migrationBuilder.AlterColumn( name: "ReleaseEdition", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "PlantId", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(64)", maxLength: 64, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(64)", oldMaxLength: 64, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "MaterialCode", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_MMRP", type: "VARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(10)", oldMaxLength: 10, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureType", table: "SUPPLIER_CON_DATE", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "VentureSpecific", table: "SUPPLIER_CON_DATE", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "SupplierCode", table: "SUPPLIER_CON_DATE", type: "VARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "StartDate", table: "SUPPLIER_CON_DATE", type: "CHAR(10)", maxLength: 10, nullable: false, oldClrType: typeof(string), oldType: "NVARCHAR(10)", oldMaxLength: 10); migrationBuilder.AlterColumn( name: "ReleaseEdition", table: "SUPPLIER_CON_DATE", type: "VARCHAR(32)", maxLength: 32, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(32)", oldMaxLength: 32, oldNullable: true); migrationBuilder.AlterColumn( name: "PlantId", table: "SUPPLIER_CON_DATE", type: "VARCHAR(64)", maxLength: 64, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(64)", oldMaxLength: 64, oldNullable: true); migrationBuilder.AlterColumn( name: "Measures", table: "SUPPLIER_CON_DATE", type: "VARCHAR(255)", maxLength: 255, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(255)", oldMaxLength: 255, oldNullable: true); migrationBuilder.AlterColumn( name: "MaterialCode", table: "SUPPLIER_CON_DATE", type: "VARCHAR(50)", maxLength: 50, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(50)", oldMaxLength: 50, oldNullable: true); migrationBuilder.AlterColumn( name: "FeedbackResults", table: "SUPPLIER_CON_DATE", type: "VARCHAR(10)", maxLength: 10, nullable: true, oldClrType: typeof(string), oldType: "NVARCHAR(10)", oldMaxLength: 10, oldNullable: true); } } }