2024-04-03, 01:49 PM
root@mediasrv:~# docker exec -it 760a886b3738 bash
Code:
root@jellyfin-jellyfin1:/# cd /config
config/ configs/
root@jellyfin-jellyfin1:/# cd /configs/
root@jellyfin-jellyfin1:/configs# cd data/
root@jellyfin-jellyfin1:/configs/data# ls
device.txt jellyfin.db library.db library.db-journal playlists ScheduledTasks
root@jellyfin-jellyfin1:/configs/data#Code:
root@jellyfin-jellyfin1:/configs/data# sqlite3 jellyfin.db
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> .tables
AccessSchedules HomeSection
ActivityLogs ImageInfos
ApiKeys ItemDisplayPreferences
CustomItemDisplayPreferences Permissions
DeviceOptions Preferences
Devices Users
DisplayPreferences __EFMigrationsHistory
sqlite>Code:
sqlite> .mode markdown
sqlite> select * from Preferences
...> ;
| Id | Kind | Preference_Preferences_Guid | RowVersion | UserId | Value |
|----|------|-----------------------------|------------|--------------------------------------|-------|
| 1 | 0 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 2 | 1 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 3 | 2 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 4 | 3 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 5 | 4 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 6 | 5 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 7 | 6 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 8 | 7 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 9 | 8 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 10 | 9 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 11 | 10 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
| 12 | 11 | | 0 | 13655BD8-F1BA-45BE-9576-F4D8120E04A9 | |
sqlite>