From 105444ff90af277c84edbdc6824cdd412c1f348a Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Sat, 8 Aug 2020 15:22:44 +0800
Subject: Database add unqiue id for user.

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

(limited to 'Timeline/Entities')

diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
index acb80742..50648fb6 100644
--- a/Timeline/Entities/DatabaseContext.cs
+++ b/Timeline/Entities/DatabaseContext.cs
@@ -13,6 +13,7 @@ namespace Timeline.Entities
         {
             modelBuilder.Entity<UserEntity>().Property(e => e.Version).HasDefaultValue(0);
             modelBuilder.Entity<UserEntity>().HasIndex(e => e.Username).IsUnique();
+            modelBuilder.Entity<UserEntity>().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))");
             modelBuilder.Entity<DataEntity>().HasIndex(e => e.Tag).IsUnique();
             modelBuilder.Entity<TimelineEntity>().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))");
         }
diff --git a/Timeline/Entities/UserEntity.cs b/Timeline/Entities/UserEntity.cs
index 1ef3f98c..07b19d62 100644
--- a/Timeline/Entities/UserEntity.cs
+++ b/Timeline/Entities/UserEntity.cs
@@ -17,6 +17,9 @@ namespace Timeline.Entities
         [Column("id"), Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
         public long Id { get; set; }
 
+        [Column("unique_id"), Required]
+        public string UniqueId { get; set; } = default!;
+
         [Column("username"), Required]
         public string Username { get; set; } = default!;
 
-- 
cgit v1.2.3