|
CREATE VIEW `tv_task_info_view` AS SELECT `ttf`.`id` AS `id`, `ttf`.`parent_id` AS `parent_id`, `ttf`.`task_topic_Id` AS `task_topic_Id`, `ttf`.`sub_task_type` AS `sub_task_type`, `ttf`.`status` AS `status`, `ttf`.`total_operation_num` AS `total_operation_num`, `ttf`.`total_success_operation_num` AS `total_success_operation_num`, `ttf`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttf`.`create_time` AS `create_time`, `ttf`.`error_message` AS `error_message`, `ttf`.`user_id` AS `user_id` FROM `tb_twitter_forward_task` `ttf` UNION ALL SELECT `ttr`.`id` AS `id`, `ttr`.`parent_id` AS `parent_id`, `ttr`.`task_topic_Id` AS `task_topic_Id`, `ttr`.`sub_task_type` AS `sub_task_type`, `ttr`.`status` AS `status`, `ttr`.`total_operation_num` AS `total_operation_num`, `ttr`.`total_success_operation_num` AS `total_success_operation_num`, `ttr`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttr`.`create_time` AS `create_time`, `ttr`.`error_message` AS `error_message`, `ttr`.`user_id` AS `user_id` FROM `tb_twitter_reply_task` `ttr` UNION ALL SELECT `tts`.`id` AS `id`, `tts`.`parent_id` AS `parent_id`, `tts`.`task_topic_Id` AS `task_topic_Id`, `tts`.`sub_task_type` AS `sub_task_type`, `tts`.`status` AS `status`, `tts`.`total_operation_num` AS `total_operation_num`, `tts`.`total_success_operation_num` AS `total_success_operation_num`, `tts`.`total_failed_operation_num` AS `total_failed_operation_num`, `tts`.`create_time` AS `create_time`, `tts`.`error_message` AS `error_message`, `tts`.`user_id` AS `user_id` FROM `tb_twitter_send_task` `tts` UNION ALL SELECT `tnp`.`id` AS `id`, `tnp`.`parent_id` AS `parent_id`, `tnp`.`task_topic_Id` AS `task_topic_Id`, `tnp`.`sub_task_type` AS `sub_task_type`, `tnp`.`status` AS `status`, `tnp`.`total_operation_num` AS `total_operation_num`, `tnp`.`total_success_operation_num` AS `total_success_operation_num`, `tnp`.`total_failed_operation_num` AS `total_failed_operation_num`, `tnp`.`create_time` AS `create_time`, `tnp`.`error_message` AS `error_message`, `tnp`.`user_id` AS `user_id` FROM `tb_news_praise_task` `tnp` UNION ALL SELECT `tvt`.`id` AS `id`, `tvt`.`parent_id` AS `parent_id`, `tvt`.`task_topic_Id` AS `task_topic_Id`, `tvt`.`sub_task_type` AS `sub_task_type`, `tvt`.`status` AS `status`, `tvt`.`total_operation_num` AS `total_operation_num`, `tvt`.`total_success_operation_num` AS `total_success_operation_num`, `tvt`.`total_failed_operation_num` AS `total_failed_operation_num`, `tvt`.`create_time` AS `create_time`, `tvt`.`error_message` AS `error_message`, `tvt`.`user_id` AS `user_id` FROM `tb_vote_task` `tvt` UNION ALL SELECT `tnr`.`id` AS `id`, `tnr`.`parent_id` AS `parent_id`, `tnr`.`task_topic_Id` AS `task_topic_Id`, `tnr`.`sub_task_type` AS `sub_task_type`, `tnr`.`status` AS `status`, `tnr`.`total_operation_num` AS `total_operation_num`, `tnr`.`total_success_operation_num` AS `total_success_operation_num`, `tnr`.`total_failed_operation_num` AS `total_failed_operation_num`, `tnr`.`create_time` AS `create_time`, `tnr`.`error_message` AS `error_message`, `tnr`.`user_id` AS `user_id` FROM `tb_news_batch_reply_task` `tnr` UNION ALL SELECT `ttp`.`id` AS `id`, `ttp`.`parent_id` AS `parent_id`, `ttp`.`task_topic_Id` AS `task_topic_Id`, `ttp`.`sub_task_type` AS `sub_task_type`, `ttp`.`status` AS `status`, `ttp`.`total_operation_num` AS `total_operation_num`, `ttp`.`total_success_operation_num` AS `total_success_operation_num`, `ttp`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttp`.`create_time` AS `create_time`, `ttp`.`error_message` AS `error_message`, `ttp`.`user_id` AS `user_id` FROM `tb_twitter_praise_task` `ttp` UNION ALL SELECT `tsk`.`id` AS `id`, `tsk`.`parent_id` AS `parent_id`, `tsk`.`task_topic_Id` AS `task_topic_Id`, `tsk`.`sub_task_type` AS `sub_task_type`, `tsk`.`status` AS `status`, `tsk`.`total_operation_num` AS `total_operation_num`, `tsk`.`total_success_operation_num` AS `total_success_operation_num`, `tsk`.`total_failed_operation_num` AS `total_failed_operation_num`, `tsk`.`create_time` AS `create_time`, `tsk`.`error_message` AS `error_message`, `tsk`.`user_id` AS `user_id` FROM `tb_search_keyword_task` `tsk` UNION ALL SELECT `tec`.`id` AS `id`, `tec`.`parent_id` AS `parent_id`, `tec`.`task_topic_Id` AS `task_topic_Id`, `tec`.`sub_task_type` AS `sub_task_type`, `tec`.`status` AS `status`, `tec`.`total_operation_num` AS `total_operation_num`, `tec`.`total_success_operation_num` AS `total_success_operation_num`, `tec`.`total_failed_operation_num` AS `total_failed_operation_num`, `tec`.`create_time` AS `create_time`, `tec`.`error_message` AS `error_message`, `tec`.`user_id` AS `user_id` FROM `tb_effect_check_task` `tec` UNION ALL SELECT `tap`.`id` AS `id`, `tap`.`parent_id` AS `parent_id`, `tap`.`task_topic_Id` AS `task_topic_Id`, `tap`.`sub_task_type` AS `sub_task_type`, `tap`.`status` AS `status`, `tap`.`total_operation_num` AS `total_operation_num`, `tap`.`total_success_operation_num` AS `total_success_operation_num`, `tap`.`total_failed_operation_num` AS `total_failed_operation_num`, `tap`.`create_time` AS `create_time`, `tap`.`error_message` AS `error_message`, `tap`.`user_id` AS `user_id` FROM `tb_app_praise_task` `tap` UNION ALL SELECT `tab`.`id` AS `id`, `tab`.`parent_id` AS `parent_id`, `tab`.`task_topic_Id` AS `task_topic_Id`, `tab`.`sub_task_type` AS `sub_task_type`, `tab`.`status` AS `status`, `tab`.`total_operation_num` AS `total_operation_num`, `tab`.`total_success_operation_num` AS `total_success_operation_num`, `tab`.`total_failed_operation_num` AS `total_failed_operation_num`, `tab`.`create_time` AS `create_time`, `tab`.`error_message` AS `error_message`, `tab`.`user_id` AS `user_id` FROM `tb_app_batch_reply_task` `tab` UNION ALL SELECT `tnb`.`id` AS `id`, `tnb`.`parent_id` AS `parent_id`, `tnb`.`task_topic_Id` AS `task_topic_Id`, `tnb`.`sub_task_type` AS `sub_task_type`, `tnb`.`status` AS `status`, `tnb`.`total_operation_num` AS `total_operation_num`, `tnb`.`total_success_operation_num` AS `total_success_operation_num`, `tnb`.`total_failed_operation_num` AS `total_failed_operation_num`, `tnb`.`create_time` AS `create_time`, `tnb`.`error_message` AS `error_message`, `tnb`.`user_id` AS `user_id` FROM `tb_news_building_task` `tnb` UNION ALL SELECT `ttb`.`id` AS `id`, `ttb`.`parent_id` AS `parent_id`, `ttb`.`task_topic_Id` AS `task_topic_Id`, `ttb`.`sub_task_type` AS `sub_task_type`, `ttb`.`status` AS `status`, `ttb`.`total_operation_num` AS `total_operation_num`, `ttb`.`total_success_operation_num` AS `total_success_operation_num`, `ttb`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttb`.`create_time` AS `create_time`, `ttb`.`error_message` AS `error_message`, `ttb`.`user_id` AS `user_id` FROM `tb_twitter_building_task` `ttb` UNION ALL SELECT `tfb`.`id` AS `id`, `tfb`.`parent_id` AS `parent_id`, `tfb`.`task_topic_Id` AS `task_topic_Id`, `tfb`.`sub_task_type` AS `sub_task_type`, `tfb`.`status` AS `status`, `tfb`.`total_operation_num` AS `total_operation_num`, `tfb`.`total_success_operation_num` AS `total_success_operation_num`, `tfb`.`total_failed_operation_num` AS `total_failed_operation_num`, `tfb`.`create_time` AS `create_time`, `tfb`.`error_message` AS `error_message`, `tfb`.`user_id` AS `user_id` FROM `tb_forum_building_task` `tfb` UNION ALL SELECT `tfr`.`id` AS `id`, `tfr`.`parent_id` AS `parent_id`, `tfr`.`task_topic_Id` AS `task_topic_Id`, `tfr`.`sub_task_type` AS `sub_task_type`, `tfr`.`status` AS `status`, `tfr`.`total_operation_num` AS `total_operation_num`, `tfr`.`total_success_operation_num` AS `total_success_operation_num`, `tfr`.`total_failed_operation_num` AS `total_failed_operation_num`, `tfr`.`create_time` AS `create_time`, `tfr`.`error_message` AS `error_message`, `tfr`.`user_id` AS `user_id` FROM `tb_forum_reply_task` `tfr` UNION ALL SELECT `tfs`.`id` AS `id`, `tfs`.`parent_id` AS `parent_id`, `tfs`.`task_topic_Id` AS `task_topic_Id`, `tfs`.`sub_task_type` AS `sub_task_type`, `tfs`.`status` AS `status`, `tfs`.`total_operation_num` AS `total_operation_num`, `tfs`.`total_success_operation_num` AS `total_success_operation_num`, `tfs`.`total_failed_operation_num` AS `total_failed_operation_num`, `tfs`.`create_time` AS `create_time`, `tfs`.`error_message` AS `error_message`, `tfs`.`user_id` AS `user_id` FROM `tb_forum_send_task` `tfs` UNION ALL SELECT `ttrt`.`id` AS `id`, `ttrt`.`parent_id` AS `parent_id`, `ttrt`.`task_topic_Id` AS `task_topic_Id`, `ttrt`.`sub_task_type` AS `sub_task_type`, `ttrt`.`status` AS `status`, `ttrt`.`total_operation_num` AS `total_operation_num`, `ttrt`.`total_success_operation_num` AS `total_success_operation_num`, `ttrt`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttrt`.`create_time` AS `create_time`, `ttrt`.`error_message` AS `error_message`, `ttrt`.`user_id` AS `user_id` FROM `tb_tieba_reply_task` `ttrt` UNION ALL SELECT `ttst`.`id` AS `id`, `ttst`.`parent_id` AS `parent_id`, `ttst`.`task_topic_Id` AS `task_topic_Id`, `ttst`.`sub_task_type` AS `sub_task_type`, `ttst`.`status` AS `status`, `ttst`.`total_operation_num` AS `total_operation_num`, `ttst`.`total_success_operation_num` AS `total_success_operation_num`, `ttst`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttst`.`create_time` AS `create_time`, `ttst`.`error_message` AS `error_message`, `ttst`.`user_id` AS `user_id` FROM `tb_tieba_send_task` `ttst` UNION ALL SELECT `ttbt`.`id` AS `id`, `ttbt`.`parent_id` AS `parent_id`, `ttbt`.`task_topic_Id` AS `task_topic_Id`, `ttbt`.`sub_task_type` AS `sub_task_type`, `ttbt`.`status` AS `status`, `ttbt`.`total_operation_num` AS `total_operation_num`, `ttbt`.`total_success_operation_num` AS `total_success_operation_num`, `ttbt`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttbt`.`create_time` AS `create_time`, `ttbt`.`error_message` AS `error_message`, `ttbt`.`user_id` AS `user_id` FROM `tb_tieba_building_task` `ttbt` UNION ALL SELECT `ttrp`.`id` AS `id`, `ttrp`.`parent_id` AS `parent_id`, `ttrp`.`task_topic_Id` AS `task_topic_Id`, `ttrp`.`sub_task_type` AS `sub_task_type`, `ttrp`.`status` AS `status`, `ttrp`.`total_operation_num` AS `total_operation_num`, `ttrp`.`total_success_operation_num` AS `total_success_operation_num`, `ttrp`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttrp`.`create_time` AS `create_time`, `ttrp`.`error_message` AS `error_message`, `ttrp`.`user_id` AS `user_id` FROM `tb_twitter_reply_praise_task` `ttrp` UNION ALL SELECT `ttrr`.`id` AS `id`, `ttrr`.`parent_id` AS `parent_id`, `ttrr`.`task_topic_Id` AS `task_topic_Id`, `ttrr`.`sub_task_type` AS `sub_task_type`, `ttrr`.`status` AS `status`, `ttrr`.`total_operation_num` AS `total_operation_num`, `ttrr`.`total_success_operation_num` AS `total_success_operation_num`, `ttrr`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttrr`.`create_time` AS `create_time`, `ttrr`.`error_message` AS `error_message`, `ttrr`.`user_id` AS `user_id` FROM `tb_twitter_reply_reply_task` `ttrr` UNION ALL SELECT `ttat`.`id` AS `id`, `ttat`.`parent_id` AS `parent_id`, `ttat`.`task_topic_Id` AS `task_topic_Id`, `ttat`.`sub_task_type` AS `sub_task_type`, `ttat`.`status` AS `status`, `ttat`.`total_operation_num` AS `total_operation_num`, `ttat`.`total_success_operation_num` AS `total_success_operation_num`, `ttat`.`total_failed_operation_num` AS `total_failed_operation_num`, `ttat`.`create_time` AS `create_time`, `ttat`.`error_message` AS `error_message`, `ttat`.`user_id` AS `user_id` FROM `tb_twitter_attention_task` `ttat` |
|
|
