3YvDtN9E

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	`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`event_id` INT UNSIGNED NOT NULL,
22`points` INT UNSIGNED NOT NULL,
23`created` datetime NOT NULL,
24`updated` datetime NOT NULL,
25 PRIMARY KEY (`id`)
26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28INSERT INTO `muser_points` (user_id)
29    SELECT user.user_id FROM user;