 ,`subtask_starting_demand` tinyint(4)
 ,`subtask_inflation_rate` decimal(4,1)
 ,`subtask_demand_cutoff` tinyint(4)
+,`subtask_bonus_base` tinyint(4)
 ,`subtask_task_period_demand` tinyint(4)
 ,`subtask_description` text
 ,`subtask_url` varchar(48)

,`subtask_max_value` tinyint(4)
,`subtask_inflation_rate` decimal(4,1)
,`subtask_demand_cutoff` tinyint(4)
,`subtask_description` text
,`subtask_url` varchar(48)
,`subtask_accumulative` tinyint(4)

--
DROP TABLE IF EXISTS `lc60_calculated_subtask_demand_external`;

CREATE ALGORITHM=UNDEFINED DEFINER=`tggtt`@`localhost` SQL SECURITY DEFINER VIEW `lc60_calculated_subtask_demand_external` AS select `calculated_subtask_demand_inner`.`current_task_id` AS `current_task_id`,`calculated_subtask_demand_inner`.`contemporary_task_id` AS `contemporary_task_id`,`calculated_subtask_demand_inner`.`subtask_id` AS `subtask_id`,`calculated_subtask_demand_inner`.`subtask_starting_demand` AS `subtask_starting_demand`,`calculated_subtask_demand_inner`.`subtask_success_count` AS `subtask_success_count`,`calculated_subtask_demand_inner`.`subtask_success_count_total` AS `subtask_success_count_total`,`calculated_subtask_demand_inner`.`subtask_task_period_demand` AS `subtask_task_period_demand`,`calculated_subtask_demand_inner`.`subtask_task_id` AS `subtask_task_id`,`calculated_subtask_demand_inner`.`subtask_super_id` AS `subtask_super_id`,`calculated_subtask_demand_inner`.`subtask_name` AS `subtask_name`,`calculated_subtask_demand_inner`.`subtask_category_id` AS `subtask_category_id`,`calculated_subtask_demand_inner`.`subtask_base_value` AS `subtask_base_value`,`calculated_subtask_demand_inner`.`subtask_max_value` AS `subtask_max_value`,`calculated_subtask_demand_inner`.`subtask_inflation_rate` AS `subtask_inflation_rate`,`calculated_subtask_demand_inner`.`subtask_demand_cutoff` AS `subtask_demand_cutoff`,`calculated_subtask_demand_inner`.`subtask_bonus_base` AS `subtask_bonus_base`,`calculated_subtask_demand_inner`.`subtask_description` AS `subtask_description`,`calculated_subtask_demand_inner`.`subtask_url` AS `subtask_url`,`calculated_subtask_demand_inner`.`subtask_accumulative` AS `subtask_accumulative`,`calculated_subtask_demand_inner`.`subtask_owner_participant_id` AS `subtask_owner_participant_id`,`calculated_subtask_demand_inner`.`subtask_dividend_rate` AS `subtask_dividend_rate`,`calculated_subtask_demand_inner`.`subtask_category_name` AS `subtask_category_name`,`calculated_subtask_demand_inner`.`subtask_category_class` AS `subtask_category_class`,`calculated_subtask_demand_inner`.`subtask_category_description` AS `subtask_category_description`,`calculated_subtask_demand_inner`.`contemporary_demand` AS `contemporary_demand`,`calculated_subtask_demand_inner`.`contemporary_demand_positive` AS `contemporary_demand_positive`,`calculated_subtask_demand_inner`.`inner_function` AS `inner_function`,(`calculated_subtask_demand_inner`.`inner_function` * `calculated_subtask_demand_inner`.`subtask_bonus_base`) AS `external_function` from `lc60_calculated_subtask_demand_inner` `calculated_subtask_demand_inner`;

-- --------------------------------------------------------

