| | | 1 | | using Microsoft.EntityFrameworkCore.Infrastructure; |
| | | 2 | | using Microsoft.EntityFrameworkCore.Migrations; |
| | | 3 | | |
| | | 4 | | #nullable disable |
| | | 5 | | |
| | | 6 | | namespace ProjectTemplate.Infrastructure.Data.Migrations; |
| | | 7 | | |
| | | 8 | | /// <inheritdoc /> |
| | | 9 | | [DbContext(typeof(ApplicationDbContext))] |
| | | 10 | | [Migration("20260719170000_AddApplicationAuditReconciliation")] |
| | | 11 | | public partial class AddApplicationAuditReconciliation : Migration |
| | | 12 | | { |
| | | 13 | | /// <inheritdoc /> |
| | | 14 | | protected override void Up(MigrationBuilder migrationBuilder) |
| | | 15 | | { |
| | 1 | 16 | | migrationBuilder.CreateTable( |
| | 1 | 17 | | name: "ApplicationAuditReconciliationFindings", |
| | 1 | 18 | | columns: table => new |
| | 1 | 19 | | { |
| | 1 | 20 | | Id = table.Column<Guid>(type: "TEXT", nullable: false), |
| | 1 | 21 | | SchemaVersion = table.Column<string>(type: "TEXT", maxLength: 32, nullable: false), |
| | 1 | 22 | | FindingKey = table.Column<string>(type: "TEXT", maxLength: 128, nullable: false), |
| | 1 | 23 | | ReasonCode = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false), |
| | 1 | 24 | | Severity = table.Column<string>(type: "TEXT", maxLength: 32, nullable: false), |
| | 1 | 25 | | MutationBatchId = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false), |
| | 1 | 26 | | Destination = table.Column<string>(type: "TEXT", maxLength: 128, nullable: true), |
| | 1 | 27 | | Guidance = table.Column<string>(type: "TEXT", maxLength: 512, nullable: false), |
| | 1 | 28 | | RemediationStatus = table.Column<string>(type: "TEXT", maxLength: 32, nullable: false), |
| | 1 | 29 | | FirstObservedUtc = table.Column<DateTime>(type: "TEXT", precision: 3, nullable: false), |
| | 1 | 30 | | LastObservedUtc = table.Column<DateTime>(type: "TEXT", precision: 3, nullable: false), |
| | 1 | 31 | | ResolvedUtc = table.Column<DateTime>(type: "TEXT", precision: 3, nullable: true), |
| | 1 | 32 | | ConcurrencyStamp = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false) |
| | 1 | 33 | | }, |
| | 1 | 34 | | constraints: table => table.PrimaryKey("PK_ApplicationAuditReconciliationFindings", x => x.Id)); |
| | | 35 | | |
| | 1 | 36 | | migrationBuilder.CreateTable( |
| | 1 | 37 | | name: "ApplicationAuditReconciliationRemediations", |
| | 1 | 38 | | columns: table => new |
| | 1 | 39 | | { |
| | 1 | 40 | | Id = table.Column<Guid>(type: "TEXT", nullable: false), |
| | 1 | 41 | | FindingId = table.Column<Guid>(type: "TEXT", nullable: false), |
| | 1 | 42 | | MutationBatchId = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false), |
| | 1 | 43 | | ActionCode = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false), |
| | 1 | 44 | | ActorId = table.Column<string>(type: "TEXT", maxLength: 256, nullable: false), |
| | 1 | 45 | | EvidenceReference = table.Column<string>(type: "TEXT", maxLength: 256, nullable: true), |
| | 1 | 46 | | RecordedUtc = table.Column<DateTime>(type: "TEXT", precision: 3, nullable: false), |
| | 1 | 47 | | ConcurrencyStamp = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false) |
| | 1 | 48 | | }, |
| | 1 | 49 | | constraints: table => table.PrimaryKey("PK_ApplicationAuditReconciliationRemediations", x => x.Id)); |
| | | 50 | | |
| | 1 | 51 | | migrationBuilder.CreateIndex( |
| | 1 | 52 | | name: "IX_ApplicationAuditReconciliationFindings_FindingKey", |
| | 1 | 53 | | table: "ApplicationAuditReconciliationFindings", |
| | 1 | 54 | | column: "FindingKey", |
| | 1 | 55 | | unique: true); |
| | | 56 | | |
| | 1 | 57 | | migrationBuilder.CreateIndex( |
| | 1 | 58 | | name: "IX_ApplicationAuditReconciliationFindings_MutationBatchId_ReasonCode", |
| | 1 | 59 | | table: "ApplicationAuditReconciliationFindings", |
| | 1 | 60 | | columns: ["MutationBatchId", "ReasonCode"]); |
| | | 61 | | |
| | 1 | 62 | | migrationBuilder.CreateIndex( |
| | 1 | 63 | | name: "IX_ApplicationAuditReconciliationFindings_RemediationStatus_Severity", |
| | 1 | 64 | | table: "ApplicationAuditReconciliationFindings", |
| | 1 | 65 | | columns: ["RemediationStatus", "Severity"]); |
| | | 66 | | |
| | 1 | 67 | | migrationBuilder.CreateIndex( |
| | 1 | 68 | | name: "IX_ApplicationAuditReconciliationRemediations_FindingId", |
| | 1 | 69 | | table: "ApplicationAuditReconciliationRemediations", |
| | 1 | 70 | | column: "FindingId"); |
| | | 71 | | |
| | 1 | 72 | | migrationBuilder.CreateIndex( |
| | 1 | 73 | | name: "IX_ApplicationAuditReconciliationRemediations_MutationBatchId", |
| | 1 | 74 | | table: "ApplicationAuditReconciliationRemediations", |
| | 1 | 75 | | column: "MutationBatchId"); |
| | 1 | 76 | | } |
| | | 77 | | |
| | | 78 | | /// <inheritdoc /> |
| | | 79 | | protected override void Down(MigrationBuilder migrationBuilder) |
| | | 80 | | { |
| | 1 | 81 | | migrationBuilder.DropTable(name: "ApplicationAuditReconciliationRemediations"); |
| | 1 | 82 | | migrationBuilder.DropTable(name: "ApplicationAuditReconciliationFindings"); |
| | 1 | 83 | | } |
| | | 84 | | } |