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

START TRANSACTION;



--
-- Database: `askhindi`
--

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

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

CREATE TABLE `blogs` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `type` varchar(55) DEFAULT 'question',
  `slug` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `body` text CHARACTER SET utf8mb4,
  `featured` int(11) DEFAULT NULL,
  `published` date DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `posted_by` int(11) DEFAULT NULL,
  `meta_info` text,
  `followcnt` int(11) NOT NULL DEFAULT '0',
  `vote` int(11) DEFAULT '0',
  `views` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `blogs` (`id`, `user_id`, `type`, `slug`, `category_id`, `title`, `body`, `featured`, `published`, `tags`, `posted_by`, `meta_info`, `followcnt`, `vote`, `views`, `status`, `created_at`, `updated_at`) VALUES
(8, 1, 'question', 'This_is_test_post_for_language_and_scope', 4, 'This is test post for language and scope1', '<p>This is test post for language and scope 1</p>', NULL, NULL, NULL, NULL, NULL, 0, NULL, 2, 1, '2018-02-11 04:54:12', '2018-08-07 17:06:53'),
(12, 1, 'question', 'this-is-test-post-in-finance-category', 1, 'This is test post in finance category', '<h2>What is Lorem Ipsum?</h2>\r\n\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<h2>Why do we use it?</h2>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n\r\n<h2>What is Lorem Ipsum?</h2>\r\n\r\n<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n\r\n<h2>Why do we use it?</h2>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>', NULL, '2018-07-30', 'test', 7, 'a:3:{s:5:\"title\";s:17:\"Why do we use it?\";s:11:\"description\";s:22:\"Why do we use it? desc\";s:5:\"robot\";s:1:\"1\";}', 0, 3, 108, 1, '2018-07-21 16:54:57', '2018-08-02 17:00:20'),
(13, 7, 'blog', 'this-is-test-post-for-language-and-scope', NULL, 'This is test post for language and scope', '<p>This is test post for language and scopeThis is test post for language and scope and this is basic language</p>', 1, '2018-07-31', 'test,jaipur,mypost', 1, 'a:3:{s:5:\"title\";s:5:\"test1\";s:11:\"description\";s:7:\"jaipur1\";s:5:\"robot\";s:1:\"1\";}', 0, 3, 172, 1, '2018-07-24 17:14:01', '2018-08-04 04:22:35'),
(16, 1, 'question', 'हैलो अनिल यादव यह एक स्कूल है', NULL, 'हैलो अनिल यादव यह एक स्कूल है', '<p>हैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल हैहैलो अनिल यादव यह एक स्कूल है</p>', NULL, '2018-07-30', NULL, 8, 'a:3:{s:5:\"title\";N;s:11:\"description\";N;s:5:\"robot\";s:1:\"1\";}', 1, 2, 32, 1, '2018-07-30 16:22:32', '2018-08-07 17:06:23'),
(17, 4, 'question', 'how-is-india-developing', NULL, 'How is india developing', '<p>How is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developingHow is india developing</p>', NULL, NULL, 'india', NULL, 'a:3:{s:5:\"title\";N;s:11:\"description\";N;s:5:\"robot\";s:1:\"1\";}', 0, 1, 11, 1, '2018-08-03 17:42:37', '2018-08-07 17:06:20');

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

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

CREATE TABLE `blog_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `category_id` int(11) 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 `blog_categories`
--

INSERT INTO `blog_categories` (`id`, `blog_id`, `category_id`, `created_at`, `updated_at`) VALUES
(120, 14, 1, '2018-07-29 00:26:55', '2018-07-29 00:26:55'),
(128, 15, 1, '2018-07-30 10:23:34', '2018-07-30 10:23:34'),
(129, 16, 5, '2018-07-30 10:52:32', '2018-07-30 10:52:32'),
(131, 12, 8, '2018-08-01 10:55:13', '2018-08-01 10:55:13'),
(132, 13, 5, '2018-08-03 12:10:36', '2018-08-03 12:10:36'),
(133, 13, 6, '2018-08-03 12:10:36', '2018-08-03 12:10:36'),
(134, 17, 9, '2018-08-03 12:12:37', '2018-08-03 12:12:37');

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

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` int(10) UNSIGNED NOT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `vote` int(11) NOT NULL DEFAULT '0',
  `views` int(11) NOT NULL DEFAULT '0',
  `status` int(11) 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 `blog_comments`
