202005290620325_Modified_UploadFileId.cs 1.9 KB

123456789101112131415161718192021222324252627282930313233343536
  1. namespace EVCB_OCPP.Domain.MainDBContextMigrations
  2. {
  3. using System;
  4. using System.Data.Entity.Migrations;
  5. public partial class Modified_UploadFileId : DbMigration
  6. {
  7. public override void Up()
  8. {
  9. DropForeignKey("dbo.MachineVersionFile", "UploadFileId", "dbo.UploadFile");
  10. DropIndex("dbo.MachineVersionFile", new[] { "UploadFileId" });
  11. DropPrimaryKey("dbo.UploadFile");
  12. AlterColumn("dbo.MachineVersionFile", "UploadFileId", c => c.String(nullable: false, maxLength: 36));
  13. AlterColumn("dbo.UploadFile", "Id", c => c.String(nullable: false, maxLength: 36));
  14. AlterColumn("dbo.UploadFile", "VendorId", c => c.String(nullable: false, maxLength: 50));
  15. AlterColumn("dbo.UploadFile", "ModelName", c => c.String(nullable: false, maxLength: 50));
  16. AddPrimaryKey("dbo.UploadFile", "Id");
  17. CreateIndex("dbo.MachineVersionFile", "UploadFileId");
  18. AddForeignKey("dbo.MachineVersionFile", "UploadFileId", "dbo.UploadFile", "Id", cascadeDelete: true);
  19. }
  20. public override void Down()
  21. {
  22. DropForeignKey("dbo.MachineVersionFile", "UploadFileId", "dbo.UploadFile");
  23. DropIndex("dbo.MachineVersionFile", new[] { "UploadFileId" });
  24. DropPrimaryKey("dbo.UploadFile");
  25. AlterColumn("dbo.UploadFile", "ModelName", c => c.String(maxLength: 50));
  26. AlterColumn("dbo.UploadFile", "VendorId", c => c.String(maxLength: 50));
  27. AlterColumn("dbo.UploadFile", "Id", c => c.Guid(nullable: false));
  28. AlterColumn("dbo.MachineVersionFile", "UploadFileId", c => c.Guid(nullable: false));
  29. AddPrimaryKey("dbo.UploadFile", "Id");
  30. CreateIndex("dbo.MachineVersionFile", "UploadFileId");
  31. AddForeignKey("dbo.MachineVersionFile", "UploadFileId", "dbo.UploadFile", "Id", cascadeDelete: true);
  32. }
  33. }
  34. }