-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Jul 13, 2026 at 06:15 AM
-- Server version: 9.1.0
-- PHP Version: 8.3.14

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: `gold_loan_app`
--

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

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
  `ad_id` int NOT NULL AUTO_INCREMENT,
  `ad_user` varchar(50) NOT NULL,
  `ad_pass` varchar(50) NOT NULL,
  `ad_email` varchar(100) NOT NULL,
  `ad_mobile` varchar(20) NOT NULL,
  `br_code` varchar(20) DEFAULT NULL,
  `br_name` varchar(100) DEFAULT NULL,
  `br_manager` varchar(100) DEFAULT NULL,
  `br_address` varchar(255) DEFAULT NULL,
  `br_city` varchar(50) DEFAULT NULL,
  `br_state_id` int DEFAULT NULL,
  `ad_status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `ad_type` varchar(1) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT 's(Super Admin), b(Branch)',
  `ad_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ad_id`),
  UNIQUE KEY `ad_email` (`ad_email`),
  UNIQUE KEY `ad_user` (`ad_user`),
  UNIQUE KEY `br_code` (`br_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`ad_id`, `ad_user`, `ad_pass`, `ad_email`, `ad_mobile`, `br_code`, `br_name`, `br_manager`, `br_address`, `br_city`, `br_state_id`, `ad_status`, `ad_type`, `ad_date`) VALUES
(1, 'admin', '', 'rak324550@gmail.com', '7053600064', 'ADMIN', 'Super Admin Branch', 'Super Admin', '', '', NULL, 'active', 's', '2017-10-01 18:30:00');

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

--
-- Table structure for table `customer_document_types`
--

