diff options
Diffstat (limited to 'Migrations/20221125223610_AddRaffleWinner.cs')
-rw-r--r-- | Migrations/20221125223610_AddRaffleWinner.cs | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/Migrations/20221125223610_AddRaffleWinner.cs b/Migrations/20221125223610_AddRaffleWinner.cs new file mode 100644 index 0000000..68a66af --- /dev/null +++ b/Migrations/20221125223610_AddRaffleWinner.cs @@ -0,0 +1,70 @@ +using Microsoft.EntityFrameworkCore.Migrations; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; + +#nullable disable + +namespace BackendPIA.Migrations +{ + /// <inheritdoc /> + public partial class AddRaffleWinner : Migration + { + /// <inheritdoc /> + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "RaffleWinners", + columns: table => new + { + Id = table.Column<long>(type: "bigint", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + UserAccountId = table.Column<string>(type: "text", nullable: false), + PrizeId = table.Column<long>(type: "bigint", nullable: false), + RaffleId = table.Column<long>(type: "bigint", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_RaffleWinners", x => x.Id); + table.ForeignKey( + name: "FK_RaffleWinners_AspNetUsers_UserAccountId", + column: x => x.UserAccountId, + principalTable: "AspNetUsers", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + table.ForeignKey( + name: "FK_RaffleWinners_Prizes_PrizeId", + column: x => x.PrizeId, + principalTable: "Prizes", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + table.ForeignKey( + name: "FK_RaffleWinners_Raffles_RaffleId", + column: x => x.RaffleId, + principalTable: "Raffles", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_RaffleWinners_PrizeId", + table: "RaffleWinners", + column: "PrizeId"); + + migrationBuilder.CreateIndex( + name: "IX_RaffleWinners_RaffleId", + table: "RaffleWinners", + column: "RaffleId"); + + migrationBuilder.CreateIndex( + name: "IX_RaffleWinners_UserAccountId", + table: "RaffleWinners", + column: "UserAccountId"); + } + + /// <inheritdoc /> + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "RaffleWinners"); + } + } +} |