ÎļþÃû´Ó iWara.SCADA.Code/iWare.Wms.Database.Migrations/Migrations/20240112013535_v1.0.1.cs ÐÞ¸Ä |
| | |
| | | |
| | | namespace iWare.Wms.Database.Migrations.Migrations |
| | | { |
| | | public partial class v101 : Migration |
| | | public partial class v102 : Migration |
| | | { |
| | | protected override void Up(MigrationBuilder migrationBuilder) |
| | | { |
| | | migrationBuilder.CreateTable( |
| | | name: "WorkPieceOutbound", |
| | | name: "WorkPieceOutboundRecord", |
| | | columns: table => new |
| | | { |
| | | Id = table.Column<long>(type: "bigint", nullable: false, comment: "Id主é®"), |
| | | WorkPieceID = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "工件å·"), |
| | | OP80NewCode = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "OP80æç "), |
| | | WorkPieceOutboundTime = table.Column<DateTime>(type: "datetime2", nullable: false, comment: "åºåºæ¶é´"), |
| | | WorkPieceOutboundUserId = table.Column<long>(type: "bigint", maxLength: 32, nullable: false, comment: "åºåºäººId"), |
| | | WorkPieceOutboundUserName = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: false, comment: "åºåºäººåç§°"), |
| | | OperationType = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true, comment: "æä½ç±»å"), |
| | | OP80NewCode = table.Column<string>(type: "nvarchar(255)", maxLength: 255, nullable: false, comment: "æåç "), |
| | | WorkPieceID = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "工件å·"), |
| | | CarNo = table.Column<string>(type: "nvarchar(32)", maxLength: 32, nullable: true, comment: "å°è½¦ç "), |
| | | Remark = table.Column<string>(type: "nvarchar(500)", maxLength: 500, nullable: true, comment: "夿³¨"), |
| | | CreatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "å建æ¶é´"), |
| | | UpdatedTime = table.Column<DateTimeOffset>(type: "datetimeoffset", nullable: true, comment: "æ´æ°æ¶é´"), |
| | | CreatedUserId = table.Column<long>(type: "bigint", nullable: true, comment: "å建è
Id"), |
| | |
| | | }, |
| | | constraints: table => |
| | | { |
| | | table.PrimaryKey("PK_WorkPieceOutbound", x => x.Id); |
| | | table.PrimaryKey("PK_WorkPieceOutboundRecord", x => x.Id); |
| | | }, |
| | | comment: "工件åºåºè¡¨"); |
| | | comment: "工件åºåºè®°å½è¡¨"); |
| | | } |
| | | |
| | | protected override void Down(MigrationBuilder migrationBuilder) |
| | | { |
| | | migrationBuilder.DropTable( |
| | | name: "WorkPieceOutbound"); |
| | | name: "WorkPieceOutboundRecord"); |
| | | } |
| | | } |
| | | } |