(5372,4,NULL,'PostEx','MURREE',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5373,4,NULL,'PostEx','MUZAFFARABAD',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5374,4,NULL,'PostEx','MUZAFFARABAD (AJK)',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5375,4,NULL,'PostEx','MUZAFFARGARH',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5376,4,NULL,'PostEx','NAKKA KAHUT',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5377,4,NULL,'PostEx','NANKANA SAHIB',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5378,4,NULL,'PostEx','NARA',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5379,4,NULL,'PostEx','NARANG MANDI',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5380,4,NULL,'PostEx','NARAR',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5381,4,NULL,'PostEx','NAROWAL',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5382,4,NULL,'PostEx','NASARPUR',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5383,4,NULL,'PostEx','NASIRABAD',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5384,4,NULL,'PostEx','NATHIA GALI',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5385,4,NULL,'PostEx','NAUSHAHRO FEROZE',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5386,4,NULL,'PostEx','NAWABSHAH',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5387,4,NULL,'PostEx','NAWAN SHEHR',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5388,4,NULL,'PostEx','NAWAY KALI',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5389,4,NULL,'PostEx','NAYA LAHORE',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5390,4,NULL,'PostEx','NEW INDUSTRIAL AREA',NULL,'Pakistan','2025-08-15 19:31:52','2025-08-15 19:31:52'),(5391,4,NULL,'PostEx','NEW MURREE',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5392,4,NULL,'PostEx','NEW TOWN KARACHI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5393,4,NULL,'PostEx','NIZAMABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5394,4,NULL,'PostEx','NOKHAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5395,4,NULL,'PostEx','NOMAN PORA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5396,4,NULL,'PostEx','NONAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5397,4,NULL,'PostEx','NOOR COLONY',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5398,4,NULL,'PostEx','NOOR JAMAAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5399,4,NULL,'PostEx','NOOR KOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5400,4,NULL,'PostEx','NOORPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5401,4,NULL,'PostEx','NOORPUR THAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5402,4,NULL,'PostEx','NORIABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5403,4,NULL,'PostEx','NOWSHERA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5404,4,NULL,'PostEx','NOWSHERA KALAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5405,4,NULL,'PostEx','NOWSHERA VIRKAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5406,4,NULL,'PostEx','NRTC (TELECOM STAFF COLLEGE)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5407,4,NULL,'PostEx','NUDEARO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5408,4,NULL,'PostEx','OKARA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5409,4,NULL,'PostEx','OLD HALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5410,4,NULL,'PostEx','OLDING',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5411,4,NULL,'PostEx','P.O.F. (FACTORY & COLONY)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5412,4,NULL,'PostEx','PABBI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5413,4,NULL,'PostEx','PABI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5414,4,NULL,'PostEx','PACHNAND',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5415,4,NULL,'PostEx','PAHARPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5416,4,NULL,'PostEx','PAK PATTAN SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5417,4,NULL,'PostEx','PAKKA LARAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5418,4,NULL,'PostEx','PAKPATTAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5419,4,NULL,'PostEx','PALANDRI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5420,4,NULL,'PostEx','PANJAN SHER SHAHANA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5421,4,NULL,'PostEx','PANO AKIL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5422,4,NULL,'PostEx','PANOAQIL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5423,4,NULL,'PostEx','PAROA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5424,4,NULL,'PostEx','PASNI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5425,4,NULL,'PostEx','PASROOR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5426,4,NULL,'PostEx','PASROOR ROAD AND VILLAGES',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5427,4,NULL,'PostEx','PASRUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5428,4,NULL,'PostEx','PATHIKA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5429,4,NULL,'PostEx','PATOKI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5430,4,NULL,'PostEx','PATRIATA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5431,4,NULL,'PostEx','PATTOKI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5432,4,NULL,'PostEx','PEER MAHAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5433,4,NULL,'PostEx','PESHAWAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5434,4,NULL,'PostEx','PEZU',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5435,4,NULL,'PostEx','PHAGWARI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5436,4,NULL,'PostEx','PHALIA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5437,4,NULL,'PostEx','PHOOL NAGAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5438,4,NULL,'PostEx','PINANWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5439,4,NULL,'PostEx','PIND DADAN KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5440,4,NULL,'PostEx','PINDI BHATIAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5441,4,NULL,'PostEx','PINDI GHEB',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5442,4,NULL,'PostEx','PINDI GUJRAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5443,4,NULL,'PostEx','PINDI POINT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5444,4,NULL,'PostEx','PINDI SAID PUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5445,4,NULL,'PostEx','PIPLAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5446,4,NULL,'PostEx','PIR BABA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5447,4,NULL,'PostEx','PIR JO GOTH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5448,4,NULL,'PostEx','PIR WASAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5449,4,NULL,'PostEx','PIRA FATEHAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5450,4,NULL,'PostEx','PIRYALOI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5451,4,NULL,'PostEx','PISHIN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5452,4,NULL,'PostEx','PITARO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5453,4,NULL,'PostEx','PMA KAKUL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5454,4,NULL,'PostEx','POONCH (AJK)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5455,4,NULL,'PostEx','PORANWALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5456,4,NULL,'PostEx','PUNGIRAYIN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5457,4,NULL,'PostEx','PUNJAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5458,4,NULL,'PostEx','PUNWAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5459,4,NULL,'PostEx','QABAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5460,4,NULL,'PostEx','QABOOLA SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5461,4,NULL,'PostEx','QADIR PUR RAWAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5462,4,NULL,'PostEx','QAIDABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5463,4,NULL,'PostEx','QAIM BHARWANA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5464,4,NULL,'PostEx','QAIMPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5465,4,NULL,'PostEx','QALAT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5466,4,NULL,'PostEx','QAMAR ABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5467,4,NULL,'PostEx','QAMAR MASHANI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5468,4,NULL,'PostEx','QAMBAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5469,4,NULL,'PostEx','QASBA GUJRAT.',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5470,4,NULL,'PostEx','QAZI AHMED',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5471,4,NULL,'PostEx','QILA AHMED ABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5472,4,NULL,'PostEx','QILA DEEDAR SING',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5473,4,NULL,'PostEx','QILA KALAR WALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5474,4,NULL,'PostEx','QILA SAIB SINGH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5475,4,NULL,'PostEx','QILA SHEIKHUPURA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5476,4,NULL,'PostEx','QUETTA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5477,4,NULL,'PostEx','RABAT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5478,4,NULL,'PostEx','RACHNA TOWN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5479,4,NULL,'PostEx','RADHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5480,4,NULL,'PostEx','RAHIM YAR KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5481,4,NULL,'PostEx','RAHIMYAR KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5482,4,NULL,'PostEx','RAIWIND',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5483,4,NULL,'PostEx','RAJA JANG',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5484,4,NULL,'PostEx','RAJANA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5485,4,NULL,'PostEx','RAJANPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5486,4,NULL,'PostEx','RAJAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5487,4,NULL,'PostEx','RAKH BALOCH KALAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5488,4,NULL,'PostEx','RAMAK',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5489,4,NULL,'PostEx','RANI PUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5490,4,NULL,'PostEx','RAO KHAN WALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5491,4,NULL,'PostEx','RASHAKI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5492,4,NULL,'PostEx','RASOOL NAGAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5493,4,NULL,'PostEx','RATO DEARO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5494,4,NULL,'PostEx','RATODERO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5495,4,NULL,'PostEx','RAWALAKOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5496,4,NULL,'PostEx','RAWALAKOT (AJK)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5497,4,NULL,'PostEx','Rawalpindi',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5498,4,NULL,'PostEx','RAWAT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5499,4,NULL,'PostEx','RENALA KHURD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5500,4,NULL,'PostEx','RISALPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5501,4,NULL,'PostEx','ROHRI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5502,4,NULL,'PostEx','ROUNDU',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5503,4,NULL,'PostEx','RUBWA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5504,4,NULL,'PostEx','SABAZ PEER',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5505,4,NULL,'PostEx','SADIQABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5506,4,NULL,'PostEx','SADPARA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5507,4,NULL,'PostEx','SAFDARABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5508,4,NULL,'PostEx','SAGHAR PUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5509,4,NULL,'PostEx','SAHARAN CHATTHA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5510,4,NULL,'PostEx','SAHIWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5511,4,NULL,'PostEx','SAID NAGAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5512,4,NULL,'PostEx','SAIDU SHAIRF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5513,4,NULL,'PostEx','SAIDU SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5514,4,NULL,'PostEx','SAJAWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5515,4,NULL,'PostEx','SAKRAND',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5516,4,NULL,'PostEx','SALLHOKE CHATTHA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5517,4,NULL,'PostEx','SAMANDARI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5518,4,NULL,'PostEx','SAMAR BAGH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5519,4,NULL,'PostEx','SAMARO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5520,4,NULL,'PostEx','SAMBRIAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5521,4,NULL,'PostEx','SAMOTE',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5522,4,NULL,'PostEx','SAMUNDRI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5523,4,NULL,'PostEx','SANGHAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5524,4,NULL,'PostEx','SANGLA HILL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5525,4,NULL,'PostEx','SANGWALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5526,4,NULL,'PostEx','SANJHORO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5527,4,NULL,'PostEx','SANJWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5528,4,NULL,'PostEx','SARAI ALAMGIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5529,4,NULL,'PostEx','SARAYE NORANG',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5530,4,NULL,'PostEx','SARDAR GARH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5531,4,NULL,'PostEx','SARDARYAB',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5532,4,NULL,'PostEx','SARGODHA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5533,4,NULL,'PostEx','SARI ALAMGIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5534,4,NULL,'PostEx','SAROBA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5535,4,NULL,'PostEx','SATRAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5536,4,NULL,'PostEx','SATYYANA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5537,4,NULL,'PostEx','SAUWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5538,4,NULL,'PostEx','SAWABI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5539,4,NULL,'PostEx','SAWARI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5540,4,NULL,'PostEx','SEHR BAGLA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5541,4,NULL,'PostEx','SEHWAN SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5542,4,NULL,'PostEx','SERMIK',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5543,4,NULL,'PostEx','SETHARJA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5544,4,NULL,'PostEx','SHABQADAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5545,4,NULL,'PostEx','SHADAD KOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5546,4,NULL,'PostEx','SHADIWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5547,4,NULL,'PostEx','SHAH BAGH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5548,4,NULL,'PostEx','SHAH PUR CHAKAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5549,4,NULL,'PostEx','SHAHDAD PUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5550,4,NULL,'PostEx','SHAHDADPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5551,4,NULL,'PostEx','SHAHDARA TOWN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5552,4,NULL,'PostEx','SHAHKOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5553,4,NULL,'PostEx','SHAHPUR JAHANIA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5554,4,NULL,'PostEx','SHAHPUR SADDAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5555,4,NULL,'PostEx','SHAKARGARH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5556,4,NULL,'PostEx','SHAM KOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5557,4,NULL,'PostEx','SHAMS ABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5558,4,NULL,'PostEx','SHANGLA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5559,4,NULL,'PostEx','SHARAQPUR SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5560,4,NULL,'PostEx','SHEEDO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5561,4,NULL,'PostEx','SHEIKHOO SUGAR MILLS',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5562,4,NULL,'PostEx','SHEIKHU CHAK',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5563,4,NULL,'PostEx','SHEIKHUPURA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5564,4,NULL,'PostEx','SHERGARH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5565,4,NULL,'PostEx','SHERINGAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5566,4,NULL,'PostEx','SHEWA ADDA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5567,4,NULL,'PostEx','SHIGAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5568,4,NULL,'PostEx','SHIKARPUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5569,4,NULL,'PostEx','SHIMLA HILL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5570,4,NULL,'PostEx','SHORKOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5571,4,NULL,'PostEx','SHORKOT CANTONMENT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5572,4,NULL,'PostEx','SHUJABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5573,4,NULL,'PostEx','SIALKOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5574,4,NULL,'PostEx','SIBI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5575,4,NULL,'PostEx','SIHALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5576,4,NULL,'PostEx','SIKANDARABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5577,4,NULL,'PostEx','SILANWALI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5578,4,NULL,'PostEx','SINJHORO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5579,4,NULL,'PostEx','SIR SUBA SHAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5580,4,NULL,'PostEx','SIRAYE MUHAJIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5581,4,NULL,'PostEx','SIVIA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5582,4,NULL,'PostEx','SKARDU',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5583,4,NULL,'PostEx','SMAAL IND ESTATE. DASKA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5584,4,NULL,'PostEx','SOHAWA ONLY MAIN GT ROAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5585,4,NULL,'PostEx','SUDHANOTI (AJK)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5586,4,NULL,'PostEx','SUI TOWN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5587,4,NULL,'PostEx','SUKKUR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5588,4,NULL,'PostEx','SUMBRIAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5589,4,NULL,'PostEx','SUNDER ADDA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5590,4,NULL,'PostEx','SWABI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5591,4,NULL,'PostEx','SWAT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5592,4,NULL,'PostEx','SYED WALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5593,4,NULL,'PostEx','T.T SINGH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5594,4,NULL,'PostEx','TAJA BARA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5595,4,NULL,'PostEx','TAKHT-E-BHAI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5596,4,NULL,'PostEx','TAKHT-I-BAHI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5597,4,NULL,'PostEx','TALAGANG',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5598,4,NULL,'PostEx','TALAGUNG',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5599,4,NULL,'PostEx','TALASH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5600,4,NULL,'PostEx','TALHAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5601,4,NULL,'PostEx','TALL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5602,4,NULL,'PostEx','TALPUR WADA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5603,4,NULL,'PostEx','TALVANDI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5604,4,NULL,'PostEx','TAMMAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5605,4,NULL,'PostEx','TANDLIAWALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5606,4,NULL,'PostEx','TANDO ADAM',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5607,4,NULL,'PostEx','TANDO ALLAHYAR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5608,4,NULL,'PostEx','TANDO BAGO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5609,4,NULL,'PostEx','TANDO GHULAM ALI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5610,4,NULL,'PostEx','TANDO JAM',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5611,4,NULL,'PostEx','TANDO JAN MUHAMMAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5612,4,NULL,'PostEx','TANDO MOHD KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5613,4,NULL,'PostEx','TANGI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5614,4,NULL,'PostEx','TANK',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5615,4,NULL,'PostEx','TARBELA DAM',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5616,4,NULL,'PostEx','TARNOL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5617,4,NULL,'PostEx','TAUNSA SHARIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5618,4,NULL,'PostEx','TAXILA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5619,4,NULL,'PostEx','TAXLA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5620,4,NULL,'PostEx','TEHI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5621,4,NULL,'PostEx','THARI MIRWAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5622,4,NULL,'PostEx','THATHA AMIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5623,4,NULL,'PostEx','THATTA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5624,4,NULL,'PostEx','THEENG MORE (ALLAHABAD)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5625,4,NULL,'PostEx','THOA MEHRAM KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5626,4,NULL,'PostEx','THOHA KHALSA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5627,4,NULL,'PostEx','THUL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5628,4,NULL,'PostEx','THUL HAMZA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5629,4,NULL,'PostEx','THULL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5630,4,NULL,'PostEx','TIBBA SULTANPURA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5631,4,NULL,'PostEx','TIMARGARA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5632,4,NULL,'PostEx','TIMARGARAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5633,4,NULL,'PostEx','TOBA TEK SINGH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5634,4,NULL,'PostEx','TOBAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5635,4,NULL,'PostEx','TOPA ADAM',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5636,4,NULL,'PostEx','TOPI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5637,4,NULL,'PostEx','TOPI (GIK UNIVERSITY AREA ONLY)*',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5638,4,NULL,'PostEx','TORWARSAK',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5639,4,NULL,'PostEx','TRANDA MOHAMMAD PANAH',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5640,4,NULL,'PostEx','TRANDA SAWAY KHAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5641,4,NULL,'PostEx','TRET',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5642,4,NULL,'PostEx','TULAMBA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5643,4,NULL,'PostEx','TURBAT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5644,4,NULL,'PostEx','UBARO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5645,4,NULL,'PostEx','UBAURO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5646,4,NULL,'PostEx','UCH SHRIF',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5647,4,NULL,'PostEx','UGGOKE',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5648,4,NULL,'PostEx','UMAR KOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5649,4,NULL,'PostEx','UMERKOT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5650,4,NULL,'PostEx','UPPER CHITRAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5651,4,NULL,'PostEx','UPPER DIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5652,4,NULL,'PostEx','USTA MOHAMMAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5653,4,NULL,'PostEx','USTA MUHAMMAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5654,4,NULL,'PostEx','UTHAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5655,4,NULL,'PostEx','VEHARI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5656,4,NULL,'PostEx','VERPAL CHATTHA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5657,4,NULL,'PostEx','VILLAGE SIAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5658,4,NULL,'PostEx','WADA MACHHI',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5659,4,NULL,'PostEx','WAH CANTT',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5660,4,NULL,'PostEx','WAH CANTT.',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5661,4,NULL,'PostEx','WAHNDO',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5662,4,NULL,'PostEx','WAN RAHDA RAM',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5663,4,NULL,'PostEx','WAPDA COLONY (AJK)',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5664,4,NULL,'PostEx','WARBATTAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5665,4,NULL,'PostEx','WARRAICHAN WALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5666,4,NULL,'PostEx','WARYAM WALA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5667,4,NULL,'PostEx','WAZIR KE CHATTHA',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5668,4,NULL,'PostEx','WAZIRABAD',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5669,4,NULL,'PostEx','WINDER',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5670,4,NULL,'PostEx','YAZMAN',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5671,4,NULL,'PostEx','ZAFARWAL',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5672,4,NULL,'PostEx','ZAHIR PIR',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53'),(5673,4,NULL,'PostEx','ZHOB',NULL,'Pakistan','2025-08-15 19:31:53','2025-08-15 19:31:53');

--
-- Table structure for table `complaint_issues`
--

CREATE TABLE `complaint_issues` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `complaint_issues_category_type_unique` (`category`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `complaint_issues`
--


--
-- Table structure for table `complaint_threads`
--

CREATE TABLE `complaint_threads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `ticket_id` bigint unsigned NOT NULL,
  `sender` enum('system_admin','seller','wholesaler') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sender_ref_id` bigint unsigned DEFAULT NULL,
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Has the message been read by the recipient',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `complaint_threads`
--


--
-- Table structure for table `complaint_tickets`
--

CREATE TABLE `complaint_tickets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seller_profile_id` bigint unsigned NOT NULL,
  `complaint_issue_id` bigint unsigned NOT NULL,
  `status` enum('open','in_progress','resolved','closed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `priority` enum('low','medium','high') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  `has_unread_seller_messages` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if seller has unread messages from admin',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `complaint_tickets`
--


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

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2024_05_03_131341_create_categories_table',1),(6,'2024_05_03_131406_create_brands_table',1),(7,'2024_05_03_131418_create_products_table',1),(8,'2024_05_03_131424_create_orders_table',1),(9,'2024_05_03_131431_create_order_items_table',1),(10,'2025_06_30_091933_create_seller_profils_table',1),(11,'2025_06_30_091957_create_wholesaler_profils_table',1),(12,'2025_06_30_122231_create_payment_methods_table',1),(13,'2025_06_30_141942_create_shippers_table',1),(14,'2025_07_03_204140_create_wish_lists_table',2),(17,'2025_07_22_185645_create_payouts_table',3),(18,'2025_07_22_185914_add_orderpayout',4),(19,'2025_07_31_135805_create_order_deductions_table',4),(20,'2025_07_31_192706_update_order_table',5),(21,'2025_08_03_010033_alter_tables',6),(22,'2025_08_03_165803_alter_tables',7),(23,'2025_08_19_174059_create_taxes_table',8),(24,'2025_09_09_013140_create_order_requests_table',9),(25,'2025_09_09_013218_create_order_request_threads_table',9),(26,'2025_09_09_195821_create_complaint_tickets_table',10),(27,'2025_09_09_195831_create_complaint_tickets_table',11),(28,'2025_09_09_195911_create_complaint_threads_table',11),(29,'2025_09_09_195926_create_complaint_issues_table',12),(30,'2025_09_13_051446_create_order_histories_table',13),(31,'2025_09_17_232638_alterorder',14),(32,'2025_09_17_233654_alterorder',14),(33,'2025_09_24_081244_softdeleteadd',15),(34,'2025_09_24_154842_alters',15),(35,'2025_10_08_210243_add_printable_and_print_details_columns',16),(36,'2025_10_08_210250_rename_customization_to_print_details_on_order_items',16),(37,'2025_10_11_014846_add_under_review_to_seller_profiles_table',17),(38,'2025_10_11_034623_add_cancelled_at_to_orders_table',17),(39,'2025_10_11_034716_add_notes_to_order_histories_table',17),(40,'2025_10_14_205416_add_seller_profile_id_and_wholesaler_profile_id_to_users_table',17),(41,'2025_10_22_102237_fix_complaint_tables_schema',18),(42,'2025_10_22_125201_add_total_weight_to_orders_table',18);

--
-- Table structure for table `order_deductions`
--

CREATE TABLE `order_deductions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL COMMENT 'Reference to the order',
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Reason for the deduction',
  `user_id` int DEFAULT NULL COMMENT 'who did it',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_deductions_order_id_index` (`order_id`),
  KEY `order_deductions_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_deductions`
--


--
-- Table structure for table `order_histories`
--

CREATE TABLE `order_histories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `previous_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `new_status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `changed_by` bigint unsigned DEFAULT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_histories`
--

INSERT INTO `order_histories` VALUES (1,2,'0','2',5,NULL,'2025-10-20 10:23:30','2025-10-20 10:23:30'),(2,1,'0','2',5,NULL,'2025-10-20 10:23:39','2025-10-20 10:23:39'),(3,3,'0','2',5,NULL,'2025-10-20 10:23:49','2025-10-20 10:23:49'),(4,3,'4','3',5,NULL,'2025-10-20 10:27:38','2025-10-20 10:27:38'),(5,2,'4','3',5,NULL,'2025-10-20 10:28:07','2025-10-20 10:28:07'),(6,1,'4','3',5,NULL,'2025-10-20 10:36:16','2025-10-20 10:36:16'),(9,3,'6','5',5,NULL,'2025-10-20 10:39:14','2025-10-20 10:39:14'),(10,2,'3','5',5,NULL,'2025-10-20 10:40:41','2025-10-20 10:40:41'),(11,1,'3','5',5,NULL,'2025-10-20 10:41:05','2025-10-20 10:41:05'),(12,7,'0','2',5,NULL,'2025-10-20 10:53:21','2025-10-20 10:53:21'),(13,5,'0','2',5,NULL,'2025-10-20 10:53:34','2025-10-20 10:53:34'),(14,6,'0','2',5,NULL,'2025-10-20 10:53:45','2025-10-20 10:53:45'),(15,4,'0','2',5,NULL,'2025-10-20 10:54:02','2025-10-20 10:54:02'),(16,7,'4','5',5,NULL,'2025-10-20 10:55:48','2025-10-20 10:55:48'),(17,5,'4','5',5,NULL,'2025-10-20 10:55:58','2025-10-20 10:55:58'),(18,2,'5','9',5,NULL,'2025-10-20 10:56:40','2025-10-20 10:56:40'),(19,6,'4','5',5,NULL,'2025-10-20 11:07:01','2025-10-20 11:07:01'),(20,4,'4','5',5,NULL,'2025-10-20 11:07:11','2025-10-20 11:07:11'),(21,8,'0','2',5,NULL,'2025-10-21 08:23:23','2025-10-21 08:23:23'),(22,8,'4','5',5,NULL,'2025-10-21 08:39:11','2025-10-21 08:39:11'),(23,8,'5','3',5,NULL,'2025-10-21 08:40:57','2025-10-21 08:40:57'),(24,8,'3','5',5,NULL,'2025-10-21 08:43:50','2025-10-21 08:43:50'),(27,8,'3','10',1,NULL,'2025-10-21 10:27:36','2025-10-21 10:27:36'),(28,8,'10','5',5,NULL,'2025-10-21 10:31:32','2025-10-21 10:31:32'),(29,9,'0','2',5,NULL,'2025-10-21 11:25:50','2025-10-21 11:25:50'),(30,9,'2','9',5,NULL,'2025-10-21 11:34:04','2025-10-21 11:34:04'),(31,10,'0','5',5,NULL,'2025-10-21 12:46:41','2025-10-21 12:46:41'),(32,12,'0','2',5,NULL,'2025-10-21 16:45:40','2025-10-21 16:45:40'),(33,13,'0','3',5,NULL,'2025-10-21 18:16:12','2025-10-21 18:16:12'),(34,14,'0','2',5,NULL,'2025-10-21 18:28:02','2025-10-21 18:28:02'),(35,15,'7','2',5,NULL,'2025-10-22 15:23:26','2025-10-22 15:23:26'),(36,15,'2','3',5,NULL,'2025-10-22 17:00:19','2025-10-22 17:00:19'),(37,15,'3','10',5,NULL,'2025-10-22 17:00:57','2025-10-22 17:00:57'),(38,15,'10','3',5,NULL,'2025-10-22 17:01:50','2025-10-22 17:01:50'),(39,15,'3','10',1,NULL,'2025-10-22 17:02:36','2025-10-22 17:02:36'),(40,13,'3','5',5,NULL,'2025-10-22 18:35:14','2025-10-22 18:35:14'),(41,15,'10','5',5,NULL,'2025-10-23 09:36:27','2025-10-23 09:36:27'),(42,14,'4','3',5,NULL,'2025-10-23 10:01:24','2025-10-23 10:01:24'),(43,14,'3','10',1,NULL,'2025-10-23 10:02:07','2025-10-23 10:02:07');

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `product_variant_id` bigint unsigned NOT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `unit_amount` decimal(10,2) DEFAULT NULL,
  `unit_discounted_amount` decimal(10,2) DEFAULT NULL,
  `base_amount` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_purchased_price` decimal(10,2) DEFAULT '0.00',
  `print_details` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_product_variant_id_foreign` (`product_variant_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` VALUES (1,1,1,1,589.00,589.00,589.00,'2025-10-20 10:19:56','2025-10-20 10:19:56',475.00,NULL),(2,2,1,1,589.00,589.00,589.00,'2025-10-20 10:20:20','2025-10-20 10:20:20',475.00,NULL),(3,3,1,1,589.00,589.00,589.00,'2025-10-20 10:23:32','2025-10-20 10:23:32',475.00,NULL),(4,4,1,1,589.00,589.00,589.00,'2025-10-20 10:41:08','2025-10-20 10:41:08',475.00,NULL),(5,5,1,1,589.00,589.00,589.00,'2025-10-20 10:42:34','2025-10-20 10:42:34',475.00,NULL),(6,6,1,1,589.00,589.00,589.00,'2025-10-20 10:48:54','2025-10-20 10:48:54',475.00,NULL),(7,7,1,1,589.00,589.00,589.00,'2025-10-20 10:52:45','2025-10-20 10:52:45',475.00,NULL),(8,8,3,1,699.00,699.00,699.00,'2025-10-20 18:14:40','2025-10-20 18:14:40',430.00,NULL),(9,9,2,1,198.00,198.00,198.00,'2025-10-21 11:23:42','2025-10-21 11:23:42',120.00,NULL),(10,10,5,1,216.00,216.00,216.00,'2025-10-21 12:33:11','2025-10-21 12:33:11',130.00,NULL),(11,11,6,1,849.00,849.00,849.00,'2025-10-21 14:46:59','2025-10-21 14:46:59',750.00,NULL),(12,12,6,1,849.00,849.00,849.00,'2025-10-21 16:40:05','2025-10-21 16:40:05',750.00,NULL),(13,13,1,1,589.00,589.00,589.00,'2025-10-21 17:18:23','2025-10-21 17:18:23',475.00,NULL),(14,14,11,1,279.00,279.00,279.00,'2025-10-21 18:19:02','2025-10-21 18:19:02',220.00,NULL),(15,15,11,1,279.00,279.00,279.00,'2025-10-22 10:50:52','2025-10-22 10:50:52',220.00,NULL),(16,15,6,1,849.00,849.00,849.00,'2025-10-22 10:50:52','2025-10-22 10:50:52',750.00,NULL),(17,15,4,1,549.00,0.00,549.00,'2025-10-22 10:50:52','2025-10-22 10:50:52',450.00,NULL),(18,15,3,1,699.00,699.00,699.00,'2025-10-22 10:50:52','2025-10-22 10:50:52',430.00,NULL),(19,15,1,1,589.00,589.00,589.00,'2025-10-22 10:50:52','2025-10-22 10:50:52',475.00,NULL);

--
-- Table structure for table `order_request_threads`
--

CREATE TABLE `order_request_threads` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_request_id` bigint unsigned NOT NULL,
  `sender` int NOT NULL DEFAULT '0' COMMENT '0=system admin ,1=seller,2=wholesaler',
  `message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_request_threads_order_request_id_foreign` (`order_request_id`),
  CONSTRAINT `order_request_threads_order_request_id_foreign` FOREIGN KEY (`order_request_id`) REFERENCES `order_requests` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_request_threads`
--

INSERT INTO `order_request_threads` VALUES (1,1,1,'plz deliver asap','2025-10-21 10:27:36','2025-10-21 10:27:36'),(2,1,0,'<p>ok done</p>','2025-10-21 10:30:34','2025-10-21 10:30:34'),(3,1,1,'thanks','2025-10-21 10:31:37','2025-10-21 10:31:37'),(4,1,0,'<p>How</p>','2025-10-22 16:56:13','2025-10-22 16:56:13'),(5,1,0,'<p>Hi how are u</p>','2025-10-22 16:56:27','2025-10-22 16:56:27'),(6,2,1,'Reattampt asap','2025-10-22 17:02:36','2025-10-22 17:02:36'),(7,2,0,'<p>Noted</p>','2025-10-22 17:03:59','2025-10-22 17:03:59'),(8,2,1,'<img src=\"data:image/jpeg;base64,[BLOB]\" style=\"max-width: 100%; height: auto; border-radius: 8px; margin: 8px 0;\" alt=\"Uploaded image\">\n                                    ','2025-10-22 18:26:54','2025-10-22 18:26:54'),(9,2,0,'<p>hellow</p>','2025-10-23 09:35:06','2025-10-23 09:35:06'),(10,3,1,'hi whatabout my order','2025-10-23 10:02:07','2025-10-23 10:02:07'),(11,3,0,'<p>Dispatched</p>','2025-10-23 10:03:44','2025-10-23 10:03:44');

--
-- Table structure for table `order_requests`
--

CREATE TABLE `order_requests` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0=pending,1=in_process,2=delivered,3=returned',
  `requested_type` tinyint NOT NULL DEFAULT '0' COMMENT '0=re-attempt,1=returned',
  `seller_profile_id` int NOT NULL,
  `wholesaler_profile_id` int NOT NULL,
  `shipper_id` int NOT NULL,
  `shipping_ref` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_message` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_status_change_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `order_id` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_requests`
--

INSERT INTO `order_requests` VALUES (1,2,0,1,1,4,'20074190037367','Hi how are u','2025-10-22 16:56:27','2025-10-21 10:27:36','2025-10-22 16:56:27',8),(2,0,0,1,1,2,'KI7509069093','hellow','2025-10-23 09:35:06','2025-10-22 17:02:36','2025-10-23 09:35:06',15),(3,0,0,1,1,4,'29074190037374','Dispatched','2025-10-23 10:03:44','2025-10-23 10:02:07','2025-10-23 10:03:44',14);

--
-- Table structure for table `order_taxes`
--

CREATE TABLE `order_taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `tax_id` bigint unsigned NOT NULL,
  `type` enum('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_taxes_order_id_foreign` (`order_id`),
  KEY `order_taxes_tax_id_foreign` (`tax_id`),
  CONSTRAINT `order_taxes_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_taxes_tax_id_foreign` FOREIGN KEY (`tax_id`) REFERENCES `taxes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_taxes`
--

INSERT INTO `order_taxes` VALUES (1,1,2,'percentage',2.50,25.00,'2025-10-20 10:19:56','2025-10-20 10:19:56'),(2,2,2,'percentage',2.50,37.48,'2025-10-20 10:20:20','2025-10-20 10:20:20'),(3,3,2,'percentage',2.50,32.48,'2025-10-20 10:23:32','2025-10-20 10:23:32'),(4,4,2,'percentage',2.50,29.98,'2025-10-20 10:41:08','2025-10-20 10:41:08'),(5,5,2,'percentage',2.50,29.98,'2025-10-20 10:42:34','2025-10-20 10:42:34'),(6,6,2,'percentage',2.50,25.00,'2025-10-20 10:48:54','2025-10-20 10:48:54'),(7,7,2,'percentage',2.50,25.00,'2025-10-20 10:52:45','2025-10-20 10:52:45'),(8,8,2,'percentage',2.50,29.98,'2025-10-20 18:14:40','2025-10-20 18:14:40'),(9,9,2,'percentage',2.50,20.00,'2025-10-21 11:23:42','2025-10-21 11:23:42'),(10,10,2,'percentage',2.50,22.50,'2025-10-21 12:33:11','2025-10-21 12:33:11'),(11,11,2,'percentage',2.50,36.10,'2025-10-21 14:46:59','2025-10-21 14:46:59'),(12,12,2,'percentage',2.50,37.48,'2025-10-21 16:40:05','2025-10-21 16:40:05'),(13,13,2,'percentage',2.50,24.98,'2025-10-21 17:18:23','2025-10-21 17:18:23'),(14,14,2,'percentage',2.50,24.98,'2025-10-21 18:19:02','2025-10-21 18:19:02');

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seller_profile_id` int NOT NULL COMMENT 'User ID as a seller ID',
  `wholesaler_profile_id` int NOT NULL COMMENT 'Wholesaler ID as a seller ID',
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_city` int DEFAULT NULL,
  `city_id` int DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `discounted_amount` decimal(10,2) DEFAULT '0.00',
  `shipping_charges` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_weight` decimal(10,2) NOT NULL DEFAULT '0.00',
  `weight_unit` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'kg',
  `base_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Base amount after any discount or tax etc',
  `tax_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Tax amount applied on the order',
  `seller_profit_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `seller_status` tinyint NOT NULL DEFAULT '0' COMMENT '0:pending, 1:invoiced, 2:paid',
  `payout_id` bigint unsigned DEFAULT NULL,
  `seller_deduction_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `payment_method_id` int DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0:paid to seller, 1:pending, 2:confirmed, 3:ready to process, 4:shipped, 5:ready to ship, 6:delivered, 7:refused/returned, 8:on hold, 9:cancelled, 10:return confirm, 11:shipper advise',
  `package_openable` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if the package can be opened by the customer',
  `ready_to_pay_seller` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if the order is ready to pay to the seller',
  `shipper_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `total_purchased_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Total cost of products from wholesaler',
  `shipper_city_id` bigint unsigned DEFAULT NULL,
  `city_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_instructions` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_status` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `profit_cost_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `net_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `cancelled_at` timestamp NULL DEFAULT NULL,
  `orderscol` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_seller_profile_id_index` (`seller_profile_id`),
  KEY `orders_wholesaler_profile_id_index` (`wholesaler_profile_id`),
  KEY `orders_payout_id_foreign` (`payout_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` VALUES (1,13,1,'zain Khan','03406740008',NULL,'sadder bank road rania mall 2 floor office number 247',NULL,4671,589.00,0.00,230.00,0.00,'kg',844.00,25.00,156.00,2,1,0.00,1,5,0,1,'2','KI7509011208','2025-10-20 10:19:56','2025-10-20 11:10:59',475.00,NULL,NULL,'Call Before Delviery',NULL,114.00,1000.00,NULL,NULL),(2,1,1,'Zain qureshi','03323399562',NULL,'H-487/20 near advani building karachi',NULL,4330,589.00,0.00,230.00,0.00,'kg',856.48,37.48,642.53,2,2,0.00,2,9,0,0,'2','KI7509011194','2025-10-20 10:20:20','2025-10-22 10:44:21',475.00,NULL,NULL,'no instructions','Pickup Request not Send | Date: 2025-10-22 12:44:21',114.00,1499.00,NULL,NULL),(3,1,1,'Kashif abbasi','03462425813',NULL,'dharamshala House no 519 Lahore',NULL,5277,589.00,0.00,230.00,0.00,'kg',851.48,32.48,447.53,2,2,0.00,1,5,0,1,'4','26074190037276','2025-10-20 10:23:32','2025-10-20 17:31:10',475.00,NULL,NULL,'no instructions','At AR FAST LOGISTICS Warehouse | Date: 2025-10-20 17:23:49',114.00,1299.00,NULL,NULL),(4,1,1,'hammad','03432425813',NULL,'peshawar high school karkhano market',NULL,151,589.00,0.00,230.00,0.00,'kg',848.98,29.98,350.03,2,2,0.00,1,5,0,1,'6','20227156473411','2025-10-20 10:41:08','2025-10-20 17:30:56',475.00,NULL,NULL,'no instructions','Shipment - Booked | Date: 2025-10-20 17:54:00',114.00,1199.00,NULL,NULL),(5,1,1,'daniyal','03323355956',NULL,'mansehra kpk ',NULL,4465,589.00,0.00,230.00,0.00,'kg',848.98,29.98,350.03,2,2,0.00,1,5,0,1,'2','KI7509012480','2025-10-20 10:42:34','2025-10-20 17:29:33',475.00,NULL,NULL,'no instructions','Pickup Request not Send | Date: 2025-10-20 19:29:33',114.00,1199.00,NULL,NULL),(6,13,1,'Dil Shah','03689789955',NULL,'House number 110 4 MES Colony Shami Road Lahore Cantt',NULL,5277,589.00,0.00,230.00,0.00,'kg',844.00,25.00,156.00,2,1,0.00,1,5,0,1,'4','28074190037277','2025-10-20 10:48:54','2025-10-20 11:10:59',475.00,NULL,NULL,'Deliver Urgent hai ',NULL,114.00,1000.00,NULL,NULL),(7,13,1,'Hammad ','03408670006',NULL,'2B East Street Phase 1 DHA Karachi 25000 Pakistan',NULL,94,589.00,0.00,230.00,0.00,'kg',844.00,25.00,156.00,2,1,0.00,1,5,0,1,'6','20220256473399','2025-10-20 10:52:45','2025-10-20 11:10:59',475.00,NULL,NULL,'Call delivery',NULL,114.00,1000.00,NULL,NULL),(8,1,1,'Saim','03323399562',NULL,'Lasbela karachi',NULL,4857,699.00,0.00,230.00,0.00,'kg',958.98,29.98,240.03,2,3,0.00,1,5,0,1,'4','20074190037367','2025-10-20 18:14:40','2025-10-21 10:31:32',430.00,NULL,NULL,'no instructions','At AR FAST LOGISTICS Warehouse | Date: 2025-10-21 15:23:22',269.00,1199.00,NULL,NULL),(9,13,1,'Fake Order','03580987779',NULL,'First Floor Time Motar Opposite New Memom Plaza',NULL,4857,198.00,0.00,230.00,0.00,'kg',448.00,20.00,352.00,2,4,0.00,1,9,0,0,'4','20074190037372','2025-10-21 11:23:42','2025-10-21 12:51:23',120.00,NULL,NULL,'no instructions',NULL,78.00,800.00,NULL,NULL),(10,13,1,'momo','03489797888',NULL,'First Floor Time Motar Opposite New Memom Plaza',NULL,4030,216.00,0.00,230.00,0.00,'kg',468.50,22.50,431.50,0,NULL,0.00,1,5,0,0,'2',NULL,'2025-10-21 12:33:11','2025-10-21 12:46:41',130.00,NULL,NULL,'call before delivery',NULL,86.00,900.00,NULL,NULL),(11,12,1,'Momal','03002666857',NULL,'Karachi garden pakistan',NULL,4029,849.00,0.00,230.00,0.00,'kg',1115.10,36.10,328.90,0,NULL,0.00,1,0,0,0,'2',NULL,'2025-10-21 14:46:59','2025-10-21 14:46:59',750.00,NULL,NULL,'no instructions',NULL,99.00,1444.00,NULL,NULL),(12,12,1,'Khan','03323399562',NULL,'Karachi pak',NULL,4857,849.00,0.00,230.00,0.00,'kg',1116.48,37.48,382.53,0,NULL,0.00,2,2,1,0,'4','27074190037373','2025-10-21 16:40:05','2025-10-21 16:45:40',750.00,NULL,NULL,'no instructions',NULL,99.00,1499.00,NULL,NULL),(13,1,1,'Asim','03323399562',NULL,'Abbotabad kpk',NULL,4029,589.00,0.00,230.00,0.00,'kg',843.98,24.98,155.03,0,NULL,0.00,1,5,1,0,'2',NULL,'2025-10-21 17:18:23','2025-10-22 18:35:14',475.00,NULL,NULL,'no instructions',NULL,114.00,999.00,NULL,NULL),(14,1,1,'Asif','03323399562',NULL,'H218 st 19 karachi',NULL,4857,279.00,0.00,230.00,0.00,'kg',533.98,24.98,465.03,0,NULL,0.00,2,10,0,0,'4','29074190037374','2025-10-21 18:19:02','2025-10-23 10:02:07',220.00,NULL,NULL,'no instructions',NULL,59.00,999.00,NULL,NULL),(15,1,1,'momo','03899890009',NULL,'First Floor Time Motar Opposite New Memom Plaza',NULL,4038,2965.00,0.00,530.00,0.00,'kg',3495.00,0.00,0.00,0,NULL,0.00,2,5,1,0,'2','KI7509069093','2025-10-22 10:50:52','2025-10-23 09:36:27',2325.00,NULL,NULL,'no instructions',NULL,640.00,3495.00,NULL,NULL);

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the payment method',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of the payment method',
  `settings` json DEFAULT NULL COMMENT 'JSON field for additional settings',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1=active, 0=inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_methods_title_unique` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` VALUES (1,'Cash on Delivery','Pay with cash upon delivery.','[]',1,'2025-07-02 12:20:06','2025-10-22 14:54:30'),(2,'Bank Transfer','Transfer the amount directly to our bank account.','{\"IBN\": \"PK88FAYS3507301000002837\", \"bank_name\": \"FAYSAL BANK\", \"account_title\": \"Ar Fast Logistics\", \"account_number\": \"3507301000002837\"}',1,'2025-07-02 12:20:06','2025-10-21 17:08:31'),(3,'JazzCash','3123456789 account','{\"mode\": \"live\", \"api_key\": \"sk_live_xxxx\"}',0,'2025-07-02 12:20:06','2025-07-02 12:20:06'),(4,'EasyPaisa','Pay with EasyPaisa 31234567890 account','{\"mode\": \"live\", \"api_key\": \"sk_live_yyyy\"}',0,'2025-07-02 12:20:06','2025-10-17 12:04:18');

--
-- Table structure for table `payouts`
--

CREATE TABLE `payouts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seller_profile_id` bigint unsigned NOT NULL,
  `total_orders` int NOT NULL DEFAULT '0',
  `total_shipped_orders` int NOT NULL DEFAULT '0',
  `total_return_orders` int NOT NULL DEFAULT '0',
  `total_items` int NOT NULL DEFAULT '0',
  `total_profit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_deduction` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_order_deduction` decimal(10,2) NOT NULL DEFAULT '0.00',
  `final_payout` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_shipping_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_product_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_wholesaler_cost` decimal(10,2) NOT NULL DEFAULT '0.00',
  `profit_cost_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `net_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '0: pending, 1: approved, 2: declined, 3: paid',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `proofs` json DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `payouts_seller_profile_id_foreign` (`seller_profile_id`),
  CONSTRAINT `payouts_seller_profile_id_foreign` FOREIGN KEY (`seller_profile_id`) REFERENCES `seller_profiles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payouts`
--

INSERT INTO `payouts` VALUES (1,13,3,3,0,3,468.00,0.00,0.00,468.00,75.00,690.00,1767.00,1425.00,342.00,3000.00,3,'Admin User updated payout with 3 delivered orders.','2025-10-20 11:04:39','2025-10-20 11:10:59',NULL),(2,1,4,3,1,3,1147.59,0.00,0.00,1147.59,92.44,690.00,1767.00,1425.00,342.00,3697.00,3,'Admin User updated payout with 3 delivered orders.','2025-10-20 11:04:39','2025-10-20 11:10:57',NULL),(3,1,1,1,0,1,240.03,0.00,0.00,240.03,29.98,230.00,699.00,430.00,269.00,1199.00,3,'Admin User updated payout with 1 delivered orders.','2025-10-21 09:03:02','2025-10-21 09:05:00',NULL),(4,13,0,0,1,0,0.00,230.00,0.00,-230.00,0.00,0.00,0.00,0.00,0.00,0.00,3,'Admin User updated payout with 1 returned orders.','2025-10-21 12:50:24','2025-10-21 12:51:23',NULL);

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

CREATE TABLE `product_variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock` int NOT NULL DEFAULT '0',
  `cover_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` json DEFAULT NULL,
  `weight` decimal(8,2) DEFAULT NULL COMMENT 'Weight of the product',
  `weight_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unit of weight, e.g., kg, lb',
  `purchased_price` decimal(10,2) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `discounted_price` decimal(10,2) DEFAULT NULL COMMENT 'Price after discount, if applicable',
  `discount_start_date` datetime DEFAULT NULL COMMENT 'Start date for discount',
  `discount_end_date` datetime DEFAULT NULL COMMENT 'End date for discount',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1=active, 0=inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_variants_sku_unique` (`sku`),
  KEY `product_variants_product_id_foreign` (`product_id`),
  CONSTRAINT `product_variants_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_variants`
--

INSERT INTO `product_variants` VALUES (1,1,'SKU-BFF65U3D',12,'products/01K80QKXV2B9BSWB4XE42KMKK4.jpg','[\"products/01K80QKXV70DR9C09ZN7WR33F0.jpg\", \"products/01K80QKXV8YAX29P4R7RQKGSEF.jpg\", \"products/01K80QKXVA3K2KY4KWB0VYJWZ7.jpg\", \"products/01K80QKXVB6G9W042YAS2FSASQ.jpg\", \"products/01K80QKXVCQ4EVVSQN877MXG46.jpg\"]',0.30,'kg',475.00,589.00,NULL,NULL,NULL,1,'2025-10-20 09:56:01','2025-10-24 12:07:56'),(2,2,'AR2',4999,'products/01K813210RR0DFT9TPNTFEXD7E.jpg','[\"products/01K813210Y5PZNGEERRHACJEWZ.jpg\", \"products/01K813210Z389PYFAH409RXRSB.jpg\", \"products/01K813210Z389PYFAH409RXRSC.jpg\"]',0.10,'kg',120.00,198.00,NULL,NULL,NULL,1,'2025-10-20 13:15:58','2025-10-21 11:23:42'),(3,3,'AR3',4997,'products/01K813E5375DAMY87361AV5KN5.jpg','[\"products/01K813E53ETF0P861FJQJY7SZC.jpg\", \"products/01K813E53KJ2EDMYN5BTHNWPET.jpg\", \"products/01K813E53P45430S1039131JWC.jpg\", \"products/01K813E53VCNC068KGZYY7NRRF.jpg\", \"products/01K813E53XV581FAGEFEFABAH6.jpg\"]',1.00,NULL,430.00,699.00,NULL,NULL,NULL,1,'2025-10-20 13:22:35','2025-10-22 10:50:52'),(4,4,'AR4',499,'products/01K83D6SF2TEE9PCETC0KS2KW9.jpg','[\"products/01K83D6SF8BNCNG5Y8RJX0A054.jpg\", \"products/01K83D6SFAVJQXEGS5X40QK2EJ.jpg\", \"products/01K83D6SFAVJQXEGS5X40QK2EK.jpg\", \"products/01K83D6SFBX2VS35MD5W25S3PX.jpg\"]',0.40,'kg',450.00,699.00,549.00,NULL,NULL,1,'2025-10-21 10:51:48','2025-10-22 10:50:52'),(5,5,'AR5',4999,'products/01K83FCTGYZCFHQ4KT0VMEMM82.jpg','[\"products/01K83FCTH3N9VANAR96BEDN6W2.jpg\", \"products/01K83FCTH45B2VXNQ05JDXXXS4.jpg\", \"products/01K83FCTH5SDZRARSGKT1X8D8Q.jpg\"]',0.20,'kg',130.00,216.00,NULL,NULL,NULL,1,'2025-10-21 11:30:03','2025-10-21 12:33:11'),(6,6,'AR5-S',4997,'products/01K83FY2GP1FQPPJ13N5YVFJEK.jpg','[\"products/01K83FY2GR5TGAB3DE3V3A8TM8.jpg\", \"products/01K83FY2GTB6D1QQNQY8VEW682.jpg\", \"products/01K83FY2GTB6D1QQNQY8VEW683.jpg\", \"products/01K83FY2GV672VZ3J6E2A2WJKP.jpg\", \"products/01K83FY2GWY9XR6GXBAHXJDJ53.jpg\"]',0.50,'kg',750.00,849.00,NULL,NULL,NULL,1,'2025-10-21 11:39:29','2025-10-22 10:50:52'),(7,6,'AR5-M',5000,'products/01K83FY2H0ZTBJ042P2FK07FDN.jpg','[]',0.50,'kg',750.00,849.00,NULL,NULL,NULL,1,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(8,6,'AR5-L',5000,'products/01K83FY2H4FCJMMGYSMQV8RV6F.jpg','[]',0.50,'kg',750.00,849.00,NULL,NULL,NULL,1,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(9,6,'AR5-XL',5000,'products/01K83FY2H8EHWSGSRZC05TZJR1.jpg','[]',0.50,'kg',750.00,849.00,NULL,NULL,NULL,1,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(10,6,'AR5-XXL',5000,'products/01K83FY2HC5F9WS8QZ4TH9HVGA.jpg','[]',0.50,'kg',750.00,849.00,NULL,NULL,NULL,1,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(11,7,'AR6',4998,'products/01K83GJP8CEBW4Z1Y7J00MMQVW.jpg','[\"products/01K83GJP8G0XNY4Y0GH5AW2ZK9.jpg\", \"products/01K83GJP8HTBPCK29QP2TG6A21.jpg\", \"products/01K83GJP8J59AN7KVKWWZYFD02.jpg\"]',-1.00,'kg',220.00,279.00,NULL,NULL,NULL,1,'2025-10-21 11:50:44','2025-10-22 10:50:52');

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

CREATE TABLE `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `wholesaler_profile_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `specifications` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dispute_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `Embedded_videos` json DEFAULT NULL,
  `chart_images` json DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1=active, 0=inactive',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `is_bulk` tinyint(1) NOT NULL DEFAULT '0',
  `printable_product` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_slug_unique` (`slug`),
  KEY `products_category_id_index` (`category_id`),
  KEY `products_wholesaler_profile_id_index` (`wholesaler_profile_id`),
  KEY `products_deleted_at_index` (`deleted_at`),
  KEY `products_printable_product_index` (`printable_product`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` VALUES (1,'Original ECRIN COOL STYLING HAIR GEL WITH ACTIVE COLLAGEN 280ml','original-ecrin-cool-styling-hair-gel-with-active-collagen-280ml','3','1',NULL,'<p><strong>ECRIN Cool Styling Hair Gel with Active Collagen – 280ml</strong></p><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">Take control of your style with <strong>ECRIN Cool Styling Hair Gel</strong> – the ultimate solution for long-lasting hold and a healthy shine. Infused with <strong>Active Collagen</strong>, this gel not only keeps your hair in place all day but also <strong>nourishes and strengthens</strong> each strand from root to tip.</p><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><img style=\"box-sizing: border-box; border: 0px; vertical-align: middle; max-width: 100%;\" src=\"https://cdn.shopify.com/s/files/1/0844/3091/3846/files/shopify_9.png?v=1755093196\"></p><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">Perfect for all hair types, it gives you that <strong>fresh, cool look</strong> without the stiffness or flakes. Whether you&#039;re going for a clean, sleek finish or a bold, textured style, ECRIN has you covered.</p><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">? Strong Hold<br>? No Residue or Flakes<br>? Enriched with Active Collagen<br>? Refreshing Cool Effect<br>? Suitable for Daily Use</p><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">Style with confidence. <strong>Look sharp. Stay fresh.</strong></p>','<h4 class=\"bold tbmargin10;\" style=\"box-sizing: border-box; font-family: inherit; font-weight: 700 !important; line-height: 1.1; color: inherit; margin-top: 8.5px; margin-bottom: 8.5px; font-size: 15px;\"><strong>WHAT&#039;S IN THE BOX</strong></h4><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px;\">1x Original ECRIN COOL STYLING HAIR GEL WITH ACTIVE COLLAGEN 280ml</p>','<p>Memom Trader</p>','[{\"url\": null}]','[]',0,1,0,0,'2025-10-20 09:56:01','2025-10-24 12:07:36',NULL),(2,'Baby Crawling Anti Slip Knee Protector Leg Warmers Kids Knee Pads Adjustable Kneepads For Toddlers','baby-crawling-anti-slip-knee-protector-leg-warmers-kids-knee-pads-adjustable-kneepads-for-toddlers','6',NULL,NULL,'<p><span style=\"color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;\">These baby knee pads can protect your baby&#039;s knees from bruises and scrapes when they are crawling and learning to walk and Suitable for any season. The baby knee pads design of high elastic sponge, very breathable, absorb sweat, deodorization durable and soft to wear. Adjustable Knee pad so can fit the baby leg perfectly. Adjustable knee pad so can fit the baby leg perfectly. The knee pads are easy to wash, to keep baby knee pads soft and quality, we recommend that you wash them by hand. </span></p>','<h4 class=\"bold tbmargin10;\" style=\"box-sizing: border-box; font-family: inherit; font-weight: 700 !important; line-height: 1.1; color: inherit; margin-top: 8.5px; margin-bottom: 8.5px; font-size: 15px;\"><strong>WHAT&#039;S IN THE BOX</strong></h4><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px;\">1x Baby Crawling Anti Slip Knee Protector Leg Warmers Kids Knee pads Adjustable Kneepads for Toddlers</p>',NULL,'[{\"url\": null}]','[]',1,1,0,0,'2025-10-20 13:15:58','2025-10-20 13:16:38',NULL),(3,' Sweet Sweat Waist Trimmer Belt For Weight Loss (Only Advance Payment)','sweet-sweat-waist-trimmer-belt-for-weight-loss-only-advance-payment','5','1',NULL,'<ul style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 8.5px; display: block; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><li style=\"box-sizing: border-box;\"><p>GET YOUR SWEAT ON: The Sweet Sweat Waist Trimmer is designed to enhance your workout by helping to improve thermogenic activity and SWEAT!</p></li><li style=\"box-sizing: border-box;\"><p>CONTOURED &amp; FLEXES FOR CUSTOM FIT: The Sweet Sweat Waist Trimmer is naturally flexible to adjust to your size and shape and contoured to fit around your waist comfortably during exercise.</p></li><li style=\"box-sizing: border-box;\"><p>Please note - Waist Trimmer should be worn loose enough to provide a full range of motion during your workouts.</p></li><li style=\"box-sizing: border-box;\"><p>PREMIUM QUALITY: Made with extra thick, latex-free Neoprene for an enhanced sweating experience. But don’t worry about the extra Sweat, our Waist Trimmer&#039;s grid inner lining will not only repel moisture absorption but also limit slipping and bunching during your workout.</p></li></ul>',NULL,NULL,'[{\"url\": null}]','[]',1,1,0,0,'2025-10-20 13:22:35','2025-10-20 13:22:35',NULL),(4,'Car Shape Clip Phone Holder Adjustable','car-shape-clip-phone-holder-adjustable','4','1',NULL,'<ul class=\"a-unordered-list a-vertical a-spacing-mini\" style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 8.5px; display: block; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><li class=\"a-spacing-mini\" style=\"box-sizing: border-box;\"><p><span class=\"a-list-item\" style=\"box-sizing: border-box;\">Car Auto Universal SportsCar Shape?The unique sports car-like appearance design can not only be used as a car stand, but also as a decoration to satisfy your sports car dream!</span></p></li><li class=\"a-spacing-mini\" style=\"box-sizing: border-box;\"><p><span class=\"a-list-item\" style=\"box-sizing: border-box;\">?Clip Phone Holder?The bottom of the product is designed with strong film, which is safe and traceless, does not fall off, and does not shake. There is no need to worry about falling off during the subversive journey.</span></p></li><li class=\"a-spacing-mini\" style=\"box-sizing: border-box;\"><p><span class=\"a-list-item\" style=\"box-sizing: border-box;\">?Car Phone Holder?Pay attention to beauty but don&#039;t neglect protection. It is anti-slip, anti-scratch and anti-falling, protecting your device during use.360-degree rotation to meet multi-directional and multi-angle needs.</span></p></li><li class=\"a-spacing-mini\" style=\"box-sizing: border-box;\"><p><span class=\"a-list-item\" style=\"box-sizing: border-box;\">?Automobile Cradles Universal?Compatible with a variety of mobile phone and other player screen sizes, the span can be as wide as 105 mm, so there is no need to worry about your device being unable to be installed or fixed.</span></p></li></ul>',NULL,NULL,'[{\"url\": null}]','[]',1,1,0,0,'2025-10-21 10:51:48','2025-10-21 10:51:48',NULL),(5,'Hot & Cold Soft & Flexible Gel Ice Pack For Pain Relief,','hot-cold-soft-flexible-gel-ice-pack-for-pain-relief','5','1',NULL,'<ul style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 8.5px; display: block; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><li style=\"box-sizing: border-box;\"><p>Professional series</p></li><li style=\"box-sizing: border-box;\"><p>High quality</p></li><li style=\"box-sizing: border-box;\"><p>Easy to use</p></li><li style=\"box-sizing: border-box;\"><p>Hot and cold pack</p></li><li style=\"box-sizing: border-box;\"><p>ICE GEL PACK</p></li></ul>',NULL,NULL,'[{\"url\": null}]','[]',1,1,0,0,'2025-10-21 11:30:03','2025-10-21 11:30:03',NULL),(6,'Adjustable Magnetic Posture Corrector Corset Back Brace Back Belt Lumbar Support Straight Corrector','adjustable-magnetic-posture-corrector-corset-back-brace-back-belt-lumbar-support-straight-corrector','5',NULL,NULL,'<ul style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 8.5px; display: block; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><li style=\"box-sizing: border-box;\"><p>Supports Proper Posture and Relieves Back Pain</p></li><li style=\"box-sizing: border-box;\"><p>2. Lightweight, Easy to Wear and Easy to Wash</p></li><li style=\"box-sizing: border-box;\"><p>3. Comfortable Neoprene material allows you to wear the brace at work, home, and while exercising</p></li><li style=\"box-sizing: border-box;\"><p>4. Can be discretely worn under clothing</p></li><li style=\"box-sizing: border-box;\"><p>5. Straps adjustable for comfort, help pull the shoulders back to stand tall &amp; sit up straight</p></li><li style=\"box-sizing: border-box;\"><p>6. Supporting design helps correct poor posture</p></li><li style=\"box-sizing: border-box;\"><p>7. Pulls shoulder back to correct posture</p></li><li style=\"box-sizing: border-box;\"><p>8. Provides gentle back support</p></li></ul>',NULL,NULL,'[{\"url\": null}]','[]',1,1,0,0,'2025-10-21 11:39:28','2025-10-21 11:39:28',NULL),(7,'Apple Cutter Slicer Stainless Steel','apple-cutter-slicer-stainless-steel','4','1',NULL,'<ul style=\"box-sizing: border-box; margin-top: 0px; margin-bottom: 8.5px; display: block; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\"><li style=\"box-sizing: border-box;\"><p>Premium Stainless Steel Blades: Sharp, rust-resistant blades for smooth and precise slicing.</p></li><li style=\"box-sizing: border-box;\"><p>Effortless Cutting: Quickly slices apples or similar fruits into 8–12 uniform pieces while removing the core.</p></li><li style=\"box-sizing: border-box;\"><p>Comfortable Grip: Ergonomic, non-slip handles for easy handling and maximum comfort.</p></li><li style=\"box-sizing: border-box;\"><p>Durable &amp; Safe: Made from food-grade materials, ensuring long-lasting use and safety for your family.</p></li><li style=\"box-sizing: border-box;\"><p>Multifunctional Tool: Ideal for slicing fruits like apples, pears, and even small vegetables for salads, snacks, or baking.</p></li></ul><p style=\"box-sizing: border-box; margin: 0px 0px 8.5px; color: rgb(76, 77, 77); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 13px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;\">An essential tool for every kitchen, this apple cutter and slicer saves time and effort, making meal prep faster and more enjoyable!</p>',NULL,NULL,'[{\"url\": \"https://youtube.com/shorts/9BH1J1wTCT0?si=73E8d977uOQ8XTWJ\"}]','[]',1,1,0,0,'2025-10-21 11:50:44','2025-10-21 16:57:42',NULL);

--
-- Table structure for table `shippers`
--

CREATE TABLE `shippers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the shipper',
  `fixed_amount_charge` decimal(8,2) NOT NULL DEFAULT '200.00' COMMENT 'Rate per kg for shipping',
  `packaging_charges` decimal(8,2) NOT NULL DEFAULT '30.00' COMMENT 'Packaging charges for the shipment',
  `logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` json DEFAULT NULL COMMENT 'JSON field for additional settings',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '1=active, 0=inactive',
  `per_kg_additional_charge` decimal(8,2) NOT NULL DEFAULT '0.00' COMMENT 'Additional charge per kg beyond base weight',
  `additional_charge_threshold_weight` decimal(8,2) NOT NULL DEFAULT '1.00' COMMENT 'Apply additional per kg charge if weight is greater than or equal to this threshold',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `shippers_title_unique` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shippers`
--

INSERT INTO `shippers` VALUES (1,'TCS Courier',200.00,30.00,NULL,'[]',0,0.00,1.00,'2025-07-02 12:20:06','2025-09-15 10:15:14'),(2,'Leopard Couriers',200.00,30.00,'shippers/logos/01K2RBHASYR66F1XTN5RW8Z9AP.jpg','[]',1,150.00,0.99,'2025-07-02 12:20:06','2025-10-20 18:40:09'),(3,'Trax2',200.00,30.00,'shippers/logos/01JZB4X8WK6EX77YB29HZ5984V.png','[]',0,0.00,1.00,'2025-07-02 12:20:06','2025-09-15 10:14:14'),(4,'Post EX',200.00,30.00,'shippers/logos/01K2RBHSP5XYVBGP9MK0RJ2YD3.jpg','{\"address_code\": \"001\"}',1,150.00,1.00,'2025-07-02 12:20:06','2025-09-24 14:27:07'),(5,'Call Courier',200.00,30.00,NULL,'[]',0,0.00,1.00,'2025-07-02 12:20:06','2025-09-15 10:14:32'),(6,'TRAX',200.00,30.00,'shippers/logos/01K2RBJ48Y06A52E2RM1AVNR60.jpg','[]',1,150.00,1.00,'2025-07-02 12:20:06','2025-09-24 14:27:27');

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

CREATE TABLE `taxes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('percentage','fixed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'percentage',
  `rate` decimal(10,2) NOT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxes`
--

INSERT INTO `taxes` VALUES (1,'WHT','percentage',2.00,'with holding tax',0,'2025-08-19 12:58:57','2025-09-15 10:15:45'),(2,'SST','percentage',2.50,'sales tax',1,'2025-08-19 12:59:10','2025-10-05 17:59:27');

--
-- Table structure for table `variant_attributes`
--

CREATE TABLE `variant_attributes` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attribute_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attribute_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `variant_id` bigint unsigned NOT NULL,
  `attribute_id` bigint unsigned NOT NULL,
  `attribute_value_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `variant_attributes_variant_id_foreign` (`variant_id`),
  KEY `variant_attributes_attribute_id_foreign` (`attribute_id`),
  KEY `variant_attributes_attribute_value_id_foreign` (`attribute_value_id`),
  CONSTRAINT `variant_attributes_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `variant_attributes_attribute_value_id_foreign` FOREIGN KEY (`attribute_value_id`) REFERENCES `attribute_values` (`id`) ON DELETE CASCADE,
  CONSTRAINT `variant_attributes_variant_id_foreign` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variant_attributes`
--

INSERT INTO `variant_attributes` VALUES (1,'Color','Multi-Color',1,1,19,'2025-10-20 09:56:01','2025-10-20 09:56:01'),(2,'Color','Multi-Color',2,1,19,'2025-10-20 13:15:58','2025-10-20 13:15:58'),(3,'Color','Black',3,1,4,'2025-10-20 13:22:35','2025-10-20 13:22:35'),(4,'Color','Multi-Color',4,1,19,'2025-10-21 10:51:48','2025-10-21 10:51:48'),(5,'Color','Multi-Color',5,1,19,'2025-10-21 11:30:03','2025-10-21 11:30:03'),(6,'Color','Black',6,1,4,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(7,'Size','S',6,2,6,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(8,'Color','Black',7,1,4,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(9,'Size','M',7,2,7,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(10,'Color','Black',8,1,4,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(11,'Size','L',8,2,8,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(12,'Color','Black',9,1,4,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(13,'Size','XL',9,2,9,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(14,'Color','Black',10,1,4,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(15,'Size','XXL',10,2,20,'2025-10-21 11:39:29','2025-10-21 11:39:29'),(16,'Color','Multi-Color',11,1,19,'2025-10-21 11:50:44','2025-10-21 11:50:44');

--
-- Table structure for table `wholesaler_profiles`
--

CREATE TABLE `wholesaler_profiles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `store_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_banner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `company_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_ntn` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_settings` json DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '1=active, 0=inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wholesaler_profiles_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wholesaler_profiles`
--

INSERT INTO `wholesaler_profiles` VALUES (1,3,'Armall','armall','Time Motors Ist Floor Opposite New Memon plaza nishter road filimstan karachi','0307-2770257','info@ardropshipping.com',NULL,NULL,'Leading wholesaler in garments and shoes.','https://ardropshipping.com','1234567-1','[{\"shipper_id\": \"6\", \"pickup_address_id\": \"457892\"}, {\"shipper_id\": \"4\", \"pickup_address_id\": \"001\"}]',1,'2025-07-02 12:20:06','2025-09-19 09:07:02');

--
-- Table structure for table `wish_lists`
--

CREATE TABLE `wish_lists` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wish_lists_user_id_foreign` (`user_id`),
  KEY `wish_lists_product_id_foreign` (`product_id`),
  CONSTRAINT `wish_lists_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `wish_lists_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wish_lists`
--

INSERT INTO `wish_lists` VALUES (7,19,7,'2025-10-23 16:11:54','2025-10-23 16:11:54');


