-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathnextshopsphere.sql
More file actions
1873 lines (1774 loc) · 347 KB
/
nextshopsphere.sql
File metadata and controls
1873 lines (1774 loc) · 347 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19-11.7.2-MariaDB, for Win64 (AMD64)
--
-- Host: localhost Database: nextshopsphere
-- ------------------------------------------------------
-- Server version 11.7.2-MariaDB
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*M!100616 SET @OLD_NOTE_VERBOSITY=@@NOTE_VERBOSITY, NOTE_VERBOSITY=0 */;
--
-- Table structure for table `accounts_user`
--
DROP TABLE IF EXISTS `accounts_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`password` varchar(128) NOT NULL,
`last_login` datetime(6) DEFAULT NULL,
`is_superuser` tinyint(1) NOT NULL,
`username` varchar(150) NOT NULL,
`first_name` varchar(150) NOT NULL,
`last_name` varchar(150) NOT NULL,
`is_staff` tinyint(1) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`date_joined` datetime(6) NOT NULL,
`email` varchar(254) NOT NULL,
`phone` varchar(15) DEFAULT NULL,
`address` longtext DEFAULT NULL,
`city` varchar(100) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`avatar` varchar(100) DEFAULT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts_user`
--
LOCK TABLES `accounts_user` WRITE;
/*!40000 ALTER TABLE `accounts_user` DISABLE KEYS */;
INSERT INTO `accounts_user` VALUES
(1,'pbkdf2_sha256$1200000$t6SeAmuQDOi8oZq91JXoKA$QIGEymY6SnYA+bfrKfIHtgujmjrTeOp4p5SQTTIb8Pw=','2025-12-16 13:19:31.359024',1,'nextshop','Next','Shop',1,1,'2025-12-09 15:09:07.781659','nextshop@gmail.com','+23764093413','Bonaberi','Douala','Cameroon','','2025-12-09 15:09:08.854641','2025-12-09 19:46:25.442658'),
(2,'pbkdf2_sha256$1200000$6Ju2Xb7ICVYBU71eZBhXOo$gExzTT1SXNRk+6jKu2AcanDniBQ1ywrV1dMBjGU3Ld8=',NULL,0,'testuser','Test','User',0,1,'2025-12-09 15:26:29.497639','test@example.com',NULL,NULL,NULL,NULL,'','2025-12-09 15:26:30.724479','2025-12-09 15:26:30.724479'),
(3,'!61x6yFdvkfuwyWmTcwCE7uULc2Bl0C10cWv44QSf',NULL,0,'claraberi63','Clara','Beri',0,1,'2025-12-10 18:11:30.145131','claraberi63@gmail.com','+23764093456','Bonaberi','Douala','Cameroon','avatars/project2.JPG','2025-12-10 18:11:30.146164','2025-12-19 12:42:47.302640');
/*!40000 ALTER TABLE `accounts_user` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `accounts_user_groups`
--
DROP TABLE IF EXISTS `accounts_user_groups`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts_user_groups` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`group_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `accounts_user_groups_user_id_group_id_59c0b32f_uniq` (`user_id`,`group_id`),
KEY `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` (`group_id`),
CONSTRAINT `accounts_user_groups_group_id_bd11a704_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
CONSTRAINT `accounts_user_groups_user_id_52b62117_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts_user_groups`
--
LOCK TABLES `accounts_user_groups` WRITE;
/*!40000 ALTER TABLE `accounts_user_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts_user_groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `accounts_user_user_permissions`
--
DROP TABLE IF EXISTS `accounts_user_user_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounts_user_user_permissions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `accounts_user_user_permi_user_id_permission_id_2ab516c2_uniq` (`user_id`,`permission_id`),
KEY `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` (`permission_id`),
CONSTRAINT `accounts_user_user_p_permission_id_113bb443_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
CONSTRAINT `accounts_user_user_p_user_id_e4f0a161_fk_accounts_` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `accounts_user_user_permissions`
--
LOCK TABLES `accounts_user_user_permissions` WRITE;
/*!40000 ALTER TABLE `accounts_user_user_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `accounts_user_user_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `alerts_usernotification`
--
DROP TABLE IF EXISTS `alerts_usernotification`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `alerts_usernotification` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`type` varchar(20) NOT NULL,
`title` varchar(255) NOT NULL,
`message` longtext NOT NULL,
`link` varchar(500) DEFAULT NULL,
`is_read` tinyint(1) NOT NULL,
`created_at` datetime(6) NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `alerts_usernotification_user_id_c89de959_fk_accounts_user_id` (`user_id`),
CONSTRAINT `alerts_usernotification_user_id_c89de959_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `alerts_usernotification`
--
LOCK TABLES `alerts_usernotification` WRITE;
/*!40000 ALTER TABLE `alerts_usernotification` DISABLE KEYS */;
INSERT INTO `alerts_usernotification` VALUES
(1,'promo','christmas discounts','Christmas sales typically run throughout December, with early promotions appearing in late November. Most retailers push their biggest holiday discounts between the second and third weeks of December, especially for gifting categories. When do people start Christmas shopping?',NULL,0,'2025-12-11 03:52:45.567071',1),
(2,'order','🛍️ Order Confirmed!','Your order #123 has been confirmed and is being processed. We will notify you when it ships.','/orders/1',0,'2025-12-11 04:07:05.134756',3),
(3,'payment','💳 Payment Successful!','Your payment of $150.00 was processed successfully. Thank you for your purchase!','/orders/1',0,'2025-12-11 04:07:05.148516',3),
(4,'shipping','📦 Order Shipped!','Great news! Your order is on its way. Track your package to see delivery updates.','/orders/1',0,'2025-12-11 04:07:05.157517',3),
(5,'promo','🎉 50% Off Flash Sale!','Don\'t miss our biggest sale of the year! Use code SAVE50 at checkout. Limited time only!','/products',0,'2025-12-11 04:07:05.170517',3);
/*!40000 ALTER TABLE `alerts_usernotification` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_group`
--
DROP TABLE IF EXISTS `auth_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_group` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group`
--
LOCK TABLES `auth_group` WRITE;
/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_group_permissions`
--
DROP TABLE IF EXISTS `auth_group_permissions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_group_permissions` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`permission_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_group_permissions`
--
LOCK TABLES `auth_group_permissions` WRITE;
/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `auth_permission`
--
DROP TABLE IF EXISTS `auth_permission`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `auth_permission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`content_type_id` int(11) NOT NULL,
`codename` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `auth_permission`
--
LOCK TABLES `auth_permission` WRITE;
/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;
INSERT INTO `auth_permission` VALUES
(1,'Can add log entry',1,'add_logentry'),
(2,'Can change log entry',1,'change_logentry'),
(3,'Can delete log entry',1,'delete_logentry'),
(4,'Can view log entry',1,'view_logentry'),
(5,'Can add permission',3,'add_permission'),
(6,'Can change permission',3,'change_permission'),
(7,'Can delete permission',3,'delete_permission'),
(8,'Can view permission',3,'view_permission'),
(9,'Can add group',2,'add_group'),
(10,'Can change group',2,'change_group'),
(11,'Can delete group',2,'delete_group'),
(12,'Can view group',2,'view_group'),
(13,'Can add content type',4,'add_contenttype'),
(14,'Can change content type',4,'change_contenttype'),
(15,'Can delete content type',4,'delete_contenttype'),
(16,'Can view content type',4,'view_contenttype'),
(17,'Can add session',5,'add_session'),
(18,'Can change session',5,'change_session'),
(19,'Can delete session',5,'delete_session'),
(20,'Can view session',5,'view_session'),
(21,'Can add user',6,'add_user'),
(22,'Can change user',6,'change_user'),
(23,'Can delete user',6,'delete_user'),
(24,'Can view user',6,'view_user'),
(25,'Can add Blacklisted Token',7,'add_blacklistedtoken'),
(26,'Can change Blacklisted Token',7,'change_blacklistedtoken'),
(27,'Can delete Blacklisted Token',7,'delete_blacklistedtoken'),
(28,'Can view Blacklisted Token',7,'view_blacklistedtoken'),
(29,'Can add Outstanding Token',8,'add_outstandingtoken'),
(30,'Can change Outstanding Token',8,'change_outstandingtoken'),
(31,'Can delete Outstanding Token',8,'delete_outstandingtoken'),
(32,'Can view Outstanding Token',8,'view_outstandingtoken'),
(33,'Can add product',10,'add_product'),
(34,'Can change product',10,'change_product'),
(35,'Can delete product',10,'delete_product'),
(36,'Can view product',10,'view_product'),
(37,'Can add category',9,'add_category'),
(38,'Can change category',9,'change_category'),
(39,'Can delete category',9,'delete_category'),
(40,'Can view category',9,'view_category'),
(41,'Can add product image',11,'add_productimage'),
(42,'Can change product image',11,'change_productimage'),
(43,'Can delete product image',11,'delete_productimage'),
(44,'Can view product image',11,'view_productimage'),
(45,'Can add order',12,'add_order'),
(46,'Can change order',12,'change_order'),
(47,'Can delete order',12,'delete_order'),
(48,'Can view order',12,'view_order'),
(49,'Can add order item',13,'add_orderitem'),
(50,'Can change order item',13,'change_orderitem'),
(51,'Can delete order item',13,'delete_orderitem'),
(52,'Can view order item',13,'view_orderitem'),
(53,'Can add review',14,'add_review'),
(54,'Can change review',14,'change_review'),
(55,'Can delete review',14,'delete_review'),
(56,'Can view review',14,'view_review'),
(57,'Can add wishlist item',15,'add_wishlistitem'),
(58,'Can change wishlist item',15,'change_wishlistitem'),
(59,'Can delete wishlist item',15,'delete_wishlistitem'),
(60,'Can view wishlist item',15,'view_wishlistitem'),
(61,'Can add payment',16,'add_payment'),
(62,'Can change payment',16,'change_payment'),
(63,'Can delete payment',16,'delete_payment'),
(64,'Can view payment',16,'view_payment'),
(65,'Can add Notification',17,'add_usernotification'),
(66,'Can change Notification',17,'change_usernotification'),
(67,'Can delete Notification',17,'delete_usernotification'),
(68,'Can view Notification',17,'view_usernotification'),
(69,'Can add brand',18,'add_brand'),
(70,'Can change brand',18,'change_brand'),
(71,'Can delete brand',18,'delete_brand'),
(72,'Can view brand',18,'view_brand'),
(73,'Can add shipping option',20,'add_shippingoption'),
(74,'Can change shipping option',20,'change_shippingoption'),
(75,'Can delete shipping option',20,'delete_shippingoption'),
(76,'Can view shipping option',20,'view_shippingoption'),
(77,'Can add product specification',19,'add_productspecification'),
(78,'Can change product specification',19,'change_productspecification'),
(79,'Can delete product specification',19,'delete_productspecification'),
(80,'Can view product specification',19,'view_productspecification');
/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_admin_log`
--
DROP TABLE IF EXISTS `django_admin_log`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_admin_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`action_time` datetime(6) NOT NULL,
`object_id` longtext DEFAULT NULL,
`object_repr` varchar(200) NOT NULL,
`action_flag` smallint(5) unsigned NOT NULL CHECK (`action_flag` >= 0),
`change_message` longtext NOT NULL,
`content_type_id` int(11) DEFAULT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
KEY `django_admin_log_user_id_c564eba6_fk_accounts_user_id` (`user_id`),
CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
CONSTRAINT `django_admin_log_user_id_c564eba6_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_admin_log`
--
LOCK TABLES `django_admin_log` WRITE;
/*!40000 ALTER TABLE `django_admin_log` DISABLE KEYS */;
INSERT INTO `django_admin_log` VALUES
(1,'2025-12-09 16:31:08.469120','1','caps',1,'[{\"added\": {}}]',9,1),
(2,'2025-12-09 16:31:19.043690','1','Caps',1,'[{\"added\": {}}]',10,1),
(3,'2025-12-09 16:32:07.962669','1','Caps - Image 6',1,'[{\"added\": {}}]',11,1),
(4,'2025-12-09 19:24:44.808446','1','Caps',2,'[{\"changed\": {\"fields\": [\"Featured\"]}}]',10,1),
(5,'2025-12-09 19:30:28.349406','2','Shoes',1,'[{\"added\": {}}]',9,1),
(6,'2025-12-09 19:31:41.123167','2','Shoes',1,'[{\"added\": {}}, {\"added\": {\"name\": \"product image\", \"object\": \"Shoes - Image 0\"}}, {\"added\": {\"name\": \"product image\", \"object\": \"Shoes - Image 0\"}}]',10,1),
(7,'2025-12-09 20:13:55.373619','1','Order #1 - nextshop@gmail.com',1,'[{\"added\": {}}]',12,1),
(8,'2025-12-09 20:24:00.273238','2','Order #2 - nextshop@gmail.com',2,'[{\"changed\": {\"fields\": [\"Status\", \"Notes\"]}}]',12,1),
(9,'2025-12-09 20:31:41.022404','3','Order #3 - nextshop@gmail.com',2,'[]',12,1),
(10,'2025-12-09 20:36:20.743643','3','Cosmetics',1,'[{\"added\": {}}]',9,1),
(11,'2025-12-09 20:36:48.110110','3','Beauty-Kits',1,'[{\"added\": {}}, {\"added\": {\"name\": \"product image\", \"object\": \"Beauty-Kits - Image 0\"}}]',10,1),
(12,'2025-12-09 20:37:20.553267','2','Shoes',2,'[{\"changed\": {\"fields\": [\"Sku\"]}}]',10,1),
(13,'2025-12-09 20:37:37.136948','1','Caps',2,'[{\"changed\": {\"fields\": [\"Sku\"]}}]',10,1),
(14,'2025-12-09 20:55:23.734614','6','Order #6 - nextshop@gmail.com',2,'[{\"changed\": {\"fields\": [\"Status\", \"Payment status\"]}}]',12,1),
(15,'2025-12-09 21:41:08.920891','1','Order #1 - nextshop@gmail.com',3,'',12,1),
(16,'2025-12-09 21:42:32.387435','5','Order #5 - nextshop@gmail.com',3,'',12,1),
(17,'2025-12-09 21:42:32.387435','3','Order #3 - nextshop@gmail.com',3,'',12,1),
(18,'2025-12-09 21:44:56.136261','1','nextshop@gmail.com - Shoes (4Γÿà)',2,'[]',14,1),
(19,'2025-12-09 21:56:22.432355','3','test@example.com - Beauty-Kits',1,'[{\"added\": {}}]',15,1),
(20,'2025-12-11 03:28:20.210107','11','Order #11 - claraberi63@gmail.com',2,'[{\"changed\": {\"fields\": [\"Status\"]}}]',12,1),
(21,'2025-12-11 03:52:45.569071','1','christmas discounts - nextshop@gmail.com',1,'[{\"added\": {}}]',17,1),
(22,'2025-12-11 03:54:42.050495','1','christmas discounts - nextshop@gmail.com',2,'[{\"changed\": {\"fields\": [\"Is read\"]}}]',17,1),
(23,'2025-12-11 04:10:20.789741','6','👋 Welcome to NextShopSphere! - claraberi63@gmail.com',2,'[]',17,1),
(24,'2025-12-11 04:10:43.760216','5','🎉 50% Off Flash Sale! - claraberi63@gmail.com',2,'[]',17,1),
(25,'2025-12-11 04:11:17.504331','3','💳 Payment Successful! - claraberi63@gmail.com',2,'[]',17,1),
(26,'2025-12-14 02:00:12.549516','1','Apple',1,'[{\"added\": {}}]',18,1),
(27,'2025-12-14 02:01:16.694694','2','Orange',1,'[{\"added\": {}}]',18,1),
(28,'2025-12-14 03:47:43.598183','4','Blaze Cannon',1,'[{\"added\": {}}, {\"added\": {\"name\": \"product image\", \"object\": \"Blaze Cannon - Image 84\"}}, {\"added\": {\"name\": \"product specification\", \"object\": \"Blaze Cannon - Fletcher Conrad: Aut occaecat proident voluptatem Dolor sit unde\"}}, {\"added\": {\"name\": \"product specification\", \"object\": \"Blaze Cannon - Daniel Griffith: Molestias quod minus sunt elit quia tenetur voluptas dolorem totam voluptatem dolorum numquam sint fugiat quis\"}}, {\"added\": {\"name\": \"product specification\", \"object\": \"Blaze Cannon - Quintessa Meadows: Totam in in aut omnis id id excepturi\"}}]',10,1),
(29,'2025-12-14 04:39:52.604816','4','Blaze Cannon',2,'[{\"changed\": {\"fields\": [\"Sku\", \"Is available\", \"Category\", \"Brand\"]}}]',10,1),
(30,'2025-12-14 05:04:08.415539','80','UI Design Icon Pack',2,'[{\"changed\": {\"fields\": [\"Brand\"]}}, {\"added\": {\"name\": \"product image\", \"object\": \"UI Design Icon Pack - Image 0\"}}]',10,1),
(31,'2025-12-14 05:06:13.274938','80','UI Design Icon Pack',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"UI Design Icon Pack - Image 0\"}}]',10,1),
(32,'2025-12-16 13:26:00.765459','68','Kids & Toys → Action Figures',3,'',9,1),
(33,'2025-12-16 13:43:07.545741','74','Kids & Toys → Baby Toys',3,'',9,1),
(34,'2025-12-16 13:43:54.247055','42','Home & Living → Bathroom',3,'',9,1),
(35,'2025-12-16 13:44:11.436046','39','Home & Living → Bedding',3,'',9,1),
(36,'2025-12-16 13:55:20.760642','20','Electronics → Tablets',2,'[{\"changed\": {\"fields\": [\"Description\", \"Image\"]}}]',9,1),
(37,'2025-12-16 21:56:34.200903','171','Display Font Bundle - 20 Fonts',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Display Font Bundle - 20 Fonts - Image 0\"}}]',10,1),
(38,'2025-12-16 21:57:18.880790','170','Elegant Script Font Collection',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Elegant Script Font Collection - Image 0\"}}]',10,1),
(39,'2025-12-16 21:57:43.585771','169','Modern Sans Serif Font Family',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Modern Sans Serif Font Family - Image 0\"}}]',10,1),
(40,'2025-12-16 21:58:03.255219','168','Podcast Sound Effects Bundle',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Podcast Sound Effects Bundle - Image 0\"}}]',10,1),
(41,'2025-12-18 00:58:55.488317','17','Electronics',2,'[{\"changed\": {\"fields\": [\"Image\"]}}]',9,1),
(42,'2025-12-18 01:01:04.921362','86','Xbox Series X',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Xbox Series X - Image 0\"}}]',10,1),
(43,'2025-12-18 01:02:09.127619','85','PlayStation 5',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"PlayStation 5 - Image 0\"}}]',10,1),
(44,'2025-12-18 01:03:22.852321','78','Nintendo Switch OLED',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Nintendo Switch OLED - Image 0\"}}]',10,1),
(45,'2025-12-18 01:04:44.435307','52','AirPods Pro (2nd Gen)',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"AirPods Pro (2nd Gen) - Image 0\"}}]',10,1),
(46,'2025-12-18 01:08:56.356828','128','The Pragmatic Programmer',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"The Pragmatic Programmer - Image 0\"}}]',10,1),
(47,'2025-12-18 01:09:12.085205','134','Compression Leggings',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Compression Leggings - Image 0\"}}]',10,1),
(48,'2025-12-18 01:10:15.663955','81','Google Pixel 8 Pro',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Google Pixel 8 Pro - Image 0\"}}]',10,1),
(49,'2025-12-18 01:11:08.978663','55','Apple Watch Series 9',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Apple Watch Series 9 - Image 0\"}}]',10,1),
(50,'2025-12-18 01:15:44.185803','156','Notion Life OS Template',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Notion Life OS Template - Image 0\"}}]',10,1),
(51,'2025-12-18 01:20:20.637792','66','Fenty Beauty Pro Filt\'r Foundation',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Fenty Beauty Pro Filt\'r Foundation - Image 0\"}}]',10,1),
(52,'2025-12-18 01:20:48.549943','155','Social Media Content Calendar Template',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Social Media Content Calendar Template - Image 0\"}}]',10,1),
(53,'2025-12-18 01:21:56.010307','96','Leather Tote Bag',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Leather Tote Bag - Image 0\"}}]',10,1),
(54,'2025-12-18 01:23:32.827230','163','Complete Python Developer Masterclass',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Complete Python Developer Masterclass - Image 0\"}}]',10,1),
(55,'2025-12-18 01:25:49.978410','53','Bose QuietComfort Ultra',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Bose QuietComfort Ultra - Image 0\"}}]',10,1),
(56,'2025-12-18 01:26:44.546305','113','Sauvage Eau de Parfum',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Sauvage Eau de Parfum - Image 0\"}}]',10,1),
(57,'2025-12-19 03:46:05.539959','164','Digital Marketing Complete Course',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Digital Marketing Complete Course - Image 0\"}}]',10,1),
(58,'2025-12-19 03:46:43.942524','165','UI/UX Design Bootcamp',2,'[{\"changed\": {\"fields\": [\"Is bestseller\"]}}]',10,1),
(59,'2025-12-19 03:47:43.365475','162','VideoStudio Pro - Video Editor',2,'[{\"changed\": {\"fields\": [\"Featured\"]}}]',10,1),
(60,'2025-12-19 03:48:13.993739','160','TaskMaster Pro - Project Management Software',2,'[{\"changed\": {\"fields\": [\"Featured\"]}}]',10,1),
(61,'2025-12-19 03:49:31.257894','166','Cinematic Music Pack - Epic Orchestral',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Cinematic Music Pack - Epic Orchestral - Image 0\"}}]',10,1),
(62,'2025-12-19 03:51:14.639976','159','Logo Template Mega Bundle',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Logo Template Mega Bundle - Image 0\"}}]',10,1),
(63,'2025-12-19 03:52:24.884363','159','Logo Template Mega Bundle',2,'[]',10,1),
(64,'2025-12-19 04:09:25.816270','157','Ultimate Icon Bundle - 10,000+ Icons',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Ultimate Icon Bundle - 10,000+ Icons - Image 0\"}}]',10,1),
(65,'2025-12-19 04:11:10.699981','167','Lo-Fi Hip Hop Beat Collection',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Lo-Fi Hip Hop Beat Collection - Image 0\"}}]',10,1),
(66,'2025-12-19 04:13:40.460215','160','TaskMaster Pro - Project Management Software',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"TaskMaster Pro - Project Management Software - Image 0\"}}]',10,1),
(67,'2025-12-19 04:15:15.922919','161','PhotoEdit Suite - Image Editor',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"PhotoEdit Suite - Image Editor - Image 0\"}}]',10,1),
(68,'2025-12-19 04:20:19.095025','166','Cinematic Music Pack - Epic Orchestral',2,'[{\"changed\": {\"name\": \"product image\", \"object\": \"Cinematic Music Pack - Epic Orchestral - Image 0\", \"fields\": [\"Image\"]}}]',10,1),
(69,'2025-12-19 04:21:37.129538','166','Cinematic Music Pack - Epic Orchestral',2,'[]',10,1),
(70,'2025-12-19 04:22:03.592799','158','3D Illustration Pack - Characters',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"3D Illustration Pack - Characters - Image 0\"}}]',10,1),
(71,'2025-12-19 04:24:23.673512','80','UI Design Icon Pack',2,'[{\"changed\": {\"name\": \"product image\", \"object\": \"UI Design Icon Pack - Image 0\", \"fields\": [\"Image\"]}}]',10,1),
(72,'2025-12-19 04:26:28.541688','154','Professional Resume & CV Template Pack',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"Professional Resume & CV Template Pack - Image 0\"}}]',10,1),
(73,'2025-12-19 04:31:23.388059','165','UI/UX Design Bootcamp',2,'[{\"added\": {\"name\": \"product image\", \"object\": \"UI/UX Design Bootcamp - Image 0\"}}]',10,1),
(74,'2025-12-19 13:39:29.093261','16','Order #16 - claraberi63@gmail.com',2,'[{\"changed\": {\"fields\": [\"Status\"]}}]',12,1),
(75,'2025-12-19 13:39:42.328590','17','Order #17 - claraberi63@gmail.com',2,'[{\"changed\": {\"fields\": [\"Status\"]}}]',12,1);
/*!40000 ALTER TABLE `django_admin_log` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_content_type`
--
DROP TABLE IF EXISTS `django_content_type`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_content_type` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`app_label` varchar(100) NOT NULL,
`model` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_content_type`
--
LOCK TABLES `django_content_type` WRITE;
/*!40000 ALTER TABLE `django_content_type` DISABLE KEYS */;
INSERT INTO `django_content_type` VALUES
(6,'accounts','user'),
(1,'admin','logentry'),
(17,'alerts','usernotification'),
(2,'auth','group'),
(3,'auth','permission'),
(4,'contenttypes','contenttype'),
(12,'orders','order'),
(13,'orders','orderitem'),
(16,'payments','payment'),
(18,'products','brand'),
(9,'products','category'),
(10,'products','product'),
(11,'products','productimage'),
(19,'products','productspecification'),
(20,'products','shippingoption'),
(14,'reviews','review'),
(5,'sessions','session'),
(7,'token_blacklist','blacklistedtoken'),
(8,'token_blacklist','outstandingtoken'),
(15,'wishlist','wishlistitem');
/*!40000 ALTER TABLE `django_content_type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_migrations`
--
DROP TABLE IF EXISTS `django_migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_migrations` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`app` varchar(255) NOT NULL,
`name` varchar(255) NOT NULL,
`applied` datetime(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_migrations`
--
LOCK TABLES `django_migrations` WRITE;
/*!40000 ALTER TABLE `django_migrations` DISABLE KEYS */;
INSERT INTO `django_migrations` VALUES
(1,'contenttypes','0001_initial','2025-12-09 15:07:54.567227'),
(2,'contenttypes','0002_remove_content_type_name','2025-12-09 15:07:54.657428'),
(3,'auth','0001_initial','2025-12-09 15:07:54.958420'),
(4,'auth','0002_alter_permission_name_max_length','2025-12-09 15:07:55.065151'),
(5,'auth','0003_alter_user_email_max_length','2025-12-09 15:07:55.072149'),
(6,'auth','0004_alter_user_username_opts','2025-12-09 15:07:55.080185'),
(7,'auth','0005_alter_user_last_login_null','2025-12-09 15:07:55.088150'),
(8,'auth','0006_require_contenttypes_0002','2025-12-09 15:07:55.093150'),
(9,'auth','0007_alter_validators_add_error_messages','2025-12-09 15:07:55.102150'),
(10,'auth','0008_alter_user_username_max_length','2025-12-09 15:07:55.110276'),
(11,'auth','0009_alter_user_last_name_max_length','2025-12-09 15:07:55.118279'),
(12,'auth','0010_alter_group_name_max_length','2025-12-09 15:07:55.154422'),
(13,'auth','0011_update_proxy_permissions','2025-12-09 15:07:55.162423'),
(14,'auth','0012_alter_user_first_name_max_length','2025-12-09 15:07:55.170387'),
(15,'accounts','0001_initial','2025-12-09 15:07:55.539123'),
(16,'admin','0001_initial','2025-12-09 15:07:55.681009'),
(17,'admin','0002_logentry_remove_auto_add','2025-12-09 15:07:55.691011'),
(18,'admin','0003_logentry_add_action_flag_choices','2025-12-09 15:07:55.711047'),
(19,'sessions','0001_initial','2025-12-09 15:07:55.783223'),
(20,'token_blacklist','0001_initial','2025-12-09 15:21:32.905820'),
(21,'token_blacklist','0002_outstandingtoken_jti_hex','2025-12-09 15:21:32.944821'),
(22,'token_blacklist','0003_auto_20171017_2007','2025-12-09 15:21:32.960822'),
(23,'token_blacklist','0004_auto_20171017_2013','2025-12-09 15:21:33.056825'),
(24,'token_blacklist','0005_remove_outstandingtoken_jti','2025-12-09 15:21:33.101491'),
(25,'token_blacklist','0006_auto_20171017_2113','2025-12-09 15:21:33.142491'),
(26,'token_blacklist','0007_auto_20171017_2214','2025-12-09 15:21:35.350097'),
(27,'token_blacklist','0008_migrate_to_bigautofield','2025-12-09 15:21:35.786090'),
(28,'token_blacklist','0010_fix_migrate_to_bigautofield','2025-12-09 15:21:35.800075'),
(29,'token_blacklist','0011_linearizes_history','2025-12-09 15:21:35.805079'),
(30,'token_blacklist','0012_alter_outstandingtoken_user','2025-12-09 15:21:35.815076'),
(31,'token_blacklist','0013_alter_blacklistedtoken_options_and_more','2025-12-09 15:21:35.829076'),
(32,'products','0001_initial','2025-12-09 16:26:45.427979'),
(33,'accounts','0002_alter_user_address_alter_user_avatar_alter_user_city_and_more','2025-12-09 16:38:05.689017'),
(34,'products','0002_alter_category_description_alter_category_image_and_more','2025-12-09 16:38:05.751018'),
(35,'orders','0001_initial','2025-12-09 19:52:26.431058'),
(36,'orders','0002_orderitem_product_image_orderitem_product_slug_and_more','2025-12-09 20:28:33.958077'),
(37,'reviews','0001_initial','2025-12-09 21:10:23.947540'),
(38,'wishlist','0001_initial','2025-12-09 21:10:24.234392'),
(39,'payments','0001_initial','2025-12-09 23:54:35.098201'),
(40,'alerts','0001_initial','2025-12-11 03:14:16.268976'),
(41,'products','0003_brand_shippingoption_alter_category_options_and_more','2025-12-14 01:42:36.122975'),
(42,'products','0004_alter_category_name_alter_category_unique_together','2025-12-14 02:19:07.432299'),
(43,'wishlist','0002_alter_wishlistitem_options','2025-12-16 21:34:19.418170');
/*!40000 ALTER TABLE `django_migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `django_session`
--
DROP TABLE IF EXISTS `django_session`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `django_session` (
`session_key` varchar(40) NOT NULL,
`session_data` longtext NOT NULL,
`expire_date` datetime(6) NOT NULL,
PRIMARY KEY (`session_key`),
KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `django_session`
--
LOCK TABLES `django_session` WRITE;
/*!40000 ALTER TABLE `django_session` DISABLE KEYS */;
INSERT INTO `django_session` VALUES
('f6z12thhyq0qi8v5wk2cvntuptantroy','.eJxVjMEOwiAQRP-FsyEUZOl69N5vILssStXQpLQn47_bJj3obTLvzbxVpHUpcW15jqOoi-rU6bdjSs9cdyAPqvdJp6ku88h6V_RBmx4mya_r4f4dFGplW_fik7jMCahLSD2hCWJtILTIaFxOAgjgmAMGa9AAEZz9bcveEYP6fAHxjDep:1vVUxf:CWVusW9f9H5d_9EEzoUtIkArV1RhvwW6A25mStYwPjo','2025-12-30 13:19:31.366658'),
('lf1b5netwru2y62beihlli41t74u8zfy','.eJxVjMEOwiAQRP-FsyEUZOl69N5vILssStXQpLQn47_bJj3obTLvzbxVpHUpcW15jqOoi-rU6bdjSs9cdyAPqvdJp6ku88h6V_RBmx4mya_r4f4dFGplW_fik7jMCahLSD2hCWJtILTIaFxOAgjgmAMGa9AAEZz9bcveEYP6fAHxjDep:1vSzMH:A71ZBPo6cEF-IZTvw9QDr_Z6FuTYzxgcKpNO6qbDamg','2025-12-23 15:10:33.156247');
/*!40000 ALTER TABLE `django_session` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders_order`
--
DROP TABLE IF EXISTS `orders_order`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`status` varchar(20) NOT NULL,
`payment_status` varchar(20) NOT NULL,
`shipping_address` longtext NOT NULL,
`shipping_city` varchar(100) NOT NULL,
`shipping_country` varchar(100) NOT NULL,
`shipping_phone` varchar(20) NOT NULL,
`subtotal` decimal(10,2) NOT NULL,
`shipping_cost` decimal(10,2) NOT NULL,
`tax` decimal(10,2) NOT NULL,
`total` decimal(10,2) NOT NULL,
`notes` longtext NOT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `orders_order_user_id_e9b59eb1_fk_accounts_user_id` (`user_id`),
CONSTRAINT `orders_order_user_id_e9b59eb1_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders_order`
--
LOCK TABLES `orders_order` WRITE;
/*!40000 ALTER TABLE `orders_order` DISABLE KEYS */;
INSERT INTO `orders_order` VALUES
(2,'shipped','pending','Bonaberi','Douala','Cameroon','+23764093413',45000.00,0.00,4500.00,49500.00,'Ecommerce, short for electronic commerce, is the buying and selling of goods and services over the internet.','2025-12-09 20:20:24.579997','2025-12-09 20:24:00.269923',1),
(4,'pending','pending','Bonaberi','Douala','Cameroon','+23764093413',24000.00,0.00,2400.00,26400.00,'It involves a transaction between two parties, usually a business and a consumer, where the payment and delivery of products or services are conducted online.','2025-12-09 20:39:51.229728','2025-12-09 20:39:51.254406',1),
(6,'delivered','paid','Bonaberi','Douala','Cameroon','+23764093413',24000.00,0.00,2400.00,26400.00,'It involves a transaction between two parties, usually a business and a consumer, where the payment and delivery of products or services are conducted online.','2025-12-09 20:53:14.114861','2025-12-09 20:55:23.731273',1),
(7,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',23000.00,0.00,2300.00,25300.00,'It involves a transaction between two parties, usually a business and a consumer, where the payment and delivery of products or services are conducted online.','2025-12-10 00:04:23.793633','2025-12-10 00:09:48.453351',1),
(8,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',30000.00,0.00,3000.00,33000.00,'It involves a transaction between two parties, usually a business and a consumer, where the payment and delivery of products or services are conducted online.','2025-12-10 13:38:31.503568','2025-12-10 13:41:39.253358',1),
(9,'cancelled','paid','Bonaberi','Douala','Cameroon','+23764093413',500.00,0.00,50.00,550.00,'','2025-12-10 14:02:02.908296','2025-12-10 14:04:01.196454',1),
(10,'pending','pending','Bonaberi','Douala','Cameroon','+23764093413',500.00,0.00,50.00,550.00,'','2025-12-11 01:16:07.287316','2025-12-11 01:16:08.265432',3),
(11,'delivered','paid','Bonaberi','Douala','Cameroon','+23764093413',38500.00,0.00,3850.00,42350.00,'','2025-12-11 03:25:34.874126','2025-12-11 03:28:20.207873',3),
(12,'cancelled','paid','Bonaberi','Douala','Cameroon','+23764093413',15000.00,0.00,1500.00,16500.00,'','2025-12-13 04:41:31.815441','2025-12-13 04:47:51.921899',3),
(13,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',8000.00,0.00,800.00,8800.00,'','2025-12-13 04:48:40.307917','2025-12-13 04:54:06.747922',3),
(14,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',15000.00,0.00,1500.00,16500.00,'','2025-12-13 04:55:18.352037','2025-12-13 04:57:13.365212',3),
(15,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',29.99,5.00,3.00,37.99,'','2025-12-16 13:56:58.189038','2025-12-16 13:58:32.678781',3),
(16,'processing','paid','Bonaberi','Douala','Cameroon','+23764093413',39.99,5.00,4.00,48.99,'','2025-12-17 00:35:47.703462','2025-12-19 13:40:34.668121',3),
(17,'processing','pending','Bonaberi','Douala','Cameroon','+23764093413',39.99,5.00,4.00,48.99,'','2025-12-17 00:45:13.423895','2025-12-19 13:39:42.325131',3),
(18,'cancelled','pending','Bonaberi','Douala','Cameroon','+23764093413',39.99,5.00,4.00,48.99,'','2025-12-17 00:50:09.453586','2025-12-19 13:54:14.476036',3),
(19,'cancelled','paid','Bonaberi','Douala','Cameroon','+23764093456',49.98,5.00,5.00,59.98,'Gain the skills and the hands-on experience you need to become a UX/UI Designer','2025-12-19 04:59:20.691401','2025-12-19 13:25:11.107441',3),
(20,'cancelled','pending','Bonaberi','Douala','Cameroon','+23764093456',19.99,5.00,2.00,26.99,'','2025-12-19 13:26:10.340055','2025-12-19 13:26:31.611931',3);
/*!40000 ALTER TABLE `orders_order` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `orders_orderitem`
--
DROP TABLE IF EXISTS `orders_orderitem`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orders_orderitem` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`product_name` varchar(255) NOT NULL,
`product_price` decimal(10,2) NOT NULL,
`quantity` int(10) unsigned NOT NULL CHECK (`quantity` >= 0),
`created_at` datetime(6) NOT NULL,
`order_id` bigint(20) NOT NULL,
`product_id` bigint(20) DEFAULT NULL,
`product_image` varchar(500) DEFAULT NULL,
`product_slug` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `orders_orderitem_order_id_fe61a34d_fk_orders_order_id` (`order_id`),
KEY `orders_orderitem_product_id_afe4254a_fk_products_product_id` (`product_id`),
CONSTRAINT `orders_orderitem_order_id_fe61a34d_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`),
CONSTRAINT `orders_orderitem_product_id_afe4254a_fk_products_product_id` FOREIGN KEY (`product_id`) REFERENCES `products_product` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `orders_orderitem`
--
LOCK TABLES `orders_orderitem` WRITE;
/*!40000 ALTER TABLE `orders_orderitem` DISABLE KEYS */;
INSERT INTO `orders_orderitem` VALUES
(1,'Shoes',15000.00,3,'2025-12-09 20:20:24.594970',2,NULL,NULL,NULL),
(3,'Beauty-Kits',8000.00,3,'2025-12-09 20:39:51.242429',4,NULL,'/media/products/IMG_9410.JPG','beauty-kits'),
(5,'Beauty-Kits',8000.00,3,'2025-12-09 20:53:14.129247',6,NULL,'/media/products/IMG_9410.JPG','beauty-kits'),
(6,'Shoes',15000.00,1,'2025-12-10 00:04:23.806687',7,NULL,'/media/products/IMG_1703.JPG','foot-wears'),
(7,'Beauty-Kits',8000.00,1,'2025-12-10 00:04:23.827857',7,NULL,'/media/products/IMG_9410.JPG','beauty-kits'),
(8,'Shoes',15000.00,2,'2025-12-10 13:38:31.513598',8,NULL,'/media/products/IMG_1703.JPG','foot-wears'),
(9,'Caps',500.00,1,'2025-12-10 14:02:02.916331',9,NULL,'/media/products/IMG_0131.JPG','caps'),
(10,'Caps',500.00,1,'2025-12-11 01:16:07.677132',10,NULL,'/media/products/IMG_0131.JPG','caps'),
(11,'Shoes',15000.00,2,'2025-12-11 03:25:34.900763',11,NULL,'/media/products/IMG_1703.JPG','foot-wears'),
(12,'Beauty-Kits',8000.00,1,'2025-12-11 03:25:34.940033',11,NULL,'/media/products/IMG_9410.JPG','beauty-kits'),
(13,'Caps',500.00,1,'2025-12-11 03:25:34.972357',11,NULL,'/media/products/IMG_0131.JPG','caps'),
(14,'Shoes',15000.00,1,'2025-12-13 04:41:31.825445',12,NULL,'/media/products/IMG_1703.JPG','foot-wears'),
(15,'Beauty-Kits',8000.00,1,'2025-12-13 04:48:40.317917',13,NULL,'/media/products/IMG_9410.JPG','beauty-kits'),
(16,'Shoes',15000.00,1,'2025-12-13 04:55:18.361034',14,NULL,'/media/products/IMG_1703.JPG','foot-wears'),
(17,'UI Design Icon Pack',29.99,1,'2025-12-16 13:56:58.228818',15,80,'/media/products/IMG_74451.JPG','ui-design-icon-pack'),
(18,'Display Font Bundle - 20 Fonts',39.99,1,'2025-12-17 00:35:47.716783',16,171,'/media/products/The-Big-Bold-Font-Bundle-Cover-min.jpg','display-font-bundle-20-fonts'),
(19,'Display Font Bundle - 20 Fonts',39.99,1,'2025-12-17 00:45:13.435897',17,171,'/media/products/The-Big-Bold-Font-Bundle-Cover-min.jpg','display-font-bundle-20-fonts'),
(20,'Display Font Bundle - 20 Fonts',39.99,1,'2025-12-17 00:50:09.463631',18,171,'/media/products/The-Big-Bold-Font-Bundle-Cover-min.jpg','display-font-bundle-20-fonts'),
(21,'Elegant Script Font Collection',24.99,2,'2025-12-19 04:59:20.717374',19,170,'/media/products/61aptQ-r6EL.jpg','elegant-script-font-collection'),
(22,'Professional Resume & CV Template Pack',19.99,1,'2025-12-19 13:26:10.389925',20,154,'/media/products/b08f05ca44c031a26dcc5ddea5c4ca2444f94d0950e2acb4b70eb984827c2d39.jpg','professional-resume-cv-template-pack');
/*!40000 ALTER TABLE `orders_orderitem` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payments_payment`
--
DROP TABLE IF EXISTS `payments_payment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments_payment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`reference` varchar(100) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`currency` varchar(3) NOT NULL,
`status` varchar(20) NOT NULL,
`card_last_four` varchar(4) DEFAULT NULL,
`card_brand` varchar(20) DEFAULT NULL,
`card_holder_name` varchar(100) DEFAULT NULL,
`error_message` longtext DEFAULT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
`paid_at` datetime(6) DEFAULT NULL,
`order_id` bigint(20) NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `reference` (`reference`),
UNIQUE KEY `order_id` (`order_id`),
KEY `payments_payment_user_id_f9db060a_fk_accounts_user_id` (`user_id`),
CONSTRAINT `payments_payment_order_id_22c479b7_fk_orders_order_id` FOREIGN KEY (`order_id`) REFERENCES `orders_order` (`id`),
CONSTRAINT `payments_payment_user_id_f9db060a_fk_accounts_user_id` FOREIGN KEY (`user_id`) REFERENCES `accounts_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payments_payment`
--
LOCK TABLES `payments_payment` WRITE;
/*!40000 ALTER TABLE `payments_payment` DISABLE KEYS */;
INSERT INTO `payments_payment` VALUES
(1,'PAY-A4E89FFE7C74',25300.00,'USD','successful','5678','American Express','clara',NULL,'2025-12-10 00:09:48.439444','2025-12-10 00:09:48.447726','2025-12-10 00:09:48.446727',7,1),
(2,'PAY-2FEF03D3895F',33000.00,'USD','successful','3444','Visa','nextshop',NULL,'2025-12-10 13:41:39.240253','2025-12-10 13:41:39.248356','2025-12-10 13:41:39.248356',8,1),
(3,'PAY-1122B806356A',550.00,'USD','successful','3344','Visa','Jude',NULL,'2025-12-10 14:02:50.045349','2025-12-10 14:02:50.053396','2025-12-10 14:02:50.053396',9,1),
(4,'PAY-A4BA260F6791',42350.00,'USD','successful','8666','Unknown','john',NULL,'2025-12-11 03:26:26.208964','2025-12-11 03:26:26.222628','2025-12-11 03:26:26.221621',11,3),
(5,'PAY-8783F4225BDF',16500.00,'USD','successful','6632','Visa','clara',NULL,'2025-12-13 04:42:31.428829','2025-12-13 04:42:31.437834','2025-12-13 04:42:31.437834',12,3),
(6,'PAY-839B24FC62A2',8800.00,'USD','successful','4242','Visa','dora',NULL,'2025-12-13 04:54:06.736709','2025-12-13 04:54:06.743001','2025-12-13 04:54:06.742401',13,3),
(7,'PAY-E96BA6CEFE44',16500.00,'USD','successful','4444','Mastercard','claud',NULL,'2025-12-13 04:57:13.347542','2025-12-13 04:57:13.359497','2025-12-13 04:57:13.359497',14,3),
(8,'PAY-5808659E06AC',37.99,'USD','successful','4444','Visa','bb',NULL,'2025-12-16 13:58:32.663808','2025-12-16 13:58:32.674690','2025-12-16 13:58:32.673641',15,3),
(9,'PAY-C91AA5A2CC95',59.98,'USD','successful','4444','Visa','Fanny',NULL,'2025-12-19 05:00:23.653793','2025-12-19 05:00:23.672130','2025-12-19 05:00:23.671906',19,3),
(10,'PAY-94B1F377C8D9',48.99,'USD','successful','7777','Unknown','judth',NULL,'2025-12-19 13:40:34.643039','2025-12-19 13:40:34.655832','2025-12-19 13:40:34.655832',16,3);
/*!40000 ALTER TABLE `payments_payment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products_brand`
--
DROP TABLE IF EXISTS `products_brand`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products_brand` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`slug` varchar(100) NOT NULL,
`logo` varchar(100) DEFAULT NULL,
`description` longtext NOT NULL,
`website` varchar(200) NOT NULL,
`is_active` tinyint(1) NOT NULL,
`is_featured` tinyint(1) NOT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products_brand`
--
LOCK TABLES `products_brand` WRITE;
/*!40000 ALTER TABLE `products_brand` DISABLE KEYS */;
INSERT INTO `products_brand` VALUES
(3,'Apple','apple','','Think Different','',1,1,'2025-12-14 02:19:15.154739','2025-12-16 21:39:54.032081'),
(4,'Samsung','samsung','','Do What You Can\'t','',1,1,'2025-12-14 02:19:15.154739','2025-12-16 21:39:54.038576'),
(5,'Sony','sony','','Be Moved','',1,1,'2025-12-14 02:19:15.172649','2025-12-16 21:39:54.045255'),
(6,'LG','lg','','Life\'s Good','',1,0,'2025-12-14 02:19:15.175643','2025-12-16 21:39:54.050698'),
(7,'Lenovo','lenovo','','Different is Better','',1,0,'2025-12-14 02:19:15.178654','2025-12-16 21:39:54.056410'),
(8,'Dell','dell','','The Power To Do More','',1,0,'2025-12-14 02:19:15.181692','2025-12-16 21:39:54.061831'),
(9,'HP','hp','','Keep Reinventing','',1,0,'2025-12-14 02:19:15.184696','2025-12-16 21:39:54.067158'),
(10,'Bose','bose','','Better Sound Through Research','',1,1,'2025-12-14 02:19:15.188694','2025-12-16 21:39:54.073269'),
(11,'Nike','nike','','Just Do It','',1,1,'2025-12-14 02:19:15.191690','2025-12-16 21:39:54.078650'),
(12,'Adidas','adidas','','Impossible Is Nothing','',1,1,'2025-12-14 02:19:15.194650','2025-12-16 21:39:54.083784'),
(13,'Zara','zara','','Love your curves','',1,1,'2025-12-14 02:19:15.198649','2025-12-16 21:39:54.089222'),
(14,'H&M','hm','','Fashion and quality at the best price','',1,0,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.093653'),
(15,'Gucci','gucci','','Quality is remembered long after price is forgotten','',1,1,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.096815'),
(16,'Louis Vuitton','louis-vuitton','','The art of travel','',1,1,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.101407'),
(17,'Dior','dior','','Perfection in every detail','',1,1,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.107547'),
(18,'Fenty Beauty','fenty-beauty','','Beauty for all','',1,1,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.112007'),
(19,'CeraVe','cerave','','Developed with dermatologists','',1,0,'2025-12-14 02:19:15.201692','2025-12-16 21:39:54.117111'),
(20,'L\'Oreal','loreal','','Because you\'re worth it','',1,1,'2025-12-14 02:19:15.217319','2025-12-16 21:39:54.122370'),
(21,'Puma','puma','','Forever Faster','',1,0,'2025-12-14 02:19:15.217319','2025-12-16 21:39:54.126262'),
(22,'Under Armour','under-armour','','I Will','',1,0,'2025-12-14 02:19:15.217319','2025-12-16 21:39:54.130703'),
(23,'Fitbit','fitbit','','Find your fit','',1,0,'2025-12-14 02:19:15.217319','2025-12-16 21:39:54.136937'),
(24,'IKEA','ikea','','The wonderful everyday','',1,1,'2025-12-14 02:19:15.232944','2025-12-16 21:39:54.142431'),
(25,'Philips','philips','','Innovation and You','',1,0,'2025-12-14 02:19:15.232944','2025-12-16 21:39:54.146439'),
(26,'Google','google','','','',1,0,'2025-12-16 21:40:10.367120','2025-12-16 21:40:10.367120'),
(27,'OnePlus','oneplus','','','',1,0,'2025-12-16 21:40:10.384851','2025-12-16 21:40:10.384851'),
(28,'ASUS','asus','','','',1,0,'2025-12-16 21:40:10.419823','2025-12-16 21:40:10.419823'),
(29,'Microsoft','microsoft','','','',1,0,'2025-12-16 21:40:10.502593','2025-12-16 21:40:10.502593'),
(30,'Nintendo','nintendo','','','',1,0,'2025-12-16 21:40:10.517143','2025-12-16 21:40:10.517143'),
(31,'LEGO','lego','','','',1,0,'2025-12-16 21:40:11.284197','2025-12-16 21:40:11.284197');
/*!40000 ALTER TABLE `products_brand` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products_category`
--
DROP TABLE IF EXISTS `products_category`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products_category` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`slug` varchar(100) NOT NULL,
`description` longtext NOT NULL,
`image` varchar(100) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
`parent_id` bigint(20) DEFAULT NULL,
`display_order` int(10) unsigned NOT NULL CHECK (`display_order` >= 0),
`featured` tinyint(1) NOT NULL,
`icon` varchar(50) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`),
UNIQUE KEY `products_category_name_parent_id_6f135aaf_uniq` (`name`,`parent_id`),
KEY `products_category_parent_id_3388f6c9_fk_products_category_id` (`parent_id`),
CONSTRAINT `products_category_parent_id_3388f6c9_fk_products_category_id` FOREIGN KEY (`parent_id`) REFERENCES `products_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products_category`
--
LOCK TABLES `products_category` WRITE;
/*!40000 ALTER TABLE `products_category` DISABLE KEYS */;
INSERT INTO `products_category` VALUES
(17,'Electronics','electronics','Phones, laptops, accessories, gaming, and gadgets','categories/images_1.jpeg',1,'2025-12-14 02:19:14.937325','2025-12-18 00:58:55.485719',NULL,1,1,'laptop'),
(18,'Smartphones','smartphones','','',1,'2025-12-14 02:19:14.952985','2025-12-16 21:39:53.627010',17,0,0,'laptop'),
(19,'Laptops & Computers','laptops-computers','','',1,'2025-12-14 02:19:14.952985','2025-12-16 21:39:53.632318',17,0,0,'laptop'),
(20,'Tablets','tablets','','categories/IMG_0131_uwbIAF0.JPG',1,'2025-12-14 02:19:14.952985','2025-12-16 21:39:53.639672',17,0,0,'laptop'),
(21,'Headphones & Audio','headphones-audio','','',1,'2025-12-14 02:19:14.952985','2025-12-16 21:39:53.646096',17,0,0,'laptop'),
(22,'Smart Watches','smart-watches','','',1,'2025-12-14 02:19:14.952985','2025-12-16 21:39:53.654369',17,0,0,'laptop'),
(23,'Cameras','cameras','','',1,'2025-12-14 02:19:14.968717','2025-12-16 21:39:53.659726',17,0,0,'laptop'),
(24,'Gaming','gaming','','',1,'2025-12-14 02:19:14.971750','2025-12-16 21:39:53.665320',17,0,0,'laptop'),
(25,'Electronics Accessories','electronics-accessories','','',1,'2025-12-14 02:19:14.973750','2025-12-16 21:39:53.672672',17,0,0,'laptop'),
(26,'Fashion','fashion','Men, women, shoes, bags, clothes, and accessories','',1,'2025-12-14 02:19:14.976753','2025-12-16 21:39:53.678286',NULL,2,1,'shirt'),
(27,'Men\'s Clothing','mens-clothing','','',1,'2025-12-14 02:19:14.979752','2025-12-16 21:39:53.683426',26,0,0,'shirt'),
(28,'Women\'s Clothing','womens-clothing','','',1,'2025-12-14 02:19:14.982750','2025-12-16 21:39:53.689069',26,0,0,'shirt'),
(29,'Footwear','footwear','','',1,'2025-12-14 02:19:14.982862','2025-12-16 21:39:53.696317',26,0,0,'shirt'),
(30,'Bags & Luggage','bags-luggage','','',1,'2025-12-14 02:19:14.982862','2025-12-16 21:39:53.701930',26,0,0,'shirt'),
(31,'Watches','fashion-watches','','',1,'2025-12-14 02:19:14.982862','2025-12-16 21:39:53.709212',26,0,0,'shirt'),
(32,'Jewelry','jewelry','','',1,'2025-12-14 02:19:14.982862','2025-12-16 21:39:53.714919',26,0,0,'shirt'),
(33,'Sunglasses','sunglasses','','',1,'2025-12-14 02:19:14.982862','2025-12-16 21:39:53.722004',26,0,0,'shirt'),
(34,'Fashion Accessories','fashion-accessories','','',1,'2025-12-14 02:19:14.998524','2025-12-16 21:39:53.728133',26,0,0,'shirt'),
(35,'Home & Living','home-living','Furniture, lamps, kitchen tools, and organizing supplies','',1,'2025-12-14 02:19:14.998524','2025-12-16 21:39:53.733624',NULL,3,1,'home'),
(36,'Furniture','furniture','','',1,'2025-12-14 02:19:14.998524','2025-12-16 21:39:53.740495',35,0,0,'home'),
(37,'Lighting','lighting','','',1,'2025-12-14 02:19:14.998524','2025-12-16 21:39:53.746781',35,0,0,'home'),
(38,'Kitchen & Dining','kitchen-dining','','',1,'2025-12-14 02:19:14.998524','2025-12-16 21:39:53.753059',35,0,0,'home'),
(40,'Home Decor','home-decor','','',1,'2025-12-14 02:19:15.014153','2025-12-16 21:39:53.765117',35,0,0,'home'),
(41,'Storage & Organization','storage-organization','','',1,'2025-12-14 02:19:15.014153','2025-12-16 21:39:53.771392',35,0,0,'home'),
(43,'Beauty & Skincare','beauty-skincare','Makeup, skincare, hair care, and perfumes','',1,'2025-12-14 02:19:15.014153','2025-12-16 21:39:53.783052',NULL,4,1,'sparkles'),
(44,'Skincare','skincare','','',1,'2025-12-14 02:19:15.029739','2025-12-16 21:39:53.789470',43,0,0,'sparkles'),
(45,'Makeup','makeup','','',1,'2025-12-14 02:19:15.029739','2025-12-16 21:39:53.795452',43,0,0,'sparkles'),
(46,'Hair Care','hair-care','','',1,'2025-12-14 02:19:15.029739','2025-12-16 21:39:53.801227',43,0,0,'sparkles'),
(47,'Fragrances','fragrances','','',1,'2025-12-14 02:19:15.029739','2025-12-16 21:39:53.807699',43,0,0,'sparkles'),
(48,'Bath & Body','bath-body','','',1,'2025-12-14 02:19:15.029739','2025-12-16 21:39:53.813821',43,0,0,'sparkles'),
(49,'Nail Care','nail-care','','',1,'2025-12-14 02:19:15.045365','2025-12-16 21:39:53.820181',43,0,0,'sparkles'),
(50,'Men\'s Grooming','mens-grooming','','',1,'2025-12-14 02:19:15.045365','2025-12-16 21:39:53.826515',43,0,0,'sparkles'),
(51,'Books & Education','books-education','Novels, textbooks, and self-help books','',1,'2025-12-14 02:19:15.045365','2025-12-16 21:39:53.832248',NULL,5,1,'book-open'),
(52,'Fiction','fiction','','',1,'2025-12-14 02:19:15.045365','2025-12-16 21:39:53.838529',51,0,0,'book-open'),
(53,'Non-Fiction','non-fiction','','',1,'2025-12-14 02:19:15.060989','2025-12-16 21:39:53.844334',51,0,0,'book-open'),
(54,'Self-Help','self-help','','',1,'2025-12-14 02:19:15.060989','2025-12-16 21:39:53.852568',51,0,0,'book-open'),
(55,'Business & Finance','business-finance','','',1,'2025-12-14 02:19:15.060989','2025-12-16 21:39:53.858482',51,0,0,'book-open'),
(56,'Technology Books','technology-books','','',1,'2025-12-14 02:19:15.060989','2025-12-16 21:39:53.864031',51,0,0,'book-open'),
(57,'Children\'s Books','childrens-books','','',1,'2025-12-14 02:19:15.060989','2025-12-16 21:39:53.869625',51,0,0,'book-open'),
(58,'Textbooks','textbooks','','',1,'2025-12-14 02:19:15.076614','2025-12-16 21:39:53.875983',51,0,0,'book-open'),
(59,'Sports & Fitness','sports-fitness','Gym equipment, sportswear, and fitness accessories','',1,'2025-12-14 02:19:15.076614','2025-12-16 21:39:53.881813',NULL,6,1,'fire'),
(60,'Exercise Equipment','exercise-equipment','','',1,'2025-12-14 02:19:15.076614','2025-12-16 21:39:53.887794',59,0,0,'fire'),
(61,'Sportswear','sportswear','','',1,'2025-12-14 02:19:15.076614','2025-12-16 21:39:53.892888',59,0,0,'fire'),
(62,'Yoga & Pilates','yoga-pilates','','',1,'2025-12-14 02:19:15.092239','2025-12-16 21:39:53.899768',59,0,0,'fire'),
(63,'Outdoor Sports','outdoor-sports','','',1,'2025-12-14 02:19:15.092239','2025-12-16 21:39:53.905521',59,0,0,'fire'),
(64,'Fitness Accessories','fitness-accessories','','',1,'2025-12-14 02:19:15.092239','2025-12-16 21:39:53.911457',59,0,0,'fire'),
(65,'Supplements','supplements','','',1,'2025-12-14 02:19:15.092239','2025-12-16 21:39:53.917232',59,0,0,'fire'),
(66,'Smart Fitness','smart-fitness','','',1,'2025-12-14 02:19:15.092239','2025-12-16 21:39:53.923376',59,0,0,'fire'),
(67,'Kids & Toys','kids-toys','Toys, games, and kids accessories','',1,'2025-12-14 02:19:15.107864','2025-12-16 21:39:53.928962',NULL,7,1,'puzzle'),
(69,'Dolls & Playsets','dolls-playsets','','',1,'2025-12-14 02:19:15.107864','2025-12-16 21:39:53.942116',67,0,0,'puzzle'),
(70,'Building Blocks','building-blocks','','',1,'2025-12-14 02:19:15.107864','2025-12-16 21:39:53.947868',67,0,0,'puzzle'),
(71,'Educational Toys','educational-toys','','',1,'2025-12-14 02:19:15.107864','2025-12-16 21:39:53.953246',67,0,0,'puzzle'),
(72,'Outdoor Play','outdoor-play','','',1,'2025-12-14 02:19:15.123489','2025-12-16 21:39:53.958773',67,0,0,'puzzle'),
(73,'Board Games','board-games','','',1,'2025-12-14 02:19:15.123489','2025-12-16 21:39:53.965635',67,0,0,'puzzle'),
(75,'Digital Products','digital-products','Ebooks, templates, icons, and software','',1,'2025-12-14 02:19:15.123489','2025-12-16 21:39:53.979039',NULL,8,1,'cloud-download'),
(76,'Ebooks','ebooks','','',1,'2025-12-14 02:19:15.139113','2025-12-16 21:39:53.985706',75,0,0,'cloud-download'),
(77,'Templates','templates','','',1,'2025-12-14 02:19:15.139113','2025-12-16 21:39:53.992195',75,0,0,'cloud-download'),
(78,'Graphics & Icons','graphics-icons','','',1,'2025-12-14 02:19:15.139113','2025-12-16 21:39:53.997801',75,0,0,'cloud-download'),
(79,'Software','software','','',1,'2025-12-14 02:19:15.139113','2025-12-16 21:39:54.003878',75,0,0,'cloud-download'),
(80,'Online Courses','online-courses','','',1,'2025-12-14 02:19:15.139113','2025-12-16 21:39:54.010408',75,0,0,'cloud-download'),
(81,'Music & Audio','music-audio','','',1,'2025-12-14 02:19:15.154739','2025-12-16 21:39:54.016171',75,0,0,'cloud-download'),
(82,'Fonts','fonts','','',1,'2025-12-14 02:19:15.154739','2025-12-16 21:39:54.021755',75,0,0,'cloud-download'),
(83,'Bedding','bedding','','',1,'2025-12-16 21:39:53.759406','2025-12-16 21:39:53.759406',35,0,0,'home'),
(84,'Bathroom','bathroom','','',1,'2025-12-16 21:39:53.777551','2025-12-16 21:39:53.777551',35,0,0,'home'),
(85,'Action Figures','action-figures','','',1,'2025-12-16 21:39:53.935954','2025-12-16 21:39:53.935954',67,0,0,'puzzle'),
(86,'Baby Toys','baby-toys','','',1,'2025-12-16 21:39:53.971635','2025-12-16 21:39:53.971635',67,0,0,'puzzle');
/*!40000 ALTER TABLE `products_category` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `products_product`
--
DROP TABLE IF EXISTS `products_product`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products_product` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`slug` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`short_description` varchar(500) NOT NULL,
`price` decimal(10,2) NOT NULL,
`compare_price` decimal(10,2) DEFAULT NULL,
`sku` varchar(100) NOT NULL,
`stock` int(10) unsigned NOT NULL CHECK (`stock` >= 0),
`is_available` tinyint(1) NOT NULL,
`featured` tinyint(1) NOT NULL,
`created_at` datetime(6) NOT NULL,
`updated_at` datetime(6) NOT NULL,
`category_id` bigint(20) DEFAULT NULL,
`dimensions` varchar(100) NOT NULL,
`is_bestseller` tinyint(1) NOT NULL,
`is_new` tinyint(1) NOT NULL,
`low_stock_threshold` int(10) unsigned NOT NULL CHECK (`low_stock_threshold` >= 0),
`meta_description` varchar(500) NOT NULL,
`meta_title` varchar(255) NOT NULL,
`product_type` varchar(20) NOT NULL,
`weight` decimal(6,2) DEFAULT NULL,
`brand_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `slug` (`slug`),
UNIQUE KEY `sku` (`sku`),
KEY `products_product_category_id_9b594869_fk_products_category_id` (`category_id`),
KEY `products_product_brand_id_3e2e8fd1_fk_products_brand_id` (`brand_id`),
CONSTRAINT `products_product_brand_id_3e2e8fd1_fk_products_brand_id` FOREIGN KEY (`brand_id`) REFERENCES `products_brand` (`id`),
CONSTRAINT `products_product_category_id_9b594869_fk_products_category_id` FOREIGN KEY (`category_id`) REFERENCES `products_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `products_product`
--
LOCK TABLES `products_product` WRITE;
/*!40000 ALTER TABLE `products_product` DISABLE KEYS */;
INSERT INTO `products_product` VALUES
(43,'iPhone 15 Pro Max','iphone-15-pro-max','Experience the pinnacle of smartphone technology with the iPhone 15 Pro Max. Featuring the groundbreaking A17 Pro chip, a stunning 6.7-inch Super Retina XDR display, and an advanced camera system with 5x optical zoom.','The most powerful iPhone ever with A17 Pro chip.',1199.99,1299.99,'SMA-IPHONE-15-PRO-MAX-9084',10,1,1,'2025-12-14 04:50:49.320215','2025-12-16 21:40:10.350616',18,'',1,0,5,'','','physical',0.22,3),
(44,'iPhone 15','iphone-15','The iPhone 15 brings Dynamic Island and a 48MP camera to the standard model.\n \nFeatures:\nΓÇó A16 Bionic chip\nΓÇó 6.1-inch Super Retina XDR display\nΓÇó Dynamic Island\nΓÇó 48MP main camera\nΓÇó USB-C connectivity\nΓÇó Ceramic Shield front\nΓÇó Available in 5 stunning colors','Dynamic Island, 48MP camera, and USB-C in a stunning design.',799.99,899.99,'IPHONE-15-128',75,1,1,'2025-12-14 04:50:49.372550','2025-12-14 04:58:24.290394',18,'',0,1,5,'','','physical',NULL,3),
(45,'Samsung Galaxy S24 Ultra','samsung-galaxy-s24-ultra','The Samsung Galaxy S24 Ultra sets a new standard with its integrated S Pen, 200MP camera, and Galaxy AI features. Titanium design meets powerful performance.','Ultimate Galaxy experience with S Pen and AI features.',1299.99,1399.99,'SMA-SAMSUNG-GALAXY-S24-U-1857',28,1,1,'2025-12-14 04:50:49.397838','2025-12-16 21:40:10.360109',18,'',1,0,5,'','','physical',0.23,4),
(46,'Samsung Galaxy S24','samsung-galaxy-s24','The Galaxy S24 brings flagship features in a compact form factor.','Compact flagship with Galaxy AI and stunning display.',799.99,849.99,'SAMSUNG-S24-128',60,1,0,'2025-12-14 04:50:49.426354','2025-12-14 04:58:24.309744',18,'',0,1,5,'','','physical',NULL,4),
(47,'MacBook Pro 16\" M3 Max','macbook-pro-16-m3-max','Supercharged by M3 Max, MacBook Pro delivers exceptional performance for demanding workflows. Up to 22 hours of battery life.','The most powerful MacBook Pro ever made.',3499.00,3699.00,'LAP-MACBOOK-PRO-16-M3-MA-1264',55,1,1,'2025-12-14 04:50:49.449424','2025-12-16 21:40:10.405599',19,'',1,1,5,'','','physical',2.14,3),
(48,'MacBook Air 15\" M3','macbook-air-15-m3','The 15-inch MacBook Air with M3 delivers incredible performance in an impossibly thin design.','Impossibly thin, incredibly capable with the M3 chip.',1299.99,1399.99,'MBA-15-M3-8-256',45,1,1,'2025-12-14 04:50:49.478880','2025-12-14 04:58:24.328336',19,'',1,1,5,'','','physical',NULL,3),
(49,'Dell XPS 15','dell-xps-15','The Dell XPS 15 combines power and portability with a beautiful 15.6-inch OLED display and latest Intel processors.','Premium Windows laptop with stunning display.',1799.99,NULL,'LAP-DELL-XPS-15-7638',72,1,1,'2025-12-14 04:50:49.502602','2025-12-16 21:40:10.414873',19,'',0,1,5,'','','physical',1.86,8),
(50,'Lenovo ThinkPad X1 Carbon','lenovo-thinkpad-x1-carbon','The ThinkPad X1 Carbon continues the legacy of the ultimate business laptop.','Legendary business laptop, now lighter than ever.',1649.99,NULL,'LENOVO-X1C-I7-16-512',25,1,0,'2025-12-14 04:50:49.526812','2025-12-14 04:58:24.350043',19,'',0,0,5,'','','physical',NULL,7),
(51,'Sony WH-1000XM5','sony-wh-1000xm5','The Sony WH-1000XM5 offers best-in-class noise cancellation, exceptional sound quality, and up to 30 hours of battery life.','Industry-leading noise cancellation.',349.99,399.99,'HEA-SONY-WH-1000XM5-3699',36,1,1,'2025-12-14 04:50:49.553836','2025-12-16 21:40:10.440444',21,'',1,0,5,'','','physical',0.25,5),
(52,'AirPods Pro (2nd Gen)','airpods-pro-2nd-gen','AirPods Pro feature up to 2x more Active Noise Cancellation and Adaptive Audio.','Rebuilt from the sound up with H2 chip and USB-C.',249.99,NULL,'AIRPODS-PRO-2-USBC',100,1,1,'2025-12-14 04:50:49.574125','2025-12-18 01:04:44.431304',21,'',1,1,5,'','','physical',NULL,3),
(53,'Bose QuietComfort Ultra','bose-quietcomfort-ultra','Experience Bose Immersive Audio and world-class noise cancellation in a comfortable, premium design.','World-class noise cancellation meets immersive audio.',429.00,NULL,'HEA-BOSE-QUIETCOMFORT-UL-5060',19,1,1,'2025-12-14 04:50:49.590210','2025-12-18 01:25:49.974408',21,'',0,0,5,'','','physical',0.25,10),
(54,'Apple Watch Ultra 2','apple-watch-ultra-2','Built for endurance athletes, outdoor adventurers, and ocean explorers. Features the brightest Apple display ever.','The most rugged and capable Apple Watch.',799.00,NULL,'SMA-APPLE-WATCH-ULTRA-2-1649',69,1,1,'2025-12-14 04:50:49.604040','2025-12-16 21:40:10.472567',22,'',1,1,5,'','','physical',0.06,3),
(55,'Apple Watch Series 9','apple-watch-series-9','Apple Watch Series 9 with the powerful S9 chip and Double Tap gesture.','Smarter. Brighter. Mightier.',399.99,429.99,'WATCH-S9-45-GPS',55,1,1,'2025-12-14 04:50:49.619714','2025-12-18 01:11:08.975248',22,'',1,1,5,'','','physical',NULL,3),
(56,'Samsung Galaxy Watch 6 Classic','samsung-galaxy-watch-6-classic','The Galaxy Watch 6 Classic brings back the beloved rotating bezel with advanced health monitoring features.','Premium smartwatch with rotating bezel.',429.99,NULL,'SMA-SAMSUNG-GALAXY-WATCH-8914',47,1,0,'2025-12-14 04:50:49.633315','2025-12-16 21:40:10.479659',22,'',0,0,5,'','','physical',0.50,4),
(57,'Nike Air Max 270','nike-air-max-270','The Nike Air Max 270 delivers visible cushioning under every step.\n \nΓÇó Large Max Air unit in the heel for incredible cushioning\nΓÇó Breathable mesh upper\nΓÇó Foam midsole for lightweight comfort\nΓÇó Rubber outsole for traction\nΓÇó Pull tab on heel for easy on and off','Iconic style meets all-day comfort with the largest Air unit yet.',159.99,179.99,'NIKE-AM270-BLK-10',120,1,1,'2025-12-14 04:50:49.647857','2025-12-14 04:58:24.423340',29,'',1,0,5,'','','physical',NULL,11),
(58,'Nike Air Jordan 1 Retro High OG','nike-air-jordan-1-retro-high','The Air Jordan 1 Retro High OG is a legend in sneaker culture.','The shoe that started it all. Timeless style since 1985.',179.99,NULL,'NIKE-AJ1-CHI-10',45,1,1,'2025-12-14 04:50:49.664957','2025-12-14 04:58:24.434043',29,'',1,1,5,'','','physical',NULL,11),
(59,'Adidas Ultraboost 23','adidas-ultraboost-23','The Ultraboost 23 features Light BOOST for a smooth, energized ride.','Incredible energy return with every stride.',189.99,199.99,'ADIDAS-UB23-BLK-10',85,1,1,'2025-12-14 04:50:49.682073','2025-12-14 04:58:24.445171',29,'',0,1,5,'','','physical',NULL,12),
(60,'Adidas Stan Smith','adidas-stan-smith','Clean, simple, and unmistakably Stan Smith.','The tennis icon that became a style staple.',99.99,119.99,'ADIDAS-STAN-WHT-10',150,1,0,'2025-12-14 04:50:49.700247','2025-12-14 04:58:24.456105',29,'',1,0,5,'','','physical',NULL,12),
(61,'Louis Vuitton Neverfull MM','louis-vuitton-neverfull-mm','The Neverfull MM is a timeless Louis Vuitton classic.','The iconic tote that never goes out of style.',1960.00,NULL,'LV-NEVERFULL-MM-MON',15,1,1,'2025-12-14 04:50:49.717649','2025-12-14 04:58:24.466798',30,'',1,0,5,'','','physical',NULL,16),
(62,'Gucci GG Marmont Bag','gucci-gg-marmont-bag','The GG Marmont is a modern Gucci icon with the double G hardware.','Matelassé leather with the iconic GG hardware.',2350.00,NULL,'GUCCI-MARMONT-BLK',10,1,1,'2025-12-14 04:50:49.737951','2025-12-14 04:58:24.476854',30,'',0,1,5,'','','physical',NULL,15),
(63,'Zara Oversized Blazer','zara-oversized-blazer','A versatile oversized blazer that elevates any outfit.','Effortlessly chic oversized blazer for any occasion.',119.99,149.99,'ZARA-BLAZER-BLK-M',70,1,0,'2025-12-14 04:50:49.757484','2025-12-14 04:58:24.488592',28,'',0,1,5,'','','physical',NULL,13),
(64,'Nike Dri-FIT Running Shirt','nike-dri-fit-running-shirt','Nike Dri-FIT technology wicks sweat away from your body.','Stay dry and comfortable during your run.',39.99,49.99,'NIKE-DRIFIT-BLK-L',200,1,0,'2025-12-14 04:50:49.777514','2025-12-14 04:58:24.501346',27,'',1,0,5,'','','physical',NULL,11),
(65,'Dior Sauvage Eau de Parfum','dior-sauvage-edp','Sauvage Eau de Parfum is both powerful and noble, with fresh and woody notes.\n \nTop notes: Calabrian bergamot\nHeart notes: Sichuan pepper, lavender, pink pepper, vetiver, geranium, elemi, patchouli\nBase notes: Ambroxan, cedar, labdanum','Wild and noble, a powerful fresh fragrance.',134.99,155.00,'DIOR-SAUVAGE-EDP-100',60,1,1,'2025-12-14 04:50:49.797690','2025-12-14 04:58:24.512488',47,'',1,0,5,'','','physical',NULL,17),
(66,'Fenty Beauty Pro Filt\'r Foundation','fenty-beauty-pro-filtr-foundation','The revolutionary foundation that started a beauty movement.','50 shades of soft matte, longwear foundation.',39.99,NULL,'FENTY-FOUNDATION-240',90,1,1,'2025-12-14 04:50:49.816868','2025-12-18 01:20:20.632790',45,'',1,0,5,'','','physical',NULL,18),
(67,'CeraVe Moisturizing Cream','cerave-moisturizing-cream','CeraVe Moisturizing Cream with 3 essential ceramides and hyaluronic acid.','Developed with dermatologists for dry to very dry skin.',18.99,21.99,'CERAVE-CREAM-453G',150,1,0,'2025-12-14 04:50:49.849538','2025-12-14 04:58:24.539084',44,'',1,0,5,'','','physical',NULL,19),
(68,'L\'Oreal Paris Revitalift Serum','loreal-revitalift-serum','Visibly replumps skin and reduces wrinkles in just 1 week.','Pure Hyaluronic Acid serum for plumper, hydrated skin.',29.99,34.99,'LOREAL-REVITALIFT-30ML',80,1,0,'2025-12-14 04:50:49.869958','2025-12-14 04:58:24.552980',44,'',0,1,5,'','','physical',NULL,20),
(69,'IKEA MALM Bed Frame','ikea-malm-bed-frame','The MALM bed frame offers a clean look that fits anywhere.','Clean design with storage boxes available.',279.99,329.99,'IKEA-MALM-QUEEN-WHT',25,1,1,'2025-12-14 04:50:49.886596','2025-12-14 04:58:24.566143',36,'',1,0,5,'','','physical',NULL,24),
(70,'Philips Hue White Ambiance Starter Kit','philips-hue-starter-kit','Control your lights with your voice or the Hue app.','Smart lighting that adapts to your day.',149.99,179.99,'PHILIPS-HUE-STARTER-4',40,1,1,'2025-12-14 04:50:49.908064','2025-12-14 04:58:24.579812',37,'',0,1,5,'','','physical',NULL,25),
(71,'IKEA KALLAX Shelf Unit','ikea-kallax-shelf','Use it as a room divider, TV bench, or display shelf.','Versatile storage that works in any room.',89.99,NULL,'IKEA-KALLAX-4X4-WHT',50,1,0,'2025-12-14 04:50:49.927366','2025-12-14 04:58:24.592753',41,'',1,0,5,'','','physical',NULL,24),
(72,'Atomic Habits by James Clear','atomic-habits-james-clear','No matter your goals, Atomic Habits offers a proven framework for improving every day.','Tiny changes, remarkable results. #1 New York Times Bestseller.',16.99,19.99,'BOOK-ATOMIC-HABITS',200,1,1,'2025-12-14 04:50:49.943852','2025-12-14 04:58:24.602100',54,'',1,0,5,'','','physical',NULL,NULL),
(73,'The Psychology of Money','psychology-of-money','Morgan Housel shares 19 short stories exploring the strange ways people think about money.','Timeless lessons on wealth, greed, and happiness.',14.99,18.99,'BOOK-PSYCH-MONEY',150,1,0,'2025-12-14 04:50:49.961635','2025-12-14 04:58:24.610701',55,'',1,0,5,'','','physical',NULL,NULL),
(74,'Fitbit Charge 6','fitbit-charge-6','Fitbit Charge 6 is the most advanced Fitbit tracker with Google integration.','Advanced health and fitness tracker with Google apps.',159.99,NULL,'FITBIT-CHARGE6-BLK',65,1,1,'2025-12-14 04:50:49.981673','2025-12-14 04:58:24.622528',66,'',0,1,5,'','','physical',NULL,23),
(75,'Lululemon Yoga Mat','lululemon-yoga-mat','Engineered for stability and cushion, perfect for any yoga practice.','The mat that started a revolution. 5mm cushioning.',88.00,NULL,'LULU-MAT-5MM-BLK',75,1,0,'2025-12-14 04:50:49.998707','2025-12-14 04:58:24.632620',62,'',1,0,5,'','','physical',NULL,NULL),
(76,'Under Armour Tech T-Shirt','under-armour-tech-tshirt','UA Tech fabric is quick-drying, ultra-soft and has a natural feel.','Ultra-soft, quick-drying fabric for any workout.',29.99,34.99,'UA-TECH-TEE-BLK-L',180,1,0,'2025-12-14 04:50:50.019067','2025-12-14 04:58:24.643651',61,'',0,0,5,'','','physical',NULL,22),
(77,'LEGO Star Wars Millennium Falcon','lego-millennium-falcon','This LEGO Star Wars Ultimate Collector Series Millennium Falcon is the largest LEGO set ever.','Build the most iconic starship in the galaxy.',849.99,NULL,'LEGO-SW-FALCON-75192',10,1,1,'2025-12-14 04:50:50.036770','2025-12-14 04:58:24.653677',70,'',0,0,5,'','','physical',NULL,NULL),
(78,'Nintendo Switch OLED','nintendo-switch-oled','Experience enhanced audio and a vibrant 7-inch OLED screen whether playing at home or on the go.','Vibrant 7-inch OLED screen for handheld gaming.',349.99,NULL,'GAM-NINTENDO-SWITCH-OLED-6192',17,1,0,'2025-12-14 04:50:50.053626','2025-12-18 01:03:22.852321',24,'',1,0,5,'','','physical',0.42,30),
(79,'Notion Pro Templates Bundle','notion-pro-templates-bundle','Transform your Notion workspace with 50+ professionally designed templates.','50+ premium Notion templates for productivity.',49.99,99.99,'DIGITAL-NOTION-BUNDLE',9999,1,1,'2025-12-14 04:50:50.069593','2025-12-14 04:58:24.674465',77,'',0,1,5,'','','digital',NULL,NULL),
(80,'UI Design Icon Pack','ui-design-icon-pack','A comprehensive icon pack perfect for web and mobile UI design.','2000+ customizable icons for your design projects.',29.99,49.99,'DIGITAL-ICONS-2000',9998,1,0,'2025-12-14 04:50:50.090945','2025-12-19 04:24:23.664358',78,'',0,1,5,'','','digital',NULL,3),
(81,'Google Pixel 8 Pro','google-pixel-8-pro','Google Pixel 8 Pro brings you the best of Google AI with Magic Eraser, Photo Unblur, and real-time translation. 7 years of OS and security updates.','The best of Google AI in a premium smartphone.',999.00,NULL,'SMA-GOOGLE-PIXEL-8-PRO-6553',55,1,1,'2025-12-16 21:40:10.372456','2025-12-18 01:10:15.663955',18,'',0,1,5,'','','physical',0.21,26),
(82,'OnePlus 12','oneplus-12','The OnePlus 12 delivers flagship performance at a competitive price. Features a Hasselblad camera system and 100W fast charging.','Flagship killer with Hasselblad camera.',799.99,899.99,'SMA-ONEPLUS-12-4656',72,1,0,'2025-12-16 21:40:10.390333','2025-12-16 21:40:10.390333',18,'',0,0,5,'','','physical',0.50,27),
(83,'ASUS ROG Zephyrus G14','asus-rog-zephyrus-g14','The ROG Zephyrus G14 packs incredible gaming performance into a compact 14-inch chassis with AMD Ryzen 9 and RTX 4060.','Compact gaming powerhouse.',1599.99,1799.99,'LAP-ASUS-ROG-ZEPHYRUS-G1-4326',53,1,0,'2025-12-16 21:40:10.424484','2025-12-16 21:40:10.424484',19,'',1,1,5,'','','physical',1.72,28),
(84,'AirPods Pro 2','airpods-pro-2','AirPods Pro 2 feature the H2 chip, Adaptive Transparency, and Personalized Spatial Audio for an immersive experience.','Magical audio experience with Active Noise Cancellation.',249.00,NULL,'HEA-AIRPODS-PRO-2-3517',21,1,1,'2025-12-16 21:40:10.448813','2025-12-16 21:40:10.448813',21,'',1,1,5,'','','physical',0.05,3),
(85,'PlayStation 5','playstation-5','The PS5 console unleashes new gaming possibilities with ray tracing, 4K gaming, and the innovative DualSense controller.','Experience lightning-fast loading with ultra-high speed SSD.',499.99,NULL,'GAM-PLAYSTATION-5-9156',29,1,1,'2025-12-16 21:40:10.491193','2025-12-18 01:02:09.127619',24,'',1,0,5,'','','physical',4.50,5),
(86,'Xbox Series X','xbox-series-x','Experience 12 teraflops of raw graphic processing power, true 4K gaming, and Quick Resume.','The fastest, most powerful Xbox ever.',499.99,NULL,'GAM-XBOX-SERIES-X-9972',66,1,1,'2025-12-16 21:40:10.507714','2025-12-18 01:01:04.917311',24,'',0,0,5,'','','physical',4.45,29),
(87,'Classic Fit Oxford Shirt','classic-fit-oxford-shirt','A wardrobe essential crafted from premium cotton. Features a button-down collar and classic fit.','Timeless oxford shirt for any occasion.',49.99,69.99,'MEN-CLASSIC-FIT-OXFORD-S-1422',53,1,1,'2025-12-16 21:40:10.532304','2025-12-16 21:40:10.532304',27,'',0,1,5,'','','physical',0.30,13),
(88,'Slim Fit Chino Pants','slim-fit-chino-pants','Modern slim-fit chinos in stretch cotton twill. Perfect for both casual and smart-casual looks.','Versatile chinos for work or weekend.',39.99,NULL,'MEN-SLIM-FIT-CHINO-PANTS-8478',10,1,0,'2025-12-16 21:40:10.549459','2025-12-16 21:40:10.549459',27,'',1,1,5,'','','physical',0.40,14),
(89,'Wool Blend Overcoat','wool-blend-overcoat','Elegant wool-blend overcoat with notch lapels. A timeless piece for your winter wardrobe.','Sophisticated overcoat for cold weather.',189.99,249.99,'MEN-WOOL-BLEND-OVERCOAT-3285',96,1,1,'2025-12-16 21:40:10.562116','2025-12-16 21:40:10.562116',27,'',0,0,5,'','','physical',1.20,13),
(90,'Floral Midi Dress','floral-midi-dress','Beautiful midi dress with delicate floral print. Features a flattering A-line silhouette and puff sleeves.','Elegant floral dress for any season.',79.99,99.99,'WOM-FLORAL-MIDI-DRESS-6650',23,1,1,'2025-12-16 21:40:10.583055','2025-12-16 21:40:10.583055',28,'',1,1,5,'','','physical',0.35,13),
(91,'High-Rise Skinny Jeans','high-rise-skinny-jeans','Classic high-rise skinny jeans in premium stretch denim. Flattering fit that moves with you.','Perfect everyday skinny jeans.',59.99,NULL,'WOM-HIGH-RISE-SKINNY-JEA-4380',87,1,0,'2025-12-16 21:40:10.598748','2025-12-16 21:40:10.598748',28,'',1,1,5,'','','physical',0.45,13),
(92,'Cashmere Blend Sweater','cashmere-blend-sweater','Cozy cashmere-blend sweater with ribbed details. Perfect layering piece for cooler days.','Luxuriously soft cashmere blend.',89.99,129.99,'WOM-CASHMERE-BLEND-SWEAT-8704',34,1,1,'2025-12-16 21:40:10.613309','2025-12-16 21:40:10.614319',28,'',0,1,5,'','','physical',0.30,14),
(93,'Air Max 270','air-max-270','The Nike Air Max 270 delivers visible cushioning under every step with its large Air unit.','Iconic comfort meets street style.',150.00,NULL,'FOO-AIR-MAX-270-9365',30,1,1,'2025-12-16 21:40:10.628684','2025-12-16 21:40:10.629972',29,'',1,1,5,'','','physical',0.35,11),
(94,'Ultraboost 22','ultraboost-22','Experience incredible energy return with Boost midsole technology. Primeknit upper adapts to your foot.','Incredible energy return with every stride.',190.00,220.00,'FOO-ULTRABOOST-22-7890',48,1,1,'2025-12-16 21:40:10.643645','2025-12-16 21:40:10.643645',29,'',1,0,5,'','','physical',0.32,12),
(95,'Classic Leather Chelsea Boot','classic-leather-chelsea-boot','Classic Chelsea boot crafted from genuine leather. Features elastic side panels and pull tab.','Timeless Chelsea boot in genuine leather.',129.99,NULL,'FOO-CLASSIC-LEATHER-CHEL-3316',23,1,0,'2025-12-16 21:40:10.658170','2025-12-16 21:40:10.658170',29,'',0,0,5,'','','physical',0.80,13),
(96,'Leather Tote Bag','leather-tote-bag','Elegant leather tote with spacious interior. Perfect for carrying laptop, documents, and daily essentials.','Spacious tote for work and weekend.',299.99,399.99,'BAG-LEATHER-TOTE-BAG-4166',12,1,1,'2025-12-16 21:40:10.674857','2025-12-18 01:21:56.007175',30,'',0,1,5,'','','physical',0.80,15),
(97,'Travel Backpack 40L','travel-backpack-40l','Durable travel backpack with laptop compartment, multiple pockets, and ergonomic straps.','Versatile backpack for travel and daily use.',89.99,NULL,'BAG-TRAVEL-BACKPACK-40L-6576',47,1,0,'2025-12-16 21:40:10.689377','2025-12-16 21:40:10.689377',30,'',1,1,5,'','','physical',1.20,11),