mirror of
https://github.com/grocy/grocy.git
synced 2026-03-27 23:29:25 +01:00
7 lines
157 B
SQL
7 lines
157 B
SQL
CREATE TRIGGER recipes_desired_servings_default AFTER INSERT ON recipes
|
|
BEGIN
|
|
UPDATE recipes
|
|
SET desired_servings = base_servings
|
|
WHERE id = NEW.id;
|
|
END;
|