201907190308254_ModifyFields.cs 2.2 KB

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