2 files changed, 14 insertions, 1 deletions
diff --git a/Timeline/Entities/DatabaseContext.cs b/Timeline/Entities/DatabaseContext.cs
index 50648fb6..ba2566bd 100644
--- a/Timeline/Entities/DatabaseContext.cs
+++ b/Timeline/Entities/DatabaseContext.cs
@@ -14,6 +14,9 @@ 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<UserEntity>().Property(e => e.UsernameChangeTime).HasDefaultValueSql("datetime('now', 'utc')");
+            modelBuilder.Entity<UserEntity>().Property(e => e.CreateTime).HasDefaultValueSql("datetime('now', 'utc')");
+            modelBuilder.Entity<UserEntity>().Property(e => e.LastModified).HasDefaultValueSql("datetime('now', 'utc')");
             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 07b19d62..d6b55ab6 100644
--- a/Timeline/Entities/UserEntity.cs
+++ b/Timeline/Entities/UserEntity.cs
@@ -1,4 +1,5 @@
-using System.Collections.Generic;
+using System;
+using System.Collections.Generic;
 using System.ComponentModel.DataAnnotations;
 using System.ComponentModel.DataAnnotations.Schema;
 
@@ -23,6 +24,9 @@ namespace Timeline.Entities
         [Column("username"), Required]
         public string Username { get; set; } = default!;
 
+        [Column("username_change_time")]
+        public DateTimeOffset UsernameChangeTime { get; set; }
+
         [Column("password"), Required]
         public string Password { get; set; } = default!;
 
@@ -35,6 +39,12 @@ namespace Timeline.Entities
         [Column("nickname")]
         public string? Nickname { get; set; }
 
+        [Column("create_time")]
+        public DateTimeOffset CreateTime { get; set; }
+
+        [Column("last_modified")]
+        public DateTimeOffset LastModified { get; set; }
+
         public UserAvatarEntity? Avatar { get; set; }
 
         public List<TimelineEntity> Timelines { get; set; } = default!;