From 49e464705c7dbd33feff3facbc17aae3a8cb1b53 Mon Sep 17 00:00:00 2001 From: crupest Date: Tue, 11 Aug 2020 00:06:11 +0800 Subject: Add time columns to user in database. --- Timeline/Entities/DatabaseContext.cs | 3 +++ 1 file changed, 3 insertions(+) (limited to 'Timeline/Entities/DatabaseContext.cs') 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().Property(e => e.Version).HasDefaultValue(0); modelBuilder.Entity().HasIndex(e => e.Username).IsUnique(); modelBuilder.Entity().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))"); + modelBuilder.Entity().Property(e => e.UsernameChangeTime).HasDefaultValueSql("datetime('now', 'utc')"); + modelBuilder.Entity().Property(e => e.CreateTime).HasDefaultValueSql("datetime('now', 'utc')"); + modelBuilder.Entity().Property(e => e.LastModified).HasDefaultValueSql("datetime('now', 'utc')"); modelBuilder.Entity().HasIndex(e => e.Tag).IsUnique(); modelBuilder.Entity().Property(e => e.UniqueId).HasDefaultValueSql("lower(hex(randomblob(16)))"); } -- cgit v1.2.3