From 74f75d851300d2d4b511e4062f50e0560e8b041d Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Sun, 14 Jun 2020 21:30:13 +0800
Subject: fix(back): Finally get the right way to migrate database.

---
 .../20200614061237_AddTimelineUniqueId.cs          | 66 ++++++----------------
 1 file changed, 17 insertions(+), 49 deletions(-)

diff --git a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
index 1fc3de18..2d579544 100644
--- a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
+++ b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
@@ -8,11 +8,11 @@ namespace Timeline.Migrations
         {
             migrationBuilder.Sql(
 @"
-ALTER TABLE timelines RENAME TO timelines_backup;
-ALTER TABLE timeline_members RENAME TO timeline_members_backup;
-ALTER TABLE timeline_posts RENAME TO timeline_posts_backup;
+PRAGMA foreign_keys=OFF;
 
-CREATE TABLE timelines (
+BEGIN TRANSACTION;
+
+CREATE TABLE new_timelines (
     id INTEGER NOT NULL CONSTRAINT PK_timelines PRIMARY KEY AUTOINCREMENT,
 	unique_id TEXT NOT NULL DEFAULT (lower(hex(randomblob(16)))),
     name TEXT NULL,
@@ -23,55 +23,23 @@ CREATE TABLE timelines (
     CONSTRAINT FK_timelines_users_owner FOREIGN KEY (owner) REFERENCES users (id) ON DELETE CASCADE
 );
 
-CREATE TABLE timeline_members (
-    id       INTEGER NOT NULL
-                     CONSTRAINT PK_timeline_members PRIMARY KEY AUTOINCREMENT,
-    user     INTEGER NOT NULL,
-    timeline INTEGER NOT NULL,
-    CONSTRAINT FK_timeline_members_timelines_timeline FOREIGN KEY (
-        timeline
-    )
-    REFERENCES timelines (id) ON DELETE CASCADE,
-    CONSTRAINT FK_timeline_members_users_user FOREIGN KEY (
-        user
-    )
-    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;
+	
+DROP TABLE timelines;
 
-CREATE TABLE timeline_posts (
-    id            INTEGER NOT NULL
-                          CONSTRAINT PK_timeline_posts PRIMARY KEY AUTOINCREMENT,
-    timeline      INTEGER NOT NULL,
-    author        INTEGER NOT NULL,
-    content       TEXT,
-    time          TEXT    NOT NULL,
-    last_updated  TEXT    NOT NULL,
-    local_id      INTEGER NOT NULL
-                          DEFAULT 0,
-    content_type  TEXT    NOT NULL
-                          DEFAULT '',
-    extra_content TEXT,
-    CONSTRAINT FK_timeline_posts_users_author FOREIGN KEY (
-        author
-    )
-    REFERENCES users (id) ON DELETE CASCADE,
-    CONSTRAINT FK_timeline_posts_timelines_timeline FOREIGN KEY (
-        timeline
-    )
-    REFERENCES timelines (id) ON DELETE CASCADE
-);
+ALTER TABLE new_timelines
+	RENAME TO timelines; 
 
+CREATE INDEX IX_timelines_owner ON timelines (owner);
 
-INSERT INTO timelines (id, name, description, owner, visibility, create_time)
-	SELECT id, name, description, owner, visibility, create_time FROM timelines_backup;
-INSERT INTO timeline_members SELECT * FROM timeline_members_backup;
-INSERT INTO timeline_posts SELECT * FROM timeline_posts_backup;
-	
-DROP TABLE timelines_backup;
-DROP TABLE timeline_members_backup;
-DROP TABLE timeline_posts_backup;
+PRAGMA foreign_key_check;
+
+COMMIT TRANSACTION;
+
+PRAGMA foreign_keys=ON;
 "
-                );
+                , true);
         }
 
         protected override void Down(MigrationBuilder migrationBuilder)
-- 
cgit v1.2.3