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(type: "char(36)", nullable: false, collation: "ascii_general_ci"), TaskCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: false, comment: "任务编码") .Annotation("MySql:CharSet", "utf8mb4"), OrgMaterialCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: false, comment: "原料编号") .Annotation("MySql:CharSet", "utf8mb4"), FactoryCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工厂代码") .Annotation("MySql:CharSet", "utf8mb4"), ProductCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "产品代码") .Annotation("MySql:CharSet", "utf8mb4"), WorkstationCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工位代码") .Annotation("MySql:CharSet", "utf8mb4"), EquipmentCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "设备代码") .Annotation("MySql:CharSet", "utf8mb4"), WorkpieceName = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工件名称") .Annotation("MySql:CharSet", "utf8mb4"), ProcessName = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工序名称") .Annotation("MySql:CharSet", "utf8mb4"), PipeFittingCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管件编码") .Annotation("MySql:CharSet", "utf8mb4"), PreSerialNumber = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "顺序号") .Annotation("MySql:CharSet", "utf8mb4"), DataIdentifier = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "原料标识") .Annotation("MySql:CharSet", "utf8mb4"), PipeSpecCode = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管规格码") .Annotation("MySql:CharSet", "utf8mb4"), PipeSectionName = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管段名称") .Annotation("MySql:CharSet", "utf8mb4"), OuterDiameter = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "外径") .Annotation("MySql:CharSet", "utf8mb4"), Bevel = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "坡口") .Annotation("MySql:CharSet", "utf8mb4"), Material = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "材质") .Annotation("MySql:CharSet", "utf8mb4"), Length = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "长度") .Annotation("MySql:CharSet", "utf8mb4"), DrillingPosition = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "打孔位") .Annotation("MySql:CharSet", "utf8mb4"), Intersecting = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯") .Annotation("MySql:CharSet", "utf8mb4"), InterfaceRequirement = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "接口要求") .Annotation("MySql:CharSet", "utf8mb4"), HasMainSignature = table.Column(type: "tinyint(1)", nullable: false, comment: "是否有主签"), Quantity = table.Column(type: "int", nullable: false, comment: "包括数量"), MarkingContent = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "打码内容") .Annotation("MySql:CharSet", "utf8mb4"), CuttingFile = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "切割文件") .Annotation("MySql:CharSet", "utf8mb4"), BranchOuterDiameter = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支外径") .Annotation("MySql:CharSet", "utf8mb4"), BranchWallThickness = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管壁厚") .Annotation("MySql:CharSet", "utf8mb4"), BranchMaterial = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管材质") .Annotation("MySql:CharSet", "utf8mb4"), BranchPortRadius = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口曲率半径") .Annotation("MySql:CharSet", "utf8mb4"), BranchPortAngle = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口角度") .Annotation("MySql:CharSet", "utf8mb4"), BranchPortRequirement = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "支管端口要求") .Annotation("MySql:CharSet", "utf8mb4"), IntersectingLineType = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯线类型") .Annotation("MySql:CharSet", "utf8mb4"), IntersectingLineCategory = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "相贯线类别") .Annotation("MySql:CharSet", "utf8mb4"), FinishedProductScale = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "成品图幅") .Annotation("MySql:CharSet", "utf8mb4"), FlangeThickness = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "法兰厚度") .Annotation("MySql:CharSet", "utf8mb4"), FlangeInnerDiameter = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "法兰内径") .Annotation("MySql:CharSet", "utf8mb4"), WeldingHeatInput = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "焊接热输入") .Annotation("MySql:CharSet", "utf8mb4"), PipeAllowableStress = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管道允许应力") .Annotation("MySql:CharSet", "utf8mb4"), PipeDiameter = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管径") .Annotation("MySql:CharSet", "utf8mb4"), PipeWallThickness = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "管道壁厚") .Annotation("MySql:CharSet", "utf8mb4"), VRData = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "VR数据") .Annotation("MySql:CharSet", "utf8mb4"), ProcessRouteNumber = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "工艺路线编号") .Annotation("MySql:CharSet", "utf8mb4"), PlannedStartTime = table.Column(type: "datetime(6)", nullable: true, comment: "计划开始时间"), PlannedEndTime = table.Column(type: "datetime(6)", nullable: true, comment: "计划完成时间"), TimeInfo = table.Column(type: "varchar(64)", maxLength: 64, nullable: true, comment: "时间信息") .Annotation("MySql:CharSet", "utf8mb4"), RedundantField1 = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), RedundantField2 = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), RedundantField3 = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), Sort = table.Column(type: "int", nullable: false, comment: "排序"), Remark = table.Column(type: "varchar(256)", maxLength: 256, nullable: true, comment: "备注") .Annotation("MySql:CharSet", "utf8mb4"), IsDisabled = table.Column(type: "tinyint(1)", nullable: true, comment: "是否禁用"), ExtraProperties = table.Column(type: "longtext", nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), ConcurrencyStamp = table.Column(type: "varchar(40)", maxLength: 40, nullable: true) .Annotation("MySql:CharSet", "utf8mb4"), CreationTime = table.Column(type: "datetime(6)", nullable: false), CreatorId = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), LastModificationTime = table.Column(type: "datetime(6)", nullable: true), LastModifierId = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), IsDeleted = table.Column(type: "tinyint(1)", nullable: false, defaultValue: false), DeleterId = table.Column(type: "char(36)", nullable: true, collation: "ascii_general_ci"), DeletionTime = table.Column(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"); } } }