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

START TRANSACTION;



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

--
-- Table structure for table `articlecomments`
--

CREATE TABLE `articlecomments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `article_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articlecomments`
--

INSERT INTO `articlecomments` (`id`, `article_id`, `name`, `email`, `website`, `comment`, `status`, `created_at`, `updated_at`) VALUES
(3, 1, 'Subhasish Samanta', 'info@vaptechnology.in', 'www.vaptech.in', 'test', 1, '2020-01-31 04:03:52', '2020-01-31 04:03:52');

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

--
-- Table structure for table `articles`
--

CREATE TABLE `articles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `articles`
--

INSERT INTO `articles` (`id`, `cover_image`, `title`, `slug`, `content`, `author`, `views`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '1576657359.jpg', 'FREE Fitbit for your business growth', 'free-fitbit-for-your-business-growth', '<p>Fitbit is an amazingly successful global idea &ndash; you wear your personal fitness tracker like a watch around your wrist, and it keeps a tab on how you are progressing every single day in accomplishing your fitness goals. By simply adopting a personal FitBit tracker, millions of people around the world are becoming fitter and healthier.</p>\r\n\r\n<p>Brijesh Dalmia has come up with a simple yet highly effective tool which can serve every IFA as a wonderful Fitbit for business growth. The tracker awards you points for every growth-oriented task that you accomplish every working day, and enables you to measure your productivity each day against a target of 25 points per day. Brijesh&rsquo;s assertion is that if every IFA collects 25 points every working day, there is simply no way you will not accelerate your business growth and realize your true potential.</p>\r\n\r\n<p>Brijesh shares with us the genesis of this neat idea and also gives a downloadable link for you to use this excel based tracker. WF lauds this excellent initiative and has a suggestion for Brijesh: develop an app for this tracker and consider branding it &ndash; maybe something like BizFit.</p>\r\n\r\n<p>In the last few years I travelled to over 125 locations in India, did hundreds of business development programs and met thousands of IFA. I got to know their working style and time management. I noticed, many of them worked hard and worked long hours but were still struggling to build good AUM. When I enquired and looked deeper into it, I found they were engaging themselves in many petty works and were not disciplined into key areas of this business. They were spending a lot of time in unproductive activities. End of the day, they could not get optimum results.</p>\r\n\r\n<p>Considering this, I developed an IFA Productivity Tracker where I identified few activities which fuels growth into an IFAs business. The key is to engage in productive activities like; client meetings, client reviews, client connects, etc. The excel sheet automatically calculates the points on the basis of activity entered. The target is to generate 25 points every working day.</p>\r\n\r\n<p>I strongly believe if an IFA follows this productivity tracker, his/her efficiency and AUM will increase significantly.</p>\r\n\r\n<p>To download BizFit &ndash; Brijesh&rsquo;s IFA Productivity Tracker:<br />\r\nhttp://www.wealthforumezine.net/AdvisorspeakST310817.html#.Wa5wSfkjHIU</p>', 'Brijesh Dalmia', 0, 1, '2019-12-18 02:48:51', '2019-12-18 02:52:39');

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

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title1` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle1` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon1` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url1` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title2` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle2` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon2` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url2` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title3` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle3` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon3` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url3` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title4` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle4` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon4` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url4` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title5` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subtitle5` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon5` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url5` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title1`, `subtitle1`, `icon1`, `redirect_url1`, `title2`, `subtitle2`, `icon2`, `redirect_url2`, `title3`, `subtitle3`, `icon3`, `redirect_url3`, `title4`, `subtitle4`, `icon4`, `redirect_url4`, `title5`, `subtitle5`, `icon5`, `redirect_url5`, `created_at`, `updated_at`) VALUES
(1, 'Calculators', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do', '1580134293-1.svg', 'https://www.google.com/', 'Sales Presenters', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do', '1580136582-2.svg', '#', 'Become a Member', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit', '1580136720-3.svg', '#', 'Premium Banners', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do', '1580136720-4.svg', '#', 'Marketing Video', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do', '1580136720-5.svg', '#', '2020-01-26 18:30:00', '2020-01-27 09:37:30');

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

--
-- Table structure for table `blogcomments`
--

CREATE TABLE `blogcomments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogcomments`
--

INSERT INTO `blogcomments` (`id`, `blog_id`, `name`, `email`, `website`, `comment`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 'Subhasish Samanta', 'info@vaptechnology.in', 'www.vaptech.in', 'Test Comment', 1, '2020-01-31 02:13:42', '2020-01-31 02:13:42');

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `blog_category_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `cover_image`, `title`, `slug`, `content`, `author`, `views`, `is_active`, `created_at`, `updated_at`, `blog_category_id`) VALUES
(1, '1576654206.jpg', 'The falling markets and your investments – what to do?', 'the-falling-markets-and-your-investments-what-to-do', '<p>During the last one month you must have noticed that equity markets have been going down. Large cap index is down about 6-8% from their all time highs. Worst hit are small caps (index down 30-35% from all time high) and Midcaps (index down 15-20% from all time high). Some stocks are down by 50-70% from top. You must be wondering why is all this happening, should you sell now and and is it worth at all to invest in equity markets. I understand your concern.</p>\r\n\r\n<p>What you are witnessing right now is painful but a pretty normal behavior for the equity markets. They tend to respond to sentiments in the short term and fundamentals in the long term. For no reason, markets can go up and down by 15-20% in a matter of few months. It has happened many times in the past and it will continue to happen in future too. This behavior is not limited to India but seen across world markets.</p>\r\n\r\n<p><strong>A few pointers:-</strong></p>\r\n\r\n<p>&ndash; Most of the times (say 9 out of 10 times), markets recover from short term corrections within a few months or quarters. The best action is to remain invested and ignore the volatility.</p>\r\n\r\n<p>&ndash; Sometimes (say 1 out of 10 times), markets will go in deep corrections of 30-50%. This happens once or twice every decade and lasts a few years. It starts with a small correction and the slide continues to the bottom. Everything bleeds. The reason of such fall could be weak economy and future outlook, falling international markets or scams. How to protect this? Well, the honest answer is, we can&rsquo;t. Almost no one knows for sure that markets will fall so much. At best, it&rsquo;s a wild guess of a few so called analysts, who shout loud after the incidence. It&rsquo;s just a matter of being lucky this time with their prediction. We must know that these analysts or predictors are mostly those who got it wrong many times and no one noticed. You may ask &ndash; Can I predict it and save your losses? Frankly, my answer is No. At best, I can minimise the impact by proper asset allocation, understanding your needs and monitoring your portfolio regularly. So, the hard truth is that even when markets fall by 30-50%,&nbsp;<strong>the only choice and best course of action is to stay invested, continue your SIPs and wait for markets to recover</strong>. Trying to time the market (selling and hoping to buy at a lower price) never works.</p>\r\n\r\n<p>&ndash; During bad times, media will aggrevate the situation by highlighting things even more. I bet, they also know nothing about it and just have a good time by getting all the attention of readers and viewers, increased TRPs and ad revenues.</p>\r\n\r\n<p>&ndash; Investing through mutual funds is safer than investing directly in stocks. While mutual funds have fallen but the damage is huge in individual stocks. While some stocks may never recover, most mutual funds recover from lows to their previous highs and even better due to expert fund management.</p>\r\n\r\n<p>&ndash; It is very natural for you to feel the pain because of portfolio value going down. I can understand and I feel the pain too. Trust me, I am reviewing everything and doing my best I can.</p>\r\n\r\n<p>&ndash; The worst thing to do at this time is to panic. It might so happen that after you redeem/book profits/book losses, markets will continue to slide and you will feel you did the right thing. Well, in the short term, yes. But unless you buy at the bottom, you won&rsquo;t benefit from this exercise because markets will definitely go up with time. And buying low happens only in theory.</p>\r\n\r\n<p>&ndash; Events like these are lessons for both you and me to learn and improve our future decisions and action, to stick to asset allocation, to take only those risks which we can and to plan things better.</p>\r\n\r\n<p>&ndash; Goal based planning works best. We must not take risky bets with short term money. If the money that you have invested is for long term, let it stay long term.</p>\r\n\r\n<p>We need to work together in thick and thin. We need to discuss being on the same side of the table. These are tough times and we will go through with it together.</p>\r\n\r\n<p>Feel free to call me anytime if you wish to discuss on the portfolio and future action plan.</p>', 'Brijesh Dalmia', 0, 1, '2019-12-18 02:00:07', '2019-12-19 02:29:52', 1),
(2, '1576654355.jpg', 'One huge benefit from TER cut decision', 'one-huge-benefit-from-ter-cut-decision', '<p>Most clients are extremely loyal to their advisors. All they expect is an honest advice and good service. They may talk about returns but eventually they value relationship more than just returns. This makes the job of an advisor very very simple. Just do your best and you can retain clients for very long term. Yes, 10% of clients can still leave you for whatever reasons but 90% will stay with you.&nbsp; The choice is yours; whether you want to focus on those 10% or the other 90% who trust you, respect you and give you growth in life. Stay loyal to your clients.</p>', 'Sudhakar Gaonkar', 0, 1, '2019-12-18 02:02:35', '2020-01-29 08:21:58', 7);

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

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Business Practice', 'business-practice', 1, '2019-12-19 02:01:50', '2019-12-19 02:01:50'),
(2, 'Motivation', 'motivation', 1, '2019-12-19 02:02:04', '2019-12-19 02:02:04'),
(3, 'Clients', 'clients', 1, '2019-12-19 02:02:18', '2019-12-19 02:02:18'),
(4, 'Super IFA', 'super-ifa', 1, '2019-12-19 02:02:30', '2019-12-19 02:02:30'),
(5, 'Selling', 'selling', 1, '2019-12-19 02:02:46', '2019-12-19 02:02:46'),
(6, 'Regulation', 'regulation', 1, '2019-12-19 02:02:58', '2019-12-19 02:02:58'),
(7, 'Asset Allocation', 'asset-allocation', 1, '2019-12-19 02:03:11', '2019-12-19 02:03:11'),
(8, 'Knowledge', 'knowledge', 1, '2019-12-19 02:03:26', '2019-12-19 02:03:26'),
(9, 'Integrity', 'integrity', 1, '2019-12-19 02:03:37', '2019-12-19 02:03:37'),
(10, 'SIP', 'sip', 1, '2019-12-19 02:03:49', '2019-12-19 02:03:49'),
(11, 'Vision', 'vision', 1, '2019-12-19 02:04:01', '2019-12-19 02:04:01'),
(12, 'Revenue', 'revenue', 1, '2019-12-19 02:04:14', '2019-12-19 02:12:51');

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

