File indexing completed on 2024-04-21 06:00:36
0001 DROP TABLE `pling`-IMPORT.stat_downloads_24h; 0002 0003 CREATE TABLE `pling`- IMPORT.stat_downloads_24h LIKE ppload.ppload_files_downloaded; 0004 ALTER TABLE `pling`- IMPORT.`stat_downloads_24h` 0005 ADD INDEX `idx_collection_id` (`collection_id`); 0006 0007 DELIMITER $$ 0008 DROP TRIGGER IF EXISTS `ppload`.`ppload_files_downloaded_AFTER_INSERT`$$ 0009 CREATE TRIGGER `ppload`.`ppload_files_downloaded_AFTER_INSERT` 0010 AFTER INSERT 0011 ON `ppload`.`ppload_files_downloaded` 0012 FOR EACH ROW 0013 BEGIN 0014 #insert also into table stat_downloads_24h 0015 INSERT INTO `pling-import`.`stat_downloads_24h` (`id`, 0016 `client_id`, 0017 `owner_id`, 0018 `collection_id`, 0019 `file_id`, 0020 `user_id`, 0021 `referer`, 0022 `downloaded_timestamp`, 0023 `downloaded_ip`) 0024 VALUES (`new`.`id`, 0025 `new`.`client_id`, 0026 `new`.`owner_id`, 0027 `new`.`collection_id`, 0028 `new`.`file_id`, 0029 `new`.`user_id`, 0030 `new`.`referer`, 0031 `new`.`downloaded_timestamp`, 0032 `new`.`downloaded_ip`); 0033 END$$ 0034 0035 DELIMITER ; 0036 0037 0038 DROP EVENT IF EXISTS `e_generate_stat_downloads_24h`; 0039 CREATE EVENT `e_generate_stat_downloads_24h` 0040 ON SCHEDULE 0041 EVERY 1 DAY STARTS '2018-11-30 01:00:00' 0042 ON COMPLETION PRESERVE 0043 ENABLE 0044 COMMENT 'Save download data for the last 24h into table stat_downloads_24h' 0045 DO 0046 TRUNCATE TABLE `stat_downloads_24h`;