diff options
| author | crupest <crupest@outlook.com> | 2020-06-14 14:21:44 +0800 |
|---|---|---|
| committer | crupest <crupest@outlook.com> | 2020-06-14 14:21:44 +0800 |
| commit | 5d467d950fd4078146709470084cbfae331b8b10 (patch) | |
| tree | 04068a987a6edce803d99e8e110509436604f70d /Timeline/Migrations | |
| parent | 7ed5306c62262921264bf9c83e00a4c9f3ae33b1 (diff) | |
| download | timeline-5d467d950fd4078146709470084cbfae331b8b10.tar.gz timeline-5d467d950fd4078146709470084cbfae331b8b10.tar.bz2 timeline-5d467d950fd4078146709470084cbfae331b8b10.zip | |
refactor(back): No longer use standard guid but just use 32-length hex for unique id of timeline.
Diffstat (limited to 'Timeline/Migrations')
| -rw-r--r-- | Timeline/Migrations/20200614061237_AddTimelineUniqueId.Designer.cs (renamed from Timeline/Migrations/20200613161127_AddTimelineUniqueId.Designer.cs) | 9 | ||||
| -rw-r--r-- | Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs (renamed from Timeline/Migrations/20200613161127_AddTimelineUniqueId.cs) | 7 | ||||
| -rw-r--r-- | Timeline/Migrations/DatabaseContextModelSnapshot.cs | 7 |
3 files changed, 12 insertions, 11 deletions
diff --git a/Timeline/Migrations/20200613161127_AddTimelineUniqueId.Designer.cs b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.Designer.cs index 4a8da5fd..adcc6308 100644 --- a/Timeline/Migrations/20200613161127_AddTimelineUniqueId.Designer.cs +++ b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.Designer.cs @@ -9,7 +9,7 @@ using Timeline.Entities; namespace Timeline.Migrations
{
[DbContext(typeof(DatabaseContext))]
- [Migration("20200613161127_AddTimelineUniqueId")]
+ [Migration("20200614061237_AddTimelineUniqueId")]
partial class AddTimelineUniqueId
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
@@ -91,11 +91,12 @@ namespace Timeline.Migrations .HasColumnName("owner")
.HasColumnType("INTEGER");
- b.Property<Guid>("UniqueId")
+ b.Property<string>("UniqueId")
+ .IsRequired()
.ValueGeneratedOnAdd()
.HasColumnName("unique_id")
- .HasColumnType("BLOB")
- .HasDefaultValueSql("randomblob(16)");
+ .HasColumnType("TEXT")
+ .HasDefaultValueSql("lower(hex(randomblob(16)))");
b.Property<int>("Visibility")
.HasColumnName("visibility")
diff --git a/Timeline/Migrations/20200613161127_AddTimelineUniqueId.cs b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs index badd33ea..80e90dbf 100644 --- a/Timeline/Migrations/20200613161127_AddTimelineUniqueId.cs +++ b/Timeline/Migrations/20200614061237_AddTimelineUniqueId.cs @@ -1,5 +1,4 @@ -using System;
-using Microsoft.EntityFrameworkCore.Migrations;
+using Microsoft.EntityFrameworkCore.Migrations;
namespace Timeline.Migrations
{
@@ -13,7 +12,7 @@ ALTER TABLE timelines RENAME TO timelines_backup; CREATE TABLE timelines (
id INTEGER NOT NULL CONSTRAINT PK_timelines PRIMARY KEY AUTOINCREMENT,
- unique_id BLOB NOT NULL DEFAULT (randomblob(16)),
+ unique_id TEXT NOT NULL DEFAULT (lower(hex(randomblob(16)))),
name TEXT NULL,
description TEXT NULL,
owner INTEGER NOT NULL,
@@ -27,7 +26,7 @@ INSERT INTO timelines (id, name, description, owner, visibility, create_time) DROP TABLE timelines_backup;
"
- );
+ );
}
protected override void Down(MigrationBuilder migrationBuilder)
diff --git a/Timeline/Migrations/DatabaseContextModelSnapshot.cs b/Timeline/Migrations/DatabaseContextModelSnapshot.cs index 111ae9c2..ea0b58c6 100644 --- a/Timeline/Migrations/DatabaseContextModelSnapshot.cs +++ b/Timeline/Migrations/DatabaseContextModelSnapshot.cs @@ -89,11 +89,12 @@ namespace Timeline.Migrations .HasColumnName("owner")
.HasColumnType("INTEGER");
- b.Property<Guid>("UniqueId")
+ b.Property<string>("UniqueId")
+ .IsRequired()
.ValueGeneratedOnAdd()
.HasColumnName("unique_id")
- .HasColumnType("BLOB")
- .HasDefaultValueSql("randomblob(16)");
+ .HasColumnType("TEXT")
+ .HasDefaultValueSql("lower(hex(randomblob(16)))");
b.Property<int>("Visibility")
.HasColumnName("visibility")
|