--
-- Table structure for table `bookrecommendations`
--

CREATE TABLE `bookrecommendations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heading` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amazon_link` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `flipkart_link` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `download_book_english` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `downloads_english` int(11) NOT NULL DEFAULT 0,
  `download_book_hindi` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `downloads_hindi` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookrecommendations`
--

INSERT INTO `bookrecommendations` (`id`, `cover_image`, `heading`, `title`, `slug`, `content`, `amazon_link`, `flipkart_link`, `download_book_english`, `downloads_english`, `download_book_hindi`, `downloads_hindi`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '1580824063.jpg', 'WRITTEN BY BRIJESH DALMIA', 'Mutual Fund Handbook for IFAs', 'mutual-fund-handbook-for-ifas', '<p>Mutual Fund distribution is a great business to be in. However, among thousands of IFAs who join this business every year, few make it big but many IFAs either just survive or exit very early. This is because they do not get proper guidance and road-map of how to go about this business. This book will act as a guide to such IFAs. Written by a successful IFA himself, this book talks about the practical aspect of this business. Available in Hindi also at Amazon &amp; Flipkart. 11</p>', 'https://www.amazon.in/Mutual-Fund-Handbook-Brijesh-Dalmia/dp/9352121740/ref=sr_1_1?ie=UTF8&qid=1508324889&sr=8-1&keywords=Mutual+Fund+handbook', 'https://www.flipkart.com/mutual-fund-handbook-ifas/p/itme5xdfvhu3thqm?pid=RBKE5XDFYT62QHMC&srno=s_1_1&otracker=search&lid=LSTRBKE5XDFYT62QHMCBWTDGU&fm=SEARCH&iid=e575cd91-8e69-4589-acfc-eb3071b59cf3.RBKE5XDFYT62QHMC.SEARCH&qH=cfab9c751617a8b9', '1580824063.pdf', 0, '1580824063.pdf', 0, 1, '2020-02-04 08:17:43', '2020-02-05 01:19:41'),
(2, '1580824358.jpg', NULL, 'The Supernova Advisor', 'the-supernova-advisor', '<p>To become a successful investment advisor, sales is not sufficient. You must have excellent systems and processes. Also, there is an easier way to acquire more clients and grow faster. The Supernova Advisor will give excellent insights on how to become more effective. Strongly recommend to every IFA.</p>', 'https://www.amazon.in/Supernova-Advisor-Invisible-Exceptional-Consistent/dp/0470249277/ref=sr_1_1?ie=UTF8&qid=1508325777&sr=8-1&keywords=The+Supernova+Advisor', 'https://www.flipkart.com/the-supernova-advisor/p/itmdyp8schttcf9u?pid=9780470249277&srno=s_1_1&otracker=search&lid=LSTBOK9780470249277EUQ18W&fm=SEARCH&iid=c265aaff-c851-4974-8be8-45762f991c8d.9780470249277.SEARCH&qH=611967b01ece73b7', '1580824358.pdf', 0, '1580824358.pdf', 0, 0, '2020-02-04 08:22:38', '2020-02-04 08:22:38');

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

