20200721120025_Calculation.cs 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. using Microsoft.EntityFrameworkCore.Migrations;
  2. namespace GreenTree.Strohrmann.ERP.Domain.Migrations
  3. {
  4. public partial class Calculation : Migration
  5. {
  6. protected override void Up(MigrationBuilder migrationBuilder)
  7. {
  8. migrationBuilder.AddColumn<decimal>(
  9. name: "CalculationFactor",
  10. table: "CraftMaterials",
  11. nullable: false,
  12. defaultValue: 0m);
  13. migrationBuilder.AddColumn<decimal>(
  14. name: "Value",
  15. table: "CraftEmployees",
  16. nullable: false,
  17. defaultValue: 0m);
  18. migrationBuilder.InsertData(
  19. table: "Units",
  20. columns: new[] { "Id", "Description", "Name", "ShortName" },
  21. values: new object[] { 8, "Angabe in Einheit Milimeter", "Milimeter", "mm" });
  22. }
  23. protected override void Down(MigrationBuilder migrationBuilder)
  24. {
  25. migrationBuilder.DeleteData(
  26. table: "Units",
  27. keyColumn: "Id",
  28. keyValue: 8);
  29. migrationBuilder.DropColumn(
  30. name: "CalculationFactor",
  31. table: "CraftMaterials");
  32. migrationBuilder.DropColumn(
  33. name: "Value",
  34. table: "CraftEmployees");
  35. }
  36. }
  37. }