using System; using Microsoft.EntityFrameworkCore.Migrations; namespace WCS.Service.Migrations { public partial class _782 : Migration { protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "WCS_TASK", columns: table => new { ID = table.Column(type: "int", nullable: false) .Annotation("SqlServer:Identity", "1, 1"), BARCODE = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: true), TYPE = table.Column(type: "int", nullable: false), STATUS = table.Column(type: "int", nullable: false), ADDRFROM = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true), ADDRTO = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true), TUNNEL = table.Column(type: "int", nullable: false), DEVICE = table.Column(type: "nvarchar(20)", maxLength: 20, nullable: true), CREATETIME = table.Column(type: "datetime2", nullable: false), STARTTIME = table.Column(type: "datetime2", nullable: true), ENDTIME = table.Column(type: "datetime2", nullable: true), PALLETTYPE = table.Column(type: "int", nullable: false), WMSTASK = table.Column(type: "int", nullable: false), UPLOADED = table.Column(type: "int", nullable: false), ENABLED = table.Column(type: "bit", nullable: false), UPDATEUSER = table.Column(type: "nvarchar(50)", maxLength: 50, nullable: false), UPDATETIME = table.Column(type: "datetime2", nullable: false), VER = table.Column(type: "rowversion", rowVersion: true, nullable: true) }, constraints: table => { table.PrimaryKey("PK_WCS_TASK", x => x.ID); }); } protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable( name: "WCS_TASK"); } } }