--
-- Table structure for table `clientobjectionhandlings`
--

CREATE TABLE `clientobjectionhandlings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `view_count` int(11) NOT NULL DEFAULT 0,
  `like_count` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `clientobjectionhandlings`
--

INSERT INTO `clientobjectionhandlings` (`id`, `title`, `slug`, `content`, `view_count`, `like_count`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 'My fund is not performing. Why are you not shifting the investments to another fund?', 'my-fund-is-not-performing-why-are-you-not-shifting-the-investments-to-another-fund', '<p>I surely understand your concern. Let me tell the reasons why it doesn&rsquo;t make sense to make changes to your investments currently.</p>\r\n\r\n<p>&ndash; Every fund is different. The philosophy of a particular fund and the underlying investments could be different as compared to other funds. This may result in differential performance during a given period of time.</p>\r\n\r\n<p>&ndash; We also cannot compare a midcap fund with a large cap and vice-versa. It may so happen that there is a recent rally in the large cap stocks and so your midcap fund may show under performance when compared with large cap. We need to compare apples to apples.</p>\r\n\r\n<p>&ndash; Sometimes, you may even notice that your fund is not performing when compared with the peer group. While this definitely needs review but it may not be the reason enough to exit from your fund and invest elsewhere. Ideally, one needs to wait for at least 3 years before deciding to exit. If a particular fund is under-performing the peer group year on year basis for 3 years, it is signal to exit from the fund.</p>\r\n\r\n<p>&ndash; Mostly, the fund recovers after a few bad quarters. Fund managers regularly reviews the portfolio and if required, they change the underlying investments. This may reflect in improved performance going forward. So, one should wait a little longer.</p>\r\n\r\n<p>&ndash; It is rare that a particular fund is always on the top. Their rankings keep on changing. It might so happen that if you exit an under-performing fund and enter a top performing fund, the situation reverses in the next few quarters and your previous funds becomes a top performance and the new fund under-performs. So, one should not be in a hurry to exit.</p>\r\n\r\n<p>&ndash; We should also consider exit loads and taxes before exiting a fund.</p>\r\n\r\n<p>&ndash; I am regularly reviewing your portfolio and if required, I will suggest when to make necessary changes</p>', 0, 0, 1, '2020-02-04 04:32:46', '2020-02-04 05:07:53'),
(3, 'My equity funds are not performing. I am losing principal. Please suggest me alternative investments where I can earn more.', 'my-equity-funds-are-not-performing-i-am-losing-principal-please-suggest-me-alternative-investments-where-i-can-earn-more', '<p class=\"gmail_quote\">I fully understand your concern. These are tough times as equity markets are not doing well. However, I would like to bring to your notice the following :-</p>\r\n<p class=\"gmail_quote\">Primarily, there are 3 main asset class where you can invest. Let us understand them:-</p>\r\n<p class=\"gmail_quote\">1) Real Estate – As you know, real estate investments are currently not doing well. It also requires huge investments. It is illiquid also. I don’t think this is a great time to invest in real estate.</p>\r\n<p class=\"gmail_quote\">2) Bonds – You can consider to invest in fixed income products like bank FD, company FD, debentures, govt bonds, etc. Even mutual funds have debt schemes. I deal in these products and if you like them, I can suggest you some options. While you should have some exposure in fixed income products as an asset allocation strategy but considering your profile, it is not a good idea to have over exposure in bonds. Their returns are not very exciting. Also, most of them carry high tax on income. While they look attractive when equity markets are not doing well but if you are considering investment for&nbsp; 5-10 years and above, they may not be a great option to invest in. If you think, you will convert your bond investments to equities when markets recover, it happens only in hindsight, not reality.</p>\r\n<p class=\"gmail_quote\">3) Equity – Equities offer the best returns in long term. Yes, they are volatile and can give negative returns also in the short term but it makes sense to stay invested. When you invest in equities through mutual funds, they are safer than other forms of equity investment because of expert fund management and excellent processes that they follow. Don’t just look at last few year performance. I will show you the long term performance of the schemes in which you have investments. It is very decent. These are not very good times. Wait for a few more years and I think your investments will do well.</p>\r\n<p class=\"gmail_quote\">Most other investment options which you see in the market falls in one of the above category. It may just be structured differently. So, there aren’t really many investment options, just a variation of debt and equity.</p>\r\n<p>I know it hurts to see poor returns in the portfolio and when you compare it with last 1-2 years of FD return, it pains even more. But if you hold your investments for many years and look back, you will find that these investments have done far better than FDs and you will be happy that you continued in equity&nbsp; mutual funds.</p>', 0, 0, 1, '2020-02-04 05:08:55', '2020-02-04 05:08:55'),
(4, 'Debt fund is not giving good returns since last 1-2 years. FD was better. (June’18)', 'debt-fund-is-not-giving-good-returns-since-last-1-2-years-fd-was-better-june-18', '<p>Yes, it is very challenging to handle this objection. First of all, an advisor converts the clients fd into debt funds and then it under performs.</p>\r\n<p>This could be your response to clients:-</p>\r\n<ul>\r\n<li>These are tough times. I understand your concern. Due to unforeseen hike in interest rates in the country, debt funds are under pressure. (explain the inverse relationship between interest rates and bond prices).</li>\r\n<li>However, there is a positive development also. Since interest rates have gone up, the yield to maturity of debt funds have also gone up. This means, if you hold for another year or two, your return is expected to go up. Currently, in most debt funds, YTM after management fees is much higher than FD rates. If you continue to hold, you will get this benefit.</li>\r\n<li>If you hold your debt funds for 3 years, it qualifies for indexation benefit and lower capital gains tax. Your tax liability can reduce by upto 65-70% (if you are in 30% tax bracket) if you continue to hold. Because of this, even if the returns are equal to FD in 3 years time, you get better post tax returns.</li>\r\n</ul>', 0, 0, 1, '2020-02-04 05:09:47', '2020-02-04 05:09:47');

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

--
-- Table structure for table `downloadtools`
--

CREATE TABLE `downloadtools` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `downloadable_file` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `downloads` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `downloadtools`
--

INSERT INTO `downloadtools` (`id`, `cover_image`, `title`, `slug`, `content`, `downloadable_file`, `downloads`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '1580725929.jpg', 'Test', 'test', '<p>Test Content</p>', '1580725929.pdf', 0, 1, '2020-02-03 05:02:09', '2020-02-03 08:04:53'),
(3, '1580731918.jpg', 'NPS Process Chart', 'nps-process-chart', '<p>This file contains complete &lsquo;process flow&rsquo; to open accounts under National Pension System (NPS). It includes online as well as offline process.</p>', '1580731918.pdf', 0, 1, '2020-02-03 06:41:58', '2020-02-03 06:41:58');

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

--
-- Table structure for table `home_banners`
--

CREATE TABLE `home_banners` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_url` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_banners`
--

INSERT INTO `home_banners` (`id`, `title`, `image`, `redirect_url`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Banner One', '1576501756.jpg', 'https://www.google.com/', 1, '2019-12-16 07:38:31', '2019-12-16 07:39:16');

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

--
-- Table structure for table `home_usefullinks`
--

CREATE TABLE `home_usefullinks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect_url` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_usefullinks`
--

