1 files changed, 0 insertions, 55 deletions
diff --git a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs b/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs
deleted file mode 100644
index a0ca5212..00000000
--- a/Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs
+++ /dev/null
@@ -1,55 +0,0 @@
-using Microsoft.EntityFrameworkCore.Metadata;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace Timeline.Migrations.ProductionDatabase
-{
-    public partial class RefactorUser : Migration
-    {
-        protected override void Up(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.Sql(@"
-START TRANSACTION;
-
-ALTER TABLE `users`
-    CHANGE COLUMN `name` `username` varchar (26) NOT NULL,
-    RENAME INDEX IX_users_name TO IX_users_username,
-    ADD `nickname` varchar(100) CHARACTER SET utf8mb4 NULL;
-
-UPDATE users 
-    SET nickname = (
-        SELECT nickname
-        FROM user_details
-        WHERE user_details.UserId = users.id
-    );
-
-ALTER TABLE `user_avatars`
-    CHANGE COLUMN `UserId` `user` bigint (20) NOT NULL,
-    RENAME INDEX IX_user_avatars_UserId TO IX_user_avatars_user,
-    DROP FOREIGN KEY FK_user_avatars_users_UserId,
-    ADD CONSTRAINT FK_user_avatars_users_user FOREIGN KEY (`user`) REFERENCES `users` (`id`) ON DELETE CASCADE;
-
-COMMIT;
-            ");
-        }
-
-        protected override void Down(MigrationBuilder migrationBuilder)
-        {
-            migrationBuilder.Sql(@"
-START TRANSACTION;
-
-ALTER TABLE `users`
-    CHANGE COLUMN `username` `name` varchar (26) NOT NULL,
-    RENAME INDEX IX_users_username TO IX_users_name,
-    DROP COLUMN `nickname`;
-
-ALTER TABLE `user_avatars`
-    CHANGE COLUMN `user` `UserId` bigint (20) NOT NULL,
-    RENAME INDEX IX_user_avatars_user TO IX_user_avatars_UserId,
-    DROP FOREIGN KEY FK_user_avatars_users_user,
-    ADD CONSTRAINT FK_user_avatars_users_UserId FOREIGN KEY (`UserId`) REFERENCES `users` (`id`) ON DELETE CASCADE;
-
-COMMIT;
-            ");
-        }
-    }
-}