-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- 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', '', '<p>Hello everyone!!</p>\r\n\r\n<p>Want to get top rankings on your website? RHDigisoft is one of the <a href=\"https://rhdigisoft.com/\" target=\"_blank\"><strong>best SEO Company</strong></a> and guarantees you to give top rankings and traffic to your website.</p>\r\n\r\n<p>As 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.</p>\r\n\r\n<p>The 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.</p>\r\n\r\n<p>Before 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.</p>\r\n\r\n<p>.<img alt=\"\" src=\"/ckfinder/userfiles/images/imgpsh_fullsize%20(1)(1).png\" style=\"height:330px; width:600px\" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>What is SEO?</strong></p>\r\n\r\n<p>&ndash; &ldquo;Search Engine Optimization&rdquo; is a process with the intention to divers the position of your website in a search engine&rsquo;s non-paid results, also known as &ldquo;natural&rdquo;, &ldquo;earned&rdquo; results to gain higher ranking on search engine&rsquo;s visibility area.</p>\r\n\r\n<p><strong>Search engine optimization </strong>is a search engine technique which helps you to bring your website on top on search engine for some particular keywords.</p>\r\n\r\n<p><strong>Why we use SEO?</strong></p>\r\n\r\n<ul>\r\n	<li>It is an effective low cost method.</li>\r\n	<li>High Return on Investment (ROI) value</li>\r\n	<li>SEO helps your website stand out</li>\r\n	<li>It increases the visibility of your website in search engine.</li>\r\n	<li>A major fire-starter way to gain traffic on your website.</li>\r\n	<li>It is an easy way to show your business as a brand</li>\r\n</ul>\r\n\r\n<p><strong>What is white Hat SEO?</strong></p>\r\n\r\n<p>We use White Hat SEO and it follows all the guidelines of search engine .It is&nbsp; very &nbsp;efficient as white hat SEO provides long lasting growth in rankings.</p>\r\n\r\n<p>We should always use White Hat SEO.</p>\r\n\r\n<p>Now 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.</p>\r\n\r\n<p><strong>Process of SEO:-</strong></p>\r\n\r\n<ul>\r\n	<li>Website Analysis</li>\r\n	<li>Keyword Analysis</li>\r\n	<li>On page Optimization</li>\r\n	<li>Content Optimization</li>\r\n	<li>Link Building</li>\r\n	<li>Analysis and Evaluation</li>\r\n	<li>Reputation Management</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Techniques we use:-</strong></p>\r\n\r\n<ol>\r\n	<li><strong>On Page Optimization &ndash; </strong>In this we make the best and most effective use of all resources and we take best measures to improve the ranking in search engine.</li>\r\n</ol>\r\n\r\n<p>Optimization 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.</p>\r\n\r\n<p>Techniques includes:-</p>\r\n\r\n<ul>\r\n	<li>Keyword Analysis -In this we analyze the keywords which we are going to use to keep the website on top.</li>\r\n	<li>Tag Optimization &ndash; In this by using the tags we optimize how we can represent the keywords to keep the website on top.</li>\r\n	<li>Content Optimization &ndash; In this we have to optimize the contents like favicon, text, images, non-able index attributes etc.</li>\r\n	<li>Linking &ndash; There are three types of linking</li>\r\n</ul>\r\n\r\n<ul>\r\n	<li>External</li>\r\n	<li>Internal</li>\r\n	<li>Broken</li>\r\n</ul>\r\n\r\n<p>We always have to avoid broken links.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ol>\r\n	<li><strong>Off Page Optimization &ndash;</strong> In this technique we improve the rankings on search engine for our keywords. We do link building process etc and this process should be done regularly to increase the ranking of the website.</li>\r\n</ol>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Techniques includes -</p>\r\n\r\n<ul>\r\n	<li>Link Building</li>\r\n</ul>\r\n\r\n<p>You must be thinking of what is the need of link building and other process.</p>\r\n\r\n<p>First 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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li>Article Submission - We submit relevant and useful contents to increase the rank.</li>\r\n	<li>Search Engine Submission &ndash; In this we submit the optimized website on search engine.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Like this we use many techniques to do On Page and Off Page optimization.</p>\r\n\r\n<p>So friends, now you must have got some idea of what SEO is and how it helps you to increase your business online. Isn&rsquo;t it interesting that how fast your business can grow with the help of this SEO process?</p>\r\n\r\n<p>If 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 <strong><a href=\"https://rhdigisoft.com/seo-services\" target=\"_blank\">best SEO services</a> </strong>with <strong>SEO expert </strong>and will love to serve because our motive is to satisfy you.</p>\r\n\r\n<p>Have a great day!!!</p>\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', '<p>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&#39;s say you have a great website built in latest design trend &amp; 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&#39;s the latest technology, design trends become worthless if no one finds it. The solution to this is Search Engine Optimization.</p>\n\n<p><strong>Let&#39;s see why SEO is so vital: &nbsp;&nbsp;</strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</p>\n\n<p><strong>Seo is important as it:</strong></p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp; Increase Traffic</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp; SEO is not a cost but Investment</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp; Higher Brand Credibility</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp; Reach a wider audience:</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp; Your competitors are doing it</p>\n\n<p><strong>Types of SEO:</strong></p>\n\n<p>On 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</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<strong>On-page SEO:</strong></p>\n\n<p>On 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.</p>\n\n<p>&nbsp;</p>\n\n<p>&middot; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<strong>Off Page SEO:</strong></p>\n\n<p>Off page SEO is a process of putting the written content on the websites other than the website being promoted, for example, creating a &#39;guest post&#39; for another blog or posting a video on YouTube.</p>\n\n<p>SEO is a never-ending process. If you&#39;re not moving forward and refining your position, you&#39;re behind ground to your competitor. Ranking high on Google is very important if you want lots of visitors to your website.</p>\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', '<p>Hi friends!!</p>\r\n\r\n<p>Hope 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.</p>\r\n\r\n<p>In theory website traffic refers to an amount of web user who come to a website. Website traffic calculated in visits. Which also known as &ldquo;sessions&rdquo; A common way to evaluate trade effectiveness of engaging peoples.</p>\r\n\r\n<p>Now it&rsquo;s very important to know about the tools that are used to collect information data related to website traffic.</p>\r\n\r\n<p>Today we are covering two tools that are beneficial to calculate website visits. One is Google Analytics and &nbsp;second is Google Webmaster Tool.</p>\r\n\r\n<p>When the <a href=\"https://rhdigisoft.com/\" target=\"_blank\"><strong>Best Digital Marketing agency</strong></a> work so hard to get traffic and top rankings to the website, don&rsquo;t you feel it is so important to check the status of our hard work or analyze and optimize visibility of our website?</p>\r\n\r\n<p>Let us see what all we do using these tools and how huge impact it gives us for increasing traffic and ranking of our website.</p>\r\n\r\n<p>First point is that what is Google Analytics?</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>&nbsp;Google Analytics</strong></p>\r\n\r\n<p>It doesn&rsquo;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 <strong>Digital Marketing agencies</strong>.</p>\r\n\r\n<ul>\r\n	<li>Google Analytics is a free service of web analytics which provides us the statistics and information about traffic source and traffic of the website and also basic analytical tools for Search engine optimization and for Marketing Purpose.</li>\r\n</ul>\r\n\r\n<p><strong>Reasons why we use Google Analytics</strong></p>\r\n\r\n<ol>\r\n	<li>We submit our website to analyze and optimize each and every stuff here.</li>\r\n	<li>To understand the performance of our website.</li>\r\n	<li>To know how much traffic we are getting on our Website.</li>\r\n	<li>It can be easily integrated with other tools and services.</li>\r\n	<li>To know the basic information of audiences who visit our website.</li>\r\n	<li>We can choose to analyze both for Mobile Application or Website.</li>\r\n</ol>\r\n\r\n<p>Next thing is what is Google Webmaster Tools?</p>\r\n\r\n<p><img alt=\"\" src=\"/ckfinder/userfiles/images/imgpsh_fullsize.jpg\" style=\"height:388px; width:600px\" /></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Google Webmaster</strong></p>\r\n\r\n<p>Google 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.</p>\r\n\r\n<p>Further we are going to discuss the important role Google Webmaster play in the SEO process.</p>\r\n\r\n<p><strong>Reasons why we use Google Webmaster Tool</strong></p>\r\n\r\n<ol>\r\n	<li>We can check the indexing status and also optimize the visibility of our website.</li>\r\n	<li>Used for crawling errors i.e. it shows errors found during crawling.</li>\r\n	<li>Used to Search Queries of the website.</li>\r\n	<li>Used to submit Sitemap.</li>\r\n	<li>It is excellent for security and privacy of our website.</li>\r\n</ol>\r\n\r\n<p>Hence, 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&rsquo;t have to just stuck to one thing to solve the problems as it has various functions which reduces the waste of time.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li><strong>A Brief difference between Google Analytics and Google Webmaster Tool</strong></li>\r\n</ul>\r\n\r\n<p>Basically in Google Webmaster Tool it&rsquo;s all about how search engine interacts with our site whereas in Google Analytics it&rsquo;s all about how website users interact with our site.</p>\r\n\r\n<p>Friends, 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.</p>\r\n\r\n<p>For 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.</p>\r\n\r\n<p>Hope you have enjoyed reading the above article and also don&rsquo;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 &ldquo;Search Engine Optimization&rdquo; and its techniques and their uses.</p>\r\n\r\n<p>Have a great day!!!</p>\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', '<p>When we are thinking of a business and all&nbsp; process to achieve our goals&nbsp; for the success of our business, then one question usually arrives inside our mind that why we need Social Media Management?</p>\r\n\r\n<p>Let us give you the answer of this in a very simple and clear way.</p>\r\n\r\n<p>When you have a business it is very important to promote your business organically using Social Media Sites.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><img alt=\"\" src=\"/ckfinder/userfiles/images/smm2.jpg\" style=\"height:312px; width:600px\" /></p>\r\n\r\n<p>Best way to give confidence to the people about your business is by doing <a href=\"https://rhdigisoft.com/smo-services\" target=\"_blank\"><strong>Social Media marketing</strong></a>.</p>\r\n\r\n<p><strong>Following are some of the reasons why we need a Social Media Management</strong><strong>.</strong></p>\r\n\r\n<ul>\r\n	<li>To get maximum reachability of our business to our ideal users i.e. by taking help of <strong>Social media Marketing</strong> <strong>services</strong> you can get more and more reachability to the relatable users to give information about your</li>\r\n</ul>\r\n\r\n<p>Business.</p>\r\n\r\n<ul>\r\n	<li>It is best for local business and the reason is that when you have a local business it&rsquo;s a necessity to promote your business in a very well planned way. So this is one of the way to promote your local business in a creative and planned way and it will help you a lot.</li>\r\n	<li>Best part of social media management is that it is a very easy process and you don&rsquo;t have to invest so much of money for this as it is very cost efficient.</li>\r\n	<li>Another positive thing about this Social Media Management is that there is no physical limitations to promote your business, Organization or company.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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.</p>\r\n\r\n<p><img alt=\"\" src=\"/ckfinder/userfiles/images/smm1.jpg\" style=\"height:392px; width:600px\" /></p>\r\n\r\n<p>Hope 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.</p>\r\n\r\n<p>Have a great day!</p>\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', '<p>Hello everyone!</p>\r\n\r\n<p>Do 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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Here Are the Programming Languages We Use</strong></p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; HTML 5</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CSS 3</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JavaScript</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bootstrap</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; JQuery</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>&nbsp;Database Management Systems We Are Using</strong></p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MySQL</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Platforms We Are Using</strong></p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WordPress</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Magento</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PHP</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Laravel</p>\r\n\r\n<p>&middot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Opencart</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>We have a special capability in <strong>E-Commerce</strong> like <strong>OnlineShopping Sites</strong> etc. and also in <strong>Payment Integration.</strong></p>\r\n\r\n<p><strong>&nbsp;</strong></p>\r\n\r\n<p>Now let us give a brief idea of what exactly is E-Commerce and open cart.</p>\r\n\r\n<p><strong>&nbsp;</strong></p>\r\n\r\n<p><strong>WHAT IS E-COMMERCE?</strong></p>\r\n\r\n<p>Basically 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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The reason for this boom in E-Commerce is that it has made the life of people so easy that we don&rsquo;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.</p>\r\n\r\n<p><strong>E-COMMERCE WEBSITE</strong></p>\r\n\r\n<p>E-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.</p>\r\n\r\n<p>Previously 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 &nbsp;websites has made the life of people very easy and convenient.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>There are different types of E-Commerce Websites</strong></p>\r\n\r\n<p>Based on what functions they accomplish, there are different types of E-commerce websites.</p>\r\n\r\n<ul>\r\n	<li><strong>Business to Business (B2B) &ndash; </strong>In this the transaction of goods and services is done between companies electronically.</li>\r\n	<li><strong>Business to Consumer (B2C) &ndash; </strong>In this transaction of goods and services is done between companies and consumers electronically.</li>\r\n	<li><strong>Consumer to Consumer (C2C) &ndash; </strong>In this transaction of goods and services is done between consumer to consumer i.e. it is mostly done through third party electronically.</li>\r\n	<li><strong>Consumer to Business (C2B) &ndash;</strong> In this electronic transaction of goods and services where products and services are offered to the company by an individual.</li>\r\n	<li><strong>Business-to-Administration (B2A) &ndash; </strong>In this electronic transaction of goods and services is done between public administration and business.</li>\r\n	<li><strong>Consumer-to-Administration (C2A) - </strong>In this electronic transaction of goods and services is done between an individual and public administration.</li>\r\n</ul>\r\n\r\n<p><strong>&nbsp;</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>WHAT IS OPEN CART?</strong></p>\r\n\r\n<p>OPEN 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.</p>\r\n\r\n<p><strong>Advantage of Open Cart </strong>-</p>\r\n\r\n<ul>\r\n	<li>Open Cart makes the development part easy.</li>\r\n	<li>It is having many forums,articles and documentation.</li>\r\n	<li>Multi language sites can be made in fast and easy manner.</li>\r\n	<li>It has many extensions and modules.</li>\r\n	<li>It is SEO friendly.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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.</p>\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', '<p>Planning for a startup or want to increase the presence of your business in this huge and competitive business world?</p>\r\n\r\n<p>Then you must have to know how important it is to do the SEO process for your business. SEO is <a href=\"https://rhdigisoft.com/seo-services\" target=\"_blank\"><strong>Search engine optimization</strong></a> 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.</p>\r\n\r\n<p>If 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.</p>\r\n\r\n<p><strong>Here are some reasons why your business needs SEO</strong></p>\r\n\r\n<ul>\r\n	<li><strong>You can increase the visibility of your business</strong> &ndash; As soon as SEO process is done, it starts increasing the visibility of your business as these days people search for something on Google and if a Good and efficient SEO is done on your website then your website will be on top. And it will result is an increase of visibility.</li>\r\n	<li><strong>It is a very cost efficient process</strong> - As all of us know that small business doesn&rsquo;t have that much of budget that they can invest a huge amount of money to increase their business. So it&rsquo;s a good news for you that SEO process can be done in a very cost-efficient manner with a reasonable budget.</li>\r\n	<li><strong>Your small business can change into a brand</strong> - Brand mindfulness is an awesome liven that is related to your rankings in the web crawlers.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li><strong>High traffic is generated</strong> &ndash; SEO generates high traffic on your business .When there is traffic in your business then people can trust you more.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li><strong>Almost every business is implementing SEO and you also&nbsp;&nbsp; have to compete</strong> &ndash; As we said above, competition is very high in this business world and you cannot take it for granted and if you want to compete with your competitors then you have to always be one step forward to them.</li>\r\n</ul>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<ul>\r\n	<li><strong>SEO and Social media marketing have a bi-directional &nbsp;relationship</strong> &ndash;</li>\r\n</ul>\r\n\r\n<p>A high positioning site will likewise rank high in the query item with an introduction from their web-based social networking stages.</p>\r\n\r\n<p>The notoriety of online networking stages is perfect for SEO, while SEO builds its perceivability.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Hence SEO is for long-term success. It can accomplish your long-term goals.</p>\r\n\r\n<p>Friends after reading this hope you got the idea of how important SEO is and what huge impact it gives to your business.</p>\r\n\r\n<p>RH Digisoft is one of the best <strong>SEO company</strong> and gives <strong>Best SEO services</strong><strong> </strong>and if you want more information regarding this or any help or services we are here for you.</p>\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', '<p>Well, Folks, we know you have a wonderful website to give that business of yours a perfect online presence.</p>\r\n\r\n<p>First 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.</p>\r\n\r\n<p>We are here to discuss some of the common misconceptions about SEO and their logical and obvious solutions.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Look forward to these out of your SEO:</strong></p>\r\n\r\n<ol>\r\n	<li>Increase Traffic.</li>\r\n	<li>Achieve 1st page for your Keywords.</li>\r\n	<li>Generate Leads.</li>\r\n	<li>Achieve an audience worth your precious time.</li>\r\n	<li>Or want to increase your Domain Authority.</li>\r\n</ol>\r\n\r\n<p>Let&rsquo;s get started with the <strong>Traffic </strong>first:</p>\r\n\r\n<p>Well, 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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Rank:</strong></p>\r\n\r\n<p>Now, let&rsquo;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</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Lead Generation:</strong></p>\r\n\r\n<p>Now let&rsquo;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&rsquo;s just for a gig you want to do for another project or your dream project.</p>\r\n\r\n<p><strong>Appropriate Audience:</strong></p>\r\n\r\n<p>Selecting 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&rsquo;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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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</p>\r\n\r\n<ol>\r\n	<li>Number of outbound links on that page.</li>\r\n	<li>Number of visitor&rsquo;s (PA) on that page.</li>\r\n	<li>How much old is that domain.</li>\r\n	<li>Number of Backlink (Do-Follow)</li>\r\n	<li>And many more.</li>\r\n</ol>\r\n\r\n<p>But, let&rsquo;s skip the technicality for these stuffs and leave these to the agency you are hiring for that critical part.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Now let&rsquo;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.</p>\r\n\r\n<p>The 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.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Traffic:</strong></p>\r\n\r\n<p>There are many ways you can divert interested clients to your site and that too who are in dire need of the service you offer.</p>\r\n\r\n<ol>\r\n	<li>Social Media Marketing.</li>\r\n	<li>Search Engine Marketing.</li>\r\n	<li>Quora, Disquss, etc.</li>\r\n</ol>\r\n\r\n<p>Traffic is a factor which also helps to gain a lot of effective ranks for those keywords you need you site to be nicknamed for.</p>\r\n\r\n<p><img alt=\"\" src=\"/ckfinder/userfiles/images/post/post-5.jpg\" style=\"height:360px; width:600px\" /></p>\r\n\r\n<p><strong>Keyword:</strong></p>\r\n\r\n<p>Well 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.</p>\r\n\r\n<p>Now let&rsquo;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 <a href=\"https://rhdigisoft.com/seo-services\"><strong>Best SEO Agency</strong> </a>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.</p>\r\n\r\n<p>Then come the part to choose what you actually need out of your site (Lead, Traffic, Rank etc.)</p>\r\n\r\n<p>&nbsp;Now, 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 <strong><a href=\"https://rhdigisoft.com/seo-packages\">SEO Expert</a></strong> who can consult you for these.</p>\r\n\r\n<p>Folk&rsquo;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&rsquo;t ever listen to a guy who says that you can rank your site for every keyword you can imagine.</p>\r\n\r\n<p>Common problems we the SEO Agencies face is working on keywords which are literally not searched by anyone all around the globe and even it&rsquo;s not our fault clients go unsatisfied which in terms of client-business relation is not at all appropriate.</p>\r\n\r\n<p>Secondly 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.</p>\r\n\r\n<p><img alt=\"\" src=\"/ckfinder/userfiles/images/post/post-6.jpg\" style=\"height:360px; width:600px\" /></p>\r\n\r\n<p>Last 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&rsquo;t take it as an excuse and give them benefit of the doubt.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>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&rsquo;s.</p>\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 `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', '<p>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</p>', '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', '<p>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.</p>', '2018-03-15 07:56:03', '1'),
(27, 'web', 'http://redchilifun.com/ website development & SEO', '1503201808022704022018154420redchilifun.jpg', '15032018080227small.jpg', '<p>Download HD wallpapers with High resolution in all categories.</p><p>Bring laughter with latest jokes in all categories.</p><p>Now Express feelings with SMS for all situations.</p><p>Get lost in world of Mood changing HD videos, Prank videos, funny videos, bollywood videos</p>', '2018-03-15 08:02:27', '1'),
(28, 'web', 'http://outrite.co.za/ Cleaning website', '1503201808050604022018070950outrite-co-za.jpg', '15032018080506small1.jpg', '<p>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong>RH DIGISOFT Team did tremendous job while doing this project and deliverd it on time as expected. our team is capable of providing&nbsp;<strong>Best Web Development Services.</strong></p>', '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_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 `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, '<p>khfsghhyytstts</p>', '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, '<p>dsfsgsgdhfhfok</p>\r\n', '2019-10-16 07:14:09', 1),
(5, 'dfd', 'dffdfdfd', 71, 23, '', '2019-10-16 07:14:17', 1);

--
-- 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 `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_report`
--
ALTER TABLE `project_report`
  ADD PRIMARY KEY (`rept_id`);

--
-- Indexes for table `salefollowup`
--
ALTER TABLE `salefollowup`
  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 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 `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_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 `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;

