From 9eaf758e97367dbc2eca2bdbdc92ab39e08be9d0 Mon Sep 17 00:00:00 2001
From: zs <zhousong@weben-smart.com>
Date: 周四, 15 5月 2025 13:12:17 +0800
Subject: [PATCH] Merge branch 'master' of http://222.71.245.114:9086/r/HIA24016N_PipeLineDemo
---
HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250515034921_InitialCreate17.cs | 132 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 132 insertions(+), 0 deletions(-)
diff --git a/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250515034921_InitialCreate17.cs b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250515034921_InitialCreate17.cs
new file mode 100644
index 0000000..744c64e
--- /dev/null
+++ b/HIAWms/server/src/CMS.Plugin.HIAWms.MySQL/Migrations/20250515034921_InitialCreate17.cs
@@ -0,0 +1,132 @@
+锘縰sing System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+#nullable disable
+
+namespace CMS.Plugin.HIAWms.MySQL.Migrations
+{
+ public partial class InitialCreate17 : Migration
+ {
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropIndex(
+ name: "IX_scms_wmsmaterials_MaterialType",
+ table: "scms_wmsmaterials");
+
+ migrationBuilder.DropColumn(
+ name: "MaterialType",
+ table: "scms_wmsmaterials");
+
+ migrationBuilder.AddColumn<string>(
+ name: "MaterialTypeCode",
+ table: "scms_wmsmaterials",
+ type: "varchar(20)",
+ maxLength: 20,
+ nullable: true,
+ comment: "鐗╂枡绫诲瀷缂栫爜")
+ .Annotation("MySql:CharSet", "utf8mb4");
+
+ migrationBuilder.AddColumn<string>(
+ name: "MaterialTypeDesc",
+ table: "scms_wmsmaterials",
+ type: "varchar(20)",
+ maxLength: 20,
+ nullable: true,
+ comment: "鐗╂枡绫诲瀷")
+ .Annotation("MySql:CharSet", "utf8mb4");
+
+ migrationBuilder.CreateTable(
+ name: "scms_wmsmaterialtype",
+ columns: table => new
+ {
+ Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
+ MaterialTypeDesc = table.Column<string>(type: "varchar(128)", maxLength: 128, nullable: false, comment: "绫诲瀷鎻忚堪")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ MaterialTypeCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "绫诲瀷缂栫爜")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ 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, comment: "鍒涘缓鏃堕棿"),
+ CreatorId = table.Column<Guid>(type: "char(36)", nullable: true, comment: "鍒涘缓浜篒D", collation: "ascii_general_ci"),
+ LastModificationTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "鏈�鍚庝慨鏀规椂闂�"),
+ LastModifierId = table.Column<Guid>(type: "char(36)", nullable: true, comment: "鏈�鍚庝慨鏀逛汉ID", collation: "ascii_general_ci"),
+ IsDeleted = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "鏄惁宸插垹闄�"),
+ DeleterId = table.Column<Guid>(type: "char(36)", nullable: true, comment: "鍒犻櫎浜篒D", collation: "ascii_general_ci"),
+ DeletionTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "鍒犻櫎鏃堕棿"),
+ CreatorName = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ LastModifierName = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ OperationRemark = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ DeleteRemark = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ Sort = table.Column<int>(type: "int", nullable: false),
+ Remark = table.Column<string>(type: "varchar(50)", maxLength: 50, nullable: true, comment: "澶囨敞")
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true),
+ ExtraField1 = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ ExtraField2 = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4"),
+ ExtraField3 = table.Column<string>(type: "longtext", nullable: true)
+ .Annotation("MySql:CharSet", "utf8mb4")
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_scms_wmsmaterialtype", x => x.Id);
+ },
+ comment: "鐗╂枡绫诲瀷琛�")
+ .Annotation("MySql:CharSet", "utf8mb4");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmsmaterials_MaterialTypeCode",
+ table: "scms_wmsmaterials",
+ column: "MaterialTypeCode");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmsmaterialtype_MaterialTypeCode",
+ table: "scms_wmsmaterialtype",
+ column: "MaterialTypeCode",
+ unique: true);
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmsmaterialtype_MaterialTypeDesc",
+ table: "scms_wmsmaterialtype",
+ column: "MaterialTypeDesc");
+ }
+
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropTable(
+ name: "scms_wmsmaterialtype");
+
+ migrationBuilder.DropIndex(
+ name: "IX_scms_wmsmaterials_MaterialTypeCode",
+ table: "scms_wmsmaterials");
+
+ migrationBuilder.DropColumn(
+ name: "MaterialTypeCode",
+ table: "scms_wmsmaterials");
+
+ migrationBuilder.DropColumn(
+ name: "MaterialTypeDesc",
+ table: "scms_wmsmaterials");
+
+ migrationBuilder.AddColumn<int>(
+ name: "MaterialType",
+ table: "scms_wmsmaterials",
+ type: "int",
+ nullable: false,
+ defaultValue: 0,
+ comment: "鐗╂枡绫诲瀷锛堟灇涓惧�硷級");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_scms_wmsmaterials_MaterialType",
+ table: "scms_wmsmaterials",
+ column: "MaterialType");
+ }
+ }
+}
--
Gitblit v1.9.3