Update C# db models

4 files changed, 20 insertions, 4 deletions

diff --git a/extra/admin-api/Models/Spacebar.Models.Db/Contexts/SpacebarDbContext.cs b/extra/admin-api/Models/Spacebar.Models.Db/Contexts/SpacebarDbContext.cs

index a9f47c8d..6ed0a319 100644
--- a/extra/admin-api/Models/Spacebar.Models.Db/Contexts/SpacebarDbContext.cs
+++ b/extra/admin-api/Models/Spacebar.Models.Db/Contexts/SpacebarDbContext.cs
@@ -294,7 +294,13 @@ public partial class SpacebarDbContext : DbContext
 
             entity.Property(e => e.Id).ValueGeneratedNever();
 
-            entity.HasOne(d => d.Guild).WithMany(p => p.Emojis).HasConstraintName("FK_4b988e0db89d94cebcf07f598cc");
+            entity.HasOne(d => d.Application).WithMany(p => p.Emojis)
+                .OnDelete(DeleteBehavior.Cascade)
+                .HasConstraintName("FK_emoji_application_id");
+
+            entity.HasOne(d => d.Guild).WithMany(p => p.Emojis)
+                .OnDelete(DeleteBehavior.Cascade)
+                .HasConstraintName("FK_emoji_guild_id");
 
             entity.HasOne(d => d.User).WithMany(p => p.Emojis).HasConstraintName("FK_fa7ddd5f9a214e28ce596548421");
         });
diff --git a/extra/admin-api/Models/Spacebar.Models.Db/Models/Application.cs b/extra/admin-api/Models/Spacebar.Models.Db/Models/Application.cs

index 9ee3811f..7f19b57a 100644
--- a/extra/admin-api/Models/Spacebar.Models.Db/Models/Application.cs
+++ b/extra/admin-api/Models/Spacebar.Models.Db/Models/Application.cs
@@ -108,6 +108,9 @@ public partial class Application
     [InverseProperty("ApplicationBotUser")]
     public virtual User? BotUser { get; set; }
 
+    [InverseProperty("Application")]
+    public virtual ICollection<Emoji> Emojis { get; set; } = new List<Emoji>();
+
     [ForeignKey("GuildId")]
     [InverseProperty("Applications")]
     public virtual Guild? Guild { get; set; }
diff --git a/extra/admin-api/Models/Spacebar.Models.Db/Models/Emoji.cs b/extra/admin-api/Models/Spacebar.Models.Db/Models/Emoji.cs

index 04b0ae03..17823714 100644
--- a/extra/admin-api/Models/Spacebar.Models.Db/Models/Emoji.cs
+++ b/extra/admin-api/Models/Spacebar.Models.Db/Models/Emoji.cs
@@ -20,7 +20,7 @@ public partial class Emoji
     public bool Available { get; set; }
 
     [Column("guild_id")]
-    public long GuildId { get; set; }
+    public long? GuildId { get; set; }
 
     [Column("user_id")]
     public long? UserId { get; set; }
@@ -40,9 +40,16 @@ public partial class Emoji
     [Column("groups")]
     public List<long>? Groups { get; set; }
 
+    [Column("application_id")]
+    public long? ApplicationId { get; set; }
+
+    [ForeignKey("ApplicationId")]
+    [InverseProperty("Emojis")]
+    public virtual Application? Application { get; set; }
+
     [ForeignKey("GuildId")]
     [InverseProperty("Emojis")]
-    public virtual Guild Guild { get; set; } = null!;
+    public virtual Guild? Guild { get; set; }
 
     [ForeignKey("UserId")]
     [InverseProperty("Emojis")]
diff --git a/extra/admin-api/Models/Spacebar.Models.Db/Spacebar.Models.Db.csproj b/extra/admin-api/Models/Spacebar.Models.Db/Spacebar.Models.Db.csproj

index 80995e58..40a53a10 100644
--- a/extra/admin-api/Models/Spacebar.Models.Db/Spacebar.Models.Db.csproj
+++ b/extra/admin-api/Models/Spacebar.Models.Db/Spacebar.Models.Db.csproj
@@ -1,4 +1,4 @@
-<Project Sdk="Microsoft.NET.Sdk">
+<Project Sdk="Microsoft.NET.Sdk">
 
   <PropertyGroup>
     <TargetFramework>net10.0</TargetFramework>