File indexing completed on 2024-04-14 05:53:06
0001 CREATE DEFINER =`root`@`%` EVENT `e_generate_stat_projects_source_url` 0002 ON SCHEDULE 0003 EVERY 5 MINUTE STARTS '2018-11-19 11:57:15' 0004 ON COMPLETION NOT PRESERVE 0005 ENABLE 0006 COMMENT '' 0007 DO 0008 BEGIN 0009 0010 CREATE TABLE `stat_projects_source_url_tmp` 0011 ( 0012 PRIMARY KEY `primary` (`project_id`), 0013 INDEX `idx_proj` (`project_id`), 0014 INDEX `idx_member` (`member_id`), 0015 INDEX `idx_source_url` (`source_url`(50)) 0016 ) 0017 ENGINE MyISAM 0018 AS 0019 SELECT `p`.`project_id`, 0020 `p`.`member_id`, 0021 TRIM(TRAILING '/' FROM `p`.`source_url`) AS `source_url`, 0022 `p`.`created_at`, 0023 `p`.`changed_at` 0024 FROM `stat_projects` `p` 0025 WHERE `p`.`source_url` IS NOT NULL 0026 AND `p`.`source_url` <> '' 0027 AND `p`.`status` = 100; 0028 RENAME TABLE `stat_projects_source_url` TO `stat_projects_source_url_old`; 0029 RENAME TABLE `stat_projects_source_url_tmp` TO `stat_projects_source_url`; 0030 DROP TABLE `stat_projects_source_url_old`; 0031 0032 END