File indexing completed on 2024-04-14 05:53:07
0001 0002 0003 DROP PROCEDURE IF EXISTS `generate_stat_files_downloaded`; 0004 0005 DELIMITER $$ 0006 0007 CREATE PROCEDURE `generate_stat_files_downloaded`() 0008 LANGUAGE SQL 0009 NOT DETERMINISTIC 0010 CONTAINS SQL 0011 SQL SECURITY DEFINER 0012 COMMENT '' 0013 BEGIN 0014 0015 DROP TABLE IF EXISTS `ppload`.`tmp_stat_ppload_files_downloaded`; 0016 0017 CREATE TABLE `ppload`.`tmp_stat_ppload_files_downloaded` 0018 ( 0019 INDEX `idx_coll` (`collection_id`), 0020 INDEX `idx_file` (`file_id`) 0021 ) 0022 ENGINE MyISAM 0023 AS 0024 SELECT `f`.`owner_id`, `f`.`collection_id`, `f`.`file_id`, COUNT(1) AS `count_dl` 0025 FROM `ppload`.`ppload_files_downloaded` `f` 0026 WHERE `f`.`downloaded_timestamp` < DATE_FORMAT(NOW(), '%Y-%m-%d 00:00:00') 0027 GROUP BY `f`.`collection_id`, `f`.`file_id`; 0028 RENAME TABLE `ppload`.`stat_ppload_files_downloaded` TO `ppload`.`old_stat_ppload_files_downloaded`, `ppload`.`tmp_stat_ppload_files_downloaded` TO `ppload`.`stat_ppload_files_downloaded`; 0029 DROP TABLE IF EXISTS `ppload`.`old_stat_ppload_files_downloaded`; 0030 0031 0032 END$$ 0033 0034 DELIMITER ; 0035 0036 0037 CREATE EVENT `e_generate_stat_files_downloaded` 0038 ON SCHEDULE 0039 EVERY 1 DAY STARTS '2019-05-01 00:00:00' 0040 ON COMPLETION PRESERVE 0041 ENABLE 0042 COMMENT 'Regenerates ppload.stat_ppload_files_downloaded table' 0043 DO CALL generate_stat_files_downloaded() 0044 ;