diff options
author | HombreLaser <sebastian-440@live.com> | 2022-11-22 16:46:46 -0600 |
---|---|---|
committer | HombreLaser <sebastian-440@live.com> | 2022-11-22 16:46:46 -0600 |
commit | 214cd4db690635ba2a30183c1679c3e4d7b8e896 (patch) | |
tree | 95de21f42a07c27cdfa5b50be25ae97bab3abefe /Migrations/20221122224441_AddTicket.cs | |
parent | ea20e100d4afe4429ab4c24926bffc0a8f9b9b70 (diff) |
Añadido modelo de ticket
Diffstat (limited to 'Migrations/20221122224441_AddTicket.cs')
-rw-r--r-- | Migrations/20221122224441_AddTicket.cs | 60 |
1 files changed, 60 insertions, 0 deletions
diff --git a/Migrations/20221122224441_AddTicket.cs b/Migrations/20221122224441_AddTicket.cs new file mode 100644 index 0000000..d74f927 --- /dev/null +++ b/Migrations/20221122224441_AddTicket.cs @@ -0,0 +1,60 @@ +using Microsoft.EntityFrameworkCore.Migrations; +using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; + +#nullable disable + +namespace BackendPIA.Migrations +{ + /// <inheritdoc /> + public partial class AddTicket : Migration + { + /// <inheritdoc /> + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.CreateTable( + name: "Tickets", + columns: table => new + { + Id = table.Column<long>(type: "bigint", nullable: false) + .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), + Number = table.Column<int>(type: "integer", nullable: false), + IsWinner = table.Column<bool>(type: "boolean", nullable: false), + UserAccountId = table.Column<long>(type: "bigint", nullable: false), + RaffleId = table.Column<long>(type: "bigint", nullable: false), + OwnerId = table.Column<string>(type: "text", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_Tickets", x => x.Id); + table.ForeignKey( + name: "FK_Tickets_AspNetUsers_OwnerId", + column: x => x.OwnerId, + principalTable: "AspNetUsers", + principalColumn: "Id"); + table.ForeignKey( + name: "FK_Tickets_Raffles_RaffleId", + column: x => x.RaffleId, + principalTable: "Raffles", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_Tickets_OwnerId", + table: "Tickets", + column: "OwnerId"); + + migrationBuilder.CreateIndex( + name: "IX_Tickets_RaffleId", + table: "Tickets", + column: "RaffleId"); + } + + /// <inheritdoc /> + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "Tickets"); + } + } +} |