📄
MatDenDagen/Infrastructure/Storage/Database/Migrations/20260502114950_InitialCreate.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace MatDenDagen.Infrastructure.Storage.Database.Migrations { /// <inheritdoc /> public partial class InitialCreate : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.CreateTable( name: "Questions", columns: table => new { Id = table.Column<Guid>(type: "TEXT", nullable: false), Text = table.Column<string>(type: "TEXT", nullable: false), }, constraints: table => { table.PrimaryKey("PK_Questions", x => x.Id); } ); migrationBuilder.CreateTable( name: "Submissions", columns: table => new { Id = table.Column<Guid>(type: "TEXT", nullable: false) }, constraints: table => { table.PrimaryKey("PK_Submissions", x => x.Id); } ); migrationBuilder.CreateTable( name: "Answer", columns: table => new { Id = table.Column<Guid>(type: "TEXT", nullable: false), QuestionId = table.Column<Guid>(type: "TEXT", nullable: false), Text = table.Column<string>(type: "TEXT", nullable: false), SubmissionId = table.Column<Guid>(type: "TEXT", nullable: true), }, constraints: table => { table.PrimaryKey("PK_Answer", x => x.Id); table.ForeignKey( name: "FK_Answer_Questions_QuestionId", column: x => x.QuestionId, principalTable: "Questions", principalColumn: "Id", onDelete: ReferentialAction.Cascade ); table.ForeignKey( name: "FK_Answer_Submissions_SubmissionId", column: x => x.SubmissionId, principalTable: "Submissions", principalColumn: "Id" ); } ); migrationBuilder.CreateIndex(name: "IX_Answer_QuestionId", table: "Answer", column: "QuestionId"); migrationBuilder.CreateIndex(name: "IX_Answer_SubmissionId", table: "Answer", column: "SubmissionId"); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropTable(name: "Answer"); migrationBuilder.DropTable(name: "Questions"); migrationBuilder.DropTable(name: "Submissions"); } } }