--

INSERT INTO `blog_comments` (`id`, `blog_id`, `parent_id`, `user_id`, `comment`, `vote`, `views`, `status`, `created_at`, `updated_at`) VALUES
(8, 13, NULL, 1, 'dfdfdfd', 0, 0, 1, '2018-07-28 21:33:03', '2018-07-28 21:33:03'),
(9, 13, NULL, 1, 'dfdfdfsdfsdfsd', 0, 0, 1, '2018-07-28 21:33:08', '2018-07-28 21:33:08'),
(16, 12, NULL, 1, 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.', 1, 31, 1, '2018-08-01 10:56:05', '2018-08-02 11:30:32'),
(17, 12, NULL, 1, 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.', 2, 17, 1, '2018-08-01 10:56:12', '2018-08-02 11:30:33'),
(18, 12, NULL, 1, 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', 2, 22, 1, '2018-08-01 10:56:25', '2018-08-02 11:30:33'),
(19, 12, 18, 1, 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.', 0, 3, 1, '2018-08-01 10:58:14', '2018-08-01 11:43:20');

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

--
-- Table structure for table `blog_votes`
--

CREATE TABLE `blog_votes` (
  `id` int(10) UNSIGNED NOT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `comment_id` int(11) DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(55) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(255) 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;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `followcnt` int(11) NOT NULL DEFAULT '0',
  `status` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `slug`, `name`, `followcnt`, `status`, `created_at`, `updated_at`) VALUES
(1, 'english', 'English', 1, 1, '2017-09-18 09:50:36', '2018-08-03 17:30:36'),
(4, 'finance', 'Finance', 1, 1, '2018-02-11 04:01:13', '2018-08-04 12:57:32'),
(5, 'computer-science', 'Computer Science', 4, 1, '2018-02-11 04:10:23', '2018-08-04 01:54:42'),
(6, 'test-cat', 'Test Cat', 0, 1, '2018-02-12 01:48:23', '2018-07-24 15:59:51'),
(8, 'electronics-and-computer', 'Electronics and computer', 0, 1, '2018-07-24 16:02:19', '2018-07-24 16:02:19'),
(9, 'Business-व्यवसाय', 'Business-व्यवसाय', 0, 1, '2018-07-30 16:35:23', '2018-07-30 16:35:23'),
(10, 'education', 'Education', 0, 1, '2018-08-04 12:20:12', '2018-08-04 12:20:12'),
(11, 'banking-finance', 'Banking and Finance', 0, 1, '2018-08-04 12:20:54', '2018-08-04 12:20:54');

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

--
-- Table structure for table `emails`
--

CREATE TABLE `emails` (
  `id` int(11) NOT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `subject` text,
  `message` text,
  `status` int(11) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emails`
--

INSERT INTO `emails` (`id`, `slug`, `subject`, `message`, `status`, `created_at`, `updated_at`) VALUES
(1, 'forgot_password', 'Reset Password Link', '<p>{{name}}</p>\r\n\r\n<p>We\\&#39;ve received a request to reset your password</p>\r\n\r\n<p>To create a new account password, please click the link below</p>\r\n\r\n<p><a href=\"{{URL}}\">Click here</a></p>\r\n\r\n<p>If the above link doesn\\&#39;t work for you, try copy-and-pasting the following url into your web browser</p>\r\n\r\n<p>{{URL}}</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>If you did not request to reset your password, please ignore this message. Feel free to contact us at <a href=\"mailto:{{ADMIN_MAIL}}\">{{ADMIN_MAIL}} </a>if you have any questions</p>\r\n\r\n<p>Customer Support Team<br />\r\n<a href=\"{{SITE_URL}}\">{{SITE_NAME}}</a></p>\r\n', 1, '2017-07-18 03:50:47', '2018-01-19 05:06:49'),
(2, 'registeration_mail_to_admin', 'New Registration', '<p><strong>Hi {{ADMIN_NAME}}</strong></p>\r\n\r\n<p>A New Registration On <strong>{{SITE_NAME}}</strong></p>\r\n\r\n<p>New User Register User Detail is</p>\r\n\r\n<table align=\"left\" border=\"1\" cellpadding=\"3\" cellspacing=\"3\" style=\"width:500px\">\r\n	<thead>\r\n		<tr>\r\n			<th scope=\"col\">\r\n			<p>User Name</p>\r\n			</th>\r\n			<th scope=\"col\">Email</th>\r\n			<th scope=\"col\">Phone Number</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>{{name}}</td>\r\n			<td>{{email}}</td>\r\n			<td>{{phone_number}}</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n', 1, '2017-07-18 05:12:36', '2018-01-19 05:06:53'),
(3, 'registeration_mail_to_user', 'Registration Successfull', '<p><strong>Hi {{name}}</strong></p>\r\n\r\n<p>Thank You for Register our site <strong>{{site_name}}</strong></p>\r\n\r\n<p>You can login on site {{site_url}} using your entered details.</p>\r\n\r\n<p>Regards</p>\r\n\r\n<p>{{admin_name}}</p>\r\n\r\n<p>If you have any concern please feel free to contact at {{admin_mail}}</p>', 1, '2017-07-18 05:18:08', '2018-01-18 23:18:58'),
(4, 'payment_successfull', 'Payment Successfull', '<p><strong>HI {{username}}</strong></p>\r\n\r\n<p>Your Payment that you done on {{SITE_NAME}} done successfully. And you plan on {{SITE_NAME}} has been updated to paid version where you can access all cateogories of Phonics/Decoding and can give test on site.</p>\r\n\r\n<p>Following is your Payment Detail.</p>\r\n\r\n<table align=\"left\" border=\"1\" cellpadding=\"3\" cellspacing=\"3\" style=\"width:500px\">\r\n	<thead>\r\n		<tr>\r\n			<th scope=\"col\">\r\n			<p>Transection ID</p>\r\n			</th>\r\n			<th scope=\"col\">Payment</th>\r\n			<th scope=\"col\">\r\n			<p>Currency</p>\r\n			</th>\r\n		</tr>\r\n	</thead>\r\n	<tbody>\r\n		<tr>\r\n			<td>{{transection_id}}</td>\r\n			<td>{{payment_amount}}</td>\r\n			<td>\r\n			<p>{{currency_code}}</p>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Regards</p>\r\n\r\n<p>{{ADMIN_NAME}}</p>\r\n\r\n<p>If you have any concern please feel free to contact at {{ADMIN_MAIL}}</p>', 1, '2017-09-11 06:53:35', '2018-02-09 12:31:46'),
(5, 'admin_register', 'Registration Successfull', '<p><strong>Hi {{username}}</strong></p>\r\n\r\n<p>You are Register our site <strong>{{SITE_NAME}}</strong></p>\r\n\r\n<p>You can login on site {{SITE_URL}} using credentials details.</p>\r\n\r\n<p>Email : {{EMAIL_ADD}}</p>\r\n\r\n<p>Password : {{PASSWORD}}</p>\r\n\r\n<p>Regards</p>\r\n\r\n<p>{{ADMIN_NAME}}</p>\r\n\r\n<p>If you have any concern please feel free to contact at {{ADMIN_MAIL}}</p>', 1, '2018-01-18 23:04:00', '2018-01-18 23:04:00');

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

--
-- Table structure for table `follows`
--

CREATE TABLE `follows` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `data_id` int(11) DEFAULT NULL,
  `type` varchar(255) 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 `follows`
--

INSERT INTO `follows` (`id`, `user_id`, `data_id`, `type`, `created_at`, `updated_at`) VALUES
(27, 4, 5, 'category', '2018-08-03 10:33:31', '2018-08-03 10:33:31'),
(28, 1, 16, 'blog', '2018-08-03 10:39:26', '2018-08-03 10:39:26'),
(29, 1, 1, 'user', '2018-08-03 11:20:11', '2018-08-03 11:20:11'),
(30, 1, 1, 'category', '2018-08-03 12:00:36', '2018-08-03 12:00:36'),
(31, 1, 5, 'category', '2018-08-03 12:05:09', '2018-08-03 12:05:09'),
(32, 13, 13, 'user', '2018-08-03 20:24:05', '2018-08-03 20:24:05'),
(33, 13, 5, 'category', '2018-08-03 20:24:42', '2018-08-03 20:24:42'),
(34, 1, 23, 'blog', '2018-08-03 22:57:08', '2018-08-03 22:57:08'),
(35, 1, 4, 'category', '2018-08-04 07:27:32', '2018-08-04 07:27:32'),
(36, 1, 4, 'user', '2018-08-04 07:28:34', '2018-08-04 07:28:34'),
(37, 1, 26, 'blog', '2018-08-06 10:54:36', '2018-08-06 10:54:36');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `type` varchar(55) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `staticpage_id` int(11) DEFAULT NULL,
  `weight` int(11) DEFAULT '0',
  `status` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `parent_id`, `type`, `name`, `link`, `staticpage_id`, `weight`, `status`, `created_at`, `updated_at`) VALUES
(15, NULL, 'main', 'Home', '/', NULL, 0, 1, '2018-07-21 12:15:06', '2018-07-29 03:53:01'),
(16, NULL, 'main', 'Our Vision', NULL, 1, 1, 1, '2018-07-21 12:15:23', '2018-07-29 03:53:01'),
(17, NULL, 'main', 'FAQ', NULL, 2, 2, 1, '2018-07-21 12:15:46', '2018-07-29 03:53:01'),
(18, NULL, 'main', 'Blog', 'blogs', NULL, 3, 1, '2018-07-21 12:17:10', '2018-07-29 03:53:01'),
(19, 18, 'main', 'All Blog', 'blogs', NULL, 0, 1, '2018-07-21 12:33:14', '2018-07-29 03:53:01'),
(20, 18, 'main', 'Test Blog', 'blogs/test_post', NULL, 1, 1, '2018-07-21 12:58:45', '2018-07-29 03:53:01'),
(22, 18, 'main', 'Fina Blog', 'question/this-is-test-post-in-finance-category-1111', NULL, 0, 1, '2018-08-04 12:19:14', '2018-08-04 12:19:14');

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

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

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

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

--
-- Table structure for table `static_pages`
--

CREATE TABLE `static_pages` (
  `id` int(11) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `body` text,
  `meta_info` text,
  `status` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `static_pages`
--

INSERT INTO `static_pages` (`id`, `slug`, `title`, `body`, `meta_info`, `status`, `created_at`, `updated_at`) VALUES
(1, 'aboutus', 'About US', '<p>This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;&nbsp;This is about us page.&nbsp;This is about us page.&nbsp;This is about us page.</p>', NULL, 1, '2017-09-18 09:50:36', '2018-02-11 15:11:35'),
(2, 'faq', 'FAQ', '<p><strong>Frequently asked questions</strong>&nbsp;(<strong>FAQ</strong>) or&nbsp;<strong>Questions and Answers</strong>&nbsp;(<strong>Q&amp;A</strong>), are listed questions and answers, all supposed to be commonly asked in some context, and pertaining to a particular topic. The format is commonly used on email mailing lists and other online forums, where certain common questions tend to recur.</p>\r\n\r\n<p>&quot;FAQ&quot; is pronounced as either an&nbsp;<a href=\"https://en.wikipedia.org/wiki/Initialism\">initialism</a>&nbsp;(F-A-Q) or an&nbsp;<a href=\"https://en.wikipedia.org/wiki/Acronym\">acronym</a>. Since the acronym&nbsp;<em>FAQ</em>&nbsp;originated in textual media, its&nbsp;<a href=\"https://en.wikipedia.org/wiki/Pronunciation\">pronunciation</a>&nbsp;varies; &quot;F-A-Q&quot;,<a href=\"https://en.wikipedia.org/wiki/FAQ#cite_note-pron-1\">[1]</a>&nbsp;is commonly heard. Depending on usage, the term may refer specifically to a single frequently asked question, or to an assembled list of many questions and their answers. Web page designers often label a single list of questions as an &quot;FAQ&quot;, such as on&nbsp;<a href=\"https://en.wikipedia.org/wiki/Google_Search\">Google.com</a>,<a href=\"https://en.wikipedia.org/wiki/FAQ#cite_note-2\">[2]</a>&nbsp;while using &quot;FAQs&quot; to denote multiple lists of questions such as on&nbsp;<a href=\"https://en.wikipedia.org/wiki/United_States_Department_of_the_Treasury\">United States Treasury</a>&nbsp;sites.<a href=\"https://en.wikipedia.org/wiki/FAQ#cite_note-3\">[3]</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>The &quot;FAQ&quot; is an&nbsp;<a href=\"https://en.wikipedia.org/wiki/Internet\">Internet</a>&nbsp;textual tradition originating from the technical limitations of early mailing lists from&nbsp;<a href=\"https://en.wikipedia.org/wiki/NASA\">NASA</a>&nbsp;in the early 1980s. The first FAQ developed over several pre-Web years, starting from 1982 when storage was expensive. On&nbsp;<a href=\"https://en.wikipedia.org/wiki/ARPANET\">ARPANET</a>&#39;s SPACE mailing list, the presumption was that new users would download archived past messages through&nbsp;<a href=\"https://en.wikipedia.org/wiki/File_Transfer_Protocol\">FTP</a>. In practice this rarely happened, and the users tended to post questions to the mailing list instead of searching its archives. Repeating the &quot;right&quot; answers becomes tedious, and went against developing&nbsp;<a href=\"https://en.wikipedia.org/wiki/Netiquette\">netiquette</a>. A series of different measures were set up by loosely affiliated groups of computer system administrators, from regularly posted messages to&nbsp;<a href=\"https://en.wikipedia.org/wiki/Netlib\">netlib</a>-like query&nbsp;<a href=\"https://en.wikipedia.org/wiki/Email\">email</a>&nbsp;<a href=\"https://en.wikipedia.org/wiki/Daemon_(computer_software)\">daemons</a>. The acronym&nbsp;<em>FAQ</em>&nbsp;was developed between 1982 and 1985 by Eugene Miya of NASA for the SPACE mailing list.<a href=\"https://en.wikipedia.org/wiki/FAQ#cite_note-faqsaboutfaqs-4\">[4]</a>&nbsp;The format was then picked up on other mailing lists and&nbsp;<a href=\"https://en.wikipedia.org/wiki/Usenet\">Usenet</a>&nbsp;<a href=\"https://en.wikipedia.org/wiki/Newsgroup\">newsgroups</a>. Posting frequency changed to monthly, and finally weekly and daily across a variety of mailing lists and newsgroups. The first person to post a weekly FAQ was&nbsp;<a href=\"https://en.wikipedia.org/wiki/Jef_Poskanzer\">Jef Poskanzer</a>&nbsp;to the Usenet&nbsp;<a href=\"news:net.graphics\">net.graphics</a>/<a href=\"news:comp.graphics\">comp.graphics</a>&nbsp;<a href=\"https://en.wikipedia.org/wiki/Newsgroup\">newsgroups</a>. Eugene Miya experimented with the first daily FAQ.</p>\r\n\r\n<p>Meanwhile, on Usenet,&nbsp;<a href=\"https://en.wikipedia.org/wiki/Mary_Ann_Horton\">Mark Horton</a>&nbsp;had started a series of &quot;Periodic Posts&quot; (PP) which attempted to answer trivial questions with appropriate answers.[<em><a href=\"https://en.wikipedia.org/wiki/Wikipedia:Citation_needed\">citation needed</a></em>]Periodic summary messages posted to Usenet newsgroups attempted to reduce the continual reposting of the same basic questions and associated wrong answers. On Usenet, posting questions which are covered in a group&#39;s FAQ came to be considered poor netiquette, as it showed that the poster has not done the expected background reading before asking others to provide answers. Some groups may have multiple FAQs on related topics, or even two or more competing FAQs explaining a topic from different points of view.</p>\r\n\r\n<p>Another factor on early ARPANET mailing lists was people asking questions promising to &#39;summarize&#39; received answers, then either neglecting to do this or else posting simple concatenations of received replies with little-to-no quality checking.</p>', NULL, 1, '2018-02-09 18:01:36', '2018-02-11 15:08:50'),
(5, 'Career_Page', 'Career Page', '<p>This is test career page.&nbsp;This is test career page.This is test career page.This is test career page.This is test career page.This is test career page.This is test career page.This is test career page.</p>', NULL, 1, '2018-02-10 09:55:48', '2018-02-11 15:08:28'),
(7, 'Digital_Marketing', 'hello this is second thing', '<p>Digital MarketingDigital MarketingDigital MarketingDigital MarketingDigital MarketingDigital MarketingDigital MarketingDigital Marketing</p>', NULL, 1, '2018-02-11 05:32:39', '2018-02-11 15:13:09'),
(8, 'Who_We_Are', 'Who We Are', '<p>Who We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We AreWho We Are</p>', NULL, 1, '2018-02-11 15:09:15', '2018-02-11 15:09:24'),
(9, 'Compur_Science', 'Compur Science', '<p>Compur ScienceCompur ScienceCompur ScienceCompur ScienceCompur ScienceCompur ScienceCompur ScienceCompur Science</p>', NULL, 1, '2018-02-11 15:10:16', '2018-02-11 15:13:17'),
(10, 'News_abut_us_page', 'News abut us page', '<p>News abut us pageNews abut us pageNews abut us pageNews abut us pageNews abut us pageNews abut us pageNews abut us page test</p>\r\n\r\n<h1><strong>Heading</strong></h1>\r\n\r\n<p><strong><img alt=\"\" src=\"http://localhost/quantega/public/admin_upload_images/789a960.jpg\" style=\"height:133px; width:200px\" /></strong></p>\r\n\r\n<p>News abut us pageNews abut us page</p>', NULL, 1, '2018-02-12 01:39:07', '2018-07-21 16:28:20'),
(11, 'about-us', 'About US', '<p>This is our about us page</p>', NULL, 1, '2018-07-21 16:43:35', '2018-07-21 16:48:06'),
(12, 'our-team', 'Our Team', '<p>Our TeamOur TeamOur TeamOur TeamOur TeamOur Team body</p>', 'a:3:{s:5:\"title\";s:21:\"Our Team page title 1\";s:11:\"description\";s:26:\"Our Team description desc1\";s:5:\"robot\";s:1:\"1\";}', 1, '2018-07-25 15:15:42', '2018-07-29 06:04:41');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

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

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

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

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `emails`
--
ALTER TABLE `emails`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

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

--
-- AUTO_INCREMENT for table `static_pages`
--
ALTER TABLE `static_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
COMMIT;

