KgvL2Cw5

1CREATE TABLE IF NOT EXISTS `muser_summary_points` (
2	`user_id` int(10) unsigned NOT NULL,
3	`all_points` int(10) unsigned 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`type` varchar(10)  NOT NULL,
13`points` int(10) UNSIGNED NOT NULL,
14`created` datetime NOT NULL,
15`modified` datetime NOT NULL,
16 PRIMARY KEY (`id`)
17 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19INSERT INTO `muser_summary_points` (user_id, created, modified)
20    SELECT user.user_id, user.user_created, user.user_modified FROM user;