ksnY2xvQ

1CREATE TABLE IF NOT EXISTS `muser_summary_points` (
2	`user_id` int(10) unsigned NOT NULL,
3	`all_points` int(10) NOT NULL,
4	`created` datetime NOT NULL,
5	`modified` datetime NOT NULL,
6	PRIMARY KEY UNIQUE(`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`user_review_id` int(10) unsigned,
13`product_id` int(10) unsigned NOT NULL,
14`points` int(10) NOT NULL,
15`type` VARCHAR(30) NOT NULL,
16`created` datetime NOT NULL,
17`modified` datetime NOT NULL,
18 PRIMARY KEY (`id`)
19 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;