-- phpMyAdmin SQL Dump -- version 4.9.0.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 16, 2019 at 09:49 AM -- Server version: 10.4.6-MariaDB -- PHP Version: 7.3.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `client_experience` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `contact` varchar(15) NOT NULL, `usertype` int(11) NOT NULL COMMENT '1 for Admin, 2 for Client', `lastlogin` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `image` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `username`, `password`, `name`, `email`, `contact`, `usertype`, `lastlogin`, `image`) VALUES (1, 'prahlad@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', 'RH Digisoft', 'info@rhdigisoft.com', '8896889678', 1, '2019-10-15 05:51:16', 'profile_logo_.png'); -- -------------------------------------------------------- -- -- Table structure for table `blog` -- CREATE TABLE `blog` ( `id` int(10) NOT NULL, `blogcategory` varchar(50) NOT NULL, `blogtitle` varchar(200) NOT NULL, `blogimage` varchar(50) NOT NULL, `featuredimage` varchar(255) NOT NULL, `blogcontent` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `status` varchar(1) NOT NULL DEFAULT '1', `uniqueTitle` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `blog` -- INSERT INTO `blog` (`id`, `blogcategory`, `blogtitle`, `blogimage`, `featuredimage`, `blogcontent`, `date`, `status`, `uniqueTitle`) VALUES (29, '4', ' “SEO†– “INCREASE YOUR TRAFFIC INCREASE YOUR BUSINESSâ€', '30042018093432imgpsh_fullsize.png', '', '
Hello everyone!!
\r\n\r\nWant to get top rankings on your website? RHDigisoft is one of the best SEO Company and guarantees you to give top rankings and traffic to your website.
\r\n\r\nAs we all know, in this era of digitalization being digitally present is as important as having a physical address for you company or business. As the world is evolving every day, so is the new and upcoming generation, as we all expect to do many things from our mobile devices (smart phones and laptops) as much as possible.
\r\n\r\nThe day when everything is digitalized is not far as we are evolving in the field of technology, so in order to grow your business and have a digital presence is necessary.
\r\n\r\nBefore this, first thing is to know what exactly SEO is. Now let us give you some idea of SEO and its process. Trust us it is a very interesting process and also very helpful to grow your business beyond your thinking.
\r\n\r\n.
\r\n\r\n\r\n\r\n
What is SEO?
\r\n\r\n– “Search Engine Optimization” is a process with the intention to divers the position of your website in a search engine’s non-paid results, also known as “natural”, “earned” results to gain higher ranking on search engine’s visibility area.
\r\n\r\nSearch engine optimization is a search engine technique which helps you to bring your website on top on search engine for some particular keywords.
\r\n\r\nWhy we use SEO?
\r\n\r\nWhat is white Hat SEO?
\r\n\r\nWe use White Hat SEO and it follows all the guidelines of search engine .It is very efficient as white hat SEO provides long lasting growth in rankings.
\r\n\r\nWe should always use White Hat SEO.
\r\n\r\nNow let us come to the techniques we use to do this SEO process so that you can get idea of this which will help you to grow your business.
\r\n\r\nProcess of SEO:-
\r\n\r\n\r\n\r\n
Techniques we use:-
\r\n\r\nOptimization of the website is done according to the guidelines of search engine. By doing this off page optimization on the website we always get natural results.
\r\n\r\nTechniques includes:-
\r\n\r\nWe always have to avoid broken links.
\r\n\r\n\r\n\r\n
\r\n\r\n
Techniques includes -
\r\n\r\nYou must be thinking of what is the need of link building and other process.
\r\n\r\nFirst thing is it helps us to get higher Google page rank. Another reason is that it increases the Online Reputation of the website with quality back links.
\r\n\r\n\r\n\r\n
\r\n\r\n
Like this we use many techniques to do On Page and Off Page optimization.
\r\n\r\nSo friends, now you must have got some idea of what SEO is and how it helps you to increase your business online. Isn’t it interesting that how fast your business can grow with the help of this SEO process?
\r\n\r\nIf you want any help from us or want to know more about SEO process and how we work, please contact us anytime you want. We provide best SEO services with SEO expert and will love to serve because our motive is to satisfy you.
\r\n\r\nHave a great day!!!
\r\n', '2018-05-03 11:30:12', '1', 'seo-increase-your-traffic-increase-your-business'), (30, '4', 'Why SEO is necessary for online business?', '300420181205061503201806374221012018061912seo.jpg', '30042018120506thumb.jpg', 'Simply, creating a website and hosting it in World Wide Web is not just enough. Until and unless your website is visible on Search Engines, one cannot highly benefit from it and make it productive. Let's say you have a great website built in latest design trend & technology, but later you find out your analytics shows zero visits. This is because no one knows your existence on the Internet. The website, it's the latest technology, design trends become worthless if no one finds it. The solution to this is Search Engine Optimization.
\n\nLet's see why SEO is so vital:
\n\nSeo is important as it:
\n\n· Increase Traffic
\n\n· SEO is not a cost but Investment
\n\n· Higher Brand Credibility
\n\n· Reach a wider audience:
\n\n· Your competitors are doing it
\n\nTypes of SEO:
\n\nOn page and off page factors are two different aspects of your SEO efforts which work towards getting qualified traffic which provides the path that leads towards conversion
\n\n· On-page SEO:
\n\nOn page SEO refers to the text and content on your web site pages. It acts as the foundation for your ongoing SEO process. This has a significant impact on search engine results you should make your site as search engine friendly as possible.
\n\n\n\n
· Off Page SEO:
\n\nOff page SEO is a process of putting the written content on the websites other than the website being promoted, for example, creating a 'guest post' for another blog or posting a video on YouTube.
\n\nSEO is a never-ending process. If you're not moving forward and refining your position, you're behind ground to your competitor. Ranking high on Google is very important if you want lots of visitors to your website.
\n', '2018-05-03 11:43:41', '1', 'why-seo-is-necessary-for-online-business'), (31, '4', 'Beneficial Tools to Track Website Traffic Better Then You', '03052018112831imgpsh_fullsize.png', '03052018112831thumb.png', 'Hi friends!!
\r\n\r\nHope you all are doing well. As previously we were talking about SEO and its process, but today we will share details about website traffic and how to measure it.
\r\n\r\nIn theory website traffic refers to an amount of web user who come to a website. Website traffic calculated in visits. Which also known as “sessions” A common way to evaluate trade effectiveness of engaging peoples.
\r\n\r\nNow it’s very important to know about the tools that are used to collect information data related to website traffic.
\r\n\r\nToday we are covering two tools that are beneficial to calculate website visits. One is Google Analytics and second is Google Webmaster Tool.
\r\n\r\nWhen the Best Digital Marketing agency work so hard to get traffic and top rankings to the website, don’t you feel it is so important to check the status of our hard work or analyze and optimize visibility of our website?
\r\n\r\nLet us see what all we do using these tools and how huge impact it gives us for increasing traffic and ranking of our website.
\r\n\r\nFirst point is that what is Google Analytics?
\r\n\r\n\r\n\r\n
Google Analytics
\r\n\r\nIt doesn’t matter which type of business you are running and which type of website you are working for. You can find out the performance of the website by using this or you can ask us as we are one of the Best Digital Marketing agencies.
\r\n\r\nReasons why we use Google Analytics
\r\n\r\nNext thing is what is Google Webmaster Tools?
\r\n\r\n\r\n\r\n\r\n\r\n
Google Webmaster
\r\n\r\nGoogle Webmaster Tools is a web service which is free of cost given by Google for web masters. This is a very crucial tool for SEO.
\r\n\r\nFurther we are going to discuss the important role Google Webmaster play in the SEO process.
\r\n\r\nReasons why we use Google Webmaster Tool
\r\n\r\nHence, Google Webmaster Tool is for a very fast and easy way to analyze, improve and solve problems in the SEO process. It reduces the time of analysis, so we don’t have to just stuck to one thing to solve the problems as it has various functions which reduces the waste of time.
\r\n\r\n\r\n\r\n
Basically in Google Webmaster Tool it’s all about how search engine interacts with our site whereas in Google Analytics it’s all about how website users interact with our site.
\r\n\r\nFriends, our motive to write this article was to give you the idea of Google Analytics Tools and Google Webmaster Tool and what are its uses, so that it can help you to understand SEO in more depth.
\r\n\r\nFor more details or any help you can ask your queries in the comment section below or contact us anytime. We are here to help you.
\r\n\r\nHope you have enjoyed reading the above article and also don’t forget to share this article with others in your circle (personal or professional) who needs this information and follow us on Facebook for some amazing articles based on “Search Engine Optimization” and its techniques and their uses.
\r\n\r\nHave a great day!!!
\r\n', '2018-05-03 12:40:10', '1', 'beneficial-tools-to-track-website-traffic-better-then-you'), (32, '5', 'Why your Business needs a Social Media Management', '08052018055226smm.jpg', '08052018055226smm-thumb.jpg', 'When we are thinking of a business and all process to achieve our goals for the success of our business, then one question usually arrives inside our mind that why we need Social Media Management?
\r\n\r\nLet us give you the answer of this in a very simple and clear way.
\r\n\r\nWhen you have a business it is very important to promote your business organically using Social Media Sites.
\r\n\r\n\r\n\r\n\r\n\r\n
Best way to give confidence to the people about your business is by doing Social Media marketing.
\r\n\r\nFollowing are some of the reasons why we need a Social Media Management.
\r\n\r\nBusiness.
\r\n\r\n\r\n\r\n
Friends as you might be knowing that there are so many social networking sites in which we can do social media management with lots of creative ideas through which you can get more and more users which will help you to grow your business and make it successful, so that you can achieve your business goals.
\r\n\r\n\r\n\r\nHope you got the answer as it has been explained in a very easy and simple way. But friends if you want more information or some ideas for Social Media Management please contact us anytime or you can comment in the comment section below. We are always here to help you out.
\r\n\r\nHave a great day!
\r\n', '2018-05-08 05:52:26', '1', 'why-your-business-needs-a-social-media-management'), (33, '6', 'Techniques We Use For Web Development', '08052018061411html.jpg', '08052018061411html-thumb.jpg', 'Hello everyone!
\r\n\r\nDo you have an idea of how a web development company works? What are the techniques used by the company? We are here to tell you about web development and what all we do in this.We work with multiple platforms, database and languages. We are great in planning building and implementation process of each and every projectsand give the best to satisfy our customers. So guys below are the list of technologies we use and also if you are interested for something apart from the given list please contact us .We will love to help you.
\r\n\r\n\r\n\r\n
Here Are the Programming Languages We Use
\r\n\r\n· HTML 5
\r\n\r\n· CSS 3
\r\n\r\n· JavaScript
\r\n\r\n· Bootstrap
\r\n\r\n· JQuery
\r\n\r\n\r\n\r\n
Database Management Systems We Are Using
\r\n\r\n· MySQL
\r\n\r\n\r\n\r\n
Platforms We Are Using
\r\n\r\n· WordPress
\r\n\r\n· Magento
\r\n\r\n· PHP
\r\n\r\n· Laravel
\r\n\r\n· Opencart
\r\n\r\n\r\n\r\n
We have a special capability in E-Commerce like OnlineShopping Sites etc. and also in Payment Integration.
\r\n\r\n\r\n\r\n
Now let us give a brief idea of what exactly is E-Commerce and open cart.
\r\n\r\n\r\n\r\n
WHAT IS E-COMMERCE?
\r\n\r\nBasically E-Commerce is purchasing and selling of products or servicesor transferring funds and data via electronic medium over the internet .It is also known as e-Business.E-commerce was first introduced in the 1960s via an electronic data interchange (EDI) on value-added networks (VANs). As digital technologies evolved over the years like that only E-Commerce also evolved over the years and demand is increasing day by day. Because of this huge demand for E-Commerce now it is the great opportunities for businesses to expand their business in online world as the use of digital technology is increasing day by day.
\r\n\r\n\r\n\r\n
The reason for this boom in E-Commerce is that it has made the life of people so easy that we don’t have to go here and there to purchase or sell things .Everything is done online and it reduces the waste of time and money. So you can do shopping or selling without physical presence.
\r\n\r\nE-COMMERCE WEBSITE
\r\n\r\nE-Commerce website is a site where this process of selling and purchasing of products and services is done through internet. There are different types of E-Commerce website according to the field.
\r\n\r\nPreviously in commerce people used phone calls, emails , and process was mostly done physically .Now in E-Commerce website every process is done online like purchasing ,selling and transactions can be done at one place .These E-Commerce websites has made the life of people very easy and convenient.
\r\n\r\n\r\n\r\n
There are different types of E-Commerce Websites
\r\n\r\nBased on what functions they accomplish, there are different types of E-commerce websites.
\r\n\r\n\r\n\r\n
\r\n\r\n
WHAT IS OPEN CART?
\r\n\r\nOPEN CART is an open source software of e-commerce which is used to build online store. It is based on PHP using MYSQL database and html components. It provides a great foundation from which we can help us to have a strong hold over the customization of the store.
\r\n\r\nAdvantage of Open Cart -
\r\n\r\n\r\n\r\n
So friends you must have got some information about web development and hope you will get some exciting ideas through this. We are always ready and will love to implement your ideas.For any help contact us and also you can ask your questions in comment section.Have a nice day.
\r\n', '2018-05-08 06:14:11', '1', 'techniques-we-use-for-web-development'), (35, '4', 'Why Small Business needs SEO', '15052018060828SMO3.jpg', '15052018060828blog-thumb2.jpg', 'Planning for a startup or want to increase the presence of your business in this huge and competitive business world?
\r\n\r\nThen you must have to know how important it is to do the SEO process for your business. SEO is Search engine optimization which is to increase the traffic to your website and make your business successful by bringing your website to the top of Google Search Engine.
\r\n\r\nIf you are doing some business and there is no presence of your business in the digital world then it is rarely possible to increase your business as these days most people are doing each and everything via phone laptops etc. These days most of the customers search for any information or need through digital medium only. So the more digital presence you have the more successful will be your business.
\r\n\r\nHere are some reasons why your business needs SEO
\r\n\r\n\r\n\r\n
This is gainful on the grounds that customers will probably believe a brand that shows up in the best positions instead of those towards the base of the outcomes list.
\r\n\r\n\r\n\r\n
\r\n\r\n
\r\n\r\n
A high positioning site will likewise rank high in the query item with an introduction from their web-based social networking stages.
\r\n\r\nThe notoriety of online networking stages is perfect for SEO, while SEO builds its perceivability.
\r\n\r\n\r\n\r\n
Hence SEO is for long-term success. It can accomplish your long-term goals.
\r\n\r\nFriends after reading this hope you got the idea of how important SEO is and what huge impact it gives to your business.
\r\n\r\nRH Digisoft is one of the best SEO company and gives Best SEO services and if you want more information regarding this or any help or services we are here for you.
\r\n', '2018-05-15 06:08:28', '1', 'why-small-business-needs-seo'), (36, '4', 'SEO Goals: what you can expect from SEO', '24052018075016post-4.jpg', '24052018075016blog-thumb3.jpg', 'Well, Folks, we know you have a wonderful website to give that business of yours a perfect online presence.
\r\n\r\nFirst of all what is SEO? Has already been explained in earlier articles and now the main part remains choosing what you actually want out of SEO for your perfect site.
\r\n\r\nWe are here to discuss some of the common misconceptions about SEO and their logical and obvious solutions.
\r\n\r\n\r\n\r\n
Look forward to these out of your SEO:
\r\n\r\nLet’s get started with the Traffic first:
\r\n\r\nWell, you cannot earn traffic not only with SEO we need to a lot more than a healthy SEO to get a hell lot of Organic traffic to your site, which not only generates enough leads that you can spend on maintaining your SEO Agency. And also finds some increase in your business opportunity.
\r\n\r\n\r\n\r\n
Rank:
\r\n\r\nNow, let’s get to the rank part for your keywords that is, if you are already done choosing your perfect keywords for your different pages. Well, keywords are the best way to represent your site and services so, of-course you need to
\r\n\r\n\r\n\r\n
Lead Generation:
\r\n\r\nNow let’s talk about some Lead Generation, if your main goal for that perfect website of yours is to generate leads for another reason. Well lead generation is an art whether it’s just for a gig you want to do for another project or your dream project.
\r\n\r\nAppropriate Audience:
\r\n\r\nSelecting an audience worth your time and which actually benefits from your services is a must. Well, feel it this way you are wasting yours and your agency’s time on a region where there is no way to provide the services you offer is like way off your main goal and think how much more money you are wasting on that campaign.
\r\n\r\n\r\n\r\n
Now for the finale we have a very interesting fact about SEO which is to increase your Domain Authority, well DA for a site is measured on more factors than anyone can imagine some of them are as below
\r\n\r\nBut, let’s skip the technicality for these stuffs and leave these to the agency you are hiring for that critical part.
\r\n\r\n\r\n\r\n
But, simply get this as an opportunity to clear your end goal from the site and enjoy the benefits of SEO for the goal you have decided to go with.
\r\n\r\n\r\n\r\n
Now let’s dig a little deeper into the above factors which were explained briefly to get your attention to the matter of the fact that you cannot assume for Traffic when your goal is Google rankings.
\r\n\r\nThe beauty of Digital Marketing is that you can have traffic even without getting First page for your Website. But, if you are expecting Rank and Traffic at the same time you cannot put a pressure on your SEO agency to do the same in less time from what they offered.
\r\n\r\n\r\n\r\n
Traffic:
\r\n\r\nThere are many ways you can divert interested clients to your site and that too who are in dire need of the service you offer.
\r\n\r\nTraffic is a factor which also helps to gain a lot of effective ranks for those keywords you need you site to be nicknamed for.
\r\n\r\n\r\n\r\nKeyword:
\r\n\r\nWell no doubt that keywords play the most vital role in SEO. For example let me tell you something very important that first of all taking 1000 keywords for a 5-10 page website is unnecessary since, it not only complicates the work process but also effects the end results.
\r\n\r\nNow let’s talk about a logical but obvious solution for these misconceptions. First of all only take keywords which are highly searched on search engines or let the Best SEO Agency do that research for you and provide you with a list of keywords which are not only been searched all over the world but also describe your site/service perfectly. Then select the appropriate regions where you actually need a ground for that business of yours. We suggest select a region where you can provide your services easily even if your client ask for face to face meeting you are physically present in that region to do so.
\r\n\r\nThen come the part to choose what you actually need out of your site (Lead, Traffic, Rank etc.)
\r\n\r\nNow, I suppose you have all that is required to get started with the SEO part. Then I would suggest you not to waste time on overthinking about it and hire an SEO Expert who can consult you for these.
\r\n\r\nFolk’s let me clear one more thing since we are already on the topic of Seo is that try to take 10-20 Keywords top (based on relevancy and search volume all over the globe) and don’t ever listen to a guy who says that you can rank your site for every keyword you can imagine.
\r\n\r\nCommon problems we the SEO Agencies face is working on keywords which are literally not searched by anyone all around the globe and even it’s not our fault clients go unsatisfied which in terms of client-business relation is not at all appropriate.
\r\n\r\nSecondly working in a region where client is not even able to provide their services is a waste of time. So our suggestion is that you talk to your SEO Expert about these before hiring them to just work on your site.
\r\n\r\n\r\n\r\nLast but not the least understanding a little about how Google crawls your backlinks is totally up-to Google you can never expect Google to crawl every link you make so, when your SEO Agency tells you that your Page ranking might be at delay because of Google Crawlers then please don’t take it as an excuse and give them benefit of the doubt.
\r\n\r\n\r\n\r\n
Well, the conclusion of this lengthy article is you cannot get rank for every keywords and our suggestion is to dump the ineffective Keywords and let your Agency Focus on the Effective one’s.
\r\n', '2018-05-24 07:55:21', '1', 'seo-goals-what-you-can-expect-from-seo'), (37, '', '', '14062018112832', '', '', '2018-06-14 09:28:32', '1', ''), (38, '', '', '14062018113427', '', '', '2018-06-14 09:34:27', '1', ''), (39, '', '', '14062018113510', '', '', '2018-06-14 09:35:10', '1', ''); -- -------------------------------------------------------- -- -- Table structure for table `blog_category` -- CREATE TABLE `blog_category` ( `cat_id` int(11) NOT NULL, `blog_category` varchar(255) NOT NULL, `unique_title` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `blog_category` -- INSERT INTO `blog_category` (`cat_id`, `blog_category`, `unique_title`) VALUES (4, 'SEO', 'seo'), (5, 'SMO', 'smo'), (6, 'Web Development', 'web-development'), (7, 'Android & Ios Development', 'android-&-ios-development'); -- -------------------------------------------------------- -- -- Table structure for table `clientsec` -- CREATE TABLE `clientsec` ( `img_id` int(11) NOT NULL, `image` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `clientsec` -- INSERT INTO `clientsec` (`img_id`, `image`) VALUES (8, '26122017113329kdp-mgi.png'), (9, '26122017113339kothari.png'), (10, '26122017113453pt1.png'), (11, '26122017113504pt2.png'), (12, '26122017113513pt3.png'), (13, '26122017113611pt4.png'), (14, '26122017113622pt5.png'), (15, '26122017113631pt6.png'), (16, '26122017113640pt7.png'), (17, '26122017113649pt8.png'), (18, '26122017113658pt9.png'), (19, '26122017113707pt10.png'); -- -------------------------------------------------------- -- -- Table structure for table `client_project` -- CREATE TABLE `client_project` ( `pro_id` int(11) NOT NULL, `TransactionID` bigint(22) DEFAULT NULL, `package_name` varchar(255) NOT NULL, `subs_date` varchar(20) NOT NULL, `bill_cycle_date` varchar(20) NOT NULL, `total_amount` float NOT NULL, `paid_amount` float NOT NULL, `project_cat` int(11) NOT NULL, `user_id` int(11) NOT NULL, `userid` int(11) NOT NULL, `status` int(1) NOT NULL DEFAULT 1, `current_paid` varchar(20) NOT NULL, `current_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `PackageCat` int(15) NOT NULL, `PackageID` int(11) NOT NULL, `PurchasedForMonth` int(15) NOT NULL, `PackageName` varchar(100) NOT NULL, `ProjectName` varchar(100) NOT NULL, `Amount` int(11) NOT NULL, `payment_status` tinyint(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `client_project` -- INSERT INTO `client_project` (`pro_id`, `TransactionID`, `package_name`, `subs_date`, `bill_cycle_date`, `total_amount`, `paid_amount`, `project_cat`, `user_id`, `userid`, `status`, `current_paid`, `current_date`, `PackageCat`, `PackageID`, `PurchasedForMonth`, `PackageName`, `ProjectName`, `Amount`, `payment_status`) VALUES (1, NULL, '', '', '', 0, 0, 0, 0, 0, 1, '', '2018-02-02 16:03:45', 0, 0, 0, '', '', 0, 0), (2, NULL, 'Plus', '12-04-2018', '12-05-2018', 399, 399, 1, 20, 0, 1, '', '2018-04-12 09:53:17', 0, 0, 0, '', '', 0, 0), (3, NULL, '', '', '', 0, 0, 0, 0, 0, 1, '', '2018-05-17 12:27:48', 1, 3, 1, 'Professional', 'rajesh', 549, 0), (4, NULL, '', '', '', 0, 0, 0, 0, 0, 1, '', '2018-05-17 12:40:26', 1, 2, 1, 'Plus', 'ter', 399, 0), (5, NULL, 'Premier', '', '', 699, 0, 1, 20, 0, 1, '', '2018-05-17 12:46:03', 0, 4, 1, '', 'radhe', 0, 0), (6, 2147483647, 'Plus', '', '', 399, 0, 0, 6, 0, 1, '', '2019-10-11 03:19:02', 0, 2, 1, '', 'krishna', 0, 0), (7, 2147483647, 'Plus', '', '', 399, 200, 0, 6, 0, 1, '200', '2019-10-15 05:14:04', 0, 2, 1, '', 'test test', 0, 0), (8, 2147483647, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 05:06:02', 0, 2, 1, '', 'ccavn', 0, 0), (9, 0, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 05:48:54', 0, 2, 1, '', 'fdfhgdch', 0, 1), (10, 2147483647, 'Premier', '', '', 699, 0, 0, 0, 0, 1, '', '2018-05-18 05:39:32', 0, 4, 1, '', 'aaaaaaaaa', 0, 0), (11, 0, 'Premier', '', '', 699, 0, 0, 0, 0, 1, '', '2018-05-18 05:48:54', 0, 4, 1, '', 'qrtpppppp', 0, 1), (12, 2147483647, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 05:48:31', 0, 2, 1, '', 'ravi', 0, 0), (13, 83, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 05:56:54', 0, 2, 1, '', 'sssssssssssssssss', 0, 0), (14, 0, 'Professional', '', '', 549, 0, 0, 0, 0, 1, '', '2018-05-18 06:10:56', 0, 3, 1, '', 'rajesh', 0, 1), (15, 0, 'Professional', '', '', 549, 0, 0, 0, 0, 1, '', '2018-05-18 06:10:56', 0, 3, 1, '', 'rajesh', 0, 1), (16, 53137630, 'Professional', '', '', 549, 0, 0, 0, 0, 1, '', '2018-05-18 06:10:41', 0, 3, 1, '', 'vvvvv', 0, 0), (17, 2147483647, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 09:03:50', 0, 2, 1, '', 'test project', 0, 0), (18, 2147483647, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 09:04:15', 0, 2, 1, '', 'test project', 0, 0), (19, 2147483647, 'Plus', '', '', 399, 0, 0, 0, 0, 1, '', '2018-05-18 09:05:09', 0, 2, 1, '', 'test ', 0, 0), (20, 8473585152, 'Professional', '', '', 549, 0, 0, 0, 0, 1, '', '2018-05-18 09:34:22', 0, 3, 1, '', 'test ', 0, 0), (21, 4474459285, 'Professional', '', '', 549, 0, 0, 0, 0, 1, '', '2018-05-18 09:46:57', 0, 3, 1, '', 'test 12', 0, 0), (22, 6100967773, 'Basic', '', '', 299, 0, 0, 0, 0, 1, '', '2018-05-18 09:56:48', 0, 1, 1, '', 'sdssa', 0, 0), (23, NULL, 'Plus', '16-10-2019', '16-11-2019', 399, 399, 1, 71, 0, 1, '', '2019-10-16 07:03:33', 0, 0, 0, '', '', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `comment` -- CREATE TABLE `comment` ( `id` int(11) NOT NULL, `blog_id` varchar(255) NOT NULL, `name` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `comment` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `status` int(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `comment` -- INSERT INTO `comment` (`id`, `blog_id`, `name`, `email`, `comment`, `date`, `status`) VALUES (40, '18', 'rajesh kumar', 'rajesh@gmail.com', 'this is nice blog ', '2018-04-25 05:18:54', 1), (42, '20', 'atul kumar', 'arulkr12@gmail.com', 'I have a Website i want to be rank in google so which type of activity is effective for my website......', '2018-04-26 10:16:53', 1), (43, '35', 'Digital Marketing at Mumbai', 'ralettaajay@gmail.com', 'Very help full blog , informative and interesting ', '2018-05-17 12:24:51', 0), (44, '36', 'prahlad', 'prahlad.gupta@gmail.com', 'hello', '2018-05-30 09:05:05', 0); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- CREATE TABLE `customer` ( `id` int(11) NOT NULL, `title` varchar(30) NOT NULL, `fname` varchar(50) NOT NULL, `mobile` varchar(15) NOT NULL, `landline` varchar(15) NOT NULL, `email` varchar(50) NOT NULL, `address` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `postaladd` varchar(300) NOT NULL, `pcity` varchar(255) NOT NULL, `pstate` varchar(255) NOT NULL, `pzip` varchar(10) NOT NULL, `billingadd` varchar(300) NOT NULL, `city` varchar(100) NOT NULL, `state` varchar(100) NOT NULL, `zipcode` varchar(10) NOT NULL, `country` varchar(100) NOT NULL, `website` varchar(100) NOT NULL, `skypeid` varchar(100) NOT NULL, `aboutme` varchar(300) NOT NULL, `profilepic` varchar(100) NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `customer` -- INSERT INTO `customer` (`id`, `title`, `fname`, `mobile`, `landline`, `email`, `address`, `password`, `postaladd`, `pcity`, `pstate`, `pzip`, `billingadd`, `city`, `state`, `zipcode`, `country`, `website`, `skypeid`, `aboutme`, `profilepic`, `date`) VALUES (1, '', 'Atul', '9045865', '', 'atul@gmail.com', '', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2019-10-11 03:12:15'), (4, 'Mr.', 'Ankur Mishra', '9045863209', '5698', 'ankur.infoniti@gmail.com', 'Mahadeva Mohalla', 'e10adc3949ba59abbe56e057f20f883e', 'Mahadeva', 'Gorakhpur', 'Up', '273402', 'Dwarka Delhi', 'gorakhpur', 'Up', '273402', 'India', 'ankur.com', 'ankur.proict', 'I m ankur', '26122017105037460814.jpg', '2018-01-16 07:16:41'), (5, 'Mr.', 'Prahlad Gupta', '9990011043', '', 'prahlad.gupta1988@gmail.com', 'hello', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '', '', 'jaipur', 'rajasthan', '201301', 'india', 'www.rhdigisoft.com', 'prahlad123453', 'Hey Karthik, Happy new year buddy\r\nmay god bless you with great success and happy life in this new year :)\r\nHey Karthik, Happy new year buddy\r\nmay god bless you wi', '', '2019-10-11 03:09:34'), (6, 'Mr.', 'atul', '8896881603', '', 'atulkr12@gmail.com', '', '3202d4f5bdcc2e914fb57a21262afae9', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2019-10-15 06:25:03'), (8, 'Mr.', 'Adrian', '01329693147', '', 'wohihogef@minex-coin.com', '', '4297f44b13955235245b2497399d7a93', '', '', '', '', '', '', '', '', 'uk', '', '', '', '', '2018-01-16 07:16:41'), (9, 'Mr.', 'Karthik V. Ambakad', '7143315911', '', 'info@kreativeteksolutions.com', '', '2cd986e4e8afd8e52aaf12c2e20f2f77', '', '', '', '', '', 'Placentia', 'CA', '92870', 'USA', 'https://www.kreativeteksolutions.com', 'kva123451', '', '', '2018-01-16 07:16:41'), (11, 'Mr.', 'sagar vig', '9503325349', '', 'sagarvig3@gmail.com', '', 'e5585eaca1cdba51f88516c27c1b6523', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2018-01-16 07:16:41'), (12, 'Mr.', 'mahesh', '8896850008', '', 'mahesh@gmail.com', '', '1f5532f7f3d683092f484c6951ebaad4', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2018-01-16 07:16:41'), (14, 'Mr.', 'krishna', '8896881603', '', 'krishnaveer@gmail.com', '', '243bd1ce0387f18005abfc43b001646a', '', '', '', '', '', '', '', '', 'India', '', '', '', '11012018062316Andrue_2.jpg', '2018-01-16 07:16:41'), (15, 'Mr.', 'jitesh Gupta', '9958411634', '', 'jiteshgupta1992@gmail.com', '', '4aacd7f6a06e4071d328a3b2c9986701', '', '', '', '', '', '', '', '', 'india', '', '', '', '', '2018-01-17 05:23:19'), (16, 'Mr.', 'Brajesh', '8510017579', '', 'brajeshroy65@gmail.com', 'Mamura chowk', 'e10adc3949ba59abbe56e057f20f883e', 'Mamura chowk', 'Noida', 'Up', '203598', '', 'Noida', 'Up', '203598', 'India', '', 'brajeshroy.1', '', '17012018124055piret.jpg', '2018-01-17 12:40:55'), (17, 'Mr.', 'prateek', '7838949711', '', 'prateeku87@gmail.com', '', '3d232e8f499a3342edeeaafefd62e7d1', '', '', '', '', '', '', '', '', 'india', '', '', '', '', '2018-01-30 08:03:31'), (18, 'Mr.', 'mayank', '9878766554', '', 'mayank@gmail.com', '', '308a3820e4cccbe043cb5228de5e71e3', '', '', '', '', '', '', '', '', 'india', '', '', '', '', '2018-02-09 11:17:14'), (21, 'Mr.', 'brajesh', '8510017579', '', 'brajeshroy65@gmail.com', '', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '', '', '', '', '', 'india', '', '', '', '', '2018-03-14 06:04:13'), (22, 'Mr.', 'sohail', '8802458563', '', 'sohail.k@gmail.com', '', '202cb962ac59075b964b07152d234b70', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2018-03-17 07:06:12'), (28, 'Mr.', 'Brajesh Roy', '8510017579', '', 'brajesh.rhdigisoft@gmail.com', '', '373240481e102eee4a858a518e5ba4ad', '', '', '', '', '', '', '', '', 'US', '', '', '', '', '2018-04-24 12:17:16'), (29, 'Mr.', 'Rajesh Yadav', '8383019093', '', 'rajesh.rhdigisoft@gmail.com', '', 'e10adc3949ba59abbe56e057f20f883e', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2019-10-11 03:10:02'), (30, 'Mr.', 'gaurav', '7792877658', '', 'afdsghfjgk@ythdt.com', '', 'a6ec614d7f503a733ac2b1b6c5f06457', '', '', '', '', '', '', '', '', 'india', '', '', '', '', '2018-05-13 13:49:35'), (47, 'Mr.', 'SAA@##', '8896881603', '', 'arulkr12@gmail.com', '', 'ce402a499def52f04ecb17a18f679111', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2018-06-01 09:14:59'), (48, 'Mr.', 'atul', '8896881603', '', 'arulkr12', '', 'ce402a499def52f04ecb17a18f679111', '', '', '', '', '', '', '', '', 'India', '', '', '', '', '2018-06-01 09:15:21'), (59, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6a8d45df19', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:21:24'), (60, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6aa0e14730', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:26:38'), (61, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6aa908572b', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:28:48'), (62, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6ae31c3023', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:44:17'), (63, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6af0c8385b', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:47:56'), (64, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6af331a064', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:48:35'), (65, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6b09a91c22', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:54:34'), (66, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6b09cd7767', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:54:36'), (67, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6b0b68f5a3', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:55:02'), (68, '', 'aa', '8896881603', '', 'atul@gmail.com', '', '55da6b0e985eaa', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:55:53'), (69, '', 'aa', '8896881603', '', 'atul@gmail.com', '', 'aa85f973cef6cac2fe4721caa6b7b09e', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 05:58:43'), (70, '', 'ranjit', '8896881603', '', 'atul@gmail.com', '', '55da6b2481d8c0', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 06:01:44'), (71, '', 'aman', '8896881603', '', 'atul@gmail.com', '', '55da6b2ffc4b7a', '', '', '', '', '', '', '', '', '', '', '', '', '', '2019-10-16 06:04:47'); -- -------------------------------------------------------- -- -- Table structure for table `invoice` -- CREATE TABLE `invoice` ( `invoiceid` int(11) NOT NULL, `project_id` int(11) NOT NULL, `project_amount` float NOT NULL, `cycle_date` varchar(20) NOT NULL, `due_date` varchar(20) NOT NULL, `tax` float NOT NULL, `file_name` varchar(255) NOT NULL, `date` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `invoice` -- INSERT INTO `invoice` (`invoiceid`, `project_id`, `project_amount`, `cycle_date`, `due_date`, `tax`, `file_name`, `date`) VALUES (3, 1, 500, '16/01/2018', '16/02/2018', 90, '', ''), (4, 21, 0, '31-01-2018', '', 0, '', ''), (5, 22, 0, '31-01-2018', '', 0, '', '07-01-2018'), (6, 27, 0, '01-02-2018', '', 0, '', '07-01-2018'), (7, 23, 0, '16-11-2019', '', 0, '', '16-10-2019'); -- -------------------------------------------------------- -- -- Table structure for table `payments` -- CREATE TABLE `payments` ( `id` int(11) NOT NULL, `tid` varchar(20) NOT NULL, `merchant_id` varchar(25) NOT NULL, `order_id` varchar(25) NOT NULL, `currency` varchar(25) NOT NULL, `billing_name` varchar(50) NOT NULL, `billing_address` varchar(100) NOT NULL, `billing_city` varchar(100) NOT NULL, `billing_state` varchar(100) NOT NULL, `billing_zip` varchar(25) NOT NULL, `billing_country` varchar(25) NOT NULL, `billing_tel` int(25) NOT NULL, `billing_email` varchar(25) NOT NULL, `delivery_name` varchar(25) NOT NULL, `delivery_address` varchar(256) NOT NULL, `delivery_city` varchar(25) NOT NULL, `delivery_state` varchar(25) NOT NULL, `delivery_zip` int(11) NOT NULL, `delivery_country` varchar(25) NOT NULL, `delivery_tel` int(25) NOT NULL, `payment_status` tinyint(4) NOT NULL, `createdtime` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `itemid` int(11) NOT NULL, `PackageCat` int(11) DEFAULT NULL, `PackageID` int(11) DEFAULT NULL, `PurchasedForMonth` int(11) DEFAULT NULL, `PackageName` varchar(255) DEFAULT NULL, `ProjectName` varchar(255) DEFAULT NULL, `Amount` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `tid`, `merchant_id`, `order_id`, `currency`, `billing_name`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `billing_country`, `billing_tel`, `billing_email`, `delivery_name`, `delivery_address`, `delivery_city`, `delivery_state`, `delivery_zip`, `delivery_country`, `delivery_tel`, `payment_status`, `createdtime`, `itemid`, `PackageCat`, `PackageID`, `PurchasedForMonth`, `PackageName`, `ProjectName`, `Amount`) VALUES (1, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 1, '2018-05-17 10:17:46', 0, 1, 1, 1, 'Basic', 'ggg', 299), (2, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 1, '2018-05-17 10:22:01', 0, 1, 1, 1, 'Basic', 'testing name', 299), (3, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 1, '2018-05-17 10:32:24', 0, 1, 3, 1, 'Professional', 'ujyo', 549), (4, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '0000-00-00 00:00:00', 0, 1, 2, 1, 'Plus', 'ddf', 399), (5, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '0000-00-00 00:00:00', 0, 1, 2, 1, 'Plus', 'ddf', 399), (6, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-14 12:37:18', 0, 2, 2, 1, 'Plus', 'c2g', 399), (7, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 06:34:31', 0, 2, 2, 1, 'Plus', 'gethelp', 399), (8, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 09:10:02', 0, 2, 2, 1, 'Plus', 'Rhdigisoft', 399), (9, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 09:56:33', 0, 2, 2, 1, 'Plus', 'sss', 399), (10, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 09:59:41', 0, 1, 1, 1, 'Basic', 'aaa', 299), (11, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 10:08:40', 0, 1, 1, 1, 'Basic', 'utyu', 299), (12, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 10:14:36', 0, 1, 2, 1, 'Plus', 'yui', 399), (13, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 10:19:42', 0, 1, 2, 1, 'Plus', 'jjtuyu', 399), (14, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 10:42:49', 0, 2, 2, 1, 'Plus', 'rajesh', 399), (15, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 11:04:46', 0, 1, 2, 1, 'Plus', 'abc', 399), (16, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 11:11:54', 0, 1, 2, 1, 'Plus', 'zzz', 399), (17, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 11:20:30', 0, 1, 2, 1, 'Plus', 'zzz', 399), (18, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 11:48:46', 0, 1, 2, 1, 'Plus', 'gethelp', 399), (19, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 11:53:05', 0, 2, 2, 1, 'Plus', 'gethelp', 399), (20, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:12:46', 0, 1, 2, 1, 'Plus', 'sss', 399), (21, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:18:49', 0, 1, 4, 1, 'Premier', 'hello', 699), (22, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:22:59', 0, 1, 1, 1, 'Basic', 'brandmat.co.za', 299), (23, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:26:23', 0, 1, 1, 1, 'Basic', 'hello', 299), (24, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:26:56', 0, 1, 1, 1, 'Basic', 'hello', 299), (25, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:27:25', 0, 1, 1, 1, 'Basic', 'hello', 299), (26, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:28:04', 0, 1, 1, 1, 'Basic', 'hello', 299), (27, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:37:37', 0, 1, 2, 1, 'Plus', 'sss', 399), (28, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-15 12:40:22', 0, 1, 2, 1, 'Plus', 'sss', 399), (29, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:10:42', 0, 1, 2, 1, 'Plus', 'xxx', 399), (30, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:14:22', 0, 1, 2, 1, 'Plus', 'xxx', 399), (31, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:15:09', 0, 1, 2, 1, 'Plus', 'xxx', 399), (32, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:18:50', 0, 1, 2, 1, 'Plus', 'ppp', 399), (33, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:23:46', 0, 1, 4, 1, 'Premier', 'zzz', 699), (34, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 09:29:25', 0, 1, 2, 1, 'Plus', 'jjhgj', 399), (35, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:48:50', 0, 1, 2, 1, 'Plus', 'rajesh', 399), (36, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:50:08', 0, 1, 2, 1, 'Plus', 'rajesh', 399), (37, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:51:21', 0, 1, 2, 1, 'Plus', 'ddd', 399), (38, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:52:00', 0, 1, 2, 1, 'Plus', 'dsd', 399), (39, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:52:25', 0, 1, 2, 1, 'Plus', 'dsd', 399), (40, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:54:09', 0, 1, 2, 1, 'Plus', 'dsd', 399), (41, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:55:38', 0, 1, 2, 1, 'Plus', 'fghtfrt', 399), (42, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 10:57:09', 0, 1, 2, 1, 'Plus', 'sdfsaf', 399), (43, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:02:23', 0, 1, 2, 1, 'Plus', 'sdfsaf', 399), (44, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:10:40', 0, 1, 2, 1, 'Plus', 'rajesh', 399), (45, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:13:07', 0, 1, 3, 1, 'Professional', 'setetr', 549), (46, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:14:08', 0, 1, 3, 1, 'Professional', 'rajesh', 549), (47, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:15:59', 0, 2, 3, 1, 'Professional', 'gg', 549), (48, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:26:01', 0, 2, 1, 1, 'Basic', 'dfgd', 299), (49, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:26:17', 0, 2, 1, 1, 'Basic', 'dfgd', 299), (50, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:26:31', 0, 2, 1, 1, 'Basic', 'dfgd', 299), (51, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:27:32', 0, 2, 1, 1, 'Basic', 'dfgd', 299), (52, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:27:42', 0, 2, 1, 1, 'Basic', 'dfgd', 299), (53, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:27:55', 0, 2, 2, 1, 'Plus', 'saaxda', 399), (54, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:28:11', 0, 1, 4, 1, 'Premier', 'sada', 699), (55, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:28:27', 0, 2, 1, 1, 'Basic', 'xdas', 299), (56, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:28:40', 0, 2, 1, 1, 'Basic', 'xdas', 299), (57, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:28:50', 0, 2, 1, 1, 'Basic', 'xdas', 299), (58, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:38:07', 0, 1, 2, 1, 'Plus', 'rajesh', 399), (59, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:38:42', 0, 1, 2, 1, 'Plus', 'rajesh', 399), (60, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:38:53', 0, 1, 1, 1, 'Basic', 'test', 299), (61, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:42:48', 0, 1, 2, 1, 'Plus', 'sda', 399), (62, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 11:44:11', 0, 1, 2, 1, 'Plus', 'atul', 399), (63, '', '', '', '', '', '', '', '', '', '', 0, '', '', '', '', '', 0, '', 0, 0, '2018-05-17 12:00:50', 0, 1, 1, 1, 'Basic', 'assaa', 299); -- -------------------------------------------------------- -- -- Table structure for table `payments-old` -- CREATE TABLE `payments-old` ( `id` int(11) NOT NULL, `txnid` varchar(20) NOT NULL, `payment_amount` decimal(10,0) NOT NULL, `payment_status` tinyint(4) NOT NULL, `createdtime` datetime NOT NULL, `itemid` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `portfolio` -- CREATE TABLE `portfolio` ( `id` int(11) NOT NULL, `p_categary` varchar(255) NOT NULL, `p_title` text NOT NULL, `p_image` varchar(255) NOT NULL, `featuredimage` varchar(255) NOT NULL, `p_about` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `status` varchar(1) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `portfolio` -- INSERT INTO `portfolio` (`id`, `p_categary`, `p_title`, `p_image`, `featuredimage`, `p_about`, `date`, `status`) VALUES (25, 'seo', 'http://www.excusslogistics.co.za/ SEO Project', '1503201807433204022018155714excusslogistics.jpg', '15032018074332small.jpg', 'Excuss has been in existence since year 2000. We are small enough to care yet big enough to meet your entire removal requirements. Excuss Movers is quite aware of the fact that clients we serve today are the ones who can make or break us, hence we provide a superior level of care for your go
', '2018-03-15 07:43:32', '1'), (26, 'seo', 'http://kant.co.za/ SEO & SMO Project', '1503201807560304022018155212kant-co-za (1).jpg', '1503201807560304022018155212kant-co-za.jpg', 'Kant Consulting has indulged itself in providing wide range of bookkeeping and accounting services for small businesses. With years of experience since its inception, it is consistently doing its best and is globally known among the top accounting service providers.
', '2018-03-15 07:56:03', '1'), (27, 'web', 'http://redchilifun.com/ website development & SEO', '1503201808022704022018154420redchilifun.jpg', '15032018080227small.jpg', 'Download HD wallpapers with High resolution in all categories.
Bring laughter with latest jokes in all categories.
Now Express feelings with SMS for all situations.
Get lost in world of Mood changing HD videos, Prank videos, funny videos, bollywood videos
', '2018-03-15 08:02:27', '1'), (28, 'web', 'http://outrite.co.za/ Cleaning website', '1503201808050604022018070950outrite-co-za.jpg', '15032018080506small1.jpg', 'RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing Best Web Development Services.
', '2018-03-15 08:05:06', '1'); -- -------------------------------------------------------- -- -- Table structure for table `project_category` -- CREATE TABLE `project_category` ( `id` int(11) NOT NULL, `pro_cat_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `project_category` -- INSERT INTO `project_category` (`id`, `pro_cat_name`) VALUES (1, 'SEO'), (2, 'SMO'), (3, 'Web Development'); -- -------------------------------------------------------- -- -- Table structure for table `project_information` -- CREATE TABLE `project_information` ( `pro_info_id` int(11) NOT NULL, `web_url` varchar(255) NOT NULL, `business_name` varchar(255) NOT NULL, `business_email` varchar(255) NOT NULL, `business_cont` varchar(20) NOT NULL, `owner_name` varchar(255) NOT NULL, `business_address` text NOT NULL, `city` varchar(255) NOT NULL, `state` varchar(255) NOT NULL, `zip_code` varchar(20) NOT NULL, `country` varchar(255) NOT NULL, `seo_tar_cnt` varchar(255) NOT NULL, `busi_fb_page` text NOT NULL, `busi_tw_page` text NOT NULL, `busi_gp_page` text NOT NULL, `busi_ln_page` text NOT NULL, `busi_pn_page` text NOT NULL, `busi_yt_page` text NOT NULL, `busi_inst_page` text NOT NULL, `cpanel_id` varchar(255) NOT NULL, `cpanel_pass` varchar(255) NOT NULL, `cms_id` varchar(255) NOT NULL, `cms_pass` varchar(255) NOT NULL, `target_keyword` text NOT NULL, `your_message` text NOT NULL, `client_pro_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `project_information` -- INSERT INTO `project_information` (`pro_info_id`, `web_url`, `business_name`, `business_email`, `business_cont`, `owner_name`, `business_address`, `city`, `state`, `zip_code`, `country`, `seo_tar_cnt`, `busi_fb_page`, `busi_tw_page`, `busi_gp_page`, `busi_ln_page`, `busi_pn_page`, `busi_yt_page`, `busi_inst_page`, `cpanel_id`, `cpanel_pass`, `cms_id`, `cms_pass`, `target_keyword`, `your_message`, `client_pro_id`) VALUES (1, 'rhdigi.com', 'apni demo', 'abc@gmail.com', '123+456778', 'Prahlafd', '', 'Noida', '', 'achaj', '', '', '', '', '', '', '', '', '', '', '', '', '', 'klchjdklcfd', 'dsjnjvndsvjks', 1), (2, '', 'proict traing', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 3), (3, '', 'xdd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 4), (4, '', 'rhdigisoft', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 5), (5, '', 'rhdigisoft', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 6), (6, '', 'rhdigisoft2', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 7), (7, '', 'smo', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 8), (8, '', 'gjhgjh,n', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 9), (9, '', 'Ankur', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 10), (10, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 11), (11, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 12), (12, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 13), (13, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 14), (14, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 15), (15, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 16), (16, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 17), (17, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 18), (18, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 19), (19, '', 'test', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 20), (20, 'rhdigisoft.com', 'hello', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 21), (31, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 32), (32, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 33), (33, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1), (34, '', 'ipl league', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 2), (35, 'www.abc.com', 'survey', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 23); -- -------------------------------------------------------- -- -- Table structure for table `project_report` -- CREATE TABLE `project_report` ( `rept_id` int(11) NOT NULL, `file_name` varchar(255) NOT NULL, `project_id` int(11) NOT NULL, `date` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `project_report` -- INSERT INTO `project_report` (`rept_id`, `file_name`, `project_id`, `date`) VALUES (3, '16122017124859Admin Panel Documentation.docx', 1, '16-12-2017'), (4, '24122017114453Admin Panel Documentation.docx', 1, '24-12-2017'), (5, '24122017120201furniture.csv', 1, '24/12/2017'), (6, '13042018102907admission.docx', 2, '13-04-2018'), (7, '11102019070604Atul resume new.docx', 6, '11-10-2019'); -- -------------------------------------------------------- -- -- Table structure for table `salefollowup` -- CREATE TABLE `salefollowup` ( `id` int(11) NOT NULL, `sales_id` int(11) NOT NULL, `cust_name` varchar(255) NOT NULL, `calldate` date NOT NULL, `nextcalldate` date NOT NULL, `email` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `fstatus` varchar(255) NOT NULL, `fclose` varchar(255) NOT NULL, `intrested` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `salefollowup` -- INSERT INTO `salefollowup` (`id`, `sales_id`, `cust_name`, `calldate`, `nextcalldate`, `email`, `contact`, `fstatus`, `fclose`, `intrested`) VALUES (1, 1, 'prahlad kumar gupta', '2018-06-12', '2018-06-14', 'prahlad.gupta1988@gmail.com', '09990011043', 'Open', 'Sold', 'doing'), (2, 5, 'prahlad kumar gupta', '2018-06-21', '2018-06-21', 'prahlad.gupta1988@gmail.com', '09990011043', 'Open', '', 'doing'); -- -------------------------------------------------------- -- -- Table structure for table `salesadmin` -- CREATE TABLE `salesadmin` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `contact` varchar(255) NOT NULL, `usertype` int(11) NOT NULL COMMENT '1 for admin,2 for client', `lastlogin` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `image` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `salesadmin` -- INSERT INTO `salesadmin` (`id`, `username`, `password`, `name`, `email`, `contact`, `usertype`, `lastlogin`, `image`) VALUES (1, 'sales', '123456', 'RH Digisoft', 'sales@gmail.com', '1234567892', 1, '2018-06-22 06:46:31', 'dist/img/user2-160x160.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `salesprofile` -- CREATE TABLE `salesprofile` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `position` varchar(255) NOT NULL, `target` float NOT NULL, `doj` date NOT NULL, `email` varchar(255) NOT NULL, `contact` bigint(10) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `address` text NOT NULL, `gender` varchar(255) NOT NULL, `image` varchar(255) NOT NULL, `status` varchar(1) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `salesprofile` -- INSERT INTO `salesprofile` (`id`, `name`, `position`, `target`, `doj`, `email`, `contact`, `username`, `password`, `address`, `gender`, `image`, `status`) VALUES (1, 'Brajesh Roy', 'Web Designer', 100000, '2018-06-13', 'brajesh@gmail.com', 8510017579, 'sales', '123456', 'Laxmi Nagar New Delhi', 'Male', '', '1'), (5, 'atul kumar', 'Web Developer', 40000, '2017-08-23', 'arulkr12@gmail.com', 8896881603, 'atul@gmail.com', '123456', 'Mamura Noida', 'Male', '', '1'), (6, 'Robin Singh', 'Sr. SEO Executive', 200000000, '2018-06-10', 'robin@gmail.com', 8766878763, 'robin@gmail.com', '123456', 'mamura', 'Male', '', '1'), (17, 'Robin Singhhjhhhhhh', 'Sr. SEO Executive', 100000, '2018-06-05', '', 0, 'robin@gmail.com', '123456', '', '', '', '1'), (18, 'Kuldeep', 'Sr. SEO Executive', 100000, '2018-06-08', '', 0, 'kuldeep@gmail.com', '123456', '', '', '', '1'), (19, 'Rajesh Yadav', 'Sr. Web Developer', 200000, '2018-06-06', '', 0, 'rajesh@gmail.com', '123456', '', '', '', '1'); -- -------------------------------------------------------- -- -- Table structure for table `salesproject` -- CREATE TABLE `salesproject` ( `id` int(11) NOT NULL, `sales_id` int(11) NOT NULL, `projecttype` varchar(255) NOT NULL, `projectname` varchar(255) NOT NULL, `startdate` varchar(20) NOT NULL, `nextbilldate` varchar(20) NOT NULL, `totalamount` float NOT NULL, `tokenmoney` float NOT NULL, `remainamount` float NOT NULL, `tenure` varchar(255) NOT NULL, `cust_fname` varchar(255) NOT NULL, `cust_lname` varchar(255) NOT NULL, `cust_email` varchar(255) NOT NULL, `cust_contact` bigint(10) NOT NULL, `cust_address` text NOT NULL, `recurring` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `salesproject` -- INSERT INTO `salesproject` (`id`, `sales_id`, `projecttype`, `projectname`, `startdate`, `nextbilldate`, `totalamount`, `tokenmoney`, `remainamount`, `tenure`, `cust_fname`, `cust_lname`, `cust_email`, `cust_contact`, `cust_address`, `recurring`, `status`) VALUES (9, 5, 'Web Development', 'brightentertainment.co.in', '0000-00-00', '0000-00-00', 0, 2000, 8000, '', 'Premji', 'Pandey', 'prenm@gmail.com', 8896881603, 'mamura', '', '1'), (10, 1, 'Web Development', 'RH Digisoft', '2018-06-08', '0000-00-00', 40000, 2000, 0, '', 'rajesh', 'kumar', 'rajesh@gmail.com', 8896881603, 'Noida', 'No', '1'), (11, 5, 'Digital Marketing', '', '2018-06-22', '0000-00-00', 50000, 2000, 30000, '8 Month', 'ranjeet', 'kumar', 'ranjeet12@gmail.com', 8896881603, 'mamura', 'Yes', '1'), (12, 1, 'Digital Marketing', 'IRCTC Project', '2018-06-22', '0000-00-00', 50000, 2000, 30000, '12 Month', 'rajesh', 'kumar', 'rajesh@gmail.com', 8896881603, 'Noida', 'Yes', '1'), (13, 5, 'Web Development', 'RH Digisoft Technical', '0000-00-00', '0000-00-00', 0, 2000, 0, '', '', '', '', 0, '', '', '1'), (14, 19, 'Web Development', 'Hotel Ramada', '2018-06-30', '0000-00-00', 90000, 2000, 80000, '10 Month', 'rajeev', 'kumar', 'arulkr12@gmail.com', 8979867598, 'noiada', 'Yes', '1'), (15, 1, '', 'CYCO', '0000-00-00', '0000-00-00', 0, 2000, 80000, '', 'rajesh', 'kumar', 'rajesh@gmail.com', 8896881603, 'Noida', '', ''), (23, 1, 'Search Engine Optimization', 'RH Digisoft Technical', '2018-06-26', '26-07-2018', 10000, 2000, 10000, '', '', '', '', 0, '', '', '1'); -- -------------------------------------------------------- -- -- Table structure for table `ticket` -- CREATE TABLE `ticket` ( `id` int(10) NOT NULL, `tickettitle` varchar(50) NOT NULL, `subject` text NOT NULL, `user_id` int(11) NOT NULL, `project_id` int(11) NOT NULL, `reply` text NOT NULL, `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `status` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ticket` -- INSERT INTO `ticket` (`id`, `tickettitle`, `subject`, `user_id`, `project_id`, `reply`, `date`, `status`) VALUES (1, 'Home page', 'issue', 22, 0, '', '2018-03-17 07:06:42', 1), (2, 'not ranked any keyword', 'sdghuksygfydghjfbfsj', 20, 2, 'khfsghhyytstts
', '2018-04-13 10:46:04', 1), (3, 'not ranked any keyword', 'sdghuksygfydghjfbfsj', 20, 2, '', '2018-04-13 10:46:14', 1), (4, 'dfd', 'dffdfdfd', 71, 23, 'dsfsgsgdhfhfok
\r\n', '2019-10-16 07:14:09', 1), (5, 'dfd', 'dffdfdfd', 71, 23, '', '2019-10-16 07:14:17', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blog` -- ALTER TABLE `blog` ADD PRIMARY KEY (`id`); -- -- Indexes for table `blog_category` -- ALTER TABLE `blog_category` ADD PRIMARY KEY (`cat_id`); -- -- Indexes for table `clientsec` -- ALTER TABLE `clientsec` ADD PRIMARY KEY (`img_id`); -- -- Indexes for table `client_project` -- ALTER TABLE `client_project` ADD PRIMARY KEY (`pro_id`); -- -- Indexes for table `comment` -- ALTER TABLE `comment` ADD PRIMARY KEY (`id`); -- -- Indexes for table `customer` -- ALTER TABLE `customer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `invoice` -- ALTER TABLE `invoice` ADD PRIMARY KEY (`invoiceid`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payments-old` -- ALTER TABLE `payments-old` ADD PRIMARY KEY (`id`); -- -- Indexes for table `portfolio` -- ALTER TABLE `portfolio` ADD PRIMARY KEY (`id`); -- -- Indexes for table `project_category` -- ALTER TABLE `project_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `project_information` -- ALTER TABLE `project_information` ADD PRIMARY KEY (`pro_info_id`); -- -- Indexes for table `project_report` -- ALTER TABLE `project_report` ADD PRIMARY KEY (`rept_id`); -- -- Indexes for table `salefollowup` -- ALTER TABLE `salefollowup` ADD PRIMARY KEY (`id`); -- -- Indexes for table `salesadmin` -- ALTER TABLE `salesadmin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `salesprofile` -- ALTER TABLE `salesprofile` ADD PRIMARY KEY (`id`); -- -- Indexes for table `salesproject` -- ALTER TABLE `salesproject` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ticket` -- ALTER TABLE `ticket` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=40; -- -- AUTO_INCREMENT for table `blog_category` -- ALTER TABLE `blog_category` MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `clientsec` -- ALTER TABLE `clientsec` MODIFY `img_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `client_project` -- ALTER TABLE `client_project` MODIFY `pro_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `comment` -- ALTER TABLE `comment` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `customer` -- ALTER TABLE `customer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72; -- -- AUTO_INCREMENT for table `invoice` -- ALTER TABLE `invoice` MODIFY `invoiceid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64; -- -- AUTO_INCREMENT for table `payments-old` -- ALTER TABLE `payments-old` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `portfolio` -- ALTER TABLE `portfolio` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `project_category` -- ALTER TABLE `project_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `project_information` -- ALTER TABLE `project_information` MODIFY `pro_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36; -- -- AUTO_INCREMENT for table `project_report` -- ALTER TABLE `project_report` MODIFY `rept_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `salefollowup` -- ALTER TABLE `salefollowup` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `salesadmin` -- ALTER TABLE `salesadmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `salesprofile` -- ALTER TABLE `salesprofile` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `salesproject` -- ALTER TABLE `salesproject` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `ticket` -- ALTER TABLE `ticket` MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; 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 */;