diff options
| author | crupest <crupest@outlook.com> | 2020-06-17 13:05:00 +0800 |
|---|---|---|
| committer | crupest <crupest@outlook.com> | 2020-06-17 13:05:00 +0800 |
| commit | 5eec1a0aac725d8b21303f94e720a79dca8d918e (patch) | |
| tree | ce6a27bbf5f778f15a5b4ae68210a0f11a1e57c5 | |
| parent | 29d0a3980a31e5fec75cd939bcb991c8ea8c93ae (diff) | |
| download | timeline-5eec1a0aac725d8b21303f94e720a79dca8d918e.tar.gz timeline-5eec1a0aac725d8b21303f94e720a79dca8d918e.tar.bz2 timeline-5eec1a0aac725d8b21303f94e720a79dca8d918e.zip | |
fix(database): Fix a critical bug in database migration.
| -rw-r--r-- | Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs | 7 |
1 files 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;
|