Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create trigger check_nova_poshta_spd_id_before_update
- before update
- on order_ttn_settings
- for each row
- BEGIN
- IF NEW.spd_id IS NULL AND (NEW.is_active_beznal IS NULL OR NEW.is_active_beznal = 0) THEN
- SIGNAL SQLSTATE '45000' SET message_text = 'Заполните поле spd_id';
- END IF;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement