aboutsummaryrefslogtreecommitdiff
path: root/Timeline/Migrations/20200229103848_AddPostLocalId.cs
diff options
context:
space:
mode:
authorcrupest <crupest@outlook.com>2020-10-27 19:21:35 +0800
committercrupest <crupest@outlook.com>2020-10-27 19:21:35 +0800
commitac769e656b122ff569c3f1534701b71e00fed586 (patch)
tree72966645ff1e25139d3995262e1c4349f2c14733 /Timeline/Migrations/20200229103848_AddPostLocalId.cs
parent14e5848c23c643cea9b5d709770747d98c3d75e2 (diff)
downloadtimeline-ac769e656b122ff569c3f1534701b71e00fed586.tar.gz
timeline-ac769e656b122ff569c3f1534701b71e00fed586.tar.bz2
timeline-ac769e656b122ff569c3f1534701b71e00fed586.zip
Split front and back end.
Diffstat (limited to 'Timeline/Migrations/20200229103848_AddPostLocalId.cs')
-rw-r--r--Timeline/Migrations/20200229103848_AddPostLocalId.cs42
1 files changed, 0 insertions, 42 deletions
diff --git a/Timeline/Migrations/20200229103848_AddPostLocalId.cs b/Timeline/Migrations/20200229103848_AddPostLocalId.cs
deleted file mode 100644
index 497b38a1..00000000
--- a/Timeline/Migrations/20200229103848_AddPostLocalId.cs
+++ /dev/null
@@ -1,42 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-namespace Timeline.Migrations
-{
- public partial class AddPostLocalId : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
-
- migrationBuilder.AddColumn<long>(
- name: "current_post_local_id",
- table: "timelines",
- nullable: false,
- defaultValue: 0L);
-
- migrationBuilder.AddColumn<long>(
- name: "local_id",
- table: "timeline_posts",
- nullable: false,
- defaultValue: 0L);
-
- migrationBuilder.Sql(@"
-UPDATE timeline_posts
-SET local_id = (SELECT COUNT (*)
- FROM timeline_posts AS p
- WHERE p.timeline = timeline_posts.timeline
- AND p.id <= timeline_posts.id);
-
-UPDATE timelines
-SET current_post_local_id = (SELECT COUNT (*)
- FROM timeline_posts AS p
- WHERE p.timeline = timelines.id);
- ");
- }
-
- protected override void Down(MigrationBuilder migrationBuilder)
- {
-
- }
- }
-}