blob: a0ca5212f25cd30c2c01cfe16ac0513ff4138b43 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
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;
");
}
}
}
|
