Add time columns to user in database.

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!;