diff options
| author | 杨宇千 <crupest@outlook.com> | 2019-08-19 16:12:16 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2019-08-19 16:12:16 +0800 |
| commit | 72ab8e49929d528b7cb461ba90ad86691a3f437b (patch) | |
| tree | bd8c0d70aac7cd4d1a6c28ae7c9b7c681dbd5613 /Timeline/Migrations/20190819074906_AddAvatarLastModified.cs | |
| parent | 3371b473d0d055f46c9ea09fba7e0d56e7a386a5 (diff) | |
| parent | 9168f07d1f35b5ba670b3c1d900f186ac868284b (diff) | |
| download | timeline-72ab8e49929d528b7cb461ba90ad86691a3f437b.tar.gz timeline-72ab8e49929d528b7cb461ba90ad86691a3f437b.tar.bz2 timeline-72ab8e49929d528b7cb461ba90ad86691a3f437b.zip | |
Merge pull request #45 from crupest/avatar-cache
Add 304 response for If-Modified-Since in avatar.
Diffstat (limited to 'Timeline/Migrations/20190819074906_AddAvatarLastModified.cs')
| -rw-r--r-- | Timeline/Migrations/20190819074906_AddAvatarLastModified.cs | 114 |
1 files changed, 114 insertions, 0 deletions
diff --git a/Timeline/Migrations/20190819074906_AddAvatarLastModified.cs b/Timeline/Migrations/20190819074906_AddAvatarLastModified.cs new file mode 100644 index 00000000..d9b5e8cf --- /dev/null +++ b/Timeline/Migrations/20190819074906_AddAvatarLastModified.cs @@ -0,0 +1,114 @@ +using System;
+using Microsoft.EntityFrameworkCore.Migrations;
+
+namespace Timeline.Migrations
+{
+ public partial class AddAvatarLastModified : Migration
+ {
+ protected override void Up(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropForeignKey(
+ name: "FK_users_user_avatars_AvatarId",
+ table: "users");
+
+ migrationBuilder.DropIndex(
+ name: "IX_users_AvatarId",
+ table: "users");
+
+ migrationBuilder.DropColumn(
+ name: "AvatarId",
+ table: "users");
+
+ migrationBuilder.AlterColumn<string>(
+ name: "type",
+ table: "user_avatars",
+ nullable: true,
+ oldClrType: typeof(string));
+
+ migrationBuilder.AlterColumn<byte[]>(
+ name: "data",
+ table: "user_avatars",
+ nullable: true,
+ oldClrType: typeof(byte[]));
+
+ migrationBuilder.AddColumn<DateTime>(
+ name: "last_modified",
+ table: "user_avatars",
+ nullable: false,
+ defaultValue: DateTime.Now);
+
+ migrationBuilder.AddColumn<long>(
+ name: "UserId",
+ table: "user_avatars",
+ nullable: false,
+ defaultValue: 0L);
+
+ migrationBuilder.CreateIndex(
+ name: "IX_user_avatars_UserId",
+ table: "user_avatars",
+ column: "UserId",
+ unique: true);
+
+ migrationBuilder.AddForeignKey(
+ name: "FK_user_avatars_users_UserId",
+ table: "user_avatars",
+ column: "UserId",
+ principalTable: "users",
+ principalColumn: "id",
+ onDelete: ReferentialAction.Cascade);
+
+ // Note! Remember to manually create avatar entities for all users.
+ }
+
+ protected override void Down(MigrationBuilder migrationBuilder)
+ {
+ migrationBuilder.DropForeignKey(
+ name: "FK_user_avatars_users_UserId",
+ table: "user_avatars");
+
+ migrationBuilder.DropIndex(
+ name: "IX_user_avatars_UserId",
+ table: "user_avatars");
+
+ migrationBuilder.DropColumn(
+ name: "last_modified",
+ table: "user_avatars");
+
+ migrationBuilder.DropColumn(
+ name: "UserId",
+ table: "user_avatars");
+
+ migrationBuilder.AddColumn<long>(
+ name: "AvatarId",
+ table: "users",
+ nullable: true);
+
+ migrationBuilder.AlterColumn<string>(
+ name: "type",
+ table: "user_avatars",
+ nullable: false,
+ oldClrType: typeof(string),
+ oldNullable: true);
+
+ migrationBuilder.AlterColumn<byte[]>(
+ name: "data",
+ table: "user_avatars",
+ nullable: false,
+ oldClrType: typeof(byte[]),
+ oldNullable: true);
+
+ migrationBuilder.CreateIndex(
+ name: "IX_users_AvatarId",
+ table: "users",
+ column: "AvatarId");
+
+ migrationBuilder.AddForeignKey(
+ name: "FK_users_user_avatars_AvatarId",
+ table: "users",
+ column: "AvatarId",
+ principalTable: "user_avatars",
+ principalColumn: "id",
+ onDelete: ReferentialAction.Restrict);
+ }
+ }
+}
|