20210725031413_7-25-2.cs 1.7 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. using System;
  2. using Microsoft.EntityFrameworkCore.Migrations;
  3. namespace WCS.Service.Migrations
  4. {
  5. public partial class _7252 : Migration
  6. {
  7. protected override void Up(MigrationBuilder migrationBuilder)
  8. {
  9. migrationBuilder.CreateTable(
  10. name: "WCS_AGVTask",
  11. columns: table => new
  12. {
  13. ID = table.Column<int>(type: "int", nullable: false)
  14. .Annotation("SqlServer:Identity", "1, 1"),
  15. AGVID = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
  16. TaskType = table.Column<int>(type: "int", nullable: false),
  17. Status = table.Column<int>(type: "int", nullable: false),
  18. AGVStatus = table.Column<int>(type: "int", nullable: false),
  19. Workshop = table.Column<int>(type: "int", nullable: false),
  20. Station = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: true),
  21. Position = table.Column<string>(type: "nvarchar(20)", maxLength: 20, nullable: false),
  22. CreateTime = table.Column<DateTime>(type: "datetime2", nullable: false),
  23. UpdateTime = table.Column<DateTime>(type: "datetime2", nullable: true),
  24. AGVUpdateTime = table.Column<DateTime>(type: "datetime2", nullable: true)
  25. },
  26. constraints: table =>
  27. {
  28. table.PrimaryKey("PK_WCS_AGVTask", x => x.ID);
  29. });
  30. }
  31. protected override void Down(MigrationBuilder migrationBuilder)
  32. {
  33. migrationBuilder.DropTable(
  34. name: "WCS_AGVTask");
  35. }
  36. }
  37. }