-- Eximpx Global eCommerce System Database Backup Dump
-- Generated on: Mon, 20 Jul 2026 19:30:07 GMT
-- Fully optimized for cPanel phpMyAdmin Import without foreign key constraint blocks.


-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR SETTINGS
-- -------------------------------------------------------------
CREATE TABLE `settings` (
  `key_name` varchar(100) NOT NULL,
  `value_content` longtext,
  PRIMARY KEY (`key_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('all_settings', '{"logoUrl":"data:image/png;base64,[encoded data, 57348 characters]","brandName":"Eximpx Global","brandSlogan":"Fruit & Vegetable Powder","whatsappNumber":"+91 92748 38389","contactEmail":"eximpx@gmail.com","contactPhone":"+91 92748 38389","address":"Eximpx Global ,41 Parishram  Industrial Hub, Chacharwadi-Vasna Road,Changodar, Ahemedabad ,Gujarat, India - 382213","favIconUrl":"","logoDesktopUrl":"","logoTabletUrl":"","logoMobileUrl":"","logoDarkModeUrl":"","logoLightModeUrl":"","logoHeaderUrl":"","logoFooterUrl":"","logoWidth":200,"logoHeight":80,"logoAlignment":"left","upiQrCodeUrl":"","authorisedSignatoryUrl":"","upiId":"eximpx@ybl","upiMerchantName":"Eximpx Global","upiQrImageUrl":"https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300","upiPaymentInstructions":"1. Scan the QR code or click an Intent button on mobile to pay.\\n2. Complete the payment inside your UPI app.\\n3. Enter the 12-digit UTR transaction reference number and upload the screenshot below.\\n4. Submit order and wait for manual verification.","upiFileLimitMb":5,"upiVerificationMessage":"Payment is awaiting verification. Order will move to processing as soon as our accounts desk confirms the transaction.","upiRotationMode":"priority","bankTransferEnabled":true,"bankAccountName":"Eximpx Global Private Limited","bankName":"","bankAccountNumber":"","bankBranchIfsc":"","bankBranchName":"","bankAccountType":"current","bankQrImageUrl":"https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300","bankPaymentInstructions":"1. Transfer the exact payable amount to the listed Bank Account via IMPS, NEFT, or RTGS.\\n2. Ensure the recipient name exactly matches our registered entity.\\n3. Note down the 12-digit transaction reference number / UTR.\\n4. Input the reference details and upload the screenshot of the confirmation page.","banners":["https://images.unsplash.com/photo-1498837167922-ddd27525d352?auto=format&fit=crop&q=80&w=1200","https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200"],"sliderEnabled":true,"sliderAutoplay":true,"sliderAutoplaySpeed":5000,"sliderLoop":true,"sliderTransition":"slide","sliderShowDots":true,"sliderShowArrows":true,"homeSlides":[{"id":"slide-1","badge":"🍎 Dehydrated Fruits","title":"Dehydrated Fruit Powders","subtitle":"Deliciously locked-in fiber matrixes, 100% natural, sugar-free, vacuum spray dried real fruit powders (Orange, Mango, Banana, Pineapple, Beetroot).","image":"https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Discover Fruit Powders ➔","primaryBtnLink":"catalog","secondaryBtnText":"Watch Sweet Recipes","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-2","badge":"🧅 Commercial Grade Quality","title":"Dehydrated Vegetable Powders","subtitle":"Export-grade dry Pink & White Onion, Garlic, Ginger, Tomato, and Carrot seasoning powders. FSSAI certified extraction with zero silica or added starches.","image":"https://images.unsplash.com/photo-1596040033229-a9821ebd058d?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Explore Vegetables ➔","primaryBtnLink":"catalog","secondaryBtnText":"Sourcing Standards","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-3","badge":"🌿 Wellness & Botanical Matrix","title":"Dehydrated Herbal Powders","subtitle":"High-density organic Moringa Oleifera leaf powder, Mint leaves, and lemongrass botanical ingredients extracted under strict clinical hygiene.","image":"https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Shop Botanical Herbs ➔","primaryBtnLink":"catalog","secondaryBtnText":"Check Lab Reports","secondaryBtnLink":"reels","alignment":"left","isActive":true}],"socialLinks":{"facebook":"https://facebook.com/eximpxglobal","instagram":"https://instagram.com/eximpx.global","youtube":"https://youtube.com/c/eximpxglobal"},"seo":{"title":"Eximpx Global | Dehydrated Fruit & Vegetable Food Powders","description":"Buy premium dehydrated onion powder, garlic powder, organic moringa, tangible beetroot, raw banana and tangy tropical mango food ingredients.","keywords":"onion powder, garlic powder, moringa, beetroot powder, dehydrated food ingredients, Eximpx Global, amchur powder India"},"googleClientId":"179225707163-3lpsraf12ih17gcvr6k9pkugkkl5uhe8.apps.googleusercontent.com","googleClientSecret":"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","firebaseApiKey":"AIzaSyADPVUZunHLjit7Swp2yEko756ahlQjO7w","firebaseAuthDomain":"eximpx-4048a.firebaseapp.com","firebaseProjectId":"eximpx-4048a","firebaseStorageBucket":"eximpx-4048a.firebasestorage.app","firebaseMessagingSenderId":"141125585021","firebaseAppId":"1:141125585021:web:7d252096a272026c164914","firebaseMeasurementId":"G-XH4TXF35Q5","googleLoginEnabled":true,"smtpHost":"mail.eximpx.com","smtpPort":465,"smtpSecure":true,"smtpUser":"info@eximpx.com","smtpPass":"Sunil@1438","smtpFrom":"info@eximpx.com","emailTemplateWelcomeSubject":"Welcome to {brandName}! 👋","emailTemplateWelcomeBody":"<h2 class=\\"title\\">Welcome to {brandName}! 👋</h2>\\n<p>Dear <strong>{customerName}</strong>,</p>\\n<p>Thank you for creating an account with us. Your registration on our {brandName} B2B Portal was successful.</p>\\n<div class=\\"highlight-card\\">\\n  <p style=\\"margin: 0; font-weight: bold;\\">🔐 Your Registered Account details:</p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Username / Email: <strong>{email}</strong></p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Status: <strong>Active Client Node</strong></p>\\n</div>\\n<p>We supply premium export-grade dehydrated fruits & vegetables, organic powders, spices, and custom agricultural ingredients. You can now login, access your dashboard, add products to your wishlist, track shipments live, and place bulk orders with exclusive checkout discounts.</p>\\n<a href=\\"https://wa.me/{whatsappNumber}\\" class=\\"button\\" style=\\"color: #ffffff;\\">Chat with B2B Sales Representative</a>\\n<p>Best Regards,<br><strong>The {brandName} Operations Desk</strong></p>","emailTemplateOrderCreatedSubject":"🛒 Order Received {orderNumber} — {brandName}","emailTemplateOrderCreatedBody":"<h2 class=\\"title\\">Order Received! Thank you for your purchase 🛒</h2>\\n<p>Dear <strong>{customerName}</strong>,</p>\\n<p>Your order <strong>{orderNumber}</strong> has been successfully placed. Our factory floor has reserved the selected batch variance for you.</p>\\n\\n<div class=\\"highlight-card\\">\\n  <p style=\\"margin:0;\\"><strong>Order Reference:</strong> {orderNumber}</p>\\n  <p style=\\"margin:4px 0 0 0;\\"><strong>Date Placed:</strong> {orderDate}</p>\\n  <p style=\\"margin:4px 0 0 0;\\"><strong>Payment Status:</strong> Pending Verification / Cash On Delivery</p>\\n  <p style=\\"margin:4px 0 0 0;\\"><strong>Shipping Destination Address:</strong> {shippingAddress}</p>\\n</div>\\n\\n<h3>Ordered Items Summary:</h3>\\n{itemsTable}\\n\\n<div style=\\"text-align: right; line-height: 1.8; margin-bottom: 20px;\\">\\n  <p style=\\"margin: 0; font-size: 11px; color: #475569;\\">Cart Subtotal: <strong>₹{totalAmount}</strong></p>\\n  <p style=\\"margin: 0; font-size: 11px; color: #475569;\\">Shipping & Courier Charge: <strong>₹{shippingCharge}</strong></p>\\n  {discountRow}\\n  <p style=\\"margin: 0; font-size: 14px; color: #1e293b; font-weight: 800;\\">Total Payable Amount: <strong>₹{payableAmount}</strong></p>\\n</div>\\n\\n<p>We are currently packing your export batch. Once your parcel is scanned and dispatched with our logistics partner, you will receive real-time shipment updates in your dashboard.</p>\\n<a href=\\"https://wa.me/{whatsappNumber}\\" class=\\"button\\" style=\\"color: #ffffff;\\">Quick Order Inquiry on WhatsApp</a>","emailTemplateOrderCancelledSubject":"🚫 Order Cancelled {orderNumber} — {brandName}","emailTemplateOrderCancelledBody":"<h2 class=\\"title\\" style=\\"color: #dc2626;\\">Order Cancelled 🚫</h2>\\n<p>Dear <strong>{customerName}</strong>,</p>\\n<p>We would like to inform you that your order <strong>{orderNumber}</strong> has been cancelled.</p>\\n\\n<div class=\\"highlight-card\\" style=\\"background-color: #fef2f2; border-color: #fca5a5;\\">\\n  <p style=\\"margin: 0; color: #991b1b; font-weight: bold;\\">📉 Cancellation Record:</p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Order Number: <strong>{orderNumber}</strong></p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Payable Amount: <strong>₹{payableAmount}</strong></p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Status: <strong style=\\"color: #b91c1c;\\">Cancelled & Refund Pending (if prepaid)</strong></p>\\n</div>\\n\\n<p>If you did not request this cancellation or if you have any questions regarding your refund processing, please get in touch with our Sales Support team immediately via the button below.</p>\\n<a href=\\"https://wa.me/{whatsappNumber}\\" class=\\"button\\" style=\\"background-color: #dc2626; color: #ffffff;\\">Discuss Cancellation Support</a>\\n<p>We apologize for any inconvenience caused.</p>","emailTemplateOrderDeliveredSubject":"✅ Safely Delivered {orderNumber} — {brandName}","emailTemplateOrderDeliveredBody":"<h2 class=\\"title\\">Delivered successfully! Enjoy your Agri-Foods! 🎉</h2>\\n<p>Dear <strong>{customerName}</strong>,</p>\\n<p>Great news! Our courier partner has confirmed that your package for order <strong>{orderNumber}</strong> has been safely delivered.</p>\\n\\n<div class=\\"highlight-card\\">\\n  <p style=\\"margin: 0; font-weight: bold;\\">✅ Shipping Handover Metrics:</p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Order Reference: <strong>{orderNumber}</strong></p>\\n  <p style=\\"margin: 4px 0 0 0;\\">Courier Partner: <strong>{courierCompany}</strong></p>\\n  {trackingNumber}\\n  <p style=\\"margin: 4px 0 0 0;\\">Handover Location: <strong>{shippingAddress}</strong></p>\\n</div>\\n\\n<p>We hope you are thrilled with the premium aroma, fresh dehydration grade, and robust nutrition of our agricultural products. Please log in to leave your feedback and share your reviews!</p>\\n\\n<a href=\\"https://wa.me/{whatsappNumber}\\" class=\\"button\\" style=\\"color: #ffffff;\\">Contact Support / Reorder</a>\\n<p>Thank you for choosing {brandName} for your ingredient needs!</p>","whatsappOrderTemplate":"🌱 *{brandName} — ORDER INQUIRY* 🌱\\n*Order Reference:* {orderNumber}\\n*Date:* {orderDate}\\n\\n*Customer Details:*\\n• Name: {customerName}\\n• Phone: {customerPhone}\\n• Shipping Address: {shippingAddress}\\n\\n*Ordered Powders:*\\n{cartSummary}\\n\\n💸 *Cost Summary:*\\n• Subtotal Amount: ₹{subTotalAmount}\\n• Applied Promotions: -₹{discountAmount}\\n*Total Payable Amount: ₹{payableAmount}*\\n\\n_Order Notes:_ {orderNotes}\\n------------------------------------------------\\nPlease fulfill our order. Thank you!","themePreset":"emerald","primaryColor":"#16a34a","secondaryColor":"#f97316","buttonRoundness":"md","cardStyle":"bordered","fontTheme":"sans","gstNumber":"24AAMFE8487F1Z1","fssaiNumber":"10726994000499","invoiceFormatStyle":"modern-green","labelFormatStyle":"modern-badge","invoiceTermsAndConditions":"","includeLogoInDocuments":true,"headerBgColor":"#ffffff","headerTextColor":"#15803d","headerShowLogoOnly":true,"headerTopBannerText":"🎉 Fast Delivery: Free shipping on orders over ₹999! WhatsApp orders supported: +91 92748 38389","headerTopBannerBg":"","footerBgColor":"#111827","footerTextColor":"#9ca3af","footerNewsletterTitle":"Newsletter","footerShowFarmerSupport":true,"footerLayout":"classic","footerShortAboutText":"Eximpx Global is a leading exporter and vendor of premium food-grade dehydrated fruit and vegetable nutritional powders, preserving vitamins, colors, and raw aroma naturally.","footerShowCertifications":true,"footerCustomCopyright":"© {year} {brandName}. All rights reserved. Registered Indian Agri Exporter.","footerMadeWithText":"for dry food ingredients & sustainable agriculture exports.","pwaDownloadUrl":"https://eximpx.com/download-pwa","heroTitle":"","heroSubtitle":"","heroBadge":"","heroPrimaryBtnText":"","heroSecondaryBtnText":"","heroBgGradientStart":"#064e3b","heroBgGradientEnd":"#022c22","heroHeight":"medium","googleConsoleVerificationTag":"","bingVerificationTag":"","pinterestVerificationTag":"","yandexVerificationTag":"","sitemapExcludedPages":["admin","profile"],"sitemapIncludeProducts":true,"sitemapIncludeCategories":true,"sitemapIncludeBlogs":true,"globalPackingSizes":["50g","100g","250g","500g","1kg"],"globalWeights":["50g","100g","250g","500g","1kg","5kg","10kg"],"globalColors":["Natural Green","Sun Orange","Amber Yellow","Pure White","Deep Red","Golden Peach"],"globalProductAttributes":[{"id":"attr-1","name":"Standard Packing Size","type":"size","values":["50g","100g","250g","500g","1kg"],"enabled":true},{"id":"attr-2","name":"Clothing Size","type":"size","values":["S","M","L","XL","XXL"],"enabled":true},{"id":"attr-3","name":"Waist Size","type":"custom","values":["28","30","32","34","36"],"enabled":true},{"id":"attr-4","name":"Product Accents / Shades","type":"color","values":["Natural Green","Deep Red","Pure White","Satin Black","Golden Peach"],"enabled":true}],"freeShippingThreshold":999,"globalShippingCharge":60,"cpanelHost":"https://xo.india.ke:2083/","cpanelUser":"adhyamart","cpanelPass":"Sheetal@1438","sqlDbHost":"localhost","sqlDbName":"adhyamart_eximpx","sqlDbUser":"adhyamart_eximpx","sqlDbPass":"Sunil@1438","sqlDbPort":3306,"sqlDbPrefix":"","ftpHost":"ftp.eximpx.com","ftpUser":"eximpx_ftp","ftpPass":"","ftpPort":21,"geminiApiKey":"AQ.Ab8RN6KkDJNwzLItTBI4zc_CPAw80S--OC9nJMyuPlwdlZLVbw","geminiModelTone":"Professional & Storytelling","geminiModelPromptCustom":"","heroImageUrl":"","heroBannerOverlayColor":"rgba(0,0,0,0.4)","googlePixelId":"","facebookPixelId":"","additionalTrackingScripts":"","headerLayout":"classic","headerHeight":72,"headerEnableTopBanner":true,"headerTopBannerTextColor":"#ffffff","headerLogoSizing":120,"headerTopBannerActionUrl":"","pinterestPixelId":"","tiktokPixelId":"","googleTagManagerId":"","companyPan":"","autoBackupEnabled":false,"autoBackupInterval":"daily","aiDiscoveryEnabled":true,"aiGroundingSnippetType":"json-ld","googleShoppingFeedEnabled":true,"googleShoppingTargetCountry":"US","googleShoppingCurrency":"USD","googleShoppingDefaultCategory":"Food & Beverages","googleShoppingXmlUrl":"https://eximpx.com/api/feeds/google-shopping.xml","googleShoppingSelectedProducts":["garlic","onion","moringa"],"googleShoppingFeedFilterType":"all","showNutritionalFacts":true,"dbConnectionMode":"env","backupRetentionLimit":10}');
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoUrl', 'data:image/png;base64,[encoded data, 57348 characters]') ON DUPLICATE KEY UPDATE `value_content` = 'data:image/png;base64,[encoded data, 57348 characters]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('brandName', 'Eximpx Global') ON DUPLICATE KEY UPDATE `value_content` = 'Eximpx Global';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('brandSlogan', 'Fruit & Vegetable Powder') ON DUPLICATE KEY UPDATE `value_content` = 'Fruit & Vegetable Powder';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('whatsappNumber', '+91 92748 38389') ON DUPLICATE KEY UPDATE `value_content` = '+91 92748 38389';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('contactEmail', 'eximpx@gmail.com') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx@gmail.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('contactPhone', '+91 92748 38389') ON DUPLICATE KEY UPDATE `value_content` = '+91 92748 38389';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('address', 'Eximpx Global ,41 Parishram  Industrial Hub, Chacharwadi-Vasna Road,Changodar, Ahemedabad ,Gujarat, India - 382213') ON DUPLICATE KEY UPDATE `value_content` = 'Eximpx Global ,41 Parishram  Industrial Hub, Chacharwadi-Vasna Road,Changodar, Ahemedabad ,Gujarat, India - 382213';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('favIconUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoDesktopUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoTabletUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoMobileUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoDarkModeUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoLightModeUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoHeaderUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoFooterUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoWidth', '200') ON DUPLICATE KEY UPDATE `value_content` = '200';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoHeight', '80') ON DUPLICATE KEY UPDATE `value_content` = '80';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('logoAlignment', 'left') ON DUPLICATE KEY UPDATE `value_content` = 'left';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiQrCodeUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('authorisedSignatoryUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiId', 'eximpx@ybl') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx@ybl';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiMerchantName', 'Eximpx Global') ON DUPLICATE KEY UPDATE `value_content` = 'Eximpx Global';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiQrImageUrl', 'https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300') ON DUPLICATE KEY UPDATE `value_content` = 'https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiPaymentInstructions', '1. Scan the QR code or click an Intent button on mobile to pay.
2. Complete the payment inside your UPI app.
3. Enter the 12-digit UTR transaction reference number and upload the screenshot below.
4. Submit order and wait for manual verification.') ON DUPLICATE KEY UPDATE `value_content` = '1. Scan the QR code or click an Intent button on mobile to pay.
2. Complete the payment inside your UPI app.
3. Enter the 12-digit UTR transaction reference number and upload the screenshot below.
4. Submit order and wait for manual verification.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiFileLimitMb', '5') ON DUPLICATE KEY UPDATE `value_content` = '5';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiVerificationMessage', 'Payment is awaiting verification. Order will move to processing as soon as our accounts desk confirms the transaction.') ON DUPLICATE KEY UPDATE `value_content` = 'Payment is awaiting verification. Order will move to processing as soon as our accounts desk confirms the transaction.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('upiRotationMode', 'priority') ON DUPLICATE KEY UPDATE `value_content` = 'priority';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankTransferEnabled', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankAccountName', 'Eximpx Global Private Limited') ON DUPLICATE KEY UPDATE `value_content` = 'Eximpx Global Private Limited';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankName', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankAccountNumber', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankBranchIfsc', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankBranchName', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankAccountType', 'current') ON DUPLICATE KEY UPDATE `value_content` = 'current';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankQrImageUrl', 'https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300') ON DUPLICATE KEY UPDATE `value_content` = 'https://images.unsplash.com/photo-1595079676339-1534801ad6cf?auto=format&fit=crop&q=80&w=300';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bankPaymentInstructions', '1. Transfer the exact payable amount to the listed Bank Account via IMPS, NEFT, or RTGS.
2. Ensure the recipient name exactly matches our registered entity.
3. Note down the 12-digit transaction reference number / UTR.
4. Input the reference details and upload the screenshot of the confirmation page.') ON DUPLICATE KEY UPDATE `value_content` = '1. Transfer the exact payable amount to the listed Bank Account via IMPS, NEFT, or RTGS.
2. Ensure the recipient name exactly matches our registered entity.
3. Note down the 12-digit transaction reference number / UTR.
4. Input the reference details and upload the screenshot of the confirmation page.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('banners', '["https://images.unsplash.com/photo-1498837167922-ddd27525d352?auto=format&fit=crop&q=80&w=1200","https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200"]') ON DUPLICATE KEY UPDATE `value_content` = '["https://images.unsplash.com/photo-1498837167922-ddd27525d352?auto=format&fit=crop&q=80&w=1200","https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderEnabled', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderAutoplay', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderAutoplaySpeed', '5000') ON DUPLICATE KEY UPDATE `value_content` = '5000';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderLoop', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderTransition', 'slide') ON DUPLICATE KEY UPDATE `value_content` = 'slide';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderShowDots', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sliderShowArrows', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('homeSlides', '[{"id":"slide-1","badge":"🍎 Dehydrated Fruits","title":"Dehydrated Fruit Powders","subtitle":"Deliciously locked-in fiber matrixes, 100% natural, sugar-free, vacuum spray dried real fruit powders (Orange, Mango, Banana, Pineapple, Beetroot).","image":"https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Discover Fruit Powders ➔","primaryBtnLink":"catalog","secondaryBtnText":"Watch Sweet Recipes","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-2","badge":"🧅 Commercial Grade Quality","title":"Dehydrated Vegetable Powders","subtitle":"Export-grade dry Pink & White Onion, Garlic, Ginger, Tomato, and Carrot seasoning powders. FSSAI certified extraction with zero silica or added starches.","image":"https://images.unsplash.com/photo-1596040033229-a9821ebd058d?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Explore Vegetables ➔","primaryBtnLink":"catalog","secondaryBtnText":"Sourcing Standards","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-3","badge":"🌿 Wellness & Botanical Matrix","title":"Dehydrated Herbal Powders","subtitle":"High-density organic Moringa Oleifera leaf powder, Mint leaves, and lemongrass botanical ingredients extracted under strict clinical hygiene.","image":"https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Shop Botanical Herbs ➔","primaryBtnLink":"catalog","secondaryBtnText":"Check Lab Reports","secondaryBtnLink":"reels","alignment":"left","isActive":true}]') ON DUPLICATE KEY UPDATE `value_content` = '[{"id":"slide-1","badge":"🍎 Dehydrated Fruits","title":"Dehydrated Fruit Powders","subtitle":"Deliciously locked-in fiber matrixes, 100% natural, sugar-free, vacuum spray dried real fruit powders (Orange, Mango, Banana, Pineapple, Beetroot).","image":"https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Discover Fruit Powders ➔","primaryBtnLink":"catalog","secondaryBtnText":"Watch Sweet Recipes","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-2","badge":"🧅 Commercial Grade Quality","title":"Dehydrated Vegetable Powders","subtitle":"Export-grade dry Pink & White Onion, Garlic, Ginger, Tomato, and Carrot seasoning powders. FSSAI certified extraction with zero silica or added starches.","image":"https://images.unsplash.com/photo-1596040033229-a9821ebd058d?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Explore Vegetables ➔","primaryBtnLink":"catalog","secondaryBtnText":"Sourcing Standards","secondaryBtnLink":"reels","alignment":"left","isActive":true},{"id":"slide-3","badge":"🌿 Wellness & Botanical Matrix","title":"Dehydrated Herbal Powders","subtitle":"High-density organic Moringa Oleifera leaf powder, Mint leaves, and lemongrass botanical ingredients extracted under strict clinical hygiene.","image":"https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=1200","primaryBtnText":"Shop Botanical Herbs ➔","primaryBtnLink":"catalog","secondaryBtnText":"Check Lab Reports","secondaryBtnLink":"reels","alignment":"left","isActive":true}]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('socialLinks', '{"facebook":"https://facebook.com/eximpxglobal","instagram":"https://instagram.com/eximpx.global","youtube":"https://youtube.com/c/eximpxglobal"}') ON DUPLICATE KEY UPDATE `value_content` = '{"facebook":"https://facebook.com/eximpxglobal","instagram":"https://instagram.com/eximpx.global","youtube":"https://youtube.com/c/eximpxglobal"}';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('seo', '{"title":"Eximpx Global | Dehydrated Fruit & Vegetable Food Powders","description":"Buy premium dehydrated onion powder, garlic powder, organic moringa, tangible beetroot, raw banana and tangy tropical mango food ingredients.","keywords":"onion powder, garlic powder, moringa, beetroot powder, dehydrated food ingredients, Eximpx Global, amchur powder India"}') ON DUPLICATE KEY UPDATE `value_content` = '{"title":"Eximpx Global | Dehydrated Fruit & Vegetable Food Powders","description":"Buy premium dehydrated onion powder, garlic powder, organic moringa, tangible beetroot, raw banana and tangy tropical mango food ingredients.","keywords":"onion powder, garlic powder, moringa, beetroot powder, dehydrated food ingredients, Eximpx Global, amchur powder India"}';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleClientId', '179225707163-3lpsraf12ih17gcvr6k9pkugkkl5uhe8.apps.googleusercontent.com') ON DUPLICATE KEY UPDATE `value_content` = '179225707163-3lpsraf12ih17gcvr6k9pkugkkl5uhe8.apps.googleusercontent.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleClientSecret', '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') ON DUPLICATE KEY UPDATE `value_content` = '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';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseApiKey', 'AIzaSyADPVUZunHLjit7Swp2yEko756ahlQjO7w') ON DUPLICATE KEY UPDATE `value_content` = 'AIzaSyADPVUZunHLjit7Swp2yEko756ahlQjO7w';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseAuthDomain', 'eximpx-4048a.firebaseapp.com') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx-4048a.firebaseapp.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseProjectId', 'eximpx-4048a') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx-4048a';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseStorageBucket', 'eximpx-4048a.firebasestorage.app') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx-4048a.firebasestorage.app';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseMessagingSenderId', '141125585021') ON DUPLICATE KEY UPDATE `value_content` = '141125585021';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseAppId', '1:141125585021:web:7d252096a272026c164914') ON DUPLICATE KEY UPDATE `value_content` = '1:141125585021:web:7d252096a272026c164914';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('firebaseMeasurementId', 'G-XH4TXF35Q5') ON DUPLICATE KEY UPDATE `value_content` = 'G-XH4TXF35Q5';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleLoginEnabled', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpHost', 'mail.eximpx.com') ON DUPLICATE KEY UPDATE `value_content` = 'mail.eximpx.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpPort', '465') ON DUPLICATE KEY UPDATE `value_content` = '465';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpSecure', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpUser', 'info@eximpx.com') ON DUPLICATE KEY UPDATE `value_content` = 'info@eximpx.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpPass', 'Sunil@1438') ON DUPLICATE KEY UPDATE `value_content` = 'Sunil@1438';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('smtpFrom', 'info@eximpx.com') ON DUPLICATE KEY UPDATE `value_content` = 'info@eximpx.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateWelcomeSubject', 'Welcome to {brandName}! 👋') ON DUPLICATE KEY UPDATE `value_content` = 'Welcome to {brandName}! 👋';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateWelcomeBody', '<h2 class="title">Welcome to {brandName}! 👋</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Thank you for creating an account with us. Your registration on our {brandName} B2B Portal was successful.</p>
<div class="highlight-card">
  <p style="margin: 0; font-weight: bold;">🔐 Your Registered Account details:</p>
  <p style="margin: 4px 0 0 0;">Username / Email: <strong>{email}</strong></p>
  <p style="margin: 4px 0 0 0;">Status: <strong>Active Client Node</strong></p>
</div>
<p>We supply premium export-grade dehydrated fruits & vegetables, organic powders, spices, and custom agricultural ingredients. You can now login, access your dashboard, add products to your wishlist, track shipments live, and place bulk orders with exclusive checkout discounts.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Chat with B2B Sales Representative</a>
<p>Best Regards,<br><strong>The {brandName} Operations Desk</strong></p>') ON DUPLICATE KEY UPDATE `value_content` = '<h2 class="title">Welcome to {brandName}! 👋</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Thank you for creating an account with us. Your registration on our {brandName} B2B Portal was successful.</p>
<div class="highlight-card">
  <p style="margin: 0; font-weight: bold;">🔐 Your Registered Account details:</p>
  <p style="margin: 4px 0 0 0;">Username / Email: <strong>{email}</strong></p>
  <p style="margin: 4px 0 0 0;">Status: <strong>Active Client Node</strong></p>
</div>
<p>We supply premium export-grade dehydrated fruits & vegetables, organic powders, spices, and custom agricultural ingredients. You can now login, access your dashboard, add products to your wishlist, track shipments live, and place bulk orders with exclusive checkout discounts.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Chat with B2B Sales Representative</a>
<p>Best Regards,<br><strong>The {brandName} Operations Desk</strong></p>';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderCreatedSubject', '🛒 Order Received {orderNumber} — {brandName}') ON DUPLICATE KEY UPDATE `value_content` = '🛒 Order Received {orderNumber} — {brandName}';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderCreatedBody', '<h2 class="title">Order Received! Thank you for your purchase 🛒</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Your order <strong>{orderNumber}</strong> has been successfully placed. Our factory floor has reserved the selected batch variance for you.</p>

<div class="highlight-card">
  <p style="margin:0;"><strong>Order Reference:</strong> {orderNumber}</p>
  <p style="margin:4px 0 0 0;"><strong>Date Placed:</strong> {orderDate}</p>
  <p style="margin:4px 0 0 0;"><strong>Payment Status:</strong> Pending Verification / Cash On Delivery</p>
  <p style="margin:4px 0 0 0;"><strong>Shipping Destination Address:</strong> {shippingAddress}</p>
</div>

<h3>Ordered Items Summary:</h3>
{itemsTable}

<div style="text-align: right; line-height: 1.8; margin-bottom: 20px;">
  <p style="margin: 0; font-size: 11px; color: #475569;">Cart Subtotal: <strong>₹{totalAmount}</strong></p>
  <p style="margin: 0; font-size: 11px; color: #475569;">Shipping & Courier Charge: <strong>₹{shippingCharge}</strong></p>
  {discountRow}
  <p style="margin: 0; font-size: 14px; color: #1e293b; font-weight: 800;">Total Payable Amount: <strong>₹{payableAmount}</strong></p>
</div>

<p>We are currently packing your export batch. Once your parcel is scanned and dispatched with our logistics partner, you will receive real-time shipment updates in your dashboard.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Quick Order Inquiry on WhatsApp</a>') ON DUPLICATE KEY UPDATE `value_content` = '<h2 class="title">Order Received! Thank you for your purchase 🛒</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Your order <strong>{orderNumber}</strong> has been successfully placed. Our factory floor has reserved the selected batch variance for you.</p>

<div class="highlight-card">
  <p style="margin:0;"><strong>Order Reference:</strong> {orderNumber}</p>
  <p style="margin:4px 0 0 0;"><strong>Date Placed:</strong> {orderDate}</p>
  <p style="margin:4px 0 0 0;"><strong>Payment Status:</strong> Pending Verification / Cash On Delivery</p>
  <p style="margin:4px 0 0 0;"><strong>Shipping Destination Address:</strong> {shippingAddress}</p>
</div>

<h3>Ordered Items Summary:</h3>
{itemsTable}

<div style="text-align: right; line-height: 1.8; margin-bottom: 20px;">
  <p style="margin: 0; font-size: 11px; color: #475569;">Cart Subtotal: <strong>₹{totalAmount}</strong></p>
  <p style="margin: 0; font-size: 11px; color: #475569;">Shipping & Courier Charge: <strong>₹{shippingCharge}</strong></p>
  {discountRow}
  <p style="margin: 0; font-size: 14px; color: #1e293b; font-weight: 800;">Total Payable Amount: <strong>₹{payableAmount}</strong></p>
</div>

<p>We are currently packing your export batch. Once your parcel is scanned and dispatched with our logistics partner, you will receive real-time shipment updates in your dashboard.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Quick Order Inquiry on WhatsApp</a>';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderCancelledSubject', '🚫 Order Cancelled {orderNumber} — {brandName}') ON DUPLICATE KEY UPDATE `value_content` = '🚫 Order Cancelled {orderNumber} — {brandName}';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderCancelledBody', '<h2 class="title" style="color: #dc2626;">Order Cancelled 🚫</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>We would like to inform you that your order <strong>{orderNumber}</strong> has been cancelled.</p>

<div class="highlight-card" style="background-color: #fef2f2; border-color: #fca5a5;">
  <p style="margin: 0; color: #991b1b; font-weight: bold;">📉 Cancellation Record:</p>
  <p style="margin: 4px 0 0 0;">Order Number: <strong>{orderNumber}</strong></p>
  <p style="margin: 4px 0 0 0;">Payable Amount: <strong>₹{payableAmount}</strong></p>
  <p style="margin: 4px 0 0 0;">Status: <strong style="color: #b91c1c;">Cancelled & Refund Pending (if prepaid)</strong></p>
</div>

<p>If you did not request this cancellation or if you have any questions regarding your refund processing, please get in touch with our Sales Support team immediately via the button below.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="background-color: #dc2626; color: #ffffff;">Discuss Cancellation Support</a>
<p>We apologize for any inconvenience caused.</p>') ON DUPLICATE KEY UPDATE `value_content` = '<h2 class="title" style="color: #dc2626;">Order Cancelled 🚫</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>We would like to inform you that your order <strong>{orderNumber}</strong> has been cancelled.</p>

<div class="highlight-card" style="background-color: #fef2f2; border-color: #fca5a5;">
  <p style="margin: 0; color: #991b1b; font-weight: bold;">📉 Cancellation Record:</p>
  <p style="margin: 4px 0 0 0;">Order Number: <strong>{orderNumber}</strong></p>
  <p style="margin: 4px 0 0 0;">Payable Amount: <strong>₹{payableAmount}</strong></p>
  <p style="margin: 4px 0 0 0;">Status: <strong style="color: #b91c1c;">Cancelled & Refund Pending (if prepaid)</strong></p>
</div>

<p>If you did not request this cancellation or if you have any questions regarding your refund processing, please get in touch with our Sales Support team immediately via the button below.</p>
<a href="https://wa.me/{whatsappNumber}" class="button" style="background-color: #dc2626; color: #ffffff;">Discuss Cancellation Support</a>
<p>We apologize for any inconvenience caused.</p>';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderDeliveredSubject', '✅ Safely Delivered {orderNumber} — {brandName}') ON DUPLICATE KEY UPDATE `value_content` = '✅ Safely Delivered {orderNumber} — {brandName}';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('emailTemplateOrderDeliveredBody', '<h2 class="title">Delivered successfully! Enjoy your Agri-Foods! 🎉</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Great news! Our courier partner has confirmed that your package for order <strong>{orderNumber}</strong> has been safely delivered.</p>

<div class="highlight-card">
  <p style="margin: 0; font-weight: bold;">✅ Shipping Handover Metrics:</p>
  <p style="margin: 4px 0 0 0;">Order Reference: <strong>{orderNumber}</strong></p>
  <p style="margin: 4px 0 0 0;">Courier Partner: <strong>{courierCompany}</strong></p>
  {trackingNumber}
  <p style="margin: 4px 0 0 0;">Handover Location: <strong>{shippingAddress}</strong></p>
</div>

<p>We hope you are thrilled with the premium aroma, fresh dehydration grade, and robust nutrition of our agricultural products. Please log in to leave your feedback and share your reviews!</p>

<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Contact Support / Reorder</a>
<p>Thank you for choosing {brandName} for your ingredient needs!</p>') ON DUPLICATE KEY UPDATE `value_content` = '<h2 class="title">Delivered successfully! Enjoy your Agri-Foods! 🎉</h2>
<p>Dear <strong>{customerName}</strong>,</p>
<p>Great news! Our courier partner has confirmed that your package for order <strong>{orderNumber}</strong> has been safely delivered.</p>

<div class="highlight-card">
  <p style="margin: 0; font-weight: bold;">✅ Shipping Handover Metrics:</p>
  <p style="margin: 4px 0 0 0;">Order Reference: <strong>{orderNumber}</strong></p>
  <p style="margin: 4px 0 0 0;">Courier Partner: <strong>{courierCompany}</strong></p>
  {trackingNumber}
  <p style="margin: 4px 0 0 0;">Handover Location: <strong>{shippingAddress}</strong></p>
</div>

<p>We hope you are thrilled with the premium aroma, fresh dehydration grade, and robust nutrition of our agricultural products. Please log in to leave your feedback and share your reviews!</p>

<a href="https://wa.me/{whatsappNumber}" class="button" style="color: #ffffff;">Contact Support / Reorder</a>
<p>Thank you for choosing {brandName} for your ingredient needs!</p>';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('whatsappOrderTemplate', '🌱 *{brandName} — ORDER INQUIRY* 🌱
*Order Reference:* {orderNumber}
*Date:* {orderDate}

*Customer Details:*
• Name: {customerName}
• Phone: {customerPhone}
• Shipping Address: {shippingAddress}

*Ordered Powders:*
{cartSummary}

💸 *Cost Summary:*
• Subtotal Amount: ₹{subTotalAmount}
• Applied Promotions: -₹{discountAmount}
*Total Payable Amount: ₹{payableAmount}*

_Order Notes:_ {orderNotes}
------------------------------------------------
Please fulfill our order. Thank you!') ON DUPLICATE KEY UPDATE `value_content` = '🌱 *{brandName} — ORDER INQUIRY* 🌱
*Order Reference:* {orderNumber}
*Date:* {orderDate}

*Customer Details:*
• Name: {customerName}
• Phone: {customerPhone}
• Shipping Address: {shippingAddress}

*Ordered Powders:*
{cartSummary}

💸 *Cost Summary:*
• Subtotal Amount: ₹{subTotalAmount}
• Applied Promotions: -₹{discountAmount}
*Total Payable Amount: ₹{payableAmount}*

_Order Notes:_ {orderNotes}
------------------------------------------------
Please fulfill our order. Thank you!';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('themePreset', 'emerald') ON DUPLICATE KEY UPDATE `value_content` = 'emerald';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('primaryColor', '#16a34a') ON DUPLICATE KEY UPDATE `value_content` = '#16a34a';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('secondaryColor', '#f97316') ON DUPLICATE KEY UPDATE `value_content` = '#f97316';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('buttonRoundness', 'md') ON DUPLICATE KEY UPDATE `value_content` = 'md';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('cardStyle', 'bordered') ON DUPLICATE KEY UPDATE `value_content` = 'bordered';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('fontTheme', 'sans') ON DUPLICATE KEY UPDATE `value_content` = 'sans';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('gstNumber', '24AAMFE8487F1Z1') ON DUPLICATE KEY UPDATE `value_content` = '24AAMFE8487F1Z1';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('fssaiNumber', '10726994000499') ON DUPLICATE KEY UPDATE `value_content` = '10726994000499';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('invoiceFormatStyle', 'modern-green') ON DUPLICATE KEY UPDATE `value_content` = 'modern-green';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('labelFormatStyle', 'modern-badge') ON DUPLICATE KEY UPDATE `value_content` = 'modern-badge';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('invoiceTermsAndConditions', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('includeLogoInDocuments', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerBgColor', '#ffffff') ON DUPLICATE KEY UPDATE `value_content` = '#ffffff';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerTextColor', '#15803d') ON DUPLICATE KEY UPDATE `value_content` = '#15803d';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerShowLogoOnly', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerTopBannerText', '🎉 Fast Delivery: Free shipping on orders over ₹999! WhatsApp orders supported: +91 92748 38389') ON DUPLICATE KEY UPDATE `value_content` = '🎉 Fast Delivery: Free shipping on orders over ₹999! WhatsApp orders supported: +91 92748 38389';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerTopBannerBg', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerBgColor', '#111827') ON DUPLICATE KEY UPDATE `value_content` = '#111827';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerTextColor', '#9ca3af') ON DUPLICATE KEY UPDATE `value_content` = '#9ca3af';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerNewsletterTitle', 'Newsletter') ON DUPLICATE KEY UPDATE `value_content` = 'Newsletter';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerShowFarmerSupport', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerLayout', 'classic') ON DUPLICATE KEY UPDATE `value_content` = 'classic';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerShortAboutText', 'Eximpx Global is a leading exporter and vendor of premium food-grade dehydrated fruit and vegetable nutritional powders, preserving vitamins, colors, and raw aroma naturally.') ON DUPLICATE KEY UPDATE `value_content` = 'Eximpx Global is a leading exporter and vendor of premium food-grade dehydrated fruit and vegetable nutritional powders, preserving vitamins, colors, and raw aroma naturally.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerShowCertifications', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerCustomCopyright', '© {year} {brandName}. All rights reserved. Registered Indian Agri Exporter.') ON DUPLICATE KEY UPDATE `value_content` = '© {year} {brandName}. All rights reserved. Registered Indian Agri Exporter.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('footerMadeWithText', 'for dry food ingredients & sustainable agriculture exports.') ON DUPLICATE KEY UPDATE `value_content` = 'for dry food ingredients & sustainable agriculture exports.';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('pwaDownloadUrl', 'https://eximpx.com/download-pwa') ON DUPLICATE KEY UPDATE `value_content` = 'https://eximpx.com/download-pwa';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroTitle', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroSubtitle', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroBadge', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroPrimaryBtnText', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroSecondaryBtnText', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroBgGradientStart', '#064e3b') ON DUPLICATE KEY UPDATE `value_content` = '#064e3b';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroBgGradientEnd', '#022c22') ON DUPLICATE KEY UPDATE `value_content` = '#022c22';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroHeight', 'medium') ON DUPLICATE KEY UPDATE `value_content` = 'medium';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleConsoleVerificationTag', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('bingVerificationTag', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('pinterestVerificationTag', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('yandexVerificationTag', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sitemapExcludedPages', '["admin","profile"]') ON DUPLICATE KEY UPDATE `value_content` = '["admin","profile"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sitemapIncludeProducts', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sitemapIncludeCategories', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sitemapIncludeBlogs', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('globalPackingSizes', '["50g","100g","250g","500g","1kg"]') ON DUPLICATE KEY UPDATE `value_content` = '["50g","100g","250g","500g","1kg"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('globalWeights', '["50g","100g","250g","500g","1kg","5kg","10kg"]') ON DUPLICATE KEY UPDATE `value_content` = '["50g","100g","250g","500g","1kg","5kg","10kg"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('globalColors', '["Natural Green","Sun Orange","Amber Yellow","Pure White","Deep Red","Golden Peach"]') ON DUPLICATE KEY UPDATE `value_content` = '["Natural Green","Sun Orange","Amber Yellow","Pure White","Deep Red","Golden Peach"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('globalProductAttributes', '[{"id":"attr-1","name":"Standard Packing Size","type":"size","values":["50g","100g","250g","500g","1kg"],"enabled":true},{"id":"attr-2","name":"Clothing Size","type":"size","values":["S","M","L","XL","XXL"],"enabled":true},{"id":"attr-3","name":"Waist Size","type":"custom","values":["28","30","32","34","36"],"enabled":true},{"id":"attr-4","name":"Product Accents / Shades","type":"color","values":["Natural Green","Deep Red","Pure White","Satin Black","Golden Peach"],"enabled":true}]') ON DUPLICATE KEY UPDATE `value_content` = '[{"id":"attr-1","name":"Standard Packing Size","type":"size","values":["50g","100g","250g","500g","1kg"],"enabled":true},{"id":"attr-2","name":"Clothing Size","type":"size","values":["S","M","L","XL","XXL"],"enabled":true},{"id":"attr-3","name":"Waist Size","type":"custom","values":["28","30","32","34","36"],"enabled":true},{"id":"attr-4","name":"Product Accents / Shades","type":"color","values":["Natural Green","Deep Red","Pure White","Satin Black","Golden Peach"],"enabled":true}]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('freeShippingThreshold', '999') ON DUPLICATE KEY UPDATE `value_content` = '999';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('globalShippingCharge', '60') ON DUPLICATE KEY UPDATE `value_content` = '60';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('cpanelHost', 'https://xo.india.ke:2083/') ON DUPLICATE KEY UPDATE `value_content` = 'https://xo.india.ke:2083/';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('cpanelUser', 'adhyamart') ON DUPLICATE KEY UPDATE `value_content` = 'adhyamart';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('cpanelPass', 'Sheetal@1438') ON DUPLICATE KEY UPDATE `value_content` = 'Sheetal@1438';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbHost', 'localhost') ON DUPLICATE KEY UPDATE `value_content` = 'localhost';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbName', 'adhyamart_eximpx') ON DUPLICATE KEY UPDATE `value_content` = 'adhyamart_eximpx';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbUser', 'adhyamart_eximpx') ON DUPLICATE KEY UPDATE `value_content` = 'adhyamart_eximpx';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbPass', 'Sunil@1438') ON DUPLICATE KEY UPDATE `value_content` = 'Sunil@1438';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbPort', '3306') ON DUPLICATE KEY UPDATE `value_content` = '3306';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('sqlDbPrefix', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('ftpHost', 'ftp.eximpx.com') ON DUPLICATE KEY UPDATE `value_content` = 'ftp.eximpx.com';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('ftpUser', 'eximpx_ftp') ON DUPLICATE KEY UPDATE `value_content` = 'eximpx_ftp';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('ftpPass', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('ftpPort', '21') ON DUPLICATE KEY UPDATE `value_content` = '21';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('geminiApiKey', 'AQ.Ab8RN6KkDJNwzLItTBI4zc_CPAw80S--OC9nJMyuPlwdlZLVbw') ON DUPLICATE KEY UPDATE `value_content` = 'AQ.Ab8RN6KkDJNwzLItTBI4zc_CPAw80S--OC9nJMyuPlwdlZLVbw';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('geminiModelTone', 'Professional & Storytelling') ON DUPLICATE KEY UPDATE `value_content` = 'Professional & Storytelling';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('geminiModelPromptCustom', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroImageUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('heroBannerOverlayColor', 'rgba(0,0,0,0.4)') ON DUPLICATE KEY UPDATE `value_content` = 'rgba(0,0,0,0.4)';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googlePixelId', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('facebookPixelId', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('additionalTrackingScripts', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerLayout', 'classic') ON DUPLICATE KEY UPDATE `value_content` = 'classic';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerHeight', '72') ON DUPLICATE KEY UPDATE `value_content` = '72';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerEnableTopBanner', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerTopBannerTextColor', '#ffffff') ON DUPLICATE KEY UPDATE `value_content` = '#ffffff';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerLogoSizing', '120') ON DUPLICATE KEY UPDATE `value_content` = '120';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('headerTopBannerActionUrl', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('pinterestPixelId', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('tiktokPixelId', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleTagManagerId', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('companyPan', '') ON DUPLICATE KEY UPDATE `value_content` = '';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('autoBackupEnabled', 'false') ON DUPLICATE KEY UPDATE `value_content` = 'false';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('autoBackupInterval', 'daily') ON DUPLICATE KEY UPDATE `value_content` = 'daily';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('aiDiscoveryEnabled', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('aiGroundingSnippetType', 'json-ld') ON DUPLICATE KEY UPDATE `value_content` = 'json-ld';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingFeedEnabled', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingTargetCountry', 'US') ON DUPLICATE KEY UPDATE `value_content` = 'US';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingCurrency', 'USD') ON DUPLICATE KEY UPDATE `value_content` = 'USD';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingDefaultCategory', 'Food & Beverages') ON DUPLICATE KEY UPDATE `value_content` = 'Food & Beverages';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingXmlUrl', 'https://eximpx.com/api/feeds/google-shopping.xml') ON DUPLICATE KEY UPDATE `value_content` = 'https://eximpx.com/api/feeds/google-shopping.xml';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingSelectedProducts', '["garlic","onion","moringa"]') ON DUPLICATE KEY UPDATE `value_content` = '["garlic","onion","moringa"]';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('googleShoppingFeedFilterType', 'all') ON DUPLICATE KEY UPDATE `value_content` = 'all';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('showNutritionalFacts', 'true') ON DUPLICATE KEY UPDATE `value_content` = 'true';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('dbConnectionMode', 'env') ON DUPLICATE KEY UPDATE `value_content` = 'env';
INSERT INTO `settings` (`key_name`, `value_content`) VALUES ('backupRetentionLimit', '10') ON DUPLICATE KEY UPDATE `value_content` = '10';

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR USERS
-- -------------------------------------------------------------
CREATE TABLE `users` (
  `id` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `role` varchar(50) NOT NULL DEFAULT 'customer',
  `permissions` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_idx` (`email`),
  KEY `role_idx` (`role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`, `permissions`, `created_at`) VALUES ('VWQOOLm8RagQg10aPtEGMdPHWiZ2', 'Sunil sonagara', 'sunilsonagara111@gmail.com', 'password123', 'admin', '[]', '2026-07-20T19:30:07.531Z');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR CATEGORIES
-- -------------------------------------------------------------
CREATE TABLE `categories` (
  `id` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(100) NOT NULL,
  `image` text DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slug_idx` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `categories` (`id`, `name`, `slug`, `image`) VALUES ('cat_veg', 'Dehydrated Vegetable Powders', 'vegetable-powders', 'https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=600');
INSERT INTO `categories` (`id`, `name`, `slug`, `image`) VALUES ('cat_fruit', 'Dehydrated Fruit Powders', 'fruit-powders', 'https://images.unsplash.com/photo-1573244514399-bf1ad13c126d?auto=format&fit=crop&q=80&w=600');
INSERT INTO `categories` (`id`, `name`, `slug`, `image`) VALUES ('cat_herbal', 'Herbal & Wellness Powders', 'herbal-powders', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=600');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR PRODUCTS
-- -------------------------------------------------------------
CREATE TABLE `products` (
  `id` varchar(50) NOT NULL,
  `sku` varchar(50) DEFAULT NULL,
  `name` varchar(150) NOT NULL,
  `description` text NOT NULL,
  `benefits` text DEFAULT NULL,
  `ingredients` varchar(255) NOT NULL,
  `nutrition_facts` text DEFAULT NULL,
  `usage_instructions` text DEFAULT NULL,
  `video_url` text DEFAULT NULL,
  `category_id` varchar(50) NOT NULL,
  `featured` tinyint(4) NOT NULL DEFAULT 0,
  `best_selling` tinyint(4) NOT NULL DEFAULT 0,
  `stock_status` varchar(20) NOT NULL DEFAULT 'instock',
  `hsn_code` varchar(50) DEFAULT NULL,
  `gst_rate` decimal(5,2) DEFAULT '0.00',
  `is_food` tinyint(4) NOT NULL DEFAULT 0,
  `is_simple` tinyint(4) NOT NULL DEFAULT 1,
  `keywords` text DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `badge` varchar(50) DEFAULT NULL,
  `hide_reviews` tinyint(4) NOT NULL DEFAULT 0,
  `variant_type` varchar(50) DEFAULT NULL,
  `shipping_rate` decimal(10,2) DEFAULT '0.00',
  `handling_cost` decimal(10,2) DEFAULT '0.00',
  `active` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_products_category` (`category_id`),
  CONSTRAINT `fk_products_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `product_variants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` varchar(50) NOT NULL,
  `size` varchar(50) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `stock` int(11) NOT NULL DEFAULT 0,
  `mrp` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `prod_size` (`product_id`,`size`),
  KEY `idx_variants_product` (`product_id`),
  CONSTRAINT `fk_variants_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `product_images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_id` varchar(50) NOT NULL,
  `image_url` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_images_product` (`product_id`),
  CONSTRAINT `fk_images_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_onion', '', 'Dehydrated Pink Onion Powder', 'Our Premium Dehydrated Pink Onion Powder is processed from fresh, premium-grade onions. It is a highly convenient seasoning with all the health benefits of raw onion including rich prebiotics and immune-boosting antioxidants.', '["100% natural with zero artificial color, flavor, or preservatives.","Saves preparation time; no cutting or tears.","Extremely long shelf-life with concentrated onion sweetness.","Excellent source of Vitamin C, calcium, and dietary fiber."]', '100% Pure Pink Onion', '{"calories":347,"protein":10.1,"carbohydrates":79.2,"fat":1,"fiber":8.9}', 'Add directly to gravies, soups, marinades, curries, dry rubs, and seasonings. 1 tbsp of Onion Powder equals 1 medium fresh onion.', 'https://assets.mixkit.co/videos/preview/mixkit-vegetables-chopped-on-a-wooden-board-40019-large.mp4', 'cat_veg', 1, 1, 'instock', '07129030', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_onion', '50g', 90, 120, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_onion', '100g', 160, 95, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_onion', '250g', 350, 65, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_onion', '500g', 600, 40, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_onion', '1kg', 1100, 20, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_onion', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=600');
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_onion', 'https://images.unsplash.com/photo-1508747703725-719ae2c13d4b?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_garlic', '', 'Dehydrated White Garlic Powder', 'Made from premium minced cloves, our White Garlic Powder delivers a pungent, savory aroma and deep flavor profile to any dish. Retains garlic’s heart-healthy compounds.', '["Rich in antibacterial Allicin.","Pure flavor without peeling or sticky fingers.","Blends uniformly without lumping.","Enhances cardiovascular health and lowers blood pressure."]', '100% Pure Domestic Garlic', '{"calories":"332 kcal","protein":"16.5g","carbohydrates":"72.7g","fat":"0.7g","fiber":"9.0g"}', 'Ideal for garlic bread, pasta sauces, meat marinades, garlic rice, or sprinkled over popcorn and roasted potatoes. Substitute 1/4 tsp of Garlic Powder for 1 fresh clove.', 'https://assets.mixkit.co/videos/preview/mixkit-top-view-of-garlic-heads-falling-on-a-table-40112-large.mp4', 'cat_veg', 1, 1, 'instock', '07129020', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_garlic', '50g', 110, 150, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_garlic', '100g', 190, 100, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_garlic', '250g', 420, 80, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_garlic', '500g', 750, 50, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_garlic', '1kg', 1350, 15, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_garlic', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=600');
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_garlic', 'https://images.unsplash.com/photo-1608797178974-15b35a61d121?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_ginger', '', 'Dehydrated Ginger Root Powder', 'Ground from sundried top-tier ginger rhizomes. This flavorful, warming ginger powder is highly versatile and renowned for its therapeutic and anti-inflammatory attributes.', '["Cures nausea and improves digestion with bioactive Gingerol.","Potent, warming aroma for dry seasoning mixtures.","Acts as a strong immunity shield.","Convenient replacement for bruised, rotting fresh ginger."]', '100% Natural Ginger Root', '{"calories":"335 kcal","protein":"8.9g","carbohydrates":"71.6g","fat":"4.2g","fiber":"14.1g"}', 'Stir into baking items (gingerbread, cookies), teas, smoothies, tea, or Asian stir-fry sauces. 1/2 tsp of Ginger Powder replaces 1 tbsp of fresh ginger paste.', 'https://assets.mixkit.co/videos/preview/mixkit-pouring-orange-ginger-juice-into-glasses-43844-large.mp4', 'cat_veg', 0, 1, 'instock', '09101110', 5, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_ginger', '50g', 95, 90, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_ginger', '100g', 175, 75, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_ginger', '250g', 380, 40, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_ginger', '500g', 680, 25, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_ginger', '1kg', 1250, 10, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_ginger', 'https://images.unsplash.com/photo-1615485290382-441e4d049cb5?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_moringa', '', 'Organic Moringa Oleifera Powder', 'Often called the "Miracle Tree", our Moringa Powder is powdered from shade-dried, high-vitality Moringa leaves. Jam-packed with active proteins, iron, calcium, and all 9 essential amino acids.', '["Top-tier energy booster without crash effect.","Supports outstanding skin complexion and detox pathways.","A dense source of multivitamins and minerals.","Fights inflammation and supports sugar regulation."]', '100% Hand-Picked Moringa Leaves', '{"calories":"205 kcal","protein":"27.1g","carbohydrates":"38.2g","fat":"2.3g","fiber":"19.2g"}', 'Blend 1-2 teaspoons daily into smoothies, fresh fruit juices, hot soups, salad dressings, or wellness lattes.', 'https://assets.mixkit.co/videos/preview/mixkit-spoon-scooping-out-powdered-munt-green-ingredients-41550-large.mp4', 'cat_herbal', 1, 0, 'instock', '12119022', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_moringa', '50g', 120, 160, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_moringa', '100g', 210, 110, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_moringa', '250g', 460, 70, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_moringa', '500g', 820, 45, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_moringa', '1kg', 1500, 22, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_moringa', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_beetroot', '', 'Premium Red Beetroot Powder', 'Perfectly dehydrated dark-red beetroots ground into fine powder. Retains natural nitrates that enhance blood circulation, oxygen transport, and cardiovascular endurance.', '["Natural food coloring dye without any additives.","Improves sports stamina and nitric oxide levels.","Sweet earthy taste that children and athletes love.","Assists liver function and detoxification."]', '100% Pure Red Beetroots', '{"calories":"350 kcal","protein":"11.0g","carbohydrates":"71.0g","fat":"1.1g","fiber":"12.0g"}', 'Fabulous for pre-workout energy juices, baking (cakes, red velvet), hummus, thick yogurt dips, and pink flatbreads.', 'https://assets.mixkit.co/videos/preview/mixkit-fresh-beetroot-sliced-into-water-splashing-43840-large.mp4', 'cat_veg', 1, 1, 'instock', '07129090', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_beetroot', '50g', 100, 140, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_beetroot', '100g', 180, 95, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_beetroot', '250g', 390, 65, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_beetroot', '500g', 710, 35, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_beetroot', '1kg', 1300, 18, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_beetroot', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_tomato', '', 'Tangy Dehydrated Tomato Powder', 'Made from vine-ripened deep red tomatoes. It is spray-dried to encapsulate the rich, absolute umami flavor, tangy aroma, and natural Lycopene antioxidants.', '["Provides quick, velvety thick tomato gravy in minutes.","Preservative-free color and high antioxidant content.","Consistent acid balance throughout the seasons.","Saves you from carrying heavy cans or dealing with squashy fruit."]', '100% Natural Vine Tomatoes', '{"calories":"302 kcal","protein":"12.9g","carbohydrates":"61.5g","fat":"1.9g","fiber":"11.4g"}', 'Perfect to make instant tomato soup, pizza and pasta sauces, tangy taco seasoning, salad toppings, or flavor marinades.', 'https://assets.mixkit.co/videos/preview/mixkit-making-of-a-fresh-salad-with-chopped-tomatoes-42403-large.mp4', 'cat_veg', 0, 0, 'instock', '07129090', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_tomato', '50g', 85, 110, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_tomato', '100g', 155, 85, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_tomato', '250g', 330, 55, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_tomato', '500g', 590, 30, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_tomato', '1kg', 1050, 12, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_tomato', 'https://images.unsplash.com/photo-1518977676601-b53f82aba655?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_spinach', '', 'Immunity Spinach Leaf Powder', 'Fresh organically cultured spinach foliage, fast-dehydrated to salvage the high concentrations of iron, potassium, folic acid, and chlorophyll.', '["Convenient way to consume green leafy nutrients daily.","No washing, boiling, or cleaning required.","Promotes ocular wellness and fights anemia.","Excellent base for nutrient supplementation."]', '100% Pesticide-Free Spinach Leaves', '{"calories":"298 kcal","protein":"28.5g","carbohydrates":"36.8g","fat":"2.5g","fiber":"21.0g"}', 'Stir directly into regular wheat flour, pancake mix, soup broth, breakfast porridge, or green power juices.', '', 'cat_veg', 0, 0, 'instock', '07129090', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_spinach', '50g', 90, 85, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_spinach', '100g', 160, 65, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_spinach', '250g', 350, 45, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_spinach', '500g', 620, 25, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_spinach', '1kg', 1150, 10, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_spinach', 'https://images.unsplash.com/photo-1576045057995-568f588f82fb?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_banana', '', 'Nutritious Raw Banana Powder', 'Prepared from raw, unripe green Cavendish bananas. Known for high resistant starch that boosts digestive microflora, and acts as a nutritious baby food ingredient.', '["Prebiotic wonder food for gut wellness.","Excellent gluten-free binding starch for baking.","Fosters optimal infant digestive development.","Packed with potassium and magnesium electrolytes."]', '100% Dehydrated Raw Green Banana', '{"calories":"346 kcal","protein":"3.5g","carbohydrates":"82.0g","fat":"0.5g","fiber":"7.5g"}', 'Widely used to cook baby porridges, gluten-free flatbread, healthy wheat replacements, puddings, or thickening morning smoothies.', 'https://assets.mixkit.co/videos/preview/mixkit-slicing-various-peeled-bananas-43831-large.mp4', 'cat_fruit', 0, 0, 'instock', '11063010', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_banana', '50g', 80, 120, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_banana', '100g', 145, 95, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_banana', '250g', 310, 60, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_banana', '500g', 550, 40, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_banana', '1kg', 990, 15, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_banana', 'https://images.unsplash.com/photo-1571771894821-ce9b6c11b08e?auto=format&fit=crop&q=80&w=600');
INSERT INTO `products` (`id`, `sku`, `name`, `description`, `benefits`, `ingredients`, `nutrition_facts`, `usage_instructions`, `video_url`, `category_id`, `featured`, `best_selling`, `stock_status`, `hsn_code`, `gst_rate`, `is_food`, `is_simple`, `keywords`, `short_description`, `badge`, `hide_reviews`, `variant_type`, `shipping_rate`, `handling_cost`, `active`) VALUES ('prod_mango', '', 'Dehydrated Alphanso Mango Powder (Amchur)', 'Made from rich, sun-ripened and slightly tart sour green mango slices. It provides a delightful sour, citrusy tang to recipes without adding visual wetness.', '["Fabulous chemical-free acidic flavor profile.","Improves digestion and combats flatulence.","A dense source of Vitamin A and Vitamin C."]', '100% Unripe Alphanso Green Mangoes', '{"calories":"320 kcal","protein":"2.8g","carbohydrates":"76.5g","fat":"1.2g","fiber":"6.4g"}', 'Stir into chickpeas, chutneys, barbecue dips, street food seasoning (chaat masala), curries, and vegetable sautés.', 'https://assets.mixkit.co/videos/preview/mixkit-cutting-slices-of-a-ripe-sweet-mango-43838-large.mp4', 'cat_fruit', 1, 0, 'instock', '09109929', 12, 0, 1, '', '', '', 0, '', 0, 0, 1);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_mango', '50g', 95, 130, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_mango', '100g', 170, 100, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_mango', '250g', 370, 75, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_mango', '500g', 660, 40, NULL);
INSERT INTO `product_variants` (`product_id`, `size`, `price`, `stock`, `mrp`) VALUES ('prod_mango', '1kg', 1190, 18, NULL);
INSERT INTO `product_images` (`product_id`, `image_url`) VALUES ('prod_mango', 'https://images.unsplash.com/photo-1553279768-865429fa0078?auto=format&fit=crop&q=80&w=600');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR REELS
-- -------------------------------------------------------------
CREATE TABLE `reels` (
  `id` varchar(50) NOT NULL,
  `video_url` text NOT NULL,
  `title` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `thumbnail` text DEFAULT NULL,
  `tagged_products` text DEFAULT NULL,
  `likes` int(11) DEFAULT 0,
  `shares` int(11) DEFAULT 0,
  `views` int(11) DEFAULT 0,
  `clicks` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `reels` (`id`, `video_url`, `title`, `description`, `thumbnail`, `tagged_products`, `likes`, `shares`, `views`, `clicks`) VALUES ('reel_1', 'https://assets.mixkit.co/videos/preview/mixkit-vegetables-chopped-on-a-wooden-board-40019-large.mp4', 'Secret Onion Powder Magic!', 'No tears, no slicing, pure onion goodness in seconds. Hand-dehydrated from fresh field harvests of Eximpx Global.', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=300', '["prod_onion"]', 345, 89, 2450, 112);
INSERT INTO `reels` (`id`, `video_url`, `title`, `description`, `thumbnail`, `tagged_products`, `likes`, `shares`, `views`, `clicks`) VALUES ('reel_2', 'https://assets.mixkit.co/videos/preview/mixkit-top-view-of-garlic-heads-falling-on-a-table-40112-large.mp4', 'Ultimate Crispy Garlic Bread Mix', 'Stop peeling sticky garlic! Use white garlic powder for clean, non-lumpy garlic distributions on buttery bread.', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=300', '["prod_garlic"]', 582, 134, 4890, 341);
INSERT INTO `reels` (`id`, `video_url`, `title`, `description`, `thumbnail`, `tagged_products`, `likes`, `shares`, `views`, `clicks`) VALUES ('reel_3', 'https://assets.mixkit.co/videos/preview/mixkit-fresh-beetroot-sliced-into-water-splashing-43840-large.mp4', 'Dynamic Pre-Workout Earthy Red', 'Boost endurance and nitric oxide levels dynamically with Red Beetroot Powder. Pure stamina, 100% natural, no added chemicals.', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=300', '["prod_beetroot"]', 412, 55, 1820, 98);
INSERT INTO `reels` (`id`, `video_url`, `title`, `description`, `thumbnail`, `tagged_products`, `likes`, `shares`, `views`, `clicks`) VALUES ('reel_4', 'https://assets.mixkit.co/videos/preview/mixkit-spoon-scooping-out-powdered-munt-green-ingredients-41550-large.mp4', 'Leafy Goodness: Organic Moringa', 'Dense nutrition right out of the jar. 2 teaspoons in your smoothie equals a massive serving of premium hand-picked Moringa.', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=300', '["prod_moringa"]', 671, 210, 5210, 434);

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR COUPONS
-- -------------------------------------------------------------
CREATE TABLE `coupons` (
  `id` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `discount_type` varchar(50) NOT NULL,
  `value` decimal(10,2) NOT NULL,
  `min_order_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `expiry_date` varchar(50) NOT NULL,
  `active` tinyint(4) NOT NULL DEFAULT 1,
  `max_uses` int(11) DEFAULT NULL,
  `used_count` int(11) NOT NULL DEFAULT 0,
  `buy_x` int(11) DEFAULT NULL,
  `get_y` int(11) DEFAULT NULL,
  `applicable_product_ids` text DEFAULT NULL,
  `applicable_categories` text DEFAULT NULL,
  `is_first_order_only` tinyint(4) NOT NULL DEFAULT 0,
  `start_date` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code_idx` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `coupons` (`id`, `code`, `discount_type`, `value`, `min_order_amount`, `expiry_date`, `active`, `max_uses`, `used_count`, `buy_x`, `get_y`, `applicable_product_ids`, `applicable_categories`, `is_first_order_only`, `start_date`) VALUES ('cp_welcome', 'WELCOME10', 'percentage', 10, 299, '2026-12-31', 1, NULL, 0, NULL, NULL, '[]', '[]', 0, NULL);
INSERT INTO `coupons` (`id`, `code`, `discount_type`, `value`, `min_order_amount`, `expiry_date`, `active`, `max_uses`, `used_count`, `buy_x`, `get_y`, `applicable_product_ids`, `applicable_categories`, `is_first_order_only`, `start_date`) VALUES ('cp_flat50', 'EXIM50', 'fixed', 50, 499, '2026-12-31', 1, NULL, 0, NULL, NULL, '[]', '[]', 0, NULL);
INSERT INTO `coupons` (`id`, `code`, `discount_type`, `value`, `min_order_amount`, `expiry_date`, `active`, `max_uses`, `used_count`, `buy_x`, `get_y`, `applicable_product_ids`, `applicable_categories`, `is_first_order_only`, `start_date`) VALUES ('cp_freegift', 'FREESHIP', 'percentage', 0, 999, '2026-09-30', 1, NULL, 0, NULL, NULL, '[]', '[]', 0, NULL);

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR ORDERS
-- -------------------------------------------------------------
CREATE TABLE `orders` (
  `id` varchar(50) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `address_line` text NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `pincode` varchar(15) NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `shipping_charge` decimal(10,2) NOT NULL,
  `coupon_code` varchar(50) DEFAULT NULL,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `payable_amount` decimal(10,2) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'pending',
  `notes` text DEFAULT NULL,
  `created_at` varchar(100) DEFAULT NULL,
  `courier_company` varchar(100) DEFAULT NULL,
  `tracking_number` varchar(100) DEFAULT NULL,
  `is_b2b` tinyint(4) DEFAULT 0,
  `company_name` varchar(150) DEFAULT NULL,
  `gst_number` varchar(50) DEFAULT NULL,
  `tracking_link` varchar(255) DEFAULT NULL,
  `tracking_status` varchar(50) DEFAULT 'placed',
  `payment_method` varchar(50) DEFAULT NULL,
  `upi_utr` varchar(100) DEFAULT NULL,
  `upi_payer_name` varchar(150) DEFAULT NULL,
  `upi_screenshot_url` text DEFAULT NULL,
  `payment_remarks` varchar(255) DEFAULT NULL,
  `upi_merchant_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `order_num_idx` (`order_number`),
  KEY `order_user_fk` (`user_id`),
  KEY `order_status_idx` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `order_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(50) NOT NULL,
  `product_id` varchar(50) NOT NULL,
  `product_name` varchar(150) NOT NULL,
  `size` varchar(50) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `image` text DEFAULT NULL,
  `hsn_code` varchar(50) DEFAULT NULL,
  `gst_rate` decimal(5,2) DEFAULT '0.00',
  PRIMARY KEY (`id`),
  KEY `idx_order_items_order` (`order_id`),
  CONSTRAINT `fk_order_items_order` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR REVIEWS
-- -------------------------------------------------------------
CREATE TABLE `reviews` (
  `id` varchar(50) NOT NULL,
  `product_id` varchar(50) NOT NULL,
  `user_name` varchar(100) NOT NULL,
  `user_email` varchar(100) NOT NULL,
  `rating` tinyint(4) NOT NULL,
  `comment` text NOT NULL,
  `date` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_reviews_product` (`product_id`),
  CONSTRAINT `fk_reviews_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `reviews` (`id`, `product_id`, `user_name`, `user_email`, `rating`, `comment`, `date`) VALUES ('rev_1', 'prod_onion', 'Rajesh Sharma', 'rajesh.sharma@gmail.com', 5, 'Exceptional texture and rich taste. I carry this Onion Powder for my travel camping trips. Saves tears and time. Eximpx Global is incredible.', '2026-05-12');
INSERT INTO `reviews` (`id`, `product_id`, `user_name`, `user_email`, `rating`, `comment`, `date`) VALUES ('rev_2', 'prod_onion', 'Kriti Patel', 'kriti.p@gmail.com', 4, 'Very fine powder. Perfectly dry, does not clump up in humid weathers. Will absolutely buy again.', '2026-05-24');
INSERT INTO `reviews` (`id`, `product_id`, `user_name`, `user_email`, `rating`, `comment`, `date`) VALUES ('rev_3', 'prod_garlic', 'Sundeep Joshi', 'sundeep@gmail.com', 5, 'This garlic powder is highly dominant in flavor! A tiny bit is enough for garlic spread. Phenomenal quality, much better than grocery store brands.', '2026-05-18');
INSERT INTO `reviews` (`id`, `product_id`, `user_name`, `user_email`, `rating`, `comment`, `date`) VALUES ('rev_4', 'prod_moringa', 'Anjali Menon', 'anjali.m@gmail.com', 5, 'The green is extremely vibrant, signaling fresh harvesting and superb shade drying. No bitter chemical taste, perfect for morning shakes.', '2026-06-01');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR CMS CONTENT
-- -------------------------------------------------------------
CREATE TABLE `cms` (
  `slug` varchar(100) NOT NULL,
  `title` varchar(150) NOT NULL,
  `content` longtext NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  `image_url` text DEFAULT NULL,
  `video_url` text DEFAULT NULL,
  PRIMARY KEY (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `cms` (`slug`, `title`, `content`, `updated_at`, `image_url`, `video_url`) VALUES ('about-us', 'About Eximpx Global', '### Pioneer in Dehydrated Agro Foods

Eximpx Global was founded with a singular focus: to deliver the purest, most nutrient-dense dehydrated fruit and vegetable powders to culinary enthusiasts and commercial food manufacturers globally. Our state-of-the-art cold-drying vacuum system removes high-water weight while sealing in 98% of the native vitamins, rich pigments, fibers, and delicious aromatic oils.

We source directly from chemical-free contract farmers across regional agricultural crop zones, ensuring that everything from our Pink Onions to wild Moringa leaf receives strict contamination analysis.

#### Why Choose Us?
* **Zero Fillers**: 100% natural, single-ingredient food powders. No cornstarch, silica, or anti-caking toxins.
* **Hygienic processing**: Fully clean-room manufacturing. All products undergo stringent metal detection and microbial screening.
* **Maximum Shelf Life**: Packaged in moisture-barrier triple-layered food bags that preserve freshness up to 12 months.
* **Empowering Farmers**: 10% of all operations profit is fed back into farmers cooperative societies.', '2026-06-01', '', '');
INSERT INTO `cms` (`slug`, `title`, `content`, `updated_at`, `image_url`, `video_url`) VALUES ('shipping-policy', 'Shipping & Delivery', '### Timely & Safe Global Shipping

We ship nationwide and internationally through premium delivery partners (DHL, FedEx, BlueDart, Delhivery).

* **Order Processing**: Standard customer order units are packed and dispatched within 24 to 48 hours of verification.
* **Delivery Transit Timelines**:
  - Domestic Metro Areas: 3 to 5 business days.
  - Domestic Non-Metro / Regional Locations: 5 to 7 business days.
  - International Destinations: 7 to 12 business days.
* **Shipping Cost Structure**:
  - We calculate fixed low shipping based on parcel net weight zones.
  - Enjoy **FREE SHIPPING** nationwide on orders exceeding ₹999 value!
* **Shipment Tracking**: Once dispatched, a live tracking hyperlink is generated and transmitted via automated SMS, dynamic WhatsApp alerts, or email.', '2026-06-01', '', '');
INSERT INTO `cms` (`slug`, `title`, `content`, `updated_at`, `image_url`, `video_url`) VALUES ('refund-policy', 'Returns & Refund Guarantees', '### 100% Satisfaction Guarantee

At Eximpx Global, food sanitation and customer trust are absolute. If you are not thoroughly satisfied with our product density or aroma, we support simple solutions.

* **Non-Perishable Returns**: Due to hygiene reasons, opened food packets cannot be repackaged. However, if a packet is received punctured, damp, or damaged, send pictures to **sales@eximpx.com** within 48 hours of arrival. We will dispatch a replacements kit completely free!
* **Refund Initiations**: Upon verifying damaged packages, full money returns are executed to your native source bank card/UPI address in 5 to 7 banking days.
* **Order Cancellations**: Cancellations can be filed on the dashboard prior to item dispatch. Dispatched items cannot be cancelled.', '2026-06-01', '', '');
INSERT INTO `cms` (`slug`, `title`, `content`, `updated_at`, `image_url`, `video_url`) VALUES ('privacy-policy', 'Privacy Guard Policy', '### Protecting Your Information

This privacy declaration highlights how Eximpx Global processes your operational, checkout, and browser footprint:

1. **Security Measures Check**: Your digital profiles, password tokens, addresses are safely secured. Order history is cached to provide personal history context.
2. **Third-Party Data Exclusion**: Absolutely zero data is sold to commercial agencies. We only transmit shipping coords to courier engines.
3. **PWA Cookies Usage**: Fast browser cookie states are leveraged only to retain shopping cart items, session profiles, and custom user settings.', '2026-06-01', '', '');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR EMAIL SUBSCRIBERS
-- -------------------------------------------------------------
CREATE TABLE `email_subscribers` (
  `id` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `subscription_date` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `source` varchar(100) NOT NULL DEFAULT 'footer',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sub_email_idx` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_1', 'sales@eximpx.com', '2026-06-05T18:10:36.366Z', 'active', 'footer');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_2', 'sunilsonagara111@gmail.com', '2026-06-20T18:10:36.366Z', 'active', 'popup');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_3', 'samir.v@gmail.com', '2026-07-05T18:10:36.366Z', 'active', 'checkout');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_4', 'purchasing@walmart-foods.com', '2026-07-08T18:10:36.366Z', 'active', 'admin');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_5', 'buyer@londongrocery.co.uk', '2026-07-10T18:10:36.366Z', 'active', 'footer');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_6', 'pur_manager@moringa-imports.de', '2026-07-12T18:10:36.366Z', 'active', 'popup');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_7', 'operations@indianspicehouses.co.in', '2026-07-15T18:10:36.366Z', 'active', 'checkout');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_8', 'unsub-test-1@bounces.net', '2026-06-25T18:10:36.366Z', 'unsubscribed', 'popup');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_9', 'unsub-test-2@example.com', '2026-07-17T18:10:36.366Z', 'unsubscribed', 'footer');
INSERT INTO `email_subscribers` (`id`, `email`, `subscription_date`, `status`, `source`) VALUES ('sub_10', 'new-lead-today@agro-deals.org', '2026-07-20T14:10:36.366Z', 'active', 'popup');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR MEDIA
-- -------------------------------------------------------------
CREATE TABLE `media` (
  `id` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `url` text NOT NULL,
  `type` varchar(100) NOT NULL,
  `size` int(11) NOT NULL,
  `category` varchar(50) NOT NULL,
  `alt_text` varchar(255) DEFAULT NULL,
  `folder_path` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_7gmnid299', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_6iu7s59c4', 'https://images.unsplash.com/photo-1508747703725-719ae2c13d4b?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1508747703725-719ae2c13d4b?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_op2rxi27c', 'https://assets.mixkit.co/videos/preview/mixkit-vegetables-chopped-on-a-wooden-board-40019-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-vegetables-chopped-on-a-wooden-board-40019-large.mp4', 'video', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_g3nwi1ycl', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_1vayccym5', 'https://images.unsplash.com/photo-1608797178974-15b35a61d121?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1608797178974-15b35a61d121?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_7yvu03eu0', 'https://assets.mixkit.co/videos/preview/mixkit-top-view-of-garlic-heads-falling-on-a-table-40112-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-top-view-of-garlic-heads-falling-on-a-table-40112-large.mp4', 'video', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_oyhsghmxx', 'https://images.unsplash.com/photo-1615485290382-441e4d049cb5?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1615485290382-441e4d049cb5?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_t4jlcbihe', 'https://assets.mixkit.co/videos/preview/mixkit-pouring-orange-ginger-juice-into-glasses-43844-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-pouring-orange-ginger-juice-into-glasses-43844-large.mp4', 'video', 0, 'video', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_ycdyyzayk', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_5po58zzam', 'https://assets.mixkit.co/videos/preview/mixkit-spoon-scooping-out-powdered-munt-green-ingredients-41550-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-spoon-scooping-out-powdered-munt-green-ingredients-41550-large.mp4', 'video', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_f72u7vcw0', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_hghoq77qn', 'https://assets.mixkit.co/videos/preview/mixkit-fresh-beetroot-sliced-into-water-splashing-43840-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-fresh-beetroot-sliced-into-water-splashing-43840-large.mp4', 'video', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_c6esaj823', 'https://images.unsplash.com/photo-1518977676601-b53f82aba655?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1518977676601-b53f82aba655?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_cx1e8yn98', 'https://assets.mixkit.co/videos/preview/mixkit-making-of-a-fresh-salad-with-chopped-tomatoes-42403-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-making-of-a-fresh-salad-with-chopped-tomatoes-42403-large.mp4', 'video', 0, 'video', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_zmbr781fw', 'https://images.unsplash.com/photo-1576045057995-568f588f82fb?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1576045057995-568f588f82fb?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_wo4pn8iqm', 'https://images.unsplash.com/photo-1571771894821-ce9b6c11b08e?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1571771894821-ce9b6c11b08e?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_k3qxufia2', 'https://assets.mixkit.co/videos/preview/mixkit-slicing-various-peeled-bananas-43831-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-slicing-various-peeled-bananas-43831-large.mp4', 'video', 0, 'video', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_jtkz8weps', 'https://images.unsplash.com/photo-1553279768-865429fa0078?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1553279768-865429fa0078?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_6klz3f9rl', 'https://assets.mixkit.co/videos/preview/mixkit-cutting-slices-of-a-ripe-sweet-mango-43838-large.mp4', 'https://assets.mixkit.co/videos/preview/mixkit-cutting-slices-of-a-ripe-sweet-mango-43838-large.mp4', 'video', 0, 'video', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_qru73byfn', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=300', 'https://images.unsplash.com/photo-1618220179428-22790b461013?auto=format&fit=crop&q=80&w=300', 'other', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_shv7t5iqf', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=300', 'https://images.unsplash.com/photo-1540148426945-6cf22a6b2383?auto=format&fit=crop&q=80&w=300', 'other', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_zyvsh4vm9', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=300', 'https://images.unsplash.com/photo-1528114039593-4366cc08227d?auto=format&fit=crop&q=80&w=300', 'other', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_qc8tsd9hg', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=300', 'https://images.unsplash.com/photo-1512290923902-8a9f81dc236c?auto=format&fit=crop&q=80&w=300', 'other', 0, 'reel', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_vhy2fy4g2', 'https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_yfttls92x', 'https://images.unsplash.com/photo-1573244514399-bf1ad13c126d?auto=format&fit=crop&q=80&w=600', 'https://images.unsplash.com/photo-1573244514399-bf1ad13c126d?auto=format&fit=crop&q=80&w=600', 'other', 0, 'product', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_g02mxlwxp', 'data:image/png;base64,[encoded data, 57348 characters]', 'data:image/png;base64,[encoded data, 57348 characters]', 'other', 0, 'logo', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_rm8iydzkm', 'https://images.unsplash.com/photo-1498837167922-ddd27525d352?auto=format&fit=crop&q=80&w=1200', 'https://images.unsplash.com/photo-1498837167922-ddd27525d352?auto=format&fit=crop&q=80&w=1200', 'other', 0, 'banner', NULL, NULL, '2026-07-20T18:10:36.375Z');
INSERT INTO `media` (`id`, `name`, `url`, `type`, `size`, `category`, `alt_text`, `folder_path`, `created_at`) VALUES ('media_7vvaumnnw', 'https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200', 'https://images.unsplash.com/photo-1540420773420-3366772f4999?auto=format&fit=crop&q=80&w=1200', 'other', 0, 'banner', NULL, NULL, '2026-07-20T18:10:36.375Z');

-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR RETURNS
-- -------------------------------------------------------------
CREATE TABLE `returns` (
  `id` varchar(50) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `mobile` varchar(50) NOT NULL,
  `refund_method` varchar(50) NOT NULL,
  `return_type` varchar(50) NOT NULL,
  `exchange_product_details` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `customer_message` text DEFAULT NULL,
  `admin_notes` text DEFAULT NULL,
  `status` varchar(50) NOT NULL,
  `history` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `return_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `return_id` varchar(50) NOT NULL,
  `product_id` varchar(50) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `size` varchar(50) NOT NULL,
  `quantity` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `image` text DEFAULT NULL,
  `reason` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_return_items_return` (`return_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- -------------------------------------------------------------
-- TABLE STRUCTURE & INSERTS FOR UPI PAYMENTS & MERCHANTS
-- -------------------------------------------------------------
CREATE TABLE `upi_merchants` (
  `id` varchar(50) NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'upi',
  `merchant_name` varchar(100) DEFAULT NULL,
  `business_name` varchar(100) DEFAULT NULL,
  `upi_vpa` varchar(100) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `account_number` varchar(100) DEFAULT NULL,
  `ifsc_code` varchar(50) DEFAULT NULL,
  `account_type` varchar(50) DEFAULT NULL,
  `qr_image_url` text DEFAULT NULL,
  `logo_url` text DEFAULT NULL,
  `payment_instructions` text DEFAULT NULL,
  `priority` int(11) DEFAULT 0,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `provider` varchar(50) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `upi_payments` (
  `id` varchar(50) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `order_number` varchar(50) NOT NULL,
  `utr` varchar(50) NOT NULL,
  `payer_name` varchar(100) DEFAULT NULL,
  `screenshot_url` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'pending',
  `remarks` text DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `payment_method` varchar(50) NOT NULL DEFAULT 'upi',
  `payer_bank_name` varchar(100) DEFAULT NULL,
  `upi_merchant_id` varchar(100) DEFAULT NULL,
  `upi_vpa` varchar(100) DEFAULT NULL,
  `upi_merchant_name` varchar(100) DEFAULT NULL,
  `created_at` varchar(100) NOT NULL,
  `updated_at` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `utr_idx` (`utr`),
  KEY `pay_order_idx` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `upi_payment_logs` (
  `id` varchar(50) NOT NULL,
  `payment_id` varchar(50) NOT NULL,
  `action` varchar(50) NOT NULL,
  `performed_by` varchar(100) NOT NULL,
  `remarks` text DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `timestamp` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `log_pay_idx` (`payment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



-- Direct Backup & Export Complete. Synced successfully for phpMyAdmin !