M-SCOR Tablets | Calcium, Vitamin D3 & K2 Bone Health Formula

-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 30, 2026 at 11:22 AM -- Server version: 11.4.10-MariaDB-cll-lve-log -- PHP Version: 8.3.30 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `iqraansari__store_new` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` int(10) UNSIGNED NOT NULL, `username` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `password` varchar(255) NOT NULL, `full_name` varchar(100) NOT NULL, `role` enum('super_admin','admin','manager') DEFAULT 'admin', `permissions` text DEFAULT NULL COMMENT 'JSON encoded permissions', `is_active` tinyint(1) DEFAULT 1, `last_login` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admins` -- INSERT INTO `admins` (`id`, `username`, `email`, `password`, `full_name`, `role`, `permissions`, `is_active`, `last_login`, `created_at`, `updated_at`) VALUES (1, 'admin', 'admin@hizenpharma.com', '$2y$10$Ud/3mociNd/wB4M4E.RPbO6/4kiI9H6Rd4YFlp2Hv9rI7vBBbRDDm', 'System Administrator', 'super_admin', NULL, 1, '2026-03-27 15:50:21', '2025-12-29 12:32:21', '2026-03-27 19:50:21'); -- -------------------------------------------------------- -- -- Table structure for table `blog_categories` -- CREATE TABLE `blog_categories` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `description` text DEFAULT NULL, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blog_categories` -- INSERT INTO `blog_categories` (`id`, `name`, `slug`, `description`, `is_active`, `created_at`) VALUES (1, 'Health Tips', 'health-tips', 'Health and wellness tips', 1, '2025-12-29 12:39:34'), (2, 'Skincare Guide', 'skincare-guide', 'Skincare routines and guides', 1, '2025-12-29 12:39:34'), (3, 'Product Reviews', 'product-reviews', 'Product reviews and recommendations', 1, '2025-12-29 12:39:34'), (4, 'Nutrition', 'nutrition', 'Nutrition and diet information', 1, '2025-12-29 12:39:34'); -- -------------------------------------------------------- -- -- Table structure for table `blog_posts` -- CREATE TABLE `blog_posts` ( `id` int(10) UNSIGNED NOT NULL, `category_id` int(10) UNSIGNED DEFAULT NULL, `author_id` int(10) UNSIGNED NOT NULL, `title` varchar(200) NOT NULL, `slug` varchar(200) NOT NULL DEFAULT '', `excerpt` text DEFAULT NULL, `content` longtext NOT NULL, `featured_image` varchar(255) DEFAULT NULL, `is_published` tinyint(1) DEFAULT 0, `published_at` datetime DEFAULT NULL, `meta_title` varchar(200) DEFAULT NULL, `meta_description` text DEFAULT NULL, `views` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blog_posts` -- INSERT INTO `blog_posts` (`id`, `category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `is_published`, `published_at`, `meta_title`, `meta_description`, `views`, `created_at`, `updated_at`) VALUES (1, 4, 1, 'a', 'a', 'a', '

', 'gallery/gallery_69a87713877e2.png', 1, NULL, '0', 'a', 0, '2026-01-04 07:19:17', '2026-03-04 18:17:05'); INSERT INTO `blog_posts` (`id`, `category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `is_published`, `published_at`, `meta_title`, `meta_description`, `views`, `created_at`, `updated_at`) VALUES (2, 1, 1, 'Best Supplements for Strong Bones', 'best-supplements-for-strong-bones', 'Best Supplements for Strong Bones\r\n\r\nAs we age, maintaining bone strength becomes increasingly important for an active and healthy life. Over time, the body’s natural ability to absorb and utilize essential minerals decreases, which may lead to weak bones, reduced mobility, and a higher risk of fractures. Poor dietary intake, limited sunlight exposure, and nutritional deficiencies can further affect bone health.\r\nThis is where bone-support supplements play an important role. Supplements containing', '

Bones require a continuous supply of minerals and vitamins to remain dense and resilient. Without proper nutritional support, the body may pull calcium from bones to maintain normal blood calcium levels, gradually weakening bone tissue over time.

Bone supplements help:

✔ Maintain bone mineral density

✔ Support healthy bone remodeling

✔ Improve mineral utilization

✔ Reduce nutritional deficiency risks

✔ Support joint movement and muscle function

The most effective bone-support formulas usually combine:

Calcium Carbonate

Vitamin D3

Vitamin K

These nutrients work together rather than individually.

1. Calcium Carbonate 🦴

Why Calcium Is Essential

Calcium is the primary mineral found in bones and teeth. Nearly 99% of the body\'s calcium is stored in the skeleton.

Without sufficient calcium intake, the body removes calcium from bones to support:

✔ Muscle contraction

✔ Heart rhythm

✔ Nerve transmission

✔ Blood clotting

This weakens bones over time.

According to the National Institutes of Health, adults generally require:

✔ 1000 mg daily for most adults

✔ 1200 mg daily for older adults

Importance of Calcium Carbonate

Calcium carbonate is widely used because:

✔ High elemental calcium content

✔ Supports bone mineralization

✔ Helps maintain skeletal hardness

✔ Cost-effective and widely available

Additional Benefit

It also supports:

✔ Muscle performance

✔ Daily movement

✔ Nerve stability

For people with low dairy intake or poor dietary calcium, supplementation may be particularly helpful.

2. Vitamin D3 ☀️

Why Vitamin D3 Is Critical

Vitamin D3 is essential because calcium cannot be properly absorbed without it.

Even if calcium intake is adequate, low vitamin D reduces calcium absorption significantly.

According to National Institute of Arthritis and Musculoskeletal and Skin Diseases:

Vitamin D helps:

✔ Increase intestinal calcium absorption

✔ Maintain muscle strength

✔ Reduce risk of osteomalacia

✔ Support bone mineral balance

Why Deficiency Is Common

Vitamin D deficiency is common because:

✔ Limited sunlight exposure

✔ Indoor lifestyle

✔ Aging skin produces less vitamin D

✔ Poor dietary intake

Daily Importance

Recommended daily intake:

✔ 600 IU for adults

✔ 800 IU after age 70

Additional Benefit

Vitamin D3 also helps support balance and muscle coordination, which indirectly reduces fall risk.

3. Vitamin K 🧬

Why Vitamin K Matters for Bones

Vitamin K plays a major role in activating proteins that direct calcium into bones.

Without adequate vitamin K:

✔ Calcium may not be efficiently incorporated into bone tissue

✔ Bone remodeling may be less effective

Recent research published in PubMed shows vitamin K supports activation of osteocalcin, a protein directly involved in bone strength.

Bone Functions of Vitamin K

✔ Supports calcium regulation

✔ Supports bone density maintenance

✔ Helps bone protein activation

✔ Supports long-term skeletal integrity

Why It Works Well with Vitamin D3

Vitamin D helps absorb calcium.

Vitamin K helps place calcium where it belongs.

This synergy is one reason many modern bone supplements combine both nutrients.

Additional Nutrients That Also Support Bone Health 🌿

Strong bones need more than only calcium.

Other supportive nutrients include:

Magnesium

Helps convert vitamin D into its active form and supports bone matrix strength.

Phosphorus

Essential part of bone mineral structure.

Zinc

Supports bone tissue repair.

Protein

Bone is partly made of protein matrix, not only minerals.

Lifestyle Factors That Improve Bone Strength 🚶☀️

Supplements work best when combined with healthy habits.

Daily Bone-Support Habits

✔ Walking

✔ Strength training

✔ Sunlight exposure

✔ Adequate hydration

✔ Balanced protein intake

✔ Reduced smoking

✔ Limited soft drinks excess

According to the International Osteoporosis Foundation, exercise remains one of the strongest non-supplement methods to preserve bone density.

Who Needs Bone Supplements Most? 💙

Bone-support supplements may benefit:

✔ Adults over 40

✔ Elderly individuals

✔ Women after menopause

✔ People with low dairy intake

✔ Individuals with limited sunlight exposure

✔ Sedentary individuals

✔ People with nutritional deficiencies

Benefits of Bone Health Supplements ✨

✔ Enhance bone density

✔ Support mineral absorption

✔ Maintain skeletal strength

✔ Improve mobility

✔ Support muscle function

✔ Help reduce nutritional gaps

✔ Support long-term wellness

Scientific Sources 📚

Main references used:

NIAMS Bone Health Guidelines

NIH Calcium Fact Sheet

International Osteoporosis Foundation

PubMed Bone Nutrition Review 2024

Conclusion 💙

Strong bones require continuous nutritional support throughout life.

The combination of:

✔ Calcium

✔ Vitamin D3

✔ Vitamin K

provides one of the most effective nutritional foundations for maintaining bone density, supporting mobility, and preserving skeletal strength over time.

Supplements are most effective when combined with:

✔ Balanced diet

✔ Physical activity

✔ Sunlight exposure

✔ Long term consistency

', 'gallery/gallery_69c635dcc1768.jpeg', 1, NULL, '0', 'Best Supplements for Strong Bones', 0, '2026-01-04 07:28:19', '2026-03-27 08:12:38'); INSERT INTO `blog_posts` (`id`, `category_id`, `author_id`, `title`, `slug`, `excerpt`, `content`, `featured_image`, `is_published`, `published_at`, `meta_title`, `meta_description`, `views`, `created_at`, `updated_at`) VALUES (4, 1, 1, 'aaaaaaaaa', 'aaaaaaaaa', 'aaaaaaaaaaaaa', '

aaaaaaaaaaaaaaaaaaaaaaaaa

', 'gallery/gallery_69c635dcc1768.jpeg', 1, NULL, 'aaaaaaaaaaaaaa', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 0, '2026-03-27 17:12:12', '2026-03-27 17:12:12'), (5, 4, 1, 'aaaaaaaaaaaaaaaaa', 'aaaaaaaaaaaaaaaaa', 'aaaaaaaaaaaa', '

qqqqqqqqqqqqq

', 'gallery/gallery_69c2a231f3d9f.png', 1, NULL, 'qqqqqqqqqqqqqqq', 'qqqqqqqqqqqqqq', 0, '2026-03-27 17:14:47', '2026-03-27 17:14:47'); -- -------------------------------------------------------- -- -- Table structure for table `cart` -- CREATE TABLE `cart` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `session_id` varchar(100) DEFAULT NULL COMMENT 'For guest users', `product_id` int(10) UNSIGNED NOT NULL, `quantity` int(11) DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cart` -- INSERT INTO `cart` (`id`, `user_id`, `session_id`, `product_id`, `quantity`, `created_at`, `updated_at`) VALUES (6, NULL, 'qcenhrds8o439pbcmsjqu59e6n', 5, 4, '2026-03-05 04:22:23', '2026-03-05 06:29:28'), (7, NULL, '66s38r7rbpvj05mg2q66ci0vme', 5, 1, '2026-03-05 12:04:27', '2026-03-05 12:04:27'), (9, NULL, 'jghfghiidi2m66514gdfvij0qf', 5, 1, '2026-03-06 08:31:34', '2026-03-06 08:31:34'), (10, NULL, 'jghfghiidi2m66514gdfvij0qf', 12, 0, '2026-03-06 08:31:35', '2026-03-06 08:31:35'), (12, NULL, 'kb1go8omknud7qa2mkmsgte7si', 17, 1, '2026-03-07 05:23:36', '2026-03-07 05:23:36'), (13, NULL, 'hfn96k0upjpacfjtrepdol8ge8', 12, 4, '2026-03-07 09:15:43', '2026-03-07 09:46:59'), (14, NULL, 'uqem1h61ip63aad90ai30sm7jh', 17, 3, '2026-03-07 11:20:53', '2026-03-07 11:22:05'), (18, NULL, '096bd5nak4eruum0j4fkh5fq99', 13, 2, '2026-03-07 18:53:27', '2026-03-07 18:53:27'), (19, NULL, '096bd5nak4eruum0j4fkh5fq99', 18, 2, '2026-03-07 18:53:34', '2026-03-07 18:53:34'), (20, NULL, '99f9sv7grpqdob5b0gu6h5a44q', 17, 1, '2026-03-08 14:58:41', '2026-03-08 14:58:41'), (21, NULL, 'cjbf20p5vjf743i373t66v81ni', 18, 1, '2026-03-08 15:17:15', '2026-03-08 15:17:15'), (22, NULL, 'oomod9psbd3q7j5dh4dbimuco2', 5, 1, '2026-03-08 17:17:08', '2026-03-08 17:17:08'), (23, NULL, '2iet68imdo831nd8pqse3vk289', 18, 1, '2026-03-08 17:17:12', '2026-03-08 17:17:12'), (24, NULL, '6ebqpdp05pto07kitco4ikcb06', 13, 1, '2026-03-08 17:17:14', '2026-03-08 17:17:14'), (25, NULL, 'bail3jkb2mdvga6jhgeu6j8ngu', 15, 1, '2026-03-08 17:17:15', '2026-03-08 17:17:15'), (26, NULL, 'pvccfdg5veboc3od96pjonrtrg', 12, 1, '2026-03-08 17:17:18', '2026-03-08 17:17:18'), (27, NULL, 'rphu3pqbbsdjibsm7c11nn3bvp', 14, 1, '2026-03-08 17:17:20', '2026-03-08 17:17:20'), (28, NULL, 'mk53lb29mc5kvln83smfdmio81', 16, 1, '2026-03-08 17:17:21', '2026-03-08 17:17:21'), (29, NULL, '1ve9vkh23j0b26qrdepv4q61k9', 17, 1, '2026-03-08 17:17:25', '2026-03-08 17:17:25'), (30, NULL, 'r5pm0dg9uhgqk5t7pvk22nkua4', 13, 1, '2026-03-08 17:19:20', '2026-03-08 17:19:20'), (31, NULL, 'nbvlfla07djagd60jd9qlhkhou', 15, 1, '2026-03-08 17:30:24', '2026-03-08 17:30:24'), (32, NULL, '42kg9a45qlied1i4qrh890vme5', 12, 1, '2026-03-08 17:41:49', '2026-03-08 17:41:49'), (33, NULL, 'f5kf97fq7cbiljsu2g9kea4h8l', 16, 1, '2026-03-08 18:12:22', '2026-03-08 18:12:22'), (34, NULL, 'bgjkmnursar4ags9em61tmrkd4', 5, 1, '2026-03-08 22:09:38', '2026-03-08 22:09:38'), (35, NULL, '4chuvdbi347bs4mdlatudfu8cu', 14, 1, '2026-03-09 06:47:44', '2026-03-09 06:47:44'), (36, NULL, '4chuvdbi347bs4mdlatudfu8cu', 15, 1, '2026-03-09 06:47:45', '2026-03-09 06:47:45'), (37, NULL, '4chuvdbi347bs4mdlatudfu8cu', 13, 1, '2026-03-09 06:47:45', '2026-03-09 06:47:45'), (38, NULL, '4chuvdbi347bs4mdlatudfu8cu', 18, 1, '2026-03-09 06:47:46', '2026-03-09 06:47:46'), (39, NULL, '4chuvdbi347bs4mdlatudfu8cu', 16, 1, '2026-03-09 06:47:46', '2026-03-09 06:47:46'), (40, NULL, '4chuvdbi347bs4mdlatudfu8cu', 17, 1, '2026-03-09 06:47:47', '2026-03-09 06:47:47'), (41, NULL, 'upeailubh8ral5l66dsndeq67p', 14, 1, '2026-03-10 22:53:11', '2026-03-10 22:53:11'), (42, NULL, '6598q00nh80vts4b2da0bjfr9k', 13, 1, '2026-03-11 03:28:44', '2026-03-11 03:28:44'), (43, NULL, 'tlfgfna7kqdr736lk73ac6rgnj', 16, 1, '2026-03-12 03:13:11', '2026-03-12 03:13:11'), (44, NULL, '2m5l9sscvrlpo9c0rfcee4l1j2', 14, 1, '2026-03-12 12:19:46', '2026-03-12 12:19:46'), (45, NULL, 'adb8101c6r1qehr1lflj2mivvc', 17, 1, '2026-03-12 14:34:07', '2026-03-12 14:34:07'), (46, NULL, 't237m66e7bbqgqf9kt7h57h7l4', 5, 1, '2026-03-12 16:01:04', '2026-03-12 16:01:04'), (47, NULL, 'n2bv2gscb70ebfhssqrp205vmk', 12, 1, '2026-03-12 16:02:52', '2026-03-12 16:02:52'), (48, NULL, 'upqjafs6stt4leb8dokkliki9b', 15, 1, '2026-03-12 17:08:48', '2026-03-12 17:08:48'), (49, NULL, 'mk9am5dajgggug0mmfe1bd0ivc', 18, 1, '2026-03-12 17:17:31', '2026-03-12 17:17:31'), (50, NULL, 'ih748niq5gvca6cmpbd0hj2cal', 13, 1, '2026-03-12 17:20:08', '2026-03-12 17:20:08'), (51, NULL, 'nb3087305nbndio338es2nv462', 16, 1, '2026-03-12 17:28:07', '2026-03-12 17:28:07'), (52, NULL, 'kn10v2iani8panqlu2fkf0so1s', 18, 1, '2026-03-12 18:01:16', '2026-03-12 18:01:16'), (53, NULL, 's4034pa3dg6focakibk6a5c8t1', 5, 1, '2026-03-12 18:13:11', '2026-03-12 18:13:11'), (54, NULL, 'potm3asrjm4r0ucm2h23ttnrs8', 12, 1, '2026-03-12 18:33:12', '2026-03-12 18:33:12'), (55, NULL, 'nuptq11kghv3dvpvg8f7mdj0k8', 14, 1, '2026-03-12 19:45:10', '2026-03-12 19:45:10'), (56, NULL, 'mhptjvf2cb25ubndemtp6k0ec5', 17, 1, '2026-03-12 20:20:58', '2026-03-12 20:20:58'), (58, NULL, 'mkmaviv348cntnj957v1kg8gdc', 13, 1, '2026-03-15 01:36:00', '2026-03-15 01:36:00'), (61, NULL, 'di9tvhape7ieiu2n458taioseo', 13, 1, '2026-03-20 11:07:21', '2026-03-20 11:07:21'), (62, NULL, 'hc105s85hdp23thua8gumnlpme', 18, 1, '2026-03-20 11:07:27', '2026-03-20 11:07:27'), (63, NULL, '2lau0jk1asf7f8jj2vvtvc24uj', 14, 1, '2026-03-20 11:07:27', '2026-03-20 11:07:27'), (64, NULL, 'q3c0sflpmeea84bovokcradgk4', 12, 1, '2026-03-20 11:07:29', '2026-03-20 11:07:29'), (65, NULL, '10heg86uihueme7m6cu2eiva6k', 5, 1, '2026-03-20 11:07:29', '2026-03-20 11:07:29'), (66, NULL, 'rtuqsqampv58l95msikmtrppid', 15, 1, '2026-03-20 11:07:31', '2026-03-20 11:07:31'), (67, NULL, 'pjdg2gfo28qfhjhneaief3j8qr', 17, 1, '2026-03-20 11:07:35', '2026-03-20 11:07:35'), (68, NULL, '0j9mbmkhh5n3pgd747dnl8346v', 16, 1, '2026-03-20 11:07:39', '2026-03-20 11:07:39'), (69, NULL, '1kfv9cohtlcnavn1mhnql3q75b', 13, 1, '2026-03-21 23:43:37', '2026-03-21 23:43:37'), (70, NULL, '8ufeqo8kre8q1viaq5crqf1pil', 12, 1, '2026-03-22 01:25:22', '2026-03-22 01:25:22'), (71, NULL, '9qjt8srjlj6h9ncde9dn21qet4', 5, 1, '2026-03-22 04:20:26', '2026-03-22 04:20:26'), (72, NULL, '7bdko6qh9pjpikf816dq0qqo2q', 17, 1, '2026-03-22 09:58:42', '2026-03-22 09:58:42'), (73, NULL, 'c4ckoaaddss7v2n5ik82riuull', 18, 1, '2026-03-22 10:57:15', '2026-03-22 10:57:15'), (74, NULL, 'ubtmctgdfkuuvan8pigu26eiam', 5, 1, '2026-03-22 11:13:28', '2026-03-22 11:13:28'), (75, NULL, '7r7de8rvnkka0uu2agbepbgg3v', 12, 1, '2026-03-22 11:13:32', '2026-03-22 11:13:32'), (76, NULL, 'oq0q39ngkaq0rvgtkngq3h3q2n', 13, 1, '2026-03-22 12:18:44', '2026-03-22 12:18:44'), (77, NULL, '3pp0c0hsb9o4274ed5cpeqmh1t', 18, 1, '2026-03-22 12:21:14', '2026-03-22 12:21:14'), (78, NULL, '7heftjfto2hsi5peaqoofd43db', 17, 1, '2026-03-22 12:21:19', '2026-03-22 12:21:19'), (79, NULL, 'bmjsjkkkpfqptdg0rfbr54lagv', 16, 1, '2026-03-22 12:21:24', '2026-03-22 12:21:24'), (80, NULL, 't49kpus5qdjs00q7i2gp4ttscb', 15, 1, '2026-03-22 12:21:29', '2026-03-22 12:21:29'), (81, NULL, 'nqptqh9rbuil08e2kjlsr3ot9m', 14, 1, '2026-03-22 12:21:35', '2026-03-22 12:21:35'), (82, NULL, 'fini3ktq810kel4u8hopjnbp8r', 15, 1, '2026-03-22 14:17:23', '2026-03-22 14:17:23'), (83, NULL, 'a54mjqfba3koosbdm3jnrog4j7', 16, 1, '2026-03-22 14:45:29', '2026-03-22 14:45:29'), (84, NULL, 'vm7f67d92lct48brjoh9e1hgrl', 14, 1, '2026-03-23 00:43:52', '2026-03-23 00:43:52'), (85, NULL, 'h4a70vcqbjecp60aj9ufqs5gil', 12, 1, '2026-03-23 01:21:42', '2026-03-23 01:21:42'), (86, NULL, '34vrv3bhjdqo4hn09tsf3dpnvv', 5, 1, '2026-03-23 03:04:17', '2026-03-23 03:04:17'), (87, NULL, '92295tkba57ut4ko8ibcdkdnu9', 15, 1, '2026-03-23 03:31:41', '2026-03-23 03:31:41'), (88, NULL, 'i5g6ocg3d4f4teaopj33cm86bp', 13, 1, '2026-03-23 05:15:10', '2026-03-23 05:15:10'), (89, NULL, 'ubenbj45etn4nkkjgphvg2lc7k', 12, 1, '2026-03-23 05:43:41', '2026-03-23 05:43:41'), (90, NULL, '0g1msarg4t773rb201ckb0fb4a', 18, 1, '2026-03-23 06:02:42', '2026-03-23 06:02:42'), (91, NULL, '661qeb6g5v6f7c31ar6jlcjoev', 17, 1, '2026-03-23 08:49:12', '2026-03-23 08:49:12'), (92, NULL, '54nfku4s19i8b8l3a13btapn6v', 16, 1, '2026-03-23 10:18:52', '2026-03-23 10:18:52'), (93, NULL, 'hs9fqvb90f1u69rmqi3q5r7svu', 13, 1, '2026-03-23 22:34:37', '2026-03-23 22:34:37'), (94, NULL, 'vv7isqcd7teo7519nqoh2bm6ic', 16, 1, '2026-03-24 05:15:01', '2026-03-24 05:15:01'), (95, NULL, 'dic3d916g4bsse9drs34c0aesj', 14, 1, '2026-03-25 01:18:24', '2026-03-25 01:18:24'), (97, NULL, '2ne93gajqsbp2flo69dv5nl44o', 18, 1, '2026-03-26 10:31:59', '2026-03-26 10:31:59'), (100, NULL, '5qrdti2n085id4fi8pv8mca0dd', 13, 1, '2026-03-26 21:16:14', '2026-03-26 21:16:14'); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(10) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `slug` varchar(100) NOT NULL, `description` text DEFAULT NULL, `tags` text NOT NULL, `image` varchar(255) DEFAULT NULL, `parent_id` int(10) UNSIGNED DEFAULT NULL COMMENT 'For subcategories', `display_order` int(11) DEFAULT 0, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `slug`, `description`, `tags`, `image`, `parent_id`, `display_order`, `is_active`, `created_at`, `updated_at`) VALUES (21, 'Skin Care', 'skin-care', 'Skin Care', '', 'gallery/gallery_69a867475295d.png', NULL, 0, 1, '2026-03-06 19:05:52', '2026-03-16 07:40:12'), (22, 'women\'s health', 'women-s-health', 'women\'s health', '', 'gallery/gallery_69a86747596e2.png', NULL, 0, 1, '2026-03-06 19:06:12', '2026-03-16 07:40:20'), (26, 'Men\'s Health', 'men-s-health', 'Men\'s Health', '', 'gallery/gallery_69a8674754bea.png', NULL, 0, 1, '2026-03-06 19:12:52', '2026-03-16 07:39:18'), (28, 'Multivitamin', 'multivitamin', 'Multivitamin', '', 'gallery/gallery_69a867475790c.png', NULL, 0, 1, '2026-03-06 19:16:41', '2026-03-16 07:39:55'), (29, 'Bones & Joints', 'bones-joints', 'Bones & Joints', '', 'gallery/gallery_69a867474851c.png', NULL, 0, 1, '2026-03-06 19:17:13', '2026-03-16 07:38:53'), (30, 'Immune Support', 'immune-support', 'Immune Support', '', 'gallery/gallery_69a867475295d.png', NULL, 0, 1, '2026-03-06 19:17:39', '2026-03-16 07:40:27'); -- -------------------------------------------------------- -- -- Table structure for table `contact_messages` -- CREATE TABLE `contact_messages` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone` varchar(20) DEFAULT NULL, `subject` varchar(200) NOT NULL, `message` text NOT NULL, `status` enum('new','read','replied','archived') DEFAULT 'new', `replied_at` timestamp NULL DEFAULT NULL, `replied_by` int(11) DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `coupons` -- CREATE TABLE `coupons` ( `id` int(11) NOT NULL, `code` varchar(50) NOT NULL, `description` varchar(255) DEFAULT NULL, `discount_type` enum('percentage','fixed') NOT NULL DEFAULT 'percentage', `discount_value` decimal(10,2) NOT NULL, `min_order_amount` decimal(10,2) DEFAULT NULL, `max_discount_amount` decimal(10,2) DEFAULT NULL, `valid_from` datetime DEFAULT NULL, `valid_until` datetime DEFAULT NULL, `max_uses` int(11) DEFAULT NULL, `used_count` int(11) DEFAULT 0, `max_uses_per_user` int(11) DEFAULT 1, `is_active` tinyint(1) DEFAULT 1, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `coupons` -- INSERT INTO `coupons` (`id`, `code`, `description`, `discount_type`, `discount_value`, `min_order_amount`, `max_discount_amount`, `valid_from`, `valid_until`, `max_uses`, `used_count`, `max_uses_per_user`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'WELCOME10', 'Welcome discount for new customers', 'percentage', 10.00, 50.00, 20.00, '2025-01-01 00:00:00', '2025-12-31 23:59:59', 1000, 0, 1, 1, '2026-01-02 20:32:20', '2026-01-02 20:32:20'), (2, 'SAVE20', 'Save 20% on orders over $100', 'percentage', 20.00, 100.00, 50.00, '2025-01-01 00:00:00', '2025-12-31 23:59:59', 500, 0, 3, 1, '2026-01-02 20:32:20', '2026-01-02 20:32:20'), (3, 'FLAT15', 'Flat $15 off on orders over $75', 'fixed', 15.00, 75.00, NULL, '2025-01-01 00:00:00', '2025-12-31 23:59:59', NULL, 0, 5, 1, '2026-01-02 20:32:20', '2026-01-02 20:32:20'), (4, 'NEWYEAR2025', 'New Year Special - 25% off', 'percentage', 25.00, 150.00, 100.00, '2025-01-01 00:00:00', '2025-01-15 23:59:59', 200, 0, 1, 1, '2026-01-02 20:32:20', '2026-01-02 20:32:20'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `original_name` varchar(255) NOT NULL, `file_size` int(11) NOT NULL, `mime_type` varchar(50) NOT NULL, `uploaded_by` int(10) UNSIGNED NOT NULL, `uploaded_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`id`, `filename`, `original_name`, `file_size`, `mime_type`, `uploaded_by`, `uploaded_at`) VALUES (5, 'gallery_69a867474851c.png', 'Multivitamins_100x_crop_center.png', 14587, 'image/png', 1, '2026-03-04 17:09:27'), (6, 'gallery_69a867475295d.png', 'Nutrisports_100x_crop_center.png', 12690, 'image/png', 1, '2026-03-04 17:09:27'), (7, 'gallery_69a8674754bea.png', 'men_health_icon_61d90a74-1cfe-45ce-8d59-04194a0b496f_100x_crop_center.png', 11793, 'image/png', 1, '2026-03-04 17:09:27'), (8, 'gallery_69a867475790c.png', 'weight_management_icon_5d78fa5b-282f-4762-adf6-3a7abfd9abd5_100x_crop_center.png', 14238, 'image/png', 1, '2026-03-04 17:09:27'), (9, 'gallery_69a86747596e2.png', 'woman_health_icon_2570e520-3fb7-404c-9786-fa2ddac60a9f_100x_crop_center.png', 10345, 'image/png', 1, '2026-03-04 17:09:27'), (10, 'gallery_69a87670d2913.png', 'Folic-Acid_1_785x.png', 92129, 'image/png', 1, '2026-03-04 18:14:08'), (11, 'gallery_69a87670f11de.png', 'B-50_5d5b077c-c7f6-4f13-80d3-2c5c434c8746_785x.png', 97181, 'image/png', 1, '2026-03-04 18:14:08'), (12, 'gallery_69a876710429f.png', 'BZOLVEbox_785x.png', 94800, 'image/png', 1, '2026-03-04 18:14:09'), (13, 'gallery_69a87713877e2.png', 'HALDI_21_960x600.png', 178510, 'image/png', 1, '2026-03-04 18:16:51'), (14, 'gallery_69a8771394af3.png', 'cherries_960x600.png', 135895, 'image/png', 1, '2026-03-04 18:16:51'), (44, 'gallery_69c2a1d724d26.png', '20260324_1831_Image_Generation_remix_01kmg0nxnxfmnv5sbr04tk4qyv (1).png', 436130, 'image/png', 1, '2026-03-24 14:38:15'), (45, 'gallery_69c2a231f3d9f.png', 'WhatsApp_Image_2026_03_07_at_12_26_23_AM__1_.png', 424028, 'image/png', 1, '2026-03-24 14:39:45'), (46, 'gallery_69c2a2a8d95aa.png', 'WhatsApp_Image_2026_03_24_at_6_27_27_PM.png', 456438, 'image/png', 1, '2026-03-24 14:41:44'), (47, 'gallery_69c2a315dc8d9.png', 'WhatsApp_Image_2026_03_06_at_9_05_31_PM.png', 404428, 'image/png', 1, '2026-03-24 14:43:33'), (48, 'gallery_69c2a36933691.png', 'WhatsApp_Image_2026_03_07_at_12_21_49_AM.png', 379134, 'image/png', 1, '2026-03-24 14:44:57'), (49, 'gallery_69c2a3cb37bd1.png', 'WhatsApp_Image_2026_03_07_at_12_21_50_AM.png', 396434, 'image/png', 1, '2026-03-24 14:46:35'), (51, 'gallery_69c2a6aef0684.png', 'WhatsApp_Image_2026_03_24_at_7_54_29_PM (1).png', 457192, 'image/png', 1, '2026-03-24 14:58:54'), (52, 'gallery_69c2a8078e5b1.png', '20260324_2002_Image Generation_remix_01kmg5v79se99bkz33tv3meybe (2) (1).png', 474277, 'image/png', 1, '2026-03-24 15:04:39'), (53, 'gallery_69c635dcc1768.jpeg', 'WhatsApp Image 2026-03-26 at 11.23.05 PM.jpeg', 408237, 'image/jpeg', 1, '2026-03-27 07:46:36'); -- -------------------------------------------------------- -- -- Table structure for table `loyalty_transactions` -- CREATE TABLE `loyalty_transactions` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `order_id` int(10) UNSIGNED DEFAULT NULL, `type` enum('earn_pending','earn_release','expire','adjustment') NOT NULL, `coins` int(11) NOT NULL, `status` enum('pending','completed','cancelled','expired') NOT NULL DEFAULT 'pending', `note` varchar(255) DEFAULT NULL, `expires_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `completed_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `newsletter_subscribers` -- CREATE TABLE `newsletter_subscribers` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `status` enum('active','unsubscribed') DEFAULT 'active', `subscribed_at` timestamp NOT NULL DEFAULT current_timestamp(), `unsubscribed_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(10) UNSIGNED NOT NULL, `order_number` varchar(50) NOT NULL, `user_id` int(10) UNSIGNED DEFAULT NULL, `customer_name` varchar(100) NOT NULL, `customer_email` varchar(100) DEFAULT NULL, `customer_phone` varchar(20) NOT NULL, `shipping_address` text NOT NULL, `city` varchar(50) NOT NULL, `postal_code` varchar(10) DEFAULT NULL, `subtotal` decimal(10,2) NOT NULL, `shipping_fee` decimal(10,2) DEFAULT 0.00, `discount` decimal(10,2) DEFAULT 0.00, `total_amount` decimal(10,2) NOT NULL, `payment_method` enum('cod') DEFAULT 'cod', `order_status` enum('pending','confirmed','processing','delivered','cancelled') DEFAULT 'pending', `payment_status` enum('unpaid','paid') DEFAULT 'unpaid', `notes` text DEFAULT NULL, `admin_notes` text DEFAULT NULL, `whatsapp_sent` tinyint(1) DEFAULT 0, `email_sent` tinyint(1) DEFAULT 0, `email_sent_at` datetime DEFAULT NULL, `whatsapp_sent_at` datetime DEFAULT NULL, `confirmed_at` datetime DEFAULT NULL, `delivered_at` datetime DEFAULT NULL, `cancelled_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `order_number`, `user_id`, `customer_name`, `customer_email`, `customer_phone`, `shipping_address`, `city`, `postal_code`, `subtotal`, `shipping_fee`, `discount`, `total_amount`, `payment_method`, `order_status`, `payment_status`, `notes`, `admin_notes`, `whatsapp_sent`, `email_sent`, `email_sent_at`, `whatsapp_sent_at`, `confirmed_at`, `delivered_at`, `cancelled_at`, `created_at`, `updated_at`) VALUES (6, '0', 6, 'John Smith', 'john@example.com', '+923082866729', '123 Main Street, Apt 101', 'New York', '1000112', 602.00, 0.00, 0.00, 602.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 1, '2026-01-04 13:27:51', NULL, NULL, NULL, NULL, '2026-01-04 08:27:51', '2026-01-04 08:27:51'), (11, 'HP17675156399020', 6, 'John Smith', 'john@example.com', '+923082866729', '123 Main Street, Apt 101', 'New York', '1000112', 602.00, 0.00, 0.00, 602.00, 'cod', 'pending', 'unpaid', 'ssssssssssss', NULL, 0, 1, '2026-01-04 13:33:59', NULL, NULL, NULL, NULL, '2026-01-04 08:33:59', '2026-01-04 08:33:59'), (12, 'HP17675159488054', 6, 'John Smith', 'john@example.com', '+923082866729', '123 Main Street, Apt 101', 'New York', '1000112', 600.00, 0.00, 0.00, 600.00, 'cod', 'pending', 'unpaid', 'wwwwwwwwwwwwwwwwwwwww', NULL, 0, 1, '2026-01-04 13:39:08', NULL, NULL, NULL, NULL, '2026-01-04 08:39:08', '2026-01-04 08:39:08'), (13, 'HP17727859771831', NULL, 'abc abc', 'abc@gmail.com', '+10310000000', 'street# 6', 'abc', '60000', 0.00, 50.00, 0.00, 50.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-06 08:32:57', '2026-03-06 08:32:57'), (14, 'HP17728135549388', NULL, 'abc abc', 'abc@gmail.com', '+922222223128888732', 'street# 6', 'abc', '60000', 0.00, 50.00, 0.00, 50.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-06 16:12:34', '2026-03-06 16:12:34'), (15, 'HP17729030304573', NULL, 'abc abc', 'abc@gmail.com', '+923100000000', 'street# 6', 'abc', '60000', 5800.00, 0.00, 0.00, 5800.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-07 17:03:50', '2026-03-07 17:03:50'), (16, 'HP17729086004029', NULL, 'adnan', 'adnan@gmail.com', '03007306299', 'Line 1', 'Multan', '66000', 3000.00, 0.00, 0.00, 3000.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-07 18:36:40', '2026-03-07 18:36:40'), (17, 'HP17733984633386', NULL, 'iqra iqra javed', 'iqraansari9809@gmail.com', '+923128888732', 'street# 6', 'Multan', '60000', 1500.00, 0.00, 0.00, 1500.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-13 10:41:03', '2026-03-13 10:41:03'), (18, 'HP17737243495616', NULL, 'iqra iqra javed', 'iqraansari9809@gmail.com', '+923128888732', 'street# 6', 'Multan', '60000', 1800.00, 0.00, 0.00, 1800.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-17 05:12:29', '2026-03-17 05:12:29'), (19, 'HP17744500143670', NULL, 'iqra iqra javed', 'iqraansari9809@gmail.com', '+923128888732', 'street# 6', 'Multan', '60000', 1512.00, 0.00, 0.00, 1512.00, 'cod', 'pending', 'unpaid', '', NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, '2026-03-25 14:46:54', '2026-03-25 14:46:54'); -- -------------------------------------------------------- -- -- Table structure for table `order_items` -- CREATE TABLE `order_items` ( `id` int(10) UNSIGNED NOT NULL, `order_id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `product_name` varchar(200) NOT NULL, `product_image` varchar(255) DEFAULT NULL, `quantity` int(11) NOT NULL, `unit_price` decimal(10,2) NOT NULL, `total_price` decimal(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_items` -- INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `product_name`, `product_image`, `quantity`, `unit_price`, `total_price`, `created_at`) VALUES (11, 6, 5, 'Multivitamin Complex - Daily Health', 'gallery_695a090924c20.png', 1, 600.00, 600.00, '2026-01-04 08:27:51'), (12, 6, 12, 'sss', 'gallery_695a090924c20.png', 1, 2.00, 2.00, '2026-01-04 08:27:51'), (13, 11, 5, 'Multivitamin Complex - Daily Health', 'gallery_695a090924c20.png', 1, 600.00, 600.00, '2026-01-04 08:33:59'), (14, 11, 12, 'sss', 'gallery_695a090924c20.png', 1, 2.00, 2.00, '2026-01-04 08:33:59'), (15, 12, 5, 'Multivitamin Complex - Daily Health', 'gallery_695a090924c20.png', 1, 600.00, 600.00, '2026-01-04 08:39:08'), (16, 13, 12, 'sss', 'gallery_69a87670f11de.png', 0, 2.00, 0.00, '2026-03-06 08:32:57'), (17, 14, 12, 'sss', 'gallery_69a87670f11de.png', 0, 2.00, 0.00, '2026-03-06 16:12:34'), (18, 15, 18, 'Lubovate Night Cream', 'gallery_69ab296e998df.jpeg', 4, 1450.00, 5800.00, '2026-03-07 17:03:50'), (19, 16, 17, 'Top-X', 'gallery_69ab2d413eb2b.jpeg', 2, 1500.00, 3000.00, '2026-03-07 18:36:40'), (20, 17, 17, 'Top-X', 'gallery_69ab2d413eb2b.jpeg', 1, 1500.00, 1500.00, '2026-03-13 10:41:03'), (21, 18, 5, 'gestomed cough syrup', 'gallery_69b7b551ee712.png', 6, 300.00, 1800.00, '2026-03-17 05:12:29'), (22, 19, 12, 'Jalariz Antacid Syrup', 'gallery_69c2a8078e5b1.png', 6, 252.00, 1512.00, '2026-03-25 14:46:54'); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `id` int(11) NOT NULL, `email` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `expires_at` datetime NOT NULL, `used` tinyint(1) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `token` varchar(64) NOT NULL, `expires_at` datetime NOT NULL, `used` tinyint(1) DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `payments` -- CREATE TABLE `payments` ( `id` int(10) UNSIGNED NOT NULL, `order_id` int(10) UNSIGNED NOT NULL, `payment_method` enum('cod') DEFAULT 'cod', `amount` decimal(10,2) NOT NULL, `payment_status` enum('pending','completed','failed') DEFAULT 'pending', `transaction_id` varchar(100) DEFAULT NULL, `paid_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `payments` -- INSERT INTO `payments` (`id`, `order_id`, `payment_method`, `amount`, `payment_status`, `transaction_id`, `paid_at`, `created_at`, `updated_at`) VALUES (3, 6, 'cod', 602.00, 'pending', NULL, NULL, '2026-01-04 08:27:51', '2026-01-04 08:27:51'), (4, 11, 'cod', 602.00, 'pending', NULL, NULL, '2026-01-04 08:33:59', '2026-01-04 08:33:59'), (5, 12, 'cod', 600.00, 'pending', NULL, NULL, '2026-01-04 08:39:08', '2026-01-04 08:39:08'), (6, 13, 'cod', 50.00, 'pending', NULL, NULL, '2026-03-06 08:32:57', '2026-03-06 08:32:57'), (7, 14, 'cod', 50.00, 'pending', NULL, NULL, '2026-03-06 16:12:34', '2026-03-06 16:12:34'), (8, 15, 'cod', 5800.00, 'pending', NULL, NULL, '2026-03-07 17:03:50', '2026-03-07 17:03:50'), (9, 16, 'cod', 3000.00, 'pending', NULL, NULL, '2026-03-07 18:36:40', '2026-03-07 18:36:40'), (10, 17, 'cod', 1500.00, 'pending', NULL, NULL, '2026-03-13 10:41:03', '2026-03-13 10:41:03'), (11, 18, 'cod', 1800.00, 'pending', NULL, NULL, '2026-03-17 05:12:29', '2026-03-17 05:12:29'), (12, 19, 'cod', 1512.00, 'pending', NULL, NULL, '2026-03-25 14:46:54', '2026-03-25 14:46:54'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(10) UNSIGNED NOT NULL, `category_id` int(10) UNSIGNED NOT NULL, `name` varchar(200) NOT NULL, `slug` varchar(200) NOT NULL DEFAULT '', `description` text NOT NULL, `short_description` varchar(500) DEFAULT NULL, `ingredients_html` mediumtext DEFAULT NULL, `instructions_html` mediumtext DEFAULT NULL, `show_tab_details` tinyint(1) NOT NULL DEFAULT 1, `show_tab_ingredients` tinyint(1) NOT NULL DEFAULT 1, `show_tab_faqs` tinyint(1) NOT NULL DEFAULT 0, `show_tab_reviews` tinyint(1) NOT NULL DEFAULT 1, `price` decimal(10,2) NOT NULL, `original_price` decimal(10,2) DEFAULT NULL, `sku` varchar(50) DEFAULT NULL, `stock_quantity` int(11) DEFAULT 0, `low_stock_alert` int(11) DEFAULT 10, `main_image` varchar(255) NOT NULL, `is_featured` tinyint(1) DEFAULT 0, `is_active` tinyint(1) DEFAULT 1, `meta_title` varchar(200) DEFAULT NULL, `meta_description` text DEFAULT NULL, `views` int(11) DEFAULT 0, `manual_avg_rating` decimal(3,2) DEFAULT NULL, `manual_review_count` int(11) NOT NULL DEFAULT 0, `wellness_coin_rate` decimal(10,2) NOT NULL DEFAULT 1.00, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `category_id`, `name`, `slug`, `description`, `short_description`, `ingredients_html`, `instructions_html`, `show_tab_details`, `show_tab_ingredients`, `show_tab_faqs`, `show_tab_reviews`, `price`, `original_price`, `sku`, `stock_quantity`, `low_stock_alert`, `main_image`, `is_featured`, `is_active`, `meta_title`, `meta_description`, `views`, `manual_avg_rating`, `manual_review_count`, `wellness_coin_rate`, `created_at`, `updated_at`) VALUES (5, 30, 'gestomed cough syrup', 'gestomed-cough-syrup', '

Product Description

\r\n

Complete daily multivitamin with essential vitamins and minerals to support overall health and wellness.

\r\n

Contains:

\r\n

Vitamins A, C, D, E, K
B-Complex vitamins
Zinc, Magnesium, Calcium
Essential trace minerals

', 'Complete multivitamin supplement with essential vitamins and minerals for daily health support.', '', '', 1, 1, 0, 1, 300.00, 300.00, 'SUP-LBV-001', 194, 10, 'gallery_69c2a6aef0684.png', 1, 1, 'Daily Multivitamin Complex - Complete Nutrition Support', 'Complete multivitamin with essential vitamins and minerals for daily health and wellness.', 99, 0.00, 0, 1.00, '2026-01-02 20:34:11', '2026-03-29 20:10:53'), (12, 30, 'Jalariz Antacid Syrup', 'jalariz-antacid-syrup', '

sss

', 'ss', '', '', 1, 1, 0, 1, 280.00, 280.00, '100', 94, 10, 'gallery_69c2a8078e5b1.png', 1, 1, 'f', 'f', 180, 0.00, 0, 1.00, '2026-01-04 06:15:38', '2026-03-29 09:06:04'), (13, 29, 'M-Scor Tab', 'm-scor-tab', '

Lubovate face wash

', 'M-Scor calcium vit D3 & k2 tab', '', '', 1, 1, 0, 1, 650.00, 650.00, 'SUP-SUP-002', 200, 10, 'gallery_69c2a2a8d95aa.png', 1, 1, 'M-Scor calcium vit D3 & k2 tab', 'M-Scor calcium vit D3 & k2 tab', 53, 0.00, 0, 1.00, '2026-03-06 19:29:35', '2026-03-30 03:49:35'), (14, 22, 'cemolin plus', 'cemolin-plus', '

cemolin plus iron tab

', 'cemolin plus iron tab', '', '', 1, 1, 0, 1, 650.00, 650.00, 'SUP-TAB-001', 200, 10, 'gallery_69c2a315dc8d9.png', 1, 1, 'cemolin plus iron tab', 'cemolin plus iron tab', 49, 0.00, 0, 1.00, '2026-03-06 19:32:57', '2026-03-30 09:18:01'), (15, 21, 'Lubovate face wash', 'lubovate-face-wash', '

M-Scor calcium vit D3 & k2 tab

', 'Lubovate face wash', '', '', 1, 1, 0, 1, 1000.00, 1000.00, 'SUP-LUB-002', 200, 10, 'gallery_69c2a36933691.png', 1, 1, '', '', 43, 0.00, 0, 1.00, '2026-03-06 19:35:38', '2026-03-29 23:36:44'), (16, 28, 'ginx plus', 'ginx-plus', '

ginx plus multivitamin tab

', 'ginx plus multivitamin tab', '', '', 1, 1, 0, 1, 1100.00, 1200.00, 'SUP-TAB-003', 200, 10, 'gallery_69c2a231f3d9f.png', 1, 1, 'ginx plus multivitamin tab', 'ginx plus multivitamin tab', 56, 0.00, 0, 1.00, '2026-03-06 19:37:39', '2026-03-30 06:47:11'), (17, 26, 'Top-X', 'top-x', '

Top-X

', 'Top-X', '', '', 1, 1, 0, 1, 1500.00, 1500.00, 'SUP-TAB-004', 1997, 10, 'gallery_69c2a1d724d26.png', 1, 1, 'Top-X', 'Top-X', 92, 0.00, 0, 1.00, '2026-03-06 19:39:18', '2026-03-30 06:47:06'), (18, 21, 'Lubovate Night Cream', 'lubovate-night-cream', '

Lubovate Night Cream

', 'Lubovate Night Cream', ' \r\n

\r\n

\r\n\r\n

\r\n

Glutathione (Reduced)

\r\n

Powerful skin whitening antioxidant
Reduces melanin formation during night repair cycle
Detoxifies skin cells and improves complexion

\r\n

\r\n\r\n

\r\n

Niacinamide

\r\n

Strengthens skin barrier overnight
Controls oil & reduces redness
Improves uneven tone and texture

\r\n

\r\n\r\n

\r\n

Vitamin E (Tocopheryl Acetate) – 1%

\r\n

Repairs skin damage caused by pollution & UV exposure
Deep nourishment and moisture retention
Improves elasticity

\r\n

\r\n\r\n

\r\n

Hyaluronic Acid

\r\n

Deep hydration throughout the night
Plumps skin and smooths fine lines
Prevents dryness caused by retinol

\r\n

\r\n\r\n

\r\n

Retinol (Encapsulated)

\r\n

Stimulates collagen production at night
Accelerates cell renewal & skin regeneration
Reduces wrinkles, acne marks & pigmentation
Encapsulation minimizes irritation

\r\n

\r\n\r\n

\r\n

Vitamin C (Ascorbic Acid) – 0.2%

\r\n

Enhances overnight glow
Supports collagen synthesis
Fights oxidative stress

\r\n

\r\n\r\n

\r\n

Alpha Arbutin (1%)

\r\n

Inhibits excess melanin production
Reduces dark spots, melasma & hyperpigmentation
Safe for nightly use

\r\n

\r\n\r\n

\r\n

', '\r\n

\r\n\r\n

\r\n\r\n \r\n

\r\n

How to Use

\r\n

Cleanse face thoroughly before bedtime
Apply a small amount evenly on face & neck
Massage gently until absorbed
Use once daily at night only

\r\n

\r\n\r\n \r\n

\r\n

Caution

\r\n

For external use only
Avoid contact with eyes
Mild tingling may occur initially
Use sunscreen during daytime
Store below 30°C, away from sunlight
Perform a patch test before first use
Discontinue use if irritation occurs
Keep out of reach of children

\r\n

\r\n\r\n

', 0, 1, 1, 0, 1450.00, 1450.00, 'SUP-LBV-001', 996, 10, 'gallery_69c2a3cb37bd1.png', 1, 1, 'M-SCOR Tablets | Calcium, Vitamin D3 & K2 Bone Health Formula', 'Lubovate Night Cream', 97, 0.00, 0, 1.00, '2026-03-06 19:43:21', '2026-03-30 08:18:57'); -- -------------------------------------------------------- -- -- Table structure for table `product_deals` -- CREATE TABLE `product_deals` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `min_quantity` int(11) NOT NULL, `discount_type` enum('percentage','fixed_amount','fixed_price') NOT NULL DEFAULT 'percentage', `discount_value` decimal(10,2) NOT NULL, `label` varchar(100) DEFAULT NULL, `end_at` datetime DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_deals` -- INSERT INTO `product_deals` (`id`, `product_id`, `min_quantity`, `discount_type`, `discount_value`, `label`, `end_at`, `is_active`, `sort_order`, `created_at`, `updated_at`) VALUES (23, 17, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 14:38:42', '2026-03-24 14:38:42'), (24, 16, 2, 'percentage', 2.00, '', NULL, 1, 0, '2026-03-24 14:39:58', '2026-03-24 14:39:58'), (25, 16, 5, 'percentage', 3.00, '', NULL, 1, 1, '2026-03-24 14:39:58', '2026-03-24 14:39:58'), (26, 16, 10, 'percentage', 5.00, '', NULL, 1, 2, '2026-03-24 14:39:58', '2026-03-24 14:39:58'), (28, 14, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 14:43:46', '2026-03-24 14:43:46'), (32, 5, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 14:59:06', '2026-03-24 14:59:06'), (33, 12, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 15:04:56', '2026-03-24 15:04:56'), (35, 13, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 15:13:27', '2026-03-24 15:13:27'), (36, 15, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-24 15:13:42', '2026-03-24 15:13:42'), (44, 18, 2, 'percentage', 10.00, '', NULL, 1, 0, '2026-03-27 19:58:20', '2026-03-27 19:58:20'); -- -------------------------------------------------------- -- -- Table structure for table `product_faqs` -- CREATE TABLE `product_faqs` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `question` varchar(255) NOT NULL, `answer` text DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `product_faqs` -- INSERT INTO `product_faqs` (`id`, `product_id`, `question`, `answer`, `sort_order`, `is_active`, `created_at`) VALUES (6, 18, 'How should I store this product?', 'Store in a cool, dry place below 30°C and keep away from direct sunlight to maintain product effectiveness.', 0, 1, '2026-03-27 19:58:20'), (7, 18, 'Can pregnant or breastfeeding women use this product?', 'It is recommended to consult a healthcare professional before use, especially due to the presence of active ingredients like Retinol.', 1, 1, '2026-03-27 19:58:20'), (8, 18, 'How long does it take to see results?', 'Visible improvements can typically be seen within 5-6 weeks of consistent use. Results may vary depending on individual skin type and concerns.', 2, 1, '2026-03-27 19:58:20'), (9, 18, 'What is this night repair cream used for?', 'This advanced night repair cream is designed to work while you sleep, helping to repair, brighten, and deeply hydrate the skin. It targets dark spots, pigmentation, fine lines, and dullness for a healthier, more radiant complexion.', 3, 1, '2026-03-27 19:58:20'), (10, 18, 'Can I use this cream every day?', 'Yes, this cream is formulated for daily use. For best results, apply it once every night as part of your skincare routine.', 4, 1, '2026-03-27 19:58:20'); -- -------------------------------------------------------- -- -- Table structure for table `product_images` -- CREATE TABLE `product_images` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `image_path` varchar(255) NOT NULL, `display_order` int(11) DEFAULT 0, `created_at` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `rating` tinyint(1) NOT NULL, `title` varchar(200) DEFAULT NULL, `comment` text NOT NULL, `is_approved` tinyint(1) DEFAULT 0, `approved_by` int(10) UNSIGNED DEFAULT NULL, `approved_at` datetime DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(10) UNSIGNED NOT NULL, `setting_key` varchar(100) NOT NULL, `setting_value` text DEFAULT NULL, `setting_type` enum('text','textarea','number','boolean','json') DEFAULT 'text', `description` varchar(255) DEFAULT NULL, `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `setting_type`, `description`, `updated_at`) VALUES (1, 'site_name', 'Hizen Pharma', 'text', 'Website name', '2025-12-29 12:39:34'), (2, 'site_email', 'hizenpharma@gmail.com', 'text', 'Contact email', '2025-12-29 12:39:34'), (3, 'site_phone', '+923082866729', 'text', 'Contact phone', '2025-12-29 12:39:34'), (4, 'whatsapp_number', '+923082866729', 'text', 'WhatsApp contact number', '2025-12-29 12:39:34'), (5, 'whatsapp_message', 'Hello! I want to confirm my order #{order_number}', 'textarea', 'WhatsApp message template', '2025-12-29 12:39:34'), (6, 'shipping_fee', '50', 'number', 'Default shipping fee', '2025-12-29 12:39:34'), (7, 'free_shipping_threshold', '500', 'number', 'Free shipping above this amount', '2025-12-29 12:39:34'), (8, 'site_address', '123 Medical Street, City, Country', 'textarea', 'Business address', '2025-12-29 12:39:34'), (9, 'google_maps_url', '', 'text', 'Google Maps embed URL', '2025-12-29 12:39:34'), (10, 'low_stock_alert', '10', 'number', 'Low stock alert threshold', '2025-12-29 12:39:34'), (11, 'currency_symbol', '$', 'text', 'Currency symbol', '2025-12-29 12:39:34'), (12, 'enable_reviews', '1', 'boolean', 'Enable product reviews', '2025-12-29 12:39:34'), (13, 'auto_approve_reviews', '0', 'boolean', 'Auto approve reviews', '2025-12-29 12:39:34'), (27, 'email_enabled', '0', 'text', NULL, '2026-01-02 20:32:30'), (28, 'email_smtp_host', 'smtp.gmail.com', 'text', NULL, '2026-01-02 20:32:30'), (29, 'email_smtp_port', '587', 'text', NULL, '2026-01-02 20:32:30'), (30, 'email_smtp_username', '', 'text', NULL, '2026-01-02 20:32:30'), (31, 'email_smtp_password', '', 'text', NULL, '2026-01-02 20:32:30'), (32, 'email_from_email', 'noreply@hizenpharma.com', 'text', NULL, '2026-01-02 20:32:30'), (33, 'email_from_name', 'Hizen Pharma', 'text', NULL, '2026-01-02 20:32:30'), (34, 'admin_email', 'admin@hizenpharma.com', 'text', NULL, '2026-01-02 20:32:30'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(10) UNSIGNED NOT NULL, `full_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `phone` varchar(20) NOT NULL, `password` varchar(255) NOT NULL, `address` text DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `postal_code` varchar(10) DEFAULT NULL, `is_active` tinyint(1) DEFAULT 0 COMMENT '0=Active, 1=Blocked', `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `full_name`, `email`, `phone`, `password`, `address`, `city`, `postal_code`, `is_active`, `created_at`, `updated_at`) VALUES (6, 'John Smith', 'john@example.com', '+923082866729', '$2y$10$bkphrug.eeKYm7a5xujuzO.N/C1hm7mOwFrl2108Ul6Wi8T7nPwWa', '123 Main Street, Apt 101', 'New York', '1000112', 1, '2026-01-02 21:50:31', '2026-01-04 07:25:58'), (7, 'Sarah Johnson', 'sarah@example.com', '+1987654321', '$2y$10$qFWxzkUqGW5.mTv6Vco54ObZyfSJzwBHSmJfWGjZ3TUQO9uwQu9cm', '456 Oak Avenue, Suite 200', 'Los Angeles', '90001', 1, '2026-01-02 21:50:31', '2026-01-04 07:25:44'), (8, 'Michael Davis', 'michael@example.com', '+1555123456', '$2y$10$6XHZf7qm7oi1VU.OMVexaeLdH3J3I3Wn4losHuAaDpxCaf9WFpX4K', '789 Pine Road, Apt 305', 'Chicago', '60601', 1, '2026-01-02 21:50:31', '2026-01-04 07:25:44'); -- -------------------------------------------------------- -- -- Table structure for table `user_loyalty_accounts` -- CREATE TABLE `user_loyalty_accounts` ( `user_id` int(10) UNSIGNED NOT NULL, `available_coins` int(11) NOT NULL DEFAULT 0, `pending_coins` int(11) NOT NULL DEFAULT 0, `lifetime_coins` int(11) NOT NULL DEFAULT 0, `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `wishlist` -- CREATE TABLE `wishlist` ( `id` int(10) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `product_id` int(10) UNSIGNED NOT NULL, `added_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD KEY `is_active` (`is_active`); -- -- Indexes for table `blog_categories` -- ALTER TABLE `blog_categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`); -- -- Indexes for table `blog_posts` -- ALTER TABLE `blog_posts` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `category_id` (`category_id`), ADD KEY `author_id` (`author_id`), ADD KEY `is_published` (`is_published`); -- -- Indexes for table `cart` -- ALTER TABLE `cart` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_cart_user_product` (`user_id`,`product_id`), ADD KEY `user_id` (`user_id`), ADD KEY `session_id` (`session_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `parent_id` (`parent_id`), ADD KEY `is_active` (`is_active`); -- -- Indexes for table `contact_messages` -- ALTER TABLE `contact_messages` ADD PRIMARY KEY (`id`), ADD KEY `status` (`status`), ADD KEY `created_at` (`created_at`), ADD KEY `email` (`email`); -- -- Indexes for table `coupons` -- ALTER TABLE `coupons` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `code` (`code`), ADD KEY `is_active` (`is_active`), ADD KEY `valid_until` (`valid_until`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `filename` (`filename`), ADD KEY `uploaded_by` (`uploaded_by`), ADD KEY `idx_uploaded_at` (`uploaded_at`); -- -- Indexes for table `loyalty_transactions` -- ALTER TABLE `loyalty_transactions` ADD PRIMARY KEY (`id`), ADD KEY `idx_loyalty_user` (`user_id`), ADD KEY `idx_loyalty_order` (`order_id`), ADD KEY `idx_loyalty_status` (`status`); -- -- Indexes for table `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `status` (`status`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `order_number` (`order_number`), ADD KEY `user_id` (`user_id`), ADD KEY `order_status` (`order_status`), ADD KEY `payment_status` (`payment_status`), ADD KEY `created_at` (`created_at`); -- -- Indexes for table `order_items` -- ALTER TABLE `order_items` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_order_product` (`order_id`,`product_id`), ADD KEY `order_id` (`order_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD PRIMARY KEY (`id`), ADD KEY `email` (`email`), ADD KEY `token` (`token`), ADD KEY `expires_at` (`expires_at`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `token` (`token`), ADD KEY `user_id` (`user_id`), ADD KEY `expires_at` (`expires_at`); -- -- Indexes for table `payments` -- ALTER TABLE `payments` ADD PRIMARY KEY (`id`), ADD KEY `order_id` (`order_id`), ADD KEY `payment_status` (`payment_status`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `category_id` (`category_id`), ADD KEY `is_featured` (`is_featured`), ADD KEY `is_active` (`is_active`), ADD KEY `stock_quantity` (`stock_quantity`); -- -- Indexes for table `product_deals` -- ALTER TABLE `product_deals` ADD PRIMARY KEY (`id`), ADD KEY `idx_product_deals_product` (`product_id`), ADD KEY `idx_product_deals_active` (`is_active`,`end_at`); -- -- Indexes for table `product_faqs` -- ALTER TABLE `product_faqs` ADD PRIMARY KEY (`id`), ADD KEY `idx_product_faqs_product` (`product_id`), ADD KEY `idx_product_faqs_active` (`is_active`), ADD KEY `idx_product_faqs_sort` (`sort_order`); -- -- Indexes for table `product_images` -- ALTER TABLE `product_images` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_product_image_order` (`product_id`,`display_order`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `uniq_review_user_product` (`user_id`,`product_id`), ADD KEY `product_id` (`product_id`), ADD KEY `user_id` (`user_id`), ADD KEY `is_approved` (`is_approved`), ADD KEY `rating` (`rating`), ADD KEY `approved_by` (`approved_by`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `setting_key` (`setting_key`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`), ADD KEY `is_blocked` (`is_active`) USING BTREE; -- -- Indexes for table `user_loyalty_accounts` -- ALTER TABLE `user_loyalty_accounts` ADD PRIMARY KEY (`user_id`); -- -- Indexes for table `wishlist` -- ALTER TABLE `wishlist` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `user_product` (`user_id`,`product_id`), ADD KEY `user_id` (`user_id`), ADD KEY `product_id` (`product_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `blog_categories` -- ALTER TABLE `blog_categories` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `blog_posts` -- ALTER TABLE `blog_posts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `cart` -- ALTER TABLE `cart` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT for table `contact_messages` -- ALTER TABLE `contact_messages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `coupons` -- ALTER TABLE `coupons` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `loyalty_transactions` -- ALTER TABLE `loyalty_transactions` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `newsletter_subscribers` -- ALTER TABLE `newsletter_subscribers` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- AUTO_INCREMENT for table `order_items` -- ALTER TABLE `order_items` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `password_resets` -- ALTER TABLE `password_resets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payments` -- ALTER TABLE `payments` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `product_deals` -- ALTER TABLE `product_deals` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `product_faqs` -- ALTER TABLE `product_faqs` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `product_images` -- ALTER TABLE `product_images` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `wishlist` -- ALTER TABLE `wishlist` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `blog_posts` -- ALTER TABLE `blog_posts` ADD CONSTRAINT `blog_posts_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `blog_categories` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `blog_posts_ibfk_2` FOREIGN KEY (`author_id`) REFERENCES `admins` (`id`) ON DELETE CASCADE; -- -- Constraints for table `cart` -- ALTER TABLE `cart` ADD CONSTRAINT `cart_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `cart_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `categories_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL; -- -- Constraints for table `gallery` -- ALTER TABLE `gallery` ADD CONSTRAINT `gallery_ibfk_1` FOREIGN KEY (`uploaded_by`) REFERENCES `admins` (`id`) ON DELETE CASCADE; -- -- Constraints for table `loyalty_transactions` -- ALTER TABLE `loyalty_transactions` ADD CONSTRAINT `fk_loyalty_tx_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `fk_loyalty_tx_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `orders` -- ALTER TABLE `orders` ADD CONSTRAINT `orders_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL; -- -- Constraints for table `order_items` -- ALTER TABLE `order_items` ADD CONSTRAINT `order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD CONSTRAINT `password_reset_user_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `payments` -- ALTER TABLE `payments` ADD CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE; -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE; -- -- Constraints for table `product_deals` -- ALTER TABLE `product_deals` ADD CONSTRAINT `fk_product_deals_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `product_faqs` -- ALTER TABLE `product_faqs` ADD CONSTRAINT `fk_product_faqs_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- 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; -- -- Constraints for table `reviews` -- ALTER TABLE `reviews` ADD CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `reviews_ibfk_3` FOREIGN KEY (`approved_by`) REFERENCES `admins` (`id`) ON DELETE SET NULL; -- -- Constraints for table `user_loyalty_accounts` -- ALTER TABLE `user_loyalty_accounts` ADD CONSTRAINT `fk_loyalty_account_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `wishlist` -- ALTER TABLE `wishlist` ADD CONSTRAINT `wishlist_product_fk` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `wishlist_user_fk` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;