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

START TRANSACTION;



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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `cat_title` varchar(225) DEFAULT NULL,
  `cat_slug` varchar(225) DEFAULT NULL,
  `cat_description` text DEFAULT NULL,
  `cat_image` varchar(555) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(4) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `parent_id`, `cat_title`, `cat_slug`, `cat_description`, `cat_image`, `created_at`, `updated_at`, `status`) VALUES
(35, NULL, 'Citrine', 'citrine', NULL, '1774169310_CitrineCluster.webp', '2026-03-22 08:48:30', '2026-03-22 08:48:30', 1),
(36, NULL, 'Rose Quartz', 'rose-quartz', NULL, '1774169358_Rose-Quartz-rock.jpg', '2026-03-22 08:49:18', '2026-03-22 08:49:18', 1),
(37, NULL, 'Chariot', 'chariot', NULL, '1774169388_Chariot_Bracelet.jpg', '2026-03-22 08:49:48', '2026-03-22 08:49:48', 1),
(38, NULL, 'Amethyst', 'amethyst', NULL, '1774173487_Amethyst.jpg', '2026-03-22 09:58:07', '2026-03-22 09:58:07', 1),
(39, NULL, 'Pyrite', 'pyrite', NULL, '1774173521_Pyrite.jpg', '2026-03-22 09:58:41', '2026-03-22 09:58:41', 1),
(40, NULL, 'Sulemani', 'sulemani', NULL, '1774173619_Amethyst_Pyrite_Sulemani_hakik.jpg', '2026-03-22 10:00:19', '2026-03-22 10:00:19', 1),
(41, NULL, 'Zodiac', 'zodiac', NULL, '1774173646_a-symbol-signifying-zodiac-signs.webp', '2026-03-22 10:00:46', '2026-03-22 10:00:46', 1),
(42, NULL, 'MBM Special', 'mbm-special', NULL, '1774173674_Logo_black.jpg', '2026-03-22 10:01:14', '2026-03-22 10:01:14', 1),
(43, NULL, 'Oracle', 'oracle', NULL, '1774173700_cards-banner-q3cvdbx4dte918sf8er5v7kk1g71hx3lkqx9e5vm68.jpg', '2026-03-22 10:01:40', '2026-03-22 10:01:40', 1),
(44, NULL, 'Tarot Guide', 'tarot-guide', NULL, '1774173747_mbm2.jpg', '2026-03-22 10:02:27', '2026-03-22 10:02:27', 1);

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

--
-- Table structure for table `gallery_images`
--

