12 lines
631 B
MySQL
12 lines
631 B
MySQL
|
-- Migration 038: Optionale verantwortliche Person pro Trainingstermin (Vertretung)
|
||
|
|
-- Für Vereins-/Trainerübersicht: COALESCE(tu.lead_trainer_profile_id, tg.trainer_id) = wirksamer Leitungstrainer.
|
||
|
|
|
||
|
|
ALTER TABLE training_units
|
||
|
|
ADD COLUMN IF NOT EXISTS lead_trainer_profile_id INT REFERENCES profiles(id) ON DELETE SET NULL;
|
||
|
|
|
||
|
|
COMMENT ON COLUMN training_units.lead_trainer_profile_id IS 'Vertretung / expliziter Leiter dieses Terms; NULL = Standard (Haupttrainer der Gruppe)';
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_training_units_lead_trainer
|
||
|
|
ON training_units(lead_trainer_profile_id)
|
||
|
|
WHERE lead_trainer_profile_id IS NOT NULL;
|