mirror of
https://github.com/simtactics/mysimulation.git
synced 2025-03-26 03:09:10 +00:00
14 lines
722 B
MySQL
14 lines
722 B
MySQL
|
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;
|