20 lines
714 B
MySQL
20 lines
714 B
MySQL
|
-- Migration 068: schnellere Unmapped-Liste und Listen-Nutzung
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_nutrition_items_unmapped_open
|
||
|
|
ON nutrition_items (profile_id, source_name_normalized)
|
||
|
|
WHERE food_id IS NULL AND recipe_id IS NULL;
|
||
|
|
|
||
|
|
CREATE INDEX IF NOT EXISTS idx_nutrition_items_profile_recipe_date
|
||
|
|
ON nutrition_items (profile_id, recipe_id, date)
|
||
|
|
WHERE recipe_id IS NOT NULL;
|
||
|
|
|
||
|
|
COMMENT ON INDEX idx_nutrition_items_unmapped_open IS
|
||
|
|
'Tagebuchzeilen ohne Lebensmittel und ohne Liste';
|
||
|
|
COMMENT ON INDEX idx_nutrition_items_profile_recipe_date IS
|
||
|
|
'Letzte Nutzung einer Liste ohne Join über den Listennamen';
|
||
|
|
|
||
|
|
DO $$
|
||
|
|
BEGIN
|
||
|
|
RAISE NOTICE 'Migration 068: nutrition unmapped/recipe indexes';
|
||
|
|
END $$;
|