DROP TABLE IF EXISTS `customer_document_types`;
CREATE TABLE IF NOT EXISTS `customer_document_types` (
  `dt_id` int NOT NULL AUTO_INCREMENT,
  `dt_name` varchar(80) NOT NULL,
  `dt_status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `dt_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dt_id`),
  UNIQUE KEY `dt_name` (`dt_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customer_document_types`
--

INSERT INTO `customer_document_types` (`dt_id`, `dt_name`, `dt_status`, `dt_dt`) VALUES
(1, 'Aadhaar', 'active', CURRENT_TIMESTAMP),
(2, 'PAN', 'active', CURRENT_TIMESTAMP),
(3, 'Voter ID', 'active', CURRENT_TIMESTAMP),
(4, 'Driving License', 'active', CURRENT_TIMESTAMP);

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

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
CREATE TABLE IF NOT EXISTS `customers` (
  `cust_id` int NOT NULL AUTO_INCREMENT,
  `cust_branch_id` int DEFAULT NULL,
  `cust_application_date` date DEFAULT NULL,
  `cust_name` varchar(120) NOT NULL,
  `cust_father_name` varchar(120) NOT NULL,
  `cust_mother_name` varchar(120) NOT NULL,
  `cust_dob` date DEFAULT NULL,
  `cust_gender` enum('Male','Female','Other') DEFAULT NULL,
  `cust_address` text NOT NULL,
  `cust_address_district` varchar(80) DEFAULT NULL,
  `cust_address_state` varchar(80) DEFAULT NULL,
  `cust_address_pincode` varchar(10) DEFAULT NULL,
  `cust_permanent_address` text NOT NULL,
  `cust_permanent_district` varchar(80) DEFAULT NULL,
  `cust_permanent_state` varchar(80) DEFAULT NULL,
  `cust_permanent_pincode` varchar(10) DEFAULT NULL,
  `cust_aadhaar` varchar(20) NOT NULL,
  `cust_pan` varchar(20) NOT NULL,
  `cust_phone` varchar(20) NOT NULL,
  `cust_email` varchar(120) NOT NULL,
  `cust_nationality` varchar(60) DEFAULT NULL,
  `cust_occupation` varchar(60) DEFAULT NULL,
  `cust_occupation_other` varchar(120) DEFAULT NULL,
  `cust_employer_sector` varchar(80) DEFAULT NULL,
  `cust_annual_income` varchar(40) DEFAULT NULL,
  `cust_residence_type` varchar(60) DEFAULT NULL,
  `cust_identity_proofs` varchar(255) DEFAULT NULL,
  `cust_address_proofs` varchar(255) DEFAULT NULL,
  `cust_application_place` varchar(100) DEFAULT NULL,
  `cust_declaration_date` date DEFAULT NULL,
  `cust_photo` varchar(255) DEFAULT NULL,
  `cust_status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `cust_created_by` int DEFAULT NULL,
  `cust_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cust_id`),
  KEY `cust_branch_id` (`cust_branch_id`),
  KEY `cust_created_by` (`cust_created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer_documents`
--

DROP TABLE IF EXISTS `customer_documents`;
CREATE TABLE IF NOT EXISTS `customer_documents` (
  `doc_id` int NOT NULL AUTO_INCREMENT,
  `doc_customer_id` int NOT NULL,
  `doc_type_id` int NOT NULL,
  `doc_file` varchar(255) NOT NULL,
  `doc_original_name` varchar(255) NOT NULL,
  `doc_uploaded_by` int DEFAULT NULL,
  `doc_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`doc_id`),
  KEY `doc_customer_id` (`doc_customer_id`),
  KEY `doc_type_id` (`doc_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loans`
--

DROP TABLE IF EXISTS `loans`;
CREATE TABLE IF NOT EXISTS `loans` (
  `loan_id` int NOT NULL AUTO_INCREMENT,
  `loan_branch_id` int DEFAULT NULL,
  `loan_customer_id` int NOT NULL,
  `loan_tenure_months` int NOT NULL,
  `loan_start_date` date DEFAULT NULL,
  `loan_gold_description` text NOT NULL,
  `loan_gold_value` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_gold_rate` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_file_charges` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_roi` decimal(6,2) NOT NULL DEFAULT '0.00',
  `loan_emi_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_total_interest` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_total_payable` decimal(12,2) NOT NULL DEFAULT '0.00',
  `loan_status` enum('active','closed','cancelled','captured') NOT NULL DEFAULT 'active',
  `loan_created_by` int DEFAULT NULL,
  `loan_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`loan_id`),
  KEY `loan_branch_id` (`loan_branch_id`),
  KEY `loan_customer_id` (`loan_customer_id`),
  KEY `loan_created_by` (`loan_created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_gold_captures`
--

DROP TABLE IF EXISTS `loan_gold_captures`;
CREATE TABLE IF NOT EXISTS `loan_gold_captures` (
  `cap_id` int NOT NULL AUTO_INCREMENT,
  `cap_loan_id` int NOT NULL,
  `cap_date` date NOT NULL,
  `cap_gold_value` decimal(12,2) NOT NULL DEFAULT '0.00',
  `cap_remarks` text,
  `cap_by` int DEFAULT NULL,
  `cap_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cap_id`),
  KEY `cap_loan_id` (`cap_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_gold_images`
--

DROP TABLE IF EXISTS `loan_gold_images`;
CREATE TABLE IF NOT EXISTS `loan_gold_images` (
  `img_id` int NOT NULL AUTO_INCREMENT,
  `img_loan_id` int NOT NULL,
  `img_file` varchar(255) NOT NULL,
  `img_original_name` varchar(255) NOT NULL,
  `img_uploaded_by` int DEFAULT NULL,
  `img_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`img_id`),
  KEY `img_loan_id` (`img_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_emis`
--

DROP TABLE IF EXISTS `loan_emis`;
CREATE TABLE IF NOT EXISTS `loan_emis` (
  `emi_id` int NOT NULL AUTO_INCREMENT,
  `emi_loan_id` int NOT NULL,
  `emi_no` int NOT NULL,
  `emi_due_date` date NOT NULL,
  `emi_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_principal` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_interest` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_overdue_interest` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_waveoff_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_last_interest_date` date DEFAULT NULL,
  `emi_balance` decimal(12,2) NOT NULL DEFAULT '0.00',
  `emi_status` enum('unpaid','paid') NOT NULL DEFAULT 'unpaid',
  `emi_paid_date` date DEFAULT NULL,
  `emi_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`emi_id`),
  KEY `emi_loan_id` (`emi_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_emi_waveoffs`
--

DROP TABLE IF EXISTS `loan_emi_waveoffs`;
CREATE TABLE IF NOT EXISTS `loan_emi_waveoffs` (
  `wave_id` int NOT NULL AUTO_INCREMENT,
  `wave_emi_id` int NOT NULL,
  `wave_loan_id` int NOT NULL,
  `wave_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `wave_remarks` text,
  `wave_by` int DEFAULT NULL,
  `wave_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`wave_id`),
  KEY `wave_emi_id` (`wave_emi_id`),
  KEY `wave_loan_id` (`wave_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `loan_emi_payments`
--

DROP TABLE IF EXISTS `loan_emi_payments`;
CREATE TABLE IF NOT EXISTS `loan_emi_payments` (
  `pay_id` int NOT NULL AUTO_INCREMENT,
  `pay_emi_id` int NOT NULL,
  `pay_loan_id` int NOT NULL,
  `pay_amount_type` enum('Online','UPI','Cash','Other') NOT NULL DEFAULT 'Cash',
  `pay_amount` decimal(12,2) NOT NULL DEFAULT '0.00',
  `pay_date` date NOT NULL,
  `pay_transaction_id` varchar(120) DEFAULT NULL,
  `pay_remarks` text,
  `pay_received_by` int DEFAULT NULL,
  `pay_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`pay_id`),
  KEY `pay_emi_id` (`pay_emi_id`),
  KEY `pay_loan_id` (`pay_loan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `email`
--

DROP TABLE IF EXISTS `email`;
CREATE TABLE IF NOT EXISTS `email` (
  `email_id` int NOT NULL AUTO_INCREMENT,
  `email_title` varchar(25) NOT NULL,
  `email_address` varchar(50) NOT NULL,
  `email_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`email_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `email`
--

INSERT INTO `email` (`email_id`, `email_title`, `email_address`, `email_dt`) VALUES
(16, 'Email Us', 'chachyotnidhi@gmail.com', '2019-09-06 07:30:26');

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

--
-- Table structure for table `msgs`
--

DROP TABLE IF EXISTS `msgs`;
CREATE TABLE IF NOT EXISTS `msgs` (
  `msg_id` int NOT NULL AUTO_INCREMENT,
  `msg_name` varchar(25) NOT NULL,
  `msg_phone` varchar(15) NOT NULL,
  `msg_email` varchar(50) NOT NULL,
  `msg_txt` varchar(255) NOT NULL,
  `msg_read` int NOT NULL,
  `msg_type` varchar(1) NOT NULL,
  `msg_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `msgs`
--

INSERT INTO `msgs` (`msg_id`, `msg_name`, `msg_phone`, `msg_email`, `msg_txt`, `msg_read`, `msg_type`, `msg_dt`) VALUES
(6, 'Steven rockims', '+1-310-295-1669', 'stevenshirani@gmail.com', '   Hi Sir,\r\n\r\nWould you like your website to Rank on Page 1 of Google for all limousine service searches in your city?\r\n\r\nWe can also provide a complete package for you to manage your Facebook, Instagram, Organic and Paid marketing campaigns.\r\n\r\nWe will s', 1, 'a', '2019-05-16 14:37:17'),
(7, 'Garry Singh', '9914915000', 'garry@algowid.com', 'dfsgdf', 1, 'm', '2019-10-26 10:06:54'),
(8, 'TEST SINGH', '7053600064', 'na@na.com', 'TEST SINGH has sent a request for an appointment', 1, 'a', '2019-11-07 07:40:43'),
(9, 'GURTEJ', '9988975882', 'gurtejsingh1@gmail.com', 'appointment plz', 1, 'a', '2019-11-07 09:53:18'),
(10, 'malkeet singh', '6283700457', 'na@na.com', 'malkeet singh has sent a request for an appointment', 1, 'a', '2019-11-07 09:54:28'),
(11, 'Eric', '416-385-3200', 'eric@talkwithcustomer.com', 'Hi,\r\n\r\nMy name is Eric and I was looking at a few different sites online and came across your site brain-lytic.com.  I must say - your website is very impressive.  I am seeing your website on the first page of the Search Engine. \r\n\r\nHave you noticed that ', 1, 'a', '2019-11-25 19:24:32'),
(12, 'Eric', '416-385-3200', 'eric@talkwithcustomer.com', 'Hello brain-lytic.com,\r\n\r\nPeople ask, “why does TalkWithCustomer work so well?”\r\n\r\nIt’s simple.\r\n\r\nTalkWithCustomer enables you to connect with a prospective customer at EXACTLY the Perfect Time.\r\n\r\n- NOT one week, two weeks, three weeks', 1, 'a', '2019-12-18 01:42:16'),
(13, 'Eric', '416-385-3200', 'eric@talkwithcustomer.com', 'Hi,\r\n\r\nYou know it’s true…\r\n\r\nYour competition just can’t hold a candle to the way you DELIVER real solutions to your customers on your website brain-lytic.com.\r\n\r\nBut it’s a shame when good people who need what you have to offer ', 1, 'a', '2020-01-06 13:24:33'),
(14, 'Parthenia', '(07) 4548 3498', 'gosse.parthenia@gmail.com', 'Good Morning\r\n\r\nBuy medical disposable face mask to protect your loved ones from the deadly CoronaVirus.  The price is $0.28 each.  If interested, please visit our site: pharmacyoutlets.online\r\n\r\nThank You,\r\n\r\nParthenia', 1, 'a', '2021-09-12 18:35:03'),
(15, 'Garry', '9914915000', 'algowid2019@gmail.com', 'TEST MSG', 1, 'a', '2021-12-24 08:04:37'),
(16, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hey there, I just found your site, quick question…\r\n\r\nMy name’s Eric, I found chachyotnidhiltd.com after doing a quick search – you showed up near the top of the rankings, so whatever you’re doing for SEO, looks like it’s wo', 1, 'a', '2022-02-13 07:06:52'),
(17, 'Tamera McGavin', '', 'tamera.mcgavin@gmail.com', 'Morning \r\n \r\nCAREDOGBEST™ - Personalized Dog Harness. All sizes from XS to XXL.  Easy ON/OFF in just 2 seconds.  LIFETIME WARRANTY.\r\n\r\nClick here: https://caredogbest.com\r\n \r\nTo your success, \r\n \r\nTamera', 1, 'a', '2022-02-27 20:48:08'),
(18, 'Steve Watson', '078 4938 0361', 'steve@explainervideos4u.info', 'Hi,\r\n\r\nWe'd like to introduce to you our explainer video service, which we feel can benefit your site chachyotnidhiltd.com.\r\n\r\nCheck out some of our existing videos here:\r\nhttps://www.youtube.com/watch?v=2GvqwoG1Mrc\r\nhttps://www.youtube.com/watch?v=7', 1, 'a', '2022-03-04 13:05:36'),
(19, 'IsabellaEl', '+40 2729687988', 'isabellaEl@yahoo.com', 'Ηello all, guуѕǃ I know, mу mesѕаge mау bе tоо ѕреcÑ–fіс,\r\nBut mу sÑ–ster fоund niсе mаn hеrе and theу marriеd, so һоw about me?! :)\r\nI аm 26 уearÑ• оld, Isаbella, frоm UkraÑ–nе, Ι knоw Εnglish аnd Gеrm', 1, 'a', '2022-03-14 05:01:36'),
(20, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'My name’s Eric and I just found your site chachyotnidhiltd.com.\r\n\r\nIt’s got a lot going for it, but here’s an idea to make it even MORE effective.\r\n\r\nTalk With Web Visitor – CLICK HERE http://talkwithwebtraffic.com for a live demo ', 1, 'a', '2022-03-16 16:11:39'),
(21, 'Pearl Tabarez', '07135 74 18 77', 'pearl.tabarez@gmail.com', 'Hi there,\r\n\r\nHave you ever wondered why new cryptocurrency tokens are always subject to insane price action?\r\n\r\nWe are giving away a totally free step-by-step guide on how you can profit from that with a front running bot.\r\n\r\nCheck out our new Youtube vid', 1, 'a', '2022-03-19 23:35:32'),
(22, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Good day, \r\n\r\nMy name is Eric and unlike a lot of emails you might get, I wanted to instead provide you with a word of encouragement – Congratulations\r\n\r\nWhat for?  \r\n\r\nPart of my job is to check out websites and the work you’ve done with chac', 1, 'a', '2022-04-14 21:46:13'),
(23, 'Kamlesh kumar', '9625441461', 'Kamlesh. Sarla254@gmail.com', 'I M kamlesh kumar vpo bardhan tehsil padhar distt mandi hp 175013 \r\n', 1, 'a', '2022-04-29 05:55:16'),
(24, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hey there, I just found your site, quick question…\r\n\r\nMy name’s Eric, I found chachyotnidhiltd.com after doing a quick search – you showed up near the top of the rankings, so whatever you’re doing for SEO, looks like it’s wo', 1, 'a', '2022-05-19 20:51:44'),
(25, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Cool website!\r\n\r\nMy name’s Eric, and I just found your site - chachyotnidhiltd.com - while surfing the net. You showed up at the top of the search results, so I checked you out. Looks like what you’re doing is pretty cool.\r\n \r\nBut if you don&r', 1, 'a', '2022-05-19 23:36:19'),
(26, 'Chase Reiner', '077 0201 9891', 'reliablecomputerhelper@gmail.com', 'Hey, are you still in business? I used a tool to run a free website report and noticed a ton of major issues! If you want to see for yourself go to https://shineranker.com', 1, 'a', '2022-06-03 02:58:27'),
(27, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hey, this is Eric and I ran across chachyotnidhiltd.com a few minutes ago.\r\n\r\nLooks great… but now what?\r\n\r\nBy that I mean, when someone like me finds your website – either through Search or just bouncing around – what happens next?  Do', 1, 'a', '2022-06-24 17:15:41'),
(28, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hi, Eric here with a quick thought about your website chachyotnidhiltd.com...\r\n\r\nI’m on the internet a lot and I look at a lot of business websites.\r\n\r\nLike yours, many of them have great content. \r\n\r\nBut all too often, they come up short when it co', 1, 'a', '2022-07-11 11:32:23'),
(29, 'Eric Jones', '555-555-1212', 'ericjonesmyemail@gmail.com', 'Hi, my name is Eric and I’m betting you’d like your website chachyotnidhiltd.com to generate more leads.\r\n\r\nHere’s how:\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Nam', 1, 'a', '2022-08-09 10:29:57'),
(30, 'Eric Jones', '555-555-1212', 'ericjonesmyemail@gmail.com', 'Hey, this is Eric and I ran across chachyotnidhiltd.com a few minutes ago.\r\n\r\nLooks great… but now what?\r\n\r\nBy that I mean, when someone like me finds your website – either through Search or just bouncing around – what happens next?  Do', 1, 'a', '2022-08-14 07:02:04'),
(31, 'Eric Jones', '555-555-1212', 'ericjonesmyemail@gmail.com', 'Hey, this is Eric and I ran across chachyotnidhiltd.com a few minutes ago.\r\n\r\nLooks great… but now what?\r\n\r\nBy that I mean, when someone like me finds your website – either through Search or just bouncing around – what happens next?  Do', 1, 'a', '2022-08-14 08:28:48'),
(32, 'Eric Jones', '555-555-1212', 'ericjonesmyemail@gmail.com', 'Hey, this is Eric and I ran across chachyotnidhiltd.com a few minutes ago.\r\n\r\nLooks great… but now what?\r\n\r\nBy that I mean, when someone like me finds your website – either through Search or just bouncing around – what happens next?  Do', 1, 'a', '2022-08-17 06:05:43'),
(33, 'Crytoplaus', '89037266324', 'de.s.p.er.atemoul@gmail.com', 'Make money, not war! Financial Robot is what you need. https://dib.rbertilsson.se/', 1, 'a', '2022-08-18 10:26:38'),
(34, 'Crytoplaus', '89030771958', 'ssweet053@aol.com', 'Make dollars just sitting home. https://dib.rbertilsson.se/', 1, 'a', '2022-08-18 12:41:02'),
(35, 'Crytoplaus', '89034376603', 'pigeonhold@aol.com', 'Financial independence is what this robot guarantees. https://dib.rbertilsson.se/', 1, 'a', '2022-08-18 15:01:39'),
(36, 'Crytoplaus', '89036028308', 'emiliogp86@hotmail.com', 'Launch the financial Robot and do your business. https://dib.rbertilsson.se/', 1, 'a', '2022-08-18 17:21:00'),
(37, 'Kate Trilly', '', 'katytrilly9@gmail.com', 'Hi,\r\n\r\nWe'd like to introduce to you our explainer video service, which we feel can benefit your site chachyotnidhiltd.com.\r\n\r\nCheck out some of our existing videos here:\r\nhttps://www.youtube.com/watch?v=zvGF7uRfH04\r\nhttps://www.youtube.com/watch?v=c', 1, 'a', '2022-09-13 19:19:07'),
(38, 'Liam Smith', '(401) 599-3510', 'wesavesmallbusinesses@gmail.com', 'Hello are you the owner of this business?\r\nI was just on your website and I have a question about your business.\r\n\r\n\r\n', 1, 'a', '2022-09-24 13:11:20'),
(39, 'Shubham bhaurao meshram', '08788378222', 'golumeshram098@gmail.com', 'I m live in Nagpur I m self employed I'm e rickshaw onar', 1, 'a', '2022-09-25 07:31:57'),
(40, 'Shubham bhaurao meshram', '08788378222', 'golumeshram098@gmail.com', 'I m live in Nagpur I am self employed', 1, 'a', '2022-09-25 07:35:36'),
(41, 'Shubham bhaurao meshram', '08788378222', 'golumeshram098@gmail.com', 'I m live in Nagpur I am self employed', 1, 'a', '2022-09-25 07:41:11'),
(42, 'Phillip Belstead', '51 872 80 90', 'phillip.belstead@hotmail.com', 'PPP Alternative Funding Options for Business owners is now available\r\n \r\n\r\n\r\n \r\n\r\nThis is great news to business owners across the country\r\n\r\nProgram Highlights:\r\n\r\n1. Minimal paperwork for approval\r\n2. Max approval per business $2 Million\r\n\r\nQualificatio', 1, 'a', '2022-10-07 08:35:24'),
(43, 'Marie Petherick', '034 764 18 69', 'marie.petherick@gmail.com', 'PPP Alternative Funding Options for Business owners is now available\r\n \r\n\r\n\r\n \r\n\r\nThis is great news to business owners across the country\r\n\r\nProgram Highlights:\r\n\r\n1. Minimal paperwork for approval\r\n2. Max approval per business $2 Million\r\n\r\nQualificatio', 1, 'a', '2022-10-19 09:37:04'),
(44, 'Rosita Synnot', '31-93-36-23', 'synnot.rosita@outlook.com', 'Do you know that you can use revolutionary All-In-One business model that makes it fast & super easy to step into an IMMEDIATELY profitable online business? this very simple All In One tool can help you get results in around 24 hours, in just a few cl', 1, 'a', '2022-10-21 15:22:01'),
(45, 'Roseanna Buck', '972-222-8409', 'buck.roseanna@msn.com', 'The current healthcare system is broken and overpriced\r\n\r\nThis Health Care Plan is the Solution your company and family needs\r\n\r\n\r\n\r\nPlan Overview:\r\n\r\nCheaper Plan ( 40-80 % more affordable than traditional health insurance cost) .\r\n\r\nIndividual Plans Sta', 1, 'a', '2022-10-22 15:05:07'),
(46, 'Angela Ball', '0354 4134343', 'angelaballj774@yahoo.com', 'Hi there,\r\n\r\nWe run an Instagram growth service, which increases your number of followers both safely and practically. \r\n\r\n- Guaranteed: We guarantee to gain you 400-1200+ followers per month.\r\n- Real, human followers: People follow you because they are i', 1, 'a', '2022-10-23 03:16:29'),
(47, 'James', '09420 59 38 08', 'eden.moreland@yahoo.com', 'Hey, James here! Do you know that there is a new AI tool that can write any content for any purpose, you can check it on jaspertab.com', 0, 'a', '2022-11-05 03:40:18'),
(48, 'Lizette Beaulieu', '062 613 36 33', 'lizette.beaulieu@gmail.com', 'Still Want to move to Florids? Huge Builde Incentives, Creative Financing, No Closing Costs', 0, 'a', '2022-11-15 19:39:16'),
(49, 'Aleida Villalpando', '903-792-5825', 'info@pontetravels.com', 'Good day \r\n\r\nI wanted to reach out and let you know about our new dog harness. It's really easy to put on and take off - in just 2 seconds - and it's personalized for each dog. \r\nPlus, we offer a lifetime warranty so you can be sure your pet is ', 0, 'a', '2022-12-07 15:27:35'),
(50, 'Christina Henderson', '041 370 81 25', 'christinahendersones6@gmail.com', 'Hi there,\r\n\r\nWe run an Instagram growth service, which increases your number of followers both safely and practically. \r\n\r\n- Guaranteed: We guarantee to gain you 400-1200+ followers per month.\r\n- Real, human followers: People follow you because they are i', 0, 'a', '2022-12-08 16:21:05'),
(51, 'Isidro Lind', '078 1990 8334', 'lind.isidro@msn.com', 'Have you tried a little-known All In One system that makes it super fast & super easy to step into an IMMEDIATELY profitable business online? this underground All-In-One system can help you see profits in around 24 hours, in just a few clicks... There', 0, 'a', '2022-12-08 22:22:43'),
(52, 'Louella Sellwood Sellwood', '05903 31 83 23', 'sellwood.louella@outlook.com', 'Hope you are having a good day at work. I'm just wondering if you have heard about FlowDax.co. They are an all-in-one sales and marketing platform designed to build and grow your business online.\r\n\r\nThey are currently offering access to their 14 serv', 0, 'a', '2022-12-09 13:05:18'),
(53, 'IsabellaBite', '+420 2764639531', 'isabellaBite@crosenoutinabsi.tk', 'Ηеllо!\r\nРеrhaps my mеѕѕage Ñ–Ñ• too sреcifÑ–c.\r\nBut my oldеr Ñ•Ñ–stеr found а wоnderful man hеre аnd thеу havе а great rеlаtionÑ•hiÑ€, but what about me?\r\nI am 28 yearÑ• old, Ιsаbellа, from thе Сzеch Republic, know &Epsi', 0, 'a', '2022-12-11 20:11:07'),
(54, 'Chance R', '0391 16 08 29', 'bestseotools7@gmail.com', 'Hey, Chance here. Are you accepting expert volunteers? I'm a website expert and I would love to clean and fix a few things up for you :) Send me a text or call me at: +1 (480) 409-1253\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n9169 W State St #1614   Garden City,', 0, 'a', '2022-12-12 23:50:35'),
(55, 'Eric Jones', '555-555-1212', 'ericjonesmyemail@gmail.com', 'Cool website!\r\n\r\nMy name’s Eric, and I just found your site - chachyotnidhiltd.com - while surfing the net. You showed up at the top of the search results, so I checked you out. Looks like what you’re doing is pretty cool.\r\n \r\nBut if you don&r', 0, 'a', '2022-12-14 07:28:11'),
(56, 'Jamaal Wootton', '070 0194 8960', 'jamaal.wootton@yahoo.com', 'Did you try this simple Artificial intelligence assistant that makes it super fast & easy to grow profits for your website chachyotnidhiltd.com? a little-known Artificial intelligence assistant deposits hundreds of thousands of highy targeted clients,', 0, 'a', '2022-12-16 07:50:27'),
(57, 'Michaela Moeller', '210-734-8885', 'michaela.moeller@gmail.com', 'Hello,\r\n\r\nIs Your Website ADA Compliant?\r\n\r\nWebsite Owners Are Getting Sued Left & Right !\r\n\r\nYour Website could be breaking the Law Right now & you don’t know it!\r\n\r\nPlease visit the following link to get a free audit of your website to che', 0, 'a', '2022-12-22 01:18:22');

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

--
-- Table structure for table `phone`
--

DROP TABLE IF EXISTS `phone`;
CREATE TABLE IF NOT EXISTS `phone` (
  `ph_id` int NOT NULL AUTO_INCREMENT,
  `ph_title` varchar(25) NOT NULL,
  `ph_no` varchar(20) NOT NULL,
  `ph_dt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ph_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `phone`
--

INSERT INTO `phone` (`ph_id`, `ph_title`, `ph_no`, `ph_dt`) VALUES
(10, 'Call Us', '+916230191006', '2019-10-31 11:47:32'),
(11, 'Enquiry', '+916230902566', '2020-10-30 08:21:14');

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

--
-- Table structure for table `states`
--

DROP TABLE IF EXISTS `states`;
CREATE TABLE IF NOT EXISTS `states` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `country_id` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`, `country_id`) VALUES
(1, 'Andaman and Nicobar Islands', 101),
(2, 'Andhra Pradesh', 101),
(3, 'Arunachal Pradesh', 101),
(4, 'Assam', 101),
(5, 'Bihar', 101),
(6, 'Chandigarh', 101),
(7, 'Chhattisgarh', 101),
(8, 'Dadra and Nagar Haveli', 101),
(9, 'Daman and Diu', 101),
(10, 'Delhi', 101),
(11, 'Goa', 101),
(12, 'Gujarat', 101),
(13, 'Haryana', 101),
(14, 'Himachal Pradesh', 101),
(15, 'Jammu and Kashmir', 101),
(16, 'Jharkhand', 101),
(17, 'Karnataka', 101),
(18, 'Kenmore', 101),
(19, 'Kerala', 101),
(20, 'Lakshadweep', 101),
(21, 'Madhya Pradesh', 101),
(22, 'Maharashtra', 101),
(23, 'Manipur', 101),
(24, 'Meghalaya', 101),
(25, 'Mizoram', 101),
(26, 'Nagaland', 101),
(27, 'Narora', 101),
(28, 'Natwar', 101),
(29, 'Odisha', 101),
(30, 'Paschim Medinipur', 101),
(31, 'Pondicherry', 101),
(32, 'Punjab', 101),
(33, 'Rajasthan', 101),
(34, 'Sikkim', 101),
(35, 'Tamil Nadu', 101),
(36, 'Telangana', 101),
(37, 'Tripura', 101),
(38, 'Uttar Pradesh', 101),
(39, 'Uttarakhand', 101),
(40, 'Vaishali', 101),
(41, 'West Bengal', 101);

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

--
-- Table structure for table `wp`
--

DROP TABLE IF EXISTS `wp`;
CREATE TABLE IF NOT EXISTS `wp` (
  `wp_id` tinyint(1) NOT NULL,
  `wp_title` varchar(150) NOT NULL,
  `wp_meta_kw` varchar(250) NOT NULL,
  `wp_meta_txt` varchar(250) NOT NULL,
  `wp_add` varchar(255) NOT NULL,
  `wp_intro` text NOT NULL,
  `wp_email` varchar(50) NOT NULL,
  `wp_mobile` varchar(10) NOT NULL,
  `wp_fb` text NOT NULL,
  `wp_tw` text NOT NULL,
  `wp_in` text NOT NULL,
  `wp_logo` varchar(255) NOT NULL DEFAULT '',
  `wp_base_url` varchar(50) NOT NULL,
  PRIMARY KEY (`wp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `wp`
--

INSERT INTO `wp` (`wp_id`, `wp_title`, `wp_meta_kw`, `wp_meta_txt`, `wp_add`, `wp_intro`, `wp_email`, `wp_mobile`, `wp_fb`, `wp_tw`, `wp_in`, `wp_logo`, `wp_base_url`) VALUES
(1, 'UJJWALA DIAMONDS PRIVATE LIMITED', 'UJJWALA DIAMONDS', 'UJJWALA DIAMONDS', 'CK DAS ROAD,Tezpur,Sonitpur,Assam,784001-India', 'UJJWALA DIAMONDS PRIVATE LIMITED is a Private company incorporated on 16th March 2026, registered with the Registrar of Companies, Guwahati. The company operates in the Manufacturing (Others) sector.', 'info@mail.com', '1234567890', '', '', '', '', '');
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 */;