CREATE TABLE `tblnew_feature_announcements` (
    `id` BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL,
    `name` varchar(191) NOT NULL,
	`mobile_type` enum('android','ios','web') COLLATE utf8mb4_unicode_ci NOT NULL,
    `mobile_app_version` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `data` text DEFAULT NULL,
    `navigation_data` text DEFAULT NULL,
    `show_to_staff` tinyint(1) DEFAULT 0,
	`is_active` tinyint(4) DEFAULT 1,
    `added_by_admin_id` bigint(20) DEFAULT NULL,
    `updated_by_admin_id` bigint(20) DEFAULT NULL,
    `added_on` datetime DEFAULT NULL,
    `updated_on` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `tbldismissed_new_feature_announcements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` bigint(20) unsigned NOT NULL,
  `staff_id` bigint(20) unsigned NOT NULL,
  `feature_announcement_id` bigint(20) unsigned NOT NULL,
  `added_on` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

insert into `tblnew_feature_announcements` (`id`, `name`, `mobile_type`, `mobile_app_version`, `data`, `navigation_data`, `show_to_staff`, `is_active`, `added_by_admin_id`, `updated_by_admin_id`, `added_on`, `updated_on`) values('1','Mileage Log','android','6.5.1','[{\"slide_no\":\"1\",\"slide_img_src\":\"live_map.png\",\"slide_title\":\"THE LIVE MAP BETA IS NOW AVAILABLE\",\"slide_desc\":\"Now you can track your employees while they\'re out in the field.\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"2\",\"slide_img_src\":\"track_mileage.png\",\"slide_title\":\"YOU CAN ALSO NOW TRACK MILEAGE!\",\"slide_desc\":\"Just like you\'d track your employees time, you can track their mileage!\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"3\",\"slide_img_src\":\"improvement.png\",\"slide_title\":\"MORE IMPROVEMENTS ON THE WAY!\",\"slide_desc\":\"We have a lot in the works to improve both of these features. We\'ll let you know as they continually improve.\",\"slide_btn_text\":\"Let\'s GO!\",\"is_last_slide\":\"1\"}]','{\"link_type\":\"internal_activity\",\"link_data\":{\"android\":{\"internal_activity\":{\"nav_graph_key\":\"nav_mileage_log\",\"data\":[]},\"internal_webview\":{\"showHeader\":\"\",\"title\":\"\",\"internal_webview_url\":\"\",\"contrefresh\":\"\"},\"external_webview\":{\"external_webview_url\":\"\"}},\"ios\":{\"internal_activity\":{\"story_vc_key\":\"mileage_log\"},\"internal_webview\":{\"showHeader\":\"\",\"title\":\"\",\"internal_webview_url\":\"\",\"contrefresh\":\"\"},\"external_webview\":{\"external_webview_url\":\"\"}}}}','0','1','1','1','2023-02-09 15:23:06','2023-02-09 15:23:06');
insert into `tblnew_feature_announcements` (`id`, `name`, `mobile_type`, `mobile_app_version`, `data`, `navigation_data`, `show_to_staff`, `is_active`, `added_by_admin_id`, `updated_by_admin_id`, `added_on`, `updated_on`) values('2','Mileage Log','ios','4.5.1','[{\"slide_no\":\"1\",\"slide_img_src\":\"live_map.png\",\"slide_title\":\"THE LIVE MAP BETA IS NOW AVAILABLE\",\"slide_desc\":\"Now you can track your employees while they\'re out in the field.\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"2\",\"slide_img_src\":\"track_mileage.png\",\"slide_title\":\"YOU CAN ALSO NOW TRACK MILEAGE!\",\"slide_desc\":\"Just like you\'d track your employees time, you can track their mileage!\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"3\",\"slide_img_src\":\"improvement.png\",\"slide_title\":\"MORE IMPROVEMENTS ON THE WAY!\",\"slide_desc\":\"We have a lot in the works to improve both of these features. We\'ll let you know as they continually improve.\",\"slide_btn_text\":\"Let\'s GO!\",\"is_last_slide\":\"1\"}]','{\"link_type\":\"internal_activity\",\"link_data\":{\"android\":{\"internal_activity\":{\"nav_graph_key\":\"nav_mileage_log\",\"data\":[]},\"internal_webview\":{\"showHeader\":\"\",\"title\":\"\",\"internal_webview_url\":\"\",\"contrefresh\":\"\"},\"external_webview\":{\"external_webview_url\":\"\"}},\"ios\":{\"internal_activity\":{\"story_vc_key\":\"mileage_log\"},\"internal_webview\":{\"showHeader\":\"\",\"title\":\"\",\"internal_webview_url\":\"\",\"contrefresh\":\"\"},\"external_webview\":{\"external_webview_url\":\"\"}}}}','0','1','1','1','2023-02-09 15:23:06','2023-02-09 15:23:06');
insert into `tblnew_feature_announcements` (`id`, `name`, `mobile_type`, `mobile_app_version`, `data`, `navigation_data`, `show_to_staff`, `is_active`, `added_by_admin_id`, `updated_by_admin_id`, `added_on`, `updated_on`) values('3','Mileage Log','web','','[{\"slide_no\":\"1\",\"slide_img_src\":\"live_map.svg\",\"slide_title\":\"THE LIVE MAP BETA IS NOW AVAILABLE\",\"slide_desc\":\"Now you can track your employees while they\'re out in the field.\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"2\",\"slide_img_src\":\"track_mileage.svg\",\"slide_title\":\"YOU CAN ALSO NOW TRACK MILEAGE!\",\"slide_desc\":\"Just like you\'d track your employees time, you can track their mileage!\",\"slide_btn_text\":\"Next\",\"is_last_slide\":\"0\"},{\"slide_no\":\"3\",\"slide_img_src\":\"improvement.svg\",\"slide_title\":\"MORE IMPROVEMENTS ON THE WAY!\",\"slide_desc\":\"We have a lot in the works to improve both of these features. We\'ll let you know as they continually improve.\",\"slide_btn_text\":\"Let\'s GO!\",\"is_last_slide\":\"1\"}]','mileage_logs','0','1','1','1','2023-02-09 15:23:06','2023-02-09 15:23:06');
