using System;
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
#nullable disable
|
|
namespace CMS.Plugin.HIAWms.MySQL.Migrations
|
{
|
public partial class InitialCreate8 : Migration
|
{
|
protected override void Up(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.AlterColumn<int>(
|
name: "IsMainBranch",
|
table: "scms_wmsmaterials",
|
type: "int",
|
nullable: false,
|
defaultValue: 0,
|
comment: "是否为主支管",
|
oldClrType: typeof(int),
|
oldType: "int",
|
oldDefaultValue: 2,
|
oldComment: "是否为主支管");
|
|
migrationBuilder.CreateTable(
|
name: "scms_wmsinoutstockorder",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
|
OrderNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "单据编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OrderStatus = table.Column<int>(type: "int", nullable: false, comment: "单据状态"),
|
MaterialName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "物料名称")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "物料件号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialModel = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "型号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialBatch = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "批次号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OrderType = table.Column<int>(type: "int", nullable: false, comment: "单据类型"),
|
StockType = table.Column<int>(type: "int", nullable: false, comment: "操作类型（枚举值）"),
|
MaterialNumber = table.Column<int>(type: "int", nullable: false, comment: "单据数量"),
|
DistributeNumber = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "下发数量"),
|
CompleteNumber = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "完成数量"),
|
Priority = table.Column<int>(type: "int", nullable: false, defaultValue: 1, comment: "优先级"),
|
PlanNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "关联计划编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OperateTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "操作时间"),
|
Remark = table.Column<string>(type: "varchar(500)", maxLength: 500, nullable: true, comment: "备注")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Sort = table.Column<int>(type: "int", nullable: false, defaultValue: 0, comment: "排序"),
|
IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, defaultValue: false, comment: "是否禁用"),
|
ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
|
LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
|
DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_scms_wmsinoutstockorder", x => x.Id);
|
},
|
comment: "出入库单据表")
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
migrationBuilder.CreateTable(
|
name: "scms_wmsinoutstockorderdetail",
|
columns: table => new
|
{
|
OrderNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "单据编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialId = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "物料唯一码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OrderType = table.Column<int>(type: "int", nullable: false, comment: "单据类型（枚举值）"),
|
MaterialNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "物料件号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialName = table.Column<string>(type: "varchar(100)", maxLength: 100, nullable: true, comment: "物料名称")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "容器编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialModel = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "机型")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialBatch = table.Column<int>(type: "int", nullable: true, comment: "物料批次")
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_scms_wmsinoutstockorderdetail", x => new { x.OrderNo, x.MaterialId });
|
},
|
comment: "出入库单据明细表")
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
migrationBuilder.CreateTable(
|
name: "scms_wmsmaterialcontainer",
|
columns: table => new
|
{
|
ContainerNo = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: false, comment: "托盘编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
MaterialId = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "物料ID")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Sort = table.Column<int>(type: "int", nullable: false),
|
IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true),
|
Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
|
ExtraProperties = table.Column<string>(type: "longtext", nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ConcurrencyStamp = table.Column<string>(type: "varchar(40)", maxLength: 40, nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
CreationTime = table.Column<DateTime>(type: "datetime(6)", nullable: false),
|
CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true),
|
LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false),
|
DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, collation: "ascii_general_ci"),
|
DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true)
|
},
|
constraints: table =>
|
{
|
table.PrimaryKey("PK_scms_wmsmaterialcontainer", x => new { x.MaterialId, x.ContainerNo });
|
},
|
comment: "物料容器关系表")
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorder_MaterialBatch",
|
table: "scms_wmsinoutstockorder",
|
column: "MaterialBatch");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorder_MaterialNo",
|
table: "scms_wmsinoutstockorder",
|
column: "MaterialNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorder_OperateTime",
|
table: "scms_wmsinoutstockorder",
|
column: "OperateTime");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorder_OrderNo",
|
table: "scms_wmsinoutstockorder",
|
column: "OrderNo",
|
unique: true);
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorder_PlanNo",
|
table: "scms_wmsinoutstockorder",
|
column: "PlanNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorderdetail_ContainerNo",
|
table: "scms_wmsinoutstockorderdetail",
|
column: "ContainerNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorderdetail_MaterialId",
|
table: "scms_wmsinoutstockorderdetail",
|
column: "MaterialId");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorderdetail_MaterialNo",
|
table: "scms_wmsinoutstockorderdetail",
|
column: "MaterialNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorderdetail_OrderNo",
|
table: "scms_wmsinoutstockorderdetail",
|
column: "OrderNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsinoutstockorderdetail_OrderNo_OrderType",
|
table: "scms_wmsinoutstockorderdetail",
|
columns: new[] { "OrderNo", "OrderType" });
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsmaterialcontainer_ContainerNo",
|
table: "scms_wmsmaterialcontainer",
|
column: "ContainerNo");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_wmsmaterialcontainer_MaterialId",
|
table: "scms_wmsmaterialcontainer",
|
column: "MaterialId");
|
}
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.DropTable(
|
name: "scms_wmsinoutstockorder");
|
|
migrationBuilder.DropTable(
|
name: "scms_wmsinoutstockorderdetail");
|
|
migrationBuilder.DropTable(
|
name: "scms_wmsmaterialcontainer");
|
|
migrationBuilder.AlterColumn<int>(
|
name: "IsMainBranch",
|
table: "scms_wmsmaterials",
|
type: "int",
|
nullable: false,
|
defaultValue: 2,
|
comment: "是否为主支管",
|
oldClrType: typeof(int),
|
oldType: "int",
|
oldDefaultValue: 0,
|
oldComment: "是否为主支管");
|
}
|
}
|
}
|
