drinkrate/DrinkRateAPI/Migrations/20250811181117_FixTypo.cs
martinshoob e0ecd86288 Establish a one-to-one relationship
Define a one-to-one relationship between CompanyTable and ProductTable.

Correct a typo in the CompanyTable DbSet name within the ApplicationDbContext to ensure correct database mapping and operations.
2025-08-11 20:12:42 +02:00

150 lines
5.7 KiB
C#

using Microsoft.EntityFrameworkCore.Migrations;
#nullable disable
namespace DrinkRateAPI.Migrations
{
/// <inheritdoc />
public partial class FixTypo : Migration
{
/// <inheritdoc />
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropForeignKey(
name: "FK_Companies_CompanyTables_CompanyTableId",
table: "Companies");
migrationBuilder.DropForeignKey(
name: "FK_DbCompanyTableDbCompanyTableView_CompanyTables_CompanyTable~",
table: "DbCompanyTableDbCompanyTableView");
migrationBuilder.DropForeignKey(
name: "FK_ProductTable_CompanyTables_CompanyTableId",
table: "ProductTable");
migrationBuilder.DropForeignKey(
name: "FK_UserProfileCompanyTableStats_CompanyTables_CompanyTableId",
table: "UserProfileCompanyTableStats");
migrationBuilder.DropPrimaryKey(
name: "PK_CompanyTables",
table: "CompanyTables");
migrationBuilder.RenameTable(
name: "CompanyTables",
newName: "CompanyTable");
migrationBuilder.RenameIndex(
name: "IX_CompanyTables_CompanyTableName",
table: "CompanyTable",
newName: "IX_CompanyTable_CompanyTableName");
migrationBuilder.AddPrimaryKey(
name: "PK_CompanyTable",
table: "CompanyTable",
column: "Id");
migrationBuilder.AddForeignKey(
name: "FK_Companies_CompanyTable_CompanyTableId",
table: "Companies",
column: "CompanyTableId",
principalTable: "CompanyTable",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_DbCompanyTableDbCompanyTableView_CompanyTable_CompanyTables~",
table: "DbCompanyTableDbCompanyTableView",
column: "CompanyTablesId",
principalTable: "CompanyTable",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_ProductTable_CompanyTable_CompanyTableId",
table: "ProductTable",
column: "CompanyTableId",
principalTable: "CompanyTable",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_UserProfileCompanyTableStats_CompanyTable_CompanyTableId",
table: "UserProfileCompanyTableStats",
column: "CompanyTableId",
principalTable: "CompanyTable",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
}
/// <inheritdoc />
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropForeignKey(
name: "FK_Companies_CompanyTable_CompanyTableId",
table: "Companies");
migrationBuilder.DropForeignKey(
name: "FK_DbCompanyTableDbCompanyTableView_CompanyTable_CompanyTables~",
table: "DbCompanyTableDbCompanyTableView");
migrationBuilder.DropForeignKey(
name: "FK_ProductTable_CompanyTable_CompanyTableId",
table: "ProductTable");
migrationBuilder.DropForeignKey(
name: "FK_UserProfileCompanyTableStats_CompanyTable_CompanyTableId",
table: "UserProfileCompanyTableStats");
migrationBuilder.DropPrimaryKey(
name: "PK_CompanyTable",
table: "CompanyTable");
migrationBuilder.RenameTable(
name: "CompanyTable",
newName: "CompanyTables");
migrationBuilder.RenameIndex(
name: "IX_CompanyTable_CompanyTableName",
table: "CompanyTables",
newName: "IX_CompanyTables_CompanyTableName");
migrationBuilder.AddPrimaryKey(
name: "PK_CompanyTables",
table: "CompanyTables",
column: "Id");
migrationBuilder.AddForeignKey(
name: "FK_Companies_CompanyTables_CompanyTableId",
table: "Companies",
column: "CompanyTableId",
principalTable: "CompanyTables",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_DbCompanyTableDbCompanyTableView_CompanyTables_CompanyTable~",
table: "DbCompanyTableDbCompanyTableView",
column: "CompanyTablesId",
principalTable: "CompanyTables",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_ProductTable_CompanyTables_CompanyTableId",
table: "ProductTable",
column: "CompanyTableId",
principalTable: "CompanyTables",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
migrationBuilder.AddForeignKey(
name: "FK_UserProfileCompanyTableStats_CompanyTables_CompanyTableId",
table: "UserProfileCompanyTableStats",
column: "CompanyTableId",
principalTable: "CompanyTables",
principalColumn: "Id",
onDelete: ReferentialAction.Cascade);
}
}
}