9 lines
334 B
SQL
9 lines
334 B
SQL
-- Migration 015: Add utilisation field
|
|
-- This field stores the host/device where the peripheral is used
|
|
-- Can be a reference to a host in host.yaml or "non-utilisé"
|
|
|
|
ALTER TABLE peripherals ADD COLUMN utilisation VARCHAR(255);
|
|
|
|
-- Add index for faster lookups
|
|
CREATE INDEX idx_peripherals_utilisation ON peripherals(utilisation);
|