mirror of
https://github.com/jellyfin/jellyfin.git
synced 2026-07-16 05:43:54 +03:00
Investigate purpose of authentication.db #212
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @sparky8251 on GitHub (Jan 6, 2019).
This is part of #42 and #422.
This one is a bit complicated. It has 2 tables and 3 indicies.
The
Devicestable has 3 fields:Idwhich isTEXTand is the master key.CustomNamewhich isTEXTCapabilitieswhich isTEXTThe
Tokenstable has 11 fields:Idwhich isINTEGERand is the master key.AccessTokenwhich isTEXTDeviceIdwhich isTEXTAppNamewhich isTEXTAppVersionwhich isTEXTDeviceNamewhich isTEXTUserIdwhich isTEXTUserNamewhich isTEXTIsActivewhich isBITDateCreatedwhich isDATETIMEDateLastActivitywhich isDATETIMEAs for the indexes, looking at my DBs layout, its apparent that the tables should be joined into one rather than splitting them up and joining them. This will require code fixes to stop the joins and just directly query the DB.
Would like confirmation on my take for this DB before proceeding. I have lacking experience with DBs.
@stale[bot] commented on GitHub (Jul 30, 2019):
Issues go stale after 60d of inactivity. Mark the issue as fresh by adding a comment or commit. Stale issues close after an additional 7d of inactivity. If this issue is safe to close now please do so. If you have any questions you can reach us on Matrix or Social Media.