37 commits

Author	SHA1	Message	Date
mikiher	40504da4d7	Improve book library page query performance for author sort order (#4080) ... * Add migration to create authorNames* columns, in libraryItems including update triggers and indices * Add authorNames columns and indices to LibraryItem model * Add database triggers for updating author names in libraryItems (for new databases) * Populate authorNames during book scanning * Update book sorting to use new authorNames columns * Add an index on podcastEpisodes.publishedAt * Fix group_concat order by and update to sqlite 3.44.2 --------- Co-authored-by: advplyr <advplyr@protonmail.com>	2025-03-17 17:09:49 -05:00
mikiher	568bf0254d	Change migration version to v2.19.4	2025-02-18 07:57:46 +02:00
mikiher	23a750214f	Add migration in preparation for podcast query optimization	2025-02-16 08:35:51 +02:00
mikiher	4cc300d6e9	Update changelog with v2.19.1 migration	2025-02-09 21:39:43 +02:00
advplyr	ef45f844e5	Update upwards migration to be idempotent	2025-02-08 12:37:34 -06:00
mikiher	a13143245b	Improve page load queries on title, titleIgnorePrefix, and addedAt sort order	2025-02-08 12:29:23 +02:00
mikiher	46247ecf78	Update migrations changelog	2025-01-01 08:41:27 +02:00
mikiher	0444829a9f	Add index on duration	2025-01-01 08:37:57 +02:00
mikiher	754c121168	Add libraryItem size index	2025-01-01 07:34:29 +02:00
Greg Lorenzen	4cdc2a8c28	Feat/download via share link (#3666) ... * Adds share download endpoint * Adds Downloadable toggle to share modal --------- Co-authored-by: advplyr <advplyr@protonmail.com>	2024-12-29 16:52:57 -06:00
advplyr	f7b7b85673	Add v2.17.5 migration to changelog	2024-12-08 08:19:23 -06:00
mikiher	9b8e059efe	Remove serverAddress from Feeds and FeedEpisodes URLs	2024-12-07 19:27:37 +02:00
advplyr	33aa4f1952	Merge master	2024-12-01 13:27:20 -06:00
advplyr	4b52f31d58	Update v2.17.3 migration file to first check if constraints need to be updated, add unit test	2024-11-30 15:48:20 -06:00
mikiher	9917f2d358	Change migration to v2.17.4	2024-11-29 09:01:03 +02:00
mikiher	6d8720b404	Subfolder support for OIDC auth	2024-11-29 04:28:50 +02:00
advplyr	70f466d03c	Add migration for v2.17.3 to fix dropped fk constraints	2024-11-28 17:18:34 -06:00
advplyr	ff026a06bb	Fix v2.17.0 migration to ensure mediaItemShares table exists	2024-11-20 16:48:09 -06:00
advplyr	2b7e3f0efe	Update uuid migration to v2.17.0 and for all tables still using UUIDv4	2024-11-17 15:45:21 -06:00
Nicholas Wallace	161a3f4da9	Update migrations changelog for 2.16.3	2024-11-09 13:20:59 -07:00
Nicholas Wallace	713bdcbc41	Add: migration for mediaId to use UUID instead of UUIDV4	2024-11-09 13:10:46 -07:00
advplyr	35e2681ea9	Update index creation migration to be idempotent	2024-10-19 15:45:14 -05:00
Nicholas Wallace	84012d9090	Fix: podcast episode index name	2024-10-19 11:38:34 -07:00
Nicholas Wallace	e8a1ea3b54	Fix: table naming	2024-10-19 11:20:29 -07:00
Nicholas Wallace	ea6882d9ab	Update changelog	2024-10-19 11:20:22 -07:00
Nicholas Wallace	1fa80e31d1	Add: migrations for authors, series, and podcast episodes	2024-10-19 10:40:17 -07:00
mikiher	50797879d5	Add a REINDEX NOCASE v2.15.1 migration and update v2.15.0 migration (#3533) ... * Add REINDEX NOCASE migration and update v2.15.0 migration * Update v2.15.0 migration test * Fix typo	2024-10-18 16:10:29 -05:00
Nicholas Wallace	e6e494a92c	Rename for next minor release	2024-10-07 18:52:14 -07:00
advplyr	5154e31c1c	Update migration to v2.14.0	2024-09-24 17:06:00 -05:00
advplyr	8a7b5cc87d	Ensure series-column-unique migration is idempotent	2024-09-24 16:47:09 -05:00
Nicholas Wallace	66b290577c	Clean up unused parts of statement	2024-09-17 20:00:06 -07:00
Nicholas Wallace	691ed88096	Add more logging, clean up typo	2024-09-14 15:34:38 -07:00
Nicholas Wallace	836d772cd4	Update: remove the same book if occurs multiple times in duplicate series	2024-09-14 15:23:29 -07:00
Nicholas Wallace	c163f84aec	Update migration changelog for series name unique	2024-09-13 17:01:48 -07:00
Nicholas Wallace	2711b989e1	Add: series migration to be unique	2024-09-13 16:55:48 -07:00
mikiher	8a28029809	Make migration management more robust	2024-09-07 22:24:19 +03:00
mikiher	3f93b93d9e	Add db migration management infratructure	2024-09-04 12:48:10 +03:00