File indexing completed on 2024-04-28 17:16:10
0001 DROP TABLE `member_score`; 0002 0003 CREATE TABLE `member_score` 0004 ( 0005 `member_score_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, 0006 `member_id` INT(10) UNSIGNED NOT NULL DEFAULT '0', 0007 `score` INT(10) NOT NULL DEFAULT '0', 0008 `count_product` INT(11) NULL DEFAULT '0', 0009 `count_pling` INT(11) NULL DEFAULT '0', 0010 `count_like` INT(11) NULL DEFAULT '0', 0011 `count_comment` INT(11) NULL DEFAULT '0', 0012 `count_years_membership` INT(11) NULL DEFAULT '0', 0013 `count_report_product_spam` INT(11) NULL DEFAULT '0', 0014 `count_report_product_fraud` INT(11) NULL DEFAULT '0', 0015 `count_report_comment` INT(11) NULL DEFAULT '0', 0016 `count_report_member` INT(11) NULL DEFAULT '0', 0017 `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP, 0018 PRIMARY KEY (`member_score_id`), 0019 INDEX `idx_member` (`member_id`) 0020 ) 0021 ENGINE = InnoDB; 0022 0023 0024 DROP TABLE `member_score_factors`; 0025 CREATE TABLE `member_score_factors` 0026 ( 0027 `factor_id` INT NOT NULL, 0028 `name` VARCHAR(50) NULL, 0029 `descrption` VARCHAR(255) NULL, 0030 `value` INT NULL, 0031 PRIMARY KEY (`factor_id`) 0032 ); 0033 0034 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0035 VALUES ('1', 'project', '1'); 0036 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0037 VALUES ('2', 'pling', '100'); 0038 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0039 VALUES ('3', 'like', '100'); 0040 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0041 VALUES ('4', 'comment', '10'); 0042 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0043 VALUES ('5', 'year', '10'); 0044 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0045 VALUES ('6', 'report_product_spam', '-100'); 0046 INSERT INTO `member_score_factors` (`factor_id`, `name`, `value`) 0047 VALUES ('7', 'report_product_fraud', '-100');