-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 192.168.17.159
-- Generation Time: Jan 23, 2023 at 10:43 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_account`
--

CREATE TABLE `mst_account` (
  `account_id` int(11) NOT NULL,
  `id_temp` varchar(255) DEFAULT NULL,
  `account_name` varchar(250) NOT NULL,
  `account_type` int(11) DEFAULT NULL,
  `account_type_temp` varchar(255) DEFAULT NULL,
  `lead_type` int(11) DEFAULT NULL,
  `lead_type_temp` varchar(255) DEFAULT NULL,
  `is_tender_client` int(11) NOT NULL,
  `is_tender_client_temp` varchar(255) DEFAULT NULL,
  `lead_bifurcation` int(11) DEFAULT NULL,
  `lead_bifurcation_temp` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `status_temp` varchar(255) DEFAULT NULL,
  `stage_temp` varchar(255) NOT NULL,
  `isdeleted` varchar(255) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `branch_id_temp` varchar(255) DEFAULT NULL,
  `branch_name` varchar(250) DEFAULT NULL,
  `potential_amount` varchar(250) DEFAULT NULL,
  `total_amount_temp` varchar(255) DEFAULT NULL,
  `business_percentage` varchar(250) DEFAULT NULL,
  `group_data` int(11) DEFAULT NULL,
  `group_temp` varchar(255) DEFAULT NULL,
  `meeting_count` varchar(250) DEFAULT NULL,
  `corporate_type` int(11) DEFAULT NULL,
  `corporate_type_temp` varchar(255) DEFAULT NULL,
  `key_person_name_phone` varchar(250) DEFAULT NULL,
  `key_person_designation` varchar(250) DEFAULT NULL,
  `account_owner` varchar(250) DEFAULT NULL,
  `ownerid_temp` varchar(255) DEFAULT NULL,
  `parent_account` int(11) DEFAULT NULL,
  `parentid_temp` varchar(255) DEFAULT NULL,
  `parent_account_name` varchar(250) NOT NULL,
  `nationality` int(11) DEFAULT NULL,
  `nationality_temp` varchar(255) DEFAULT NULL,
  `phone` varchar(250) DEFAULT NULL,
  `email_id` varchar(250) DEFAULT NULL,
  `contract_renewal_date` date DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `branch_code` varchar(100) NOT NULL,
  `region` varchar(250) DEFAULT NULL,
  `website` varchar(250) DEFAULT NULL,
  `description` text,
  `reason_for_dead` varchar(250) DEFAULT NULL,
  `account_source` int(11) DEFAULT NULL,
  `accountsource_temp` varchar(255) DEFAULT NULL,
  `company_manpower_count` int(11) DEFAULT NULL,
  `company_manpower_size_temp` varchar(255) DEFAULT NULL,
  `b2b_category` int(11) DEFAULT NULL,
  `b2b_category_temp` varchar(255) DEFAULT NULL,
  `travel_agency_owner` varchar(250) DEFAULT NULL,
  `handled_by` int(11) DEFAULT NULL,
  `handled_by_temp` varchar(255) DEFAULT NULL,
  `preferred_airline` varchar(250) DEFAULT NULL,
  `new_date` date DEFAULT NULL,
  `dead_lead_date` date DEFAULT NULL,
  `dead_lead_date_temp` varchar(255) DEFAULT NULL,
  `close_date` varchar(255) DEFAULT NULL,
  `close_date_temp` varchar(255) DEFAULT NULL,
  `converted_date` date DEFAULT NULL,
  `converted_date_temp` varchar(255) DEFAULT NULL,
  `in_process_date` date DEFAULT NULL,
  `in_process_date_temp` varchar(255) DEFAULT NULL,
  `existing_date` date DEFAULT NULL,
  `fleet_size` varchar(255) DEFAULT NULL,
  `head_quarter_temp` varchar(255) DEFAULT NULL,
  `meeting_date` date DEFAULT NULL,
  `meeting_time` varchar(20) DEFAULT NULL,
  `meeting_planned_description` text,
  `last_sales_call_date` date DEFAULT NULL,
  `last_sales_call_date_temp` varchar(255) DEFAULT NULL,
  `call_attempt_status` int(11) DEFAULT NULL,
  `call_attempt_status_temp` varchar(255) DEFAULT NULL,
  `call_outcome` int(11) DEFAULT NULL,
  `call_outcome_temp` varchar(255) DEFAULT NULL,
  `sales_call_next_action_date` date DEFAULT NULL,
  `sales_call_next_action_date_temp` varchar(255) DEFAULT NULL,
  `last_sales_call_description` text,
  `last_check_in_date` date DEFAULT NULL,
  `last_check_in_time` varchar(20) DEFAULT NULL,
  `last_check_in_time_temp` varchar(255) DEFAULT NULL,
  `last_check_in_address` varchar(250) DEFAULT NULL,
  `birthdate` varchar(255) DEFAULT NULL,
  `billing_street` varchar(250) DEFAULT NULL,
  `billing_city` varchar(250) DEFAULT NULL,
  `billing_zip_postal_code` varchar(250) DEFAULT NULL,
  `billing_state_province` varchar(250) DEFAULT NULL,
  `billing_country` varchar(250) DEFAULT NULL,
  `shipping_street` varchar(250) DEFAULT NULL,
  `shipping_city` varchar(250) DEFAULT NULL,
  `shipping_zip_postal_code` varchar(250) DEFAULT NULL,
  `shipping_state_province` varchar(250) DEFAULT NULL,
  `shipping_country` varchar(250) DEFAULT NULL,
  `lead_additional_info` varchar(255) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `createdbyid_temp` varchar(255) DEFAULT NULL,
  `last_modified_by` int(11) NOT NULL,
  `last_modified_by_temp` varchar(255) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_on` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `mst_account`
