11 lines
420 B
PL/PgSQL
11 lines
420 B
PL/PgSQL
-- Migration 2026-04-17 : ajout colonne intervenant_name a patch_history
|
|
-- pour stocker le nom d'intervenant libre provenant du xlsx (ex "Khalid", "Thierno")
|
|
-- sans FK users (car ne correspond pas forcement a un user patchcenter)
|
|
|
|
BEGIN;
|
|
|
|
ALTER TABLE patch_history ADD COLUMN IF NOT EXISTS intervenant_name varchar(100);
|
|
CREATE INDEX IF NOT EXISTS idx_ph_intervenant_name ON patch_history (intervenant_name);
|
|
|
|
COMMIT;
|