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"); } } }