19 lines
671 B
MySQL
19 lines
671 B
MySQL
|
-- Migration 064: Mengeneinheiten am Mapping + source=import erlaubt
|
||
|
|
|
||
|
|
ALTER TABLE food_name_mappings
|
||
|
|
ADD COLUMN IF NOT EXISTS grams_per_unit NUMERIC(10,3),
|
||
|
|
ADD COLUMN IF NOT EXISTS source_unit VARCHAR(20);
|
||
|
|
|
||
|
|
ALTER TABLE food_name_mappings DROP CONSTRAINT IF EXISTS food_name_mappings_source_check;
|
||
|
|
|
||
|
|
ALTER TABLE food_name_mappings
|
||
|
|
ADD CONSTRAINT food_name_mappings_source_check
|
||
|
|
CHECK (source IN ('manual', 'bulk', 'admin', 'import'));
|
||
|
|
|
||
|
|
COMMENT ON COLUMN food_name_mappings.grams_per_unit IS 'Gramm pro Quell-Einheit (Stück, EL, …); NULL = Masse/Volumen bereits in g';
|
||
|
|
|
||
|
|
DO $$
|
||
|
|
BEGIN
|
||
|
|
RAISE NOTICE 'Migration 064: mapping units + source import';
|
||
|
|
END $$;
|