INSERT INTO `policy_sections` (`id`, `policy_id`, `title`, `content`, `image`, `section_type`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(865, 19, 'Penalties and Enforcement', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Offense Level</th><th>Examples</th><th>Consequence</th></tr></thead><tbody><tr><td>Minor</td><td>Single unsolicited promo message</td><td>Warning; message blocked</td></tr><tr><td>Moderate</td><td>Repeated promo spam; minor harvesting attempt</td><td>7-day messaging restriction</td></tr><tr><td>Major</td><td>Bulk spam; phishing; bot automation</td><td>30-day suspension; seller panel lock</td></tr><tr><td>Severe</td><td>Large-scale phishing; credential theft; repeat offenses</td><td>Permanent ban; legal referral</td></tr></tbody></table></div>', 'policies/sections/anti-spam-policy-penalties-and-enforcement-section-800x400.svg', 'legal_update', 7, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(866, 19, 'Compliance with External Laws', '<p>Gletra complies with applicable anti-spam regulations. Users sending communications through Gletra to recipients in regulated jurisdictions bear responsibility for obtaining valid consent and honoring opt-out requests within 48 hours.</p>', 'policies/sections/anti-spam-policy-compliance-with-external-laws-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(867, 19, 'Best Practices for Sellers', '<ul class=\"mb-3\"><li>Use Gletra\'s built-in promotional tools rather than manual bulk chat</li><li>Personalize messages with order or product context</li><li>Include clear opt-out instructions in marketing communications</li><li>Never request payment outside Gletra Wallet or approved checkout</li><li>Respond to buyer-initiated chats within 24 hours instead of cold outreach</li></ul>', 'policies/sections/anti-spam-policy-best-practices-for-sellers-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(868, 19, 'Contact and Reporting', '<p>Report platform-wide spam campaigns or security concerns to abuse@gletra.com. Enterprise sellers may contact partner-support@gletra.com for guidance on compliant marketing practices.</p>', 'policies/sections/anti-spam-policy-contact-and-reporting-section-800x400.svg', 'notice', 10, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(869, 20, 'Accepted Payment Methods', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Method</th><th>Availability</th><th>Notes</th></tr></thead><tbody><tr><td>UPI (GPay, PhonePe, Paytm, etc.)</td><td>All users</td><td>Instant confirmation; primary method in India</td></tr><tr><td>Credit / Debit Cards</td><td>All users</td><td>Visa, Mastercard, RuPay; 3D Secure required</td></tr><tr><td>Net Banking</td><td>All users</td><td>Major Indian banks supported</td></tr><tr><td>Gletra Wallet</td><td>Verified users</td><td>Instant checkout; combine with other methods</td></tr><tr><td>Cash on Delivery (COD)</td><td>Eligible orders</td><td>Select products and regions; ₹50 fee may apply</td></tr><tr><td>EMI</td><td>Orders above ₹3,000</td><td>Partner bank terms apply; interest may apply</td></tr></tbody></table></div>', 'policies/sections/payment-terms-accepted-payment-methods-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(870, 20, 'Payment Authorization and Capture', '<p>When you place an order or confirm a service booking, Gletra authorizes payment for the total amount including product price, service fees, shipping, applicable taxes, and platform charges displayed at checkout.</p><ul class=\"mb-3\"><li>Marketplace orders: payment captured when seller confirms or ships (or immediately for digital goods)</li><li>Service bookings: partial or full prepayment captured at booking; balance on completion</li><li>Wallet top-ups: captured immediately upon successful gateway response</li><li>Multi-vendor carts: each seller item processed as a separate transaction where required by payment partner</li></ul>', 'policies/sections/payment-terms-payment-authorization-and-capture-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(871, 20, 'Pricing, Fees, and Taxes', '<p>All prices are displayed in Indian Rupees (INR) unless otherwise noted. GST and applicable state taxes are calculated at checkout based on product category, seller location, and delivery address.</p><p>Gletra service fees, payment gateway fees (where passed to buyer), and COD handling charges are disclosed before payment confirmation. Sellers set product and service prices; Gletra is not responsible for seller pricing errors but will facilitate corrections before capture where possible.</p>', 'policies/sections/payment-terms-pricing-fees-and-taxes-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:10', '2026-06-19 06:52:10'),
(872, 20, 'Failed and Declined Payments', '<p>Orders with failed payment authorization are not confirmed. Common failure reasons include insufficient funds, incorrect card details, bank declines, and UPI timeout.</p><ol class=\"mb-3\"><li>Retry payment within 30 minutes from My Orders or booking screen</li><li>After 30 minutes, the order or booking hold is released automatically</li><li>Repeated failed attempts may trigger temporary payment method restriction for fraud prevention</li><li>Contact support@gletra.com if your bank confirms deduction but Gletra shows failure</li></ol>', 'policies/sections/payment-terms-failed-and-declined-payments-section-800x400.svg', 'notice', 4, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(873, 20, 'Payment Security', '<p>Gletra implements industry-standard security measures: TLS 1.3 encryption in transit, tokenization of card data, PCI-DSS Level 1 compliant payment partners, 3D Secure authentication, and fraud scoring on all transactions.</p><p>Never share OTPs, CVV, or UPI PINs in Gletra Chat or during calls. Gletra staff will never request these credentials.</p>', 'policies/sections/payment-terms-payment-security-section-800x400.svg', 'highlight', 5, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(874, 20, 'Chargebacks and Disputes', '<p>Buyers who dispute charges with their bank or card issuer initiate a chargeback. Gletra provides transaction evidence to payment partners and may debit seller accounts for upheld chargebacks on their orders.</p><div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Chargeback Reason</th><th>Gletra Response</th><th>User Action</th></tr></thead><tbody><tr><td>Unauthorized transaction</td><td>Fraud investigation; account secured</td><td>Report immediately to support@gletra.com</td></tr><tr><td>Product not received</td><td>Tracking and delivery proof submitted</td><td>File Gletra dispute first before chargeback</td></tr><tr><td>Not as described</td><td>Seller evidence and buyer photos reviewed</td><td>Use Gletra Dispute Center for faster resolution</td></tr></tbody></table></div>', 'policies/sections/payment-terms-chargebacks-and-disputes-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(875, 20, 'Refunds and Payment Reversals', '<p>Approved refunds are returned to the original payment method or Gletra Wallet at buyer\'s choice. Refund timelines: Wallet (instant), UPI/cards (5–10 business days), net banking (5–10 business days). See Refund Policy for eligibility criteria.</p>', 'policies/sections/payment-terms-refunds-and-payment-reversals-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(876, 20, 'Off-Platform Payment Prohibition', '<p>Sellers, service providers, and buyers must not solicit or accept payment outside Gletra\'s approved checkout, wallet, or booking payment flows. Off-platform payments void Gletra Customer Protection and may result in account termination for all parties involved.</p>', 'policies/sections/payment-terms-off-platform-payment-prohibition-section-800x400.svg', 'notice', 8, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(877, 20, 'Seller and Provider Settlements', '<p>Seller earnings are settled per the Seller Withdrawal Policy (standard T+7 after delivery confirmation). Service provider payments are released 24 hours after job completion unless a dispute is filed. Gletra deducts applicable commission, payment gateway fees, and tax withholdings before disbursement.</p>', 'policies/sections/payment-terms-seller-and-provider-settlements-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(878, 20, 'Modifications and Contact', '<p>Gletra may modify these Payment Terms with 15 days notice for material changes. Payment inquiries: payments@gletra.com. Fraud reports: fraud@gletra.com.</p>', 'policies/sections/payment-terms-modifications-and-contact-section-800x400.svg', 'legal_update', 10, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(879, 21, 'Wallet Features and Eligibility', '<ul class=\"mb-3\"><li>Instant checkout for marketplace orders and service bookings</li><li>Receive refunds from cancelled orders and approved returns</li><li>Earn cashback and promotional credits from Gletra campaigns</li><li>Partial payment combined with UPI, cards, or net banking</li><li>Seller settlement disbursement destination (post-KYC)</li><li>Transaction history and downloadable statements in Account Settings</li></ul><p>All registered Gletra users aged 18+ may activate a wallet. Users under 18 may not hold wallet balances.</p>', 'policies/sections/wallet-policy-wallet-features-and-eligibility-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(880, 21, 'Top-Up Methods and Limits', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Method</th><th>Min Top-Up</th><th>Max Top-Up/Day</th><th>Processing</th></tr></thead><tbody><tr><td>UPI</td><td>₹100</td><td>₹1,00,000</td><td>Instant</td></tr><tr><td>Debit/Credit Card</td><td>₹100</td><td>₹1,00,000</td><td>Instant</td></tr><tr><td>Net Banking</td><td>₹500</td><td>₹1,00,000</td><td>Instant–2 hours</td></tr><tr><td>Refund credit</td><td>N/A</td><td>N/A</td><td>Automatic on approval</td></tr></tbody></table></div><p>Maximum wallet balance: ₹1,00,000 for standard users; ₹5,00,000 for KYC-verified business accounts.</p>', 'policies/sections/wallet-policy-top-up-methods-and-limits-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(881, 21, 'Spending Rules', '<p>Wallet funds may be used for product purchases, home service bookings, platform fees, and tipping service providers where enabled. Wallet funds may not be used for:</p><ul class=\"mb-3\"><li>Transfer to other Gletra user wallets (P2P transfers not supported)</li><li>Off-platform purchases or cash equivalent conversion except via approved withdrawal</li><li>Gambling, cryptocurrency, or prohibited category purchases</li><li>Payment of seller commission or subscription fees (debited from seller settlement)</li></ul>', 'policies/sections/wallet-policy-spending-rules-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(882, 21, 'Promotional Credits and Cashback', '<p>Promotional credits, referral bonuses, and cashback rewards are subject to individual offer terms including expiry dates, minimum order values, and category restrictions.</p><div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Credit Type</th><th>Typical Expiry</th><th>Withdrawable</th></tr></thead><tbody><tr><td>Cashback on orders</td><td>90 days</td><td>Yes (after KYC)</td></tr><tr><td>Referral bonus</td><td>60 days</td><td>Yes (after KYC)</td></tr><tr><td>Campaign voucher</td><td>Per offer (7–30 days)</td><td>No</td></tr><tr><td>Compensation credit</td><td>180 days</td><td>Yes (after KYC)</td></tr></tbody></table></div>', 'policies/sections/wallet-policy-promotional-credits-and-cashback-section-800x400.svg', 'notice', 4, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(883, 21, 'Refunds to Wallet', '<p>Buyers may elect to receive approved refunds as instant Gletra Wallet credit during the refund request process. Wallet refunds are credited immediately upon approval and may be used for subsequent purchases or withdrawn after KYC verification.</p>', 'policies/sections/wallet-policy-refunds-to-wallet-section-800x400.svg', 'highlight', 5, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(884, 21, 'Withdrawals', '<p>KYC-verified users may withdraw available wallet balance to a registered bank account. Promotional non-withdrawable credits are excluded from withdrawal calculations.</p><ul class=\"mb-3\"><li>Minimum withdrawal: ₹100</li><li>Processing time: 2–5 business days via NEFT/IMPS</li><li>Maximum 3 withdrawal requests per day</li><li>Withdrawals suspended during active fraud investigation</li></ul>', 'policies/sections/wallet-policy-withdrawals-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(885, 21, 'Inactivity and Escheatment', '<p>Wallets with no transaction activity for 24 consecutive months receive email notice at 21 months. After 24 months of inactivity, remaining balances may be escheated to government unclaimed property authorities as required by applicable law. Reactivate by logging in and completing a transaction before the deadline.</p>', 'policies/sections/wallet-policy-inactivity-and-escheatment-section-800x400.svg', 'legal_update', 7, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(886, 21, 'Security and Unauthorized Access', '<p>Protect your Gletra account credentials. Enable two-factor authentication. Report unauthorized wallet transactions to support@gletra.com within 24 hours. Gletra investigates claims and may provisionally credit verified unauthorized transactions.</p><p>Never share OTPs or wallet PINs via chat or phone calls, even if the caller claims to be Gletra support.</p>', 'policies/sections/wallet-policy-security-and-unauthorized-access-section-800x400.svg', 'notice', 8, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(887, 21, 'Seller Wallet Settlement', '<p>Sellers may receive settlements directly to Gletra Wallet for faster reinvestment in platform advertising or supplier payments. Seller wallet balances follow the same KYC and withdrawal rules. Commission and fee debits are itemized in Seller Panel &gt; Finance.</p>', 'policies/sections/wallet-policy-seller-wallet-settlement-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:11', '2026-06-19 06:52:11'),
(888, 21, 'Disputes and Contact', '<p>Wallet transaction disputes: wallet@gletra.com. Include transaction ID, date, and amount. Response within 48 hours.</p>', 'policies/sections/wallet-policy-disputes-and-contact-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(889, 22, 'Who Must Complete KYC', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>User Type</th><th>KYC Trigger</th><th>Verification Level</th></tr></thead><tbody><tr><td>Marketplace seller</td><td>Seller registration</td><td>Full business KYC</td></tr><tr><td>Home service provider</td><td>Provider registration</td><td>Individual + skill KYC</td></tr><tr><td>Buyer (wallet withdrawal)</td><td>First withdrawal request</td><td>Individual KYC</td></tr><tr><td>Buyer (high balance)</td><td>Wallet balance &gt; ₹50,000</td><td>Individual KYC</td></tr><tr><td>Any user</td><td>Risk flag or compliance review</td><td>Enhanced due diligence</td></tr></tbody></table></div>', 'policies/sections/kyc-verification-policy-who-must-complete-kyc-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(890, 22, 'Required Documents — Individual Users', '<ul class=\"mb-3\"><li>Government-issued photo ID: Aadhaar, PAN card, Passport, or Driving License</li><li>Live selfie verification matching ID photograph</li><li>Bank account proof: cancelled cheque, bank statement, or passbook (for withdrawals)</li><li>Address proof if different from ID (utility bill, rental agreement — within 3 months)</li></ul><p>Documents must be valid, unexpired, and clearly legible. Screenshots of documents are accepted only through Gletra\'s secure upload portal.</p>', 'policies/sections/kyc-verification-policy-required-documents-individual-users-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(891, 22, 'Required Documents — Business Sellers', '<h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Sole Proprietorship / Individual Seller</h4><ul class=\"mb-3\"><li>PAN card</li><li>GST registration (if applicable)</li><li>Bank account in business or individual name</li><li>Business address proof</li></ul><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Private Limited / LLP / Partnership</h4><ul class=\"mb-3\"><li>Certificate of Incorporation</li><li>PAN of entity</li><li>GST registration</li><li>Authorized signatory ID and board resolution</li><li>Bank account proof in entity name</li></ul>', 'policies/sections/kyc-verification-policy-required-documents-business-sellers-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(892, 22, 'Service Provider Verification', '<p>Home service providers undergo additional verification beyond standard KYC:</p><ol class=\"mb-3\"><li>Skill certification upload (electrician license, plumbing certification, etc.) where applicable</li><li>Background check authorization and criminal record screening for in-home services</li><li>Service area and vehicle registration (if applicable)</li><li>Portfolio or work sample review for quality standards</li></ol><p>Providers failing background checks are denied registration. Results are not disclosed to other users.</p>', 'policies/sections/kyc-verification-policy-service-provider-verification-section-800x400.svg', 'content', 4, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(893, 22, 'Verification Process and Timeline', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Step</th><th>Timeline</th><th>Description</th></tr></thead><tbody><tr><td>Document upload</td><td>User-initiated</td><td>Via Account Settings or Seller Panel &gt; KYC</td></tr><tr><td>Automated validation</td><td>1–4 hours</td><td>OCR, database match, liveness check</td></tr><tr><td>Manual review</td><td>1–3 business days</td><td>Compliance team review if flagged</td></tr><tr><td>Approval / rejection</td><td>Within 5 business days</td><td>Email and in-app notification</td></tr></tbody></table></div>', 'policies/sections/kyc-verification-policy-verification-process-and-timeline-section-800x400.svg', 'highlight', 5, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(894, 22, 'Data Handling and Privacy', '<p>KYC documents are stored with AES-256 encryption. Access is restricted to authorized compliance personnel on a need-to-know basis. Documents are not shared with buyers, sellers, or third parties except as required by law or with explicit user consent for specific integrations.</p><p>Retention period: duration of account plus 7 years after closure for regulatory compliance. Users may request deletion subject to legal retention requirements via privacy@gletra.com.</p>', 'policies/sections/kyc-verification-policy-data-handling-and-privacy-section-800x400.svg', 'notice', 6, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(895, 22, 'Re-Verification and Enhanced Due Diligence', '<p>Gletra may require re-verification when: documents expire, account details change, suspicious activity is detected, regulatory requirements change, or random compliance audits occur. Failure to complete re-verification within 30 days results in account restriction.</p>', 'policies/sections/kyc-verification-policy-re-verification-and-enhanced-due-diligence-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(896, 22, 'Consequences of Failed or Refused KYC', '<ul class=\"mb-3\"><li>Seller accounts: registration denied or suspended; listings hidden</li><li>Service providers: unable to accept bookings</li><li>Wallet users: withdrawals blocked; top-ups may continue up to ₹10,000</li><li>False documents: permanent ban and referral to authorities</li></ul>', 'policies/sections/kyc-verification-policy-consequences-of-failed-or-refused-kyc-section-800x400.svg', 'legal_update', 8, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(897, 22, 'Third-Party Verification Partners', '<p>Gletra engages licensed verification partners for document authentication and background checks. Partners are bound by data processing agreements requiring equivalent security standards.</p>', 'policies/sections/kyc-verification-policy-third-party-verification-partners-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(898, 22, 'Contact and Appeals', '<p>KYC support: kyc@gletra.com. Rejection appeals with additional documentation within 14 days. Grievance Officer: grievance@gletra.com.</p>', 'policies/sections/kyc-verification-policy-contact-and-appeals-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:12', '2026-06-19 06:52:12'),
(899, 23, 'Settlement Cycles', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Account Type</th><th>Settlement Cycle</th><th>Minimum Payout</th></tr></thead><tbody><tr><td>Standard seller</td><td>T+7 after delivery confirmation</td><td>₹100 (rolls to next cycle)</td></tr><tr><td>Premium seller</td><td>T+3 after delivery confirmation</td><td>₹100</td></tr><tr><td>New seller (first 90 days)</td><td>T+14 after delivery confirmation</td><td>₹500</td></tr><tr><td>Home service provider</td><td>T+1 after job completion (24h dispute window)</td><td>₹100</td></tr><tr><td>Enterprise seller</td><td>Custom (contact partner-support@gletra.com)</td><td>Negotiated</td></tr></tbody></table></div><p>\"T\" refers to the date of delivery confirmation (marketplace) or service completion marked in app (home services).</p>', 'policies/sections/seller-withdrawal-policy-settlement-cycles-section-800x400.svg', 'highlight', 1, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(900, 23, 'Commission and Fee Deductions', '<p>Before settlement, Gletra deducts:</p><ul class=\"mb-3\"><li>Category-based commission (8%–20% depending on product category)</li><li>Payment gateway fees (2%–2.5% where applicable)</li><li>Gletra shipping fees (if using Gletra Logistics)</li><li>Advertising spend (Sponsored Products — if auto-debit enabled)</li><li>Tax collected at source (TCS) and TDS where applicable by law</li></ul><p>Detailed fee breakdown available in Seller Panel &gt; Finance &gt; Settlement Reports.</p>', 'policies/sections/seller-withdrawal-policy-commission-and-fee-deductions-section-800x400.svg', 'content', 2, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(901, 23, 'Holds and Reserves', '<p>Gletra may place holds on seller earnings in the following circumstances:</p><div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Hold Reason</th><th>Duration</th><th>Release Condition</th></tr></thead><tbody><tr><td>Active buyer dispute</td><td>Until resolution</td><td>Dispute closed in seller favor or refund processed</td></tr><tr><td>High return rate (&gt;15%)</td><td>Rolling 30-day reserve (10% of sales)</td><td>Return rate below 10% for 60 days</td></tr><tr><td>New seller probation</td><td>First 90 days — 5% reserve</td><td>Automatic release after 90 days if no violations</td></tr><tr><td>Suspected fraud investigation</td><td>Up to 90 days</td><td>Investigation cleared or legal order</td></tr><tr><td>Chargeback received</td><td>Until chargeback resolved</td><td>Evidence submitted; bank decision final</td></tr></tbody></table></div>', 'policies/sections/seller-withdrawal-policy-holds-and-reserves-section-800x400.svg', 'notice', 3, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(902, 23, 'Withdrawal Methods', '<ul class=\"mb-3\"><li>Bank transfer (NEFT/IMPS) to registered KYC-verified account — primary method</li><li>Gletra Wallet credit — instant, for platform reinvestment</li><li>UPI transfer — available for verified individual sellers (max ₹1,00,000/day)</li></ul><p>Processing time: 1–3 business days for bank transfers after settlement release. Weekends and bank holidays excluded.</p>', 'policies/sections/seller-withdrawal-policy-withdrawal-methods-section-800x400.svg', 'content', 4, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(903, 23, 'Withdrawal Limits and Frequency', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Limit Type</th><th>Standard Seller</th><th>Premium Seller</th></tr></thead><tbody><tr><td>Min withdrawal</td><td>₹500</td><td>₹100</td></tr><tr><td>Max per withdrawal</td><td>₹10,00,000</td><td>₹25,00,000</td></tr><tr><td>Withdrawals per day</td><td>2</td><td>5</td></tr><tr><td>Auto-withdrawal threshold</td><td>Optional: ₹5,000</td><td>Optional: ₹1,000</td></tr></tbody></table></div>', 'policies/sections/seller-withdrawal-policy-withdrawal-limits-and-frequency-section-800x400.svg', 'highlight', 5, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(904, 23, 'Failed and Reversed Payouts', '<p>Payouts fail when bank account details are incorrect, the account is frozen, or name mismatch occurs. Failed amounts return to pending balance within 2 business days. Update bank details in Seller Panel &gt; Settings &gt; Banking and re-initiate withdrawal.</p>', 'policies/sections/seller-withdrawal-policy-failed-and-reversed-payouts-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(905, 23, 'Negative Balances', '<p>If refunds, chargebacks, or fee adjustments exceed available balance, a negative balance is created. Sellers must remit the deficit within 14 days. Gletra may offset future settlements, restrict listings, or pursue collection for unpaid negative balances.</p>', 'policies/sections/seller-withdrawal-policy-negative-balances-section-800x400.svg', 'legal_update', 7, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(906, 23, 'Tax Documentation', '<p>Gletra provides monthly settlement statements and annual tax summaries (Form 16A / TDS certificates where applicable). Sellers are responsible for their own GST filing and income tax compliance.</p>', 'policies/sections/seller-withdrawal-policy-tax-documentation-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(907, 23, 'Account Closure and Final Settlement', '<p>Upon account closure request, pending orders must be fulfilled or cancelled. Final settlement occurs after all dispute windows close (minimum 30 days). Reserves are released subject to no outstanding claims.</p>', 'policies/sections/seller-withdrawal-policy-account-closure-and-final-settlement-section-800x400.svg', 'notice', 9, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(908, 23, 'Contact', '<p>Settlement inquiries: settlements@gletra.com. Include seller ID and settlement reference number. Seller Panel live chat available 9 AM–9 PM IST.</p>', 'policies/sections/seller-withdrawal-policy-contact-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:13', '2026-06-19 06:52:13'),
(909, 24, 'Service Categories and Coverage', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Category</th><th>Examples</th><th>Typical Duration</th></tr></thead><tbody><tr><td>Electrical</td><td>Wiring, switch repair, fan installation, MCB replacement</td><td>1–4 hours</td></tr><tr><td>Plumbing</td><td>Leak repair, tap replacement, drainage, geyser install</td><td>1–3 hours</td></tr><tr><td>Carpentry</td><td>Furniture assembly, door repair, shelf installation</td><td>2–6 hours</td></tr><tr><td>Cleaning</td><td>Deep cleaning, sofa cleaning, bathroom sanitization</td><td>2–5 hours</td></tr><tr><td>Appliance Repair</td><td>AC, washing machine, refrigerator, microwave repair</td><td>1–3 hours</td></tr></tbody></table></div><p>Service availability varies by city. Check gletra.com/services for coverage in your area.</p>', 'policies/sections/service-booking-policy-service-categories-and-coverage-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(910, 24, 'Booking Process', '<ol class=\"mb-3\"><li>Select service category and describe the issue or requirement</li><li>Choose preferred date and time slot from available provider schedules</li><li>Review estimated price range and confirm booking with payment authorization</li><li>Receive instant confirmation; provider details shared 2 hours before appointment</li><li>Provider arrives, assesses scope, confirms final price before work begins</li><li>Mark service complete in app and rate the provider after job completion</li></ol>', 'policies/sections/service-booking-policy-booking-process-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(911, 24, 'Pricing and Payment', '<h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Estimate vs. Final Price</h4><p>Booking screen shows an estimated price range based on service type and description. Provider confirms final price after on-site inspection. Additional parts, materials, or extended labor require customer approval before proceeding.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Payment Options</h4><ul class=\"mb-3\"><li>Full prepayment at booking (preferred; unlocks Gletra Guarantee)</li><li>Partial prepayment with balance on completion via Gletra app</li><li>Gletra Wallet, UPI, cards accepted; cash only where explicitly indicated</li></ul>', 'policies/sections/service-booking-policy-pricing-and-payment-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(912, 24, 'Provider Assignment and Communication', '<p>Providers are assigned based on proximity, availability, rating, and skill match. Customers may view provider profile, ratings, and verified credentials before appointment.</p><p>Pre-service communication via Gletra Chat and calls is encouraged for sharing access instructions, parking details, and scope clarification. Do not share payment credentials or move communication off-platform.</p>', 'policies/sections/service-booking-policy-provider-assignment-and-communication-section-800x400.svg', 'content', 4, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(913, 24, 'Rescheduling and Cancellation', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Action</th><th>Timing</th><th>Fee / Refund</th></tr></thead><tbody><tr><td>Customer cancellation</td><td>&gt;24 hours before</td><td>Full refund</td></tr><tr><td>Customer cancellation</td><td>12–24 hours before</td><td>25% cancellation fee</td></tr><tr><td>Customer cancellation</td><td>&lt;12 hours before</td><td>50% cancellation fee</td></tr><tr><td>Customer no-show</td><td>Provider waits 30 min</td><td>No refund</td></tr><tr><td>Free reschedule</td><td>&gt;12 hours before</td><td>One free per booking</td></tr><tr><td>Provider cancellation</td><td>Any time</td><td>Full refund + rebooking priority</td></tr></tbody></table></div>', 'policies/sections/service-booking-policy-rescheduling-and-cancellation-section-800x400.svg', 'notice', 5, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(914, 24, 'Service Completion and Provider Payout', '<p>Customer marks \"Service Complete\" in app or auto-completion occurs 48 hours after scheduled end time if no dispute filed. Provider payout released T+1 after completion per Seller Withdrawal Policy.</p><p>Disputes filed within 24 hours of completion hold provider payout until resolution.</p>', 'policies/sections/service-booking-policy-service-completion-and-provider-payout-section-800x400.svg', 'highlight', 6, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(915, 24, 'Customer Responsibilities', '<ul class=\"mb-3\"><li>Provide accurate address with landmarks and working phone number</li><li>Ensure safe access to service area; secure pets</li><li>Adult (18+) present during in-home services</li><li>Disclose known hazards (electrical issues, asbestos, structural concerns)</li><li>Approve additional charges before provider procures parts or extends scope</li></ul>', 'policies/sections/service-booking-policy-customer-responsibilities-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(916, 24, 'Provider Responsibilities', '<ul class=\"mb-3\"><li>Arrive within 15-minute window of scheduled time; notify delays via app</li><li>Display Gletra provider ID and wear identification badge</li><li>Provide upfront pricing before starting work</li><li>Use professional tools and follow safety standards</li><li>Clean work area and dispose of debris per customer agreement</li><li>Do not solicit off-platform payment or future bookings bypassing Gletra</li></ul>', 'policies/sections/service-booking-policy-provider-responsibilities-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(917, 24, 'Disputes and Quality Issues', '<p>File service disputes within 7 days via My Bookings &gt; Report Issue. Include photos, description, and chat records. Gletra mediates and may issue partial refunds, free re-service, or full refunds based on evidence.</p>', 'policies/sections/service-booking-policy-disputes-and-quality-issues-section-800x400.svg', 'notice', 9, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(918, 24, 'Recurring and Subscription Services', '<p>Gletra offers recurring bookings for cleaning and maintenance services. Subscriptions auto-renew unless cancelled 48 hours before next scheduled visit. Subscription pricing locked for 3-month minimum term.</p>', 'policies/sections/service-booking-policy-recurring-and-subscription-services-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(919, 25, 'Gletra Guarantee — Marketplace', '<p>You are protected when:</p><ul class=\"mb-3\"><li>Item not delivered within promised timeframe (or at all)</li><li>Item significantly not as described in listing</li><li>Item is counterfeit or materially different from photos</li><li>Wrong item received and seller unresponsive</li><li>Item arrives damaged due to shipping (with photo evidence)</li></ul><p>File a claim within 30 days of expected or actual delivery date via My Orders &gt; Get Help &gt; Gletra Guarantee.</p>', 'policies/sections/customer-protection-policy-gletra-guarantee-marketplace-section-800x400.svg', 'highlight', 1, 1, '2026-06-19 06:52:14', '2026-06-19 06:52:14'),
(920, 25, 'Gletra Guarantee — Home Services', '<ul class=\"mb-3\"><li>Provider no-show after confirmed booking</li><li>Service not performed or abandoned mid-job</li><li>Work quality materially below professional standards (with evidence)</li><li>Damage to property caused by provider during service</li><li>Overcharging beyond approved quote</li></ul><p>File within 7 days of scheduled service date via My Bookings &gt; Report Issue.</p>', 'policies/sections/customer-protection-policy-gletra-guarantee-home-services-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(921, 25, 'Coverage Limits', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Transaction Type</th><th>Max Protection</th><th>Claim Window</th></tr></thead><tbody><tr><td>Standard product order</td><td>Full order value up to ₹1,00,000</td><td>30 days from delivery</td></tr><tr><td>High-value order (&gt;₹1,00,000)</td><td>Full value; enhanced review</td><td>30 days; may require additional verification</td></tr><tr><td>Home service booking</td><td>Full booking value up to ₹50,000</td><td>7 days from service date</td></tr><tr><td>Wallet transaction (fraud)</td><td>Full unauthorized amount</td><td>24 hours from discovery</td></tr></tbody></table></div>', 'policies/sections/customer-protection-policy-coverage-limits-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(922, 25, 'Exclusions', '<p>Customer Protection does not cover:</p><ul class=\"mb-3\"><li>Off-platform payments or bookings arranged outside Gletra</li><li>Buyer\'s remorse or change of mind (see Return Policy instead)</li><li>Items damaged by buyer after delivery</li><li>Services where customer approved final work and marked complete</li><li>Digital goods after download or access granted</li><li>Perishable goods after delivery acceptance</li><li>Claims filed outside applicable time windows</li></ul>', 'policies/sections/customer-protection-policy-exclusions-section-800x400.svg', 'notice', 4, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(923, 25, 'Filing a Protection Claim', '<ol class=\"mb-3\"><li>Navigate to My Orders or My Bookings and select the transaction</li><li>Choose issue type and provide detailed description</li><li>Upload supporting evidence: photos, videos, chat screenshots</li><li>Submit claim; receive acknowledgment within 24 hours</li><li>Cooperate with investigation; respond to requests within 72 hours</li><li>Receive decision notification with refund or resolution details</li></ol>', 'policies/sections/customer-protection-policy-filing-a-protection-claim-section-800x400.svg', 'content', 5, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(924, 25, 'Investigation and Resolution Timeline', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Stage</th><th>Timeline</th><th>Action</th></tr></thead><tbody><tr><td>Acknowledgment</td><td>24 hours</td><td>Claim ID assigned; initial review</td></tr><tr><td>Seller/provider response</td><td>72 hours</td><td>Other party may submit counter-evidence</td></tr><tr><td>Gletra decision</td><td>7 business days (standard)</td><td>Refund, replacement, or rejection with reason</td></tr><tr><td>Appeal</td><td>5 days from decision</td><td>One appeal with new evidence</td></tr></tbody></table></div>', 'policies/sections/customer-protection-policy-investigation-and-resolution-timeline-section-800x400.svg', 'highlight', 6, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(925, 25, 'Fraud Protection', '<p>Gletra monitors transactions for fraud using machine learning, device fingerprinting, and behavioral analysis. Suspicious orders may be held for verification. Buyers are never liable for verified unauthorized wallet or card transactions reported within 24 hours.</p><p>Report suspected fraud immediately: fraud@gletra.com or Account Settings &gt; Security &gt; Report Unauthorized Activity.</p>', 'policies/sections/customer-protection-policy-fraud-protection-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(926, 25, 'Chat and Call Safety in Disputes', '<p>Gletra may review chat messages and call metadata related to disputed transactions. Users who attempt to manipulate outcomes through false claims, collusion, or evidence fabrication forfeit protection eligibility and face account termination.</p>', 'policies/sections/customer-protection-policy-chat-and-call-safety-in-disputes-section-800x400.svg', 'notice', 8, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(927, 25, 'Compensation Beyond Refund', '<p>In exceptional cases — significant inconvenience, repeat seller failures, or service failures — Gletra may offer additional wallet credit at its discretion. This is not guaranteed and does not set precedent.</p>', 'policies/sections/customer-protection-policy-compensation-beyond-refund-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(928, 25, 'Contact', '<p>Customer Protection team: protection@gletra.com. Live chat in app 8 AM–10 PM IST. Emergency safety issues: use in-app Emergency button during active home service bookings.</p>', 'policies/sections/customer-protection-policy-contact-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:15', '2026-06-19 06:52:15'),
(929, 26, 'Account and Digital Safety', '<ul class=\"mb-3\"><li>Use a strong, unique password and enable two-factor authentication</li><li>Never share OTPs, passwords, UPI PINs, or CVV codes with anyone</li><li>Gletra staff will never ask for your password or OTP via chat or call</li><li>Log out on shared devices; review active sessions in Account Settings</li><li>Verify gletra.com URL; beware of phishing sites mimicking Gletra</li></ul>', 'policies/sections/safety-guidelines-account-and-digital-safety-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(930, 26, 'Safe Shopping Practices', '<ol class=\"mb-3\"><li>Check seller ratings, review count, and response time before purchasing</li><li>Read product descriptions carefully; verify return eligibility</li><li>Use Gletra checkout only — never pay sellers directly via UPI or bank transfer</li><li>Inspect high-value items at delivery; report damage before accepting</li><li>Keep order confirmations and chat records until transaction is fully resolved</li></ol>', 'policies/sections/safety-guidelines-safe-shopping-practices-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(931, 26, 'Chat and Communication Safety', '<p>Gletra Chat is for transaction-related communication. Safety rules:</p><ul class=\"mb-3\"><li>Do not share Aadhaar, PAN, full card numbers, or home security details unnecessarily</li><li>Block and report users who send harassment, threats, or inappropriate content</li><li>Be cautious of links sent in chat; verify they point to gletra.com domains</li><li>Report requests to move conversation to personal WhatsApp for payment</li></ul>', 'policies/sections/safety-guidelines-chat-and-communication-safety-section-800x400.svg', 'notice', 3, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(932, 26, 'Voice and Video Call Safety', '<ul class=\"mb-3\"><li>Use Gletra in-app calling rather than sharing personal phone numbers when possible</li><li>Do not share screen showing sensitive financial or identity documents</li><li>End calls immediately if the other party behaves inappropriately; report via call log</li><li>Recording calls without all-party consent may violate local law — do not record without consent</li></ul>', 'policies/sections/safety-guidelines-voice-and-video-call-safety-section-800x400.svg', 'content', 4, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(933, 26, 'In-Home Service Safety', '<h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Before the Appointment</h4><ul class=\"mb-3\"><li>Verify provider identity matches Gletra app profile and ID badge</li><li>Share appointment details with a trusted contact</li><li>Secure valuables and restrict access to sensitive areas</li><li>Ensure an adult (18+) will be present throughout the service</li></ul><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">During the Service</h4><ul class=\"mb-3\"><li>Maintain visibility of the provider\'s work area</li><li>Do not leave provider alone in home unless necessary and trusted</li><li>Use in-app Emergency button for immediate safety concerns</li><li>Decline requests to pay in cash if you prepaid through Gletra</li></ul>', 'policies/sections/safety-guidelines-in-home-service-safety-section-800x400.svg', 'highlight', 5, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(934, 26, 'Local Pickup and Meeting Safety', '<p>For local pickup orders or buyer-seller meetings:</p><ul class=\"mb-3\"><li>Meet in public, well-lit locations during daytime hours</li><li>Bring a companion when possible</li><li>Inspect items before completing payment</li><li>Do not invite strangers to your home except for verified Gletra service bookings</li></ul>', 'policies/sections/safety-guidelines-local-pickup-and-meeting-safety-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(935, 26, 'Recognizing Scams', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Scam Type</th><th>Warning Signs</th><th>Action</th></tr></thead><tbody><tr><td>Fake Gletra support</td><td>Unsolicited call asking for OTP or remote access</td><td>Hang up; contact support@gletra.com only</td></tr><tr><td>Payment redirect</td><td>Seller asks to pay via personal UPI</td><td>Refuse; report seller</td></tr><tr><td>Phishing link</td><td>Chat link to non-gletra.com login page</td><td>Do not click; report message</td></tr><tr><td>Too-good-to-be-true listing</td><td>Premium product at 90% discount</td><td>Verify seller; use Customer Protection</td></tr></tbody></table></div>', 'policies/sections/safety-guidelines-recognizing-scams-section-800x400.svg', 'notice', 7, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(936, 26, 'Reporting Safety Issues', '<p>Report via: in-app Report button (chat, calls, orders, bookings), safety@gletra.com, or Emergency button during active home services. Gletra Safety Team responds to emergency reports within 15 minutes 24/7.</p>', 'policies/sections/safety-guidelines-reporting-safety-issues-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(937, 26, 'Children and Vulnerable Users', '<p>Gletra is not intended for users under 18. Parents should supervise minors\' internet use. Vulnerable users should arrange for a trusted adult during in-home services and high-value transactions.</p>', 'policies/sections/safety-guidelines-children-and-vulnerable-users-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(938, 26, 'Seller and Provider Safety', '<p>Sellers and service providers should: verify buyer identity for high-value orders, avoid sharing personal contact details unnecessarily, report threatening buyer behavior, and use Gletra\'s documented channels for all communication to maintain evidence for disputes.</p>', 'policies/sections/safety-guidelines-seller-and-provider-safety-section-800x400.svg', 'highlight', 10, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(939, 27, 'Absolutely Prohibited Items', '<p>The following categories are strictly banned on Gletra:</p><ul class=\"mb-3\"><li>Weapons, firearms, ammunition, explosives, and weapon components</li><li>Illegal drugs, controlled substances, and drug paraphernalia</li><li>Counterfeit goods, unauthorized replicas, and fake branded products</li><li>Stolen property and items without clear legal title</li><li>Human remains, organs, body parts, and related materials</li><li>Unauthorized prescription medications and unapproved medical devices</li><li>Child exploitation material and content sexualizing minors</li><li>Hate propaganda, extremist materials, and discriminatory content</li><li>Wildlife products from endangered species (ivory, rhino horn, etc.)</li><li>Currency, counterfeit money, and unauthorized financial instruments</li></ul>', 'policies/sections/prohibited-items-policy-absolutely-prohibited-items-section-800x400.svg', 'notice', 1, 1, '2026-06-19 06:52:16', '2026-06-19 06:52:16'),
(940, 27, 'Prohibited Services', '<ul class=\"mb-3\"><li>Unlicensed medical, dental, or surgical procedures</li><li>Illegal gambling, betting, and lottery services</li><li>Escort, adult entertainment, and sexual services</li><li>Unlicensed financial advisory, crypto mining, or Ponzi schemes</li><li>Services requiring licenses the provider does not hold (certain electrical/plumbing work above permitted scope)</li><li>Surveillance equipment for illegal interception</li></ul>', 'policies/sections/prohibited-items-policy-prohibited-services-section-800x400.svg', 'notice', 2, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(941, 27, 'Restricted Items Requiring Approval', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Category</th><th>Requirements</th><th>Approval Process</th></tr></thead><tbody><tr><td>Alcohol and beverages</td><td>Valid liquor license; age verification at delivery</td><td>compliance@gletra.com + license upload</td></tr><tr><td>Tobacco and vaping products</td><td>GST registration; age 21+ verification</td><td>Restricted category application</td></tr><tr><td>Adult products (legal category)</td><td>Age verification; no obscene imagery in listings</td><td>Category unlock request</td></tr><tr><td>Precious metals and gems</td><td>BIS hallmark; authenticity certificate</td><td>High-value seller verification</td></tr><tr><td>Agricultural chemicals and pesticides</td><td>Licensed dealer certificate</td><td>Document review</td></tr><tr><td>Medical equipment (non-prescription)</td><td>CDSCO compliance where applicable</td><td>Category application</td></tr></tbody></table></div>', 'policies/sections/prohibited-items-policy-restricted-items-requiring-approval-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(942, 27, 'Marketplace Listing Violations', '<p>Common listing violations beyond prohibited categories:</p><ul class=\"mb-3\"><li>Products with false safety certifications (fake ISI, BIS marks)</li><li>Items recalled by manufacturer or government authority</li><li>Products exceeding legal quantity limits (certain chemicals, batteries)</li><li>Listings designed to circumvent category restrictions (miscategorization)</li><li>Drop-shipped items from unauthorized sources</li></ul>', 'policies/sections/prohibited-items-policy-marketplace-listing-violations-section-800x400.svg', 'highlight', 4, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17');
INSERT INTO `policy_sections` (`id`, `policy_id`, `title`, `content`, `image`, `section_type`, `sort_order`, `status`, `created_at`, `updated_at`) VALUES
(943, 27, 'Home Services Restrictions', '<p>Gletra Home Services providers may not offer:</p><ul class=\"mb-3\"><li>Gas line modifications without valid gas fitter license</li><li>Structural demolition without municipal permits</li><li>Asbestos removal or hazardous material abatement</li><li>Pest control using banned chemical agents</li><li>Electrical work exceeding provider\'s verified license class</li></ul><p>Providers must accurately declare license scope during KYC registration.</p>', 'policies/sections/prohibited-items-policy-home-services-restrictions-section-800x400.svg', 'content', 5, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(944, 27, 'Chat and Communication Restrictions', '<p>Users may not use Gletra Chat or calls to offer, solicit, or facilitate sale of prohibited items or off-platform transactions involving restricted goods.</p>', 'policies/sections/prohibited-items-policy-chat-and-communication-restrictions-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(945, 27, 'Detection and Enforcement', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Violation Severity</th><th>First Offense</th><th>Repeat Offense</th></tr></thead><tbody><tr><td>Critical (weapons, drugs, CSAM)</td><td>Permanent ban; law enforcement referral</td><td>N/A</td></tr><tr><td>Major (counterfeit, stolen goods)</td><td>Permanent ban; wallet hold</td><td>N/A</td></tr><tr><td>Moderate (miscategorization, restricted without approval)</td><td>Listing removal; 7-day suspension</td><td>30-day or permanent ban</td></tr><tr><td>Minor (policy edge case)</td><td>Listing removal; warning</td><td>Escalating suspension</td></tr></tbody></table></div>', 'policies/sections/prohibited-items-policy-detection-and-enforcement-section-800x400.svg', 'legal_update', 7, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(946, 27, 'Reporting Prohibited Items', '<p>Report prohibited listings via product page \"Report\" button or compliance@gletra.com. Include listing URL, category concern, and supporting evidence. Gletra reviews reports within 24 hours for critical categories.</p>', 'policies/sections/prohibited-items-policy-reporting-prohibited-items-section-800x400.svg', 'highlight', 8, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(947, 27, 'Seller Responsibilities', '<p>Sellers must maintain current knowledge of prohibited items, verify product legality before listing, retain supplier documentation, and immediately remove listings for recalled or banned products upon notification.</p>', 'policies/sections/prohibited-items-policy-seller-responsibilities-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(948, 27, 'Policy Updates', '<p>This list is updated as laws change and new risk patterns emerge. Subscribe to Seller Panel announcements for policy updates. Last comprehensive review: annual cycle.</p>', 'policies/sections/prohibited-items-policy-policy-updates-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:17', '2026-06-19 06:52:17'),
(949, 28, 'Types of Disputes Covered', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Dispute Category</th><th>Examples</th><th>Filing Window</th></tr></thead><tbody><tr><td>Product — non-delivery</td><td>Item never arrived; tracking shows no delivery</td><td>30 days from expected delivery</td></tr><tr><td>Product — quality</td><td>Defective, damaged, not as described</td><td>30 days from delivery</td></tr><tr><td>Service — performance</td><td>Incomplete work, poor quality, scope disagreement</td><td>7 days from service date</td></tr><tr><td>Service — no-show</td><td>Provider did not arrive</td><td>24 hours from scheduled time</td></tr><tr><td>Payment — billing</td><td>Overcharge, duplicate charge, unauthorized transaction</td><td>24 hours–30 days by type</td></tr><tr><td>Communication — conduct</td><td>Harassment, threats via chat or calls</td><td>30 days from incident</td></tr></tbody></table></div>', 'policies/sections/dispute-resolution-policy-types-of-disputes-covered-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(950, 28, 'Pre-Dispute Requirements', '<ol class=\"mb-3\"><li>Attempt direct resolution via Gletra Chat or in-app call</li><li>Document the issue with photos, screenshots, and order/booking details</li><li>Review applicable policy (Return, Refund, Cancellation, Service Booking)</li><li>File formal dispute only after 48 hours without satisfactory seller/provider response (except emergencies)</li></ol>', 'policies/sections/dispute-resolution-policy-pre-dispute-requirements-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(951, 28, 'Filing a Dispute', '<p>Access Dispute Center from My Orders, My Bookings, or Account Settings &gt; Help &gt; Dispute Center.</p><ul class=\"mb-3\"><li>Select transaction and dispute category</li><li>Describe issue with specific details (dates, amounts, expectations vs. reality)</li><li>Upload evidence: photos, videos, chat exports, receipts</li><li>Specify desired resolution: full refund, partial refund, replacement, re-service</li><li>Submit; receive Dispute ID for tracking</li></ul>', 'policies/sections/dispute-resolution-policy-filing-a-dispute-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(952, 28, 'Mediation Process', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Phase</th><th>Timeline</th><th>Description</th></tr></thead><tbody><tr><td>Acknowledgment</td><td>24 hours</td><td>Dispute assigned to Gletra mediator</td></tr><tr><td>Seller/provider response</td><td>72 hours</td><td>Other party submits counter-evidence</td></tr><tr><td>Evidence review</td><td>2–5 business days</td><td>Mediator evaluates all submissions</td></tr><tr><td>Decision</td><td>7 business days total (standard)</td><td>Binding platform decision issued</td></tr><tr><td>Appeal</td><td>5 days from decision</td><td>One appeal with new material evidence</td></tr></tbody></table></div>', 'policies/sections/dispute-resolution-policy-mediation-process-section-800x400.svg', 'highlight', 4, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(953, 28, 'Evidence Standards', '<h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Accepted Evidence</h4><ul class=\"mb-3\"><li>Gletra order/booking records</li><li>In-app chat messages</li><li>Delivery tracking data</li><li>Timestamped photos/videos</li><li>Call logs (metadata from Gletra system)</li></ul><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Limited Weight Evidence</h4><ul class=\"mb-3\"><li>Off-platform WhatsApp messages (unless corroborated)</li><li>Unverified third-party statements</li><li>Evidence created after dispute filing without prior documentation</li></ul>', 'policies/sections/dispute-resolution-policy-evidence-standards-section-800x400.svg', 'content', 5, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(954, 28, 'Possible Outcomes', '<ul class=\"mb-3\"><li>Full refund to original payment method or Gletra Wallet</li><li>Partial refund based on assessed damage or incomplete service</li><li>Replacement item shipped at seller expense</li><li>Free re-service by same or different provider</li><li>No refund — claim rejected with written reasoning</li><li>Account action against party found in violation (warning, suspension)</li></ul>', 'policies/sections/dispute-resolution-policy-possible-outcomes-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(955, 28, 'Financial Holds During Disputes', '<p>When a dispute is filed, seller or provider payouts for the disputed transaction are held until resolution. If refund is ordered, held amount is returned to buyer. If dispute is rejected, held amount is released to seller/provider.</p>', 'policies/sections/dispute-resolution-policy-financial-holds-during-disputes-section-800x400.svg', 'notice', 7, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(956, 28, 'Escalation and Arbitration', '<p>If appeal is denied or dispute involves amounts exceeding ₹5,00,000, either party may request binding arbitration per Gletra Terms & Conditions. Arbitration conducted in Bengaluru, Karnataka under Indian Arbitration and Conciliation Act. Small claims court remedies remain available where applicable.</p>', 'policies/sections/dispute-resolution-policy-escalation-and-arbitration-section-800x400.svg', 'legal_update', 8, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(957, 28, 'Abuse of Dispute Process', '<p>Frivolous, fraudulent, or repetitive disputes filed to harass sellers or obtain unjustified refunds result in loss of Customer Protection eligibility, account restrictions, and potential legal action for fraud.</p>', 'policies/sections/dispute-resolution-policy-abuse-of-dispute-process-section-800x400.svg', 'notice', 9, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(958, 28, 'Contact', '<p>Dispute Center in app. Email: disputes@gletra.com with Dispute ID. Response within 24 hours for acknowledgment.</p>', 'policies/sections/dispute-resolution-policy-contact-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:18', '2026-06-19 06:52:18'),
(959, 29, 'Regulatory Framework', '<p>Gletra\'s AML program addresses requirements under:</p><ul class=\"mb-3\"><li>Prevention of Money Laundering Act, 2002 (PMLA) and amendments</li><li>RBI Master Direction on Prepaid Payment Instruments</li><li>FEMA regulations for cross-border transactions where applicable</li><li>IT Act provisions on intermediary due diligence</li><li>Sanctions lists issued by UN, OFAC, and Indian government</li></ul>', 'policies/sections/aml-policy-regulatory-framework-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(960, 29, 'Customer Due Diligence (CDD)', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>User Category</th><th>CDD Requirement</th><th>Trigger</th></tr></thead><tbody><tr><td>All sellers</td><td>Full KYC + business verification</td><td>Registration</td></tr><tr><td>Service providers</td><td>Individual KYC + background check</td><td>Registration</td></tr><tr><td>Wallet users (withdrawal)</td><td>Individual KYC + bank verification</td><td>First withdrawal</td></tr><tr><td>High-value buyers</td><td>Enhanced verification</td><td>Single transaction &gt; ₹2,00,000</td></tr><tr><td>All users</td><td>Ongoing monitoring</td><td>Continuous automated screening</td></tr></tbody></table></div>', 'policies/sections/aml-policy-customer-due-diligence-cdd-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(961, 29, 'Enhanced Due Diligence (EDD)', '<p>EDD applies to: politically exposed persons (PEPs), users from high-risk jurisdictions, accounts with unusual transaction patterns, sellers in high-risk categories (precious metals, electronics), and any account flagged by automated risk scoring.</p><p>EDD measures include senior management approval, source of funds documentation, increased monitoring frequency, and transaction limits.</p>', 'policies/sections/aml-policy-enhanced-due-diligence-edd-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(962, 29, 'Transaction Monitoring', '<p>Gletra employs automated systems monitoring for:</p><ul class=\"mb-3\"><li>Structuring: multiple transactions just below reporting thresholds</li><li>Rapid wallet top-up and immediate withdrawal cycles</li><li>Unusual seller payout patterns inconsistent with sales history</li><li>High refund rates combined with new account activity</li><li>Cross-border payment anomalies</li><li>Matches against sanctions and PEP databases</li></ul><p>Flagged transactions are reviewed by the Compliance Team within 24 hours.</p>', 'policies/sections/aml-policy-transaction-monitoring-section-800x400.svg', 'highlight', 4, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(963, 29, 'Suspicious Activity Reporting (SAR)', '<p>When Gletra identifies suspicious activity that may indicate money laundering or terrorist financing, we file Suspicious Transaction Reports (STRs) with FIU-IND as required by law. Users are not notified of SAR filings where notification is prohibited.</p><p>Indicators include: inability to explain source of funds, reluctance to provide KYC documents, transactions with no apparent economic purpose, and use of multiple accounts to obscure identity.</p>', 'policies/sections/aml-policy-suspicious-activity-reporting-sar-section-800x400.svg', 'notice', 5, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(964, 29, 'Prohibited Activities', '<ul class=\"mb-3\"><li>Using Gletra to launder proceeds of crime</li><li>Structuring transactions to avoid reporting thresholds</li><li>Using stolen payment instruments or compromised accounts</li><li>Shell seller accounts for pass-through transactions</li><li>Off-platform payment schemes to obscure transaction trails</li><li>Transactions involving sanctioned individuals or entities</li></ul>', 'policies/sections/aml-policy-prohibited-activities-section-800x400.svg', 'legal_update', 6, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(965, 29, 'Record Keeping', '<p>Gletra maintains transaction records, KYC documents, and compliance reports for a minimum of 7 years from account closure or last transaction, whichever is later. Records are stored securely and made available to regulators upon lawful request.</p>', 'policies/sections/aml-policy-record-keeping-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(966, 29, 'Employee Training and Governance', '<p>Gletra\'s Compliance Officer oversees the AML program. All employees handling financial transactions, KYC review, or seller onboarding receive annual AML training. The program is audited internally every 12 months and by external auditors biennially.</p>', 'policies/sections/aml-policy-employee-training-and-governance-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(967, 29, 'Sanctions Screening', '<p>All users are screened against UN Security Council sanctions lists, OFAC SDN list, and Indian Ministry of Home Affairs proscribed entity lists at onboarding and continuously thereafter. Matches result in account blocking and regulatory reporting.</p>', 'policies/sections/aml-policy-sanctions-screening-section-800x400.svg', 'highlight', 9, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(968, 29, 'User Cooperation and Contact', '<p>Users must provide accurate information and respond to compliance inquiries within 7 days. Non-cooperation results in account restriction. AML inquiries: compliance@gletra.com. Compliance Officer: aml-officer@gletra.com.</p>', 'policies/sections/aml-policy-user-cooperation-and-contact-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:19', '2026-06-19 06:52:19'),
(969, 30, 'Data Controller Information', '<p><strong>Data Controller:</strong> Gletra Technologies Pvt. Ltd., 42 Brigade Tech Park, Whitefield, Bengaluru, Karnataka 560066, India.</p><p><strong>EU Representative:</strong> Where required, Gletra appoints an EU representative accessible at dpo@gletra.com for EEA data subject inquiries.</p><p><strong>Data Protection Officer:</strong> dpo@gletra.com</p>', 'policies/sections/gdpr-compliance-data-controller-information-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(970, 30, 'Legal Bases for Processing', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Processing Activity</th><th>Legal Basis</th><th>GDPR Article</th></tr></thead><tbody><tr><td>Account creation and order fulfillment</td><td>Contract performance</td><td>Art. 6(1)(b)</td></tr><tr><td>KYC and AML compliance</td><td>Legal obligation</td><td>Art. 6(1)(c)</td></tr><tr><td>Fraud prevention and platform security</td><td>Legitimate interests</td><td>Art. 6(1)(f)</td></tr><tr><td>Marketing communications</td><td>Consent</td><td>Art. 6(1)(a)</td></tr><tr><td>Chat and call metadata storage</td><td>Legitimate interests / Contract</td><td>Art. 6(1)(f)/(b)</td></tr><tr><td>Analytics and product improvement</td><td>Legitimate interests (with opt-out)</td><td>Art. 6(1)(f)</td></tr></tbody></table></div>', 'policies/sections/gdpr-compliance-legal-bases-for-processing-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(971, 30, 'Personal Data Categories Processed', '<ul class=\"mb-3\"><li>Identity data: name, email, phone, date of birth, government ID (KYC)</li><li>Transaction data: orders, bookings, payments, wallet activity</li><li>Communication data: chat messages, call metadata, support tickets</li><li>Technical data: IP address, device ID, browser type, cookies</li><li>Location data: delivery address, service location (with consent for GPS)</li><li>Profile data: preferences, reviews, seller/service provider credentials</li></ul>', 'policies/sections/gdpr-compliance-personal-data-categories-processed-section-800x400.svg', 'content', 3, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(972, 30, 'Your GDPR Rights', '<h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right of Access (Art. 15)</h4><p>Request a copy of personal data Gletra holds about you.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Rectification (Art. 16)</h4><p>Correct inaccurate personal data via Account Settings or dpo@gletra.com.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Erasure (Art. 17)</h4><p>Request deletion where no legal retention obligation exists.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Restriction (Art. 18)</h4><p>Limit processing during dispute resolution or objection review.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Data Portability (Art. 20)</h4><p>Receive your data in structured, machine-readable format.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Object (Art. 21)</h4><p>Object to processing based on legitimate interests or for direct marketing.</p><h4 class=\"h6 fw-bold mt-3 mb-2 text-dark\">Right to Withdraw Consent (Art. 7)</h4><p>Withdraw marketing consent anytime via Account Settings without affecting prior lawful processing.</p>', 'policies/sections/gdpr-compliance-your-gdpr-rights-section-800x400.svg', 'highlight', 4, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(973, 30, 'Exercising Your Rights', '<p>Submit requests to dpo@gletra.com with subject \"GDPR Data Subject Request.\" Include account email and request type. Gletra responds within 30 days (extendable by 60 days for complex requests with notice). Identity verification required before disclosure.</p>', 'policies/sections/gdpr-compliance-exercising-your-rights-section-800x400.svg', 'content', 5, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(974, 30, 'International Data Transfers', '<p>Personal data of EEA/UK users may be transferred to India and other countries where Gletra or its processors operate. Transfers are protected by:</p><ul class=\"mb-3\"><li>Standard Contractual Clauses (SCCs) approved by European Commission</li><li>UK International Data Transfer Agreement where applicable</li><li>Adequacy decisions where recognized by relevant authorities</li><li>Supplementary measures including encryption and access controls</li></ul>', 'policies/sections/gdpr-compliance-international-data-transfers-section-800x400.svg', 'notice', 6, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(975, 30, 'Data Processors and Sub-Processors', '<p>Gletra engages vetted processors for payment processing, cloud hosting, KYC verification, email delivery, and analytics. All processors are bound by Data Processing Agreements requiring GDPR-equivalent protections. Sub-processor list available on request from dpo@gletra.com.</p>', 'policies/sections/gdpr-compliance-data-processors-and-sub-processors-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(976, 30, 'Data Retention for EEA/UK Users', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Data Category</th><th>Retention Period</th><th>Basis</th></tr></thead><tbody><tr><td>Account profile</td><td>Account lifetime + 2 years</td><td>Contract / legal claims</td></tr><tr><td>Transaction records</td><td>7 years</td><td>Tax and AML legal obligation</td></tr><tr><td>Chat messages</td><td>3 years from last activity</td><td>Dispute resolution legitimate interest</td></tr><tr><td>Marketing consent records</td><td>Duration of consent + 3 years</td><td>Legal obligation to demonstrate consent</td></tr><tr><td>KYC documents</td><td>7 years after account closure</td><td>AML legal obligation</td></tr></tbody></table></div>', 'policies/sections/gdpr-compliance-data-retention-for-eeauk-users-section-800x400.svg', 'content', 8, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(977, 30, 'Automated Decision-Making', '<p>Gletra uses automated systems for fraud scoring, product recommendations, and search ranking. These do not produce legal or similarly significant effects without human review. You may request human review of automated fraud holds by contacting dpo@gletra.com.</p>', 'policies/sections/gdpr-compliance-automated-decision-making-section-800x400.svg', 'notice', 9, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(978, 30, 'Complaints and Supervisory Authority', '<p>You have the right to lodge a complaint with your local data protection supervisory authority. Gletra encourages contacting our DPO first at dpo@gletra.com to resolve concerns. List of EU supervisory authorities: edpb.europa.eu.</p>', 'policies/sections/gdpr-compliance-complaints-and-supervisory-authority-section-800x400.svg', 'legal_update', 10, 1, '2026-06-19 06:52:20', '2026-06-19 06:52:20'),
(979, 31, 'Company Information', '<p><strong>Legal Name:</strong> Gletra Technologies Pvt. Ltd.</p><p><strong>Registered Office:</strong><br>42, Brigade Tech Park, 1st Floor, Whitefield Main Road,<br>Whitefield, Bengaluru, Karnataka 560066, India</p><p><strong>Corporate Identity Number (CIN):</strong> U72900KA2021PTC145678</p><p><strong>GSTIN:</strong> 29AABCG1234F1Z5</p><p><strong>Website:</strong> https://www.gletra.com</p>', 'policies/sections/contact-legal-company-information-section-800x400.svg', 'content', 1, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(980, 31, 'Department Contact Channels', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Department</th><th>Email</th><th>Purpose</th></tr></thead><tbody><tr><td>General Support</td><td>support@gletra.com</td><td>Orders, bookings, refunds, account help</td></tr><tr><td>Legal</td><td>legal@gletra.com</td><td>Legal notices, contracts, litigation</td></tr><tr><td>Privacy / DPO</td><td>dpo@gletra.com</td><td>GDPR requests, privacy inquiries</td></tr><tr><td>Copyright</td><td>copyright@gletra.com</td><td>IP infringement notices</td></tr><tr><td>Compliance / AML</td><td>compliance@gletra.com</td><td>AML inquiries, regulatory correspondence</td></tr><tr><td>KYC</td><td>kyc@gletra.com</td><td>Identity verification support</td></tr><tr><td>Payments</td><td>payments@gletra.com</td><td>Payment and settlement issues</td></tr><tr><td>Wallet</td><td>wallet@gletra.com</td><td>Wallet balance and withdrawal</td></tr><tr><td>Safety</td><td>safety@gletra.com</td><td>Safety reports and emergencies</td></tr><tr><td>Fraud</td><td>fraud@gletra.com</td><td>Fraud and unauthorized activity</td></tr><tr><td>Disputes</td><td>disputes@gletra.com</td><td>Formal dispute escalation</td></tr><tr><td>Seller Support</td><td>seller-support@gletra.com</td><td>Seller panel and settlements</td></tr><tr><td>Abuse</td><td>abuse@gletra.com</td><td>Spam, harassment, platform abuse</td></tr></tbody></table></div>', 'policies/sections/contact-legal-department-contact-channels-section-800x400.svg', 'highlight', 2, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(981, 31, 'Grievance Officer (IT Rules 2021)', '<p><strong>Name:</strong> Ms. Priya Sharma, Grievance Officer</p><p><strong>Email:</strong> grievance@gletra.com</p><p><strong>Address:</strong> Gletra Technologies Pvt. Ltd., 42 Brigade Tech Park, Whitefield, Bengaluru 560066, India</p><p>The Grievance Officer acknowledges complaints within 24 hours and aims to resolve them within 15 days. For content-related grievances under IT Rules 2021, include the content URL and nature of complaint.</p>', 'policies/sections/contact-legal-grievance-officer-it-rules-2021-section-800x400.svg', 'notice', 3, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(982, 31, 'Legal Notices and Service of Process', '<p>Legal notices, court orders, and service of process must be delivered to:</p><ol class=\"mb-3\"><li>Registered Office (registered post or courier with acknowledgment)</li><li>Electronic copy to legal@gletra.com (PDF format with sender verification)</li></ol><p>Gletra does not accept legal service via social media, chat, or general support email without \"Legal Notice\" designation.</p>', 'policies/sections/contact-legal-legal-notices-and-service-of-process-section-800x400.svg', 'legal_update', 4, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(983, 31, 'Regulatory and Law Enforcement', '<p>Law enforcement and regulatory agencies may contact compliance@gletra.com with official credentials and legal authority documentation. Gletra responds to lawful requests in accordance with applicable law and our Law Enforcement Guidelines.</p>', 'policies/sections/contact-legal-regulatory-and-law-enforcement-section-800x400.svg', 'content', 5, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(984, 31, 'Media and Press Inquiries', '<p>Media inquiries: press@gletra.com. Gletra\'s communications team responds to verified media requests within 2 business days.</p>', 'policies/sections/contact-legal-media-and-press-inquiries-section-800x400.svg', 'content', 6, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(985, 31, 'Business and Partnership Inquiries', '<p>Enterprise sellers, brand partnerships, and API integrations: partner-support@gletra.com or visit gletra.com/partners.</p>', 'policies/sections/contact-legal-business-and-partnership-inquiries-section-800x400.svg', 'content', 7, 1, '2026-06-19 06:52:21', '2026-06-19 06:52:21'),
(986, 31, 'Office Hours and Support Availability', '<div class=\"table-responsive mb-3\"><table class=\"table table-bordered table-sm\"><thead class=\"table-light\"><tr><th>Channel</th><th>Hours (IST)</th><th>Languages</th></tr></thead><tbody><tr><td>Live chat (in-app)</td><td>8:00 AM – 10:00 PM daily</td><td>English, Hindi</td></tr><tr><td>Email support</td><td>24/7 intake; response 8 AM–10 PM</td><td>English, Hindi</td></tr><tr><td>Emergency safety (home services)</td><td>24/7</td><td>English, Hindi</td></tr><tr><td>Legal / compliance email</td><td>Business days; 24/7 intake</td><td>English</td></tr></tbody></table></div>', 'policies/sections/contact-legal-office-hours-and-support-availability-section-800x400.svg', 'highlight', 8, 1, '2026-06-19 06:52:22', '2026-06-19 06:52:22'),
(987, 31, 'Accessibility', '<p>Gletra is committed to digital accessibility. Report accessibility barriers to accessibility@gletra.com.</p>', 'policies/sections/contact-legal-accessibility-section-800x400.svg', 'content', 9, 1, '2026-06-19 06:52:22', '2026-06-19 06:52:22'),
(988, 31, 'Policy Document Index', '<p>All Gletra policies are available at gletra.com/legal. Key documents include Privacy Policy, Terms & Conditions, Payment Terms, Wallet Policy, KYC Verification Policy, Customer Protection Policy, and this Contact & Legal Information page.</p>', 'policies/sections/contact-legal-policy-document-index-section-800x400.svg', 'content', 10, 1, '2026-06-19 06:52:22', '2026-06-19 06:52:22');

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

--
-- Table structure for table `price_change_requests`
--

CREATE TABLE `price_change_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `current_price` decimal(10,2) NOT NULL,
  `current_sale_price` decimal(10,2) DEFAULT NULL,
  `requested_price` decimal(10,2) NOT NULL,
  `requested_sale_price` decimal(10,2) DEFAULT NULL,
  `approved_price` decimal(10,2) DEFAULT NULL,
  `approved_sale_price` decimal(10,2) DEFAULT NULL,
  `reason` text NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `admin_remark` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `price_history_logs`
--

CREATE TABLE `price_history_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `admin_id` bigint(20) UNSIGNED DEFAULT NULL,
  `old_price` decimal(10,2) NOT NULL,
  `new_price` decimal(10,2) NOT NULL,
  `old_sale_price` decimal(10,2) DEFAULT NULL,
  `new_sale_price` decimal(10,2) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `source` varchar(50) NOT NULL DEFAULT 'admin_direct',
  `price_change_request_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(200) DEFAULT NULL,
  `primary_image` varchar(255) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `short_description` varchar(500) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `weight` decimal(8,2) NOT NULL DEFAULT 0.50,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `sku` varchar(100) DEFAULT NULL,
  `product_code` varchar(50) DEFAULT NULL,
  `barcode` varchar(64) DEFAULT NULL,
  `print_sku_on_image` tinyint(1) NOT NULL DEFAULT 1,
  `hsn_code` varchar(20) DEFAULT NULL,
  `gst_rate` decimal(5,2) NOT NULL DEFAULT 18.00,
  `stock_qty` int(11) NOT NULL DEFAULT 0,
  `low_stock_threshold` int(10) UNSIGNED NOT NULL DEFAULT 5,
  `product_type` enum('simple','variable','digital') DEFAULT NULL,
  `listing_type` enum('own','affiliate') NOT NULL DEFAULT 'own',
  `affiliate_source` enum('amazon','flipkart','meesho','myntra','other') DEFAULT NULL,
  `affiliate_url` varchar(500) DEFAULT NULL,
  `affiliate_status` enum('pending','approved','rejected') DEFAULT NULL,
  `affiliate_admin_remark` text DEFAULT NULL,
  `affiliate_reviewed_at` timestamp NULL DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `is_live` tinyint(1) NOT NULL DEFAULT 0,
  `approved_at` timestamp NULL DEFAULT NULL,
  `is_cod_available` tinyint(1) NOT NULL DEFAULT 1,
  `is_prepaid_available` tinyint(1) NOT NULL DEFAULT 1,
  `length` decimal(8,2) DEFAULT NULL,
  `width` decimal(8,2) DEFAULT NULL,
  `height` decimal(8,2) DEFAULT NULL,
  `is_featured` tinyint(4) NOT NULL DEFAULT 0,
  `average_rating` decimal(3,2) NOT NULL DEFAULT 0.00,
  `rating_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_flash_sale` tinyint(1) NOT NULL DEFAULT 0,
  `flash_sale_price` decimal(15,2) DEFAULT NULL,
  `is_deal_of_the_day` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ai_tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`ai_tags`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_analytics_daily`
--

CREATE TABLE `product_analytics_daily` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `unique_views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `clicks` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `unique_clicks` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `searches` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `page_visits` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cart_adds` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `wishlist_adds` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `checkout_starts` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `orders` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `units_sold` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revenue` decimal(14,2) NOT NULL DEFAULT 0.00,
  `returns` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cancellations` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `conversion_rate` decimal(8,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_analytics_insights`
--

CREATE TABLE `product_analytics_insights` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `insight_type` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `severity` varchar(20) NOT NULL DEFAULT 'medium',
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `metrics` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metrics`)),
  `recommendations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`recommendations`)),
  `detected_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_analytics_recommendations`
--

CREATE TABLE `product_analytics_recommendations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `recommendation_type` varchar(50) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `action_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`action_items`)),
  `priority` tinyint(3) UNSIGNED NOT NULL DEFAULT 5,
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_answers`
--

CREATE TABLE `product_answers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_question_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `answer` text NOT NULL,
  `is_vendor_reply` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_attributes`
--

CREATE TABLE `product_attributes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `type` enum('text','select','color','number') NOT NULL DEFAULT 'select',
  `is_filterable` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_attribute_product`
--

CREATE TABLE `product_attribute_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `product_attribute_value_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_attribute_values`
--

CREATE TABLE `product_attribute_values` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_attribute_id` bigint(20) UNSIGNED NOT NULL,
  `value` varchar(255) NOT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `color_hex` varchar(7) DEFAULT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_comparisons`
--

CREATE TABLE `product_comparisons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_galleries`
--

CREATE TABLE `product_galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_health_scores`
--

CREATE TABLE `product_health_scores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `grade` varchar(20) NOT NULL DEFAULT 'needs_attention',
  `views_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `clicks_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `orders_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `conversion_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `revenue_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `returns_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `ratings_score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `period` varchar(20) NOT NULL DEFAULT '30d',
  `computed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `is_primary` tinyint(4) NOT NULL DEFAULT 0,
  `hash` varchar(64) DEFAULT NULL,
  `overlay_number` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_questions`
--

CREATE TABLE `product_questions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `question` text NOT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_tags`
--

CREATE TABLE `product_tags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `tag` varchar(255) NOT NULL,
  `is_ai_generated` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_types`
--

CREATE TABLE `product_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(150) NOT NULL,
  `slug` varchar(150) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `display_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_updates`
--

CREATE TABLE `product_updates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `updated_fields` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`updated_fields`)),
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `admin_remark` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variants`
--

CREATE TABLE `product_variants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sale_price` decimal(10,2) DEFAULT NULL,
  `stock_qty` int(11) NOT NULL DEFAULT 0,
  `sku` varchar(255) DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `combination_key` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `barcode` varchar(64) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_variant_values`
--

CREATE TABLE `product_variant_values` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_id` bigint(20) UNSIGNED NOT NULL,
  `variant_value_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_view_logs`
--

CREATE TABLE `product_view_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `session_id` varchar(64) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `source_page` varchar(100) DEFAULT NULL,
  `view_duration_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `was_shared` tinyint(1) NOT NULL DEFAULT 0,
  `added_to_cart` tinyint(1) NOT NULL DEFAULT 0,
  `added_to_wishlist` tinyint(1) NOT NULL DEFAULT 0,
  `purchased` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `promotional_campaigns`
--

CREATE TABLE `promotional_campaigns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('banner','email','push','sms') NOT NULL DEFAULT 'banner',
  `target_rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`target_rules`)),
  `starts_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `push_notification_devices`
--

CREATE TABLE `push_notification_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `device_token` varchar(255) NOT NULL,
  `platform` enum('web','android','ios') NOT NULL DEFAULT 'web',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_id` bigint(20) UNSIGNED NOT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `worker_id` bigint(20) UNSIGNED NOT NULL,
  `rating` tinyint(3) UNSIGNED NOT NULL,
  `comment` text DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `recently_vieweds`
--

CREATE TABLE `recently_vieweds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `viewed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reels`
--

CREATE TABLE `reels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `video` varchar(255) NOT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `caption` text DEFAULT NULL,
  `music_name` varchar(255) DEFAULT NULL,
  `music_url` varchar(255) DEFAULT NULL,
  `trim_start` decimal(8,2) NOT NULL DEFAULT 0.00,
  `duration` decimal(8,2) DEFAULT NULL,
  `views` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `likes_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reel_comments`
--

CREATE TABLE `reel_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reel_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `body` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reel_likes`
--

CREATE TABLE `reel_likes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reel_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `referral_type` varchar(20) NOT NULL DEFAULT 'customer',
  `referrer_id` bigint(20) UNSIGNED NOT NULL,
  `referred_user_id` bigint(20) UNSIGNED NOT NULL,
  `coins_earned` decimal(12,2) NOT NULL DEFAULT 0.00,
  `coins_unlocked` decimal(12,2) NOT NULL DEFAULT 0.00,
  `status` enum('pending','successful','flagged','blocked') NOT NULL DEFAULT 'pending',
  `ip_address` varchar(45) DEFAULT NULL,
  `device_id` varchar(255) DEFAULT NULL,
  `first_order_at` timestamp NULL DEFAULT NULL,
  `is_fraud` tinyint(1) NOT NULL DEFAULT 0,
  `risk_score` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` (`id`, `referral_type`, `referrer_id`, `referred_user_id`, `coins_earned`, `coins_unlocked`, `status`, `ip_address`, `device_id`, `first_order_at`, `is_fraud`, `risk_score`, `created_at`, `updated_at`) VALUES
(1, 'customer', 26, 27, 100.00, 0.00, 'pending', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36127.0.0.1', NULL, 0, 0, '2026-07-06 21:07:17', '2026-07-06 21:07:17'),
(2, 'customer', 26, 28, 100.00, 100.00, 'successful', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36127.0.0.1', '2026-07-07 02:53:16', 0, 0, '2026-07-07 02:53:16', '2026-07-07 02:53:16');

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

--
-- Table structure for table `refund_requests`
--

CREATE TABLE `refund_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(15,2) NOT NULL,
  `reason` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `admin_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `related_products`
--

CREATE TABLE `related_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `related_product_id` bigint(20) UNSIGNED NOT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `return_requests`
--

CREATE TABLE `return_requests` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('return','exchange','cancel') NOT NULL DEFAULT 'return',
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`items`)),
  `reason` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('pending','approved','rejected','picked_up','completed') NOT NULL DEFAULT 'pending',
  `admin_note` text DEFAULT NULL,
  `refund_amount` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `booking_id` bigint(20) UNSIGNED DEFAULT NULL,
  `worker_id` bigint(20) UNSIGNED DEFAULT NULL,
  `review_type` varchar(20) NOT NULL DEFAULT 'product',
  `rating` int(11) DEFAULT NULL,
  `review` text DEFAULT NULL,
  `vendor_reply` text DEFAULT NULL,
  `replied_at` timestamp NULL DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`images`)),
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `reward_points`
--

CREATE TABLE `reward_points` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `points` int(11) NOT NULL,
  `type` varchar(20) NOT NULL,
  `description` varchar(255) NOT NULL,
  `reference_type` varchar(255) DEFAULT NULL,
  `reference_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'web', '2026-01-24 11:47:11', '2026-01-24 11:47:11'),
(2, 'Admin', 'web', '2026-01-24 11:47:11', '2026-01-24 11:47:11'),
(3, 'Vendor', 'web', '2026-01-24 11:47:11', '2026-01-24 11:47:11'),
(4, 'Vendor Staff', 'web', '2026-01-24 11:47:11', '2026-01-24 11:47:11'),
(5, 'Customer', 'web', '2026-01-24 11:47:11', '2026-01-24 11:47:11'),
(6, 'special_user', 'web', '2026-01-25 15:59:48', '2026-01-25 15:59:48'),
(7, 'Designer', 'web', '2026-01-27 12:07:59', '2026-01-27 12:07:59'),
(8, 'User', 'web', '2026-01-27 12:07:59', '2026-01-27 12:07:59'),
(9, 'Support', 'web', '2026-02-08 11:39:48', '2026-02-08 11:39:48'),
(10, 'Editor', 'web', '2026-02-08 11:39:48', '2026-02-08 11:39:48');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(2, 1),
(2, 2),
(3, 1),
(3, 2),
(4, 1),
(4, 2),
(4, 3),
(4, 4),
(5, 1),
(5, 2),
(6, 1),
(6, 2),
(6, 3),
(6, 4),
(6, 5),
(7, 1),
(7, 2),
(8, 1),
(8, 3),
(9, 1),
(10, 1),
(11, 1),
(11, 3),
(11, 5),
(12, 1),
(13, 1),
(14, 1),
(14, 2),
(15, 1),
(15, 2),
(16, 1),
(17, 1),
(18, 7),
(19, 7),
(20, 7),
(21, 7),
(22, 7),
(23, 7),
(24, 7),
(25, 7),
(26, 7),
(27, 7),
(28, 7),
(29, 7),
(30, 7),
(31, 7),
(32, 7),
(33, 7),
(34, 7),
(33, 9),
(34, 9);

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

--
-- Table structure for table `scheduled_messages`
--

CREATE TABLE `scheduled_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `conversation_id` bigint(20) UNSIGNED NOT NULL,
  `body` text DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'text',
  `media_path` varchar(255) DEFAULT NULL,
  `send_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `search_analytics_daily`
--

CREATE TABLE `search_analytics_daily` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `normalized_keyword` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `search_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `cart_adds` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `orders_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `no_purchase_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `search_to_cart_ratio` decimal(8,4) NOT NULL DEFAULT 0.0000,
  `search_to_order_ratio` decimal(8,4) NOT NULL DEFAULT 0.0000,
  `conversion_rate` decimal(8,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `search_analytics_logs`
--

CREATE TABLE `search_analytics_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `normalized_keyword` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` varchar(64) DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`product_ids`)),
  `result_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `led_to_cart` tinyint(1) NOT NULL DEFAULT 0,
  `led_to_order` tinyint(1) NOT NULL DEFAULT 0,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `search_no_product_logs`
--

CREATE TABLE `search_no_product_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `keyword` varchar(255) NOT NULL,
  `normalized_keyword` varchar(255) NOT NULL,
  `search_count` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `first_searched_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `last_searched_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `section_settings`
--

CREATE TABLE `section_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `section_name` varchar(255) NOT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `section_settings`
--

INSERT INTO `section_settings` (`id`, `section_name`, `order`, `is_enabled`, `settings`, `created_at`, `updated_at`) VALUES
(1, 'hero', 1, 1, '{\"padding\":\"0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(2, 'trust_bar', 2, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(3, 'categories', 3, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(4, 'featured', 4, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#f8f9fa\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(5, 'new_arrivals', 5, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(6, 'promo', 6, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(7, 'vendors', 7, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52'),
(8, 'all_products', 8, 1, '{\"padding\":\"50px 0\",\"bg_color\":\"#ffffff\"}', '2026-01-27 12:13:52', '2026-01-27 12:13:52');

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

--
-- Table structure for table `seller_bank_accounts`
--

CREATE TABLE `seller_bank_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `account_holder_name` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `account_number` varchar(255) NOT NULL,
  `ifsc_code` varchar(20) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_flash_sales`
--

CREATE TABLE `seller_flash_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `starts_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `discount_percentage` decimal(5,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_kyc_documents`
--

CREATE TABLE `seller_kyc_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `aadhaar_front` varchar(255) DEFAULT NULL,
  `aadhaar_back` varchar(255) DEFAULT NULL,
  `pan_card` varchar(255) DEFAULT NULL,
  `selfie_photo` varchar(255) DEFAULT NULL,
  `bank_proof` varchar(255) DEFAULT NULL,
  `bank_proof_type` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_orders`
--

CREATE TABLE `seller_orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `order_number` varchar(255) NOT NULL,
  `marketplace_order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_email` varchar(255) DEFAULT NULL,
  `customer_mobile` varchar(255) DEFAULT NULL,
  `shipping_address` text DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `subtotal` decimal(12,2) NOT NULL DEFAULT 0.00,
  `commission` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `seller_earnings` decimal(12,2) NOT NULL DEFAULT 0.00,
  `invoice_path` varchar(255) DEFAULT NULL,
  `shipping_label_path` varchar(255) DEFAULT NULL,
  `tracking_number` varchar(255) DEFAULT NULL,
  `accepted_at` timestamp NULL DEFAULT NULL,
  `packed_at` timestamp NULL DEFAULT NULL,
  `shipped_at` timestamp NULL DEFAULT NULL,
  `delivered_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_order_items`
--

CREATE TABLE `seller_order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_order_id` bigint(20) UNSIGNED NOT NULL,
  `seller_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_name` varchar(255) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `quantity` int(10) UNSIGNED NOT NULL DEFAULT 1,
  `unit_price` decimal(12,2) NOT NULL,
  `total_price` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_order_notes`
--

CREATE TABLE `seller_order_notes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_order_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `note` text NOT NULL,
  `is_internal` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_products`
--

CREATE TABLE `seller_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `brand` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `subcategory` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `price` decimal(12,2) NOT NULL DEFAULT 0.00,
  `sale_price` decimal(12,2) DEFAULT NULL,
  `stock` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `weight` decimal(10,3) DEFAULT NULL,
  `length` decimal(10,2) DEFAULT NULL,
  `width` decimal(10,2) DEFAULT NULL,
  `height` decimal(10,2) DEFAULT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `rejection_reason` text DEFAULT NULL,
  `low_stock_threshold` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_product_images`
--

CREATE TABLE `seller_product_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_product_id` bigint(20) UNSIGNED NOT NULL,
  `path` varchar(255) NOT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_profiles`
--

CREATE TABLE `seller_profiles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `shop_name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `pan_number` varchar(20) NOT NULL,
  `kyc_status` varchar(255) NOT NULL DEFAULT 'pending',
  `kyc_rejection_reason` text DEFAULT NULL,
  `kyc_submitted_at` timestamp NULL DEFAULT NULL,
  `kyc_approved_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `product_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_promotions`
--

CREATE TABLE `seller_promotions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `seller_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`rules`)),
  `starts_at` timestamp NULL DEFAULT NULL,
  `ends_at` timestamp NULL DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_settings`
--

CREATE TABLE `seller_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `store_name` varchar(255) DEFAULT NULL,
  `store_logo` varchar(255) DEFAULT NULL,
  `store_banner` varchar(255) DEFAULT NULL,
  `store_description` text DEFAULT NULL,
  `store_address` text DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `tiktok` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seller_wallets`
--

CREATE TABLE `seller_wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seller_profile_id` bigint(20) UNSIGNED NOT NULL,
  `available_balance` decimal(14,2) NOT NULL DEFAULT 0.00,
  `pending_balance` decimal(14,2) NOT NULL DEFAULT 0.00,
  `total_earned` decimal(14,2) NOT NULL DEFAULT 0.00,
  `total_withdrawn` decimal(14,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `seo_metas`
--

CREATE TABLE `seo_metas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `seoable_type` varchar(255) DEFAULT NULL,
  `seoable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `url_path` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `canonical_url` varchar(255) DEFAULT NULL,
  `robots` varchar(255) NOT NULL DEFAULT 'index, follow',
  `og_image` varchar(255) DEFAULT NULL,
  `schema_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`schema_data`)),
  `is_indexable` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `base_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `price_type` varchar(20) NOT NULL DEFAULT 'fixed',
  `duration_minutes` int(10) UNSIGNED DEFAULT NULL,
  `is_emergency` tinyint(1) NOT NULL DEFAULT 0,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `service_booking_items`
--

CREATE TABLE `service_booking_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(150) NOT NULL,
  `price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `image` varchar(255) DEFAULT NULL,
  `sort_order` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `group` varchar(255) NOT NULL DEFAULT 'general',
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `group`, `value`, `created_at`, `updated_at`) VALUES
(1, 'site_name', 'general', 'Gletra', '2026-01-24 10:53:03', '2026-06-20 16:42:38'),
(2, 'contact_email', 'general', 'admin@gletra.com', '2026-01-24 10:53:03', '2026-01-24 10:53:03'),
(3, 'currency_symbol', 'general', '$', '2026-01-24 10:53:03', '2026-06-28 20:51:12'),
(4, 'commission_rate', 'general', '10', '2026-01-24 10:53:03', '2026-01-24 10:53:03'),
(5, 'tax_rate', 'general', '10', '2026-01-24 10:53:03', '2026-01-24 10:53:03'),
(6, 'footer_text', 'general', '© 2026 Gletra Multi-Vendor E-commerce. All rights reserved.', '2026-01-24 10:53:03', '2026-06-28 20:51:12'),
(7, 'shipping_model', 'shipping', 'flat', '2026-01-25 11:05:50', '2026-01-25 11:05:50'),
(8, 'flat_rate_amount', 'shipping', '10', '2026-01-25 11:05:50', '2026-01-25 11:05:50'),
(9, 'free_shipping_threshold', 'shipping', '199', '2026-01-25 11:05:50', '2026-07-04 13:59:20'),
(10, 'est_delivery_msg', 'shipping', 'Estimated delivery within 3-5 business days.', '2026-01-25 11:05:50', '2026-01-25 11:05:50'),
(11, 'delivery_slots_enabled', 'shipping', '1', '2026-01-27 12:53:16', '2026-01-27 12:53:16'),
(12, 'shiprocket_enabled', 'shipping', '1', '2026-01-27 12:53:16', '2026-01-27 12:53:16'),
(13, 'shiprocket_email', 'shipping', 'rajubarnala@gmail.com', '2026-01-27 12:53:16', '2026-02-09 20:39:34'),
(14, 'shiprocket_password', 'shipping', 'FQy4HArVdBbZ87AHrbfdhSXRgyE5NUbrh6GaL8enMUeh.eyJzdWIiOjk0NjYyMjAsInNvdXJjZSI6InNyLWF1dGgtaW50IiwiZXhwIjoxNzcxNTIzNzEyLCJqdGkiOiJJNzlSU1JpOFNaV05kMUZEIiwiaWF0IjoxNzcwNjU5NzEyLCJpc3MiOiJodHRwczovL3NyLWF1dGguc2hpcHJvY2parameter is either empty or invalid.ZiI6Mparameter is either empty or invalid.0YyI6MzYwLCJ2ZXJib3NlIjpmYWxzZSwidmVuZG9yX2lkIjowLCJ2ZW5kb3JfY29kZSI6IiJ9.2YAgzMz3fjGAI0q8gvQIDyNCv0HSVeCxJStwaLsKEW8', '2026-01-27 12:53:16', '2026-02-09 20:39:34'),
(15, 'return_policy_days', 'order', '5', '2026-01-27 12:54:16', '2026-06-20 17:18:42'),
(16, 'auto_cancel_hours', 'order', '48', '2026-01-27 12:54:16', '2026-01-27 12:54:16'),
(17, 'auto_invoice_gen', 'order', '1', '2026-01-27 12:54:16', '2026-01-27 12:54:16'),
(18, 'user_reg_enabled', 'user', '1', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(19, 'otp_login_enabled', 'user', '1', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(20, 'guest_checkout_enabled', 'user', '1', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(21, 'signup_bonus', 'user', '0', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(22, 'loyalty_points_rate', 'user', '1', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(23, 'referral_enabled', 'user', '1', '2026-01-27 12:54:46', '2026-01-27 12:54:46'),
(24, 'email_notif_enabled', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(25, 'sms_notif_enabled', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(26, 'push_notif_enabled', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(27, 'notify_order_placed', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(28, 'notify_order_shipped', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(29, 'admin_notify_new_order', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(30, 'vendor_notify_new_order', 'notification', '1', '2026-01-27 12:55:17', '2026-01-27 12:55:17'),
(31, 'seo_meta_title', 'seo', 'Gletra - Best Multi-Vendor Ecommerce Platform', '2026-01-27 12:59:46', '2026-01-27 12:59:46'),
(32, 'seo_meta_desc', 'seo', 'Shop thousands of products from local vendors on Gletra. Quality service and guaranteed delivery.', '2026-01-27 12:59:46', '2026-01-27 12:59:46'),
(33, 'seo_meta_keywords', 'seo', 'ecommerce, multivendor, gletra, shopping,shipping,men,women,kids,home,fashion,jellwey', '2026-01-27 12:59:46', '2026-01-27 12:59:46'),
(34, 'seo_og_tags', 'seo', '1', '2026-01-27 12:59:46', '2026-01-27 12:59:46'),
(35, 'seo_robots_txt', 'seo', 'User-agent: *\r\nDisallow: /admin/\r\nDisallow: /vendor/', '2026-01-27 12:59:46', '2026-01-27 12:59:46'),
(36, 'site_url', 'general', 'http://127.0.0.1:8000', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(37, 'admin_email', 'general', 'admin@gletra.com', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(38, 'support_email', 'general', 'support@gletra.com', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(39, 'support_phone', 'general', '+800-9041-823-725', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(40, 'default_language', 'general', 'en', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(41, 'timezone', 'general', 'UTC', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(42, 'date_format', 'general', 'd M, Y', '2026-02-02 20:33:48', '2026-06-19 13:43:22'),
(43, 'site_enabled', 'general', '1', '2026-02-02 20:33:48', '2026-02-02 20:33:48'),
(44, 'social_links', 'site', '{\"facebook\":null,\"twitter\":null,\"instagram\":null,\"linkedin\":null}', '2026-02-02 20:34:20', '2026-02-02 20:34:20'),
(45, 'site_favicon', 'site', 'uploads/settings/PRu8w9VCAfzaiS4w79KaImX3W0bn5dDSvB7BNHls.png', '2026-02-02 20:34:20', '2026-02-02 20:34:20'),
(46, 'default_country', 'localization', 'IN', '2026-02-02 20:34:57', '2026-02-02 20:34:57'),
(47, 'default_state', 'localization', 'California', '2026-02-02 20:34:57', '2026-02-02 20:34:57'),
(48, 'default_city', 'localization', 'San Francisco', '2026-02-02 20:34:57', '2026-02-02 20:34:57'),
(49, 'direction', 'localization', 'ltr', '2026-02-02 20:34:57', '2026-02-02 20:34:57'),
(50, 'unit_system', 'localization', 'metric', '2026-02-02 20:34:57', '2026-02-02 20:34:57'),
(51, 'currency_code', 'currency', 'INR', '2026-02-02 20:37:56', '2026-02-02 20:37:56'),
(52, 'currency_placement', 'currency', 'before', '2026-02-02 20:37:56', '2026-02-02 20:37:56'),
(53, 'currency_decimal_separator', 'currency', '.', '2026-02-02 20:37:56', '2026-02-02 20:37:56'),
(54, 'currency_thousand_separator', 'currency', ',', '2026-02-02 20:37:56', '2026-02-02 20:37:56'),
(55, 'currency_decimal_digits', 'currency', '1', '2026-02-02 20:37:56', '2026-02-06 11:38:34'),
(56, 'watermark_opacity', 'media', '20', '2026-02-02 20:41:22', '2026-02-02 20:41:22'),
(57, 'watermark_image', 'media', 'uploads/settings/iohkMWuJ5lHaOEtZ521XNDARiPf5AvbslpnNIxk4.png', '2026-02-02 20:41:22', '2026-02-02 20:41:22'),
(58, 'flash_sale_title', 'promotions', 'Flash Sale!', '2026-02-09 04:18:21', '2026-02-09 04:18:21'),
(59, 'flash_sale_description', 'promotions', 'Limited period offers on premium sarees and ethnic wear.', '2026-02-09 04:18:21', '2026-02-09 04:18:21'),
(60, 'flash_sale_link', 'promotions', 'http://127.0.0.1:8000/shop', '2026-02-09 04:18:21', '2026-02-09 04:18:21'),
(61, 'flash_sale_button_text', 'promotions', 'GO TO SALE', '2026-02-09 04:18:21', '2026-02-09 04:18:21'),
(62, 'flash_sale_image', 'promotions', 'uploads/settings/xujvwTkzcGIXtJyWtuED3dLxNYZEX41y8ErvQOFv.jpg', '2026-02-09 04:18:22', '2026-02-09 04:18:22'),
(63, 'gletra_best_title', 'promotions', 'Gletra Best', '2026-02-09 04:18:44', '2026-02-09 04:18:44'),
(64, 'gletra_best_description', 'promotions', 'Curated collection of top-rated appliances and gadgets.', '2026-02-09 04:18:44', '2026-02-09 04:18:44'),
(65, 'gletra_best_link', 'promotions', 'http://127.0.0.1:8000/shop', '2026-02-09 04:18:44', '2026-02-09 04:18:44'),
(66, 'gletra_best_button_text', 'promotions', 'BROWSE ALL', '2026-02-09 04:18:44', '2026-02-09 04:18:44'),
(67, 'gletra_best_image', 'promotions', 'uploads/settings/iiKnFqatU1nypAwNroFhpYejxXZICx9xWbFbA15C.jpg', '2026-02-09 04:18:44', '2026-02-09 04:18:44'),
(68, 'source_protection', 'site', 'disabled', '2026-02-10 04:15:19', '2026-07-05 09:18:33'),
(69, 'own_product_commission_mode', 'commission', 'disabled', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(70, 'own_product_commission_type', 'commission', 'percentage', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(71, 'own_product_commission_value', 'commission', '0', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(72, 'affiliate_commission_mode', 'commission', 'enabled', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(73, 'affiliate_commission_type', 'commission', 'percentage', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(74, 'affiliate_commission_value', 'commission', '5', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(75, 'settlement_hold_days', 'commission', '5', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(76, 'auto_payout_enabled', 'commission', 'disabled', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(77, 'auto_payout_frequency', 'commission', 'weekly', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(78, 'auto_payout_provider', 'commission', 'manual', '2026-06-19 13:17:43', '2026-06-19 13:17:43'),
(79, 'otp_delivery_enabled', 'order', '1', '2026-06-20 17:18:42', '2026-06-20 17:18:42'),
(80, 'maintenance_mode', 'maintenance', '0', '2026-06-20 17:19:16', '2026-06-27 23:48:22'),
(81, 'maintenance_message', 'maintenance', 'We are currently under maintenance for improvements. We will be back shortly!', '2026-06-20 17:19:16', '2026-06-20 17:19:16'),
(82, 'maintenance_ips', 'maintenance', '127.0.0.1', '2026-06-20 17:19:16', '2026-06-20 17:19:16'),
(83, 'minimum_order_amount', 'order', '100', '2026-07-04 13:59:20', '2026-07-04 13:59:20'),
(84, 'wallet_minimum_order_amount', 'wallet', '199', '2026-07-04 13:59:21', '2026-07-04 13:59:21');

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

--
-- Table structure for table `shippings`
--

CREATE TABLE `shippings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `courier_name` varchar(100) DEFAULT NULL,
  `tracking_number` varchar(150) DEFAULT NULL,
  `shipping_status` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shipping_rates`
--

CREATE TABLE `shipping_rates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `shipping_zone_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `min_weight` decimal(10,2) NOT NULL DEFAULT 0.00,
  `max_weight` decimal(10,2) DEFAULT NULL,
  `rate` decimal(15,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `shipping_zones`
--

CREATE TABLE `shipping_zones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `state_code` varchar(255) DEFAULT NULL,
  `country_code` varchar(2) NOT NULL DEFAULT 'IN',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `site_settings`
--

CREATE TABLE `site_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `primary_color` varchar(255) NOT NULL DEFAULT '#4f46e5',
  `secondary_color` varchar(255) NOT NULL DEFAULT '#ec4899',
  `app_bg_color` varchar(255) NOT NULL DEFAULT '#f8f9fa',
  `primary_dark` varchar(255) NOT NULL DEFAULT '#1e1b4b',
  `primary_hover` varchar(255) NOT NULL DEFAULT '#4338ca',
  `accent_color` varchar(255) NOT NULL DEFAULT '#fb641b',
  `gradient_end_color` varchar(255) NOT NULL DEFAULT '#7c3aed',
  `text_color` varchar(255) NOT NULL DEFAULT '#1e293b',
  `text_muted` varchar(255) NOT NULL DEFAULT '#64748b',
  `link_color` varchar(255) NOT NULL DEFAULT '#4f46e5',
  `card_bg` varchar(255) NOT NULL DEFAULT '#ffffff',
  `border_color` varchar(255) NOT NULL DEFAULT '#e2e8f0',
  `header_bg` varchar(255) NOT NULL DEFAULT '#50113c',
  `footer_bg` varchar(255) NOT NULL DEFAULT '#0f172a',
  `success_color` varchar(255) NOT NULL DEFAULT '#10b981',
  `warning_color` varchar(255) NOT NULL DEFAULT '#f59e0b',
  `danger_color` varchar(255) NOT NULL DEFAULT '#ef4444',
  `info_color` varchar(255) NOT NULL DEFAULT '#3b82f6',
  `theme_color` varchar(255) NOT NULL DEFAULT '#4f46e5',
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `site_settings`
--

INSERT INTO `site_settings` (`id`, `primary_color`, `secondary_color`, `app_bg_color`, `primary_dark`, `primary_hover`, `accent_color`, `gradient_end_color`, `text_color`, `text_muted`, `link_color`, `card_bg`, `border_color`, `header_bg`, `footer_bg`, `success_color`, `warning_color`, `danger_color`, `info_color`, `theme_color`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, '#0a2947', '#cc7700', '#f3f4f6', '#1e1b4b', '#4338ca', '#fb641b', '#7c3aed', '#1e293b', '#64748b', '#4f46e5', '#ffffff', '#e2e8f0', '#50113c', '#0f172a', '#10b981', '#f59e0b', '#ef4444', '#3b82f6', '#4f46e5', 1, '2026-02-01 19:20:33', '2026-07-07 11:16:53');

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

--
-- Table structure for table `sku_counters`
--

CREATE TABLE `sku_counters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `prefix` varchar(255) NOT NULL DEFAULT 'G',
  `current_value` bigint(20) UNSIGNED NOT NULL DEFAULT 100000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) NOT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `order_priority` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `page` varchar(20) NOT NULL DEFAULT 'home',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `starred_messages`
--

CREATE TABLE `starred_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `message_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `country_id`, `name`, `code`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 'Delhi', 'DL', 1, '2026-06-16 03:59:35', '2026-06-16 03:59:35', NULL);

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

--
-- Table structure for table `statuses`
--

CREATE TABLE `statuses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'text',
  `content` text DEFAULT NULL,
  `media_path` varchar(255) DEFAULT NULL,
  `background_color` varchar(255) DEFAULT NULL,
  `text_color` varchar(20) DEFAULT NULL,
  `font_style` varchar(40) DEFAULT NULL,
  `privacy` varchar(20) NOT NULL DEFAULT 'contacts',
  `is_archived` tinyint(1) NOT NULL DEFAULT 0,
  `view_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `expires_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `media_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `statuses`
--

INSERT INTO `statuses` (`id`, `user_id`, `type`, `content`, `media_path`, `background_color`, `text_color`, `font_style`, `privacy`, `is_archived`, `view_count`, `expires_at`, `created_at`, `updated_at`, `media_id`) VALUES
(1, 1, 'text', 'hi', NULL, '#128C7E', '#ffffff', 'sans-serif', 'contacts', 0, 2, '2026-07-07 08:18:20', '2026-07-06 21:25:54', '2026-07-07 02:48:20', NULL),
(4, 27, 'video', NULL, 'chat/videos/2026/07/pEuZzuz3DOt0JDD4Hx8HudXeBMD20ckGEHRrgdXa.mp4', '#128C7E', '#ffffff', 'sans-serif', 'everyone', 0, 2, '2026-07-07 15:08:22', '2026-07-06 22:05:09', '2026-07-07 09:38:22', 6),
(6, 27, 'video', NULL, 'chat/videos/2026/07/3C1D7JbBIL911wKE9EgsxdOXUfa8DhRMB62VJGNB.mp4', '#128C7E', '#ffffff', 'sans-serif', 'everyone', 0, 2, '2026-07-07 15:08:22', '2026-07-06 22:49:54', '2026-07-07 09:38:22', 7),
(7, 27, 'audio', 'tumre liye', 'chat/audio/2026/07/TGOCcuVoQGVYr1rgS6MfVi0uNGdDrWkRv3PrtHHv.mp3', '#128C7E', '#ffffff', 'sans-serif', 'everyone', 0, 2, '2026-07-07 15:08:23', '2026-07-06 22:54:40', '2026-07-07 09:38:23', 8),
(8, 26, 'video', NULL, 'chat/videos/2026/07/NYCelD5tDKTmMgBMOfCil85zIAAHjR3KapTNqiTw.mp4', '#128C7E', '#ffffff', 'sans-serif', 'contacts', 0, 0, '2026-07-07 15:08:23', '2026-07-07 02:33:29', '2026-07-07 09:38:23', 9),
(9, 26, 'image', NULL, 'chat/images/2026/07/oF9QwlrqWRLBjqtnXH09LrfMgO4JvmRjZOknHoeU.jpg', '#128C7E', '#ffffff', 'sans-serif', 'contacts', 0, 0, '2026-07-07 15:08:23', '2026-07-07 08:42:46', '2026-07-07 09:38:23', 10);

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

--
-- Table structure for table `status_archives`
--

CREATE TABLE `status_archives` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `archived_user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `status_mutes`
--

CREATE TABLE `status_mutes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `muted_user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `status_privacy_users`
--

CREATE TABLE `status_privacy_users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `status_reactions`
--

CREATE TABLE `status_reactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `emoji` varchar(32) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_reactions`
--

INSERT INTO `status_reactions` (`id`, `status_id`, `user_id`, `emoji`, `created_at`, `updated_at`) VALUES
(3, 1, 27, '❤️', '2026-07-06 22:01:35', '2026-07-06 22:01:35'),
(5, 4, 1, '❤️', '2026-07-06 22:44:34', '2026-07-06 22:44:34'),
(6, 6, 1, '👍', '2026-07-06 22:51:05', '2026-07-06 22:51:05');

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

--
-- Table structure for table `status_replies`
--

CREATE TABLE `status_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` bigint(20) UNSIGNED NOT NULL,
  `message` text DEFAULT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'text',
  `media_path` varchar(255) DEFAULT NULL,
  `sticker_id` bigint(20) UNSIGNED DEFAULT NULL,
  `gif_url` varchar(255) DEFAULT NULL,
  `message_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_replies`
--

INSERT INTO `status_replies` (`id`, `status_id`, `sender_id`, `message`, `type`, `media_path`, `sticker_id`, `gif_url`, `message_id`, `created_at`, `updated_at`) VALUES
(3, 4, 1, 'nice', 'text', NULL, NULL, NULL, 406, '2026-07-06 22:05:47', '2026-07-06 22:05:47');

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

--
-- Table structure for table `status_views`
--

CREATE TABLE `status_views` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `status_id` bigint(20) UNSIGNED NOT NULL,
  `viewer_id` bigint(20) UNSIGNED NOT NULL,
  `viewed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `status_views`
--

INSERT INTO `status_views` (`id`, `status_id`, `viewer_id`, `viewed_at`, `created_at`, `updated_at`) VALUES
(2, 1, 27, '2026-07-06 22:00:42', '2026-07-06 22:00:42', '2026-07-06 22:00:42'),
(4, 4, 1, '2026-07-06 22:05:37', '2026-07-06 22:05:37', '2026-07-06 22:05:37'),
(5, 6, 1, '2026-07-06 22:50:52', '2026-07-06 22:50:52', '2026-07-06 22:50:52'),
(6, 7, 1, '2026-07-06 22:58:43', '2026-07-06 22:58:43', '2026-07-06 22:58:43'),
(7, 4, 26, '2026-07-07 02:17:21', '2026-07-07 02:17:21', '2026-07-07 02:17:21'),
(8, 6, 26, '2026-07-07 02:17:39', '2026-07-07 02:17:39', '2026-07-07 02:17:39'),
(9, 7, 26, '2026-07-07 02:47:43', '2026-07-07 02:47:43', '2026-07-07 02:47:43'),
(10, 1, 26, '2026-07-07 02:48:20', '2026-07-07 02:48:20', '2026-07-07 02:48:20');

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

--
-- Table structure for table `stickers`
--

CREATE TABLE `stickers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `category` varchar(50) NOT NULL,
  `image_url` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `media_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `store_followers`
--

CREATE TABLE `store_followers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `subscriber_type` varchar(30) NOT NULL,
  `subscriber_id` bigint(20) UNSIGNED NOT NULL,
  `membership_plan_id` bigint(20) UNSIGNED NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `starts_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ends_at` timestamp NULL DEFAULT NULL,
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_activity_logs`
--

CREATE TABLE `support_activity_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `action` varchar(80) NOT NULL,
  `subject_type` varchar(255) DEFAULT NULL,
  `subject_id` bigint(20) UNSIGNED DEFAULT NULL,
  `description` text NOT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_replies`
--

CREATE TABLE `support_replies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `assigned_to` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `priority` varchar(255) NOT NULL DEFAULT 'medium',
  `category` varchar(255) NOT NULL DEFAULT 'general',
  `escalated_to_admin` tinyint(1) NOT NULL DEFAULT 0,
  `escalation_reason` text DEFAULT NULL,
  `escalated_at` timestamp NULL DEFAULT NULL,
  `escalated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `internal_note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `support_ticket_attachments`
--

CREATE TABLE `support_ticket_attachments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `support_ticket_id` bigint(20) UNSIGNED NOT NULL,
  `path` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `file_size` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `rate` decimal(5,2) NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT 'percentage',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `theme_settings`
--

CREATE TABLE `theme_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `traffic_source_daily`
--

CREATE TABLE `traffic_source_daily` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `traffic_source` varchar(50) NOT NULL,
  `visitors` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `unique_visitors` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `orders` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `revenue` decimal(14,2) NOT NULL DEFAULT 0.00,
  `conversion_rate` decimal(8,4) NOT NULL DEFAULT 0.0000,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `traffic_source_logs`
--

CREATE TABLE `traffic_source_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `session_id` varchar(64) NOT NULL,
  `visitor_hash` varchar(64) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `traffic_source` varchar(50) NOT NULL,
  `utm_source` varchar(100) DEFAULT NULL,
  `utm_medium` varchar(100) DEFAULT NULL,
  `utm_campaign` varchar(150) DEFAULT NULL,
  `referrer_domain` varchar(150) DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `revenue` decimal(14,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `typings`
--

CREATE TABLE `typings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `conversation_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `typing` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `typings`
--

INSERT INTO `typings` (`id`, `conversation_id`, `user_id`, `typing`, `created_at`, `updated_at`) VALUES
(15, 14, 1, 0, '2026-07-06 20:47:47', '2026-07-06 20:47:51'),
(16, 15, 27, 0, '2026-07-06 21:47:42', '2026-07-06 21:47:48'),
(17, 17, 26, 0, '2026-07-07 08:47:17', '2026-07-07 08:47:25');

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

--
-- Table structure for table `ui_settings`
--

CREATE TABLE `ui_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `group` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `zip_code` varchar(255) NOT NULL,
  `address` text NOT NULL,
  `full_address` text DEFAULT NULL,
  `lat` decimal(10,7) DEFAULT NULL,
  `lng` decimal(10,7) DEFAULT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_devices`
--

CREATE TABLE `user_devices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `device_name` varchar(255) NOT NULL,
  `device_type` varchar(30) NOT NULL DEFAULT 'web',
  `push_token` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `last_active_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_engagement_scores`
--

CREATE TABLE `user_engagement_scores` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `visitor_hash` varchar(64) DEFAULT NULL,
  `score` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `grade` varchar(30) NOT NULL DEFAULT 'inactive',
  `time_spent_seconds` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `pages_visited` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `searches` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `clicks` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `purchases` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `wishlist_actions` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `period` varchar(20) NOT NULL DEFAULT '30d',
  `computed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_profile_files`
--

CREATE TABLE `user_profile_files` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(200) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `mime_type` varchar(120) DEFAULT NULL,
  `file_size` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `media_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_reports`
--

CREATE TABLE `user_reports` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reporter_id` bigint(20) UNSIGNED NOT NULL,
  `reported_user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reportable_type` varchar(255) DEFAULT NULL,
  `reportable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `reason` varchar(255) NOT NULL,
  `details` text DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_restrictions`
--

CREATE TABLE `user_restrictions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `restricted_user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_search_logs`
--

CREATE TABLE `user_search_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `session_id` varchar(64) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `keyword` varchar(255) NOT NULL,
  `normalized_keyword` varchar(255) NOT NULL,
  `results_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `has_results` tinyint(1) NOT NULL DEFAULT 1,
  `clicked_product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `led_to_purchase` tinyint(1) NOT NULL DEFAULT 0,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `category_id` bigint(20) UNSIGNED DEFAULT NULL,
  `brand_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`product_ids`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_sessions`
--

CREATE TABLE `user_sessions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `session_id` varchar(255) NOT NULL,
  `device_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `last_activity_at` timestamp NULL DEFAULT NULL,
  `revoked_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `dark_mode` tinyint(1) NOT NULL DEFAULT 1,
  `notifications_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `message_sound_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `chat_wallpaper` varchar(255) DEFAULT NULL,
  `theme_color` varchar(20) NOT NULL DEFAULT '#00a884',
  `font_size` enum('small','medium','large') NOT NULL DEFAULT 'medium',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `privacy` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`privacy`)),
  `chat` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`chat`)),
  `notifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`notifications`)),
  `storage` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`storage`)),
  `appearance` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`appearance`)),
  `status` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`status`)),
  `security` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`security`)),
  `screen` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`screen`)),
  `calls` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`calls`)),
  `screen_protection_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `inactivity_redirect_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `screen_off_redirect_enabled` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_settings`
--

INSERT INTO `user_settings` (`id`, `user_id`, `dark_mode`, `notifications_enabled`, `message_sound_enabled`, `chat_wallpaper`, `theme_color`, `font_size`, `created_at`, `updated_at`, `privacy`, `chat`, `notifications`, `storage`, `appearance`, `status`, `security`, `screen`, `calls`, `screen_protection_enabled`, `inactivity_redirect_enabled`, `screen_off_redirect_enabled`) VALUES
(18, 1, 1, 1, 1, NULL, '#00a884', 'medium', '2026-07-06 20:46:48', '2026-07-06 20:46:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0),
(19, 17, 1, 1, 1, NULL, '#00a884', 'medium', '2026-07-06 20:47:42', '2026-07-06 20:47:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, 0),
(20, 27, 1, 1, 1, NULL, '#00a884', 'medium', '2026-07-06 21:25:11', '2026-07-07 01:02:34', NULL, NULL, NULL, NULL, NULL, '{\"privacy\":\"only_share_with\",\"auto_delete_hours\":\"24\",\"privacy_user_ids\":[]}', NULL, '{\"screen_protection_enabled\":true,\"inactivity_redirect_enabled\":true,\"screen_off_redirect_enabled\":true}', NULL, 1, 1, 1),
(21, 26, 1, 1, 1, NULL, '#00a884', 'medium', '2026-07-06 21:55:22', '2026-07-07 02:07:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '{\"screen_protection_enabled\":true,\"screen_off_redirect_enabled\":false}', NULL, 1, 0, 0);

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

--
-- Table structure for table `variant_groups`
--

CREATE TABLE `variant_groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `slug` varchar(120) NOT NULL,
  `display_type` enum('swatch','button','dropdown','text') NOT NULL DEFAULT 'button',
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variant_images`
--

CREATE TABLE `variant_images` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_variant_id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `is_featured` tinyint(1) NOT NULL DEFAULT 0,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `variant_values`
--

CREATE TABLE `variant_values` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `variant_group_id` bigint(20) UNSIGNED NOT NULL,
  `value` varchar(150) NOT NULL,
  `slug` varchar(170) NOT NULL,
  `color_hex` varchar(7) DEFAULT NULL,
  `sort_order` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `shop_name` varchar(150) DEFAULT NULL,
  `state_code` varchar(5) DEFAULT NULL,
  `shiprocket_pickup_location` varchar(255) DEFAULT NULL,
  `pickup_pincode` varchar(10) DEFAULT NULL,
  `pickup_address` text DEFAULT NULL,
  `pickup_phone` varchar(20) DEFAULT NULL,
  `shop_slug` varchar(150) DEFAULT NULL,
  `logo` varchar(255) DEFAULT NULL,
  `banner` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `pan_number` varchar(50) DEFAULT NULL,
  `gst_number` varchar(50) DEFAULT NULL,
  `commission_rate` decimal(5,2) NOT NULL DEFAULT 0.00,
  `is_approved` tinyint(4) NOT NULL DEFAULT 0,
  `verification_level` tinyint(3) UNSIGNED NOT NULL DEFAULT 1,
  `seller_type` varchar(20) NOT NULL DEFAULT 'individual',
  `trust_score` smallint(5) UNSIGNED NOT NULL DEFAULT 10,
  `trust_tier` varchar(20) NOT NULL DEFAULT 'bronze',
  `rejected_at` timestamp NULL DEFAULT NULL,
  `rejection_reason` varchar(255) DEFAULT NULL,
  `kyc_status` varchar(255) NOT NULL DEFAULT 'pending',
  `kyc_document_type` varchar(255) DEFAULT NULL,
  `kyc_document_path` varchar(255) DEFAULT NULL,
  `kyc_rejection_reason` text DEFAULT NULL,
  `kyc_hold_reason` text DEFAULT NULL,
  `kyc_held_at` timestamp NULL DEFAULT NULL,
  `kyc_submitted_at` timestamp NULL DEFAULT NULL,
  `kyc_approved_at` timestamp NULL DEFAULT NULL,
  `setup_wizard_completed` tinyint(1) NOT NULL DEFAULT 0,
  `setup_wizard_step` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `bank_account_holder` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `bank_account_number` varchar(255) DEFAULT NULL,
  `bank_ifsc` varchar(20) DEFAULT NULL,
  `bank_document_path` varchar(255) DEFAULT NULL,
  `bank_media_id` bigint(20) UNSIGNED DEFAULT NULL,
  `bank_verified` tinyint(1) NOT NULL DEFAULT 0,
  `bank_verified_at` timestamp NULL DEFAULT NULL,
  `first_withdrawal_completed` tinyint(1) NOT NULL DEFAULT 0,
  `first_withdrawal_at` timestamp NULL DEFAULT NULL,
  `product_limit_notified` tinyint(1) NOT NULL DEFAULT 0,
  `fraud_flags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`fraud_flags`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_verified` tinyint(1) NOT NULL DEFAULT 0,
  `verified_at` timestamp NULL DEFAULT NULL,
  `average_rating` decimal(3,2) NOT NULL DEFAULT 0.00,
  `rating_count` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `follower_count` int(10) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendors`
--

INSERT INTO `vendors` (`id`, `user_id`, `shop_name`, `state_code`, `shiprocket_pickup_location`, `pickup_pincode`, `pickup_address`, `pickup_phone`, `shop_slug`, `logo`, `banner`, `description`, `pan_number`, `gst_number`, `commission_rate`, `is_approved`, `verification_level`, `seller_type`, `trust_score`, `trust_tier`, `rejected_at`, `rejection_reason`, `kyc_status`, `kyc_document_type`, `kyc_document_path`, `kyc_rejection_reason`, `kyc_hold_reason`, `kyc_held_at`, `kyc_submitted_at`, `kyc_approved_at`, `setup_wizard_completed`, `setup_wizard_step`, `bank_account_holder`, `bank_name`, `bank_account_number`, `bank_ifsc`, `bank_document_path`, `bank_media_id`, `bank_verified`, `bank_verified_at`, `first_withdrawal_completed`, `first_withdrawal_at`, `product_limit_notified`, `fraud_flags`, `created_at`, `updated_at`, `is_verified`, `verified_at`, `average_rating`, `rating_count`, `follower_count`) VALUES
(4, 27, 'Manu\'s Shop', NULL, NULL, NULL, NULL, NULL, 'manus-shop-2299', NULL, NULL, NULL, NULL, NULL, 0.00, 1, 1, 'individual', 10, 'bronze', NULL, NULL, 'not_submitted', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, '2026-07-06 21:07:17', '2026-07-06 21:07:35', 0, NULL, 0.00, 0, 0);

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

--
-- Table structure for table `vendor_audit_logs`
--

CREATE TABLE `vendor_audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(100) NOT NULL,
  `entity_type` varchar(50) DEFAULT NULL,
  `entity_id` bigint(20) UNSIGNED DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `severity` varchar(20) NOT NULL DEFAULT 'info',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vendor_audit_logs`
--

INSERT INTO `vendor_audit_logs` (`id`, `vendor_id`, `user_id`, `action`, `entity_type`, `entity_id`, `old_values`, `new_values`, `ip_address`, `user_agent`, `severity`, `created_at`, `updated_at`) VALUES
(4, 4, NULL, 'vendor_registered', NULL, NULL, NULL, '{\"shop_name\":\"Manu\'s Shop\"}', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'info', '2026-07-06 21:07:17', '2026-07-06 21:07:17');

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

--
-- Table structure for table `vendor_kyc_documents`
--

CREATE TABLE `vendor_kyc_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `document_type` varchar(50) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `original_filename` varchar(255) DEFAULT NULL,
  `mime_type` varchar(100) DEFAULT NULL,
  `file_size` int(10) UNSIGNED DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `rejection_reason` text DEFAULT NULL,
  `reviewed_by` bigint(20) UNSIGNED DEFAULT NULL,
  `reviewed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `media_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_ratings`
--

CREATE TABLE `vendor_ratings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `rating` tinyint(3) UNSIGNED NOT NULL,
  `review` text DEFAULT NULL,
  `is_approved` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_settlements`
--

CREATE TABLE `vendor_settlements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `settlement_uid` varchar(36) NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `gross_amount` decimal(12,2) NOT NULL,
  `platform_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(12,2) NOT NULL,
  `status` enum('pending','released','paid_out','failed') NOT NULL DEFAULT 'pending',
  `hold_until` timestamp NULL DEFAULT NULL,
  `released_at` timestamp NULL DEFAULT NULL,
  `paid_out_at` timestamp NULL DEFAULT NULL,
  `payout_provider` varchar(255) DEFAULT NULL,
  `payout_reference` varchar(255) DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_settlement_items`
--

CREATE TABLE `vendor_settlement_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_settlement_id` bigint(20) UNSIGNED NOT NULL,
  `wallet_transaction_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `vendor_sliders`
--

CREATE TABLE `vendor_sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image_path` varchar(255) NOT NULL,
  `link_url` varchar(255) DEFAULT NULL,
  `order_priority` int(11) NOT NULL DEFAULT 0,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `owner_type` varchar(255) NOT NULL DEFAULT 'user',
  `owner_id` bigint(20) UNSIGNED DEFAULT NULL,
  `wallet_type` varchar(20) NOT NULL DEFAULT 'customer',
  `balance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `pending_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_earnings` decimal(12,2) NOT NULL DEFAULT 0.00,
  `affiliate_earnings` decimal(12,2) NOT NULL DEFAULT 0.00,
  `own_earnings` decimal(12,2) NOT NULL DEFAULT 0.00,
  `platform_charges` decimal(12,2) NOT NULL DEFAULT 0.00,
  `withdrawn_total` decimal(12,2) NOT NULL DEFAULT 0.00,
  `escrow_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `reward_points` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `currency` char(3) NOT NULL DEFAULT 'INR',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `owner_type`, `owner_id`, `wallet_type`, `balance`, `pending_balance`, `total_earnings`, `affiliate_earnings`, `own_earnings`, `platform_charges`, `withdrawn_total`, `escrow_balance`, `reward_points`, `currency`, `created_at`, `updated_at`, `deleted_at`) VALUES
(7, 26, 'user', 26, 'customer', 200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 'INR', NULL, NULL, NULL),
(8, 27, 'user', NULL, 'customer', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 'INR', NULL, NULL, NULL),
(9, 28, 'user', 28, 'worker', 100.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0, 'INR', NULL, NULL, NULL);

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `transaction_uid` varchar(36) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `vendor_id` bigint(20) UNSIGNED DEFAULT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `type` enum('credit','debit') NOT NULL,
  `remark` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `reference_type` varchar(255) DEFAULT NULL,
  `reference_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'completed',
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `idempotency_key` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_item_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_id` bigint(20) UNSIGNED DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `listing_type` enum('own','affiliate') DEFAULT NULL,
  `order_amount` decimal(12,2) DEFAULT NULL,
  `commission_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `platform_charge` decimal(12,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(12,2) DEFAULT NULL,
  `available_at` timestamp NULL DEFAULT NULL,
  `source` varchar(50) NOT NULL DEFAULT 'manual'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `transaction_uid`, `user_id`, `vendor_id`, `wallet_id`, `amount`, `type`, `remark`, `description`, `reference_type`, `reference_id`, `status`, `metadata`, `idempotency_key`, `created_at`, `updated_at`, `order_id`, `order_item_id`, `product_id`, `product_name`, `listing_type`, `order_amount`, `commission_amount`, `platform_charge`, `net_amount`, `available_at`, `source`) VALUES
(6, NULL, 26, NULL, 7, 100.00, 'credit', 'Welcome bonus for new registration', 'Welcome bonus for new registration', 'signup_bonus', 26, 'completed', NULL, 'signup_bonus_user_26', '2026-07-06 21:00:04', '2026-07-06 21:00:04', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, 'manual'),
(7, NULL, 28, NULL, 9, 100.00, 'credit', 'Welcome bonus for new registration', 'Welcome bonus for new registration', 'signup_bonus', 28, 'completed', NULL, 'signup_bonus_user_28', '2026-07-07 02:53:16', '2026-07-07 02:53:16', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, 'manual'),
(8, NULL, 26, NULL, 7, 100.00, 'credit', 'Referral bonus for inviting bitlife store', 'Referral bonus for inviting bitlife store', 'referral_bonus', 2, 'completed', NULL, 'referral_bonus_2', '2026-07-07 02:53:16', '2026-07-07 02:53:16', NULL, NULL, NULL, NULL, NULL, NULL, 0.00, 0.00, NULL, NULL, 'manual');

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `net_amount` decimal(12,2) NOT NULL,
  `method` varchar(20) NOT NULL DEFAULT 'bank',
  `account_details` text NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'pending',
  `admin_note` text DEFAULT NULL,
  `processed_by` bigint(20) UNSIGNED DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `workers`
--

CREATE TABLE `workers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED DEFAULT NULL,
  `display_name` varchar(255) NOT NULL,
  `bio` text DEFAULT NULL,
  `experience_years` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
  `hourly_rate` decimal(10,2) NOT NULL DEFAULT 0.00,
  `is_online` tinyint(1) NOT NULL DEFAULT 0,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `verification_status` varchar(20) NOT NULL DEFAULT 'pending',
  `verified_badge` tinyint(1) NOT NULL DEFAULT 0,
  `police_verified` tinyint(1) NOT NULL DEFAULT 0,
  `premium_verified` tinyint(1) NOT NULL DEFAULT 0,
  `avg_rating` decimal(3,2) NOT NULL DEFAULT 0.00,
  `total_jobs` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `service_radius_km` decimal(5,2) NOT NULL DEFAULT 10.00,
  `current_lat` decimal(10,7) DEFAULT NULL,
  `current_lng` decimal(10,7) DEFAULT NULL,
  `last_location_at` timestamp NULL DEFAULT NULL,
  `subscription_plan` varchar(20) NOT NULL DEFAULT 'free',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `workers`
--

INSERT INTO `workers` (`id`, `user_id`, `company_id`, `display_name`, `bio`, `experience_years`, `hourly_rate`, `is_online`, `is_available`, `verification_status`, `verified_badge`, `police_verified`, `premium_verified`, `avg_rating`, `total_jobs`, `service_radius_km`, `current_lat`, `current_lng`, `last_location_at`, `subscription_plan`, `status`, `created_at`, `updated_at`, `deleted_at`) VALUES
(2, 28, NULL, 'bitlife store', NULL, 0, 299.00, 0, 1, 'pending', 0, 0, 0, 0.00, 0, 10.00, NULL, NULL, NULL, 'free', 1, '2026-07-07 04:18:14', '2026-07-07 04:18:14', NULL),
(3, 26, NULL, 'gletra site', NULL, 0, 299.00, 0, 1, 'pending', 0, 0, 0, 0.00, 0, 10.00, NULL, NULL, NULL, 'free', 0, '2026-07-07 06:52:50', '2026-07-07 06:52:50', NULL);

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

--
-- Table structure for table `worker_availability`
--

CREATE TABLE `worker_availability` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `worker_id` bigint(20) UNSIGNED NOT NULL,
  `day_of_week` tinyint(3) UNSIGNED NOT NULL,
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `worker_locations`
--

CREATE TABLE `worker_locations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `worker_id` bigint(20) UNSIGNED NOT NULL,
  `lat` decimal(10,7) NOT NULL,
  `lng` decimal(10,7) NOT NULL,
  `accuracy` decimal(8,2) DEFAULT NULL,
  `heading` decimal(6,2) DEFAULT NULL,
  `speed` decimal(8,2) DEFAULT NULL,
  `recorded_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `worker_service`
--

CREATE TABLE `worker_service` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `worker_id` bigint(20) UNSIGNED NOT NULL,
  `service_id` bigint(20) UNSIGNED NOT NULL,
  `custom_price` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_deletion_requests`
--
ALTER TABLE `account_deletion_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_deletion_requests_user_id_foreign` (`user_id`),
  ADD KEY `account_deletion_requests_handled_by_foreign` (`handled_by`),
  ADD KEY `account_deletion_requests_status_requested_at_index` (`status`,`requested_at`);

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

--
-- Indexes for table `addresses`
--
ALTER TABLE `addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `addresses_city_id_foreign` (`city_id`),
  ADD KEY `addresses_state_id_foreign` (`state_id`),
  ADD KEY `addresses_country_id_foreign` (`country_id`),
  ADD KEY `addresses_user_id_is_default_index` (`user_id`,`is_default`);

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

--
-- Indexes for table `affiliates`
--
ALTER TABLE `affiliates`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `affiliates_code_unique` (`code`),
  ADD KEY `affiliates_user_id_foreign` (`user_id`);

--
-- Indexes for table `affiliate_commissions`
--
ALTER TABLE `affiliate_commissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `affiliate_commissions_affiliate_id_foreign` (`affiliate_id`),
  ADD KEY `affiliate_commissions_order_id_foreign` (`order_id`);

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

--
-- Indexes for table `analytics_events`
--
ALTER TABLE `analytics_events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_events_event_type_index` (`event_type`),
  ADD KEY `analytics_events_product_id_index` (`product_id`),
  ADD KEY `analytics_events_vendor_id_index` (`vendor_id`),
  ADD KEY `analytics_events_user_id_index` (`user_id`),
  ADD KEY `analytics_events_category_id_index` (`category_id`),
  ADD KEY `analytics_events_brand_id_index` (`brand_id`),
  ADD KEY `analytics_events_order_id_index` (`order_id`),
  ADD KEY `analytics_events_session_id_index` (`session_id`),
  ADD KEY `analytics_events_visitor_hash_index` (`visitor_hash`),
  ADD KEY `analytics_events_keyword_index` (`keyword`),
  ADD KEY `analytics_events_created_at_index` (`created_at`);

--
-- Indexes for table `analytics_reports`
--
ALTER TABLE `analytics_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `analytics_reports_report_type_index` (`report_type`);

--
-- Indexes for table `analytics_visitor_sessions`
--
ALTER TABLE `analytics_visitor_sessions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `analytics_visitor_sessions_session_id_unique` (`session_id`),
  ADD KEY `analytics_visitor_sessions_visitor_hash_index` (`visitor_hash`),
  ADD KEY `analytics_visitor_sessions_user_id_index` (`user_id`);

--
-- Indexes for table `app_notifications`
--
ALTER TABLE `app_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `app_notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`),
  ADD KEY `app_notifications_notifiable_type_notifiable_id_read_at_index` (`notifiable_type`,`notifiable_id`,`read_at`);

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `attendance_worker_id_date_unique` (`worker_id`,`date`);

--
-- Indexes for table `attribute_definitions`
--
ALTER TABLE `attribute_definitions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `attribute_definitions_slug_unique` (`slug`);

--
-- Indexes for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `audit_logs_user_id_foreign` (`user_id`),
  ADD KEY `audit_logs_action_created_at_index` (`action`,`created_at`);

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

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

--
-- Indexes for table `blocked_users`
--
ALTER TABLE `blocked_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `blocked_users_user_id_blocked_user_id_unique` (`user_id`,`blocked_user_id`),
  ADD KEY `blocked_users_blocked_user_id_foreign` (`blocked_user_id`);

--
-- Indexes for table `bookings`
--
ALTER TABLE `bookings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bookings_uuid_unique` (`uuid`),
  ADD KEY `bookings_company_id_foreign` (`company_id`),
  ADD KEY `bookings_service_id_foreign` (`service_id`),
  ADD KEY `bookings_address_id_foreign` (`address_id`),
  ADD KEY `bookings_coupon_id_foreign` (`coupon_id`),
  ADD KEY `bookings_cancelled_by_foreign` (`cancelled_by`),
  ADD KEY `bookings_customer_id_status_index` (`customer_id`,`status`),
  ADD KEY `bookings_worker_id_status_index` (`worker_id`,`status`),
  ADD KEY `bookings_status_is_emergency_index` (`status`,`is_emergency`),
  ADD KEY `bookings_scheduled_at_index` (`scheduled_at`);

--
-- Indexes for table `booking_attachments`
--
ALTER TABLE `booking_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `booking_attachments_booking_id_type_index` (`booking_id`,`type`);

--
-- Indexes for table `booking_statuses`
--
ALTER TABLE `booking_statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `booking_statuses_changed_by_foreign` (`changed_by`),
  ADD KEY `booking_statuses_booking_id_created_at_index` (`booking_id`,`created_at`);

--
-- Indexes for table `booking_worker_alerts`
--
ALTER TABLE `booking_worker_alerts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `booking_worker_alerts_booking_id_worker_id_unique` (`booking_id`,`worker_id`),
  ADD KEY `booking_worker_alerts_worker_id_foreign` (`worker_id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brands_slug_unique` (`slug`);

--
-- Indexes for table `brand_analytics_daily`
--
ALTER TABLE `brand_analytics_daily`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `brand_analytics_daily_brand_id_date_unique` (`brand_id`,`date`),
  ADD KEY `brand_analytics_daily_brand_id_index` (`brand_id`),
  ADD KEY `brand_analytics_daily_date_index` (`date`);

--
-- Indexes for table `browser_analytics_daily`
--
ALTER TABLE `browser_analytics_daily`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `browser_analytics_daily_date_browser_unique` (`date`,`browser`),
  ADD KEY `browser_analytics_daily_date_index` (`date`);

--
-- Indexes for table `calls`
--
ALTER TABLE `calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `calls_initiator_id_foreign` (`initiator_id`),
  ADD KEY `calls_callable_type_callable_id_index` (`callable_type`,`callable_id`),
  ADD KEY `calls_status_created_at_index` (`status`,`created_at`);

--
-- Indexes for table `call_favorites`
--
ALTER TABLE `call_favorites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `call_favorites_user_id_favorite_user_id_unique` (`user_id`,`favorite_user_id`),
  ADD KEY `call_favorites_favorite_user_id_foreign` (`favorite_user_id`);

--
-- Indexes for table `call_logs`
--
ALTER TABLE `call_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `call_logs_user_id_foreign` (`user_id`),
  ADD KEY `call_logs_call_id_created_at_index` (`call_id`,`created_at`);

--
-- Indexes for table `call_notifications`
--
ALTER TABLE `call_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `call_notifications_sender_id_foreign` (`sender_id`),
  ADD KEY `call_notifications_receiver_id_is_read_created_at_index` (`receiver_id`,`is_read`,`created_at`),
  ADD KEY `call_notifications_call_id_foreign` (`call_id`);

--
-- Indexes for table `call_participants`
--
ALTER TABLE `call_participants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `call_participants_call_id_user_id_unique` (`call_id`,`user_id`),
  ADD KEY `call_participants_user_id_foreign` (`user_id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `carts_user_id_foreign` (`user_id`),
  ADD KEY `carts_product_id_foreign` (`product_id`),
  ADD KEY `carts_variant_id_foreign` (`variant_id`),
  ADD KEY `carts_session_id_index` (`session_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_parent_slug_unique` (`parent_id`,`slug`),
  ADD KEY `categories_parent_id_foreign` (`parent_id`),
  ADD KEY `categories_domain_status_index` (`domain`,`status`),
  ADD KEY `categories_created_by_foreign` (`created_by`),
  ADD KEY `categories_updated_by_foreign` (`updated_by`),
  ADD KEY `categories_status_level_index` (`status`,`level`),
  ADD KEY `categories_display_order_index` (`display_order`);

--
-- Indexes for table `category_analytics_daily`
--
ALTER TABLE `category_analytics_daily`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_analytics_daily_category_id_date_unique` (`category_id`,`date`),
  ADD KEY `category_analytics_daily_category_id_index` (`category_id`),
  ADD KEY `category_analytics_daily_date_index` (`date`);

--
-- Indexes for table `category_attributes`
--
ALTER TABLE `category_attributes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_attr_unique` (`category_id`,`attribute_definition_id`),
  ADD KEY `category_attributes_attribute_definition_id_foreign` (`attribute_definition_id`);

--
-- Indexes for table `category_filter`
--
ALTER TABLE `category_filter`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `category_filter_unique` (`category_id`,`filter_definition_id`),
  ADD KEY `category_filter_filter_definition_id_foreign` (`filter_definition_id`);

--
-- Indexes for table `channels`
--
ALTER TABLE `channels`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `channels_slug_unique` (`slug`),
  ADD KEY `channels_owner_id_foreign` (`owner_id`);

--
-- Indexes for table `channel_comments`
--
ALTER TABLE `channel_comments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `channel_comments_channel_post_id_foreign` (`channel_post_id`),
  ADD KEY `channel_comments_user_id_foreign` (`user_id`);

--
-- Indexes for table `channel_followers`
--
ALTER TABLE `channel_followers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `channel_followers_channel_id_user_id_unique` (`channel_id`,`user_id`),
  ADD KEY `channel_followers_user_id_foreign` (`user_id`);

--
-- Indexes for table `channel_posts`
--
ALTER TABLE `channel_posts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `channel_posts_author_id_foreign` (`author_id`),
  ADD KEY `channel_posts_channel_id_created_at_index` (`channel_id`,`created_at`);

--
-- Indexes for table `channel_reactions`
--
ALTER TABLE `channel_reactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `channel_reactions_channel_post_id_user_id_unique` (`channel_post_id`,`user_id`),
  ADD KEY `channel_reactions_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `chat_audit_logs`
--
ALTER TABLE `chat_audit_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_audit_logs_admin_id_foreign` (`admin_id`);

--
-- Indexes for table `chat_conversations`
--
ALTER TABLE `chat_conversations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `chat_conversations_user_one_id_user_two_id_unique` (`user_one_id`,`user_two_id`),
  ADD KEY `chat_conversations_user_two_id_foreign` (`user_two_id`);

--
-- Indexes for table `chat_messages`
--
ALTER TABLE `chat_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_messages_conversation_id_foreign` (`conversation_id`),
  ADD KEY `chat_messages_sender_id_foreign` (`sender_id`);

--
-- Indexes for table `chat_password_requests`
--
ALTER TABLE `chat_password_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `chat_password_requests_user_id_foreign` (`user_id`),
  ADD KEY `chat_password_requests_handled_by_admin_foreign` (`handled_by_admin`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_country_id_foreign` (`country_id`),
  ADD KEY `cities_state_id_status_index` (`state_id`,`status`);

--
-- Indexes for table `communities`
--
ALTER TABLE `communities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `communities_owner_id_foreign` (`owner_id`);

--
-- Indexes for table `community_groups`
--
ALTER TABLE `community_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `community_groups_community_id_group_id_unique` (`community_id`,`group_id`),
  ADD KEY `community_groups_group_id_foreign` (`group_id`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `companies_slug_unique` (`slug`),
  ADD KEY `companies_owner_id_foreign` (`owner_id`),
  ADD KEY `companies_verification_status_status_index` (`verification_status`,`status`);

--
-- Indexes for table `company_staff`
--
ALTER TABLE `company_staff`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `company_staff_company_id_user_id_unique` (`company_id`,`user_id`),
  ADD KEY `company_staff_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `countries_iso2_unique` (`iso2`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`),
  ADD KEY `coupons_vendor_id_foreign` (`vendor_id`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `currencies_code_unique` (`code`);

--
-- Indexes for table `delivery_assignments`
--
ALTER TABLE `delivery_assignments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `delivery_assignments_order_id_unique` (`order_id`),
  ADD KEY `delivery_assignments_delivery_partner_id_foreign` (`delivery_partner_id`);

--
-- Indexes for table `device_analytics_daily`
--
ALTER TABLE `device_analytics_daily`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `device_analytics_daily_date_device_type_unique` (`date`,`device_type`),
  ADD KEY `device_analytics_daily_date_index` (`date`);

--
-- Indexes for table `disputes`
--
ALTER TABLE `disputes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `disputes_booking_id_unique` (`booking_id`),
  ADD KEY `disputes_raised_by_foreign` (`raised_by`),
  ADD KEY `disputes_resolved_by_foreign` (`resolved_by`),
  ADD KEY `disputes_status_index` (`status`);

--
-- Indexes for table `escrow_holds`
--
ALTER TABLE `escrow_holds`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `escrow_holds_booking_id_unique` (`booking_id`),
  ADD KEY `escrow_holds_customer_wallet_id_foreign` (`customer_wallet_id`),
  ADD KEY `escrow_holds_status_index` (`status`);

--
-- Indexes for table `favorites`
--
ALTER TABLE `favorites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `favorites_user_id_worker_id_unique` (`user_id`,`worker_id`),
  ADD KEY `favorites_worker_id_foreign` (`worker_id`);

--
-- Indexes for table `filter_definitions`
--
ALTER TABLE `filter_definitions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `filter_definitions_slug_unique` (`slug`);

--
-- Indexes for table `followers`
--
ALTER TABLE `followers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `followers_follower_id_following_id_unique` (`follower_id`,`following_id`),
  ADD KEY `followers_following_id_status_index` (`following_id`,`status`),
  ADD KEY `followers_follower_id_status_index` (`follower_id`,`status`),
  ADD KEY `followers_accepted_at_index` (`accepted_at`);

--
-- Indexes for table `fraud_alerts`
--
ALTER TABLE `fraud_alerts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fraud_alerts_user_id_foreign` (`user_id`),
  ADD KEY `fraud_alerts_order_id_foreign` (`order_id`);

--
-- Indexes for table `funnel_dropoff_daily`
--
ALTER TABLE `funnel_dropoff_daily`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `funnel_dropoff_daily_date_dropoff_type_unique` (`date`,`dropoff_type`),
  ADD KEY `funnel_dropoff_daily_date_index` (`date`);

--
-- Indexes for table `gc_blocked_users`
--
ALTER TABLE `gc_blocked_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_blocked_users_blocker_id_blocked_id_unique` (`blocker_id`,`blocked_id`),
  ADD KEY `gc_blocked_users_blocked_id_foreign` (`blocked_id`);

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

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

--
-- Indexes for table `gc_chat_participants`
--
ALTER TABLE `gc_chat_participants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_chat_participants_chat_id_user_id_unique` (`chat_id`,`user_id`);

--
-- Indexes for table `gc_chat_reports`
--
ALTER TABLE `gc_chat_reports`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gc_chat_reports_reporter_id_foreign` (`reporter_id`),
  ADD KEY `gc_chat_reports_reported_user_id_foreign` (`reported_user_id`),
  ADD KEY `gc_chat_reports_message_id_foreign` (`message_id`);

--
-- Indexes for table `gc_chat_user_settings`
--
ALTER TABLE `gc_chat_user_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_chat_user_settings_user_id_chat_id_unique` (`user_id`,`chat_id`),
  ADD KEY `gc_chat_user_settings_chat_id_foreign` (`chat_id`);

--
-- Indexes for table `gc_group_calls`
--
ALTER TABLE `gc_group_calls`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gc_group_calls_chat_id_foreign` (`chat_id`);

--
-- Indexes for table `gc_group_call_participants`
--
ALTER TABLE `gc_group_call_participants`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_group_call_participants_group_call_id_user_id_unique` (`group_call_id`,`user_id`);

--
-- Indexes for table `gc_media_cache`
--
ALTER TABLE `gc_media_cache`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_media_cache_url_hash_unique` (`url_hash`);

--
-- Indexes for table `gc_messages`
--
ALTER TABLE `gc_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gc_messages_delivered_at_index` (`delivered_at`),
  ADD KEY `gc_messages_seen_at_index` (`seen_at`),
  ADD KEY `gc_messages_scheduled_at_index` (`scheduled_at`),
  ADD KEY `gc_messages_disappears_at_index` (`disappears_at`),
  ADD KEY `gc_messages_chat_id_created_at_index` (`chat_id`,`created_at`);

--
-- Indexes for table `gc_message_hides`
--
ALTER TABLE `gc_message_hides`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_message_hides_user_id_message_id_unique` (`user_id`,`message_id`),
  ADD KEY `gc_message_hides_message_id_foreign` (`message_id`);

--
-- Indexes for table `gc_message_mentions`
--
ALTER TABLE `gc_message_mentions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_message_mentions_message_id_user_id_unique` (`message_id`,`user_id`);

--
-- Indexes for table `gc_message_reactions`
--
ALTER TABLE `gc_message_reactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_message_reactions_message_id_user_id_unique` (`message_id`,`user_id`),
  ADD KEY `gc_message_reactions_user_id_foreign` (`user_id`);

--
-- Indexes for table `gc_polls`
--
ALTER TABLE `gc_polls`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `gc_polls_message_id_unique` (`message_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `group_messages`
--
ALTER TABLE `group_messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `group_messages_media_id_foreign` (`media_id`);

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

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

--
-- Indexes for table `kyc_documents`
--
ALTER TABLE `kyc_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kyc_documents_media_id_foreign` (`media_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `media_files`
--
ALTER TABLE `media_files`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_files_uuid_unique` (`uuid`),
  ADD KEY `media_files_owner_type_owner_id_index` (`owner_type`,`owner_id`),
  ADD KEY `media_files_context_collection_index` (`context`,`collection`),
  ADD KEY `media_files_uploaded_by_index` (`uploaded_by`),
  ADD KEY `media_files_owner_collection_index` (`owner_type`,`owner_id`,`collection`);

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

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `messages_media_id_foreign` (`media_id`),
  ADD KEY `messages_thumbnail_media_id_foreign` (`thumbnail_media_id`);

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

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

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

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

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

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

--
-- Indexes for table `order_return_requests`
--
ALTER TABLE `order_return_requests`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_return_requests_replacement_order_id_foreign` (`replacement_order_id`);

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

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

--
-- Indexes for table `package_scan_logs`
--
ALTER TABLE `package_scan_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_scan_logs_scanned_by_foreign` (`scanned_by`),
  ADD KEY `package_scan_logs_order_id_action_index` (`order_id`,`action`),
  ADD KEY `package_scan_logs_scan_value_index` (`scan_value`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `product_types`
--
ALTER TABLE `product_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `product_types_category_id_slug_unique` (`category_id`,`slug`),
  ADD KEY `product_types_category_id_status_display_order_index` (`category_id`,`status`,`display_order`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `statuses`
--
ALTER TABLE `statuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `statuses_user_id_expires_at_index` (`user_id`,`expires_at`),
  ADD KEY `statuses_media_id_foreign` (`media_id`);

--
-- Indexes for table `status_archives`
--
ALTER TABLE `status_archives`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `status_archives_user_id_archived_user_id_unique` (`user_id`,`archived_user_id`),
  ADD KEY `status_archives_archived_user_id_foreign` (`archived_user_id`);

--
-- Indexes for table `status_mutes`
--
ALTER TABLE `status_mutes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `status_mutes_user_id_muted_user_id_unique` (`user_id`,`muted_user_id`),
  ADD KEY `status_mutes_muted_user_id_foreign` (`muted_user_id`);

--
-- Indexes for table `status_privacy_users`
--
ALTER TABLE `status_privacy_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `status_privacy_users_status_id_user_id_unique` (`status_id`,`user_id`),
  ADD KEY `status_privacy_users_user_id_foreign` (`user_id`);

--
-- Indexes for table `status_reactions`
--
ALTER TABLE `status_reactions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `status_reactions_status_id_user_id_unique` (`status_id`,`user_id`),
  ADD KEY `status_reactions_user_id_foreign` (`user_id`);

--
-- Indexes for table `status_replies`
--
ALTER TABLE `status_replies`
  ADD PRIMARY KEY (`id`),
  ADD KEY `status_replies_sender_id_foreign` (`sender_id`),
  ADD KEY `status_replies_sticker_id_foreign` (`sticker_id`),
  ADD KEY `status_replies_message_id_foreign` (`message_id`),
  ADD KEY `status_replies_status_id_created_at_index` (`status_id`,`created_at`);

--
-- Indexes for table `status_views`
--
ALTER TABLE `status_views`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `status_views_status_id_viewer_id_unique` (`status_id`,`viewer_id`),
  ADD KEY `status_views_viewer_id_foreign` (`viewer_id`);

--
-- Indexes for table `stickers`
--
ALTER TABLE `stickers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stickers_media_id_foreign` (`media_id`);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `user_profile_files`
--
ALTER TABLE `user_profile_files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_profile_files_user_id_created_at_index` (`user_id`,`created_at`),
  ADD KEY `user_profile_files_media_id_foreign` (`media_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vendors_bank_media_id_foreign` (`bank_media_id`);

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

--
-- Indexes for table `vendor_kyc_documents`
--
ALTER TABLE `vendor_kyc_documents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vendor_kyc_documents_media_id_foreign` (`media_id`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `categories_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `category_attributes`
--
ALTER TABLE `category_attributes`
  ADD CONSTRAINT `category_attributes_attribute_definition_id_foreign` FOREIGN KEY (`attribute_definition_id`) REFERENCES `attribute_definitions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_attributes_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `category_filter`
--
ALTER TABLE `category_filter`
  ADD CONSTRAINT `category_filter_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_filter_filter_definition_id_foreign` FOREIGN KEY (`filter_definition_id`) REFERENCES `filter_definitions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `group_messages`
--
ALTER TABLE `group_messages`
  ADD CONSTRAINT `group_messages_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `kyc_documents`
--
ALTER TABLE `kyc_documents`
  ADD CONSTRAINT `kyc_documents_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `media_files`
--
ALTER TABLE `media_files`
  ADD CONSTRAINT `media_files_uploaded_by_foreign` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `messages_thumbnail_media_id_foreign` FOREIGN KEY (`thumbnail_media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `order_return_requests`
--
ALTER TABLE `order_return_requests`
  ADD CONSTRAINT `order_return_requests_replacement_order_id_foreign` FOREIGN KEY (`replacement_order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `package_scan_logs`
--
ALTER TABLE `package_scan_logs`
  ADD CONSTRAINT `package_scan_logs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `package_scan_logs_scanned_by_foreign` FOREIGN KEY (`scanned_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_product_type_id_foreign` FOREIGN KEY (`product_type_id`) REFERENCES `product_types` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `product_types`
--
ALTER TABLE `product_types`
  ADD CONSTRAINT `product_types_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `statuses`
--
ALTER TABLE `statuses`
  ADD CONSTRAINT `statuses_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `statuses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `status_archives`
--
ALTER TABLE `status_archives`
  ADD CONSTRAINT `status_archives_archived_user_id_foreign` FOREIGN KEY (`archived_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_archives_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `status_mutes`
--
ALTER TABLE `status_mutes`
  ADD CONSTRAINT `status_mutes_muted_user_id_foreign` FOREIGN KEY (`muted_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_mutes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `status_privacy_users`
--
ALTER TABLE `status_privacy_users`
  ADD CONSTRAINT `status_privacy_users_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_privacy_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `status_reactions`
--
ALTER TABLE `status_reactions`
  ADD CONSTRAINT `status_reactions_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_reactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `status_replies`
--
ALTER TABLE `status_replies`
  ADD CONSTRAINT `status_replies_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `status_replies_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_replies_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_replies_sticker_id_foreign` FOREIGN KEY (`sticker_id`) REFERENCES `stickers` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `status_views`
--
ALTER TABLE `status_views`
  ADD CONSTRAINT `status_views_status_id_foreign` FOREIGN KEY (`status_id`) REFERENCES `statuses` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `status_views_viewer_id_foreign` FOREIGN KEY (`viewer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `stickers`
--
ALTER TABLE `stickers`
  ADD CONSTRAINT `stickers_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `user_profile_files`
--
ALTER TABLE `user_profile_files`
  ADD CONSTRAINT `user_profile_files_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `user_profile_files_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `vendors`
--
ALTER TABLE `vendors`
  ADD CONSTRAINT `vendors_bank_media_id_foreign` FOREIGN KEY (`bank_media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `vendor_kyc_documents`
--
ALTER TABLE `vendor_kyc_documents`
  ADD CONSTRAINT `vendor_kyc_documents_media_id_foreign` FOREIGN KEY (`media_id`) REFERENCES `media_files` (`id`) ON DELETE SET NULL;
COMMIT;

