From e775895bf0332334ef1925a6cdeff27bc341ad8a Mon Sep 17 00:00:00 2001 From: Paweł Bernaciak Date: Sat, 21 Oct 2023 20:43:00 +0200 Subject: Change how element icons are stored --- .../Migrations/20231021135238_Add suggestions.cs | 74 ---------------------- 1 file changed, 74 deletions(-) delete mode 100644 backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs (limited to 'backend/Elements.Data/Migrations/20231021135238_Add suggestions.cs') 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 -{ - /// - public partial class Addsuggestions : Migration - { - /// - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.CreateTable( - name: "Suggestion", - columns: table => new - { - Id = table.Column(type: "INTEGER", nullable: false) - .Annotation("Sqlite:Autoincrement", true), - Name = table.Column(type: "TEXT", nullable: false), - Icon = table.Column(type: "TEXT", nullable: false), - FirstIngredientId = table.Column(type: "INTEGER", nullable: false), - SecondIngredientId = table.Column(type: "INTEGER", nullable: false), - VotingEnd = table.Column(type: "TEXT", nullable: false), - Votes = table.Column(type: "INTEGER", nullable: false), - UserId = table.Column(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"); - } - - /// - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropTable( - name: "Suggestion"); - } - } -} -- cgit v1.2.3