5hu0jiN9

1CREATE TABLE IF NOT EXISTS `muser_summary_points` (
2	`user_id` int(10) unsigned NOT NULL,
3	`all_points` int(10) NOT NULL,
4	`created` datetime NOT NULL,
5	`modified` datetime NOT NULL,
6	PRIMARY KEY (`user_id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9CREATE TABLE  IF NOT EXISTS `muser_points` (
10`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
11`user_id` int(10) unsigned NOT NULL,
12`points` int(10) NOT NULL,
13`created` datetime NOT NULL,
14`modified` datetime NOT NULL,
15 PRIMARY KEY (`id`)
16 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18INSERT INTO `muser_summary_points` (user_id, created, modified)
19    SELECT user.user_id, user.user_created, user.user_modified FROM user;
20
21CREATE TRIGGER update_muser_points AFTER INSERT
22 ON morele.muser_points
23        FOR EACH ROW UPDATE INTO
24        `muser_summary_points`
25        (
26            `all_points`
27        )
28        SELECT
29            `points`
30        FROM
31        `muser_points`
32END