Xerochat 6.1 update

ALTER TABLE `sms_sending_campaign` ADD `campaign_delay` VARCHAR(50) NOT NULL AFTER `is_try_again`;

INSERT 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);

INSERT 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');

ALTER 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`;

ALTER 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`;

ALTER TABLE `auto_comment_reply_info` ADD INDEX (`auto_comment_template_id`);

ALTER TABLE `auto_comment_reply_info` ADD INDEX (`auto_private_reply_status`);

ALTER TABLE `auto_comment_reply_info` ADD INDEX(`user_id`);

ALTER TABLE `auto_comment_reply_info` ADD `social_media_type` ENUM('Facebook','Instagram') NOT NULL DEFAULT 'Facebook' AFTER `deleted`;

ALTER TABLE `auto_comment_reply_info` ADD `insta_media_url` VARCHAR(50) NOT NULL AFTER `social_media_type`;

INSERT 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');

INSERT 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');

CREATE 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;

UPDATE `version` SET `current`='0';

INSERT INTO version(version, CURRENT, DATE) VALUES ('6.1','1',CURRENT_TIMESTAMP) ON DUPLICATE KEY UPDATE version='6.1',CURRENT='1',DATE=CURRENT_TIMESTAMP;