Split front and back end.

1 files changed, 50 insertions, 0 deletions

diff --git a/BackEnd/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs b/BackEnd/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
new file mode 100644
index 00000000..7abbed79
--- /dev/null
+++ b/BackEnd/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
@@ -0,0 +1,50 @@
+using Microsoft.EntityFrameworkCore.Migrations;

+

+namespace Timeline.Migrations

+{

+    public partial class AddTimelineUniqueId : Migration

+    {

+        protected override void Up(MigrationBuilder migrationBuilder)

+        {

+            migrationBuilder.Sql(

+@"

+PRAGMA foreign_keys=OFF;

+

+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,

+    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,

+    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, current_post_local_id)

+	SELECT id, name, description, owner, visibility, create_time, current_post_local_id FROM timelines;

+	

+DROP TABLE timelines;

+

+ALTER TABLE new_timelines

+	RENAME TO timelines; 

+

+CREATE INDEX IX_timelines_owner ON timelines (owner);

+

+PRAGMA foreign_key_check;

+

+COMMIT TRANSACTION;

+

+PRAGMA foreign_keys=ON;

+"

+                , true);

+        }

+

+        protected override void Down(MigrationBuilder migrationBuilder)

+        {

+        }

+    }

+}