Gallery media is now filtered by tag using Object IDs rather than Guids, signficantly reducing DB overhead

1 files changed, 5 insertions, 2 deletions

diff --git a/HBContext.cs b/HBContext.cs
index d0cd26f..f6bc15c 100644
--- a/HBContext.cs
+++ b/HBContext.cs
@@ -4,6 +4,9 @@ using HyperBooru.Services;
 namespace HyperBooru;
 
 public class HBContext : DbContext {
+    public const int NsfwTagId   = -1;
+    public const int IngestTagId = -2;
+
     public static readonly Guid NsfwTag   = new("EBDAD4F8-455A-4351-8017-1D4854D6FA38");
     public static readonly Guid IngestTag = new("EA212801-5BCC-4C0E-814F-FB9D30DB58BC");
 
@@ -38,13 +41,13 @@ public class HBContext : DbContext {
         // These should NEVER change
         modelBuilder.Entity<TagDefinition>().HasData(new TagDefinition[] {
             new() {
-                ObjectId = -1,
+                ObjectId = NsfwTagId,
                 Guid     = NsfwTag,
                 Source   = TagSource.Internal,
                 Name     = "nsfw"
             },
             new() {
-                ObjectId = -2,
+                ObjectId = IngestTagId,
                 Guid     = IngestTag,
                 Source   = TagSource.Internal,
                 Name     = "ingest"