 ,`final_value_pre` decimal(48,0)
 ,`final_value_cur` decimal(48,0)
 ,`subtask_share_holder_count` bigint(21)
+,`subtask_type_unlockable` tinyint(1)
 );
 
 -- --------------------------------------------------------

DROP TABLE IF EXISTS `lc60_successful_subtask_category_complete_inner`;

CREATE ALGORITHM=UNDEFINED DEFINER=`tggtt`@`localhost` SQL SECURITY DEFINER VIEW `lc60_successful_subtask_category_complete_inner`  AS  select `successful_subtask_category`.`participant_id` AS `participant_id`,`subtask_category`.`id` AS `subtask_category_id`,`successful_subtask_category`.`subtask_category_count` AS `subtask_category_count` from (`lc60_subtask_categories` `subtask_category` join `lc60_successful_subtask_category` `successful_subtask_category` on((`subtask_category`.`id` = `successful_subtask_category`.`subtask_category_id`))) union select `participant`.`id` AS `participant_id`,`subtask_category`.`id` AS `subtask_category_id`,0 AS `subtask_category_count` from (`lc60_participants` `participant` join `lc60_subtask_categories` `subtask_category`) ;

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


  `id` tinyint(4) NOT NULL,
  `subtask_type_name` varchar(32) NOT NULL,
  `subtask_type_ownable` tinyint(1) UNSIGNED DEFAULT '1',
  `subtask_type_shareable` tinyint(1) UNSIGNED DEFAULT '1',
  `subtask_type_unlockable` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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