using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace CMS.Plugin.HIAWms.MySQL.Migrations { public partial class InitialCreate11 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AlterColumn( name: "Sort", table: "scms_wmscontainerplaces", type: "int", nullable: false, defaultValue: 0, comment: "排序", oldClrType: typeof(int), oldType: "int"); migrationBuilder.AlterColumn( name: "LastModifierId", table: "scms_wmscontainerplaces", type: "char(36)", maxLength: 36, nullable: true, comment: "修改人ID", collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldNullable: true) .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "LastModificationTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: true, comment: "修改时间", oldClrType: typeof(DateTime), oldType: "datetime(6)", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDisabled", table: "scms_wmscontainerplaces", type: "tinyint(1)", nullable: true, defaultValue: false, comment: "是否禁用", oldClrType: typeof(bool), oldType: "tinyint(1)", oldNullable: true); migrationBuilder.AlterColumn( name: "IsDeleted", table: "scms_wmscontainerplaces", type: "tinyint(1)", nullable: false, defaultValue: false, comment: "是否删除", oldClrType: typeof(bool), oldType: "tinyint(1)", oldDefaultValue: false); migrationBuilder.AlterColumn( name: "ExtraProperties", table: "scms_wmscontainerplaces", type: "longtext", nullable: true, comment: "扩展属性", oldClrType: typeof(string), oldType: "longtext", oldNullable: true) .Annotation("MySql:CharSet", "utf8mb4") .OldAnnotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AlterColumn( name: "DeletionTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: true, comment: "删除时间", oldClrType: typeof(DateTime), oldType: "datetime(6)", oldNullable: true); migrationBuilder.AlterColumn( name: "DeleterId", table: "scms_wmscontainerplaces", type: "char(36)", maxLength: 36, nullable: true, comment: "删除人ID", collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldNullable: true) .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "CreatorId", table: "scms_wmscontainerplaces", type: "char(36)", maxLength: 36, nullable: true, comment: "创建人ID", collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldNullable: true) .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "CreationTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: false, comment: "创建时间", oldClrType: typeof(DateTime), oldType: "datetime(6)"); migrationBuilder.AlterColumn( name: "ConcurrencyStamp", table: "scms_wmscontainerplaces", type: "varchar(40)", maxLength: 40, nullable: true, comment: "并发戳", oldClrType: typeof(string), oldType: "varchar(40)", oldMaxLength: 40, oldNullable: true) .Annotation("MySql:CharSet", "utf8mb4") .OldAnnotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "CreatorName", table: "scms_wmscontainerplaces", type: "varchar(64)", maxLength: 64, nullable: true, comment: "创建人") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "DeleteRemark", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "删除备注") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "ExtraField1", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段1") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "ExtraField2", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段2") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "ExtraField3", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "扩展字段3") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "LastModifierName", table: "scms_wmscontainerplaces", type: "varchar(64)", maxLength: 64, nullable: true, comment: "修改人") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "OperationRemark", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "操作备注") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "Remark", table: "scms_wmscontainerplaces", type: "varchar(256)", maxLength: 256, nullable: true, comment: "备注") .Annotation("MySql:CharSet", "utf8mb4"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropColumn( name: "CreatorName", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "DeleteRemark", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "ExtraField1", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "ExtraField2", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "ExtraField3", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "LastModifierName", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "OperationRemark", table: "scms_wmscontainerplaces"); migrationBuilder.DropColumn( name: "Remark", table: "scms_wmscontainerplaces"); migrationBuilder.AlterColumn( name: "Sort", table: "scms_wmscontainerplaces", type: "int", nullable: false, oldClrType: typeof(int), oldType: "int", oldDefaultValue: 0, oldComment: "排序"); migrationBuilder.AlterColumn( name: "LastModifierId", table: "scms_wmscontainerplaces", type: "char(36)", nullable: true, collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldMaxLength: 36, oldNullable: true, oldComment: "修改人ID") .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "LastModificationTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime(6)", oldNullable: true, oldComment: "修改时间"); migrationBuilder.AlterColumn( name: "IsDisabled", table: "scms_wmscontainerplaces", type: "tinyint(1)", nullable: true, oldClrType: typeof(bool), oldType: "tinyint(1)", oldNullable: true, oldDefaultValue: false, oldComment: "是否禁用"); migrationBuilder.AlterColumn( name: "IsDeleted", table: "scms_wmscontainerplaces", type: "tinyint(1)", nullable: false, defaultValue: false, oldClrType: typeof(bool), oldType: "tinyint(1)", oldDefaultValue: false, oldComment: "是否删除"); migrationBuilder.AlterColumn( name: "ExtraProperties", table: "scms_wmscontainerplaces", type: "longtext", nullable: true, oldClrType: typeof(string), oldType: "longtext", oldNullable: true, oldComment: "扩展属性") .Annotation("MySql:CharSet", "utf8mb4") .OldAnnotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AlterColumn( name: "DeletionTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: true, oldClrType: typeof(DateTime), oldType: "datetime(6)", oldNullable: true, oldComment: "删除时间"); migrationBuilder.AlterColumn( name: "DeleterId", table: "scms_wmscontainerplaces", type: "char(36)", nullable: true, collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldMaxLength: 36, oldNullable: true, oldComment: "删除人ID") .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "CreatorId", table: "scms_wmscontainerplaces", type: "char(36)", nullable: true, collation: "ascii_general_ci", oldClrType: typeof(Guid), oldType: "char(36)", oldMaxLength: 36, oldNullable: true, oldComment: "创建人ID") .OldAnnotation("Relational:Collation", "ascii_general_ci"); migrationBuilder.AlterColumn( name: "CreationTime", table: "scms_wmscontainerplaces", type: "datetime(6)", nullable: false, oldClrType: typeof(DateTime), oldType: "datetime(6)", oldComment: "创建时间"); migrationBuilder.AlterColumn( name: "ConcurrencyStamp", table: "scms_wmscontainerplaces", type: "varchar(40)", maxLength: 40, nullable: true, oldClrType: typeof(string), oldType: "varchar(40)", oldMaxLength: 40, oldNullable: true, oldComment: "并发戳") .Annotation("MySql:CharSet", "utf8mb4") .OldAnnotation("MySql:CharSet", "utf8mb4"); } } }