INSERT INTO `home_usefullinks` (`id`, `title`, `icon`, `description`, `redirect_url`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Mock Exams', '1576666729.png', 'These exams will test your knowledge on various subjects and help you learn too.', 'https://www.masterstrokeonline.com/mock-exams', 1, '2019-12-18 05:28:49', '2019-12-18 05:28:49'),
(2, 'IFA Tools', '1576666779.png', 'Tools and information you may need to run your business effectively.', 'https://www.masterstrokeonline.com/ifa-tools', 1, '2019-12-18 05:29:39', '2019-12-18 05:29:39'),
(3, 'Brokerage Calculator', '1576666885.png', 'Plan your business by calculating brokerage you can earn in mutual funds.', 'https://www.masterstrokeonline.com/brokerage-calculator', 1, '2019-12-18 05:31:25', '2019-12-18 05:57:00'),
(4, 'Download Tools', '1576666934.png', 'You can download several tools to manage your practice.', 'https://www.masterstrokeonline.com/ifa-tools/download-tools/', 1, '2019-12-18 05:32:14', '2019-12-18 05:32:14'),
(5, 'Business FAQ', '1576666993.png', 'Hundreds of business development questions answered by Brijesh.', 'https://www.masterstrokeonline.com/ifa-business-faqs/', 1, '2019-12-18 05:33:13', '2019-12-18 05:33:13'),
(6, 'Product FAQ', '1576668383.png', 'Increase your knowledge on various financial products.', 'https://www.masterstrokeonline.com/investment-product-faq/', 1, '2019-12-18 05:33:58', '2019-12-18 05:56:24');

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

--
-- Table structure for table `home_whatsnews`
--

CREATE TABLE `home_whatsnews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `redirect_url` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `home_whatsnews`
--

INSERT INTO `home_whatsnews` (`id`, `title`, `image`, `redirect_url`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Read Success Story of Mr.Aman Gupta', '1576674516.jpg', NULL, 1, '2019-12-18 07:38:36', '2019-12-18 07:38:36'),
(2, 'New Free Banner Uploaded Happy Birthday', '1576674555.jpg', NULL, 1, '2019-12-18 07:39:15', '2019-12-18 07:46:44');

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

--
-- Table structure for table `marketingvideocategories`
--

CREATE TABLE `marketingvideocategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketingvideocategories`
--

INSERT INTO `marketingvideocategories` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Financial Planning', 'financial-planning', 1, '2020-02-07 00:41:36', '2020-02-07 00:41:36'),
(2, 'SIP', 'sip', 1, '2020-02-07 00:42:07', '2020-02-07 00:42:07'),
(3, 'Investment Planning', 'investment-planning', 1, '2020-02-07 00:42:29', '2020-02-07 00:42:29'),
(4, 'Equity Investment', 'equity-investment', 1, '2020-02-07 00:42:47', '2020-02-07 00:42:47'),
(5, 'Other', 'other', 1, '2020-02-07 00:43:09', '2020-02-07 00:43:09');

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

--
-- Table structure for table `marketingvideos`
--

CREATE TABLE `marketingvideos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `marketingvideocategory_id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` double NOT NULL DEFAULT 0,
  `downloads` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `marketingvideos`
--

INSERT INTO `marketingvideos` (`id`, `marketingvideocategory_id`, `cover_image`, `video`, `title`, `slug`, `content`, `views`, `downloads`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 2, '1581061572.jpg', '1581061572.mp4', 'SIP Today..SWP Tomorrow', 'sip-today-swp-tomorrow', '<p>SIP today and SWP tomorrow is an excellent way to plan for retirement funds. This video will help you reach out to your clients for planning their future goals</p>', 0, 0, 1, '2020-02-07 02:16:12', '2020-02-07 02:16:12'),
(3, 1, '1581073185.png', '1581073185.mp4', 'Retirement Planning', 'retirement-planning', '<p>This video explains of Importance&nbsp;of&nbsp;Planning&nbsp;for&nbsp;Retirement.</p>', 0, 0, 1, '2020-02-07 05:29:45', '2020-02-07 05:29:45');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_12_12_100527_create_admin_auths_table', 1),
(6, '2019_12_17_113120_create_videos_table', 3),
(8, '2019_12_18_062845_create_blogs_table', 4),
(9, '2019_12_18_080329_create_articles_table', 5),
(10, '2019_12_18_105208_create_home_usefullinks_table', 6),
(11, '2019_12_18_125705_create_home_whatsnews_table', 7),
(12, '2019_12_19_062838_create_testimonials_table', 8),
(13, '2019_12_19_072531_create_blog_categories_table', 9),
(14, '2019_12_19_074538_add_blog_category_id_to_blogs_table', 10),
(15, '2019_12_19_093633_create_options_table', 11),
(16, '2019_12_20_061630_create_pages_table', 12),
(17, '2019_12_23_093735_create_thoughts_table', 13),
(18, '2019_12_26_065045_create_thought_categories_table', 14),
(19, '2019_12_26_065539_add_thought_category_id_to_thoughts_table', 15),
(21, '2020_01_27_114015_create_banners_table', 17),
(22, '2019_12_16_110115_create_home_banners_table', 18),
(23, '2020_01_30_100205_create_blogcomments_table', 19),
(24, '2020_01_31_072617_create_articlecomments_table', 19),
(25, '2020_01_31_113701_create_news_table', 20),
(26, '2020_02_03_092416_create_downloadtools_table', 21),
(27, '2020_02_04_075830_create_clientobjectionhandlings_table', 22),
(28, '2020_02_04_100634_create_bookrecommendations_table', 23),
(29, '2014_10_12_000000_create_users_table', 24),
(32, '2020_02_06_074000_create_premiumbannercategories_table', 25),
(33, '2020_02_06_072756_create_premiumbanners_table', 26),
(34, '2020_02_06_135208_create_marketingvideocategories_table', 27),
(35, '2020_02_06_135134_create_marketingvideos_table', 28);

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

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `source_url` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `author` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `cover_image`, `title`, `slug`, `content`, `source_url`, `author`, `views`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '1580473531.jpg', 'RTAs should be asked to update KYC immediately, FIFA requests AMFI', 'rtas-should-be-asked-to-update-kyc-immediately-fifa-requests-amfi', '<p>Highlighting the key issues faced by the mutual fund distribution community, Federation of Independent Financial Advisors (FIFA) has submitted a letter to AMFI requesting them to address distributors concerns on an urgent basis&hellip;.</p>', 'https://cafemutual.com/news/industry/16943-rtas-should-be-asked-to-update-kyc-immediately-fifa-requests-amfi', 'Subhasish', 0, 1, '2020-01-31 06:55:31', '2020-01-31 06:55:31'),
(2, '1580473756.jpg', 'Advisors with mobile apps will have a big advantage', 'advisors-with-mobile-apps-will-have-a-big-advantage', '<p>Financial advisors with mobile apps are more likely to succeed in the future. A survey by business and management consulting firm EY shows that investors&rsquo; demand for mobile apps to manage their wealth</p>', 'https://www.morningstar.in/posts/53438/impact-new-sebi-norms-debt-funds.aspx-', 'Subhasish', 0, 1, '2020-01-31 06:59:16', '2020-01-31 06:59:16');

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

--
-- Table structure for table `options`
--

CREATE TABLE `options` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `option_name` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `option_value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `options`
--

INSERT INTO `options` (`id`, `option_name`, `option_value`, `created_at`, `updated_at`) VALUES
(1, 'site_logo', '1576752307.png', NULL, '2019-12-19 05:15:07'),
(2, 'site_title', 'Masterstrokeonline', NULL, '2019-12-19 05:15:07'),
(3, 'meta_keywords', 'Masterstrokeonline', NULL, '2019-12-19 05:15:07'),
(4, 'meta_description', 'Masterstrokeonline', NULL, '2019-12-19 05:15:07'),
(5, 'contact_address', '203, Vinayak Chambers 10/A, Hospital Street, Kolkata - 700072', NULL, '2019-12-19 05:15:07'),
(6, 'contact_phone', '+91 9883818627', NULL, '2019-12-19 05:15:07'),
(7, 'contact_email', 'info@masterstrokeonline.com', NULL, '2019-12-19 05:15:07'),
(12, 'thought_of_the_day_description', 'Everyday meet two clients and solve every query you receive. One day you will become a top IFA.', NULL, '2019-12-19 05:28:42'),
(13, 'thought_of_the_day_redirect_link', '#', NULL, '2019-12-19 05:28:42'),
(14, 'free_videos_sort_description', 'Watch short videos by Brijesh on specific topics related to clients, marketing, fund selection, growth targets, managing behavior, etc.', NULL, '2019-12-19 05:28:42'),
(15, 'mock_exams_sort_description', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida.', NULL, '2019-12-19 05:28:42'),
(16, 'mock_exams_redirect_link', '#', NULL, '2019-12-19 05:28:42'),
(17, 'mock_exams_icon', 'mock_exams_icon_1576755434.png', NULL, '2019-12-19 06:07:14'),
(18, 'brokerage_calculator_sort_description', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida.', NULL, '2019-12-19 05:28:42'),
(19, 'brokerage_calculator_redirect_link', '#', NULL, '2019-12-19 05:28:42'),
(20, 'brokerage_calculator_icon', '1576753122.png', NULL, '2019-12-19 05:28:42'),
(21, 'useful_links_sort_description', 'Watch short videos by Brijesh on specific topics related to clients, marketing, fund selection, growth targets, managing behavior, etc.', NULL, '2019-12-19 05:28:42'),
(22, 'what_is_new_sort_description', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore', NULL, '2019-12-19 05:28:42'),
(23, 'what_is_our_client_say_sort_description', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore', NULL, '2019-12-19 05:28:42'),
(24, 'membership', '1500', NULL, '2020-02-07 02:41:11');

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `content`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'About Us', 'about-us', '<section class=\"main-sec\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-12 mb-3\">\r\n<h4>About the Website</h4>\r\n\r\n<p>This website is the brain child of Brijesh Dalmia. The purpose of this website is to empower, educate and motivate IFAs / MFDs / RIAs to grow in their profession. I have tried to give you clear answers, suggestions and guidelines to grow your business. The views are personal and IFAs/MFDs/RIAs should adhere to respective guidelines issued by regulators.</p>\r\n</div>\r\n\r\n<div class=\"col-md-4\">\r\n<div class=\"card text-center\">\r\n<div class=\"card-body\"><img alt=\"\" class=\"img-fluid\" src=\"http://127.0.0.1:8000/photos/shares/about.jpg\" />\r\n<h5 class=\"mt-3\">About Brijesh Dalmia</h5>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-8\">\r\n<p>Brijesh has been connected with financial services industry for over 25 years. He is the founder of &lsquo;Dalmia Advisory Services Pvt. Ltd&rsquo;, a leading boutique wealth management company in India. Brijesh has done massive work in the area of empowering IFAs across India. He has conducted over 700 IFA programs in over 125 cities in India, reaching out to over 25,000 IFAs. His short motivational and strategy videos and business development messages under &lsquo;Masterstroke&rsquo; have huge followings and creating deep impact on IFAs across the country.</p>\r\n\r\n<p>A CFPCM, LUTCF and LMF, Brijesh has authored 9 books till now on investments, business practices and personal growth, reaching over 1,00,000 readers. He is considered to be an opinion maker in the industry. His views and articles are regularly published by several leading publications and websites. In year 2016, he was awarded &lsquo;The Oracle Award&rsquo; by Wealth Forum for outstanding work in the field of mutual fund awareness and IFA empowerment.</p>\r\n\r\n<p>He is also the founder of &lsquo;The Brijesh Dalmia Leadership Company&rsquo;. As a thinker, writer and motivational speaker in the area of life, leadership and personal development, Brijesh has transformed several lives through his coaching, workshops and keynote speaking. Till now, over 60,000 participants have benefited from his powerful speaking, workshops and seminars.</p>\r\n\r\n<p>Brijesh&rsquo;s mission in life is to spread happiness in world, infuse positivity among people and motivate one and all to find the purpose of life and achieve it. He enjoys reading, writing, swimming and listening to music.</p>\r\n\r\n<h5>Join my &lsquo;Masterstroke WhatsApp Broadcast&rsquo;</h5>\r\n\r\n<p>Over 7,000 IFAs across the country have subscribed to Brijesh&rsquo;s WhatsApp Broadcast. To subscribe, follow the following process:-</p>\r\n\r\n<ul class=\"bullet-list\">\r\n	<li>Save mobile no. +91 9883818627</li>\r\n	<li>Send WhatsApp message &ndash; &ldquo;Please Add, Your Name, City&rdquo;</li>\r\n</ul>\r\n<a href=\"#\">Read my recommended books for IFAs here</a><br />\r\n<a href=\"#\">Subscribe my You Tube Channel for latest videos here</a></div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"btm-shape-prt\"><img alt=\"\" class=\"img-fluid\" src=\"http://127.0.0.1:8000/photos/shares/shape2.png\" /></div>\r\n</section>', 1, '2019-12-20 02:52:03', '2019-12-20 02:52:03'),
(2, 'DISCLAIMERS OF THE WEBSITE', 'disclaimers', '<section class=\"main-sec\">\r\n<div class=\"container\">\r\n<div class=\"row\">\r\n<div class=\"col-md-4\">\r\n<div class=\"card\">\r\n<div class=\"card-body\"><a href=\"#\"><img alt=\"\" class=\"img-fluid\" src=\"http://127.0.0.1:8000/photos/shares/Sample-2-rev-2.jpg\" /> </a></div>\r\n</div>\r\n\r\n<div class=\"card mt-3\">\r\n<div class=\"card-body\">\r\n<h4>Quick Links</h4>\r\n\r\n<ul>\r\n	<li><a href=\"#\">Book Recommendation for IFAs</a></li>\r\n	<li><a href=\"#\">Use Specially designed Meeting Notebook</a></li>\r\n	<li><a href=\"#\">List of Mutual Fund Software Vendors</a></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"col-md-8\">\r\n<p>This website is for financial intermediaries only. If you are an investor, please leave now.</p>\r\n\r\n<p>The contents on this website is personal. The intent of this website is to help IFAs / MFDs / RIAs and other financial intermediaries to become more efficient in their profession. We do not take any legal liability or otherwise for any action taken by visitors on the basis of content available on the website.</p>\r\n\r\n<p>Please adhere to laws and guidelines issues by respective regulators like SEBI, IRDA and other regulatory bodies which may change from time to time.</p>\r\n\r\n<p>Website of SEBI :<a href=\"https://www.sebi.gov.in/\" rel=\"noopener\" target=\"_blank\"> https://www.sebi.gov.in/</a></p>\r\n\r\n<p>Website of AMFI :<a href=\"https://www.amfiindia.com/\" rel=\"noopener\" target=\"_blank\"> https://www.amfiindia.com/</a></p>\r\n\r\n<p>Website of IRDA :<a href=\"https://www.irdai.gov.in/\" rel=\"noopener\" target=\"_blank\"> https://www.irdai.gov.in/</a></p>\r\n</div>\r\n</div>\r\n</div>\r\n\r\n<div class=\"btm-shape-prt\"><img alt=\"\" class=\"img-fluid\" src=\"http://127.0.0.1:8000/photos/shares/shape2.png\" /></div>\r\n</section>', 1, '2019-12-20 04:07:13', '2019-12-20 04:54:12'),
(3, 'MEMBERSHIP', 'membership', '<p>\r\n                    When you become a Member, you get the following access / benefits.\r\n                </p>               \r\n                <h4>\r\n                    <a href=\"#\">Access to Masterstroke Online Sales Presenter</a>\r\n                </h4>\r\n                <p>\r\n                    Having the right tools makes it easy to sell more. With Masterstroke Sales Presenters, you will definitely have the edge. It will help you in approaching clients/prospects with quality presentations. It will help boost your brand too. Hundreds of MFDs across the country are using it with great results.\r\n                </p>\r\n                <ul class=\"bullet-list\">\r\n                    <li>\r\n                        You can create customized presentations with your personal branding from over 60 images and use it for marketing purpose.\r\n                    </li>\r\n                    <li>\r\n                        You can download the presentation in PDF form and sent to clients via email or Whats app.\r\n                    </li>\r\n                    <li>\r\n                        You can download pre-designed presentations on SIPs, STPs, SWPs, etc and use it instantly.\r\n                    </li>\r\n                    <li>\r\n                        You can save your presentation for future use too.\r\n                    </li>\r\n                    <li>\r\n                        You can download individual slides with your personal branding and use it on social media.\r\n                    </li>\r\n                    <li>\r\n                       You can add, edit, rearrange your presentations at any time. \r\n                    </li>\r\n                    <li>\r\n                        <a href=\"#\">See samples PDFs which you can create, download and share with clients</a>\r\n                    </li>\r\n                    <li>\r\n                        <a href=\"#\">See all the images which you can use to create your own presentation</a>\r\n                    </li>\r\n                </ul>\r\n                <h4>\r\n                    <a href=\"#\">Access to Masterstroke Client Proposals with Financial Calculators</a>\r\n                </h4>\r\n                <p>\r\n                    This is a fantastic tool to prepare instant investment proposals for clients with your personal branding.\r\n                </p>\r\n                <ul class=\"bullet-list\">\r\n                    <li>\r\n                        You can do various calculations / goal planning with summary or detailed report. Over 25 Calculators.\r\n                    </li>\r\n                    <li>\r\n                        You can add your suggested mutual fund schemes for investments along with their performance.\r\n                    </li>\r\n                    <li>\r\n                        You can add unique sales presenters in the report, like SIP, STP, SWP, goal planning, etc.\r\n                    </li>\r\n                    <li>\r\n                        You can download the report in PDF and sent to client via email, Whats App.\r\n                    </li>\r\n                    <li>\r\n                        You can save your report for future use too.\r\n                    </li>\r\n                </ul>\r\n                <a class=\"mb-4 d-block\" href=\"#\">Click here to See Sample reports</a>\r\n                <h4>\r\n                    <a href=\"#\">Access to Premium Banners</a>\r\n                </h4>\r\n                <p>Download Premium Promotional Banners with your own branding which you can share with your clients and prospects through What’sApp or Social Media.</p>\r\n                <ul class=\"bullet-list\">\r\n                    <li>\r\n                        Promotional Banner : 2-4 every month, 30-40 Banners in a year.\r\n                    </li>\r\n                    <li>\r\n                        Choose the banners category wise.\r\n                    </li>\r\n                </ul>\r\n                <h4>\r\n                    <a href=\"#\">Access to Marketing Animated Videos</a>\r\n                </h4>\r\n                <p>Animated Marketing Video are extremely effective resources for your marketing campaigns.</p>\r\n                <p>\r\n                    Download Marketing Animated Video with your Personal branding which you can share with your clients and prospects through What’sApp or Social Media.\r\n                </p>\r\n                <ul class=\"bullet-list\">\r\n                    <li>\r\n                        Every Month we will give you 1 animated marketing videos.\r\n                    </li>\r\n                    <li>\r\n                        Choose the Videos category wise.\r\n                    </li>\r\n                </ul>\r\n                <h4>\r\n                    <a href=\"#\">Cost of Membership</a>\r\n                </h4>\r\n                <p>\r\n                    Price – Rs.9,999/- (valid for 12 months)\r\n                </p>\r\n                <h4>\r\n                    Support\r\n                </h4>\r\n                <p>\r\n                    You will get full support to use the features of Sales Presenters and client proposals with calculators. For any assistance/query, <br>\r\n                    call Suman @ <a href=\"tel:+91-9883818627\">+91-9883818627</a>\r\n                </p>', 1, '2020-02-06 00:39:41', '2020-02-06 00:47:31');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `premiumbannercategories`
--

CREATE TABLE `premiumbannercategories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `premiumbannercategories`
--

