HIA24016N_PipeLineDemo.git

ÎÄ¼þÃû´Ó PipeLineLems/server/src/CMS.Plugin.PipeLineLems.MySQL/Migrations/20250520032108_Update2.cs ÐÞ¸Ä
			@@ -152,8 +152,22 @@
			Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
			TaskCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, comment: "ä»»å¡ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSectionName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåå·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥åºåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ShipNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "è¹å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProjectNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡¹ç®å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			WorkPlanStatus = table.Column<int>(type: "int", nullable: false, comment: "è®¡åç¶æ"),
			CallMaterialStatus = table.Column<int>(type: "int", nullable: false, comment: "å«æç¶æ"),
			ProcessRouteNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥èºæµåç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			DataIdentifier = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åææ è¯")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åæåå·")
			@@ -182,25 +196,13 @@
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProdLineCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "äº§çº¿ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ShipNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "è¹å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProjectNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡¹ç®å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥åºåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeFittingCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡ä»¶ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PreSerialNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡ºåºå·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSectionName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			OuterDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å¤å¾(mm)"),
			Thickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å£å(mm)"),
			Material = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æè´¨")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessRouteNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥èºæµåç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PlannedStartTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "è®¡åå¼å§æ¶é´"),
			PlannedEndTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "è®¡åå®ææ¶é´"),
			@@ -254,8 +256,22 @@
			.Annotation("MySql:CharSet", "utf8mb4"),
			TaskCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, comment: "ä»»å¡ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSectionName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåå·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥åºåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ShipNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "è¹å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProjectNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡¹ç®å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			WorkPlanStatus = table.Column<int>(type: "int", nullable: false, comment: "è®¡åç¶æ"),
			CallMaterialStatus = table.Column<int>(type: "int", nullable: false, comment: "å«æç¶æ"),
			ProcessRouteNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥èºæµåç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			DataIdentifier = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åææ è¯")
			.Annotation("MySql:CharSet", "utf8mb4"),
			MaterialMode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "åæåå·")
			@@ -284,25 +300,13 @@
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProdLineCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "äº§çº¿ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ShipNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "è¹å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProjectNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡¹ç®å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥åºåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeFittingCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡ä»¶ç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PreSerialNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "é¡ºåºå·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSpecCode = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µç¼ç ")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PipeSectionName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "ç®¡æ®µåç§°")
			.Annotation("MySql:CharSet", "utf8mb4"),
			OuterDiameter = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å¤å¾(mm)"),
			Thickness = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "å£å(mm)"),
			Material = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "æè´¨")
			.Annotation("MySql:CharSet", "utf8mb4"),
			ProcessRouteNumber = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "å·¥èºæµåç¼å·")
			.Annotation("MySql:CharSet", "utf8mb4"),
			PlannedStartTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "è®¡åå¼å§æ¶é´"),
			PlannedEndTime = table.Column<DateTime>(type: "datetime(6)", nullable: true, comment: "è®¡åå®ææ¶é´"),