--

INSERT INTO `mst_account` (`account_id`, `id_temp`, `account_name`, `account_type`, `account_type_temp`, `lead_type`, `lead_type_temp`, `is_tender_client`, `is_tender_client_temp`, `lead_bifurcation`, `lead_bifurcation_temp`, `status`, `status_temp`, `stage_temp`, `isdeleted`, `branch_id`, `branch_id_temp`, `branch_name`, `potential_amount`, `total_amount_temp`, `business_percentage`, `group_data`, `group_temp`, `meeting_count`, `corporate_type`, `corporate_type_temp`, `key_person_name_phone`, `key_person_designation`, `account_owner`, `ownerid_temp`, `parent_account`, `parentid_temp`, `parent_account_name`, `nationality`, `nationality_temp`, `phone`, `email_id`, `contract_renewal_date`, `city`, `branch_code`, `region`, `website`, `description`, `reason_for_dead`, `account_source`, `accountsource_temp`, `company_manpower_count`, `company_manpower_size_temp`, `b2b_category`, `b2b_category_temp`, `travel_agency_owner`, `handled_by`, `handled_by_temp`, `preferred_airline`, `new_date`, `dead_lead_date`, `dead_lead_date_temp`, `close_date`, `close_date_temp`, `converted_date`, `converted_date_temp`, `in_process_date`, `in_process_date_temp`, `existing_date`, `fleet_size`, `head_quarter_temp`, `meeting_date`, `meeting_time`, `meeting_planned_description`, `last_sales_call_date`, `last_sales_call_date_temp`, `call_attempt_status`, `call_attempt_status_temp`, `call_outcome`, `call_outcome_temp`, `sales_call_next_action_date`, `sales_call_next_action_date_temp`, `last_sales_call_description`, `last_check_in_date`, `last_check_in_time`, `last_check_in_time_temp`, `last_check_in_address`, `birthdate`, `billing_street`, `billing_city`, `billing_zip_postal_code`, `billing_state_province`, `billing_country`, `shipping_street`, `shipping_city`, `shipping_zip_postal_code`, `shipping_state_province`, `shipping_country`, `lead_additional_info`, `created_by`, `createdbyid_temp`, `last_modified_by`, `last_modified_by_temp`, `created_on`, `updated_on`) VALUES
(1, NULL, 'Satguru User Account', 85, NULL, 93, NULL, 156, NULL, 130, NULL, 142, NULL, '', NULL, 1, NULL, 'Pune Branch 1 For Satguru', '12345', NULL, '5%', 1, NULL, '5', 0, NULL, 'Satgure User1 From Pune Branch', 'TEST', '5', NULL, 0, NULL, '', 101, NULL, '1212121212', 'satguruuser1@gmail.com', '2022-08-18', 'Chandigarh', 'PU 01', '1', '127.0.0.1/crm/accounts-master', '', '', 161, NULL, 169, NULL, 0, NULL, 'TEST', 171, NULL, NULL, '2022-08-12', '2022-08-12', NULL, NULL, NULL, '2022-08-12', NULL, '2022-08-12', NULL, '2022-08-12', NULL, NULL, '1970-01-01', NULL, NULL, '1970-01-01', NULL, 0, NULL, 0, NULL, '1970-01-01', NULL, 'TEST', '2022-11-30', '18:00 PM', NULL, 'N', NULL, 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', 'TEST', NULL, 30, NULL, 30, NULL, '2022-11-23 16:17:02', '2022-11-30 18:00:56'),
(2, NULL, 'Satguru User2 Account', 86, NULL, 100, NULL, 156, NULL, 122, NULL, 142, NULL, '', NULL, 1, NULL, 'Pune Branch 1 For Satguru', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '6', NULL, NULL, NULL, '', 13, NULL, '1212121212', 'satguruuser2@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', NULL, NULL, 164, NULL, 168, NULL, NULL, NULL, 'TEST', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, NULL, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '2022-11-16', '15:42 PM', NULL, 'N', NULL, 'Billing Street Test', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street Test', 'Shipping City Test', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 6, NULL, 6, NULL, '2022-08-16 05:42:55', '2022-11-16 15:42:24'),
(3, NULL, 'Satguru User3 Account', 87, NULL, 103, NULL, 0, NULL, 120, NULL, 141, NULL, '', NULL, 2, NULL, 'Pune Branch 2 For Satguru', '23451', NULL, '15%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '7', NULL, NULL, NULL, '', 8, NULL, '1313131313', 'satguruuser3@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', NULL, 'Reason for Dead Test', 206, NULL, 229, NULL, 0, NULL, 'Travel Agency Owner Test', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '2022-11-14', '17:21 PM', NULL, 'N', NULL, 'Billing Street TEST', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street Test', 'Shipping City Test', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 7, NULL, 7, NULL, '2022-08-16 05:47:37', '2022-11-14 17:21:53'),
(4, NULL, 'Satguru User4 Account', 88, NULL, 105, NULL, 156, NULL, 132, NULL, 143, NULL, '', NULL, 3, NULL, 'Pune Branch 3 For Satguru', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone TEST\r\n', 'Key Person Designation Test', '8', NULL, NULL, NULL, '', 17, NULL, '1414141414', 'satguruuser4@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 205, NULL, 168, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST\r\n', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street Test', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'TEST', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'TEST', NULL, 8, NULL, 8, NULL, '2022-08-16 05:52:13', '2022-08-16 11:22:13'),
(5, NULL, 'Satguru User5 Account', 89, NULL, 109, NULL, 157, NULL, 129, NULL, 154, NULL, '', NULL, 4, NULL, 'Chandigarh Branch 1 For Satguru', '23451', NULL, '15%', 0, NULL, '15', 0, NULL, ' Key Person Name & Phone TEST', 'Key Person Designation Test', '9', NULL, NULL, NULL, '', 17, NULL, '1515151515', 'satguruuser5@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', NULL, 'Reason for Dead Test', 165, NULL, 168, NULL, NULL, NULL, 'Travel Agency Owner TEST', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'Billing City Test', 'TEST', 'TEST', 'Billing Country Test', 'Shipping Street TEST', 'Shipping City Test', 'TEST', 'TEST', 'Shipping Country Test', NULL, 9, NULL, 9, NULL, '2022-08-16 05:57:18', '2022-08-16 11:27:18'),
(6, NULL, 'Satguru User6 Account', 90, NULL, 113, NULL, 0, NULL, 140, NULL, 155, NULL, '', NULL, 5, NULL, 'Chandigarh Branch 2 For Satguru', '12345', NULL, '5%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '10', NULL, NULL, NULL, '', 10, NULL, '1313131313', 'satguruuser6@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 164, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner Test', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '2022-09-13', '16:42 PM', NULL, 'N', NULL, 'Billing Street Test', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'Shipping City Test', 'TEST', 'TEST', 'Shipping Country Test', NULL, 10, NULL, 10, NULL, '2022-08-16 06:03:17', '2022-09-13 16:42:59'),
(7, NULL, 'Satguru User7 Account', 91, NULL, 115, NULL, 156, NULL, 121, NULL, 141, NULL, '', NULL, 5, NULL, 'Chandigarh Branch 2 For Satguru', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone TEST', 'Key Person Designation Test', '11', NULL, NULL, NULL, '', 19, NULL, '1414141414', 'satguruuser7@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead TEST', 164, NULL, 169, NULL, NULL, NULL, 'Travel Agency Owner Test\r\n', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address Test', NULL, 'Billing Street', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street', 'TEST', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'TEST', NULL, 11, NULL, 11, NULL, '2022-08-16 06:07:02', '2022-08-16 11:37:02'),
(8, NULL, 'Satguru User8 Account', 85, NULL, 92, NULL, 156, NULL, 118, NULL, 154, NULL, '', NULL, 6, NULL, 'Chandigarh Branch 3 For Satguru', '12345', NULL, '15%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '12', NULL, NULL, NULL, '', 39, NULL, '1515151515', 'satguruuser8@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 160, NULL, 169, NULL, NULL, NULL, 'Travel Agency Owner Test', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '2022-09-08', '18:33 PM', NULL, 'N', NULL, 'Billing Street Test', ' Billing City Test', 'TEST', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'TEST', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'TEST', NULL, 12, NULL, 12, NULL, '2022-08-16 06:17:21', '2022-09-08 18:33:53'),
(9, NULL, 'Soegies User1 Account', 86, NULL, 99, NULL, 156, NULL, 137, NULL, 142, NULL, '', NULL, 19, NULL, 'Pune Branch 1 For Soegis', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '13', NULL, NULL, NULL, '', 38, NULL, '1414141414', 'soegiesuser1@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 204, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner Test', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'Billing City Test', 'TEST', 'TEST', 'Billing Country Test', 'Shipping Street TEST', 'Shipping City Test', 'TEST', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 13, NULL, 13, NULL, '2022-08-16 06:23:12', '2022-08-16 11:53:12'),
(10, NULL, 'Soegies User2 Account', 87, NULL, 102, NULL, 157, NULL, 132, NULL, 142, NULL, '', NULL, 19, NULL, 'Pune Branch 1 For Soegis', '23451', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '14', NULL, NULL, NULL, '', 17, NULL, '1313131313', 'soegiesuser2@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', NULL, 'Reason for Dead Test', 162, NULL, 167, NULL, 0, NULL, 'Travel Agency Owner TEST', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'Shipping City Test', 'TEST', 'Shipping State/Province Test', 'TEST', NULL, 14, NULL, 14, NULL, '2022-08-16 06:26:51', '2022-08-16 11:56:51'),
(11, NULL, 'Soegies User3 Account', 88, NULL, 104, NULL, 156, NULL, 125, NULL, 154, NULL, '', NULL, 20, NULL, 'Pune Branch 2 For Soegis', '23451', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test\r\n', 'Key Person Designation Test', '15', NULL, NULL, NULL, '', 60, NULL, '1212121212', 'soegiesuser3@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead TEST', 163, NULL, 169, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-28', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street TEST', 'Shipping City Test', 'TEST', 'Shipping State/Province Test', 'TEST', NULL, 15, NULL, 15, NULL, '2022-08-16 06:33:13', '2022-08-16 12:03:13'),
(12, NULL, 'Soegies User4 Account', 87, NULL, 103, NULL, 156, NULL, 132, NULL, 141, NULL, '', NULL, 21, NULL, 'Pune Branch 3 For Soegis', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '16', NULL, NULL, NULL, '', 58, NULL, '1212121212', 'soegiesuser4@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 205, NULL, 167, NULL, 0, NULL, 'Travel Agency Owner TEST', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test\r\n', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'Billing City Test', 'TEST', 'TEST', 'Billing Country Test', 'Shipping Street TEST', 'Shipping City Test', 'TEST', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 16, NULL, 16, NULL, '2022-08-16 07:20:59', '2022-08-16 12:50:59'),
(13, NULL, 'Soegies User5 Account', 88, NULL, 105, NULL, 156, NULL, 123, NULL, 141, NULL, '', NULL, 22, NULL, 'Chandigarh Branch 1 For Soegis', '12345', NULL, '15%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '17', NULL, NULL, NULL, '', 17, NULL, '1515151515', 'soegiesuser5@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description TEST', 'Reason for Dead Test', 160, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner Test', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address Test', NULL, 'Billing Street Test', 'TEST', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'TEST', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'TEST', NULL, 17, NULL, 17, NULL, '2022-08-16 07:48:25', '2022-08-16 13:18:25'),
(14, NULL, 'Soegies User6 Account', 89, NULL, 107, NULL, 156, NULL, 132, NULL, 158, NULL, '', NULL, 23, NULL, 'Chandigarh Branch 2  For Soegis', '12345', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone TEST', 'Key Person Designation Test', '18', NULL, NULL, NULL, '', 6, NULL, '1313131313', 'soegiesuser6@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description TEST', 'Reason for Dead Test', 205, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address Test', NULL, 'Billing Street Test', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'TEST', 'Shipping Street Test', 'Shipping City Test', 'TEST', 'TEST', 'Shipping Country Test', NULL, 18, NULL, 18, NULL, '2022-08-16 07:51:44', '2022-08-16 13:21:44'),
(15, NULL, 'Soegies User7 Account', 91, NULL, 115, NULL, 157, NULL, 120, NULL, 141, NULL, '', NULL, 23, NULL, 'Chandigarh Branch 2  For Soegis', '23451', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone', 'Key Person Designation Test', '19', NULL, NULL, NULL, '', 2, NULL, '1515151515', 'soegiesuser7@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description', 'Reason for Dead', 161, NULL, 169, NULL, NULL, NULL, 'Travel Agency Owner', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description', '1970-01-01', NULL, NULL, 'Last Check In Address', NULL, 'Billing Street', 'Billing City Test', 'TEST', 'Billing State/Province Test', 'Billing Country', 'Shipping Street', 'Shipping City', 'Shipping Zip/Postal Code', 'Shipping State/Province', 'Shipping Country', NULL, 19, NULL, 19, NULL, '2022-08-16 07:55:29', '2022-08-16 13:25:29'),
(16, NULL, 'Soegies User8 Account', 89, NULL, 109, NULL, 157, NULL, 119, NULL, 141, NULL, '', NULL, 24, NULL, 'Chandigarh Branch 3 For Soegis', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation', '20', NULL, NULL, NULL, '', 67, NULL, '1515151515', 'soegiesuser8@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead', 163, NULL, 166, NULL, NULL, NULL, 'Travel Agency Owner', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street Test', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street Test', 'Shipping City Test', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 20, NULL, 20, NULL, '2022-08-16 08:00:02', '2022-08-16 13:30:02'),
(17, NULL, 'Cargo User1 Account', 85, NULL, 96, NULL, 156, NULL, 118, NULL, 154, NULL, '', NULL, 37, NULL, 'Pune Branch 1 For Cargo', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone', 'Key Person Designation Test', '21', NULL, NULL, NULL, '', 100, NULL, '1212121212', 'cargouser1@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description', 'Reason for Dead Test', 160, NULL, 166, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test\r\n', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street Test', 'Shipping City Test', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 21, NULL, 21, NULL, '2022-08-16 08:11:06', '2022-08-16 13:41:06'),
(18, NULL, 'Cargo User2 Account', 86, NULL, 98, NULL, 156, NULL, 0, NULL, 141, NULL, '', NULL, 38, NULL, 'Pune Branch 2 For Cargo', '12345', NULL, '15%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone', 'Key Person Designation Test', '22', NULL, NULL, NULL, '', 18, NULL, '1313131313', 'cargouser2@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description TEST', 'Reason for Dead TEST', 161, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner TEST', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description', '1970-01-01', NULL, NULL, 'Last Check In Address', NULL, 'Billing Street TEST', 'Billing City Test', 'Billing Zip/Postal Code Test', ' Billing City Test Billing State/Province', 'Billing Country Test', 'Shipping Street TEST', 'Shipping City', 'Shipping Zip/Postal Code', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 22, NULL, 22, NULL, '2022-08-16 08:15:09', '2022-08-16 13:45:09'),
(19, NULL, 'Cargo User3 Account', 87, NULL, 103, NULL, 156, NULL, 139, NULL, 141, NULL, '', NULL, 38, NULL, 'Pune Branch 2 For Cargo', '12345', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone', 'Key Person Designation Test', '22', NULL, NULL, NULL, '', 70, NULL, '1313131313', 'cargouser3@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description', 'Reason for Dead TEST', 165, NULL, 167, NULL, 0, NULL, 'Travel Agency Owner', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street TEST', 'Billing City Test', 'TEST', 'TEST', 'Billing Country Test', 'Shipping Street', 'Shipping City Test', 'Shipping Zip/Postal Code', 'Shipping State/Province Test', 'TEST', NULL, 22, NULL, 22, NULL, '2022-08-16 08:18:54', '2022-08-16 13:48:54'),
(20, NULL, 'Cargo User4 Account', 88, NULL, 105, NULL, 156, NULL, 130, NULL, 141, NULL, '', NULL, 38, NULL, 'Pune Branch 2 For Cargo', '12345', NULL, '15%', 0, NULL, '15', 0, NULL, 'Key Person Name & Phone TST', 'Key Person Designation', '24', NULL, NULL, NULL, '', 15, NULL, '1414141414', 'cargouser4@gmail.com', '2022-08-16', 'Pune', '', NULL, '127.0.0.1/crm/accounts-master', 'Description', 'Reason for Dead', 165, NULL, 168, NULL, NULL, NULL, 'Travel Agency Owner TEST', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description TEST', '1970-01-01', NULL, NULL, 'Last Check In Address TEST', NULL, 'Billing Street', ' Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country', 'Shipping Street', 'TEST', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country', NULL, 24, NULL, 24, NULL, '2022-08-16 08:23:57', '2022-08-16 13:53:57'),
(21, NULL, 'Cargo User5 Account', 89, NULL, 107, NULL, 156, NULL, 127, NULL, 141, NULL, '', NULL, 40, NULL, 'Chandigarh Branch 1 For Cargo', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '25', NULL, NULL, NULL, '', 68, NULL, '1515151515', 'cargouser5@gmail.com', '0000-00-00', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 164, NULL, 229, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address', NULL, 'Billing Street', ' Billing City Test', 'Billing Zip/Postal Code Test', ' Billing City Test Billing State/Province', 'Billing Country Test', 'Shipping Street', 'Shipping City', 'Shipping Zip/Postal Code Test', 'Shipping State/Province', 'Shipping Country Test', NULL, 25, NULL, 25, NULL, '2022-08-16 09:20:43', '2022-08-16 14:50:43'),
(22, NULL, 'Cargo User6 Account', 90, NULL, 113, NULL, 157, NULL, 0, NULL, 158, NULL, '', NULL, 41, NULL, 'Chandigarh Branch 2 For Cargo', '12345', NULL, '5%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone\r\n', 'Key Person Designation Test', '26', NULL, NULL, NULL, '', 58, NULL, '1212121212', 'cargouser6@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description', 'Reason for Dead', 165, NULL, 166, NULL, NULL, NULL, 'Travel Agency Owner\r\n', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description\r\n', '1970-01-01', NULL, NULL, 'Last Check In Address', NULL, 'Billing Street', 'Billing City', 'Billing Zip/Postal Code', 'Billing State/Province', 'Billing Country', 'Shipping Street', 'Shipping City', 'Shipping Zip/Postal Code', 'Shipping State/Province', 'Shipping Country', NULL, 26, NULL, 26, NULL, '2022-08-16 09:23:48', '2022-08-16 14:53:48'),
(23, NULL, 'Cargo User7 Account', 91, NULL, 115, NULL, 156, NULL, 130, NULL, 141, NULL, '', NULL, 41, NULL, 'Chandigarh Branch 2 For Cargo', '12345', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '27', NULL, NULL, NULL, '', 6, NULL, '1313131313', 'cargouser7@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 204, NULL, 167, NULL, NULL, NULL, 'Travel Agency Owner', 172, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address Test', NULL, 'Billing Street', 'Billing City', 'Billing Zip/Postal Code', ' Billing City Test Billing State/Province', 'Billing Country', 'Shipping Street', 'Shipping City', 'Shipping Zip/Postal Code', 'Shipping State/Province', 'Shipping Country', NULL, 27, NULL, 27, NULL, '2022-08-16 09:34:03', '2022-08-16 15:04:03'),
(24, NULL, 'Cargo User8 Account', 85, NULL, 92, NULL, 0, NULL, 132, NULL, 208, NULL, '', NULL, 42, NULL, 'Chandigarh Branch 3 For Cargo', '12345', NULL, '15%', 0, NULL, '5', 0, NULL, 'Key Person Name & Phone Test', 'Key Person Designation Test', '28', NULL, NULL, NULL, '', 101, NULL, '1515151515', 'cargouser8@gmail.com', '2022-08-16', 'Chandigarh', '', NULL, '127.0.0.1/crm/accounts-master', 'Description Test', 'Reason for Dead Test', 206, NULL, 168, NULL, NULL, NULL, 'Travel Agency Owner Test', 171, NULL, NULL, '2022-08-16', '2022-08-16', NULL, NULL, NULL, '2022-08-16', NULL, '2022-08-16', NULL, '2022-08-16', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, 0, NULL, 0, NULL, '0000-00-00', NULL, 'Last Sales Call Description Test', '1970-01-01', NULL, NULL, 'Last Check In Address Test', NULL, 'Billing Street Test', 'Billing City Test', 'Billing Zip/Postal Code Test', 'Billing State/Province Test', 'Billing Country Test', 'Shipping Street Test', 'Shipping City Test', 'Shipping Zip/Postal Code Test', 'Shipping State/Province Test', 'Shipping Country Test', NULL, 28, NULL, 28, NULL, '2022-08-16 09:37:58', '2022-08-16 15:07:58'),
(25, NULL, 'test', 85, NULL, 93, NULL, 0, NULL, 120, NULL, 155, NULL, '', NULL, 5, NULL, 'Chandigarh Branch 2 For Satguru', '33', NULL, NULL, 0, NULL, NULL, NULL, NULL, 'sdsd', 'sdsd', '12', NULL, NULL, NULL, '', 2, NULL, '322322233', 'punebranch2@gmail.com', '0000-00-00', 'pune', '', NULL, NULL, NULL, NULL, 0, NULL, 167, NULL, NULL, NULL, NULL, 0, NULL, NULL, '0000-00-00', '2022-08-23', NULL, NULL, NULL, '0000-00-00', NULL, '0000-00-00', NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, '0000-00-00', NULL, NULL, '2022-09-08', '16:18 PM', NULL, 'N', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 12, NULL, 12, NULL, '2022-08-23 11:54:28', '2022-11-17 11:45:43'),
(26, NULL, 'test1', 85, NULL, 92, NULL, 156, NULL, 119, NULL, 155, NULL, '', NULL, 5, NULL, 'Chandigarh Branch 2 For Satguru', '33', NULL, NULL, 0, NULL, NULL, NULL, NULL, 'sdsd', 'sds', '11', NULL, NULL, NULL, '', 2, NULL, '21232323121', 'punebranc3h2@gmail.com', '0000-00-00', 'pune', '', NULL, NULL, NULL, NULL, 161, NULL, 166, NULL, NULL, NULL, NULL, 0, NULL, NULL, '0000-00-00', '0000-00-00', NULL, NULL, NULL, '0000-00-00', NULL, '2022-08-23', NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, 11, NULL, '2022-08-23 12:06:40', '2022-11-15 13:11:18'),
(27, NULL, 'test3', 87, NULL, 102, NULL, 156, NULL, 119, NULL, 141, NULL, '', NULL, 5, NULL, 'Chandigarh Branch 2 For Satguru', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'ssd', 'sds', '11', NULL, NULL, NULL, '', 1, NULL, '21232323121', 'punebranch2@gmail.com', '0000-00-00', 'pune', '', NULL, NULL, NULL, NULL, 160, NULL, 166, NULL, 0, NULL, 'asas', 171, NULL, NULL, '0000-00-00', '0000-00-00', NULL, NULL, NULL, '0000-00-00', NULL, '0000-00-00', NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 11, NULL, 11, NULL, '2022-08-23 14:25:19', '2022-08-23 14:25:19'),
(28, NULL, 'Test One', 88, NULL, 104, NULL, 156, NULL, 117, NULL, 208, NULL, '', NULL, 1, NULL, 'Pune Branch 1 For Satguru', '', NULL, '', 1, NULL, '', 0, NULL, 'Pawan 123456789', 'TM', '1', NULL, 0, NULL, '', 101, NULL, '987654321', 'shubham@yiron.in', '1970-01-01', 'Pune', 'PU 01', '1', '', '', '', 0, NULL, 169, NULL, 0, NULL, '', 171, NULL, NULL, '1970-01-01', '1970-01-01', NULL, NULL, NULL, '1970-01-01', NULL, '1970-01-01', NULL, '1970-01-01', NULL, NULL, '1970-01-01', NULL, NULL, '1970-01-01', NULL, 0, NULL, 0, NULL, '1970-01-01', NULL, '', '1970-01-01', NULL, NULL, '', NULL, '', '', '', '', '', '', '', '', '', '', NULL, 2, NULL, 2, NULL, '2022-09-13 12:43:44', '2022-09-13 12:43:44'),
(29, NULL, 'Mobile Shopee', 85, NULL, 96, NULL, 0, NULL, 126, NULL, 155, NULL, '', NULL, 1, NULL, 'Pune Branch 1 For Satguru', '10000', NULL, '', 1, NULL, '', 0, NULL, 'qwbnm ', 'dfghj', '1', NULL, 0, NULL, '', 101, NULL, '+919877620525', 'tushar.bagal@yirontechnologies.com', '1970-01-01', 'Pune', 'PU 01', '1', '', '', '', 0, NULL, 166, NULL, NULL, NULL, '', 0, NULL, NULL, '1970-01-01', '1970-01-01', NULL, NULL, NULL, '1970-01-01', NULL, '1970-01-01', NULL, '1970-01-01', NULL, NULL, '1970-01-01', NULL, NULL, '1970-01-01', NULL, 0, NULL, 0, NULL, '1970-01-01', NULL, '', '2023-01-17', '16:55 PM', NULL, 'N', NULL, 'P1, Magarpatta Hadapsar', '', '', '', '', '', '', '', '', '', NULL, 1, NULL, 1, NULL, '2023-01-17 16:56:11', '2023-01-17 16:56:11'),
(30, NULL, 'Satguru', 87, NULL, 102, NULL, 0, NULL, 117, NULL, 141, NULL, '', NULL, 1, NULL, 'Pune Branch 1 For Satguru', '50000', NULL, '90', 0, NULL, '5', 0, NULL, 'gs 3456789', 'mn', '1', NULL, NULL, NULL, '', 101, NULL, '+9198776205251', 'tushar.bagal@yirontechnologies.com', '0000-00-00', 'Pune', '', NULL, NULL, NULL, NULL, 165, NULL, 166, NULL, 0, NULL, NULL, 171, NULL, NULL, '0000-00-00', '0000-00-00', NULL, NULL, NULL, '0000-00-00', NULL, '0000-00-00', NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, '0000-00-00', NULL, NULL, '2022-11-22', '18:55 PM', NULL, 'GW6G+C6J, Slip Rd to Tower-3/4, Magarpatta, Hadapsar, Pune, Maharashtra 411028, India', NULL, 'P1, Magarpatta Hadapsar', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, '2022-11-22 18:49:54', '2022-11-22 18:55:06'),
(31, NULL, 'Test data', 87, NULL, 102, NULL, 156, NULL, 122, NULL, 155, NULL, '', NULL, 2, NULL, 'Chandigarh', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, 'test', 'test', '139', NULL, NULL, NULL, '', 8, NULL, '96756546464', 'msatish8@gmail.com', '0000-00-00', 'pune', '', NULL, NULL, NULL, NULL, 205, NULL, 167, NULL, 0, NULL, 'testtse', 171, NULL, NULL, '2023-01-23', '2023-01-26', NULL, NULL, NULL, '2023-01-23', NULL, '2023-01-26', NULL, '2023-01-18', NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, '0000-00-00', NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 139, NULL, 139, NULL, '2023-01-23 15:58:31', '2023-01-23 15:57:49');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `mst_account`
--
ALTER TABLE `mst_account`
  ADD PRIMARY KEY (`account_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `mst_account`
--
ALTER TABLE `mst_account`
  MODIFY `account_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
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 */;
