From 3fa9899e17df4b1012e8b645915ac15022b84f9b Mon Sep 17 00:00:00 2001 From: crupest Date: Fri, 21 Feb 2020 11:59:58 +0800 Subject: Migrate to use sqlite. --- .../20200131152033_RefactorUser.cs | 55 ---------------------- 1 file changed, 55 deletions(-) delete mode 100644 Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs (limited to 'Timeline/Migrations/ProductionDatabase/20200131152033_RefactorUser.cs') 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; - "); - } - } -} -- cgit v1.2.3