a guest Feb 22nd, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create trigger AdminInITUpdateMitarbeier before update on Mitarbeiter
  2. when NEW.Bereich != 'IT' and exists (
  3.     select * from Administrator
  4.     where MitarbeiterBenutzerEmail = NEW.BenutzerEmail
  5. )
  6. begin
  7.     select RAISE(ABORT,"Administrator muss im Bereich IT arbeiten")
  8. end;
  9. end;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand