U23GtMX3

1ALTER TABLE `sms_sending_campaign` ADD `campaign_delay` VARCHAR(50) NOT NULL AFTER `is_try_again`;
2
3INSERT INTO `menu` (`name`, `icon`, `url`, `serial`, `module_access`, `have_child`, `only_admin`, `only_member`, `add_ons_id`, `is_external`, `header_text`, `is_menu_manager`, `custom_page_id`) VALUES('Visual Flow Builder', 'fas fa-project-diagram', 'visual_flow_builder/flowbuilder_manager', (SELECT serial FROM menu as menu2 WHERE url='messenger_bot'), '315', '0', '0', '0', 0, '0', '', '0', 0);
4
5INSERT INTO `menu_child_1` (`name`, `url`, `serial`, `icon`, `module_access`, `parent_id`, `have_child`, `only_admin`, `only_member`, `is_external`, `is_menu_manager`, `custom_page_id`) VALUES('Check Update v2', 'update_system/update_list_v2', (SELECT serial FROM menu_child_1 as menu_child_copy WHERE url='update_system/index'), 'fas fa-leaf', '', (SELECT parent_id FROM menu_child_1 as menu_child_copy WHERE url='update_system/index'), '0', '1', '0', '0', '0', '0');
6
7ALTER TABLE `messenger_bot` ADD `visual_flow_type` ENUM('flow','general') NOT NULL DEFAULT 'general' AFTER `drip_campaign_id`, ADD `visual_flow_campaign_id` INT(11) NOT NULL AFTER `visual_flow_type`;
8
9ALTER TABLE `messenger_bot_postback` ADD `visual_flow_type` ENUM('flow','general') NOT NULL DEFAULT 'general' AFTER `drip_campaign_id`, ADD `visual_flow_campaign_id` INT(11) NOT NULL AFTER `visual_flow_type`;
10
11ALTER TABLE `auto_comment_reply_info` ADD INDEX (`auto_comment_template_id`);
12
13ALTER TABLE `auto_comment_reply_info` ADD INDEX (`auto_private_reply_status`);
14
15ALTER TABLE `auto_comment_reply_info` ADD INDEX(`user_id`);
16
17ALTER TABLE `auto_comment_reply_info` ADD `social_media_type` ENUM('Facebook','Instagram') NOT NULL DEFAULT 'Facebook' AFTER `deleted`;
18
19ALTER TABLE `auto_comment_reply_info` ADD `insta_media_url` VARCHAR(50) NOT NULL AFTER `social_media_type`;
20
21INSERT INTO `menu_child_1` (`name`, `url`, `serial`, `icon`, `module_access`, `parent_id`, `have_child`, `only_admin`, `only_member`, `is_external`, `is_menu_manager`, `custom_page_id`) VALUES('Comment Template', 'comment_automation/comment_template_manager', 0, 'fa fa-comment-dots', '278,279', (SELECT id FROM menu WHERE module_access='278,279'), '0', '0', '0', '0', '0', '0');
22
23INSERT INTO `menu_child_1` (`name`, `url`, `serial`, `icon`, `module_access`, `parent_id`, `have_child`, `only_admin`, `only_member`, `is_external`, `is_menu_manager`, `custom_page_id`) VALUES('Reply Template', 'instagram_reply/template_manager', 0, 'fa fa-reply-all', '278,279', (SELECT id FROM menu WHERE module_access='278,279'), '0', '0', '0', '0', '0', '0');
24
25CREATE TABLE IF NOT EXISTS `instagram_reply_template` ( `id` int(11) NOT NULL AUTO_INCREMENT, `auto_reply_campaign_name` varchar(255) DEFAULT NULL, `user_id` int(11) NOT NULL, `reply_type` varchar(200) NOT NULL, `multiple_reply` enum('no','yes') NOT NULL, `nofilter_word_found_text` longtext NOT NULL, `auto_reply_text` longtext NOT NULL, `last_updated_at` datetime NOT NULL, `error_message` text NOT NULL, `hide_comment_after_comment_reply` enum('no','yes') NOT NULL, `is_delete_offensive` enum('hide','delete') NOT NULL, `offensive_words` longtext NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
26
27UPDATE `version` SET `current`='0';
28
29INSERT INTO version(version, current, date) VALUES ('6.1','1',CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE version='6.1',current='1',date=CURRENT_TIMESTAMP;
30
31