From 5d467d950fd4078146709470084cbfae331b8b10 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Sun, 14 Jun 2020 14:21:44 +0800
Subject: refactor(back): No longer use standard guid but just use 32-length
 hex for unique id of timeline.

---
 Timeline/Entities/DatabaseContext.cs | 2 +-
 Timeline/Entities/TimelineEntity.cs  | 4 ++--
 2 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'Timeline/Entities')

diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
index 136dc442..acb80742 100644
--- a/Timeline/Entities/DatabaseContext.cs
+++ b/Timeline/Entities/DatabaseContext.cs
@@ -14,7 +14,7 @@ namespace Timeline.Entities
             modelBuilder.Entity<UserEntity>().Property(e => e.Version).HasDefaultValue(0);
             modelBuilder.Entity<UserEntity>().HasIndex(e => e.Username).IsUnique();
             modelBuilder.Entity<DataEntity>().HasIndex(e => e.Tag).IsUnique();
-            modelBuilder.Entity<TimelineEntity>().Property(e => e.UniqueId).HasDefaultValueSql("randomblob(16)");
+            modelBuilder.Entity<TimelineEntity>().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))");
         }
 
         public DbSet<UserEntity> Users { get; set; } = default!;
diff --git a/Timeline/Entities/TimelineEntity.cs b/Timeline/Entities/TimelineEntity.cs
index 4a4e8502..1159cbfe 100644
--- a/Timeline/Entities/TimelineEntity.cs
+++ b/Timeline/Entities/TimelineEntity.cs
@@ -14,8 +14,8 @@ namespace Timeline.Entities
         [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
         public long Id { get; set; }
 
-        [Column("unique_id", TypeName = "BLOB"), Required]
-        public Guid UniqueId { get; set; } = default!;
+        [Column("unique_id"), Required]
+        public string UniqueId { get; set; } = default!;
 
         /// <summary>
         /// If null, then this timeline is a personal timeline.
-- 
cgit v1.2.3