20211026062747_20211026.cs 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. namespace wispro.sp.api.Migrations
  3. {
  4. public partial class _20211026 : Migration
  5. {
  6. protected override void Up(MigrationBuilder migrationBuilder)
  7. {
  8. migrationBuilder.AddColumn<bool>(
  9. name: "IsOnJob",
  10. table: "Staff",
  11. type: "bit",
  12. nullable: false,
  13. defaultValue: false);
  14. migrationBuilder.AddColumn<string>(
  15. name: "Mobile",
  16. table: "Staff",
  17. type: "nvarchar(max)",
  18. nullable: true);
  19. migrationBuilder.AddColumn<string>(
  20. name: "Sex",
  21. table: "Staff",
  22. type: "nvarchar(max)",
  23. nullable: true);
  24. migrationBuilder.AddColumn<string>(
  25. name: "Tel",
  26. table: "Staff",
  27. type: "nvarchar(max)",
  28. nullable: true);
  29. }
  30. protected override void Down(MigrationBuilder migrationBuilder)
  31. {
  32. migrationBuilder.DropColumn(
  33. name: "IsOnJob",
  34. table: "Staff");
  35. migrationBuilder.DropColumn(
  36. name: "Mobile",
  37. table: "Staff");
  38. migrationBuilder.DropColumn(
  39. name: "Sex",
  40. table: "Staff");
  41. migrationBuilder.DropColumn(
  42. name: "Tel",
  43. table: "Staff");
  44. }
  45. }
  46. }