mirror of
https://github.com/Citadel-Station-13/Citadel-Station-13-RP.git
synced 2026-08-21 10:46:42 +01:00
16 lines
733 B
SQL
16 lines
733 B
SQL
DROP TRIGGER IF EXISTS `playtimeTlogupdate`;
|
|
DROP TRIGGER IF EXISTS `playtimeTloginsert`;
|
|
DROP TRIGGER IF EXISTS `playtimeTlogdelete`;
|
|
|
|
DELIMITER $$
|
|
CREATE TRIGGER `playtimeTlogupdate` AFTER UPDATE ON `playtime` FOR EACH ROW BEGIN INSERT into `playtime_log` (player, roleid, delta) VALUES (NEW.player, NEW.roleid, NEW.minutes-OLD.minutes);
|
|
END
|
|
$$
|
|
CREATE TRIGGER `playtimeTloginsert` AFTER INSERT ON `playtime` FOR EACH ROW BEGIN INSERT into `playtime_log` (player, roleid, delta) VALUES (NEW.player, NEW.roleid, NEW.minutes);
|
|
END
|
|
$$
|
|
CREATE TRIGGER `playtimeTlogdelete` AFTER DELETE ON `playtime` FOR EACH ROW BEGIN INSERT into `playtime_log` (player, roleid, delta) VALUES (OLD.player, OLD.roleid, 0-OLD.minutes);
|
|
END
|
|
$$
|
|
DELIMITER ;
|