📄
MatDenDagen/Infrastructure/Storage/Database/Migrations/20260504152716_CreateParticipants.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
using System; using Microsoft.EntityFrameworkCore.Migrations; #nullable disable namespace MatDenDagen.Infrastructure.Storage.Database.Migrations { /// <inheritdoc /> public partial class CreateParticipants : Migration { /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { migrationBuilder.AddColumn<Guid>( name: "Participant", table: "Submissions", type: "TEXT", nullable: false, defaultValue: new Guid("00000000-0000-0000-0000-000000000000") ); migrationBuilder.CreateTable( name: "Participants", columns: table => new { Id = table.Column<Guid>(type: "TEXT", nullable: false), PhoneNumber = table.Column<string>(type: "TEXT", nullable: false), Name = table.Column<string>(type: "TEXT", nullable: false), }, constraints: table => { table.PrimaryKey("PK_Participants", x => x.Id); } ); migrationBuilder.CreateIndex( name: "IX_Submissions_Participant", table: "Submissions", column: "Participant" ); migrationBuilder.CreateIndex( name: "IX_Participants_PhoneNumber", table: "Participants", column: "PhoneNumber", unique: true ); migrationBuilder.AddForeignKey( name: "FK_Submissions_Participants_Participant", table: "Submissions", column: "Participant", principalTable: "Participants", principalColumn: "Id", onDelete: ReferentialAction.Cascade ); } /// <inheritdoc /> protected override void Down(MigrationBuilder migrationBuilder) { migrationBuilder.DropForeignKey(name: "FK_Submissions_Participants_Participant", table: "Submissions"); migrationBuilder.DropTable(name: "Participants"); migrationBuilder.DropIndex(name: "IX_Submissions_Participant", table: "Submissions"); migrationBuilder.DropColumn(name: "Participant", table: "Submissions"); } } }