5 lines
240 B
SQL
5 lines
240 B
SQL
-- Add status column to network_devices for online/offline/warning indicators.
|
|
ALTER TABLE network_devices
|
|
ADD COLUMN IF NOT EXISTS status TEXT NOT NULL DEFAULT 'unknown'
|
|
CHECK (status IN ('online', 'offline', 'warning', 'unknown'));
|