From ac769e656b122ff569c3f1534701b71e00fed586 Mon Sep 17 00:00:00 2001
From: crupest <crupest@outlook.com>
Date: Tue, 27 Oct 2020 19:21:35 +0800
Subject: Split front and back end.

---
 BackEnd/Timeline/Entities/DatabaseContext.cs | 34 ++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)
 create mode 100644 BackEnd/Timeline/Entities/DatabaseContext.cs

(limited to 'BackEnd/Timeline/Entities/DatabaseContext.cs')

diff --git a/BackEnd/Timeline/Entities/DatabaseContext.cs b/BackEnd/Timeline/Entities/DatabaseContext.cs
new file mode 100644
index 00000000..ecadd703
--- /dev/null
+++ b/BackEnd/Timeline/Entities/DatabaseContext.cs
@@ -0,0 +1,34 @@
+using Microsoft.EntityFrameworkCore;
+
+namespace Timeline.Entities
+{
+    public class DatabaseContext : DbContext
+    {
+        public DatabaseContext(DbContextOptions<DatabaseContext> options)
+            : base(options)
+        {
+        }
+
+        protected override void OnModelCreating(ModelBuilder modelBuilder)
+        {
+            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)))");
+
+            modelBuilder.ApplyUtcDateTimeConverter();
+        }
+
+        public DbSet<UserEntity> Users { get; set; } = default!;
+        public DbSet<UserAvatarEntity> UserAvatars { get; set; } = default!;
+        public DbSet<TimelineEntity> Timelines { get; set; } = default!;
+        public DbSet<TimelinePostEntity> TimelinePosts { get; set; } = default!;
+        public DbSet<TimelineMemberEntity> TimelineMembers { get; set; } = default!;
+        public DbSet<JwtTokenEntity> JwtToken { get; set; } = default!;
+        public DbSet<DataEntity> Data { get; set; } = default!;
+    }
+}
-- 
cgit v1.2.3