From 5eec1a0aac725d8b21303f94e720a79dca8d918e Mon Sep 17 00:00:00 2001 From: crupest Date: Wed, 17 Jun 2020 13:05:00 +0800 Subject: fix(database): Fix a critical bug in database migration. --- Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs index 2d579544..7abbed79 100644 --- a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs +++ b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs @@ -19,12 +19,13 @@ CREATE TABLE new_timelines ( description TEXT NULL, owner INTEGER NOT NULL, visibility INTEGER NOT NULL, - create_time TEXT NOT NULL, current_post_local_id INTEGER NOT NULL DEFAULT 0, + create_time TEXT NOT NULL, + current_post_local_id INTEGER NOT NULL DEFAULT 0, CONSTRAINT FK_timelines_users_owner FOREIGN KEY (owner) REFERENCES users (id) ON DELETE CASCADE ); -INSERT INTO new_timelines (id, name, description, owner, visibility, create_time) - SELECT id, name, description, owner, visibility, create_time FROM timelines; +INSERT INTO new_timelines (id, name, description, owner, visibility, create_time, current_post_local_id) + SELECT id, name, description, owner, visibility, create_time, current_post_local_id FROM timelines; DROP TABLE timelines; -- cgit v1.2.3