using System;
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
#nullable disable
|
|
namespace CMS.Plugin.PipeLineLems.MySQL.Migrations
|
{
|
public partial class Update1 : Migration
|
{
|
protected override void Up(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.CreateTable(
|
name: "scms_workplans",
|
columns: table => new
|
{
|
Id = table.Column<Guid>(type: "char(36)", nullable: false, collation: "ascii_general_ci"),
|
TaskCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "任务编码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OrgMaterialCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: false, comment: "原料编号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
FactoryCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工厂代码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ProductCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "产品代码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
WorkstationCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工位代码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
EquipmentCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "设备代码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
WorkpieceName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工件名称")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ProcessName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工序名称")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeFittingCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管件编码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PreSerialNumber = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "顺序号")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
DataIdentifier = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "原料标识")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeSpecCode = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管规格码")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeSectionName = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管段名称")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
OuterDiameter = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "外径")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Bevel = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "坡口")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Material = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "材质")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Length = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "长度")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
DrillingPosition = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "打孔位")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Intersecting = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
InterfaceRequirement = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "接口要求")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
HasMainSignature = table.Column<bool>(type: "tinyint(1)", nullable: false, comment: "是否有主签"),
|
Quantity = table.Column<int>(type: "int", nullable: false, comment: "包括数量"),
|
MarkingContent = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "打码内容")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
CuttingFile = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "切割文件")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchOuterDiameter = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支外径")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchWallThickness = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管壁厚")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchMaterial = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管材质")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchPortRadius = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口曲率半径")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchPortAngle = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口角度")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
BranchPortRequirement = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口要求")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
IntersectingLineType = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯线类型")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
IntersectingLineCategory = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯线类别")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
FinishedProductScale = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "成品图幅")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
FlangeThickness = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "法兰厚度")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
FlangeInnerDiameter = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "法兰内径")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
WeldingHeatInput = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "焊接热输入")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeAllowableStress = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管道允许应力")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeDiameter = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管径")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
PipeWallThickness = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管道壁厚")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
VRData = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "VR数据")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
ProcessRouteNumber = table.Column<string>(type: "varchar(64)", maxLength: 64, 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: "计划完成时间"),
|
TimeInfo = table.Column<string>(type: "varchar(64)", maxLength: 64, nullable: true, comment: "时间信息")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
RedundantField1 = table.Column<string>(type: "longtext", nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
RedundantField2 = table.Column<string>(type: "longtext", nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
RedundantField3 = table.Column<string>(type: "longtext", nullable: true)
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
|
Remark = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: true, comment: "备注")
|
.Annotation("MySql:CharSet", "utf8mb4"),
|
IsDisabled = table.Column<bool>(type: "tinyint(1)", nullable: true, 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_workplans", x => x.Id);
|
},
|
comment: "WorkPlan")
|
.Annotation("MySql:CharSet", "utf8mb4");
|
|
migrationBuilder.CreateIndex(
|
name: "IX_scms_workplans_TaskCode",
|
table: "scms_workplans",
|
column: "TaskCode");
|
}
|
|
protected override void Down(MigrationBuilder migrationBuilder)
|
{
|
migrationBuilder.DropTable(
|
name: "scms_workplans");
|
}
|
}
|
}
|
