-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 192.168.17.159
-- Generation Time: Jan 23, 2023 at 10:49 AM
-- Server version: 5.6.44-log
-- PHP Version: 7.2.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ycrm_satish`
--

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

--
-- Table structure for table `mst_grid_settings`
--

CREATE TABLE `mst_grid_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `table_id` int(10) UNSIGNED NOT NULL,
  `column_field` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mst_grid_settings`
--

INSERT INTO `mst_grid_settings` (`id`, `table_id`, `column_field`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 2, '[\"lead_id\",\"email\",\"mobile_number\",\"branch_FB_country_code\",\"applicable_for_calling\",\"purpose_of_visit\",\"tentative_travel_month\",\"which_package_you_are_looking_for\",\"interested_for_repatriation\",\"soe_status\",\"soe_counsellor\",\"company_name\",\"status\",\"admission_pool\",\"agent_name\"]', 1, '2022-07-05 11:12:51', '2023-01-17 12:33:57'),
(2, 1, '[\"sr_no\",\"account_name\",\"account_owner\",\"account_type\",\"lead_type\",\"nationality\",\"status\",\"phone\",\"branch_name\",\"email\",\"contract_renewal_date\",\"city\",\"website\",\"region\",\"description\",\"reason_for_dead\",\"account_source\",\"company_manpower_count\",\"last_check_in_date\"]', 1, '2022-07-05 11:13:08', '2022-09-29 11:20:45'),
(3, 3, '[\"salutation\",\"name\",\"suffix\",\"account_name\",\"report_to\",\"birthdate\",\"department\",\"title\",\"email\",\"phone\"]', 1, '2022-07-06 06:06:06', '2022-07-06 06:06:06'),
(4, 1, '[\"account_name\",\"account_owner\",\"account_type\",\"branch_name\",\"email\",\"lead_type\",\"nationality\",\"sr_no\",\"status\"]', 4, '2022-08-08 12:34:45', '2022-08-08 12:34:45'),
(5, 2, '[\"lead_id\",\"name\",\"email\",\"gender\",\"mobile_number\",\"contact_number\",\"branch_FB_country_code\",\"country\",\"branch_name\"]', 5, '2022-08-16 13:55:05', '2022-08-16 13:55:05'),
(6, 2, '[\"lead_id\",\"name\",\"email\",\"gender\",\"mobile_number\",\"contact_number\",\"branch_FB_country_code\",\"country\"]', 2, '2022-10-03 07:14:09', '2022-10-03 07:14:34'),
(7, 1, '[\"sr_no\",\"account_name\",\"account_owner\",\"account_type\",\"lead_type\",\"nationality\",\"status\",\"email\"]', 2, '2022-10-03 07:17:09', '2022-10-03 07:17:22'),
(8, 2, '[\"lead_id\",\"name\",\"email\",\"gender\",\"mobile_number\",\"contact_number\",\"branch_FB_country_code\",\"country\"]', 30, '2022-11-09 14:12:11', '2022-11-14 13:21:43');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mst_grid_settings`
--
ALTER TABLE `mst_grid_settings`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mst_grid_settings`
--
ALTER TABLE `mst_grid_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