CREATE TABLE `gallery_images` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery_images`
--

INSERT INTO `gallery_images` (`id`, `image`, `created_at`) VALUES
(53, '1763969734_Head & Neck Surgery.png', '2025-11-24 07:35:34'),
(54, '1763969737_Endoscopic Sinus & Skull-Base Surgery.png', '2025-11-24 07:35:37'),
(55, '1763969740_Vocal Fold Surgery.png', '2025-11-24 07:35:40'),
(56, '1763969742_Rhinoplasty Surgery.png', '2025-11-24 07:35:42'),
(57, '1763969745_Endoscopic Micro Ear Surgery.png', '2025-11-24 07:35:45'),
(64, '1768632396_WhatsApp Image 2026-01-17 at 12.13.12 PM.jpeg', '2026-01-17 06:46:36'),
(65, '1768632403_WhatsApp Image 2026-01-17 at 12.12.41 PM (1).jpeg', '2026-01-17 06:46:43'),
(66, '1768632410_WhatsApp Image 2026-01-17 at 12.12.40 PM (2).jpeg', '2026-01-17 06:46:50'),
(67, '1768632416_WhatsApp Image 2026-01-17 at 12.12.40 PM (1).jpeg', '2026-01-17 06:46:56'),
(68, '1768632421_WhatsApp Image 2026-01-17 at 12.12.40 PM.jpeg', '2026-01-17 06:47:01'),
(69, '1768632426_WhatsApp Image 2026-01-17 at 12.12.12 PM.jpeg', '2026-01-17 06:47:06'),
(70, '1768632456_WhatsApp Image 2026-01-17 at 12.11.51 PM.jpeg', '2026-01-17 06:47:36'),
(71, '1768632464_WhatsApp Image 2026-01-17 at 12.11.50 PM (1).jpeg', '2026-01-17 06:47:44'),
(72, '1768632487_WhatsApp Image 2026-01-17 at 12.11.50 PM.jpeg', '2026-01-17 06:48:07'),
(73, '1768632507_WhatsApp Image 2026-01-17 at 12.13.14 PM.jpeg', '2026-01-17 06:48:27'),
(74, '1768632512_WhatsApp Image 2026-01-17 at 12.13.13 PM (3).jpeg', '2026-01-17 06:48:32'),
(75, '1768632517_WhatsApp Image 2026-01-17 at 12.13.13 PM (2).jpeg', '2026-01-17 06:48:37'),
(76, '1768632548_WhatsApp Image 2026-01-17 at 12.13.13 PM (1).jpeg', '2026-01-17 06:49:08'),
(77, '1768632558_WhatsApp Image 2026-01-17 at 12.13.13 PM.jpeg', '2026-01-17 06:49:18');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `pro_title` varchar(225) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `pro_material` varchar(555) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `pro_image` varchar(255) DEFAULT NULL,
  `short_description` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp(),
  `highlight` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `benefits` text DEFAULT NULL,
  `how_to_use` text DEFAULT NULL,
  `ideal_for` text DEFAULT NULL,
  `care` text DEFAULT NULL,
  `special_instruction` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `pro_title`, `slug`, `pro_material`, `price`, `sale_price`, `category_id`, `sub_category_id`, `pro_image`, `short_description`, `created_at`, `updated_at`, `highlight`, `description`, `benefits`, `how_to_use`, `ideal_for`, `care`, `special_instruction`) VALUES
(24, 'Rose Quartz Bracelet', 'rose-quartz-bracelet', NULL, 1999.00, 1599.00, 44, 0, '1774173957_Rose_Quartz_449c2ded-2fee-4ef7-bd5a-16d71eabdc63.webp', '<p>This Rose Quartz bracelet supports unconditional love and relationship harmony through the crystal&#39;s powerful healing vibrations and spiritual energy.<br />\r\n<br />\r\nThe stone&#39;s natural properties provide continuous support for your personal growth and emotional well-being. Perfect for anyone seeking unconditional love and relationship harmony, enhanced spiritual connection, or daily energetic support.<br />\r\n<br />\r\nWear consistently to maintain positive energy and experience the full benefits of this healing crystal combination.</p>\r\n', '2026-03-22 10:05:57', '2026-03-22 10:05:57', 'Shipping calculated at checkout.', '', '<p>Enhances self-love, compassion, and empathy<br />\r\n<br />\r\nSupports emotional healing and stress relief<br />\r\n<br />\r\nEncourages forgiveness and harmonious relationships<br />\r\n<br />\r\nPromotes calmness, inner peace, and balance<br />\r\n<br />\r\nAttracts love and positive energy into life</p>\r\n', '<p>Wear on your wrist to attract love and maintain emotional balance<br />\r\n<br />\r\nMeditate holding the bracelet to deepen self-love and forgiveness<br />\r\n<br />\r\nPlace near your bed or meditation space for calming and loving energy</p>\r\n', '<ul>\r\n	<li>Love &amp; Relationships</li>\r\n	<li>Emotional Healing</li>\r\n</ul>\r\n', '<p>Avoid harsh chemicals, perfumes, and prolonged sunlight exposure<br />\r\n<br />\r\nClean gently with a soft cloth or rinse briefly in lukewarm water<br />\r\n<br />\r\nRecharge under moonlight or on a clear quartz cluster</p>\r\n', '<p>Clean gently with a soft cloth or rinse briefly in lukewarm water</p>\r\n'),
(25, 'Rose Quartz Bracelet Copy', 'rose-quartz-bracelet-copy', NULL, 1999.00, 1599.00, 44, 0, '1774174320_1774173957_Rose_Quartz_449c2ded-2fee-4ef7-bd5a-16d71eabdc63.webp', '<p>This Rose Quartz bracelet supports unconditional love and relationship harmony through the crystal&#39;s powerful healing vibrations and spiritual energy.<br />\r\n<br />\r\nThe stone&#39;s natural properties provide continuous support for your personal growth and emotional well-being. Perfect for anyone seeking unconditional love and relationship harmony, enhanced spiritual connection, or daily energetic support.<br />\r\n<br />\r\nWear consistently to maintain positive energy and experience the full benefits of this healing crystal combination.</p>\r\n', '2026-03-22 10:12:00', '2026-03-22 10:12:00', 'Shipping calculated at checkout.', '', '<p>Enhances self-love, compassion, and empathy<br />\r\n<br />\r\nSupports emotional healing and stress relief<br />\r\n<br />\r\nEncourages forgiveness and harmonious relationships<br />\r\n<br />\r\nPromotes calmness, inner peace, and balance<br />\r\n<br />\r\nAttracts love and positive energy into life</p>\r\n', '<p>Wear on your wrist to attract love and maintain emotional balance<br />\r\n<br />\r\nMeditate holding the bracelet to deepen self-love and forgiveness<br />\r\n<br />\r\nPlace near your bed or meditation space for calming and loving energy</p>\r\n', '<ul>\r\n	<li>Love &amp; Relationships</li>\r\n	<li>Emotional Healing</li>\r\n</ul>\r\n', '<p>Avoid harsh chemicals, perfumes, and prolonged sunlight exposure<br />\r\n<br />\r\nClean gently with a soft cloth or rinse briefly in lukewarm water<br />\r\n<br />\r\nRecharge under moonlight or on a clear quartz cluster</p>\r\n', '<p>Clean gently with a soft cloth or rinse briefly in lukewarm water</p>\r\n'),
(26, 'Rose Quartz Bracelet Copy', 'rose-quartz-bracelet-copy', NULL, 1999.00, 1599.00, 44, 0, '1774174322_1774173957_Rose_Quartz_449c2ded-2fee-4ef7-bd5a-16d71eabdc63.webp', '<p>This Rose Quartz bracelet supports unconditional love and relationship harmony through the crystal&#39;s powerful healing vibrations and spiritual energy.<br />\r\n<br />\r\nThe stone&#39;s natural properties provide continuous support for your personal growth and emotional well-being. Perfect for anyone seeking unconditional love and relationship harmony, enhanced spiritual connection, or daily energetic support.<br />\r\n<br />\r\nWear consistently to maintain positive energy and experience the full benefits of this healing crystal combination.</p>\r\n', '2026-03-22 10:12:02', '2026-03-22 10:12:02', 'Shipping calculated at checkout.', '', '<p>Enhances self-love, compassion, and empathy<br />\r\n<br />\r\nSupports emotional healing and stress relief<br />\r\n<br />\r\nEncourages forgiveness and harmonious relationships<br />\r\n<br />\r\nPromotes calmness, inner peace, and balance<br />\r\n<br />\r\nAttracts love and positive energy into life</p>\r\n', '<p>Wear on your wrist to attract love and maintain emotional balance<br />\r\n<br />\r\nMeditate holding the bracelet to deepen self-love and forgiveness<br />\r\n<br />\r\nPlace near your bed or meditation space for calming and loving energy</p>\r\n', '<ul>\r\n	<li>Love &amp; Relationships</li>\r\n	<li>Emotional Healing</li>\r\n</ul>\r\n', '<p>Avoid harsh chemicals, perfumes, and prolonged sunlight exposure<br />\r\n<br />\r\nClean gently with a soft cloth or rinse briefly in lukewarm water<br />\r\n<br />\r\nRecharge under moonlight or on a clear quartz cluster</p>\r\n', '<p>Clean gently with a soft cloth or rinse briefly in lukewarm water</p>\r\n'),
(27, 'Rose Quartz Bracelet Copy', 'rose-quartz-bracelet-copy', NULL, 1999.00, 1599.00, 44, 0, '1774174324_1774173957_Rose_Quartz_449c2ded-2fee-4ef7-bd5a-16d71eabdc63.webp', '<p>This Rose Quartz bracelet supports unconditional love and relationship harmony through the crystal&#39;s powerful healing vibrations and spiritual energy.<br />\r\n<br />\r\nThe stone&#39;s natural properties provide continuous support for your personal growth and emotional well-being. Perfect for anyone seeking unconditional love and relationship harmony, enhanced spiritual connection, or daily energetic support.<br />\r\n<br />\r\nWear consistently to maintain positive energy and experience the full benefits of this healing crystal combination.</p>\r\n', '2026-03-22 10:12:04', '2026-03-22 10:12:04', 'Shipping calculated at checkout.', '', '<p>Enhances self-love, compassion, and empathy<br />\r\n<br />\r\nSupports emotional healing and stress relief<br />\r\n<br />\r\nEncourages forgiveness and harmonious relationships<br />\r\n<br />\r\nPromotes calmness, inner peace, and balance<br />\r\n<br />\r\nAttracts love and positive energy into life</p>\r\n', '<p>Wear on your wrist to attract love and maintain emotional balance<br />\r\n<br />\r\nMeditate holding the bracelet to deepen self-love and forgiveness<br />\r\n<br />\r\nPlace near your bed or meditation space for calming and loving energy</p>\r\n', '<ul>\r\n	<li>Love &amp; Relationships</li>\r\n	<li>Emotional Healing</li>\r\n</ul>\r\n', '<p>Avoid harsh chemicals, perfumes, and prolonged sunlight exposure<br />\r\n<br />\r\nClean gently with a soft cloth or rinse briefly in lukewarm water<br />\r\n<br />\r\nRecharge under moonlight or on a clear quartz cluster</p>\r\n', '<p>Clean gently with a soft cloth or rinse briefly in lukewarm water</p>\r\n'),
(28, 'Rose Quartz Bracelet Copy Copy', 'rose-quartz-bracelet-copy-copy', NULL, 1999.00, 1599.00, 44, 0, '1774182709_1774174324_1774173957_Rose_Quartz_449c2ded-2fee-4ef7-bd5a-16d71eabdc63.webp', '<p>This Rose Quartz bracelet supports unconditional love and relationship harmony through the crystal&#39;s powerful healing vibrations and spiritual energy.<br />\r\n<br />\r\nThe stone&#39;s natural properties provide continuous support for your personal growth and emotional well-being. Perfect for anyone seeking unconditional love and relationship harmony, enhanced spiritual connection, or daily energetic support.<br />\r\n<br />\r\nWear consistently to maintain positive energy and experience the full benefits of this healing crystal combination.</p>\r\n', '2026-03-22 12:31:49', '2026-03-22 12:31:49', 'Shipping calculated at checkout.', '', '<p>Enhances self-love, compassion, and empathy<br />\r\n<br />\r\nSupports emotional healing and stress relief<br />\r\n<br />\r\nEncourages forgiveness and harmonious relationships<br />\r\n<br />\r\nPromotes calmness, inner peace, and balance<br />\r\n<br />\r\nAttracts love and positive energy into life</p>\r\n', '<p>Wear on your wrist to attract love and maintain emotional balance<br />\r\n<br />\r\nMeditate holding the bracelet to deepen self-love and forgiveness<br />\r\n<br />\r\nPlace near your bed or meditation space for calming and loving energy</p>\r\n', '<ul>\r\n	<li>Love &amp; Relationships</li>\r\n	<li>Emotional Healing</li>\r\n</ul>\r\n', '<p>Avoid harsh chemicals, perfumes, and prolonged sunlight exposure<br />\r\n<br />\r\nClean gently with a soft cloth or rinse briefly in lukewarm water<br />\r\n<br />\r\nRecharge under moonlight or on a clear quartz cluster</p>\r\n', '<p>Clean gently with a soft cloth or rinse briefly in lukewarm water</p>\r\n');

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

--
-- Table structure for table `product_images`
--

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `image_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_images`
--

INSERT INTO `product_images` (`id`, `product_id`, `image_name`) VALUES
(23, 24, '1774173957_Rose_quartz.webp'),
(24, 24, '1774173957_2_2_99adf285-f040-435b-ad09-1895e96860e1.webp'),
(25, 25, '1774174320_1774173957_Rose_quartz.webp'),
(26, 25, '1774174320_1774173957_2_2_99adf285-f040-435b-ad09-1895e96860e1.webp'),
(27, 26, '1774174322_1774173957_Rose_quartz.webp'),
(28, 26, '1774174322_1774173957_2_2_99adf285-f040-435b-ad09-1895e96860e1.webp'),
(29, 27, '1774174324_1774173957_Rose_quartz.webp'),
(30, 27, '1774174324_1774173957_2_2_99adf285-f040-435b-ad09-1895e96860e1.webp'),
(31, 28, '1774182709_1774174324_1774173957_Rose_quartz.webp'),
(32, 28, '1774182709_1774174324_1774173957_2_2_99adf285-f040-435b-ad09-1895e96860e1.webp');

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

--
-- Table structure for table `product_reviews`
--

CREATE TABLE `product_reviews` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `review` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL,
  `title` varchar(225) DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `treatments`
--

CREATE TABLE `treatments` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `short_description` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `product_reviews`
--
ALTER TABLE `product_reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `product_images`
--
ALTER TABLE `product_images`
  ADD CONSTRAINT `product_images_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;
COMMIT;

