Z1PLzBWq

1
2
3update radacct set acctInputOctets = acctInputOctets + 73462 where radacctid = 14539;
4
5DROP TABLE IF EXISTS `user_stats`;
6    CREATE TABLE `user_stats` (
7    `id` int(11) NOT NULL AUTO_INCREMENT,
8    `radacct_id` int(11) NOT NULL,
9    `username` varchar(64) NOT NULL,
10    `acctsessionid` varchar(64) NOT NULL,
11    `acctuniqueid` varchar(32) NOT NULL,
12    `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
13    `acctinputoctets` bigint(20) NOT NULL,
14    `acctoutputoctets` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
15
16
17delimiter $$
18    CREATE TRIGGER radacct_after_update
19    AFTER update ON radacct FOR EACH ROW BEGIN
20    INSERT INTO 
21      user_stats 
22    SET 
23      radacct_id = OLD.radacctid, 
24      username = OLD.username,
25      acctsessionid = OLD.acctsessionid,
26      acctuniqueid = OLD.acctuniqueid,
27      acctinputoctets = (NEW.acctinputoctets - OLD.acctinputoctets), 
28      acctoutputoctets = (NEW.acctoutputoctets - OLD.acctoutputoctets);
29    END$$ 
30delimiter ;