diff options
Diffstat (limited to 'backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs')
| -rw-r--r-- | backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs | 74 |
1 files changed, 0 insertions, 74 deletions
diff --git a/backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs b/backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs deleted file mode 100644 index b20a47a..0000000 --- a/backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs +++ /dev/null @@ -1,74 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; - -#nullable disable - -namespace Elements.Data.Migrations -{ - /// <inheritdoc /> - public partial class Addsuggestions : Migration - { - /// <inheritdoc /> - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.CreateTable( - name: "Suggestion", - columns: table => new - { - Id = table.Column<int>(type: "INTEGER", nullable: false) - .Annotation("Sqlite:Autoincrement", true), - Name = table.Column<string>(type: "TEXT", nullable: false), - Icon = table.Column<string>(type: "TEXT", nullable: false), - FirstIngredientId = table.Column<int>(type: "INTEGER", nullable: false), - SecondIngredientId = table.Column<int>(type: "INTEGER", nullable: false), - VotingEnd = table.Column<DateTime>(type: "TEXT", nullable: false), - Votes = table.Column<int>(type: "INTEGER", nullable: false), - UserId = table.Column<int>(type: "INTEGER", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_Suggestion", x => x.Id); - table.ForeignKey( - name: "FK_Suggestion_Elements_FirstIngredientId", - column: x => x.FirstIngredientId, - principalTable: "Elements", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_Suggestion_Elements_SecondIngredientId", - column: x => x.SecondIngredientId, - principalTable: "Elements", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_Suggestion_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateIndex( - name: "IX_Suggestion_FirstIngredientId", - table: "Suggestion", - column: "FirstIngredientId"); - - migrationBuilder.CreateIndex( - name: "IX_Suggestion_SecondIngredientId", - table: "Suggestion", - column: "SecondIngredientId"); - - migrationBuilder.CreateIndex( - name: "IX_Suggestion_UserId", - table: "Suggestion", - column: "UserId"); - } - - /// <inheritdoc /> - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropTable( - name: "Suggestion"); - } - } -} |
