-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Sep 06, 2024 at 01:13 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12
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: `fineview`
--
-- --------------------------------------------------------
--
-- Table structure for table `about_seo`
--
CREATE TABLE `about_seo` (
`id` int(11) NOT NULL,
`metatitle` longtext NOT NULL,
`metadescription` longtext NOT NULL,
`keywords` longtext NOT NULL,
`robots` longtext DEFAULT NULL,
`metatitlef` longtext NOT NULL,
`metadescriptionf` longtext NOT NULL,
`keywordsf` longtext NOT NULL,
`robotsf` longtext DEFAULT NULL,
`metatitlet` longtext NOT NULL,
`metadescriptiont` longtext NOT NULL,
`keywordst` longtext NOT NULL,
`robotst` longtext DEFAULT NULL,
`linkf` longtext NOT NULL,
`conical` longtext NOT NULL,
`delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `about_seo`
--
INSERT INTO `about_seo` (`id`, `metatitle`, `metadescription`, `keywords`, `robots`, `metatitlef`, `metadescriptionf`, `keywordsf`, `robotsf`, `metatitlet`, `metadescriptiont`, `keywordst`, `robotst`, `linkf`, `conical`, `delete_status`) VALUES
(1, 'Internal Financial Control (IFC) Solutions | Finview Consulting', 'Strengthen your financial operations with our expert IFC solutions. Finview Consulting provides tailored strategies to enhance your internal controls and mitigate risks.', 'internal financial control, IFC solutions, financial risk management, compliance, audit', '', 'Internal Financial Control (IFC) Solutions | Finview Consulting', 'Strengthen your financial operations with our expert IFC solutions. Finview Consulting provides tailored strategies to enhance your internal controls and mitigate risks.', '', '', 'Internal Financial Control (IFC) Solutions | Finview Consulting', 'Strengthen your financial operations with our expert IFC solutions. Finview Consulting provides tailored strategies to enhance your internal controls and mitigate risks.', '', '', 'https://system365.cloud/finview/', 'https://system365.cloud/finview/', 0);
-- --------------------------------------------------------
--
-- Table structure for table `contactus`
--
CREATE TABLE `contactus` (
`id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`email` varchar(100) NOT NULL,
`subject` varchar(300) NOT NULL,
`contact` varchar(200) NOT NULL,
`message` varchar(200) NOT NULL,
`delete_status` tinyint(2) NOT NULL,
`created_date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `contactus`
--
INSERT INTO `contactus` (`id`, `name`, `email`, `subject`, `contact`, `message`, `delete_status`, `created_date`) VALUES
(1, 'test', 'test@gmail.com', 'test', '3456789767', 'test', 0, '2024-04-13 12:50:39'),
(2, 'kunal', 'yadnya@gmail.com', 'Mutual Funds', '', 'asdfasfasf', 0, '2024-08-07 17:48:44'),
(3, 'admin', 'user@gmail.com', 'test', '', 'done', 0, '2024-09-06 12:13:25'),
(4, 'admin', 'member@gmail.com', 'test', '', 'hi team', 0, '2024-09-06 12:15:09'),
(5, 'Sakib Al Hasan', 'test@gmail.com', 'test', '', 'hello guys', 0, '2024-09-06 12:16:00'),
(6, 'nir', 'admin@gmail.com', 'test', '', 'hrhghth', 0, '2024-09-06 15:37:34'),
(7, 'admin', 'admin@gmail.com', 'test', '', 'gdfgdfg', 0, '2024-09-06 15:37:54');
-- --------------------------------------------------------
--
-- Table structure for table `contact_seo`
--
CREATE TABLE `contact_seo` (
`id` int(11) NOT NULL,
`metatitle` longtext NOT NULL,
`metadescription` longtext NOT NULL,
`keywords` longtext NOT NULL,
`robots` longtext DEFAULT NULL,
`metatitlef` longtext NOT NULL,
`metadescriptionf` longtext NOT NULL,
`keywordsf` longtext NOT NULL,
`robotsf` longtext DEFAULT NULL,
`metatitlet` longtext NOT NULL,
`metadescriptiont` longtext NOT NULL,
`keywordst` longtext NOT NULL,
`robotst` longtext DEFAULT NULL,
`linkf` longtext NOT NULL,
`conical` longtext NOT NULL,
`delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `contact_seo`
--
INSERT INTO `contact_seo` (`id`, `metatitle`, `metadescription`, `keywords`, `robots`, `metatitlef`, `metadescriptionf`, `keywordsf`, `robotsf`, `metatitlet`, `metadescriptiont`, `keywordst`, `robotst`, `linkf`, `conical`, `delete_status`) VALUES
(1, 'Contact Velanka Trades LLP | Financial Advice & Services', 'Need financial advice? Contact Velanka Trades LLP. Experts in investments, insurance, tax, & NRI services. Build your future.', 'contact us, financial advisor, NRI support, investment consultancy, insurance queries', '', 'Contact Velanka Trades LLP | Financial Advice & Services', 'Need financial advice? Contact Velanka Trades LLP. Experts in investments, insurance, tax, & NRI services. Build your future.', 'Ornate Art Products Private Limited', '', 'Contact Velanka Trades LLP | Financial Advice & Services', 'Need financial advice? Contact Velanka Trades LLP. Experts in investments, insurance, tax, & NRI services. Build your future.', 'Ornate Art Products Private Limited', '', 'https://system365.cloud/velanka/contact-us.php', 'https://system365.cloud/velanka/contact-us.php', 0);
-- --------------------------------------------------------
--
-- Table structure for table `emailsetting`
--
CREATE TABLE `emailsetting` (
`id` int(11) NOT NULL,
`smtp_server` varchar(255) NOT NULL,
`smtp_username` varchar(255) NOT NULL,
`smtp_password` varchar(255) NOT NULL,
`stmp_port` varchar(255) NOT NULL,
`smtp_type` varchar(255) NOT NULL,
`email` varchar(300) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `emailsetting`
--
INSERT INTO `emailsetting` (`id`, `smtp_server`, `smtp_username`, `smtp_password`, `stmp_port`, `smtp_type`, `email`) VALUES
(1, 'smtp.hostinger.com', 'info@photobill.in', 'info@PHOTO123', '587', 'tls', 'fgf@ffv.com');
-- --------------------------------------------------------
--
-- Table structure for table `home_seo`
--
CREATE TABLE `home_seo` (
`id` int(11) NOT NULL,
`metatitle` longtext NOT NULL,
`metadescription` longtext NOT NULL,
`keywords` longtext NOT NULL,
`robots` longtext DEFAULT NULL,
`metatitlef` longtext NOT NULL,
`metadescriptionf` longtext NOT NULL,
`keywordsf` longtext NOT NULL,
`robotsf` longtext DEFAULT NULL,
`metatitlet` longtext NOT NULL,
`metadescriptiont` longtext NOT NULL,
`keywordst` longtext NOT NULL,
`robotst` longtext DEFAULT NULL,
`linkf` longtext NOT NULL,
`delete_status` tinyint(20) NOT NULL,
`conical` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `home_seo`
--
INSERT INTO `home_seo` (`id`, `metatitle`, `metadescription`, `keywords`, `robots`, `metatitlef`, `metadescriptionf`, `keywordsf`, `robotsf`, `metatitlet`, `metadescriptiont`, `keywordst`, `robotst`, `linkf`, `delete_status`, `conical`) VALUES
(1, 'Secure Your Financial Future with Velanka Trades LLP', 'Secure your financial future with Velanka Trades LLP. Expert investment advice, NRI services, & more. Own your tomorrow.', 'wealth management, financial planning, NRI services, investment, mutual funds', '', 'Secure Your Financial Future with Velanka Trades LLP', 'Secure your financial future with Velanka Trades LLP. Expert investment advice, NRI services, & more. Own your tomorrow.', 'Ornate Art Products Private Limited', '', 'Finview Consulting: Comprehensive Financial Solutions', 'Secure your financial future with Velanka Trades LLP. Expert investment advice, NRI services, & more. Own your tomorrow.', 'Ornate Art Products Private Limited', '', 'https://system365.cloud/velanka/', 0, 'https://system365.cloud/velanka/');
-- --------------------------------------------------------
--
-- Table structure for table `login`
--
CREATE TABLE `login` (
`id` int(10) NOT NULL,
`email` varchar(150) NOT NULL,
`password` varchar(150) NOT NULL,
`username` varchar(150) NOT NULL,
`mobileno` varchar(150) NOT NULL,
`image` varchar(150) NOT NULL,
`delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `login`
--
INSERT INTO `login` (`id`, `email`, `password`, `username`, `mobileno`, `image`, `delete_status`) VALUES
(1, 'admin@gmail.com', 'aa7f019c326413d5b8bcad4314228bcd33ef557f5d81c7cc977f7728156f4357', 'admin', '9423979339', 'ganpatibappa.jpg', 0);
-- --------------------------------------------------------
--
-- Table structure for table `manage_web`
--
CREATE TABLE `manage_web` (
`id` int(10) NOT NULL,
`photo1` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`photos` varchar(255) NOT NULL,
`sitekey` varchar(255) NOT NULL,
`secretkey` varchar(255) NOT NULL,
`contact` varchar(200) NOT NULL,
`contact1` varchar(200) NOT NULL,
`email` varchar(200) NOT NULL,
`email1` varchar(200) NOT NULL,
`address` varchar(200) NOT NULL,
`captcha` tinyint(4) NOT NULL,
`heading` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `manage_web`
--
INSERT INTO `manage_web` (`id`, `photo1`, `title`, `photos`, `sitekey`, `secretkey`, `contact`, `contact1`, `email`, `email1`, `address`, `captcha`, `heading`) VALUES
(1, '66daa957c998e.png', 'FineView Consulting LLP', '66daa957cb48c.png', '6LdJC4AeAAAAAE638ShRfVSMBDSDjbQmkxD-lh_p', '6LdJC4AeAAAAAMLn9tfGX8_BoZGIwLHgBNiiYgxb', '9673337904', '9145266813', 'vaibhav@finview.co.in', 'tanvi@finview.co.in', 'P.No. 26, Kshipra Housing Society, Karvenagar, Pune- 411052.', 0, 'Under development');
-- --------------------------------------------------------
--
-- Table structure for table `service`
--
CREATE TABLE `service` (
`id` int(11) NOT NULL,
`category` int(50) NOT NULL,
`heading` varchar(200) NOT NULL,
`photo` varchar(200) NOT NULL,
`short_content` varchar(200) NOT NULL,
`content` longtext NOT NULL,
`date` date NOT NULL DEFAULT current_timestamp(),
`amount` varchar(200) NOT NULL,
`metatitle` varchar(200) NOT NULL,
`metadescription` varchar(200) NOT NULL,
`keywords` varchar(200) NOT NULL,
`robots` varchar(200) NOT NULL,
`conical` varchar(100) NOT NULL,
`photo1` varchar(200) NOT NULL,
`delete_status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `service`
--
INSERT INTO `service` (`id`, `category`, `heading`, `photo`, `short_content`, `content`, `date`, `amount`, `metatitle`, `metadescription`, `keywords`, `robots`, `conical`, `photo1`, `delete_status`) VALUES
(1, 0, 'Mutual Funds', '66b360ae1848a.jpg', 'Diversified investment options to grow your wealth with professional fund management.', '<p>The best and intelligent way to invest in equities and various other money market instruments. Mutual funds do carry risk, but it is a calculated and intelligent way of taking risk, as your funds are handled by a professional Fund Manager. There is an overabundance of mutual fund schemes to choose from and that is where we come to your assistance. Over 2500+ mutual fund schemes from 44 asset companies are available to choose from. We ascertain your needs and goals, your risk appetite and the way you wish to invest. Then only we suggest you the schemes you can invest in. You can choose from Lumpsum or “Systematic Investment Plan” (SIP). In SIP, you can invest at fixed intervals, an amount agreed by you as per your abilities and needs. You can invest weekly, monthly, quarterly, daily or fortnightly, though monthly is the most popular option for SIP.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '354.jpg', 1),
(2, 0, 'Bonds', '66b360ba3dd5f.jpg', 'Stable and secure investment avenues offering regular income and capital preservation.', '<p>Bonds are high-security, fixed income instruments that are issued by Central and State governments, corporates and other such entities to raise funds for their ongoing or future projects, but carry some degree of credit risk. They are long term investments and come with the advantage of low risk. An investor must match the timing of his goals with that of the maturity period of bonds and the exit options. Investors with low-risk appetite and are not averse to low interest rate fixed income can look into investment in Bonds.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '292.jpg', 1),
(3, 0, 'NCD', '66b360c669d59.jpg', 'High-yield investment opportunities with fixed returns and low risk.', '<p>Non-convertible debentures are issued by companies to raise funds for various purposes. NCD can be secured or unsecured and have a fixed maturity date and interest rates as per the terms mentioned by the company. They generally have higher interest rates than bonds and fixed deposits by banks. Credit rating of issuing company and certain financial ratios are important to determine the level of risk, but generally are subject to various risks, offer good liquidity options and may offer tax benefits.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '647.jpg', 1),
(4, 0, 'Insurance', '66b9e8242e4a4.jpg', 'Comprehensive protection plans to safeguard your family and assets.', '<p>Most of us are aware of the word Insurance and most of us have it in some form, Car, two-wheeler, house, life or health, car and two-wheeler being common, as these are mandatory to have for your vehicles. In insurance too, many choices are available as many companies have forayed into this business and are working independently or have a tie up with banks and other marketing companies. Premium, policy limit and deductibles are three important components of any insurance type. You can rely on us in helping you to choose the best insurance policy for you. We also suggest to you the type of insurance that you must have. Life is becoming uncertain, accident can happen anytime and health issues are increasing. A regular contribution towards appropriate insurance can hedge against financial losses.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '762.jpg', 1),
(5, 0, 'Tax saving Solutions', '986.jpg', 'Investment options that utilise the provisions of Section 80C of the Income Tax Act, 1961 and allow you to claim tax deductions of up to Rs 1.5 Lacs.', '<p>An income tax return is required to be filed annually. Several options are available under various sections of income tax, that allow you to reduce your tax liability by way of investments that allow you tax rebate. You can save taxes and earn a high return on your investment at the same time. We can suggest many options after looking at possibilities, your financial statements and your needs.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '602.jpg', 1),
(6, 0, 'Child Future Solutions', '838.jpg', 'Child investment plans help you to build a corpus for your child's secure future including their school education, higher studies, and wedding.', '<p>Securing child’s future is very important to every parent as you wish to give the very best future to your children. Higher education, a good career, wedding and supporting your children is of utmost priority to the parents. Costs of all this, especially higher education and wedding have increased manifold. Don’t feel helpless to meet the aspirations of your children. Just a simple saving is no longer enough to beat the inflation and providing adequately for these goals. There are many products that are suitable to achieve these objectives, depending upon your ability to save, time available and the corpus required. We can help you choose the best options for you.</p>', '2024-08-07', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', 'index, follow', 'https://system365.cloud/velanka/service.php', '375.jpg', 1),
(7, 0, 'Retirement Planning Solutions', '370.jpg', 'Planning for retirement is a crucial step in ensuring a secure and comfortable future.', '<p>Retirement is not about saving money only. Various aspects of retirement life and old age has to be considered before providing a near perfect retirement solution. Planning for retirement is a crucial step in ensuring a secure and comfortable future. Our Retirement Planning Solutions are designed to help you build a robust financial plan that ensures a steady income post-retirement. We analyse your current financial status, future needs, and risk tolerance to create a personalized retirement strategy. Whether you’re just starting to plan or are nearing retirement, our solutions are tailored to meet your unique needs and goals, providing peace of mind as you approach your golden years.&nbsp;</p>', '2024-08-12', '', 'Retirement Planning Solutions', 'Retirement Planning Solutions', 'Retirement Planning Solutions', 'index,follow', '', '518.jpg', 1),
(8, 0, 'NRIs Investment', '543.jpeg', 'Returning to India as an NRI comes with its own set of financial challenges and opportunities.', '<p>Our partners were NRI for a long time and have personally understood the investment needs and necessities of fellow NRIs, when they are abroad and specially, when they return back to India.Returning to India as an NRI comes with its own set of financial challenges and opportunities.&nbsp;We curate special packages and offer most suitable options for this purpose to provide steady income, lower income tax and create wealth for you.&nbsp;We offer comprehensive investment options that consider your global assets, tax liabilities, and long-term financial goals. From optimizing your savings to managing your investments, we ensure a smooth financial transition, helping you build a strong financial foundation as you settle back in India.</p>', '2024-08-12', '', 'NRIs Investment', 'NRIs Investment', 'NRIs Investment', 'index,follow', '', '501.jpeg', 1),
(9, 0, 'Systems implementations', '439.jpg', 'Analysing, modifying, and implementing accounting, tax, payroll, and inventory & manufacturing systems. Training users and handholding clients and auditors for drawing first financials post implem', '<p>Achieving your financial goals requires more than just saving—it requires a strategic investment plan. Our Goal-Based Investment Planning service helps you define your financial objectives, whether it’s buying a home, buying a car, planning a holiday abroad, pilgrimage, celebrating important events of life, funding education, or starting a business. We create a personalized investment plan that aligns with your timeline, risk appetite, and financial aspirations. By focusing on your specific goals, we guide you in making informed investment decisions that bring you closer to realizing your dreams.</p>', '2024-08-12', '', 'Goal Based Investment/Planning.', 'Goal Based Investment/Planning.', 'Goal Based Investment/Planning.', 'index,follow', '', '215.jpg', 0),
(10, 0, 'Internal Financial Control (IFC)', '640.jpg', 'Assessing, documenting, designing/redesigning and testing processes for compliance.', '<p>Life is uncertain and unpredictable. Having a contingency fund is to prepare oneself for these uncertainties. This contingency fund can save you spending your savings and investments on an unplanned event. Our Contingency Fund Planning service helps you build an emergency fund that covers unforeseen expenses, such as medical emergencies, job loss, natural disasters, man-made disasters or unexpected repairs. We assess your financial status and recommend a fund size that ensures you’re prepared for any eventuality. With our guidance, you can face life’s uncertainties with confidence, knowing you have a financial buffer in place.</p>', '2024-08-12', '', 'Contigency Fund Planning.', 'Contigency Fund Planning.', 'Contigency Fund Planning.', 'index,follow', '', '345.jpg', 0),
(11, 0, 'CFO services', '598.jpg', 'Providing comprehensive financial advisory, budgeting, inventory management, tax consultancy, fund management services, handling ownership and management change, formation, compliance, taxation and ac', '<p>Analysing, modifying, and implementing accounting, tax, payroll, and inventory &amp; manufacturing systems. Training users and handholding clients and auditors for drawing first financials post implementation</p><p>&nbsp;</p><ul><li>Pre implementation foundation.</li><li>Designing standard controls and validations at master level.</li><li>Testing on UAT database.</li><li>Go Live on new ERP with critical modules, viz. sales, inventory, manufacturing, accounting and procurement.</li><li>Post implementation support.</li></ul>', '2024-09-05', '', 'Services | Univogue Sourcing: Comprehensive Fabric &amp; Textile Solutions', 'Univogue Sourcing Private Limited provides comprehensive fabric sourcing and textile design services to meet your specific requirements. We offer custom sourcing solutions, design development, and qua', 'Fabric Sourcing Services, Textile Design Services, Custom Fabric Sourcing, Design Development', 'Services | Univogue Sourcing: Comprehensive Fabric &amp; Textile Solutions', 'https://system365.cloud/univogue/service.php', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `service_seo`
--
CREATE TABLE `service_seo` (
`id` int(11) NOT NULL,
`metatitle` longtext NOT NULL,
`metadescription` longtext NOT NULL,
`keywords` longtext NOT NULL,
`robots` longtext DEFAULT NULL,
`metatitlef` longtext NOT NULL,
`metadescriptionf` longtext NOT NULL,
`keywordsf` longtext NOT NULL,
`robotsf` longtext DEFAULT NULL,
`metatitlet` longtext NOT NULL,
`metadescriptiont` longtext NOT NULL,
`keywordst` longtext NOT NULL,
`robotst` longtext DEFAULT NULL,
`linkf` longtext NOT NULL,
`conical` longtext NOT NULL,
`delete_status` tinyint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `service_seo`
--
INSERT INTO `service_seo` (`id`, `metatitle`, `metadescription`, `keywords`, `robots`, `metatitlef`, `metadescriptionf`, `keywordsf`, `robotsf`, `metatitlet`, `metadescriptiont`, `keywordst`, `robotst`, `linkf`, `conical`, `delete_status`) VALUES
(1, 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'financial services, investment solutions, insurance plans, tax planning, NRI financial advice', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'Ornate Art services Private Limited', '', 'Comprehensive Financial Solutions | Velanka Trades LLP', 'Financial solutions for all. Mutual funds, insurance, tax, NRI. Achieve your goals with us.', 'Ornate Art services Private Limited', '', 'https://system365.cloud/velanka/service.php', 'https://system365.cloud/velanka/service.php', 0);
-- --------------------------------------------------------
--
-- Table structure for table `slider`
--
CREATE TABLE `slider` (
`id` int(10) NOT NULL,
`photo` varchar(300) NOT NULL,
`heading` varchar(300) NOT NULL,
`heading1` varchar(200) NOT NULL,
`delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `slider`
--
INSERT INTO `slider` (`id`, `photo`, `heading`, `heading1`, `delete_status`) VALUES
(1, '117.png', 'Your Trusted Financial Partners', 'As your trusted financial partners, we empower your business to thrive in dynamic markets with tailored expertise and innovative solutions.', 0);
-- --------------------------------------------------------
--
-- Table structure for table `team`
--
CREATE TABLE `team` (
`id` int(11) NOT NULL,
`name1` varchar(200) NOT NULL,
`designation` varchar(200) NOT NULL,
`description` varchar(500) NOT NULL,
`photo` varchar(200) NOT NULL,
`delete_status` tinyint(2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `team`
--
INSERT INTO `team` (`id`, `name1`, `designation`, `description`, `photo`, `delete_status`) VALUES
(1, 'Tiya Kapoor', 'Business Expert', '', '800.jpg', 1),
(2, 'Vikram Patel', 'Managment', '', '617.jpg', 1),
(3, 'Amit Kumar', 'Founder', '', '661.jpg', 1),
(4, 'Mitali Sharma', 'Consultant', 'Chartered Accountant with an experience of 12 years across a broad spectrum of industries viz. banking, insurance, retail, auto and auto components, film distribution, and veterinary industry. Experienced in leading finance transformation projects. Passionate about strategic finance and systems implementation including business controls set up.', '795.jpg', 1),
(5, 'Tanvi Paranjape', 'Secretory', 'Company Secretary and Masters in Finance having blended experience of 10 years in compliance, corporate finance and systems implementations & finance and compliance function transformations . Previous experience in manufacturing, trading and service sectors in various industries. Field experience as finance controller and cost controller.', '66d9ae65505fc.jpg', 0),
(6, 'Vaibhav Gunjkar', 'Chartered Accountant', 'Chartered Accountant with an experience of 12 years across a broad spectrum of industries viz. banking, insurance, retail, auto and auto components, film distribution, and veterinary industry. Experienced in leading finance transformation projects. Passionate about strategic finance and systems implementation including business controls set up.', '66d9ae8d4d88d.jpg', 0),
(7, 'f', 'ff', 'rgrg', '283.png', 1);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `about_seo`
--
ALTER TABLE `about_seo`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contactus`
--
ALTER TABLE `contactus`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contact_seo`
--
ALTER TABLE `contact_seo`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `emailsetting`
--
ALTER TABLE `emailsetting`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `home_seo`
--
ALTER TABLE `home_seo`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `login`
--
ALTER TABLE `login`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `manage_web`
--
ALTER TABLE `manage_web`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `service`
--
ALTER TABLE `service`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `service_seo`
--
ALTER TABLE `service_seo`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `team`
--
ALTER TABLE `team`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `about_seo`
--
ALTER TABLE `about_seo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `contactus`
--
ALTER TABLE `contactus`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `contact_seo`
--
ALTER TABLE `contact_seo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `emailsetting`
--
ALTER TABLE `emailsetting`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `home_seo`
--
ALTER TABLE `home_seo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `manage_web`
--
ALTER TABLE `manage_web`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `service_seo`
--
ALTER TABLE `service_seo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `team`
--
ALTER TABLE `team`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
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 */;