tom/HealthLog
1
0 Fork 0
mirror of https://github.com/MBombeck/HealthLog.git synced 2026-11-08 20:42:43 +00:00
Code Issues Packages Projects Releases Wiki Activity
Files
v1.18.7
HealthLog/prisma/migrations
T
History
Marc-André Bombeck ce684cc429 chore(db): renumber the share-link passphrase migration to 0180 
The status-batching work claimed no migration, so the passphrase column
takes 0180 and the sequence stays gapless after 0179.
2026-06-19 22:07:46 +02:00
..
0001_init
…
0002_roles_and_settings
…
0003_add_missing_columns
…
0004_add_audit_log_location
…
0005_notification_system
…
0006_medication_notifications_enabled
…
0007_medication_paused_at
…
0008_app_settings_bugreport_github
…
0009_app_settings_api_global
…
0010_app_settings_monitoring
…
0011_app_settings_web_push_vapid
…
0012_app_settings_reminder_thresholds
…
0013_medication_snoozed_until
…
0014_add_moodlog_integration
…
0015_add_reminder_phase_tracking
…
0016_telegram_scheduled_deletions
…
0017_add_data_backups
…
0018_add_user_achievements
…
0019_add_rate_limits
…
0020_codex_oauth_admin_ai
…
0021_v1_2_personalization_feedback_glucose
…
0022_body_composition_metrics
…
0023_ios_adapters_idempotency_devices
…
0024_oxygen_saturation
…
0025_refresh_tokens
…
0025_user_locale_drift_fix
…
0026_user_ai_openai_key
…
0027_bug_report_enabled_toggle
…
0028_notification_channel_reliability
…
0029_integration_status
…
0030_onboarding_tour_completed
…
0031_user_last_report_practice_name
…
0032_host_metric
…
0033_user_ai_provider_chain
…
0034_recommendation_feedback
…
0035_coach_conversations_v1420
…
0036_apple_health_measurement_types
…
0037_apns_device_columns
…
0038_coach_prefs
…
0039_medication_schedule_days_of_week
…
0040_recommendation_feedback_target_type
…
0041_apns_token_unique_partial
…
0042_coach_feedback_message_ref
…
0043_per_user_timezone
…
0044_mood_entry_tz_column
…
0045_doctor_report_prefs
…
0046_glp1_dose_history
…
0047_medication_schedule_window_snake_case
…
0048_user_source_priority
…
0049_withings_full_metrics
…
0050_withings_connection_scope
…
0051_measurement_device_type
…
0052_apple_health_enum_extensions
…
0053_workout_and_route
…
0054_personal_record
…
0055_measurement_sleepstage_composite
…
0056_medication_inventory_item
…
0057_user_onboarding_step
…
0058_user_research_mode
…
0059_medication_side_effect
…
0060_onboarding_step_not_null
…
0061_audit_log_carrier
…
0062_v1430_sync_mode_foundation
…
0063_mood_entry_note_column
…
0064_v1430_measurement_type_additions
…
0065_v1431_assistant_feature_flags
…
0066_v1434_import_jobs
…
0067_v1434_measurement_rollups
…
0068_v1436_insights_exclude_metrics
v1.4.36 — perf, charts, AI payload trim, UX punch
2026-05-17 13:22:51 +02:00
0069_v054_mood_reminder
feat(notifications): APNs category + MOOD_REMINDER event for iOS v0.5.4 (#190)
2026-05-17 23:08:17 +02:00
0070_v1439_mood_rollups
chore(release): v1.4.39 — mood, medication-compliance, and cumulative-sum rollup tiers
2026-05-21 07:39:10 +02:00
0071_v1439_medication_compliance_rollups
chore(release): v1.4.39 — mood, medication-compliance, and cumulative-sum rollup tiers
2026-05-21 07:39:10 +02:00
0072_v1439_rollup_sum_value
chore(release): v1.4.39 — mood, medication-compliance, and cumulative-sum rollup tiers
2026-05-21 07:39:10 +02:00
0073_v1439_medication_intake_unique_per_source
chore(release): v1.4.39.4 — dashboard symmetry for daily-schedule intake projection
2026-05-21 11:20:24 +02:00
0074_v1440_consent_receipts
chore(release): v1.4.40 — comprehensive Critical+High architecture closure plus iOS PB30 enablement
2026-05-21 12:48:02 +02:00
0075_v1443_integration_park
chore(release): v1.4.45 — analytics 9 s perf fix + audit-marathon closure + v1.4.44 hotfix merged
2026-05-21 23:13:21 +02:00
0076_v1447_withings_oauth_state
chore(release): v1.4.47 — audit-backlog closure + drag-to-reorder + Coach disable + OAuth nonce ledger
2026-05-22 09:18:52 +02:00
0077_v1447_drop_legacy_consecutive_failures
chore(release): v1.4.47 — audit-backlog closure + drag-to-reorder + Coach disable + OAuth nonce ledger
2026-05-22 09:18:52 +02:00
0078_v1447_user_disable_coach
chore(release): v1.4.47 — audit-backlog closure + drag-to-reorder + Coach disable + OAuth nonce ledger
2026-05-22 09:18:52 +02:00
0079_v1449_user_notification_prefs
chore(release): v1.4.49 — audit-backlog closure + server reminder suppression + diagnostic endpoint + analytics cold-path fix
2026-05-23 12:51:41 +02:00
0080_v1449_push_attempts
chore(release): v1.4.49 — audit-backlog closure + server reminder suppression + diagnostic endpoint + analytics cold-path fix
2026-05-23 12:51:41 +02:00
0081_v15_medication_scheduling
feat(medications): v1.5 scheduling fields + backfill migration
2026-05-28 07:52:11 +02:00
0082_v154_clinical_category_diabetes_antibiotic
feat(meds): extend MedicationCategory with diabetes and antibiotic
2026-05-28 19:33:11 +02:00
0083_v155_ios_measurement_types
fix(measurements): wire the six deferred Apple Health identifiers
2026-05-28 22:32:18 +02:00
0084_v155_user_insights_layout
feat(insights): server-persist insights tile order + visibility
2026-05-28 22:32:40 +02:00
0085_v155_user_avatar
feat(avatar): self-hosted avatar storage replacing the Gravatar leak
2026-05-28 22:39:20 +02:00
0086_v155_ios_walking_step_length_speed
fix(measurements): wire walking step length and walking speed
2026-05-28 23:38:21 +02:00
0087_v156_step_consolidation
chore(release): v1.5.6
2026-05-29 22:07:10 +02:00
0088_v160_delivery_form
chore(release): v1.6.0
2026-05-30 00:10:12 +02:00
0091_v170_med_flags_and_device_delivery
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0092_v170_schedule_types
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0093_v170_profile_identity_fields
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0094_v170_user_unit_preference
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0095_v170_reminder_message_time_of_day
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0096_v170_measurement_sync_keyset_index
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0097_v170_mood_intake_sync
chore(release): v1.7.0
2026-05-31 14:36:17 +02:00
0098_app_settings_global_toggles_drift_fix
fix(seed): repair demo seed against the current schema
2026-06-01 17:31:45 +02:00
0099_v185_medication_injection_tracking
feat(medications): make injection-site tracking and rotation real
2026-06-01 20:25:34 +02:00
0100_v185_user_global_excluded_injection_sites
feat(medications): make injection-site tracking and rotation real
2026-06-01 20:25:34 +02:00
0101_v185_mood_tag_taxonomy
feat(mood): structured tag taxonomy + note capture and timeline
2026-06-01 20:25:42 +02:00
0102_v186_user_insurer_ik_number
feat(profile): capture the insurer IK number
2026-06-01 23:24:10 +02:00
0103_v190_medication_drug_codes
feat(medications): add optional ATC + RxNorm codes to the medication row
2026-06-02 16:45:23 +02:00
0104_v1100_additive_healthkit_metrics
feat(healthkit): ingest seven additive HealthKit signals end-to-end
2026-06-02 22:02:50 +02:00
0105_v1100_categorical_event_rows
feat(healthkit): add a categorical device-event row class
2026-06-02 22:07:28 +02:00
0106_v1100_computed_scores
docs: document the wellness-summary report section and correct the computed-scores note
2026-06-02 23:43:22 +02:00
0107_v1100_workout_hr_series
feat(workouts): add a route-independent per-workout heart-rate series
2026-06-02 22:02:46 +02:00
0108_v1100_dense_intraday_retention
feat(measurements): add a bounded dense intra-day retention tier for HRV/HR
2026-06-02 22:49:43 +02:00
0109_v1103_strain_trimp_cache
feat(insights): anchor STRAIN to the user's own training load
2026-06-03 19:31:16 +02:00
0110_v1110_clinician_share_links
feat(db): add ClinicianShareLink model (migration 0110)
2026-06-04 00:49:31 +02:00
0111_v1110_whoop_integration
feat(measurements): add WHOOP source, native score types, and source-priority ladders
2026-06-04 00:49:31 +02:00
0112_v1110_provider_health_ledger
feat(ai): durable provider-health ledger and credential-expired surfacing
2026-06-04 00:50:13 +02:00
0113_v1110_insight_narratives
feat(insights): period-narrative summary on the overview
2026-06-04 01:21:42 +02:00
0114_v1110_coach_conversation_summary
feat(coach): add encrypted conversation-summary columns (migration 0114)
2026-06-04 03:38:19 +02:00
0115_v1111_source_aware_rollups
feat(rollups): make measurement rollups source-aware (migration 0115)
2026-06-04 09:29:49 +02:00
0116_v1111_coach_facts
feat(coach): scaffold conversation-summary + facts storage
2026-06-04 10:11:19 +02:00
0117_v1120_fitbit_integration
feat(fitbit): add the Fitbit connection data model and FITBIT measurement source
2026-06-04 21:02:10 +02:00
0118_v1120_mood_tag_hobbies_nutrition
feat(mood): add hobbies and nutrition tag categories, persist bulk tagKeys
2026-06-04 22:36:58 +02:00
0119_v1120_mood_rated_factors
fix(mood): assert tag-link entry ownership and guard mood migrations with IF NOT EXISTS
2026-06-05 01:05:47 +02:00
0120_v1120_mood_factor_family
feat(mood): seed a rated family factor in the mood catalog
2026-06-05 01:07:27 +02:00
0121_v1121_partial_unique_live_rows
fix(db): live-row partial unique for intake re-take, mood external-id dedup key, perf indexes
2026-06-05 03:01:36 +02:00
0122_v1121_mood_external_id
fix(db): live-row partial unique for intake re-take, mood external-id dedup key, perf indexes
2026-06-05 03:01:36 +02:00
0123_v1121_perf_indexes
fix(db): live-row partial unique for intake re-take, mood external-id dedup key, perf indexes
2026-06-05 03:01:36 +02:00
0124_v1122_whoop_connect_ticket
feat(whoop): native-scheme connect redirect and Bearer connect ticket
2026-06-05 08:10:13 +02:00
0125_v1128_whoop_extra_metrics
feat(measurements): add average/max heart rate + sleep disturbance types
2026-06-05 14:45:58 +02:00
0126_v1129_mood_catalog_revision
feat(mood): revise factor + tag catalog (migration 0126)
2026-06-05 15:28:47 +02:00
0127_v1130_custom_mood_tags
chore(release): v1.13.0 — per-user custom mood tags + catalogue hide
2026-06-05 20:50:05 +02:00
0128_v1150_cycle_core
feat(cycle): add cycle-tracking schema foundation
2026-06-06 08:19:32 +02:00
0129_v1150_cycle_symptom_taxonomy
feat(cycle): add cycle-tracking schema foundation
2026-06-06 08:19:32 +02:00
0130_v1150_cycle_prediction
feat(cycle): add cycle-tracking schema foundation
2026-06-06 08:19:32 +02:00
0131_v1150_cycle_sensitive_encryption
fix(cycle): honour the sensitive-data encryption toggle + harden the write path
2026-06-06 11:49:23 +02:00
0132_v1150_cycle_enable_flag
feat(cycle): add cycle-tracking API surface + offline sync
2026-06-06 08:57:12 +02:00
0133_v1150_cycle_symptom_severity
feat(cycle): single-day read endpoint, symptom severity, and a richer log-day sheet
2026-06-06 12:39:28 +02:00
0134_v1151_cycle_custom_symptom_category
feat(cycle): user-defined custom symptoms
2026-06-06 16:54:43 +02:00
0135_v1159_intake_auto_missed
fix(medications): count forgotten doses as missed, not skipped
2026-06-07 13:26:41 +02:00
0136_v11513_source_filter_indexes
feat(api): add source filter to measurement and mood lists
2026-06-07 19:23:59 +02:00
0137_v11518_dose_windows
feat(medications): persist a per-dose configurable intake window
2026-06-08 18:29:05 +02:00
0138_v11520_time_format
feat(settings): a time-format preference and one home for insight pills
2026-06-10 13:34:46 +02:00
0139_v11520_intake_attribution_source
feat(coach,auth): self-context for the assistant, invite links, proactive nudges
2026-06-10 15:40:48 +02:00
0140_v11520_user_health_profile
feat(coach,auth): self-context for the assistant, invite links, proactive nudges
2026-06-10 15:40:48 +02:00
0141_v11520_invite_tokens
feat(coach,auth): self-context for the assistant, invite links, proactive nudges
2026-06-10 15:40:48 +02:00
0142_v1160_invite_redemptions
feat(coach,admin): finish the self-context and invite surfaces end to end
2026-06-10 16:18:48 +02:00
0143_v1160_self_context_fields
feat(coach,admin): finish the self-context and invite surfaces end to end
2026-06-10 16:18:48 +02:00
0144_v1163_schedule_revisions
feat(medications): schedules remember their history
2026-06-10 22:21:44 +02:00
0145_v1164_dose_taken
feat(medications,coach,insights): record the dose you actually took
2026-06-11 00:10:01 +02:00
0146_v1165_schedule_revision_source
feat(medications,admin): the schedule's history is visible and invites count their uses
2026-06-11 11:45:58 +02:00
0147_v1166_schedule_revision_supersede
feat(medications,coach,admin,perf): era corrections, a truthful weekly status and one card language everywhere
2026-06-11 13:57:15 +02:00
0148_v1168_insight_snapshot_hash
perf(insights): regenerate texts only when the underlying data changed
2026-06-11 21:17:05 +02:00
0149_v11610_inventory_units
fix(medications): every taken dose moves the stock, in units that match the product
2026-06-12 17:42:31 +02:00
0150_v11610_medication_list_layout
feat(medications): a sortable table view with an order you choose
2026-06-12 18:10:21 +02:00
0151_v11611_medication_low_stock_stamp
feat(medications): low-stock notifications with a runway threshold
2026-06-12 21:04:09 +02:00
0152_v1170_mood_tag_groups
feat(mood): tags get groups, icons and a home of their own
2026-06-12 22:03:01 +02:00
0153_v11611_medication_as_needed
feat(medications): as-needed medications log without a schedule
2026-06-12 22:56:03 +02:00
0154_v11612_fractional_units_per_dose
feat(medications): fractional dosing via decimal units per dose (#316)
2026-06-13 16:07:50 +02:00
0155_v11613_mood_tag_curation
fix(mood): deactivate the sleep-quality factor in the curated catalog
2026-06-14 10:29:22 +02:00
0156_v1170_cycle_temp_excluded
feat(cycle): exclude disturbed temperatures from the symptothermal engine
2026-06-14 15:04:25 +02:00
0157_v1170_cycle_secondary_symptom
feat(cycle): choose cervix as the symptothermal secondary symptom
2026-06-14 15:23:26 +02:00
0158_v11616_whoop_per_resource_cursor
Add per-resource cursors, fetch-by-id, and full backfill to WHOOP sync
2026-06-14 17:19:09 +02:00
0159_v11616_consent_active_unique
Harden consent receipts and document iOS series + ai-provider contract
2026-06-14 17:42:00 +02:00
0160_v1170_new_measurement_sources
Drop unused polar refresh-token column
2026-06-14 21:23:56 +02:00
0161_v1170_reorder_lead_days
Make migration 0161 re-runnable with IF NOT EXISTS
2026-06-14 20:58:49 +02:00
0162_v1171_creds_reminders_labs
fix(migrations): reference the mapped measurement_type enum in the reminders table
2026-06-15 01:49:28 +02:00
0163_v1171_sleep_timeline_backfill
chore(migrations): renumber sleep-timeline backfill to 0163 for monotonic order
2026-06-14 23:20:54 +02:00
0164_v1171_onboarding_goals
chore(migrations): renumber onboarding-goals to 0164 for monotonic order
2026-06-14 23:22:52 +02:00
0165_v1171_oura_coverage
feat(measurements): add Sleep Score and body-temperature deviation types
2026-06-15 00:09:33 +02:00
0166_v1171_polar_recovery_strain
feat(measurements): add ANS_CHARGE and CARDIO_LOAD measurement types
2026-06-15 00:07:30 +02:00
0167_module_enable_disable
feat(modules): add module_preferences_json disabled-allowlist column
2026-06-15 20:53:46 +02:00
0168_operator_module_availability
feat(modules): add operator-level server-wide module availability
2026-06-15 22:44:35 +02:00
0169_v1181_reminder_engine_fields
feat(schema): add the v1.18.1 data foundation
2026-06-16 20:36:13 +02:00
0170_v1181_biomarker_catalog
fix(vorsorge,coach): align reminders + coach chrome with the gold standard
2026-06-16 23:11:08 +02:00
0171_v1181_illness_episode
fix(vorsorge,coach): align reminders + coach chrome with the gold standard
2026-06-16 23:11:08 +02:00
0172_v1181_coach_reminder_unique
fix(vorsorge,coach): align reminders + coach chrome with the gold standard
2026-06-16 23:11:08 +02:00
0173_v1186_tour_progress
feat(onboarding): add resumable module-tour progress field + API
2026-06-18 19:27:28 +02:00
0174_v1186_diabetes_opt_in
feat(glucose): add a diabetes opt-in preference
2026-06-18 20:17:13 +02:00
0175_v1186_disclaimer_ack
feat(onboarding): one-time medical-disclaimer acknowledgment
2026-06-18 21:37:13 +02:00
0176_v1186_coach_last_seen
fix(migrations): renumber coach last-seen migration to 0176
2026-06-18 22:05:17 +02:00
0177_v1186_coach_message_role_index
fix(coach): cap proactive nudges by the persisted conversation, not push success
2026-06-18 22:41:47 +02:00
0178_v1187_session_expiry_indexes
perf(db): index session and challenge expiry columns
2026-06-19 20:52:31 +02:00
0179_v1187_briefing_reroll_date
chore(db): renumber the briefing-reroll migration to 0179
2026-06-19 21:25:22 +02:00
0180_v1187_share_link_passphrase
chore(db): renumber the share-link passphrase migration to 0180
2026-06-19 22:07:46 +02:00
migration_lock.toml
…