Fimeg/RedFlag
Watch
1
0
Fork
You've already forked RedFlag
 0
Code Releases Activity
RedFlag/server/internal/database/migrations
History
Exact
Repository files (latest commit first)
Filename Latest commit message Latest commit date
Fimeg 1f75bfd23a device-type: layered detection + laptop/vm/container types 
Replaces the flat battery x display matrix (which misclassified laptops
as phones) with layered detection: container -> vm -> SMBIOS chassis ->
ARM fallback. Adds laptop, vm, container device types across agent,
migration 062, server validation, web icons/types.
2026-07-12 14:55:04 -04:00
..
001_initial_schema.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
001_initial_schema.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
003_create_update_tables.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
004_fix_update_logs_foreign_key.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
005_add_pending_dependencies_status.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
006_add_missing_command_statuses.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
007_expand_status_column_length.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
008_create_refresh_tokens_table.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
009_add_agent_version_tracking.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
009b_add_retry_tracking.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
010_add_archived_failed_status.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
011_create_registration_tokens_table.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
012_add_token_seats.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
012b_create_admin_user.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
013_add_reboot_tracking.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
014_add_command_source.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
015_agent_subsystems.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
015_agent_subsystems.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
016_agent_update_packages.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
016_agent_update_packages.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
017_add_machine_id.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
017_add_machine_id.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
018_create_metrics_and_docker_tables.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
018_create_metrics_and_docker_tables.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
019_create_system_events_table.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
020_add_command_signatures.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
020_add_command_signatures.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
021_create_storage_metrics.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
022_add_subsystem_to_logs.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
022_add_subsystem_to_logs.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
023_client_error_logging.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
023_client_error_logging.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
023a_command_deduplication.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
023a_command_deduplication.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
024_disable_updates_subsystem.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
024_disable_updates_subsystem.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
025_add_key_id_signed_at.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
025_add_key_id_signed_at.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
025b_platform_scanner_subsystems.down.sql feat: agent resilience knobs, shared polling loop, settings restructure 2026-05-28 21:45:04 -04:00
025b_platform_scanner_subsystems.up.sql feat: agent resilience knobs, shared polling loop, settings restructure 2026-05-28 21:45:04 -04:00
026_add_expires_at.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
026_add_expires_at.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
027_create_scanner_config_table.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
027_create_scanner_config_table.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
028_add_stuck_commands_index.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
028_add_stuck_commands_index.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
029_add_command_retry_count.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
029_add_command_retry_count.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
030_add_operational_settings.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
030_add_operational_settings.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
031_create_maintenance_windows_table.down.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
031_create_maintenance_windows_table.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
032_add_commands_updated_at.up.sql refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
033_add_received_command_state.down.sql command-lifecycle v2: add received state, disk-persisted dedup, authenticated download, timeout reconciler 2026-05-22 08:45:16 -04:00
033_add_received_command_state.up.sql command-lifecycle v2: add received state, disk-persisted dedup, authenticated download, timeout reconciler 2026-05-22 08:45:16 -04:00
034_add_security_settings_created_at.down.sql fix: add security_settings.created_at column 2026-05-22 14:20:20 -04:00
034_add_security_settings_created_at.up.sql fix: add security_settings.created_at column 2026-05-22 14:20:20 -04:00
035_create_upstream_sync.down.sql feat: install/sync/RL hardening + upstream version sync subsystem 2026-05-23 15:12:20 -04:00
035_create_upstream_sync.up.sql feat: install/sync/RL hardening + upstream version sync subsystem 2026-05-23 15:12:20 -04:00
036_create_token_seats_and_convert_timestamps.down.sql fix: create token_seats table before timestamp conversion (migration 036) 2026-05-24 20:45:17 -04:00
036_create_token_seats_and_convert_timestamps.up.sql feat: helper distribution pipeline + dnf discovery/resolve fixes for live gate 2026-05-29 22:04:38 -04:00
037_dedupe_agent_update_packages.down.sql v0.2.0.3: wire install flow, restore lost handlers, dedupe agent packages 2026-05-25 10:02:52 -04:00
037_dedupe_agent_update_packages.up.sql v0.2.0.3: wire install flow, restore lost handlers, dedupe agent packages 2026-05-25 10:02:52 -04:00
038_add_policy_settings.down.sql feat: auto-heartbeat at dispatch, event narratives, policy table (migration 038) 2026-05-25 14:12:23 -04:00
038_add_policy_settings.up.sql feat: auto-heartbeat at dispatch, event narratives, policy table (migration 038) 2026-05-25 14:12:23 -04:00
039_create_agent_tracked_software.down.sql chore: bump to v0.2.0.5 + agent↔tracked_software bindings 2026-05-25 19:52:48 -04:00
039_create_agent_tracked_software.up.sql chore: bump to v0.2.0.5 + agent↔tracked_software bindings 2026-05-25 19:52:48 -04:00
040_add_expected_sha256.down.sql Layer 1: Hash Registry — verify package SHA256 before installation 2026-05-26 13:25:54 -04:00
040_add_expected_sha256.up.sql Layer 1: Hash Registry — verify package SHA256 before installation 2026-05-26 13:25:54 -04:00
041_update_version_history_status_constraint.down.sql refactor(agent): scanner orchestrator cleanup + kernel-enforcement wiring + hash-registry follow-ups 2026-05-28 13:31:51 -04:00
041_update_version_history_status_constraint.up.sql refactor(agent): scanner orchestrator cleanup + kernel-enforcement wiring + hash-registry follow-ups 2026-05-28 13:31:51 -04:00
042_create_capability_tokens.down.sql feat: supply-chain capability-token gate (executor, signing, mint/deliver, agent consumer) 2026-05-28 14:53:05 -04:00
042_create_capability_tokens.up.sql feat: supply-chain capability-token gate (executor, signing, mint/deliver, agent consumer) 2026-05-28 14:53:05 -04:00
043_create_package_versions.down.sql feat: package-centric updates, version timeline, and registry-gap closure (v0.2.0.7) 2026-05-28 20:25:59 -04:00
043_create_package_versions.up.sql feat: package-centric updates, version timeline, and registry-gap closure (v0.2.0.7) 2026-05-28 20:25:59 -04:00
044_add_polling_operational_settings.down.sql feat: agent resilience knobs, shared polling loop, settings restructure 2026-05-28 21:45:04 -04:00
044_add_polling_operational_settings.up.sql feat: agent resilience knobs, shared polling loop, settings restructure 2026-05-28 21:45:04 -04:00
045_add_refresh_token_rotation.down.sql feat: machine-bound token renewal + refresh-token rotation with reuse detection 2026-05-29 10:47:48 -04:00
045_add_refresh_token_rotation.up.sql feat: machine-bound token renewal + refresh-token rotation with reuse detection 2026-05-29 10:47:48 -04:00
046_hash_registration_tokens.down.sql security: hash registration tokens at rest, idempotency guard, README trust model 2026-05-30 13:12:58 -04:00
046_hash_registration_tokens.up.sql give the system a window you can scrape, and patch a migration that couldn't run twice 2026-06-07 20:59:29 -04:00
047_rename_updated_to_installed.down.sql v0.2.2.0: enforce package state machine across all transitions, vuln dashboard 2026-05-31 16:39:58 -04:00
047_rename_updated_to_installed.up.sql v0.2.2.0: enforce package state machine across all transitions, vuln dashboard 2026-05-31 16:39:58 -04:00
048_add_update_log_result_values.down.sql update_logs.result: add started/partial/running — fix agent-report badge semantics 2026-06-05 09:13:42 -04:00
048_add_update_log_result_values.up.sql update_logs.result: add started/partial/running — fix agent-report badge semantics 2026-06-05 09:13:42 -04:00
049_add_registration_token_encrypted.down.sql feat: SETTINGS-001 reversible token encryption + one-liner restore 2026-06-05 16:17:47 -04:00
049_add_registration_token_encrypted.up.sql feat: SETTINGS-001 reversible token encryption + one-liner restore 2026-06-05 16:17:47 -04:00
050_version_soak_gate.down.sql feat: FEAT-002 metadata pipeline, GATE-005 soak gate, BRIDGE-001 auto-discovery 2026-06-05 17:43:11 -04:00
050_version_soak_gate.up.sql feat: FEAT-002 metadata pipeline, GATE-005 soak gate, BRIDGE-001 auto-discovery 2026-06-05 17:43:11 -04:00
051_tracked_software_discovery.down.sql feat: FEAT-002 metadata pipeline, GATE-005 soak gate, BRIDGE-001 auto-discovery 2026-06-05 17:43:11 -04:00
051_tracked_software_discovery.up.sql feat: FEAT-002 metadata pipeline, GATE-005 soak gate, BRIDGE-001 auto-discovery 2026-06-05 17:43:11 -04:00
052_docker_enrichment.down.sql feat: docker enrichment pipeline, package detail, update history pagination 2026-06-05 21:18:06 -04:00
052_docker_enrichment.up.sql feat: docker enrichment pipeline, package detail, update history pagination 2026-06-05 21:18:06 -04:00
053_retire_soak_override_scaffolding.down.sql v0.2.6.2 — osv scans moved to detection, soak gate grew up 2026-06-07 14:44:41 -04:00
053_retire_soak_override_scaffolding.up.sql v0.2.6.2 — osv scans moved to detection, soak gate grew up 2026-06-07 14:44:41 -04:00
054_add_observability_metrics_settings.down.sql give the system a window you can scrape, and patch a migration that couldn't run twice 2026-06-07 20:59:29 -04:00
054_add_observability_metrics_settings.up.sql give the system a window you can scrape, and patch a migration that couldn't run twice 2026-06-07 20:59:29 -04:00
055_create_process_tables.down.sql feat: process explorer — on-demand /proc scanning with full osquery parity 2026-06-11 02:01:43 -04:00
055_create_process_tables.up.sql feat: process explorer — on-demand /proc scanning with full osquery parity 2026-06-11 02:01:43 -04:00
056_create_agent_inventory.down.sql feat: process explorer — on-demand /proc scanning with full osquery parity 2026-06-11 02:01:43 -04:00
056_create_agent_inventory.up.sql feat: process explorer — on-demand /proc scanning with full osquery parity 2026-06-11 02:01:43 -04:00
057_add_totp_to_registration_tokens.down.sql SEC-025: fleet-join 2FA — TOTP validation, host-generated seed, migration 057 2026-06-11 13:37:17 -04:00
057_add_totp_to_registration_tokens.up.sql SEC-025: fleet-join 2FA — TOTP validation, host-generated seed, migration 057 2026-06-11 13:37:17 -04:00
058_totp_seed_encrypted.down.sql sec: encrypt TOTP seed at rest (migration 058) 2026-06-11 17:47:23 -04:00
058_totp_seed_encrypted.up.sql sec: encrypt TOTP seed at rest (migration 058) 2026-06-11 17:47:23 -04:00
059_tracked_software_prereleases.down.sql upstream: track prereleases per row; rename gitea adapter to forgejo 2026-06-15 12:10:12 -04:00
059_tracked_software_prereleases.up.sql upstream: track prereleases per row; rename gitea adapter to forgejo 2026-06-15 12:10:12 -04:00
060_drop_token_seats.down.sql v0.2.9.0 — Windows desktop tray ships; unified Agents & Enrollment page 2026-06-15 20:51:44 -04:00
060_drop_token_seats.up.sql v0.2.9.0 — Windows desktop tray ships; unified Agents & Enrollment page 2026-06-15 20:51:44 -04:00
061_agent_device_type.down.sql v0.2.9.3: device classification + ARM support — Pixel 3 lands 2026-07-06 18:21:23 -04:00
061_agent_device_type.up.sql v0.2.9.3: device classification + ARM support — Pixel 3 lands 2026-07-06 18:21:23 -04:00
062_widen_device_type_enum.down.sql device-type: layered detection + laptop/vm/container types 2026-07-12 14:55:04 -04:00
062_widen_device_type_enum.up.sql device-type: layered detection + laptop/vm/container types 2026-07-12 14:55:04 -04:00
idempotency_test.go refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
index_audit_test.go refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
migration018_test.go refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00
migration024_test.go refactor: rename aggregator-agent to agent for public release 2026-05-21 13:19:18 -04:00