201907190543469_ModifyFields1.cs 2.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940
  1. namespace EVCB_OCPP.Domain.MeterValueDBContextMigrations
  2. {
  3. using System;
  4. using System.Data.Entity.Migrations;
  5. public partial class ModifyFields1 : DbMigration
  6. {
  7. public override void Up()
  8. {
  9. AddColumn("dbo.ConnectorMeterValueRecord", "ContextId", c => c.Int(nullable: false));
  10. AddColumn("dbo.ConnectorMeterValueRecord", "FormatId", c => c.Int(nullable: false));
  11. AddColumn("dbo.ConnectorMeterValueRecord", "MeasurandId", c => c.Int(nullable: false));
  12. AddColumn("dbo.ConnectorMeterValueRecord", "PhaseId", c => c.Int(nullable: false));
  13. AddColumn("dbo.ConnectorMeterValueRecord", "LocationId", c => c.Int(nullable: false));
  14. AddColumn("dbo.ConnectorMeterValueRecord", "UnitId", c => c.Int(nullable: false));
  15. DropColumn("dbo.ConnectorMeterValueRecord", "ContextNo");
  16. DropColumn("dbo.ConnectorMeterValueRecord", "FormatNo");
  17. DropColumn("dbo.ConnectorMeterValueRecord", "MeasurandNo");
  18. DropColumn("dbo.ConnectorMeterValueRecord", "PhaseNo");
  19. DropColumn("dbo.ConnectorMeterValueRecord", "LocationNo");
  20. DropColumn("dbo.ConnectorMeterValueRecord", "UnitNo");
  21. }
  22. public override void Down()
  23. {
  24. AddColumn("dbo.ConnectorMeterValueRecord", "UnitNo", c => c.Int(nullable: false));
  25. AddColumn("dbo.ConnectorMeterValueRecord", "LocationNo", c => c.Int(nullable: false));
  26. AddColumn("dbo.ConnectorMeterValueRecord", "PhaseNo", c => c.Int(nullable: false));
  27. AddColumn("dbo.ConnectorMeterValueRecord", "MeasurandNo", c => c.Int(nullable: false));
  28. AddColumn("dbo.ConnectorMeterValueRecord", "FormatNo", c => c.Int(nullable: false));
  29. AddColumn("dbo.ConnectorMeterValueRecord", "ContextNo", c => c.Int(nullable: false));
  30. DropColumn("dbo.ConnectorMeterValueRecord", "UnitId");
  31. DropColumn("dbo.ConnectorMeterValueRecord", "LocationId");
  32. DropColumn("dbo.ConnectorMeterValueRecord", "PhaseId");
  33. DropColumn("dbo.ConnectorMeterValueRecord", "MeasurandId");
  34. DropColumn("dbo.ConnectorMeterValueRecord", "FormatId");
  35. DropColumn("dbo.ConnectorMeterValueRecord", "ContextId");
  36. }
  37. }
  38. }