7jZwPJP2

1CREATE TABLE IF NOT EXISTS `muser_summary_points` (
2	`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3	`user_id` int(10) unsigned NOT NULL,
4	`all_points` int(10) unsigned NOT NULL,
5	`created` datetime NOT NULL,
6	`updated` datetime NOT NULL,
7	PRIMARY KEY (`id`)
8) ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10
11CREATE TABLE  IF NOT EXISTS `muser_points` (
12`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
13`user_id` int(10) unsigned NOT NULL,
14`type` varchar(10) unsigned NOT NULL,
15`points` int(10) UNSIGNED NOT NULL,
16`created` datetime NOT NULL,
17`updated` datetime NOT NULL,
18 PRIMARY KEY (`id`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21INSERT INTO `muser_points` (user_id)
22    SELECT user.user_id FROM user;