mirror of
https://github.com/grocy/grocy.git
synced 2025-09-16 17:56:51 +00:00
7 lines
157 B
MySQL
7 lines
157 B
MySQL
|
CREATE TRIGGER recipes_desired_servings_default AFTER INSERT ON recipes
|
||
|
|
BEGIN
|
||
|
|
UPDATE recipes
|
||
|
|
SET desired_servings = base_servings
|
||
|
|
WHERE id = NEW.id;
|
||
|
|
END;
|