5e9c27b7ef
The reboot_reason field was defined as string instead of *string, causing database scan failures when the column contains NULL values. This broke agent list loading on existing installations after migration. - Changed reboot_reason to *string in both Agent and AgentWithLastScan structs - Added DEFAULT empty string to migration for new installations - Added README section for full server reinstall procedure
14 lines
691 B
SQL
14 lines
691 B
SQL
-- Add reboot tracking fields to agents table
|
|
ALTER TABLE agents
|
|
ADD COLUMN reboot_required BOOLEAN DEFAULT FALSE,
|
|
ADD COLUMN last_reboot_at TIMESTAMP,
|
|
ADD COLUMN reboot_reason TEXT DEFAULT '';
|
|
|
|
-- Add index for efficient querying of agents needing reboot
|
|
CREATE INDEX idx_agents_reboot_required ON agents(reboot_required) WHERE reboot_required = TRUE;
|
|
|
|
-- Add comment for documentation
|
|
COMMENT ON COLUMN agents.reboot_required IS 'Whether the agent host requires a reboot to complete updates';
|
|
COMMENT ON COLUMN agents.last_reboot_at IS 'Timestamp of the last system reboot';
|
|
COMMENT ON COLUMN agents.reboot_reason IS 'Reason why reboot is required (e.g., kernel update, library updates)';
|