zhibinlv
/
QRAPI
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
203 Commits
2 Branches
0 Tags
25 MiB
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
QRAPI/API/TaskManager.EntityFramework/Migrations/20250529020443_2025052903.cs

303 lines
23 KiB
Raw Permalink Blame History

using System;
using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace TaskManager.EntityFramework.Migrations
{
/// <inheritdoc />
public partial class _2025052903 : Migration
{
/// <inheritdoc />
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_ATTACHMENT_DATA",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
Type = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
FileName = table.Column<string>(type: "VARCHAR(300)", maxLength: 300, nullable: false),
FileUrl = table.Column<string>(type: "VARCHAR(1000)", maxLength: 1000, nullable: false),
DateTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
ProductionLineName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProductionLineId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
StationName = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
StationId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DeviceName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DeviceId = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
VendorProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
VendorProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
CheryProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
CheryProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductSn = table.Column<string>(type: "VARCHAR(100)", maxLength: 100, nullable: true),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_ATTACHMENT_DATA", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_ENVIRONMENT",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
PlantId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
PlantName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
WorkshopId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WorkshopName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProductionLineId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
ProductionLineName = table.Column<string>(type: "VARCHAR(100)", maxLength: 100, nullable: false),
EnvIndicatorName = table.Column<string>(type: "VARCHAR(100)", maxLength: 100, nullable: false),
NumValue = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: true),
UpperLimit = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: false),
LowerLimit = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: false),
ChineseUnit = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
EquipmentCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
EquipmentName = table.Column<string>(type: "VARCHAR(100)", maxLength: 100, nullable: false),
DataCollectionPoint = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: true),
CollectTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_ENVIRONMENT", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_MATERIAL_DATA",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
VendorProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
Type = table.Column<decimal>(type: "DECIMAL(1,0)", precision: 1, scale: 0, nullable: false),
VendorHardwareRevision = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: true),
CheryProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
CheryProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
OemHardwareRevision = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
OemSoftwareRevision = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: true),
OemModel = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: true),
OemProjectName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: true),
Launched = table.Column<string>(type: "VARCHAR(6)", maxLength: 6, nullable: true),
DateTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: true),
PlantId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: true),
PlantName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: true),
ProcurementType = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: true),
MpnCode = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: true),
MpnName = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: true),
ValidDays = table.Column<string>(type: "CHAR(12)", maxLength: 12, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_MATERIAL_DATA", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_OEE_ACHIEVEMENT_RATE",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
PlantId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
PlantName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
WorkshopId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WorkshopName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProductionLineId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
ProductionLineName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
StationId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
StationName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DeviceId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DeviceName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
CheryProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
CheryProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
VendorProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProductBatchNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
ManufactureNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
Rate = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: false),
RateTagValue = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: false),
WorkShift = table.Column<string>(type: "VARCHAR(10)", maxLength: 10, nullable: false),
StatisticalTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
DateTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_OEE_ACHIEVEMENT_RATE", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_OEE_TIME_DETAILS",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
PlantId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
PlantName = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WorkshopId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WorkshopName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
ProductionLineId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
ProductionLineName = table.Column<string>(type: "nvarchar(50)", maxLength: 50, nullable: true),
StationId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
StationName = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DeviceId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DeviceName = table.Column<string>(type: "VARCHAR(33)", maxLength: 33, nullable: false),
RecId = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
Type = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SubType = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SubTypeName = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
StartTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
EndTime = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_OEE_TIME_DETAILS", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_PROCESS",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
CheryProductNo = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
CheryProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductNo = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
SupplierCode = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
TechCode = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
TechName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ValidPeriod = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
TechVersion = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
MoldCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
MoldName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
MaxProcessingCapacity = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProcessCode = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProcessName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProcessOrder = table.Column<decimal>(type: "DECIMAL(16,0)", precision: 16, scale: 0, nullable: false),
DeviceCode = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
Rhythm = table.Column<decimal>(type: "DECIMAL(16,5)", precision: 16, scale: 5, nullable: false),
RhythmUnit = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_PROCESS", x => x.UId);
});
migrationBuilder.CreateTable(
name: "SUPPLIER_PRO_PROCESS_EQUIPMENT",
columns: table => new
{
UId = table.Column<long>(type: "bigint", nullable: false)
.Annotation("SqlServer:Identity", "1, 1"),
SupplierCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
SupplierName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
CheryProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
CheryProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
VendorProductNo = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
VendorProductName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DeviceType = table.Column<decimal>(type: "DECIMAL(1,0)", precision: 1, scale: 0, nullable: false),
DeviceCode = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DeviceName = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
Manufacturer = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ModelNumber = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
SerialNumber = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
ProductionDate = table.Column<string>(type: "CHAR(16)", maxLength: 16, nullable: false),
Material = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
CurrentLocation = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DeviceStatus = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
CavityCount = table.Column<decimal>(type: "DECIMAL(16,0)", precision: 16, scale: 0, nullable: false),
MoldSize = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DesignLifeUnits = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
DesignLifeValue = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
CurrentUsageCount = table.Column<string>(type: "VARCHAR(16)", maxLength: 16, nullable: false),
OverhaulCount = table.Column<decimal>(type: "DECIMAL(16,0)", precision: 16, scale: 0, nullable: false),
CoolingChannelLayout = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
DetectionAccuracy = table.Column<string>(type: "VARCHAR(64)", maxLength: 64, nullable: false),
CalibrationDate = table.Column<string>(type: "CHAR(19)", maxLength: 19, nullable: false),
CalibrationDueDays = table.Column<string>(type: "CHAR(12)", maxLength: 12, nullable: false),
ToleranceRange = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WearThreshold = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
DetectionRange = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
UnitType = table.Column<string>(type: "VARCHAR(32)", maxLength: 32, nullable: false),
WriteState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
ReadState = table.Column<bool>(type: "bit", nullable: false, defaultValue: false),
CreationTime = table.Column<DateTime>(type: "datetime2", nullable: false),
Remark = table.Column<string>(type: "NVarchar(500)", maxLength: 500, nullable: true),
TaskId = table.Column<Guid>(type: "uniqueidentifier", nullable: false)
},
constraints: table =>
{
table.PrimaryKey("PK_SUPPLIER_PRO_PROCESS_EQUIPMENT", x => x.UId);
});
}
/// <inheritdoc />
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_ATTACHMENT_DATA");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_ENVIRONMENT");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_MATERIAL_DATA");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_OEE_ACHIEVEMENT_RATE");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_OEE_TIME_DETAILS");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_PROCESS");
migrationBuilder.DropTable(
name: "SUPPLIER_PRO_PROCESS_EQUIPMENT");
}
}
}