Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TRIGGER IF EXISTS dispatchTrigger;
- CREATE TRIGGER IF NOT EXISTS dispatchTrigger
- AFTER INSERT ON bestellungenthaltenmahlzeiten
- FOR EACH ROW
- UPDATE mahlzeiten
- SET Vorrat = Vorrat - NEW.Anzahl
- WHERE ID = NEW.MahlzeitID;
- DROP TRIGGER IF EXISTS verfügbarTrigger;
- CREATE TRIGGER IF NOT EXISTS verfügbarTrigger
- AFTER INSERT ON bestellungenthaltenmahlzeiten
- FOR EACH ROW
- UPDATE mahlzeiten
- SET Verfügbar = 0
- WHERE Vorrat = 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement