File indexing completed on 2024-04-21 06:00:36
0001 CREATE TABLE `stat_cnt_projects_catid_memberid` AS 0002 SELECT `project_category_id`, `member_id`, count(1) AS `cnt` 0003 FROM `project` `pp` 0004 WHERE `pp`.`status` = 100 0005 AND `pp`.`type_id` = 1 0006 GROUP BY `project_category_id`, `member_id`; 0007 0008 ALTER TABLE `stat_cnt_projects_catid_memberid` 0009 ADD INDEX `idx_project_category_id` (`project_category_id`), 0010 ADD INDEX `idx_member_id` (`member_id`); 0011 0012 0013 TRUNCATE TABLE `stat_cnt_projects_catid_memberid`; 0014 0015 INSERT INTO `stat_cnt_projects_catid_memberid` 0016 SELECT `project_category_id`, `member_id`, count(1) AS `cnt` 0017 FROM `project` `pp` 0018 WHERE `pp`.`status` = 100 0019 AND `pp`.`type_id` = 1 0020 GROUP BY `project_category_id`, `member_id`; 0021 0022 0023 0024 CREATE EVENT `e_generate_stat_cnt_projects_catid_memberid` 0025 ON SCHEDULE 0026 EVERY 1 DAY STARTS '2019-01-15 03:30:00' 0027 ON COMPLETION NOT PRESERVE 0028 ENABLE 0029 COMMENT '' 0030 DO 0031 BEGIN 0032 TRUNCATE TABLE `stat_cnt_projects_catid_memberid`; 0033 0034 INSERT INTO `stat_cnt_projects_catid_memberid` 0035 SELECT `project_category_id`, `member_id`, count(1) AS `cnt` 0036 FROM `project` `pp` 0037 WHERE `pp`.`status` = 100 0038 AND `pp`.`type_id` = 1 0039 GROUP BY `project_category_id`, `member_id`; 0040 0041 END; 0042 0043 0044 0045 0046