using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace CMS.Plugin.HIAWms.MySQL.Migrations { public partial class InitialCreate9 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_scms_wmsinoutstockorderdetail", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.AddColumn( name: "Id", table: "scms_wmsinoutstockorderdetail", type: "char(36)", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000"), collation: "ascii_general_ci"); migrationBuilder.AddColumn( name: "ConcurrencyStamp", table: "scms_wmsinoutstockorderdetail", type: "varchar(40)", maxLength: 40, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "CreationTime", table: "scms_wmsinoutstockorderdetail", type: "datetime(6)", nullable: false, defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified)); migrationBuilder.AddColumn( name: "CreatorId", table: "scms_wmsinoutstockorderdetail", type: "char(36)", nullable: true, collation: "ascii_general_ci"); migrationBuilder.AddColumn( name: "DeleterId", table: "scms_wmsinoutstockorderdetail", type: "char(36)", nullable: true, collation: "ascii_general_ci"); migrationBuilder.AddColumn( name: "DeletionTime", table: "scms_wmsinoutstockorderdetail", type: "datetime(6)", nullable: true); migrationBuilder.AddColumn( name: "ExtraProperties", table: "scms_wmsinoutstockorderdetail", type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "IsDeleted", table: "scms_wmsinoutstockorderdetail", type: "tinyint(1)", nullable: false, defaultValue: false); migrationBuilder.AddColumn( name: "IsDisabled", table: "scms_wmsinoutstockorderdetail", type: "tinyint(1)", nullable: true, defaultValue: false, comment: "是否禁用"); migrationBuilder.AddColumn( name: "LastModificationTime", table: "scms_wmsinoutstockorderdetail", type: "datetime(6)", nullable: true); migrationBuilder.AddColumn( name: "LastModifierId", table: "scms_wmsinoutstockorderdetail", type: "char(36)", nullable: true, collation: "ascii_general_ci"); migrationBuilder.AddColumn( name: "Remark", table: "scms_wmsinoutstockorderdetail", type: "varchar(500)", maxLength: 500, nullable: true, comment: "备注") .Annotation("MySql:CharSet", "utf8mb4"); migrationBuilder.AddColumn( name: "Sort", table: "scms_wmsinoutstockorderdetail", type: "int", nullable: false, defaultValue: 0, comment: "排序"); migrationBuilder.AddPrimaryKey( name: "PK_scms_wmsinoutstockorderdetail", table: "scms_wmsinoutstockorderdetail", column: "Id"); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropPrimaryKey( name: "PK_scms_wmsinoutstockorderdetail", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "Id", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "ConcurrencyStamp", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "CreationTime", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "CreatorId", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "DeleterId", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "DeletionTime", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "ExtraProperties", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "IsDeleted", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "IsDisabled", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "LastModificationTime", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "LastModifierId", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "Remark", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.DropColumn( name: "Sort", table: "scms_wmsinoutstockorderdetail"); migrationBuilder.AddPrimaryKey( name: "PK_scms_wmsinoutstockorderdetail", table: "scms_wmsinoutstockorderdetail", columns: new[] { "OrderNo", "MaterialId" }); } } }