File indexing completed on 2024-04-21 06:00:36 

0001 CREATE TABLE `stat_page_views_48h` LIKE `stat_page_views`;
0002 
0003 DELIMITER $$
0004 DROP TRIGGER IF EXISTS `stat_page_views_AFTER_INSERT`$$
0005 CREATE TRIGGER `stat_page_views_AFTER_INSERT`
0006     AFTER INSERT
0007     ON `stat_page_views`
0008     FOR EACH ROW
0009 BEGIN
0010     #insert also into table stat_page_views_48h
0011     INSERT INTO `stat_page_views_48h` (`stat_page_views_id`, `project_id`, `ip`, `member_id`, `created_at`)
0012     VALUES (`new`.`stat_page_views_id`, `new`.`project_id`, `new`.`ip`, `new`.`member_id`, `new`.`created_at`);
0013 END$$
0014 
0015 
0016 DROP EVENT IF EXISTS `e_generate_page_views_48h`;
0017 CREATE EVENT `e_generate_page_views_48h`
0018     ON SCHEDULE
0019         EVERY 1 DAY STARTS '2018-11-20 05:00:00'
0020     ON COMPLETION PRESERVE
0021     ENABLE
0022     COMMENT 'Delete old page_view data from table stat_page_views_48h'
0023     DO
0024     DELETE
0025     FROM `stat_page_views_48h`
0026     WHERE `created_at` <= subdate(now(), 2);
0027 
0028 
0029 DELIMITER ;