From e632e9241e8afe530f6b37cb683b211769135c45 Mon Sep 17 00:00:00 2001 From: transtrike Date: Thu, 28 Jan 2021 01:08:31 +0200 Subject: USER UPDATE FIIIIIIXED --- .../20210127222937_UserFriends_Implement.cs | 78 ++++++++++++++++++++++ 1 file changed, 78 insertions(+) create mode 100644 src/DevHive.Data/Migrations/20210127222937_UserFriends_Implement.cs (limited to 'src/DevHive.Data/Migrations/20210127222937_UserFriends_Implement.cs') diff --git a/src/DevHive.Data/Migrations/20210127222937_UserFriends_Implement.cs b/src/DevHive.Data/Migrations/20210127222937_UserFriends_Implement.cs new file mode 100644 index 0000000..e891b9f --- /dev/null +++ b/src/DevHive.Data/Migrations/20210127222937_UserFriends_Implement.cs @@ -0,0 +1,78 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; + +namespace DevHive.Data.Migrations +{ + public partial class UserFriends_Implement : Migration + { + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "UserUser"); + + migrationBuilder.CreateTable( + name: "UserFriends", + columns: table => new + { + UserId = table.Column(type: "uuid", nullable: false), + FriendId = table.Column(type: "uuid", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_UserFriends", x => new { x.UserId, x.FriendId }); + table.ForeignKey( + name: "FK_UserFriends_AspNetUsers_FriendId", + column: x => x.FriendId, + principalTable: "AspNetUsers", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + table.ForeignKey( + name: "FK_UserFriends_AspNetUsers_UserId", + column: x => x.UserId, + principalTable: "AspNetUsers", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_UserFriends_FriendId", + table: "UserFriends", + column: "FriendId"); + } + + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropTable( + name: "UserFriends"); + + migrationBuilder.CreateTable( + name: "UserUser", + columns: table => new + { + UserId = table.Column(type: "uuid", nullable: false), + FriendId = table.Column(type: "uuid", nullable: false) + }, + constraints: table => + { + table.PrimaryKey("PK_UserUser", x => new { x.UserId, x.FriendId }); + table.ForeignKey( + name: "FK_UserUser_AspNetUsers_FriendId", + column: x => x.FriendId, + principalTable: "AspNetUsers", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + table.ForeignKey( + name: "FK_UserUser_AspNetUsers_UserId", + column: x => x.UserId, + principalTable: "AspNetUsers", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_UserUser_FriendId", + table: "UserUser", + column: "FriendId"); + } + } +} -- cgit v1.2.3