Kcko
10/11/2019 - 9:44 PM

Triggers

CREATE TRIGGER diskuse_ai AFTER INSERT ON diskuse FOR EACH ROW UPDATE clanky SET diskuse_pocet = diskuse_pocet + 1 WHERE id = NEW.clanek;
CREATE TRIGGER diskuse_ad AFTER DELETE ON diskuse FOR EACH ROW UPDATE clanky SET diskuse_pocet = diskuse_pocet - 1 WHERE id = OLD.clanek;
CREATE TRIGGER diskuse_au AFTER UPDATE ON diskuse FOR EACH ROW UPDATE clanky SET diskuse_pocet = diskuse_pocet + IF(id = NEW.clanek, 1, -1) WHERE id = OLD.clanek XOR id = NEW.clanek;
-- https://diskuse.jakpsatweb.cz/?action=vthread&forum=28&topic=172769#7

IF NEW.id = 10
THEN
  UPDATE mantis_custom_field_table
  SET possible_values = NEW.possible_values
  WHERE id = 11
        AND NOT possible_values <=> NEW.possible_values;
END IF;