diff options
author | crupest <crupest@outlook.com> | 2020-10-31 00:42:06 +0800 |
---|---|---|
committer | GitHub <noreply@github.com> | 2020-10-31 00:42:06 +0800 |
commit | a3c97f6fb6313da2e8c0fac0b4c08f2ef4265d0f (patch) | |
tree | ee006874b0c93e9bfc76f141a092a8b9585a1f95 /Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs | |
parent | 0c4caaebe2480e77918d5d7df234f0edaeab74ba (diff) | |
parent | 7ce0846d9ec968da3ea4f7ebcc6db26db8e49089 (diff) | |
download | timeline-a3c97f6fb6313da2e8c0fac0b4c08f2ef4265d0f.tar.gz timeline-a3c97f6fb6313da2e8c0fac0b4c08f2ef4265d0f.tar.bz2 timeline-a3c97f6fb6313da2e8c0fac0b4c08f2ef4265d0f.zip |
Merge pull request #161 from crupest/upgrade
Upgrade packages and split front end and back end.
Diffstat (limited to 'Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs')
-rw-r--r-- | Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs | 57 |
1 files changed, 0 insertions, 57 deletions
diff --git a/Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs b/Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs deleted file mode 100644 index c277fe39..00000000 --- a/Timeline/Migrations/20200618064936_TimelineAddModifiedTime.cs +++ /dev/null @@ -1,57 +0,0 @@ -using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-
-namespace Timeline.Migrations
-{
- public partial class TimelineAddModifiedTime : Migration
- {
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- var currentTime = new DateTimeToStringConverter().ConvertToProvider(DateTime.Now);
-
- 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,
- name_last_modified TEXT NOT NULL,
- description TEXT NULL,
- owner INTEGER NOT NULL,
- visibility INTEGER NOT NULL,
- create_time TEXT NOT NULL,
- last_modified 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, unique_id, name, name_last_modified, description, owner, visibility, create_time, last_modified, current_post_local_id)
- SELECT id, unique_id, name, '{currentTime}', description, owner, visibility, create_time, '{currentTime}', 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)
- {
-
- }
- }
-}
|