File indexing completed on 2024-04-21 06:00:36
0001 ALTER TABLE `project_follower` 0002 ADD COLUMN `source_id` INT(1) UNSIGNED NULL DEFAULT '0' AFTER `created_at`, 0003 ADD COLUMN `source_pk` INT(11) UNSIGNED NULL AFTER `source_id`; 0004 0005 0006 0007 SELECT count(1) 0008 FROM `H01`.`fan` `f` 0009 JOIN `H01`.`users` `u` ON `u`.`userdb` = 0 AND `u`.`login` = `f`.`user` 0010 JOIN `pling`.`project` `p` 0011 ON `p`.`source_id` = 1 AND `p`.`source_pk` = `f`.`contentid` AND `p`.`source_type` = 'project' 0012 JOIN `pling`.`member` `m` 0013 ON `m`.`is_active` = 1 AND `m`.`is_deleted` = 0 AND `m`.`source_id` = 1 AND `m`.`source_pk` = `u`.`id` 0014 WHERE `f`.`userdb` = 0; 0015 0016 0017 INSERT INTO `project_follower` 0018 ( 0019 SELECT NULL AS `project_follower_id`, 0020 `p`.`project_id`, 0021 `m`.`member_id`, 0022 from_unixtime(`f`.`timestamp`) AS `created_at`, 0023 1 AS `source_id`, 0024 `f`.`id` AS `source_pk` 0025 FROM `hive`.`fan` `f` 0026 JOIN `hive`.`users` `u` ON `u`.`userdb` = 0 AND `u`.`login` = `f`.`user` 0027 JOIN `pling-import`.`project` `p` 0028 ON `p`.`source_id` = 1 AND `p`.`source_pk` = `f`.`contentid` AND `p`.`source_type` = 'project' 0029 JOIN `pling-import`.`member` `m` 0030 ON `m`.`is_active` = 1 AND `m`.`is_deleted` = 0 AND `m`.`source_id` = 1 AND 0031 `m`.`source_pk` = `u`.`id` 0032 WHERE `f`.`userdb` = 0 0033 ); 0034 0035