BreizhHardware/Jellystat
1
0
Fork 0
mirror of https://github.com/BreizhHardware/Jellystat.git synced 2026-01-18 16:27:20 +01:00
Code Issues Packages Projects Releases Wiki Activity
Files
main
Jellystat/backend/migrations
History
CyferShepard 6c15312bf6 updated migrations to account for migrations from unstable branch
2025-10-05 17:22:08 +02:00
..
001_app_config_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
002_jf_activity_watchdog_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
003_jf_libraries_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
004_jf_library_items_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
005_jf_library_seasons_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
006_jf_library_episodes_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
007_jf_playback_activity_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
008_js_users_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
009_jf_all_user_activity_view.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
010_jf_library_count_view.js
DB Migrations
2023-04-08 13:07:23 +02:00
011_js_library_stats_overview_view.js
DB Migrations
2023-04-08 13:07:23 +02:00
012_fs_last_library_activity_function.js
DB Migrations
2023-04-08 13:07:23 +02:00
013_fs_last_user_activity_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
014_fs_library_stats_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
015_fs_most_active_user_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
016_fs_most_played_items_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
017_fs_most_popular_items_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
018_fs_most_used_clients_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
019_fs_most_viewed_libraries_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
020_fs_user_stats_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
021_fs_watch_stats_over_time_functions.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
022_fs_watch_stats_popular_days_of_week_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
023_fs_watch_stats_popular_hour_of_day_function,js.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
024_jf_item_info_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
025_fs_last_library_activity_function.js
fixed migration sequence
2023-04-16 20:55:05 +02:00
026_fs_last_user_activity_function.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
027_js_library_metadata_view.js
fixed migration sequence
2023-04-16 20:55:05 +02:00
028_jf_playback_reporting_plugin_data_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
029_jf_all_user_activity_view.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
030_jf_logging_table.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
031_jd_remove_orphaned_data.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
032_app_config_table_add_auth_flag.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
033_js_library_stats_overview_view.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
034_jf_libraries_table_add_stat_columns.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
035_ju_update_library_stats_data.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
036_js_library_stats_overview_view.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
037_jf_library_items_with_playcount_playtime.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
038_jf_playback_activity_add_stream_data_columns.js
Update 038_jf_playback_activity_add_stream_data_columns.js
2023-06-18 22:21:49 +02:00
039_jf_activity_watchdog_add_stream_data_columns.js
v1.0.4.10 Beta
2023-06-18 21:02:18 +02:00
040_app_config_add_general_settings_column.js
Code clean-up + API Keys
2023-07-01 22:52:19 +02:00
041_js_library_stats_overview_view_optimizations.js
backend changes to improve sync
2023-06-24 23:56:58 +02:00
042_app_config_add_api_keys_column.js
Code clean-up + API Keys
2023-07-01 22:52:19 +02:00
043_jf_playback_activity_add_serverid_column.js
Playback Reporting Plugin
2023-07-09 01:23:57 +02:00
044_jf_activity_watchdog_add_serverid_column.js
Playback Reporting Plugin
2023-07-09 01:23:57 +02:00
045_ji_insert_playback_plugin_data_to_activity_table.js
Playback Reporting Plugin
2023-07-09 01:23:57 +02:00
046_jf_library_items_table_add_archived_column.js
added archiving feature to libraries
2023-11-20 10:59:12 +02:00
047_jf_library_items_with_playcount_playtime.js
Sync Changes
2023-11-19 22:17:36 +02:00
048_fs_last_user_activity.js
Sync Changes
2023-11-19 22:17:36 +02:00
049_fs_last_library_activity.js
Sync Changes
2023-11-19 22:17:36 +02:00
050_fs_most_played_items.js
Sync Changes
2023-11-19 22:17:36 +02:00
051_fs_most_popular_items.js
Sync Changes
2023-11-19 22:17:36 +02:00
052_jf_libraries_table_add_archived_column.js
added archiving feature to libraries
2023-11-20 10:59:12 +02:00
053_js_library_stats_overview.js
added archiving feature to libraries
2023-11-20 10:59:12 +02:00
054_jf_library_episodes_table_add_archived_column.js
Fix for incorrect stat count
2023-11-26 20:06:33 +02:00
055_jf_library_seasons_table_add_archived_column.js
Fix for incorrect stat count
2023-11-26 20:06:33 +02:00
056_js_library_metadata.js
Fix for incorrect stat count
2023-11-26 20:06:33 +02:00
057_jf_library_count_view.js
Fix for incorrect stat count
2023-11-26 20:06:33 +02:00
058_jf_recent_playback_activity_function.js
Playback tracking rework
2024-01-08 09:03:40 +02:00
059_jf_recent_playback_activity_function_fix.js
Playback tracking fix
2024-01-08 11:54:17 +02:00
060_jf_recent_playback_activity_function_fix_2.js
Logic fix for percentage in jf_recent_playback_activity
2024-01-08 18:36:38 +02:00
061_jf_recent_playback_activity_function_fix_3.js
Playback tracking fix 3
2024-01-11 10:57:03 +02:00
062_jf_library_items_with_playcount_playtime_added_size.js
Add sorting option for Size in LibraryItems component
2024-02-27 12:16:36 +02:00
063_fs_last_user_activity_fix_1.js
Fix sorting in last user activity view
2024-02-29 11:03:35 +02:00
064_app_config_remove_default_identity.js
bug fix for signup process resulting in multiple config rows and getting stuck on step 2/2
2024-03-09 17:48:45 +02:00
065_ji_insert_playback_plugin_data_to_activity_table_fixes.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
066_jf_item_info_add_date_created.js
added DateCreated field
2024-03-30 13:28:57 +02:00
067_jf_library_items_with_playcount_playtime_added_date_created.js
added DateCreated field
2024-03-30 13:28:57 +02:00
068_ji_insert_playback_plugin_data_to_activity_table_fixes_2.js
Allow overriding owner of tables during migrations
2024-09-24 23:21:22 -07:00
069_jf_recent_playback_activity_function_fix_4.js
fixes to prevent updating existing records with playback greater than item duration
2024-04-07 16:54:24 +02:00
070_jf_playback_activity_add_unique_constraint.js
Fix to address multiple insert issue #183
2024-04-30 13:57:53 +02:00
071_jf_watchdog_table_add_activity_id_field.js
Fix to address multiple insert issue #183
2024-04-30 13:57:53 +02:00
072_jf_library_episodes_add_primaty_image_hash.js
Changes to Recently Added Items
2024-05-24 18:53:41 +02:00
073_fs_watch_stats_over_time_exclude_archived_libraries.js
#258 exclude archived libraries from stats on Statistics endpoint. When library is untracked, after a full sync, the library is archived
2024-10-20 18:09:25 +02:00
074_fs_watch_stats_popular_days_of_week_exclude_archived_libraries.js
#258 exclude archived libraries from stats on Statistics endpoint. When library is untracked, after a full sync, the library is archived
2024-10-20 18:09:25 +02:00
075_fs_watch_stats_popular_hour_of_day_exclude_archived_libraries.js
#258 exclude archived libraries from stats on Statistics endpoint. When library is untracked, after a full sync, the library is archived
2024-10-20 18:09:25 +02:00
076_fs_user_stats_fixed_hours_range.js
minor correction to sql script #263
2024-11-24 16:06:05 +02:00
077_jf_recent_playback_activity_fix_devide_by_zero.js
fix for #267 devide by 0 error
2024-11-24 16:51:28 +02:00
078_refactor_fs_user_stats.js
fix for #263, default value for no activity on fs_user_stats
2024-12-03 09:33:06 +02:00
079_create_view_jf_playback_activity_with_metadata.js
changed grouping to be perfomed on sql to present more accurate data in tables.
2025-01-02 20:32:39 +02:00
080_js_latest_playback_activity.js
changed grouping to be perfomed on sql to present more accurate data in tables.
2025-01-02 20:32:39 +02:00
081_create_trigger_refresh_function_js_latest_playback_activity.js
changed grouping to be perfomed on sql to present more accurate data in tables.
2025-01-02 20:32:39 +02:00
082_create_trigger_refresh_js_latest_playback_activity.js
changed grouping to be perfomed on sql to present more accurate data in tables.
2025-01-02 20:32:39 +02:00
083_create_materialized_view_js_library_stats_overview.js
convert js_library_stats_overview to material view to reduce load times
2025-01-02 23:02:17 +02:00
084_create_trigger_refresh_function_js_library_stats_overview.js
convert js_library_stats_overview to material view to reduce load times
2025-01-02 23:02:17 +02:00
085_create_trigger_refresh_js_library_stats_overview.js
convert js_library_stats_overview to material view to reduce load times
2025-01-02 23:02:17 +02:00
086_drop_all_refresh_triggers_on_activity_table.js
optimized materialized view for possible duplication bug with activity having the same activity date
2025-01-03 20:38:33 +02:00
087_optimize_js_latest_playback_activity.js
optimized materialized view for possible duplication bug with activity having the same activity date
2025-01-03 20:38:33 +02:00
088_optimize_materialized_view_js_library_stats_overview.js
optimized materialized view for possible duplication bug with activity having the same activity date
2025-01-03 20:38:33 +02:00
089_optimize_materialized_view_js_library_stats_overview_last_activity.js
fix for Last Activity not updating in library view due to materialized view being static
2025-01-03 20:50:59 +02:00
090_create_function_fs_get_user_activity.js
Activity timeline improvements:
2025-01-20 07:50:01 +00:00
091_fix_function_fs_get_user_activity.js
add migration to fix and enhance fs_get_user_activity function
2025-02-02 17:04:06 +02:00
092_fix_function_fs_get_user_activity_interrupt_groups_properly.js
Timeline: Improvement - start a new group if a series is interrupted by another activity
2025-02-03 08:29:42 +01:00
093_ji_insert_playback_plugin_data_to_activity_table_EpisodeID_Fix.js
fix for #249
2025-03-07 23:14:59 +02:00
094_jf_library_items_table_add_genres.js
Added Genre stats to users page #292
2025-03-30 17:33:58 +02:00
095_fs_watch_stats_over_time_include_duration.js
updated migrations to account for migrations from unstable branch
2025-10-05 17:22:08 +02:00
096_fs_watch_stats_popular_days_of_week_include_duration.js
updated migrations to account for migrations from unstable branch
2025-10-05 17:22:08 +02:00
097_fs_watch_stats_popular_hour_of_day_include_duration.js
updated migrations to account for migrations from unstable branch
2025-10-05 17:22:08 +02:00
098_create_webhooks_table.js
updated migrations to account for migrations from unstable branch
2025-10-05 17:22:08 +02:00