INSERT INTO `premiumbannercategories` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 'New', 'new', 1, '2020-02-06 04:32:48', '2020-02-06 04:32:48'),
(3, 'General', 'general', 1, '2020-02-06 04:32:58', '2020-02-06 04:32:58'),
(4, 'Goal Based Planning', 'goal-based-planning', 1, '2020-02-06 04:34:13', '2020-02-06 04:34:13'),
(5, 'Financial Planning', 'financial-planning', 1, '2020-02-06 04:34:36', '2020-02-06 04:34:36'),
(6, 'Festival', 'festival', 1, '2020-02-06 04:35:00', '2020-02-06 04:35:00'),
(7, 'SIP', 'sip', 1, '2020-02-06 04:35:14', '2020-02-06 04:35:14'),
(8, 'Famous Quotes', 'famous-quotes', 1, '2020-02-06 04:35:34', '2020-02-06 04:35:34');

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

--
-- Table structure for table `premiumbanners`
--

CREATE TABLE `premiumbanners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `premiumbannercategory_id` bigint(20) UNSIGNED NOT NULL,
  `cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `premium_banner` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `views` double NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `premiumbanners`
--

INSERT INTO `premiumbanners` (`id`, `premiumbannercategory_id`, `cover_image`, `premium_banner`, `title`, `slug`, `content`, `views`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 7, '1580995078.jpg', '1580995079.jpg', 'test', 'test', '<p>Test content</p>', 0, 1, '2020-02-06 07:47:59', '2020-02-06 07:47:59'),
(2, 5, '1581074511.jpg', '1581074511.jpg', 'Kids grow up quickly', 'kids-grow-up-quickly', '<p>Kids grow up quickly and so do there need</p>', 0, 1, '2020-02-07 05:51:51', '2020-02-07 05:51:51');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `designation` varchar(350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `image`, `name`, `designation`, `content`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '1576738002.jpg', 'Mahesh Maruti Chavan, Mumbai', 'Businessman', 'Masterstroke Sales Presenter is very valuable. It carries simple and decent presentation. After two years, I have been able to do client meetings without my iPad.', 1, '2019-12-19 01:16:42', '2019-12-19 01:16:42'),
(2, '1576738052.jpg', 'Jhon Doe', 'Businessman', 'I am a member of MasterStroke. Online Sales Presenter is helping me increase my business. I am also using client proposals extensively. They look so professional. Thank you so much for creating such wonderful tools which every advisor needs.', 1, '2019-12-19 01:17:32', '2019-12-19 01:39:06');

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

