summary refs log tree commit diff
path: root/extra/admin-api/Spacebar.Db/Models
diff options
context:
space:
mode:
Diffstat (limited to 'extra/admin-api/Spacebar.Db/Models')
-rw-r--r--extra/admin-api/Spacebar.Db/Models/Message.cs3
-rw-r--r--extra/admin-api/Spacebar.Db/Models/Session.cs31
-rw-r--r--extra/admin-api/Spacebar.Db/Models/User.cs7
3 files changed, 30 insertions, 11 deletions
diff --git a/extra/admin-api/Spacebar.Db/Models/Message.cs b/extra/admin-api/Spacebar.Db/Models/Message.cs

index 11cee738..b9260a4d 100644 --- a/extra/admin-api/Spacebar.Db/Models/Message.cs +++ b/extra/admin-api/Spacebar.Db/Models/Message.cs
@@ -94,6 +94,9 @@ public partial class Message [Column("interaction_metadata")] public string? InteractionMetadata { get; set; } + [Column("message_snapshots")] + public string MessageSnapshots { get; set; } = null!; + [ForeignKey("ApplicationId")] [InverseProperty("Messages")] public virtual Application? Application { get; set; } diff --git a/extra/admin-api/Spacebar.Db/Models/Session.cs b/extra/admin-api/Spacebar.Db/Models/Session.cs
index f7eda3cf..0a342ad8 100644 --- a/extra/admin-api/Spacebar.Db/Models/Session.cs +++ b/extra/admin-api/Spacebar.Db/Models/Session.cs
@@ -7,15 +7,13 @@ using Microsoft.EntityFrameworkCore; namespace Spacebar.Db.Models; [Table("sessions")] +[Index("UserId", Name = "IDX_085d540d9f418cfbdc7bd55bb1")] public partial class Session { - [Key] - [Column("id", TypeName = "character varying")] - public string Id { get; set; } = null!; - [Column("user_id", TypeName = "character varying")] - public string? UserId { get; set; } + public string UserId { get; set; } = null!; + [Key] [Column("session_id", TypeName = "character varying")] public string SessionId { get; set; } = null!; @@ -31,7 +29,28 @@ public partial class Session [Column("client_status")] public string ClientStatus { get; set; } = null!; + [Column("is_admin_session")] + public bool IsAdminSession { get; set; } + + [Column("created_at", TypeName = "timestamp without time zone")] + public DateTime CreatedAt { get; set; } + + [Column("last_seen", TypeName = "timestamp without time zone")] + public DateTime? LastSeen { get; set; } + + [Column("last_seen_ip", TypeName = "character varying")] + public string? LastSeenIp { get; set; } + + [Column("last_seen_location", TypeName = "character varying")] + public string? LastSeenLocation { get; set; } + + [Column("last_seen_location_info")] + public string? LastSeenLocationInfo { get; set; } + + [Column("session_nickname", TypeName = "character varying")] + public string? SessionNickname { get; set; } + [ForeignKey("UserId")] [InverseProperty("Sessions")] - public virtual User? User { get; set; } + public virtual User User { get; set; } = null!; } diff --git a/extra/admin-api/Spacebar.Db/Models/User.cs b/extra/admin-api/Spacebar.Db/Models/User.cs
index 323846d4..f8211ec1 100644 --- a/extra/admin-api/Spacebar.Db/Models/User.cs +++ b/extra/admin-api/Spacebar.Db/Models/User.cs
@@ -89,14 +89,14 @@ public partial class User [Column("email", TypeName = "character varying")] public string? Email { get; set; } - [Column("flags")] + [Column("flags", TypeName = "character varying")] public ulong Flags { get; set; } [Column("public_flags")] public ulong PublicFlags { get; set; } [Column("purchased_flags")] - public ulong PurchasedFlags { get; set; } + public long PurchasedFlags { get; set; } [Column("premium_usage_flags")] public int PremiumUsageFlags { get; set; } @@ -110,9 +110,6 @@ public partial class User [Column("fingerprints")] public string Fingerprints { get; set; } = null!; - [Column("extended_settings")] - public string ExtendedSettings { get; set; } = null!; - [Column("settingsIndex")] public int? SettingsIndex { get; set; }