jPh5yrcj

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 `muser_events` (
11`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
12`event` INT UNSIGNED NOT NULL,
13`points` INT UNSIGNED NOT NULL,
14 PRIMARY KEY (`id`)
15 UNIQUE INDEX `muser_events_UNIQUE` (`id` ASC);
16
17INSERT INTO `muser_points` (user_id)
18    SELECT user.user_id FROM user;