mysimulation/server/FSO.Server.Database/DatabaseScripts/changes/0011_fso_bonus.sql

CREATE TABLE IF NOT EXISTS `fso_bonus` (
  `avatar_id` int(10) unsigned NOT NULL DEFAULT '0',
  `period` date NOT NULL,
  `bonus_visitor` int(11) DEFAULT NULL,
  `bonus_property` int(11) DEFAULT NULL,
  `bonus_sim` int(11) DEFAULT NULL,
  PRIMARY KEY (`avatar_id`,`period`),
  CONSTRAINT `FK_fso_bonus_fso_avatars` FOREIGN KEY (`avatar_id`) REFERENCES `fso_avatars` (`avatar_id`) ON DELETE CASCADE ON UPDATE CASCADE
) COLLATE='utf8_general_ci'
  ENGINE=InnoDB;

CREATE TRIGGER `fso_bonus_after_insert` AFTER INSERT ON `fso_bonus` FOR EACH ROW BEGIN
	UPDATE fso_avatars a SET budget = (budget + IFNULL(NEW.bonus_visitor,0) + IFNULL(NEW.bonus_property,0) + IFNULL(NEW.bonus_sim,0)) WHERE a.avatar_id = NEW.avatar_id;
END;