File indexing completed on 2024-04-28 13:54:19
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 ;