aboutsummaryrefslogtreecommitdiff
path: root/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
diff options
context:
space:
mode:
Diffstat (limited to 'Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs')
-rw-r--r--Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs50
1 files changed, 0 insertions, 50 deletions
diff --git a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
deleted file mode 100644
index 7abbed79..00000000
--- a/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs
+++ /dev/null
@@ -1,50 +0,0 @@
-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)
- {
- }
- }
-}