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

START TRANSACTION;



--
-- Database: `murphy`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`id`, `title`, `desc`, `created_at`, `updated_at`) VALUES
(1, 'Where does it come from?', '<pre class=\"ql-syntax ql-align-justify\" spellcheck=\"false\"> 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.\n\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\nThe standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.\n\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'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.\nLorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'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.\n</pre>', NULL, '2023-07-03 05:59:27');

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

--
-- Table structure for table `catalogs`
--

CREATE TABLE `catalogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `file_path` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `order` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT 1,
  `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 `catalogs`
--

INSERT INTO `catalogs` (`id`, `title`, `file_path`, `file`, `order`, `status`, `created_at`, `updated_at`) VALUES
(2, 'this so edited pdf', 'catalog/1688453602.docx', 'E:\\xampp\\tmp\\phpAD6B.tmp', 6, 1, '2023-06-20 07:27:43', '2023-07-06 09:53:01'),
(11, 'This is again testing', 'catalog/1688388596.txt', NULL, 4, 1, '2023-07-03 12:49:56', '2023-07-04 06:55:07'),
(14, 'army model test paper', 'catalog/1688636279.pdf', NULL, 1, 1, '2023-07-06 09:37:59', '2023-07-06 09:47:50'),
(16, 'catalog testing 2', 'catalog/1688637094.pdf', NULL, 5, 1, '2023-07-06 09:51:34', '2023-07-06 09:52:20');

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `subcategory` bigint(20) UNSIGNED DEFAULT NULL,
  `status` bigint(20) DEFAULT 1,
  `image_path` varchar(255) DEFAULT NULL,
  `file` varchar(255) 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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `subcategory`, `status`, `image_path`, `file`, `created_at`, `updated_at`) VALUES
(5, 'New category', NULL, 1, 'subcategory/1688385220.png', 'E:\\xampp\\tmp\\php5591.tmp', '2023-07-03 11:20:32', '2023-07-03 13:20:44');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `instalink` varchar(255) DEFAULT NULL,
  `whatsapplink` varchar(255) DEFAULT NULL,
  `linkdinlink` varchar(255) DEFAULT NULL,
  `facebooklink` varchar(255) 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 `contact_us`
--

INSERT INTO `contact_us` (`id`, `email`, `phone`, `instalink`, `whatsapplink`, `linkdinlink`, `facebooklink`, `created_at`, `updated_at`) VALUES
(1, 'mktg@murphylightings.com', '9680912290', 'https://www.instagram.com/murphylightings/', '9680912290', 'https://www.linkedin.com/in/murphy-lightings-b066a6165/', 'https://www.facebook.com/MurphyLightings/', NULL, '2023-07-06 10:31:59');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `question` text DEFAULT NULL,
  `answer` text DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `order` bigint(20) DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  `user_type` 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 `faqs`
--

