3WL9YuaT

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
10CREATE TABLE IF NOT EXISTS `events` (
11`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
12`event_id` int(10) unsigned NOT NULL,
13`points` int(10) unsigned NOT NULL,
14 `created` datetime NOT NULL,
15 `updated` datetime NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;
18
19CREATE TABLE  IF NOT EXISTS `muser_events` (
20`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
21`user_id` int(10) unsigned NOT NULL,
22`event_id` int(10) UNSIGNED NOT NULL,
23`points` int(10) UNSIGNED NOT NULL,
24`created` datetime NOT NULL,
25`updated` datetime NOT NULL,
26 PRIMARY KEY (`id`)
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
28
29INSERT INTO `muser_points` (user_id)
30    SELECT user.user_id FROM user;