--
-- Table structure for table `thoughts`
--

CREATE TABLE `thoughts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `thought_category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `thought_like` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `thoughts`
--

INSERT INTO `thoughts` (`id`, `content`, `is_active`, `created_at`, `updated_at`, `thought_category_id`, `thought_like`) VALUES
(2, 'If you are indifferent to market highs and lows, you are on the path of becoming a great advisor.', 1, '2019-12-23 04:37:27', '2020-01-28 06:50:46', NULL, 4),
(3, 'Only one thing will protect you. The loyalty of your clients.', 1, '2019-12-23 04:37:37', '2019-12-23 04:37:37', NULL, 0),
(4, 'Excessive disclosure does more harm than good.', 1, '2019-12-23 04:37:45', '2020-01-28 07:56:38', NULL, 2),
(5, 'There will always be people who will value your advice and services. Focus on them.', 1, '2019-12-23 04:37:52', '2019-12-23 04:37:52', NULL, 0),
(6, 'Trail is like investments. They both compound with time.', 1, '2019-12-23 04:37:59', '2020-01-28 07:49:15', 5, 3),
(7, 'Advisors job is to hedge the risk, not predict the returns.', 1, '2019-12-23 04:38:06', '2020-01-28 06:48:49', NULL, 3),
(8, 'SWP can help you garner big AUM.', 1, '2019-12-23 04:38:11', '2020-01-28 09:45:01', 1, 11),
(9, 'If you work sincerely during work hours, you would never require to do overtime.', 1, '2019-12-23 04:38:19', '2020-01-28 08:33:58', 1, 5),
(10, 'Your growth will depend on your group of IFAs you interact with. Choose your group wisely.', 1, '2019-12-23 04:38:27', '2020-01-30 09:20:40', 1, 11);

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

--
-- Table structure for table `thought_categories`
--

CREATE TABLE `thought_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `thought_categories`
--

INSERT INTO `thought_categories` (`id`, `name`, `slug`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Motivation', 'motivation', 1, '2019-12-26 02:16:29', '2019-12-26 02:21:01'),
(2, 'Clients', 'clients', 1, '2020-01-28 07:48:00', '2020-01-28 07:48:00'),
(3, 'Selling', 'selling', 1, '2020-01-28 07:48:28', '2020-01-28 07:48:28'),
(4, 'Wisdom', 'wisdom', 1, '2020-01-28 07:48:38', '2020-01-28 07:48:38'),
(5, 'Super IFAs', 'super-ifas', 1, '2020-01-28 07:48:50', '2020-01-28 07:48:50'),
(6, 'Integrity', 'integrity', 1, '2020-01-28 07:49:00', '2020-01-28 07:49:00'),
(7, 'Vision', 'vision', 1, '2020-01-28 07:50:05', '2020-01-28 07:50:05'),
(8, 'Regulation', 'regulation', 1, '2020-01-28 07:50:14', '2020-01-28 07:50:14'),
(9, 'SIP', 'sip', 1, '2020-01-28 07:50:21', '2020-01-28 07:50:21'),
(10, 'Service', 'service', 1, '2020-01-28 07:50:29', '2020-01-28 07:50:29'),
(11, 'Stock Market', 'stock-market', 1, '2020-01-28 07:50:39', '2020-01-28 07:50:39'),
(12, 'Knowledge', 'knowledge', 1, '2020-01-28 07:50:47', '2020-01-28 07:50:47'),
(13, 'Trail', 'trail', 1, '2020-01-28 07:50:56', '2020-01-28 07:50:56');

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

--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(151) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_payable` tinyint(4) NOT NULL DEFAULT 0,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_cover_image` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(151) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` double NOT NULL DEFAULT 0,
  `youtube_url` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `title`, `is_payable`, `description`, `video_cover_image`, `video`, `price`, `youtube_url`, `is_active`, `created_at`, `updated_at`) VALUES
