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

--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` int UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `rfq_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `notify_by` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `bidder_message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  `conversation_id` varchar(22) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `display_status` int UNSIGNED NOT NULL DEFAULT '0',
  `message_datetime` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `username` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `notify_to` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '',
  `stage` varchar(55) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT '0',
  `mature_to` int DEFAULT NULL,
  `notification_id` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `chat_id` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `final_result` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `price` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `chats`
--

INSERT INTO `chats` (`id`, `deleted_at`, `created_at`, `updated_at`, `rfq_id`, `notify_by`, `message`, `bidder_message`, `conversation_id`, `display_status`, `message_datetime`, `username`, `notify_to`, `stage`, `mature_to`, `notification_id`, `chat_id`, `quantity`, `final_result`, `price`) VALUES
(2460, NULL, '2025-01-03 05:26:51', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '629', '', 0, '', 0),
(2461, NULL, '2025-01-03 05:26:53', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '630', '', 0, '', 0),
(2462, NULL, '2025-01-03 05:26:58', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '631', '', 0, '', 0),
(2463, NULL, '2025-01-03 05:27:10', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '632', '', 0, '', 0),
(2464, NULL, '2025-01-03 05:27:10', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '633', '', 0, '', 0),
(2465, NULL, '2025-01-03 05:27:10', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '634', '', 0, '', 0),
(2466, NULL, '2025-01-03 05:27:11', NULL, '10478', '4482', '', '', '', 0, NULL, '0', '4481', '', NULL, '635', '', 0, '', 0),
(2467, NULL, '2025-03-04 10:13:31', '2025-03-04 10:13:31', 'rfq_id', 'snd_from', 'f_msg', 'f_msg', 'ct_rd_id', 0, NULL, '0', 'to', 'chat_stage', NULL, '636', '', 0, '', 0),
(2468, '2026-04-21 11:25:54', '2026-04-21 11:25:40', '2026-04-21 11:25:54', '10841', '2', 'Hello  Ji ,  We are interested to Sell \n						  Product : posted vide Rfq ID  and our counter offer is as follows. <br> Price : 5200<br> Quantity : 150Double <br>Bid Valid Till one : 1 hours <br> Let us know if you can accept these terms.', 'Hello  Ji ,  We are interested to Sell \n						  Product : posted vide Rfq ID  and our counter offer is as follows. <br> Price : 5200<br> Quantity : 150Double <br>Bid Valid Till one : 1 hours <br> Let us know if you can accept these terms.', '5d7eJgVqIP', 0, NULL, 'Karan Sahota', '1', 'first', NULL, '637', '', 150, '', 5200),
(2469, NULL, '2026-07-14 05:59:35', '2026-07-14 05:59:35', '10839', '1', 'Hello  Ji ,  We are interested to Sell \n						  Product : posted vide Rfq ID  and our counter offer is as follows. <br> Price : 10500<br> Quantity : 100Double <br>Bid Valid Till one : 1 hours <br> Let us know if you can accept these terms.', 'Hello  Ji ,  We are interested to Sell \n						  Product : posted vide Rfq ID  and our counter offer is as follows. <br> Price : 10500<br> Quantity : 100Double <br>Bid Valid Till one : 1 hours <br> Let us know if you can accept these terms.', 'Phw9WQqdC0', 1, NULL, 'Vishal Narang', '1', 'first', NULL, '638', '', 100, '', 10500);