INSERT INTO `faqs` (`id`, `question`, `answer`, `status`, `order`, `category`, `user_type`, `created_at`, `updated_at`) VALUES
(1, 'question q', 'answer', 1, 2, 3, NULL, '2023-06-19 10:36:56', '2023-06-19 10:36:56'),
(2, 'question qi', 'answer', 1, 2, 3, NULL, '2023-06-19 10:37:57', '2023-06-19 10:37:57'),
(3, 'question qiy', 'answer', 1, 2, 3, NULL, '2023-06-19 10:38:56', '2023-06-19 10:38:56'),
(5, 'ghf edited with data', 'dfggf the edited data', 2, 2, 2, 4, '2023-06-19 10:44:17', '2023-07-05 10:20:16'),
(6, 'question s', 'ol', 1, 2, 3, NULL, '2023-06-19 10:52:56', '2023-06-19 10:52:56'),
(8, 'Redeem edited again once more again', 'Redeem hello world how are you bro again you are here.', 1, 1, 10, 1, '2023-06-20 07:40:58', '2023-07-05 11:26:25'),
(10, 'What are some of the Indian Armed Forces’ gallantry awards?', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 10, 4, '2023-06-27 05:02:41', '2023-07-05 11:26:10'),
(11, 'What are some the Indian Armed Forces’ gallantry awards?', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:03', '2023-06-27 05:03:03'),
(12, 'What are some Indian Armed Forces’ gallantry awards?', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:07', '2023-06-27 05:03:07'),
(13, 'What are some Indian Armed Forces’ gallantry awards? The Gallantry Awards were established by the Indian', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:25', '2023-06-27 05:03:25'),
(14, 'What some Indian Armed Forces’ gallantry awards? The Gallantry Awards were established by the Indian', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:32', '2023-06-27 05:03:32'),
(15, 'What some Indian Forces’ gallantry awards? The Gallantry Awards were established by the Indian', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:37', '2023-06-27 05:03:37'),
(16, 'What some Indian Forces’ gallantry awards? The Gallantry Awards were established by the Indian he Param Vir Chakra is the highest gallantry award given by the India', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:03:57', '2023-06-27 05:03:57'),
(17, 'What some Indian ’ gallantry awards? The Gallantry Awards were established by the Indian he Param Vir Chakra is the highest gallantry award given by the India', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:04:03', '2023-06-27 05:04:03'),
(18, 'What some Indian ’ awards? The Gallantry Awards were established by the Indian he Param Vir Chakra is the highest gallantry award given by the India', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:04:09', '2023-06-27 05:04:09'),
(19, 'What some Indian ’ ? The Gallantry Awards were established by the Indian he Param Vir Chakra is the highest gallantry award given by the India', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 2, NULL, '2023-06-27 05:04:14', '2023-06-27 05:04:14'),
(20, 'What some ’ ? The Gallantry Awards were established by the Indian he Param Vir Chakra is the highest gallantry award given by the India', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 4, NULL, '2023-06-27 05:04:38', '2023-06-27 05:04:38'),
(21, 'What distinguishes the Line of Control (LOC) from the Line of Actual Control (LAC)?', 'Answer: The Gallantry Awards were established by the Indian government to recognise the bravery and sacrifice of the troops of the Indian Armed Forces. The Param Vir Chakra is the highest gallantry award given by the Indian Army. India also awards its bravery award recipients the Maha Vir Chakra, Vir Chakra, Ashoka Chakra, Kirti Chakra, and Shaurya Chakra in addition to this distinction.', 1, 1, 4, NULL, '2023-06-27 05:05:02', '2023-06-27 05:05:02'),
(22, 'What distinguishes Line of Control (LOC) from the Line of Actual Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:23', '2023-06-27 05:05:23'),
(23, 'What Line of Control (LOC) from the Line of Actual Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:27', '2023-06-27 05:05:27'),
(24, 'What Line of (LOC) from the Line of Actual Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:32', '2023-06-27 05:05:32'),
(25, 'What of (LOC) from the Line of Actual Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:36', '2023-06-27 05:05:36'),
(26, 'What of (LOC) from the of Actual Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:41', '2023-06-27 05:05:41'),
(27, 'What of (LOC) from the of Control (LAC)?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 4, NULL, '2023-06-27 05:05:47', '2023-06-27 05:05:47'),
(28, 'Why does the Union of India consider Siachen Glacier to be a key region?', 'Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:06:09', '2023-06-27 05:06:09'),
(29, 'Why the Union of India consider Siachen Glacier to be a key region?', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:06:31', '2023-06-27 05:06:31'),
(30, 'Why the Union of India Siachen Glacier to be a key region?', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:06:36', '2023-06-27 05:06:36'),
(31, 'Why the Union of India Siachen Glacier to be a key region?Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:06:48', '2023-06-27 05:06:48'),
(32, 'Why the of India Siachen Glacier to be a key region?Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:06:54', '2023-06-27 05:06:54'),
(33, 'Why the of Siachen Glacier to be a key region?Answer: Since it serves as a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:07:36', '2023-06-27 05:07:36'),
(34, 'Why the of Glacier to be a key region?Answer: Since it serves as a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: Since it serves as a connector for the Shaksgam Valley, Karakoram Pass, and Aksai Chin, Siachen has strategic value for India, Pakistan, and even China. Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.Answer: The  Line of Actual Control (LAC) is a boundary that is not clearly delimited between India and China, similar to Aksai Chin, whereas the Line of Control (LOC) is a defined, militarily designated barrier that divides parts of India and Pakistan.', 1, 1, 5, NULL, '2023-06-27 05:07:42', '2023-06-27 05:07:42'),
(35, 'Give a brief explanation of the Indian Armed Forces’ Integrated Theater Commands.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 5, NULL, '2023-06-27 05:08:19', '2023-06-27 05:08:19'),
(36, 'Give a brief explanation of the Armed Forces’ Integrated Theater Commands.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 5, NULL, '2023-06-27 05:08:25', '2023-06-27 05:08:25'),
(37, 'Give a brief explanation of the Forces’ Integrated Theater Commands.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 5, NULL, '2023-06-27 05:08:29', '2023-06-27 05:08:29'),
(38, 'Give a brief explanation of the ’ Integrated Theater Commands.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 5, NULL, '2023-06-27 05:08:34', '2023-06-27 05:08:34'),
(39, 'Why the of Glacier to be a key region?Answer: Since it serves a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:08:54', '2023-06-27 05:08:54'),
(40, 'the of Glacier to be a key region?Answer: Since it serves a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:08:59', '2023-06-27 05:08:59'),
(41, 'of Glacier to be a key region?Answer: Since it serves a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:09:03', '2023-06-27 05:09:03'),
(42, 'of Glacien?Answer: Since it serves a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:09:11', '2023-06-27 05:09:11'),
(43, 'Since it serves a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:09:20', '2023-06-27 05:09:20'),
(44, 'Since it a connegam Valley, Karakoram Pass, and Aksai Chin, Siachen Therefore, retaining Siachen is essential for India to stop infiltration from both Pakistan and China.', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:09:41', '2023-06-27 05:09:41'),
(45, 'How much do you know about the Delhi-based National War Memorial?', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 6, NULL, '2023-06-27 05:10:11', '2023-06-27 05:10:11'),
(46, 'How do you know about the Delhi-based National War Memorial?', 'Answer: The Indian Armed Forces’ Integrated Theater Commands are different standards of cooperation and inter-service collaboration amongst the armed services of the Indian Armed Forces. Tri-service structures like the Integrated Defence Staff help to develop cooperation and integration. The appointment of a Chief of Defence Staff (CDS) in January 2020 was viewed as a crucial step toward the indigenous collaborative operations of the Indian Armed Forces.', 1, 1, 7, NULL, '2023-06-27 05:10:22', '2023-06-27 05:10:22'),
(47, 'How you know about the Delhi-based National War Memorial?', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:10:40', '2023-06-27 05:10:40'),
(48, 'Howers, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:10:48', '2023-06-27 05:10:48'),
(49, 'Howers, names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:10:55', '2023-06-27 05:10:55'),
(50, 'Howers, of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:11:00', '2023-06-27 05:11:00'),
(51, ', of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:11:05', '2023-06-27 05:11:05'),
(52, ', of personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:11:10', '2023-06-27 05:11:10'),
(53, ', personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 7, NULL, '2023-06-27 05:11:16', '2023-06-27 05:11:16'),
(54, 'Tell me about some of the recent defence contracts signed by the Indian Army.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 8, NULL, '2023-06-27 05:12:03', '2023-06-27 05:12:03'),
(55, 'Tell me about some of the recent defence signed by the Indian Army.', 'Answer: A national memorial commemorating and remembering Indian military personnel who took part in various battles is referred to as the National War Memorial. On the memorial walls are written in gold letters, the names of military personnel who sacrificed their lives in the wars with Pakistan and China. The Indian government constructed this memorial, which spans 40 acres of land, close to India Gate in New Delhi.', 1, 1, 8, NULL, '2023-06-27 05:12:16', '2023-06-27 05:12:16'),
(56, 'Tell me about some of the defence signed by the Indian Army.', 'Answer: In an effort to promote “Aatmanirbhar Bharat” (self-reliant India), the Ministry of Defence has inked more than 180 agreements with Indian businesses, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable Expendable Aerial Target, which represents a significant step toward establishing self-reliance in the defence sector.', 1, 1, 8, NULL, '2023-06-27 05:12:31', '2023-06-27 05:12:31'),
(57, 'Tell me about some of defence signed by the Indian Army.', 'Answer: In an effort to promote “Aatmanirbhar Bharat” (self-reliant India), the Ministry of Defence has inked more than 180 agreements with Indian businesses, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable Expendable Aerial Target, which represents a significant step toward establishing self-reliance in the defence sector.', 1, 1, 8, NULL, '2023-06-27 05:12:38', '2023-06-27 05:12:38'),
(58, 'Tell me about some of defence by the Indian Army.', 'Answer: In an effort to promote “Aatmanirbhar Bharat” (self-reliant India), the Ministry of Defence has inked more than 180 agreements with Indian businesses, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable Expendable Aerial Target, which represents a significant step toward establishing self-reliance in the defence sector.', 1, 1, 8, NULL, '2023-06-27 05:12:42', '2023-06-27 05:12:42'),
(59, 'Tell me about some defence by the Indian Army.', 'Answer: In an effort to promote “Aatmanirbhar Bharat” (self-reliant India), the Ministry of Defence has inked more than 180 agreements with Indian businesses, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable Expendable Aerial Target, which represents a significant step toward establishing self-reliance in the defence sector.', 1, 1, 8, NULL, '2023-06-27 05:12:48', '2023-06-27 05:12:48'),
(60, 'Tell me the names and locations of the Indian Army’s training academies.', 'Indian Military Academy (IMA), Dehradun\r\nOfficers Training Academy, Chennai\r\nNational Defence Academy (NDA) Khadakwasla\r\nArmy Medical Corps (AMC) Center and School, Lucknow\r\nArmy Cadet College (ACC), Dehradun \r\nNational Defence College (NDC) New Delhi\r\nDefence Services Staff College (DSSC), Wellingto', 1, 1, 8, NULL, '2023-06-27 05:13:12', '2023-07-05 10:11:04'),
(62, 'This is test faq add functaionality?', 'This is the answer.', NULL, NULL, 5, NULL, '2023-07-05 04:53:07', '2023-07-05 04:53:07'),
(65, 'Redeem edited', 'Redeem this is edited', NULL, NULL, 4, NULL, '2023-07-05 06:08:32', '2023-07-05 06:08:32'),
(66, 'What is Verification and Validation in Software Testing?', 'testing: It is a static analysis technique. Here, testing is done without executing the code. Examples include – Reviews, Inspection, .\r\n\r\nValidation: It is a dynamic analysis technique where testing is done by executing the code. Examples include functional and non-functional testing techniques.\r\n\r\nIn the V model, the development and QA activities are done simultaneously. There is no discrete phase called Testing, rather testing starts right from the requirement phase.  The verification and validation activities go hand in hand.', NULL, NULL, 11, 3, '2023-07-06 08:35:25', '2023-07-06 09:24:27'),
(67, 'What is Verification and Validation i Software Testing?', 'Verification: It is a static analysis technique. Here, testing is done without executing the code. Examples include – Reviews, Inspection, and walkthrough.\r\n\r\nValidation: It is a dynamic analysis technique where testing is done by executing the code. Examples include functional and non-functional testing techniques.\r\n\r\nIn the V model, the development and QA activities are done simultaneously. There is no discrete phase called Testing, rather testing starts right from the requirement phase.  The verification and validation activities go hand in hand.', NULL, NULL, 9, NULL, '2023-07-06 09:09:00', '2023-07-06 09:09:00'),
(68, 'What is Verification and Validation n Software Testing?', 'Validation: It is a dynamic analysis technique where testing is done by executing the code. Examples include functional and non-functional testing techniques.\r\n\r\nIn the V model, the development and QA activities are done simultaneously. There is no discrete phase called Testing, rather testing starts right from the requirement phase.  The verification and validation activities go hand in hand.', NULL, NULL, 9, NULL, '2023-07-06 09:11:38', '2023-07-06 09:11:38'),
(69, 'What is coverage and what are the different types of coverage techniques?', 'The parameter used in software testing to describe the extent to which the source code is tested is known as coverage. There are three basic types of coverage techniques and they are:\r\n\r\nStatement coverage: It ensures that each line of source code has been executed and tested.\r\nDecision coverage: It assures that every decision (true/false) in the source code has been executed and tested.', NULL, NULL, 11, NULL, '2023-07-06 09:14:56', '2023-07-06 09:14:56');

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

--
-- Table structure for table `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) 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 `faq_categories`
--

INSERT INTO `faq_categories` (`id`, `title`, `created_at`, `updated_at`) VALUES
(2, 'First test', '2023-06-20 07:12:13', '2023-06-20 07:12:13'),
(4, 'Redeem', '2023-06-20 07:38:51', '2023-06-20 07:38:51'),
(5, 'videos', '2023-06-20 07:42:22', '2023-06-20 07:42:22'),
(6, 'Scan', '2023-06-22 05:38:30', '2023-06-22 05:38:30'),
(7, 'Wallet', '2023-06-22 05:38:55', '2023-06-22 05:38:55'),
(8, 'testing', '2023-06-22 05:40:02', '2023-06-22 05:40:02'),
(9, 'This is test', '2023-07-05 04:49:43', '2023-07-05 04:49:43'),
(10, 'this is agaib test', '2023-07-05 05:54:12', '2023-07-05 05:54:12'),
(11, 'testing1', '2023-07-06 08:32:59', '2023-07-06 08:32:59');

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2023_05_06_063652_create_books_table', 1),
(6, '2023_06_13_043623_create_verification_codes_table', 1),
(7, '2023_06_14_045952_add_new_fields_users', 1),
(8, '2023_06_14_050047_create_user_otps_table', 1),
(9, '2023_06_15_054827_add_new1_fields_users', 1),
(10, '2023_06_15_174117_create_sliders_table', 2),
(11, '2023_06_16_160855_create_products_table', 3),
(12, '2023_06_16_161035_create_categoties_table', 3),
(13, '2023_06_16_161055_create_sub_categoties_table', 3),
(14, '2023_06_19_113831_create_faqs_table', 4),
(15, '2023_06_19_114639_create_videos_table', 5),
(16, '2023_06_19_153614_create_privacy_policies_table', 6),
(17, '2023_06_19_153651_create_term_and_conditions_table', 7),
(18, '2023_06_19_153744_create_contact_us_table', 8),
(19, '2023_06_19_164556_create_contact_us_table', 9),
(20, '2023_06_20_113500_create_catalogs_table', 10),
(21, '2023_06_20_115724_create_video_categories_table', 11),
(22, '2023_06_20_115742_create_faq_categories_table', 12),
(23, '2023_06_20_152531_create_points_table', 13),
(24, '2023_06_20_152858_create_user_points_table', 14);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `user_type` int(11) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 1,
  `desc` text 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 `notifications`
--

INSERT INTO `notifications` (`id`, `title`, `user_type`, `image_path`, `status`, `desc`, `created_at`, `updated_at`) VALUES
(2, 'well this is now bestA title can be used to identify the work', 3, 'public/storage/imagess', 0, 'This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\\\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosityThis is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity', '2023-06-15 09:34:18', '2023-06-21 09:42:29'),
(16, 'well this is now bestA title can be used to identify the', 1, 'public/storage/imagess', 0, 'This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\\\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosityThis is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity', '2023-06-16 06:36:05', '2023-06-21 09:45:03'),
(20, 'second noti fication98', 1, 'public/storage/img', 0, 'This is the first dec for the app to user', '2023-06-19 07:21:59', '2023-06-19 07:21:59'),
(21, 'well this is now bestA title can be used to identify the work', 3, 'public/storage/imagess', 0, 'This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\\\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosityThis is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\\\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity\",This is meThe title of a book, or any other published text or work of art, is a name for the work which is usually chosen by the author. A title can be used to identify the work, to put it in context, to convey a minimal summary of its contents, and to pique the reader\'s curiosity', '2023-06-20 09:35:43', '2023-06-21 05:26:42'),
(22, 'second noti fication This is the first dec for the app to user', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 05:43:05', '2023-06-22 05:43:05'),
(23, 'second noti fication', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 05:43:19', '2023-06-22 05:43:19'),
(24, 'second noti fication 1', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 05:43:28', '2023-06-22 05:43:28'),
(25, 'second noti fication 12', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 05:43:33', '2023-06-22 05:43:33'),
(26, 'second noti fication 13', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 08:36:25', '2023-06-22 08:36:25'),
(27, 'second noti fication 14', 3, 'public/storage/img', 0, 'This is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to userThis is the first dec for the app to user', '2023-06-22 12:11:36', '2023-06-22 12:11:36');

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

--
-- Table structure for table `points`
--

CREATE TABLE `points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `redeem_type` bigint(20) DEFAULT NULL COMMENT '0 => point aganist money, 1=> points aganist product ',
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `redeem_product_id` bigint(20) DEFAULT NULL,
  `product_number` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `scan_date` varchar(255) DEFAULT NULL,
  `scan_time` varchar(255) DEFAULT NULL,
  `point` bigint(20) UNSIGNED DEFAULT NULL,
  `status` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `upi_id` varchar(255) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT NULL,
  `account_no` varchar(50) DEFAULT NULL,
  `account_ifsc` varchar(50) DEFAULT NULL,
  `payment_type` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_status` bigint(20) UNSIGNED DEFAULT 0,
  `redeem` int(11) UNSIGNED 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 `points`
--

INSERT INTO `points` (`id`, `user_id`, `redeem_type`, `product_id`, `redeem_product_id`, `product_number`, `address`, `scan_date`, `scan_time`, `point`, `status`, `upi_id`, `account_name`, `account_no`, `account_ifsc`, `payment_type`, `payment_status`, `redeem`, `created_at`, `updated_at`) VALUES
(1, 2, NULL, 22, 0, '000000000000025', 'civil lines', '2023-06-23', '09:45:23am', 101, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:15:23', '2023-06-23 04:15:23'),
(2, 2, NULL, 22, 0, '000000000000028', '11 11 302034', '2023-06-23', '09:54:56am', 101, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:24:56', '2023-06-23 04:24:56'),
(3, 2, NULL, 21, 0, '000000000000015', '11 11 302034', '2023-06-23', '09:55:42am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:25:42', '2023-06-23 04:25:42'),
(4, 2, NULL, 20, 0, '00000000000005', 'civil lines jaipur', '2023-06-23', '09:59:26am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:29:26', '2023-06-23 04:29:26'),
(5, 2, NULL, 20, 0, '000000000000005', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '10:01:18am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:31:18', '2023-06-23 04:31:18'),
(6, 2, NULL, 23, 0, '000000000000036', '11 11 302034', '2023-06-23', '10:08:53am', 10, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:38:53', '2023-06-23 04:38:53'),
(7, 2, NULL, 20, 0, '000000000000009', '11 11 302034', '2023-06-23', '10:22:48am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:52:48', '2023-06-23 04:52:48'),
(8, 2, NULL, 20, 0, '000000000000004', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '10:23:56am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:53:56', '2023-06-23 04:53:56'),
(9, 2, NULL, 20, 0, '000000000000008', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '10:24:24am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:54:24', '2023-06-23 04:54:24'),
(10, 2, NULL, 20, 0, '000000000000006', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '10:26:06am', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 04:56:06', '2023-06-23 04:56:06'),
(11, 2, NULL, 23, 0, '000000000000033', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '10:30:12am', 10, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 05:00:12', '2023-06-23 05:00:12'),
(12, 2, NULL, 24, 0, '000000000000045', '11 11 302034', '2023-06-23', '11:54:13am', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:24:13', '2023-06-23 06:24:13'),
(13, 2, NULL, 24, 0, '00000000000045', 'civil lines jaipur sector 10 pin code 203010', '2023-06-23', '11:58:17am', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:28:17', '2023-06-23 06:28:17'),
(14, 2, NULL, 24, 0, '000000000000046', 'WQ5H+8RH WQ5H+8RH 302006', '2023-06-23', '11:59:45am', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:29:45', '2023-06-23 06:29:45'),
(15, 2, NULL, 24, 0, '00000000000046', 'civil lines jaipur sector 10 pin code 203010 address testing', '2023-06-23', '12:00:43pm', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:30:43', '2023-06-23 06:30:43'),
(16, 2, NULL, 24, 0, '00000000000047', 'civil lines jaipur sector 10 pin code 203010  testing', '2023-06-23', '12:25:46pm', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:55:46', '2023-06-23 06:55:46'),
(17, 2, NULL, 24, 0, '000000000000047', 'Ibis Hotel 1st Floor 302006', '2023-06-23', '12:28:23pm', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 06:58:23', '2023-06-23 06:58:23'),
(18, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '12:31:33pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 07:01:33', '2023-06-23 07:01:33'),
(19, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '12:31:48pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 07:01:48', '2023-06-23 07:01:48'),
(20, 2, NULL, 24, 0, '000000000000049', '11 11 302034', '2023-06-23', '02:15:11pm', 80, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 08:45:11', '2023-06-23 08:45:11'),
(21, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '02:55:02pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:25:02', '2023-06-23 09:25:02'),
(22, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '02:55:31pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:25:31', '2023-06-23 09:25:31'),
(23, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '02:55:55pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:25:55', '2023-06-23 09:25:55'),
(24, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '02:56:24pm', 1, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:26:24', '2023-06-23 09:26:24'),
(25, 3, NULL, 20, 0, '000000000000003', 'jain gali', '2023-06-23', '02:58:03pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:28:03', '2023-06-23 09:28:03'),
(26, 1, NULL, 20, 0, '000000000000003', 'jain gali', '2023-06-23', '02:58:13pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-23 09:28:13', '2023-06-23 09:28:13'),
(27, 1, NULL, NULL, 0, NULL, 'civil lines', '2023-06-23', '02:58:27pm', 50, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:28:27', '2023-06-23 09:28:27'),
(28, 1, NULL, NULL, 0, NULL, 'civil lines', '2023-06-23', '03:01:18pm', 50, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:31:18', '2023-06-23 09:31:18'),
(29, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:01:18pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:31:18', '2023-06-23 09:31:18'),
(30, 1, NULL, NULL, 0, NULL, 'civil lines', '2023-06-23', '03:02:31pm', 10, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:32:31', '2023-06-23 09:32:31'),
(31, 1, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:03:37pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:33:37', '2023-06-23 09:33:37'),
(32, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:04:03pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:34:03', '2023-06-23 09:34:03'),
(33, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:10:27pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:40:27', '2023-06-23 09:40:27'),
(34, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:10:58pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:40:58', '2023-06-23 09:40:58'),
(35, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:11:26pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:41:26', '2023-06-23 09:41:26'),
(36, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:11:48pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:41:48', '2023-06-23 09:41:48'),
(37, 2, NULL, NULL, 0, NULL, 'jaipur', '2023-06-23', '03:13:07pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-23 09:43:07', '2023-06-23 09:43:07'),
(38, 3, NULL, 20, 0, '000000000000005', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '12:19:15pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 06:49:15', '2023-06-27 06:49:15'),
(39, 3, NULL, 21, 0, '000000000000018', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '12:21:29pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 06:51:29', '2023-06-27 06:51:29'),
(40, 3, NULL, 21, 0, '000000000000019', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '12:22:51pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 06:52:51', '2023-06-27 06:52:51'),
(41, 3, NULL, 20, 0, '00000000000004', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '12:32:42pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 07:02:42', '2023-06-27 07:02:42'),
(42, 3, NULL, 20, 0, '000000000000004', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '12:34:45pm', 130, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 07:04:45', '2023-06-27 07:04:45'),
(43, 36, NULL, 20, 0, '000000000000004', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '01:06:55pm', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 07:36:55', '2023-06-27 07:36:55'),
(44, 36, NULL, 21, 0, '000000000000016', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '01:12:20pm', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 07:42:20', '2023-06-27 07:42:20'),
(45, 36, NULL, NULL, 0, NULL, 'WQ5H+8RH WQ5H+8RH 302006', '2023-06-27', '01:14:22pm', 1, 0, '', '', '', '', NULL, 0, 1, '2023-06-27 07:44:22', '2023-06-27 07:44:22'),
(46, 4, NULL, 21, 0, '000000000000016', 'jaipur rajasthan ram nagar sector 10 pin code 225575', '2023-06-27', '02:05:01pm', 90, 0, '', '', '', '', NULL, NULL, 0, '2023-06-27 08:35:01', '2023-06-27 08:35:01'),
(47, 4, NULL, NULL, 0, NULL, '11 11 302034', '2023-06-27', '05:51:25pm', 5, 0, '', '', '', '', NULL, 0, 1, '2023-06-27 12:21:25', '2023-06-27 12:21:25'),
(48, 39, NULL, 20, 0, '000000000000005', 'WQ5H+7R4 WQ5H+7R4 302006', '2023-06-30', '12:27:30pm', 100, 0, '', '', '', '', NULL, NULL, 0, '2023-06-30 06:57:30', '2023-06-30 06:57:30'),
(49, 39, NULL, NULL, 0, NULL, '11 11 302034', '2023-06-30', '12:30:00pm', 100, 0, '', '', '', '', NULL, 0, 1, '2023-06-30 07:00:00', '2023-06-30 07:00:00'),
(50, 36, NULL, NULL, 0, NULL, '11 11 302034', '2023-07-01', '11:14:12am', 1, 0, '', '', '', '', NULL, 0, 1, '2023-07-01 05:44:12', '2023-07-01 05:44:12'),
(51, 46, NULL, 20, 0, '000000000000005', 'WQ5H+7R4 WQ5H+7R4 302006', '2023-07-06', '10:24:13am', 100, 0, '', '', '', '', NULL, 0, 0, '2023-07-06 04:54:13', '2023-07-06 04:54:13'),
(52, 41, NULL, 20, 0, '000000000000005', 'WQ5H+7R4 WQ5H+7R4 302006', '2023-07-06', '10:25:15am', 100, 0, '', '', '', '', NULL, 0, 0, '2023-07-06 04:55:15', '2023-07-06 04:55:15'),
(53, 3, NULL, 20, NULL, '000000000000003', 'jain gali', '2023-07-06', '04:43:19pm', 130, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, '2023-07-06 11:13:19', '2023-07-06 11:13:19'),
(54, 3, NULL, 20, NULL, '000000000000003', 'jain gali', '2023-07-06', '04:46:06pm', 130, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, '2023-07-06 11:16:06', '2023-07-06 11:16:06'),
(55, 3, NULL, 20, NULL, '000000000000003', 'jain gali', '2023-07-06', '04:46:56pm', 130, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, '2023-07-06 11:16:56', '2023-07-06 11:16:56'),
(56, 40, NULL, 21, NULL, '000000000000013', 'jain gali', '2023-07-06', '04:56:32pm', 110, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, '2023-07-06 11:26:32', '2023-07-06 11:26:32'),
(57, 41, NULL, NULL, NULL, NULL, 'civil', '2023-07-06', '05:10:39pm', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, 1, '2023-07-06 11:40:39', '2023-07-06 11:40:39'),
(58, 41, NULL, NULL, NULL, NULL, 'civil', '2023-07-06', '05:15:16pm', 1, 0, NULL, NULL, NULL, NULL, NULL, 0, 1, '2023-07-06 11:45:16', '2023-07-06 11:45:16'),
(59, 40, NULL, 21, NULL, '000000000000014', 'jain gali', '2023-07-06', '05:15:59pm', 110, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, '2023-07-06 11:45:59', '2023-07-06 11:45:59'),
(60, 41, 0, NULL, NULL, NULL, 'civil', '2023-07-06', '05:20:52pm', 1, 0, NULL, 'abcd', '152758', 'fgg', NULL, 0, 1, '2023-07-06 11:50:52', '2023-07-06 11:50:52'),
(61, 41, 0, NULL, NULL, NULL, 'civil', '2023-07-06', '05:24:31pm', 1, 0, 'abbb', NULL, NULL, NULL, NULL, 0, 1, '2023-07-06 11:54:31', '2023-07-06 11:54:31');

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

--
-- Table structure for table `privacy_policies`
--

CREATE TABLE `privacy_policies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `desc` text 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 `privacy_policies`
--

INSERT INTO `privacy_policies` (`id`, `title`, `desc`, `created_at`, `updated_at`) VALUES
(1, 'HGHG is updated privacy jaii Our values reflect', '<pre class=\"ql-syntax\" spellcheck=\"false\">Our values reflect our pse, our priorities and the way in which we conduct ourselves. They define what it means to work at Murphy, regardless of where we work or what we do.\\nOne family, one team, one murphy - We work collaboratively to provide a seamless, integrated service to our clients. \\n\\nAlways deliver - Our ‘can do’ attitude means that we aspire to deliver all our projects on time, on budget and to a high quality. \\n\\nIntegrity &amp; respect - We conduct business in a transparent, honest and professional manner. We act with integrity and are trusted by all our stakeholders. \\n\\nNever harm - We protect people, the environment and communities, no matter where we are or what we are doing. \\n\\nContinually improve - Innovation is integral to our success and we look to make improvements in all aspects of our work. We continuously strive to improve.    \r\n   Our values reflect our purpose, our priorities and the way in which we conduct ourselves.This is updated privacy policy desc jaii                                     Our values reflect our purpose, our priorities and the way in which we conduct ourselves. \r\nThey define what it means to work at Murphy, regardless of where we work or what we do.\r\n\r\n\\nOne family, one team, one murphy - We work collaboratively to provide a seamless, integrated service to our clients. \\n\\nAlways deliver - Our ‘can do’ attitude means that we aspire to deliver all our projects on time, on budget and to a high quality. \\n\\nIntegrity &amp; respect - We conduct business in a transparent, honest and professional manner. We act with integrity and are trusted by all our stakeholders. \\n\\nNever harm - We protect people, the environment and communities, no matter where we are or what we are doing. \\n\\nContinually improve - Innovation is integral to our success and we look to make improvements in all aspects of our work. We continuously strive to improve.  \r\n    \r\n Our values reflect our purpose, our priorities and the way in which we conduct ourselves. They define what it means to work at Murphy, regardless of where we work or what we do.\\nOne family, one team, one murphy - We work collaboratively to provide a seamless, integrated service to our clients. \\n\\nAlways deliver - Our ‘can do’ attitude means that we aspire to deliver all our projects on time, on budget and to a high quality. \\n\\nIntegrity &amp; respect - We conduct business in a transparent, honest and professional manner. We act with integrity and are trusted by all our stakeholders. \\n\\nNever harm - We protect people, the environment and communities, no matter where we are or what we are doing. \\n\\nContinually improve - Innovation is integral to our success and we look to make improvements in all aspects of our work. We continuously strive to improve.\r\n</pre>', NULL, '2023-06-29 12:24:20');

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sku` bigint(20) DEFAULT NULL,
  `range_for` bigint(15) UNSIGNED ZEROFILL DEFAULT NULL,
  `range_to` bigint(15) UNSIGNED ZEROFILL DEFAULT NULL,
  `dealer_point` bigint(20) DEFAULT NULL,
  `retailer_point` bigint(20) DEFAULT NULL,
  `electrician_point` bigint(20) DEFAULT NULL,
  `distributor_point` bigint(20) DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  `subcategory` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT 1,
  `image_path` varchar(255) DEFAULT NULL,
  `file` varchar(255) 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 `products`
--

INSERT INTO `products` (`id`, `name`, `sku`, `range_for`, `range_to`, `dealer_point`, `retailer_point`, `electrician_point`, `distributor_point`, `category`, `subcategory`, `status`, `image_path`, `file`, `created_at`, `updated_at`) VALUES
(20, 'product1to10', 25, 000000000000001, 000000000000010, 130, 110, 100, 120, 5, 8, 1, 'product/1688451619.png', 'E:\\xampp\\tmp\\php6BDE.tmp', '2023-06-22 10:45:37', '2023-07-04 06:20:19'),
(21, 'product10to20', 26, 000000000000011, 000000000000020, 130, 110, 100, 90, 2, 2, 1, 'product/1688460324.png', 'E:\\xampp\\tmp\\php415F.tmp', '2023-06-22 10:48:41', '2023-07-04 08:46:48'),
(22, 'product21to30', 27, 000000000000021, 000000000000030, 130, 110, 101, 90, 2, 2, 1, 'product/1688460340.png', 'E:\\xampp\\tmp\\php7EA8.tmp', '2023-06-22 10:50:36', '2023-07-04 08:46:41'),
(23, 'product31to40', 28, 000000000000031, 000000000000040, 140, 110, 10, 90, 2, 2, 1, 'product/1688460352.png', 'E:\\xampp\\tmp\\phpAE15.tmp', '2023-06-22 10:52:01', '2023-07-04 08:46:34'),
(24, 'testing test', 4, 000000000000041, 000000000000050, 50, 705, 80, 100, 4, 2, 1, 'product/1688451312.png', 'E:\\xampp\\tmp\\phpBF26.tmp', '2023-06-23 06:23:23', '2023-07-04 08:46:13');

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `profile_img` varchar(255) DEFAULT NULL,
  `aadhar` varchar(255) DEFAULT NULL,
  `pan` varchar(255) DEFAULT NULL,
  `aadhar_img` varchar(255) DEFAULT NULL,
  `pan_img` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `geolocation` text DEFAULT NULL,
  `refcode` varchar(50) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `device_model` varchar(255) DEFAULT NULL,
  `device_plateform` varchar(255) DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `lat` varchar(255) DEFAULT NULL,
  `long` varchar(255) DEFAULT NULL,
  `app_version` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `update_user` varchar(255) DEFAULT NULL,
  `update_date` varchar(255) DEFAULT NULL,
  `update_reason` varchar(255) DEFAULT NULL,
  `register_by_id` int(11) DEFAULT NULL,
  `register_by_name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `name`, `dob`, `profile_img`, `aadhar`, `pan`, `aadhar_img`, `pan_img`, `city`, `geolocation`, `refcode`, `address`, `device_model`, `device_plateform`, `device_id`, `lat`, `long`, `app_version`, `created_at`, `updated_at`, `update_user`, `update_date`, `update_reason`, `register_by_id`, `register_by_name`) VALUES
(1, 1, 'anish', 'fgfg', 'profile/1687174970.jpg', 'fdgdfgfdgdg', 'dfgdfgfdgdfg', 'profile/1687174529.png', 'dfgfdgdfg', 'kota', NULL, NULL, 'Jagdish ka nohra', '', '', '', '', '', '', '2023-06-15 09:22:13', '2023-07-06 06:28:14', 'abxd', '2023-06-27', 'okay ggg vdgdfhcdh nxsgn dgcvv essential', NULL, NULL),
(2, 2, 'jitendra3', 'fgfg', 'dfgdfgfgfdg', 'fdgdfgfdgdg', 'dfgdfgfdgdfg', 'fdgdfg', 'dfgfdgdfg', 'jaipur', NULL, NULL, 'civil lines 108', '', '', '', '', '', '', '2023-06-15 09:24:23', '2023-06-23 07:33:34', 'anish', '2023-06-23', 'Tu kam acha nahi kar rahan', NULL, NULL),
(3, 3, 'abcd', 'fgfgedob', 'dfgdfgfgf', 'fdgdfgddsaa', 'dfgdfgfdg', 'fdgd', 'dfgfdgd', 'jaipur', NULL, NULL, 'civil lines 108', '', '', '', '', '', '', '2023-06-15 11:44:33', '2023-06-21 11:06:17', 'jitendra3', '2023-06-21', 'Tu kam acha nahi kar rahan', NULL, NULL),
(4, 4, 'abxd', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, '3456', 'Jaipur', 'EB2101', 'Android', 'RKQ1.211119.001', '26.9082215', '75.7796441', '1.0.0', '2023-06-15 11:47:17', '2023-06-21 11:11:57', 'jitendra3', '2023-06-21', 'ok', NULL, NULL),
(5, 5, 'abcd', NULL, NULL, NULL, NULL, NULL, NULL, 'hhh', NULL, 'bb', 'gh', 'EB2101', 'Android', 'RKQ1.211119.001', '26.9082235', '75.7796455', '1.0.0', '2023-06-15 11:50:46', '2023-06-21 11:37:56', 'jitendra3', '2023-06-21', 'ok', NULL, NULL),
(6, 6, 'h', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, '345', 'Jaipur', 'EB2101', 'Android', 'RKQ1.211119.001', '26.908231', '75.7796587', '1.0.0', '2023-06-15 11:55:50', '2023-06-15 11:55:50', NULL, NULL, NULL, NULL, NULL),
(7, 7, 'abcd', NULL, NULL, NULL, NULL, NULL, NULL, 'jaipur', NULL, NULL, 'civil lines 108', '', '', '', '', '', '', '2023-06-15 12:02:31', '2023-06-27 12:26:08', 'abxd', '2023-06-27', 'only for testing', NULL, NULL),
(8, 8, 'abcd', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, '456', 'Jai', 'EB2101', 'Android', 'RKQ1.211119.001', '26.9082209', '75.7796463', '1.0.0', '2023-06-15 12:12:08', '2023-06-15 12:12:08', NULL, NULL, NULL, NULL, NULL),
(9, 9, 'anish', NULL, NULL, NULL, NULL, NULL, NULL, 'kota', NULL, NULL, 'Jagdish ka nohra', '', '', '', '', '', '', '2023-06-17 06:43:56', '2023-06-17 06:43:56', NULL, NULL, NULL, NULL, NULL),
(10, 10, 'jitendrakumar', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, 'hhh', 'civil lines', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082236', '75.779634', '1.0.0', '2023-06-17 07:08:43', '2023-06-23 09:02:55', 'jitendrakumar', '2023-06-23', 'this is for testing', NULL, NULL),
(11, 11, 'ghh', NULL, NULL, NULL, NULL, NULL, NULL, 'hgf', NULL, 'कि', 'dghh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082217', '75.7796531', '1.0.0', '2023-06-17 07:10:22', '2023-06-17 07:10:22', NULL, NULL, NULL, NULL, NULL),
(12, 12, 'jitendrakumar', NULL, NULL, NULL, NULL, NULL, NULL, 'gh', NULL, 'gh', 'ggg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082299', '75.7796357', '1.0.0', '2023-06-17 07:30:34', '2023-06-23 09:04:43', 'jitendrakumar', '2023-06-23', 'testing', NULL, NULL),
(13, 13, 'mm', NULL, NULL, NULL, NULL, NULL, NULL, 'fhh', NULL, 'gyu', 'xgh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082185', '75.7796508', '1.0.0', '2023-06-17 07:34:22', '2023-06-17 07:34:22', NULL, NULL, NULL, NULL, NULL),
(14, 14, 'hh', NULL, NULL, NULL, NULL, NULL, NULL, 'fgh', NULL, 'cvb', 'cvg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082205', '75.7796495', '1.0.0', '2023-06-17 07:38:20', '2023-06-27 08:30:09', 'abxd', '2023-06-27', 'okay', NULL, NULL),
(15, 15, 'fg', NULL, NULL, NULL, NULL, NULL, NULL, 'fhh', NULL, 'dgh', 'fhh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082224', '75.7796464', '1.0.0', '2023-06-17 07:39:31', '2023-06-27 08:46:37', 'abcd', '2023-06-27', 'dgff ddg from my side to side by side and side effects and I will be there for', NULL, NULL),
(16, 16, 'hh', NULL, NULL, NULL, NULL, NULL, NULL, 'gg', NULL, 'ghh', 'ghh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908225', '75.7796348', '1.0.0', '2023-06-17 07:42:18', '2023-06-23 09:08:57', 'hh', '2023-06-23', 'testing', NULL, NULL),
(17, 17, 'hh', NULL, NULL, NULL, NULL, NULL, NULL, 'vvv', NULL, 'hhh', 'vhv', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082262', '75.779657', '1.0.0', '2023-06-17 07:48:37', '2023-06-23 09:09:15', 'hh', '2023-06-23', 'testing', NULL, NULL),
(18, 18, 'gdhd', NULL, NULL, NULL, NULL, NULL, NULL, 'jj', NULL, 'hh', 'hh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082292', '75.779653', '1.0.0', '2023-06-17 08:35:45', '2023-06-17 08:35:45', NULL, NULL, NULL, NULL, NULL),
(19, 19, 'jitendrakumarer', NULL, NULL, NULL, NULL, NULL, NULL, 'ff', NULL, 'fg', 'ff', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908236', '75.7796454', '1.0.0', '2023-06-17 08:45:58', '2023-06-17 08:45:58', NULL, NULL, NULL, NULL, NULL),
(20, 20, 'jitendrakumarer', NULL, NULL, NULL, NULL, NULL, NULL, 'ff', NULL, 'fg', 'ff', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908236', '75.7796454', '1.0.0', '2023-06-17 08:47:08', '2023-06-17 08:47:08', NULL, NULL, NULL, NULL, NULL),
(21, 21, 'gh', NULL, NULL, NULL, NULL, NULL, NULL, 'fg', NULL, 'gg', 'vg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082219', '75.779655', '1.0.0', '2023-06-17 08:49:20', '2023-06-17 08:49:20', NULL, NULL, NULL, NULL, NULL),
(22, 22, 'ff', NULL, NULL, NULL, NULL, NULL, NULL, 'bbh', NULL, 'hhh', 'hnn', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908221', '75.7796519', '1.0.0', '2023-06-17 08:53:57', '2023-06-17 08:53:57', NULL, NULL, NULL, NULL, NULL),
(23, 23, 'frf', NULL, NULL, NULL, NULL, NULL, NULL, 'fg', NULL, 'f GN', 'fg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082496', '75.7796582', '1.0.0', '2023-06-17 09:10:40', '2023-06-27 08:49:08', 'abcd', '2023-06-27', 'dfg to meet me at home and home 🏠 to', NULL, NULL),
(24, 24, 'ff', NULL, NULL, NULL, NULL, NULL, NULL, 'fgg', NULL, 'ffg', 'ggg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082308', '75.7796697', '1.0.0', '2023-06-17 09:13:56', '2023-06-17 09:13:56', NULL, NULL, NULL, NULL, NULL),
(25, 25, 'ss', NULL, NULL, NULL, NULL, NULL, NULL, 'dd', NULL, 'dhsh', 'ddn', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082109', '75.77967', '1.0.0', '2023-06-17 09:50:28', '2023-06-17 09:50:28', NULL, NULL, NULL, NULL, NULL),
(26, 26, 'dd', NULL, NULL, NULL, NULL, NULL, NULL, 'ff', NULL, 'dd', 'xd', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082211', '75.7796396', '1.0.0', '2023-06-17 10:29:28', '2023-06-17 10:29:28', NULL, NULL, NULL, NULL, NULL),
(27, 27, 'fff', NULL, NULL, NULL, NULL, NULL, NULL, 'gg', NULL, 'gh', 'hh', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082188', '75.7796598', '1.0.0', '2023-06-19 05:27:27', '2023-06-19 05:27:27', NULL, NULL, NULL, NULL, NULL),
(28, 28, 'anish', NULL, NULL, NULL, NULL, NULL, NULL, 'kota', NULL, NULL, 'Jagdish ka nohra', '', '', '', '', '', '', '2023-06-19 05:56:08', '2023-06-19 05:56:08', NULL, NULL, NULL, NULL, NULL),
(29, 29, 'df', NULL, NULL, NULL, NULL, NULL, NULL, 'ccg', NULL, 'df', 'fgg', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908206', '75.779663', '1.0.0', '2023-06-19 05:58:58', '2023-06-19 05:58:58', NULL, NULL, NULL, NULL, NULL),
(30, 30, 'dd', NULL, NULL, NULL, NULL, NULL, NULL, 'g', NULL, 'ff', 'ggff', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082386', '75.7796705', '1.0.0', '2023-06-19 09:32:11', '2023-06-19 09:32:11', NULL, NULL, NULL, NULL, NULL),
(31, 31, 'jai', NULL, NULL, NULL, NULL, NULL, NULL, 'ghg', NULL, 'hhh', 'bbj', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082188', '75.7796441', '1.0.0', '2023-06-19 11:52:08', '2023-06-19 11:52:08', NULL, NULL, NULL, NULL, NULL),
(32, 32, 'jaii', NULL, NULL, NULL, NULL, NULL, NULL, 'ddd', NULL, 'gggg', 'ddddd', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082253', '75.7796755', '1.0.0', '2023-06-19 12:15:03', '2023-06-19 12:15:03', NULL, NULL, NULL, NULL, NULL),
(33, 33, 'jai', NULL, NULL, NULL, NULL, NULL, NULL, 'kota', NULL, NULL, 'Jagdish ka nohra', '', '', '', '', '', '', '2023-06-20 05:28:24', '2023-06-20 05:28:24', NULL, NULL, NULL, NULL, NULL),
(34, 34, 'jaiii', NULL, NULL, NULL, NULL, NULL, NULL, 'heh', NULL, 'djhs', 'hdjs', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082087', '75.7796529', '1.0.0', '2023-06-20 08:37:33', '2023-06-20 08:37:33', NULL, NULL, NULL, NULL, NULL),
(35, 35, 'Testing', NULL, NULL, NULL, NULL, NULL, NULL, 'jaipur', NULL, '12', 'civil lines 108', '', '', '', '', '', '', '2023-06-27 04:07:48', '2023-06-27 04:07:48', NULL, NULL, NULL, NULL, NULL),
(36, 36, 'testing person', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, '12345', 'civil Thailand Jaipur', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082128', '75.779649', '1.0.0', '2023-06-27 04:16:33', '2023-06-27 04:16:33', NULL, NULL, NULL, NULL, NULL),
(37, 37, 'Sanjay Kumar', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur Rajasthan', NULL, 'hhh', 'Jaipur Rajasthan Ram Nagar sector 10 pin code 225565', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082233', '75.7796561', '1.0.0', '2023-06-27 06:26:47', '2023-06-27 06:26:47', NULL, NULL, NULL, NULL, NULL),
(38, 38, 'ffddgxgg', NULL, NULL, NULL, NULL, NULL, NULL, 'jai', NULL, 'fgj', 'civil lines for kids dgfdgtn d type g and side effects', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9082102', '75.7796695', '1.0.0', '2023-06-27 08:54:45', '2023-06-27 08:54:45', NULL, NULL, NULL, NULL, NULL),
(39, 39, 'vivekt tester', NULL, NULL, NULL, NULL, NULL, NULL, 'Jaipur', NULL, '1123', '108 first floor geetanjali tower jaipur', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.908196', '75.779631', '1.0.0', '2023-06-30 06:40:02', '2023-06-30 06:40:02', NULL, NULL, NULL, NULL, NULL),
(40, 40, 'anusha Dubey', NULL, NULL, NULL, NULL, NULL, NULL, 'kota rajathan', NULL, NULL, 'Jagdish ka nohra', '', '', '', '', '', '', '2023-06-30 12:50:05', '2023-06-30 12:50:05', NULL, NULL, NULL, NULL, NULL),
(41, 41, 'Tester senior', NULL, NULL, NULL, NULL, NULL, NULL, 'jaipur', NULL, '304577', 'civil lines jaipur rajasthan', 'EB2101', 'Android', 'RKQ1.211119.001', '26.9082176', '75.779687', '1.0.0', '2023-07-01 06:08:14', '2023-07-01 06:08:14', NULL, NULL, NULL, NULL, NULL),
(42, 42, 'jaajjj', NULL, NULL, NULL, NULL, NULL, NULL, 'dhswj h na ye to', NULL, 'dnnd', 'BD no no no problem sir please', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.9081964', '75.7796321', '1.0.0', '2023-07-01 06:26:46', '2023-07-01 06:26:46', NULL, NULL, NULL, NULL, NULL),
(43, 43, 'gg', NULL, NULL, NULL, NULL, NULL, NULL, 'jai', NULL, 'fg', 'hh', 'EB2101', 'Android', 'RKQ1.211119.001', '26.9082143', '75.7796637', '1.0.0', '2023-07-01 06:42:06', '2023-07-01 06:42:06', NULL, NULL, NULL, NULL, NULL),
(44, 44, 'gh', NULL, NULL, NULL, NULL, NULL, NULL, 'dcg', NULL, 'cc', 'cf', 'Infinix X6816C', 'Android', 'RP1A.201005.001', '26.906403', '75.77774', '1.0.0', '2023-07-01 06:48:05', '2023-07-01 06:48:05', NULL, NULL, NULL, NULL, NULL),
(45, 45, 'anish', NULL, NULL, NULL, NULL, NULL, NULL, 'jaipur', NULL, 'fdf', 'civil lines jaipur rajasthan', '', '', '', '', '', '', '2023-07-01 06:55:35', '2023-07-01 06:55:35', NULL, NULL, NULL, NULL, NULL),
(50, 50, 'jaipal', NULL, NULL, NULL, NULL, NULL, NULL, 'jaipur', NULL, NULL, 'civil lines jaipur rajasthan sector 10 pin code 283939', '', '', '', '', '', '', '2023-07-06 05:48:54', '2023-07-06 05:48:54', NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `video_link` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `status` bigint(20) DEFAULT 1,
  `order` bigint(20) 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 `sliders`
--

INSERT INTO `sliders` (`id`, `title`, `image_path`, `video_link`, `file`, `status`, `order`, `created_at`, `updated_at`) VALUES
(2, 'hello from new test', 'sliders/1688114163.png', 'https://laracasts.com/discuss/channels/laravel/call-to-a-member-function-extension-on-null', NULL, 1, 12, '2023-06-30 08:36:03', '2023-06-30 08:36:03'),
(3, 'Hi this is brand new testing', 'sliders/1688115293.jpg', 'https://laracasts.com/discuss/channels/laravel/call-to-a-member-function-extension-on-null', NULL, 1, 12, '2023-06-30 08:54:53', '2023-06-30 08:54:53');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `maincategory` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT 1,
  `image_path` varchar(255) DEFAULT NULL,
  `file` varchar(255) 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 `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `name`, `maincategory`, `status`, `image_path`, `file`, `created_at`, `updated_at`) VALUES
(8, 'thi is  TEST', 5, 1, 'subcategory/1688390419.jpg', NULL, '2023-07-03 13:20:19', '2023-07-03 13:20:19');

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

--
-- Table structure for table `term_and_conditions`
--

CREATE TABLE `term_and_conditions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `desc` text 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 `term_and_conditions`
--

INSERT INTO `term_and_conditions` (`id`, `title`, `desc`, `created_at`, `updated_at`) VALUES
(1, 'Thiis is updated', '<p>anish Dubey updated </p>', NULL, '2023-06-30 05:54:55');

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

--
-- Table structure for table `user_points`
--

CREATE TABLE `user_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `total_point` bigint(20) UNSIGNED 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 `user_points`
--

INSERT INTO `user_points` (`id`, `user_id`, `total_point`, `created_at`, `updated_at`) VALUES
(1, 2, 1469, '2023-06-23 04:15:23', '2023-06-23 09:43:07'),
(2, 3, 1170, '2023-06-23 09:28:03', '2023-07-06 11:16:56'),
(3, 1, 19, '2023-06-23 09:28:13', '2023-06-23 09:33:37'),
(4, 36, 198, '2023-06-27 07:36:55', '2023-07-01 05:44:12'),
(5, 4, 85, '2023-06-27 08:35:01', '2023-06-27 12:21:25'),
(6, 39, 0, '2023-06-30 06:57:30', '2023-06-30 07:00:00'),
(7, 46, 100, '2023-07-06 04:54:13', '2023-07-06 04:54:13'),
(8, 41, 96, '2023-07-06 04:55:15', '2023-07-06 11:54:31'),
(9, 40, 220, '2023-07-06 11:26:32', '2023-07-06 11:45:59');

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

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

CREATE TABLE `videos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `desc` text DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  `video_link` varchar(255) DEFAULT NULL,
  `video_path` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `user_type` bigint(20) DEFAULT NULL,
  `status` bigint(20) DEFAULT NULL,
  `order` bigint(20) 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 `videos`
--

INSERT INTO `videos` (`id`, `title`, `desc`, `category`, `video_link`, `video_path`, `file`, `user_type`, `status`, `order`, `created_at`, `updated_at`) VALUES
(1, 'video testing', 'Pexels Videos makes it easy to find free stock footage for your website, promo video or anything else. All videos are free for personal and', 4, 'https://www.pexels.com', 'video/1688550828.mp4', 'E:\\xampp\\tmp\\php9FD1.tmp', 2, 1, 2, '2023-06-19 10:06:46', '2023-07-05 10:06:47'),
(3, 'tttwiu', 'ykotkyprktkyrtooo', 6, 'rgu', 'dfg', '0', 3, 1, 2, '2023-06-19 10:10:55', '2023-07-05 09:58:12'),
(4, 'tttwiue', 'ykotkyprktkyrtooo', NULL, 'rgu', 'dfg', '0', 3, 1, NULL, '2023-06-19 10:12:12', '2023-06-19 10:12:12'),
(5, 't', 'ykotkyprktkyrtooo', NULL, 'rgu', 'dfg', '0', 3, NULL, NULL, '2023-06-19 10:13:16', '2023-06-19 10:13:16'),
(8, 'tttrws', 'ykotkyprktkyrtooo', 1, 'rgu', 'dfg', '0', 3, 1, 2, '2023-06-19 10:41:40', '2023-06-19 10:41:40'),
(9, 'tttrwsd', 'ykotkyprktkyrtooo', 1, 'rgu', 'dfg', '0', 3, 1, NULL, '2023-06-19 10:42:36', '2023-06-19 10:42:36'),
(11, 'fg', 'sdfdsfv', 3, 'uuhy', 'yuguyg', '0', 3, 1, 2, '2023-06-21 12:32:28', '2023-06-21 12:32:28'),
(12, 'fghynhjjjyh', 'sdfdsfv', 3, 'uuhy', 'yuguyg', '0', 3, 1, 2, '2023-06-21 12:34:08', '2023-06-21 12:34:08'),
(13, 'testingg', 'ddf', 1, 'df', 'sdfff', '0', 3, 5, 3, '2023-06-22 06:28:19', '2023-06-22 06:28:19'),
(14, 'testing', 'ddf', 1, 'df', 'sdfff', '0', 3, 5, 3, '2023-06-22 07:20:34', '2023-06-22 07:20:34'),
(15, 'testinggh', 'ddf', 4, 'df', 'sdfff', '0', 2, 4, 3, '2023-06-22 07:24:57', '2023-06-22 07:24:57'),
(19, 'Ram Siya ji() Adipurush | Prabhas | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://youtu.be/FxZwOL766iY', 'jj', '0', 4, 1, 1, '2023-06-27 06:12:09', '2023-06-27 06:12:09'),
(20, 'Ram Siya ji() Adipurush | Prabhas | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 06:14:03', '2023-06-27 06:14:03'),
(21, 'Ram Siya ji Adipurush | Prabhas | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 07:08:39', '2023-06-27 07:08:39'),
(22, 'Ram Siya  Adipurush | Prabhas | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 07:09:01', '2023-06-27 07:09:01'),
(23, 'Ram Siya  Adipurush | | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 07:09:08', '2023-06-27 07:09:08'),
(24, 'Ram Siya  Adipurush | | -Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 07:09:16', '2023-06-27 07:09:16'),
(25, 'Ram Siya  Adipurush Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 4, 1, 1, '2023-06-27 07:09:27', '2023-06-27 07:09:27'),
(26, 'Ram Siya Ram (Lyrical) Adipurush Prabhas | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 5, 1, 1, '2023-06-27 07:10:45', '2023-06-27 07:10:45'),
(27, 'Ram Siya Ram (Lyrical) Adipurush | Sachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 5, 1, 1, '2023-06-27 07:10:52', '2023-06-27 07:10:52'),
(28, 'Ram Siya Ram (Lyrical) AdipurushSachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 5, 1, 1, '2023-06-27 07:11:15', '2023-06-27 07:11:15'),
(29, 'Ram Ram (Lyrical) AdipurushSachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 5, 1, 1, '2023-06-27 07:11:25', '2023-06-27 07:11:25'),
(30, 'Ram (Lyrical) AdipurushSachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan K', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 5, 1, 1, '2023-06-27 07:11:35', '2023-06-27 07:11:35'),
(31, 'Ram (Lyrical) AdipurushSachet-Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 1, 1, 1, '2023-06-27 07:20:16', '2023-06-27 07:20:16'),
(32, 'Ram (Lyrical) -Parampara,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 1, 1, 1, '2023-06-27 07:20:52', '2023-06-27 07:20:52'),
(33, 'Ram (Lyrical) -,Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 1, 1, 1, '2023-06-27 07:21:01', '2023-06-27 07:21:01'),
(34, 'Ram (Lyrical) Manoj Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 1, 1, 1, '2023-06-27 07:21:11', '2023-06-27 07:21:11'),
(35, 'Ram (Lyrical) Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'jj', '0', 1, 1, 1, '2023-06-27 07:21:21', '2023-06-27 07:21:21'),
(36, 'Ram () Muntashir S |Om Raut | Bhushan', 's, placing emphasis on a fresh push for domestic defence equipment production. The Ministry of Defence has set a goal to reach a revenue of Rs 1.75 lakh crore in aerospace and defence goods and services by 2024 under the “Make in India” initiative. The Indian Army recently signed its first contract for Rs 96 crore with Anadron Systems Pvt Ltd under Make-II for Maneuverable', 3, 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', 'https://www.youtube.com/watch?v=FxZwOL766iY&feature=youtu.be', '0', 1, 1, 1, '2023-06-27 07:21:46', '2023-06-27 07:21:46'),
(37, 'This is first video added', 'I added this video for testing purpose', 4, 'https://endtest-videos.s3-us-west-2.amazonaws.com/documentation/endtest_data_driven_testing_csv.mp4', 'video/1688542215.mp4', NULL, 4, NULL, NULL, '2023-07-05 07:30:15', '2023-07-05 07:30:15'),
(38, 'This is test', 'This is tesing for me', 5, 'null', 'video/1688542534.mp4', NULL, 2, NULL, NULL, '2023-07-05 07:35:34', '2023-07-05 09:52:00');

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

--
-- Table structure for table `video_categories`
--

CREATE TABLE `video_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) 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 `video_categories`
--

INSERT INTO `video_categories` (`id`, `title`, `created_at`, `updated_at`) VALUES
(3, 'this is again tes', '2023-06-21 12:29:30', '2023-06-22 05:01:40'),
(4, 'First testjjk', '2023-06-21 12:34:54', '2023-06-21 12:34:54'),
(5, 'testing', '2023-06-22 06:25:13', '2023-06-22 06:25:13'),
(6, 'This is anish test', '2023-07-05 07:21:47', '2023-07-05 07:21:47');

--
-- Indexes for dumped tables
--

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

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

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

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

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

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

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

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

--
-- Indexes for table `points`
--
ALTER TABLE `points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `points` (`user_id`),
  ADD KEY `pointoproduct` (`product_id`);

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

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

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profile` (`user_id`);

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

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

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

--
-- Indexes for table `user_points`
--
ALTER TABLE `user_points`
  ADD PRIMARY KEY (`id`),
  ADD KEY `userpoints` (`user_id`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `points`
--
ALTER TABLE `points`
  ADD CONSTRAINT `pointoproduct` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`),
  ADD CONSTRAINT `points` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON UPDATE CASCADE;

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
  ADD CONSTRAINT `profile` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `user_points`
--
ALTER TABLE `user_points`
  ADD CONSTRAINT `userpoints` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);
COMMIT;

