8a185XNQ

1CREATE TABLE IF NOT EXISTS `muser_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_events` (
12`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
13`user_id` int(10) unsigned NOT NULL,
14`event_id` int(10) UNSIGNED NOT NULL,
15`type` varchar(10) unsigned NOT NULL,
16`points` int(10) UNSIGNED NOT NULL,
17`created` datetime NOT NULL,
18`updated` datetime NOT NULL,
19 PRIMARY KEY (`id`)
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
21
22INSERT INTO `muser_points` (user_id)
23    SELECT user.user_id FROM user;