-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.18-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             12.4.0.6659
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table chatbox_db.bot_msgs
CREATE TABLE IF NOT EXISTS `bot_msgs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `actor_id` bigint(20) unsigned DEFAULT NULL,
  `fk_bot_info` int(10) unsigned DEFAULT NULL,
  `sequence` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_last_sequence` tinyint(4) DEFAULT NULL,
  `coming_answ` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_template` tinyint(4) DEFAULT NULL,
  `template_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_externalaction` tinyint(4) DEFAULT NULL,
  `is_context_check` tinyint(4) DEFAULT NULL,
  `template_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `bot_msgs_actor_id_foreign` (`actor_id`),
  KEY `fk_bot_info` (`fk_bot_info`),
  CONSTRAINT `bot_msgs_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `bot_actors` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_bot_info` FOREIGN KEY (`fk_bot_info`) REFERENCES `bot_info` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table chatbox_db.bot_msgs: ~21 rows (approximately)
INSERT INTO `bot_msgs` (`id`, `actor_id`, `fk_bot_info`, `sequence`, `is_last_sequence`, `coming_answ`, `language`, `is_template`, `template_id`, `is_externalaction`, `is_context_check`, `template_name`, `text`, `type`, `status`, `created_at`, `updated_at`) VALUES
	(36, 4, 1, '0', 0, NULL, '4', 0, NULL, NULL, NULL, NULL, 'Welcome to the Kiran Jadhav and Associates', '1', 1, '2023-01-31 12:12:48', NULL),
	(37, 4, 1, '0', NULL, NULL, '4', 0, NULL, NULL, NULL, NULL, 'Do you accept our terms and conditions?\r\n\r\nhttps://www.kiranjadhav.com/disclaimer.php', '3', 1, '2023-01-31 13:07:43', NULL),
	(38, 7, 1, '', NULL, '37.1', '1', 0, NULL, NULL, NULL, NULL, 'Please write your name.', '1', 1, '2023-01-31 14:06:38', NULL),
	(40, 7, 1, '1', 0, '', '1', 0, NULL, NULL, NULL, NULL, 'Please input your cell number(Numbers only)', '1', 1, '2023-01-31 14:56:05', '2023-01-31 14:56:11'),
	(41, 7, 1, '2', NULL, '', '1', 0, NULL, 1, 0, '', 'Kindly enter OTP received on your number given above', '1', 1, '2023-02-01 08:55:38', NULL),
	(42, 7, 1, '', NULL, '1234', '1', 0, NULL, 0, 0, NULL, 'Enter State', '4', 1, '2023-02-02 10:11:22', '2023-02-02 10:11:23'),
	(44, NULL, 1, NULL, NULL, '37.2', '1', 0, NULL, NULL, NULL, NULL, 'Thanks for being here. Please follow us.', NULL, NULL, NULL, NULL),
	(45, NULL, 1, NULL, NULL, '42.1', '1', 0, NULL, NULL, 0, NULL, 'Select City', '2', 1, '2023-03-17 09:12:37', '2023-03-17 09:12:38'),
	(46, NULL, 1, NULL, NULL, '42.2', '1', 0, NULL, NULL, NULL, NULL, 'Select City', '2', 1, '2023-03-17 09:14:20', NULL),
	(47, NULL, 1, NULL, NULL, '42.3', '1', 0, NULL, NULL, NULL, NULL, 'Select City', '2', 1, '2023-03-17 09:14:16', NULL),
	(48, NULL, 1, NULL, NULL, '42.4', '1', 0, NULL, NULL, NULL, NULL, 'Select City', '2', 1, '2023-03-17 09:14:44', '2023-03-17 09:14:45'),
	(49, NULL, 1, NULL, NULL, '45,46', '1', 0, NULL, NULL, NULL, NULL, 'What kind of dream are you looking for?', '2', 1, '2023-03-17 11:30:30', NULL),
	(50, NULL, 1, NULL, NULL, '49', '1', 0, NULL, NULL, NULL, NULL, 'Time frame of this dream?', '2', 1, '2023-03-17 13:40:33', NULL),
	(51, NULL, 1, '', NULL, '50', '1', 0, NULL, NULL, NULL, NULL, 'What is the present cost of your dream (@@@49.1|49.2|49.3@@@)?', '1', 1, '2023-03-18 16:23:53', NULL),
	(52, NULL, 1, '3', NULL, NULL, '1', 0, NULL, 0, NULL, NULL, 'Future value after @@@50.1|50.2|50.3|50.4|50.5|50.6|50.7|50.8|50.9@@@ for this dream would be INR.{{LUMSUM_CALC}}', '1', 1, '2023-03-18 16:41:06', NULL),
	(53, NULL, 1, '3', NULL, NULL, '1', 0, NULL, 0, NULL, NULL, 'How do you want to invest to make your dream cheaper? ', '2', 1, '2023-03-22 08:55:40', NULL),
	(54, NULL, 1, NULL, NULL, '53.1', '1', NULL, NULL, NULL, NULL, NULL, 'We recommend you to start SIP of Rs.{{SIP_CALCU}} in {{RISK_CATEGORY}} mutual funds', '1', 1, NULL, NULL),
	(55, NULL, 1, NULL, NULL, '53.1', '1', NULL, NULL, NULL, NULL, NULL, 'How much amount you can invest per month?', '1', 1, '2023-03-22 19:11:33', NULL),
	(56, NULL, 1, '4', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'Your expected corpus after {{YEARS_PLAN}} would be Rs. {{SIP_DYNAMIC}}. Hence your shortfall for target amount is Rs.{{SYP_DYNAMIC_SHORTFALL}}. Do you want to cover this shortfall? ', '3', 1, '2023-03-22 19:12:58', NULL),
	(57, NULL, 1, NULL, NULL, '56.1', '1', NULL, NULL, NULL, NULL, NULL, 'we recommend you to do Rs. {{PRESENT_VALUE}} one time investment.', '1', 1, '2023-03-23 13:18:31', NULL),
	(58, NULL, 1, NULL, NULL, '56.2', '1', NULL, NULL, NULL, NULL, NULL, 'our representative will be in touch with you. Thanks for contacting Kiran Jadhav and Associates ', '1', 1, NULL, NULL);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
