Marc-André Bombeck b99b07ad38 feat(profile): capture the insurer IK number ...

Add an optional German insurer institution number (IKNR, 9 digits) to
the user profile, alongside the existing insurer name and KVNR. The
IKNR is a public registry identifier for the institution, not a
per-person quasi-identifier, so it is stored plaintext, matching
insurer_name rather than the encrypted KVNR column.

The profile GET echoes the field; PATCH/PUT accept it via Zod —
optional, empty string maps to null, and a non-empty value must be
exactly 9 digits (422 otherwise, no checksum). The write is built
field-by-field. /api/user/profile gains an OpenAPI registration with
the profile read/write schemas.

Migration 0102 adds the nullable column, NULL-defaulted, forward-only.

2026-06-01 23:24:10 +02:00

..

0001_init

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0002_roles_and_settings

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0003_add_missing_columns

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0004_add_audit_log_location

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0005_notification_system

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0006_medication_notifications_enabled

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0007_medication_paused_at

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0008_app_settings_bugreport_github

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0009_app_settings_api_global

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0010_app_settings_monitoring

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0011_app_settings_web_push_vapid

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0012_app_settings_reminder_thresholds

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0013_medication_snoozed_until

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0014_add_moodlog_integration

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0015_add_reminder_phase_tracking

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0016_telegram_scheduled_deletions

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0017_add_data_backups

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0018_add_user_achievements

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0019_add_rate_limits

Initial release v1.0.0

2026-03-10 20:14:33 +01:00

0020_codex_oauth_admin_ai

feat(db): add Codex OAuth tokens and admin AI settings, remove openaiKeyEncrypted

2026-04-06 00:42:46 +02:00

0021_v1_2_personalization_feedback_glucose

release(v1.2): i18n, thresholds, glucose, dashboard customization, feedback, multi-provider AI (#77)

2026-04-18 22:20:12 +02:00

0022_body_composition_metrics

audit(v1.3.3): SpO2 + body-composition + 14 CRITICAL/HIGH security/correctness fixes (#121)

2026-05-08 01:05:56 +02:00

0023_ios_adapters_idempotency_devices

chore(db): migration 0023 — idempotency_keys, devices, healthkit user columns

2026-05-03 21:52:57 +02:00

0024_oxygen_saturation

audit(v1.3.3): SpO2 + body-composition + 14 CRITICAL/HIGH security/correctness fixes (#121)

2026-05-08 01:05:56 +02:00

0025_refresh_tokens

feat(v1.4): multi-tenant prep — off-host backup, encryption-key versioning, worker/web split, native-Bearer UA gating (#135)

2026-05-08 14:33:39 +02:00

0025_user_locale_drift_fix

fix(db): backfill the users.locale column as a migration (#140)

2026-05-08 14:29:44 +02:00

0026_user_ai_openai_key

feat(settings): KI-provider — OpenAI key field, model preset dropdown, gated OAuth

2026-05-08 21:36:36 +02:00

0027_bug_report_enabled_toggle

feat(admin): bug-report toggle, unify "Trennen" button styling

2026-05-08 21:45:18 +02:00

0028_notification_channel_reliability

fix(notifications): auto-disable channels on persistent hard rejects (410, etc.)

2026-05-09 21:01:45 +02:00

0029_integration_status

feat(integrations): connection-state + sync-error UI in Settings → Integrations

2026-05-09 21:04:04 +02:00

0030_onboarding_tour_completed

feat(db): User.onboardingTourCompleted flag

2026-05-09 21:14:00 +02:00

0031_user_last_report_practice_name

feat(doctor-report): practice name on cover page (persisted as user preference)

2026-05-09 21:36:47 +02:00

0032_host_metric

feat(db): HostMetric model for host-load sampling

2026-05-09 23:46:56 +02:00

0033_user_ai_provider_chain

feat(db): User.aiProviderChain for ordered fallback config

2026-05-10 00:20:12 +02:00

0034_recommendation_feedback

feat(db): RecommendationFeedback model with GDPR cascade + provider attribution

2026-05-10 01:25:57 +02:00

0035_coach_conversations_v1420

feat(coach): add CoachConversation, CoachMessage, CoachUsage models

2026-05-10 15:54:28 +02:00

0036_apple_health_measurement_types

chore(security): MED cluster — Coolify URL scrub + isCurrent device-id + SLEEP_DURATION migration note

2026-05-11 02:44:12 +02:00

0037_apns_device_columns

feat(schema): APNs device columns + dispatcher channel-type extension

2026-05-11 00:35:58 +02:00

0038_coach_prefs

feat(coach): per-user prompt-tuning surface (settings cog returns)

2026-05-11 01:35:45 +02:00

0039_medication_schedule_days_of_week

chore(schema): deploy medication_schedules.days_of_week column

2026-05-11 01:36:27 +02:00

0040_recommendation_feedback_target_type

feat(coach): per-message thumbs feedback + admin aggregate view

2026-05-11 01:51:27 +02:00

0041_apns_token_unique_partial

fix(devices): enforce global apnsToken uniqueness via partial index

2026-05-11 02:13:47 +02:00

0042_coach_feedback_message_ref

fix(coach): feedback references coach_messages, drops plaintext column

2026-05-11 02:38:17 +02:00

0043_per_user_timezone

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0044_mood_entry_tz_column

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0045_doctor_report_prefs

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0046_glp1_dose_history

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0047_medication_schedule_window_snake_case

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0048_user_source_priority

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0049_withings_full_metrics

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0050_withings_connection_scope

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0051_measurement_device_type

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0052_apple_health_enum_extensions

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0053_workout_and_route

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0054_personal_record

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0055_measurement_sleepstage_composite

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0056_medication_inventory_item

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0057_user_onboarding_step

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0058_user_research_mode

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0059_medication_side_effect

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0060_onboarding_step_not_null

chore(release): v1.4.25

2026-05-14 23:49:32 +02:00

0061_audit_log_carrier

chore(release): v1.4.27

2026-05-15 22:59:10 +02:00

0062_v1430_sync_mode_foundation

chore(release): v1.4.30

2026-05-16 12:37:55 +02:00

0063_mood_entry_note_column

chore(release): v1.4.30

2026-05-16 12:37:55 +02:00

0064_v1430_measurement_type_additions

chore(release): v1.4.30

2026-05-16 12:37:55 +02:00

0065_v1431_assistant_feature_flags

chore(release): v1.4.31

2026-05-16 14:19:57 +02:00

0066_v1434_import_jobs

v1.4.34 — apple-health import + reliability + web-freeze

2026-05-16 21:25:26 +02:00

0067_v1434_measurement_rollups

v1.4.35 — persistent measurement rollups + partial read-swap

2026-05-17 09:55:33 +02:00

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

migration_lock.toml

feat(integrations): connection-state + sync-error UI in Settings → Integrations

2026-05-09 21:04:04 +02:00