(2, 'Test Video Title with Payable Update', 1, 'Test payable video description', '1576586807.jpg', '1576586807.mp4', 2000, NULL, 1, '2019-12-17 07:16:47', '2019-12-17 08:23:45'),
(3, 'PPF vs ELSS', 0, 'Is ELSS a better alternative to PPF? Should financial advisors recommend PPF? In this video, Brijesh decodes the PPF vs ELSS question.', NULL, NULL, 0, 'https://www.youtube.com/watch?v=iPj-nmwv5TM&feature=emb_logo', 1, '2019-12-18 00:42:19', '2019-12-18 00:42:19'),
(4, 'Returns vs Safety', 0, 'In this video Brijesh explains the role of financial advisors with respect to returns vs safety on client\'s investments.', NULL, NULL, 0, 'https://www.youtube.com/watch?v=MnBbCXP6S5g&feature=emb_logo', 1, '2019-12-18 00:42:55', '2019-12-18 00:42:55'),
(5, 'First Meeting with prospective clients (IFAs)', 0, 'In this video for IFAs, Brijesh explains how should you introduce and present yourself during the first meeting with a prospective client.', NULL, NULL, 0, 'https://www.youtube.com/watch?time_continue=1&v=jXSoJuZ5koM&feature=emb_logo', 1, '2019-12-18 00:43:27', '2019-12-18 00:43:27'),
(6, 'How to grow fast', 0, 'In this video IFAs will know how to grow fast. What activities they should focus on and what should be delegated.', NULL, NULL, 0, 'https://www.youtube.com/watch?v=yAf4Kw1kBQE&feature=emb_logo', 1, '2019-12-18 00:44:03', '2019-12-18 00:44:03');

--
-- Indexes for table `articlecomments`
--
ALTER TABLE `articlecomments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `articlecomments_article_id_foreign` (`article_id`);

--
-- Indexes for table `articles`
--
ALTER TABLE `articles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogcomments`
--
ALTER TABLE `blogcomments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogcomments_blog_id_foreign` (`blog_id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `blogs_blog_category_id_foreign` (`blog_category_id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bookrecommendations`
--
ALTER TABLE `bookrecommendations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clientobjectionhandlings`
--
ALTER TABLE `clientobjectionhandlings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `downloadtools`
--
ALTER TABLE `downloadtools`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_banners`
--
ALTER TABLE `home_banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_usefullinks`
--
ALTER TABLE `home_usefullinks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_whatsnews`
--
ALTER TABLE `home_whatsnews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `marketingvideocategories`
--
ALTER TABLE `marketingvideocategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `marketingvideos`
--
ALTER TABLE `marketingvideos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `marketingvideos_marketingvideocategory_id_foreign` (`marketingvideocategory_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `premiumbannercategories`
--
ALTER TABLE `premiumbannercategories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `premiumbanners`
--
ALTER TABLE `premiumbanners`
  ADD PRIMARY KEY (`id`),
  ADD KEY `premiumbanners_premiumbannercategory_id_foreign` (`premiumbannercategory_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `thoughts`
--
ALTER TABLE `thoughts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `thoughts_thought_category_id_foreign` (`thought_category_id`);

--
-- Indexes for table `thought_categories`
--
ALTER TABLE `thought_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `videos`
--
ALTER TABLE `videos`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `articlecomments`
--
ALTER TABLE `articlecomments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `articles`
--
ALTER TABLE `articles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blogcomments`
--
ALTER TABLE `blogcomments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `bookrecommendations`
--
ALTER TABLE `bookrecommendations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `clientobjectionhandlings`
--
ALTER TABLE `clientobjectionhandlings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `downloadtools`
--
ALTER TABLE `downloadtools`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `home_banners`
--
ALTER TABLE `home_banners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `home_usefullinks`
--
ALTER TABLE `home_usefullinks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `home_whatsnews`
--
ALTER TABLE `home_whatsnews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `marketingvideocategories`
--
ALTER TABLE `marketingvideocategories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `marketingvideos`
--
ALTER TABLE `marketingvideos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `options`
--
ALTER TABLE `options`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `premiumbannercategories`
--
ALTER TABLE `premiumbannercategories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `premiumbanners`
--
ALTER TABLE `premiumbanners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `thoughts`
--
ALTER TABLE `thoughts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `thought_categories`
--
ALTER TABLE `thought_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `videos`
--
ALTER TABLE `videos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `articlecomments`
--
ALTER TABLE `articlecomments`
  ADD CONSTRAINT `articlecomments_article_id_foreign` FOREIGN KEY (`article_id`) REFERENCES `articles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blogcomments`
--
ALTER TABLE `blogcomments`
  ADD CONSTRAINT `blogcomments_blog_id_foreign` FOREIGN KEY (`blog_id`) REFERENCES `blogs` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `blogs`
--
ALTER TABLE `blogs`
  ADD CONSTRAINT `blogs_blog_category_id_foreign` FOREIGN KEY (`blog_category_id`) REFERENCES `blog_categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `marketingvideos`
--
ALTER TABLE `marketingvideos`
  ADD CONSTRAINT `marketingvideos_marketingvideocategory_id_foreign` FOREIGN KEY (`marketingvideocategory_id`) REFERENCES `marketingvideocategories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `premiumbanners`
--
ALTER TABLE `premiumbanners`
  ADD CONSTRAINT `premiumbanners_premiumbannercategory_id_foreign` FOREIGN KEY (`premiumbannercategory_id`) REFERENCES `premiumbannercategories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `thoughts`
--
ALTER TABLE `thoughts`
  ADD CONSTRAINT `thoughts_thought_category_id_foreign` FOREIGN KEY (`thought_category_id`) REFERENCES `thought_categories` (`id`) ON DELETE CASCADE;
COMMIT;

