-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathApniDukan-data.sql
82 lines (74 loc) · 59.1 KB
/
ApniDukan-data.sql
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
use ApniDukan;
-- INSERT INTO `Admin` VALUES (6,'inventore','illo','sallie.fahey@example.net','a2d1c1c6f5c8595df6f30ebe5582d6'),(572,'et','voluptas','tromp.jettie@example.org','a5cc21e08d1daf6a8f04e4c764f169'),(51127,'nesciunt','aspernatur','olen.stamm@example.com','d8e99790dec650c7b2175f0ffc31cc'),(180818,'vero','atque','dillan.koepp@example.org','5d1056bd0bbd565b134747cb02113b'),(858655,'voluptas','suscipit','kling.jana@example.org','f90db2f2594aac5ff77523815366b4'),(4737663,'eos','dolor','wfisher@example.com','3ef33cc02110d0082be6b66cd9be0e'),(5113780,'laborum','quaerat','vivien.waters@example.com','711400a109fba43b5ff5fd196fae46'),(68432800,'odio','aliquid','malcolm77@example.com','a1e7d3fcb29adeacd76420224fcbe9'),(83743575,'vero','architecto','becker.ludie@example.org','b71fbf857fdcf8c8ff3976b1088b18'),(494932646,'nesciunt','quo','uschiller@example.org','e05165bb110d638ea105717bb4ae29');
-- INSERT INTO `Category` VALUES (0,'vel'),(2,'nemo'),(3,'aspernatur'),(31,'atque'),(82,'quas'),(450,'occaecati'),(538,'ut'),(587,'alias'),(692,'adipisci'),(3606,'ea'),(15112,'natus'),(454122,'qui'),(542378,'ea'),(604191,'nobis'),(712805,'aut'),(848639,'quidem'),(38397885,'cum'),(41776865,'deleniti'),(60942883,'ut'),(552598914,'suscipit');
-- INSERT INTO `Product` VALUES (0,'odit',66757.1,'Accusamus nisi ipsum error.','corrupti','https://loremflickr.com/640/48',0,0,572,2),(1,'omnis',1098340,'Ullam facere.','reprehenderit','https://loremflickr.com/640/48',0,5,494932646,3606),(2,'accusantium',8190630,'Consequatur sint cupiditate hic.','in','https://loremflickr.com/640/48',3,8,180818,604191),(7,'omnis',0,'Aut ut unde ad.','nisi','https://loremflickr.com/640/48',5,9,572,2),(9,'cum',308189000,'Tempora aut.','et','https://loremflickr.com/640/48',5,7,572,2),(19,'eligendi',7982520,'Dolorem aliquid sint iure.','ducimus','https://loremflickr.com/640/48',3,4,51127,3),(27,'tenetur',0,'Blanditiis ut rem.','omnis','https://loremflickr.com/640/48',4,4,51127,3),(51,'unde',1.1,'Aliquam et esse.','eligendi','https://loremflickr.com/640/48',1,9,6,0),(53,'libero',82484.4,'Iusto omnis similique debitis quis.','dolorum','https://loremflickr.com/640/48',0,6,6,15112),(60,'aut',79824.9,'Ea sapiente fugiat consequatur.','non','https://loremflickr.com/640/48',0,0,494932646,552598914),(66,'facilis',0,'Maiores porro quis.','aut','https://loremflickr.com/640/48',1,4,572,454122),(69,'eum',50190.1,'Possimus non illum ea.','id','https://loremflickr.com/640/48',5,7,494932646,552598914),(72,'molestias',4.8,'Maiores necessitatibus omnis in.','est','https://loremflickr.com/640/48',0,5,6,15112),(78,'in',109554,'Voluptatem cum et alias nulla.','repudiandae','https://loremflickr.com/640/48',2,2,68432800,41776865),(82,'id',3,'Occaecati corrupti sit.','quae','https://loremflickr.com/640/48',4,7,4737663,450),(87,'sit',0,'Nostrum dolor iusto.','in','https://loremflickr.com/640/48',1,0,180818,604191),(93,'accusamus',10012600,'Tenetur nobis qui.','voluptas','https://loremflickr.com/640/48',2,9,180818,31),(145,'non',25192400,'Et veritatis dolores exercitationem voluptatibus.','culpa','https://loremflickr.com/640/48',5,4,858655,82),(204,'earum',15079.5,'Illum quo laborum.','dolorum','https://loremflickr.com/640/48',0,0,68432800,587),(207,'corrupti',222188,'Laudantium fugit et.','sint','https://loremflickr.com/640/48',5,6,494932646,3606),(251,'enim',5761640,'Reiciendis adipisci dolor dolores.','consequuntur','https://loremflickr.com/640/48',4,1,68432800,587),(297,'explicabo',127250,'Natus iste iusto.','vero','https://loremflickr.com/640/48',0,9,68432800,41776865),(302,'fugiat',0,'Molestias voluptatem ducimus autem.','aperiam','https://loremflickr.com/640/48',2,1,180818,604191),(577,'sapiente',4127170,'Quis et deleniti.','quo','https://loremflickr.com/640/48',0,0,83743575,60942883),(643,'et',14378500,'Quis alias eos totam vel.','consequatur','https://loremflickr.com/640/48',3,8,83743575,692),(715,'minima',373958,'Quasi qui ex blanditiis voluptates.','consectetur','https://loremflickr.com/640/48',1,2,51127,3),(738,'ab',16471.6,'Eligendi qui et.','dignissimos','https://loremflickr.com/640/48',5,8,5113780,38397885),(752,'reprehenderit',1712500,'Quo rerum ipsum explicabo.','ullam','https://loremflickr.com/640/48',5,8,5113780,538),(778,'ut',2602.2,'Culpa velit laudantium.','nisi','https://loremflickr.com/640/48',5,2,5113780,538),(863,'excepturi',197543,'Quam ut.','ea','https://loremflickr.com/640/48',5,7,6,15112),(887,'fugit',0,'Quos voluptatem sit dolor aperiam.','dolore','https://loremflickr.com/640/48',0,2,83743575,692),(941,'quasi',35.4,'Nemo aut omnis.','repudiandae','https://loremflickr.com/640/48',2,7,4737663,450),(998,'omnis',15813.2,'Saepe optio ut.','autem','https://loremflickr.com/640/48',2,3,494932646,552598914),(1550,'omnis',306.1,'Quod ducimus nisi.','beatae','https://loremflickr.com/640/48',2,2,572,2),(2159,'at',1536.7,'Nobis fuga voluptatem.','est','https://loremflickr.com/640/48',2,7,83743575,60942883),(3614,'facere',254007,'Repellendus perferendis iure unde.','voluptas','https://loremflickr.com/640/48',0,2,68432800,587),(3779,'harum',44791100,'Ratione fuga inventore id.','voluptas','https://loremflickr.com/640/48',0,8,5113780,38397885),(4782,'quia',303339,'Cupiditate amet.','enim','https://loremflickr.com/640/48',4,0,5113780,38397885),(5054,'et',0.5,'Mollitia perspiciatis expedita.','natus','https://loremflickr.com/640/48',1,2,5113780,538),(5279,'id',432.4,'Dolores ducimus quia enim expedita.','voluptatum','https://loremflickr.com/640/48',2,1,83743575,60942883),(6124,'sunt',7.6,'Consectetur magnam minus.','aliquid','https://loremflickr.com/640/48',4,3,858655,82),(6520,'aliquam',0.9,'Quidem commodi quos error libero.','vitae','https://loremflickr.com/640/48',3,5,6,15112),(7209,'ut',3556.2,'Dolorum exercitationem natus nobis.','neque','https://loremflickr.com/640/48',0,9,4737663,848639),(18857,'aut',582159,'Quibusdam et voluptatum.','numquam','https://loremflickr.com/640/48',0,0,494932646,3606),(22373,'necessitatibus',44.3,'Quo adipisci eius ea.','velit','https://loremflickr.com/640/48',3,0,494932646,3606),(30084,'incidunt',0,'Eum nihil et.','dolorem','https://loremflickr.com/640/48',4,0,5113780,38397885),(43031,'exercitationem',180.5,'Et delectus et.','exercitationem','https://loremflickr.com/640/48',1,4,572,454122),(51481,'officia',0,'Temporibus tempore ut id.','sed','https://loremflickr.com/640/48',5,2,858655,82),(61326,'vel',95389100,'Non et voluptatem incidunt.','reprehenderit','https://loremflickr.com/640/48',1,0,5113780,38397885),(68225,'beatae',286419000,'Maxime quia dolor quia.','harum','https://loremflickr.com/640/48',5,5,858655,712805),(78655,'facilis',8,'Ut non saepe qui.','quasi','https://loremflickr.com/640/48',2,3,494932646,552598914),(81948,'quod',3750,'Perspiciatis cumque eos.','cum','https://loremflickr.com/640/48',2,8,858655,82),(89105,'reiciendis',0,'Hic unde pariatur.','soluta','https://loremflickr.com/640/48',2,7,51127,3),(307696,'quibusdam',9802220,'In occaecati sit.','amet','https://loremflickr.com/640/48',3,0,858655,712805),(333222,'nihil',9795120,'Blanditiis labore nesciunt iste.','vero','https://loremflickr.com/640/48',1,8,4737663,450),(356918,'et',0,'Omnis expedita quia quaerat.','non','https://loremflickr.com/640/48',5,3,68432800,41776865),(431339,'molestiae',11.2,'Rem quibusdam minima quidem.','officia','https://loremflickr.com/640/48',2,2,572,2),(631192,'odit',0.8,'Ut eos et beatae.','ut','https://loremflickr.com/640/48',2,5,858655,712805),(634230,'ex',701663,'Beatae ea provident quis.','atque','https://loremflickr.com/640/48',0,9,4737663,450),(856783,'omnis',370661,'Ut veniam qui ut.','fugit','https://loremflickr.com/640/48',2,1,4737663,848639),(921848,'harum',420950,'Nihil et aperiam.','corrupti','https://loremflickr.com/640/48',2,9,83743575,692),(922788,'deleniti',246153,'Hic eligendi fugit.','molestias','https://loremflickr.com/640/48',2,4,51127,542378),(1271449,'sed',0,'Est mollitia aliquam sapiente.','explicabo','https://loremflickr.com/640/48',2,7,494932646,552598914),(2404628,'inventore',31780100,'Quo vero sint ratione.','corporis','https://loremflickr.com/640/48',4,4,83743575,60942883),(3017276,'eos',932.4,'Aut id magnam asperiores.','voluptatibus','https://loremflickr.com/640/48',2,7,572,454122),(3807015,'et',37795.1,'Consequatur debitis perspiciatis.','molestiae','https://loremflickr.com/640/48',3,7,83743575,60942883),(4875810,'delectus',2202220,'Eveniet eaque nesciunt debitis ipsa.','neque','https://loremflickr.com/640/48',3,5,4737663,848639),(5600720,'in',3158.5,'Dignissimos et.','omnis','https://loremflickr.com/640/48',5,7,51127,542378),(6127844,'tempora',175.3,'Consectetur ut autem suscipit.','totam','https://loremflickr.com/640/48',2,4,858655,712805),(6627847,'dolore',0,'Quo officiis aut ut.','quia','https://loremflickr.com/640/48',1,3,180818,31),(6825087,'voluptatum',38,'Impedit sed mollitia.','autem','https://loremflickr.com/640/48',2,0,180818,604191),(7362542,'nihil',0,'Impedit est assumenda consequatur.','explicabo','https://loremflickr.com/640/48',4,2,180818,31),(8684870,'tempora',5525130,'Est voluptatem est.','omnis','https://loremflickr.com/640/48',0,3,6,0),(9239464,'hic',15.6,'Iste animi.','explicabo','https://loremflickr.com/640/48',1,6,51127,3),(9247614,'dolorem',70251.7,'Ab doloribus omnis sit.','ipsum','https://loremflickr.com/640/48',4,3,68432800,587),(19505422,'voluptates',175890000,'Nihil dolorem.','maiores','https://loremflickr.com/640/48',0,1,4737663,848639),(23787694,'porro',36.7,'Ratione voluptatum cupiditate.','cumque','https://loremflickr.com/640/48',4,1,51127,542378),(27975371,'et',62222600,'Voluptatem rerum magni.','voluptatibus','https://loremflickr.com/640/48',4,4,858655,712805),(28109630,'commodi',2565300,'Ipsam adipisci nulla quasi.','quia','https://loremflickr.com/640/48',4,5,51127,542378),(32098795,'consequuntur',31.5,'Est quod saepe.','et','https://loremflickr.com/640/48',0,7,180818,31),(33249944,'earum',42321600,'Qui reprehenderit non.','quae','https://loremflickr.com/640/48',2,7,68432800,587),(40593646,'quae',36.4,'Labore nihil aspernatur.','voluptas','https://loremflickr.com/640/48',1,3,6,0),(42575650,'dolor',0,'Rerum sit soluta cum.','quibusdam','https://loremflickr.com/640/48',2,1,4737663,848639),(48414473,'ut',1421170,'Aliquam ut saepe ipsa.','qui','https://loremflickr.com/640/48',0,4,83743575,692),(48650354,'quo',5013480,'Praesentium quia et laborum.','nesciunt','https://loremflickr.com/640/48',5,9,68432800,41776865),(63640630,'fuga',3.3,'Aspernatur provident.','velit','https://loremflickr.com/640/48',0,8,68432800,41776865),(66440623,'soluta',5.8,'Unde tenetur incidunt.','asperiores','https://loremflickr.com/640/48',3,1,180818,31),(69308473,'cumque',2419290,'Veniam maxime et.','modi','https://loremflickr.com/640/48',4,6,572,454122),(70617187,'sequi',13341.4,'Dolorum atque amet et.','totam','https://loremflickr.com/640/48',3,6,6,0),(76154068,'magnam',2.3,'Recusandae recusandae.','eos','https://loremflickr.com/640/48',5,4,858655,82),(84309469,'quo',338.7,'Et optio facere eveniet.','omnis','https://loremflickr.com/640/48',2,7,4737663,450),(88582958,'et',188561,'Deleniti nobis et possimus hic.','nostrum','https://loremflickr.com/640/48',0,3,5113780,538),(96649970,'quis',410.8,'Reprehenderit eum aliquam.','ut','https://loremflickr.com/640/48',0,7,180818,604191),(242026665,'nam',30.6,'Repellat sunt.','dolor','https://loremflickr.com/640/48',2,1,5113780,538),(324370726,'deserunt',49725.4,'Perspiciatis odit quam est.','ea','https://loremflickr.com/640/48',4,3,572,454122),(660933824,'maiores',0,'Autem deserunt quam eaque.','aut','https://loremflickr.com/640/48',3,0,6,15112),(764605243,'corporis',30.8,'Ratione rerum quisquam natus.','aperiam','https://loremflickr.com/640/48',1,9,83743575,692),(765251358,'et',630581,'Et rerum pariatur.','aut','https://loremflickr.com/640/48',4,3,6,0),(909978517,'porro',0.9,'Ullam est cupiditate odio.','dolores','https://loremflickr.com/640/48',3,0,51127,542378),(930728853,'maiores',977.2,'Exercitationem quam est.','rerum','https://loremflickr.com/640/48',1,6,494932646,3606);
-- INSERT INTO `Cart` VALUES (0,0),(1,4772770),(2,0),(3,3.09),(4,13221900),(5,4.65),(6,1891.26),(7,6745010),(8,0.31),(44,73.06),(46,2.4),(48,148977),(54,29.19),(56,21775.6),(58,0),(62,491439),(63,34955.3),(80,2208.41),(136,0),(302,4378.82),(473,112988000),(605,0),(612,18.65),(618,329679),(639,6244.14),(753,13.56),(777,18.55),(888,2519190),(985,6.65),(1263,52.75),(1480,0),(2035,143.63),(2258,4601880),(2546,189800000),(6842,22272400),(8280,57.26),(9324,5300370),(9991,509105000),(10945,0),(14710,3529.24),(15898,3701.28),(16563,0),(37858,54370.3),(49300,4358.31),(69407,7661.93),(88434,18529.7),(89208,1331620),(93875,1988.32),(97442,555982000),(168633,3.62),(189217,5460980),(245473,121254),(337729,304.27),(444547,10.55),(485595,366.5),(546111,37.11),(565070,458.63),(606201,3251360),(669564,8.72),(814379,49.68),(847744,70.65),(899969,0),(936021,0),(952607,1489930),(1351230,91259200),(2479563,297554),(3177767,401724),(3437246,0.44),(4549772,3182.02),(5613817,58.95),(5734765,27873200),(5800432,7212280),(5912908,0),(6130408,223.2),(7648485,48328700),(8175137,2592.34),(9222896,1551140),(9530516,0),(13061233,73092.7),(28290610,22.41),(32323555,0.07),(40620367,1576.96),(42888894,21060.4),(48949004,9147980),(50351971,17.27),(52698245,7362040),(53734307,0.96),(55124257,1404.26),(62399138,2.15),(79377296,0.9),(84152879,1855890),(156766690,3.81),(241771828,88749900),(272077854,715.7),(321720898,1409.47),(324597453,4078.46),(618828863,5972.28),(638915875,0.52),(748541132,14.16),(812588588,5906.83);
-- INSERT INTO `Cart_contents` VALUES (0,0,2),(1,1,0),(2,2,5),(3,7,5),(4,9,9),(5,19,4),(6,27,0),(7,51,2),(8,53,5),(44,60,2),(46,66,4),(48,69,4),(54,72,4),(56,78,2),(58,82,6),(62,87,1),(63,93,1),(80,145,3),(136,204,5),(302,207,8),(473,251,9),(605,297,4),(612,302,9),(618,577,2),(639,643,2),(753,715,1),(777,738,7),(888,752,4),(985,778,3),(1263,863,1),(1480,887,2),(2035,941,3),(2258,998,7),(2546,1550,7),(6842,2159,5),(8280,3614,5),(9324,3779,6),(9991,4782,8),(10945,5054,3),(14710,5279,9),(15898,6124,3),(16563,6520,0),(37858,7209,0),(49300,18857,9),(69407,22373,9),(88434,30084,4),(89208,43031,2),(93875,51481,0),(97442,61326,4),(168633,68225,8),(189217,78655,1),(245473,81948,1),(337729,89105,1),(444547,307696,7),(485595,333222,3),(546111,356918,5),(565070,431339,0),(606201,631192,8),(669564,634230,3),(814379,856783,1),(847744,921848,2),(899969,922788,5),(936021,1271449,7),(952607,2404628,8),(1351230,3017276,5),(2479563,3807015,2),(3177767,4875810,0),(3437246,5600720,5),(4549772,6127844,1),(5613817,6627847,6),(5734765,6825087,1),(5800432,7362542,0),(5912908,8684870,0),(6130408,9239464,9),(7648485,9247614,0),(8175137,19505422,8),(9222896,23787694,9),(9530516,27975371,9),(13061233,28109630,0),(28290610,32098795,6),(32323555,33249944,0),(40620367,40593646,3),(42888894,42575650,7),(48949004,48414473,6),(50351971,48650354,4),(52698245,63640630,6),(53734307,66440623,5),(55124257,69308473,8),(62399138,70617187,5),(79377296,76154068,0),(84152879,84309469,9),(156766690,88582958,8),(241771828,96649970,9),(272077854,242026665,3),(321720898,324370726,3),(324597453,660933824,6),(618828863,764605243,0),(638915875,765251358,7),(748541132,909978517,8),(812588588,930728853,7);
-- INSERT INTO `Customer` VALUES (0,'ducimus','et','jerry84@example.net','f58030432369d28b9344a603baead7','1993-12-30','9026','South Bernardside','District of Columbia','99607-',5),(1,'voluptatem','qui','kitty75@example.org','3902fa4875fcc5ca52ab0546d37f53','2022-05-13','82538','Jakeshire','Wisconsin','09774',0),(3,'sint','sit','lawrence.schroeder@example.net','14f0f94eb9180c27fa4212a139b784','2014-02-23','010','Gilestown','Kentucky','49502-',546111),(4,'harum','expedita','macejkovic.alvina@example.com','f7afcdce940752cc487c1698319894','1999-07-04','095','Lucieton','Washington','20413-',48949004),(6,'quis','quia','willms.florence@example.net','9ebfcbafe6719eb2ab2a838c282043','2010-04-11','1103','West Berthaven','Alabama','46074-',1480),(8,'unde','explicabo','shawna.ziemann@example.com','30e3c65cd236af64b35aa683852903','1978-11-27','4011','Rahulmouth','Iowa','73536',1351230),(12,'est','sapiente','reichert.lily@example.net','c0219a4bac123f68ae5989b7e1de02','2012-05-09','44900','Oleport','SouthDakota','62645-',337729),(21,'veniam','deserunt','filomena.hilpert@example.org','1ffcba1c3ea1d4344d19cd29acb1f0','1972-03-19','5225','Lake Carolinastad','Tennessee','84108-',8280),(25,'asperiores','voluptas','medhurst.murray@example.org','a77d6bacbf38d320713973be104d88','1999-01-09','2956','Rhiannafurt','Massachusetts','55777',44),(37,'voluptas','explicabo','friesen.lexus@example.net','44cba1e0d7f13641e5281779aa6ea6','2003-03-06','496','Cameronstad','Alabama','25904',2),(39,'eligendi','est','ykunze@example.com','72905080b0e39311e243d8280e1e4c','1991-11-03','8761','West Ross','Nebraska','48901-',69407),(41,'reprehenderit','non','vernie.wisoky@example.com','3fda5a980b1ff3891ace7873727bd1','1995-12-30','44350','North Bethanymouth','Mississippi','79416-',812588588),(52,'quia','eum','gorczany.monty@example.net','4a69c701180d979c9618cc2502772e','2013-01-05','3018','Lake Aidenhaven','Washington','77559',4),(54,'qui','eaque','cali53@example.org','f915eef11468381554cb620a2e3a56','2017-09-03','659','Huelsborough','NewJersey','14930',97442),(57,'voluptatem','quisquam','crempel@example.org','5e6bbace37c156df04209d79f4bff6','2021-09-01','816','Port Earnestine','Kansas','07616',55124257),(66,'dolor','ab','raphael17@example.org','2cf6df56dd6c95aa4acf99fd74eba7','1981-11-24','570','Port Malliestad','Washington','73435',8175137),(82,'illum','in','ocronin@example.com','b0c95ed2d467ebb6f958b1cba1d0a5','2000-01-30','5802','Gislasontown','Florida','99521',3437246),(87,'perferendis','odit','sadie20@example.com','d9143beb5823dc7f93a9be21d24704','2003-03-15','523','Lonmouth','Hawaii','62022',9324),(140,'corrupti','laboriosam','orion04@example.net','516823d9f14f0b52f1efc8dbd254cd','1989-03-28','637','Michealton','Georgia','04557-',473),(142,'pariatur','in','oran.fahey@example.com','50db9f4b002b7b973afbcbdc7dd8db','1986-08-06','27704','Cormierbury','RhodeIsland','79187-',62),(305,'pariatur','autem','isac29@example.org','5ba3d026882e9770ed0ed3b49454bc','2014-08-19','003','East Bennieview','Georgia','61312-',618828863),(389,'a','et','camylle49@example.org','81d073354644f5b09969b1a5f2c56e','1989-02-07','642','Hudsonfort','NewJersey','45360',899969),(454,'sed','ut','thompson.norma@example.org','196329a91898a15af3a4fbff979226','2000-09-08','1702','West Enolastad','Oklahoma','60607',2035),(531,'dolor','aliquid','adrianna97@example.org','af2b8c31e473b6842dc90ed8b918fe','1984-11-26','10068','Bednarborough','Massachusetts','86619',748541132),(584,'reiciendis','qui','heller.jalen@example.net','a030a7b1eb2d3b3d7fb8f99071199f','2006-10-13','4280','East Alvinaside','Massachusetts','40025',52698245),(758,'mollitia','inventore','robb65@example.com','4fb4a059f7b3d16e2988368e725d3e','1977-05-09','54883','Lake Mabelmouth','Delaware','17179',638915875),(814,'similique','hic','nienow.kristian@example.com','e059bd22ed3a92b4ed1b7bdefdb114','1992-05-19','8593','Harrismouth','Illinois','64008-',3),(921,'sequi','quam','jane.hackett@example.com','6dc6002823f6eae89e5b473293a2fd','2002-09-19','97489','Maryjaneville','Minnesota','63020',5800432),(953,'magni','autem','ybode@example.org','705f1a9892f8be4ba609fe8fa9fc6a','1974-10-23','59151','West Nelsonfurt','California','46760',16563),(981,'tempora','odio','mheaney@example.net','ed82cd8b21bc2ba23d2220ed544876','1987-04-16','58652','Port Katlyn','Texas','41358',7648485),(2628,'omnis','quisquam','jayce.farrell@example.net','cb5f458152df651b10a48291e7ff84','2013-01-09','47299','Taliatown','NewHampshire','70693',241771828),(4765,'sit','iure','efren.harvey@example.com','838f3da74e08a6298e5c42af786e1f','1999-12-30','898','East Mario','Kansas','74020-',4549772),(5509,'autem','dolorem','lucie20@example.org','3bf607e8349d9f7201d91074828c59','2007-01-24','607','Sydniland','Idaho','76789',639),(6576,'soluta','aut','gutmann.cole@example.org','30a4d0c7a8b25c15d473411eec9a3d','2003-06-03','245','South Woodrowside','Vermont','79096',48),(6776,'accusantium','quae','cameron.williamson@example.org','b1a2522bd578d302190e60b012e268','1992-01-08','300','Daneville','NewMexico','05412',5734765),(8356,'qui','enim','gusikowski.reese@example.net','688661360e83ff407db97dd92a7cbb','2003-08-08','11464','East Osvaldofurt','Oklahoma','13839-',13061233),(9766,'accusantium','nihil','virgil97@example.com','f346ac50779d09237e11aca5f04411','1972-04-19','08591','Port Parkertown','Idaho','71617-',56),(10183,'nihil','deserunt','rjaskolski@example.org','7a2f63b698952a3ed817f56bce5478','1993-05-03','739','New Juwanmouth','Illinois','81090',14710),(15306,'quam','sit','legros.erin@example.org','c657c24aa21cbbaf248795e831ad7b','1980-11-01','67997','Brittanyberg','Nevada','78256',753),(19174,'rerum','libero','pablo21@example.com','f8830e9010358d737c1eee18bafc91','1991-09-12','4451','Deloresbury','Nebraska','67493',189217),(30084,'praesentium','dicta','xgreenfelder@example.com','99cb2194c6d3c82342d3ff86c94b92','1994-05-19','597','South Carmenport','NorthDakota','35059-',10945),(31463,'dolore','praesentium','mbruen@example.org','7b6966db9631c8c5740b3e11bce6ab','1996-09-02','85772','Koelpinshire','Illinois','13826-',28290610),(46591,'odio','repellat','aron93@example.org','fc2145a660719c5b1429d51d88ce3f','2021-10-15','173','Loweburgh','Texas','72176',888),(66147,'et','accusamus','kris44@example.net','4841f11fc7a43f489d3c641bea5f6c','1983-03-18','364','Delphinemouth','NewYork','11622',847744),(73550,'doloribus','illum','deja98@example.net','3e65c9cf0d006aa5636d5f5ebc219a','1987-09-10','99752','Tressafort','NorthCarolina','47512',9991),(78298,'mollitia','voluptatem','simeon39@example.com','c9e5f40f7133e0881b912a27da4c2a','2002-06-10','911','Scotfurt','Texas','11924',2258),(89236,'error','et','prosenbaum@example.com','67935a2e40eba9c819bee486b62c97','1991-06-09','74825','Port Elijah','WestVirginia','41103-',15898),(89279,'vel','ut','antonio44@example.net','eb7052734673d4d8294cd74fd3560e','2015-09-03','786','Sidneyshire','Georgia','13803',444547),(91116,'perspiciatis','est','zbeier@example.org','eaca4ba42dc6811dcf78d8d9bf188b','1987-06-11','7335','East Waylonfort','Arkansas','57676',156766690),(92709,'impedit','amet','monroe.sanford@example.com','31497d82bda989873d92d2f4cdd9e6','1975-09-05','148','South Claudie','Virginia','59932-',485595),(94701,'ut','qui','sadie56@example.com','3afcc865e89dee8bcf7bc67eba22bc','1973-01-24','9091','Soniahaven','Ohio','91709',5912908),(95017,'asperiores','illo','ywaters@example.com','7024d15a2776bec9db39c4c79bdeb5','1984-10-13','0942','Hegmannton','Delaware','05022-',618),(414114,'et','omnis','nelle.morissette@example.org','7378d182ea58123a4c37be5477b100','1994-02-18','930','Durganton','SouthDakota','25714-',84152879),(421951,'perspiciatis','non','rspencer@example.net','c03082fed4ed5a985c27b113b108c1','1984-11-30','85670','Tommieside','Washington','04903',54),(452215,'illum','laudantium','zkihn@example.com','ddf13856149737475b6ae78896ce43','1975-07-08','124','South Cortneyport','Kentucky','00475-',612),(542040,'et','eum','sreinger@example.org','fb33c017e111a756662a009cc8dff7','1987-06-03','7282','South Albashire','Colorado','64368',9222896),(592440,'ut','dolorem','powlowski.kane@example.com','7bb605e75a52aa1586a16d7fe60a10','1997-12-06','7076','North Howellberg','Arizona','04521',53734307),(796338,'ut','ea','ramona13@example.org','6b6efa5d44b68d565ad1aa916cf66d','1995-05-09','498','Ondrickafort','NewYork','18767',7),(837905,'eaque','consequatur','dking@example.net','669606ffe26c14e11dd30a45dcef23','1997-07-05','68007','East Lorenz','Maine','31043-',89208),(854373,'amet','et','alessia42@example.org','1db69e0a593255bb7ab5683449d12c','2010-08-30','9567','Kihnport','WestVirginia','25560',605),(911643,'est','omnis','xander.bartoletti@example.com','173f19855d9119b24f2e488a944287','1997-12-12','49513','Durganport','Iowa','76005-',79377296),(1593481,'unde','quis','aconnelly@example.com','4052e7ffc4cdbccb33bcaa417b22cc','1981-12-13','5819','New Annetta','Florida','82358',32323555),(2162792,'vitae','dicta','miller.humberto@example.com','338e2da561fcc714b2a0fa970d18c1','2000-05-07','359','Port Lysanneborough','NewYork','98857-',1),(3500787,'earum','praesentium','murl.gottlieb@example.org','79d8ff1e0d9f8ac944f0a64d1c5e91','1996-04-27','910','Rolfsonport','SouthDakota','69327',37858),(3939416,'sed','quia','orolfson@example.net','6c7327334cc8ae6cbba20d98993144','1995-08-05','689','Robertsfurt','Wisconsin','03248',2546),(6236955,'quas','nulla','predovic.queenie@example.net','9817574c3e93b01b252665b1283fad','1975-04-29','74776','Toyfort','NewJersey','38108-',63),(6491162,'commodi','laborum','uglover@example.net','87ff9b4a9006fa59cde82e1f653802','2019-09-24','644','Domingoport','Oklahoma','02973-',42888894),(6544523,'exercitationem','sunt','juvenal49@example.org','1cbde438190fdd7a63a5ac65fa39aa','2001-09-22','6722','East Bradly','Florida','50120',6842),(9349599,'ipsum','ullam','vherman@example.org','87f4cc75509789a436308d0d1246c0','2020-05-03','3827','South Howell','Colorado','47560-',936021),(9749787,'ab','quia','langworth.rylan@example.com','a7c220473a8adfcf3af32f06a5d6f7','1997-01-16','81313','Doylemouth','Massachusetts','89184',302),(12506914,'omnis','modi','xsauer@example.com','708e4e746c92c0cb64c9620a2cb5fc','1984-09-10','177','Isaiasville','Virginia','02154',2479563),(26894709,'repellendus','fugit','sarai.sauer@example.org','82b926646af6d0ad43862a4dd34f30','1976-02-28','42241','East Marciashire','California','63823',324597453),(27943335,'assumenda','rerum','janet91@example.org','53b22817e12a58cf11d6762c3aad9a','1994-06-22','06428','South Penelopefort','NewJersey','43900',136),(29986912,'voluptatem','impedit','lilyan66@example.com','572337c69a25fec7d3a5651fe8a26f','2020-11-11','90784','East Myra','Texas','71245-',9530516),(45467915,'consequatur','minima','beverly50@example.org','c48f3c555fbea18fc2613777ec0dfb','1996-01-22','127','Aubreeburgh','Arkansas','31735',62399138),(54598673,'est','enim','powlowski.adrianna@example.net','ba26f1fa001a1fa781c01223c8c570','1982-02-13','393','East Judybury','Virginia','35372',3177767),(54700282,'odit','blanditiis','gmarks@example.net','e19aa79531ebd2b6b30dfbe581c4cd','1996-02-17','635','Lizziebury','Nevada','48251',93875),(54721814,'placeat','quis','doyle.cortez@example.com','71293b7631ec66abe6411a2aa88e8f','1971-01-04','71970','East Caden','NorthCarolina','69626',40620367),(60415841,'delectus','ab','donald25@example.net','51e02147575cfc10ed66ec04a11bdf','1970-01-16','49695','Port Rocky','NorthDakota','35828',321720898),(60555241,'odit','vel','rempel.destany@example.org','1ea906bc2e2e96559d282b8edcaa27','2007-07-26','3484','New Kaela','SouthDakota','66991',58),(66702867,'assumenda','dolorem','werner71@example.org','5c99b8c0ffba35cfd6356aafdc4709','1994-09-06','714','Omerville','Kansas','87463',814379),(70312763,'nesciunt','corrupti','agoodwin@example.com','4baac67d5710f5ce4c3918a27b5394','1973-11-28','1020','Prosaccoburgh','Delaware','61207-',8),(76573627,'iusto','velit','hoppe.cayla@example.org','8a296efecabd0ff129768fa66c953e','1993-01-04','162','New Vinnieview','Alaska','50702',777),(76830409,'et','asperiores','nannie19@example.com','fabe2339d73fece0b3e43a442a6268','2013-08-14','243','Christiansenview','Hawaii','05571',46),(81625882,'dolorum','dolore','pbernier@example.net','03f7e780a5a3c868674744e3959f7e','2022-11-01','6040','West Tom','Nevada','59907-',1263),(91699410,'doloremque','explicabo','lisandro52@example.com','4e5b5dbc7cfb136eddec9a57a5a01b','1974-10-27','202','West Prestonside','Arkansas','71289-',6),(91779277,'quis','quibusdam','drew.trantow@example.com','9f8df1049cdb0e7fe161e57b0e042b','2003-02-22','93569','Michaelaside','Indiana','15737-',272077854),(97164669,'a','id','labadie.joannie@example.com','13f373074c3b5056552d3fd5bf93f3','2015-12-12','654','New Ernestinaberg','Oregon','35003-',80),(107365850,'fuga','autem','broberts@example.net','6544d738a38fee2990381a55341f02','2012-07-07','9367','West Erickastad','NorthDakota','48979-',5613817),(153237556,'error','pariatur','heathcote.krystina@example.net','b0a9cb4eb74c21159e8d6721b0f50e','2019-06-09','448','Balistreristad','Wisconsin','65466-',565070),(222835805,'maxime','consequatur','frederick.franecki@example.com','0997f58691c581734b812f8c596528','1972-01-16','9806','Harbertown','Colorado','00714-',49300),(487569431,'mollitia','ipsam','jesus.bartoletti@example.com','d1de3965bda6c62e9313571da1f679','1981-06-18','07435','West Catalina','Maryland','43946',88434),(573631494,'repellendus','et','jenkins.graciela@example.com','0911b6b830999e431973510c6874b9','2000-12-19','828','Lake Kendall','SouthCarolina','29362-',606201),(730315895,'unde','ipsum','yboehm@example.org','ab5a1581b81a8ef474c6adca30a21d','1999-12-20','21272','Winifredhaven','SouthDakota','29227',669564),(748236123,'est','nihil','brionna71@example.net','a725ca324b2d7c82d46c1c1a473f9f','2002-12-26','930','South Quintonbury','Michigan','17973-',245473),(765812517,'eius','molestias','rickie.gaylord@example.net','915dc457b0832c1b0d2350dc12fa00','2014-04-24','588','South Pink','Connecticut','93777-',985),(774502560,'aut','cum','fwuckert@example.com','29f61f37ad4dd72203b3074c14f5c7','1979-03-02','199','Lake George','RhodeIsland','88877-',952607),(898445640,'labore','quia','wdicki@example.net','47c824013544a0ed7c8f021230498f','1998-01-13','708','New Darronville','Colorado','18948-',6130408),(906713485,'neque','aut','bode.idell@example.com','074399e1104f247633c5edb693bbe1','1989-03-11','85841','Brennonburgh','Wyoming','55857-',168633),(945767760,'ut','et','ezequiel66@example.com','468f5486a905dd15fb6b2558095b89','2004-08-02','65799','Lueilwitzborough','Michigan','41387',50351971);
-- INSERT INTO `Customer_phone` VALUES (0,'(009)167-6687'),(1,'(019)947-4711'),(3,'1-387-010-966'),(4,'(890)470-1627'),(6,'(177)292-8563'),(8,'+33(9)2753911'),(12,'464.124.2230x'),(21,'1-635-046-209'),(25,'1-825-154-933'),(37,'893-901-7279x'),(39,'588-427-3455'),(41,'+79(3)1742731'),(52,'1-232-057-740'),(54,'+06(3)6162977'),(57,'1-629-552-144'),(66,'1-829-863-134'),(82,'129-565-1737'),(87,'277-299-3322x'),(140,'1-798-812-936'),(142,'(332)380-3784'),(305,'(348)594-0420'),(389,'448-310-3489x'),(454,'(853)859-6706'),(531,'151.708.8622x'),(584,'1-330-493-478'),(758,'599.867.9749'),(814,'125-678-2817x'),(921,'(924)021-0540'),(953,'09168044562'),(981,'355.698.5464x'),(2628,'334.457.3366x'),(4765,'113-042-3047x'),(5509,'196-236-9725x'),(6576,'464.705.8113x'),(6776,'499-966-1610x'),(8356,'1-621-517-195'),(9766,'(730)961-1485'),(10183,'544.373.7845'),(15306,'463.974.3848x'),(19174,'569-509-6539'),(30084,'285.599.1572'),(31463,'513-349-0223x'),(46591,'(491)573-0099'),(66147,'+71(7)2728067'),(73550,'873.503.8126x'),(78298,'+80(9)3786429'),(89236,'164.019.9626'),(89279,'08409297620'),(91116,'874.395.6970x'),(92709,'(658)199-3407'),(94701,'1-034-976-079'),(95017,'417.408.0073x'),(414114,'1-276-997-539'),(421951,'1-070-678-547'),(452215,'(752)678-9739'),(542040,'424-258-6458x'),(592440,'1-078-559-904'),(796338,'(628)022-3866'),(837905,'623-478-6612x'),(854373,'(987)064-3577'),(911643,'189-650-8874x'),(1593481,'1-751-056-884'),(2162792,'893-340-3108x'),(3500787,'(118)835-3310'),(3939416,'(909)762-5636'),(6236955,'1-373-553-403'),(6491162,'+63(9)3481282'),(6544523,'+70(6)5447863'),(9349599,'757.002.4728x'),(9749787,'+28(2)6071854'),(12506914,'(289)431-2800'),(26894709,'(733)014-4686'),(27943335,'003-331-5127'),(29986912,'057.806.9812x'),(45467915,'519.968.8918'),(54598673,'274-393-7163x'),(54700282,'1-991-039-632'),(54721814,'(116)024-3760'),(60415841,'670-129-8659'),(60555241,'08374959344'),(66702867,'616-596-6506'),(70312763,'(000)014-3971'),(76573627,'042-916-9234x'),(76830409,'(161)540-9691'),(81625882,'(101)881-6690'),(91699410,'1-857-776-598'),(91779277,'(736)970-4775'),(97164669,'1-404-591-658'),(107365850,'916-021-8608'),(153237556,'457-571-7424x'),(222835805,'1-110-946-217'),(487569431,'06651324136'),(573631494,'1-457-043-720'),(730315895,'(557)456-8068'),(748236123,'437.747.1813x'),(765812517,'(689)727-1701'),(774502560,'659-304-7324'),(898445640,'(363)336-6726'),(906713485,'+70(3)2673936'),(945767760,'+85(5)3549172');
-- INSERT INTO `Orders` VALUES (0,2372.52,'2019-07-24','completed','4944','Donfort','Oregon','80231-'),(1,840646,'1994-01-08','completed','392','Casandrashire','Mississippi','42185-'),(2,38.15,'1982-04-12','completed','56501','Adatown','Hawaii','93741'),(3,96142.2,'2022-05-21','completed','976','West Althealand','Kentucky','17836-'),(4,163.51,'1973-03-01','completed','628','South Antoniamouth','Oregon','23777-'),(6,19328800,'1983-08-22','completed','4460','North Mark','WestVirginia','01842-'),(7,5.2,'2012-04-07','pending','003','West Ayana','SouthDakota','95108-'),(8,17492500,'1997-06-26','completed','244','Muellerhaven','NewJersey','21610'),(9,41111900,'1977-06-15','completed','9185','South Alexandria','Michigan','89882-'),(10,45383.4,'2019-01-22','completed','25050','Lake Kimberlymouth','Louisiana','89317'),(13,0,'2020-11-23','completed','68616','Kreigertown','District of Columbia','59371'),(28,4.19,'2019-03-27','completed','827','New Karianehaven','Nebraska','58250-'),(30,0,'1997-02-09','completed','7269','Hectorville','Arkansas','70230-'),(41,208.75,'1998-01-28','completed','2415','Port Quinn','Virginia','13297'),(49,3193,'1972-09-12','pending','15532','Port Anabel','Maine','59103'),(54,486256000,'2014-10-04','pending','7350','South Gia','Virginia','40611'),(60,190900000,'1994-07-11','pending','3890','Adelechester','Alabama','09875-'),(74,0,'2013-01-10','completed','59280','Hahnton','California','52053'),(88,107787000,'2022-02-27','pending','8773','Handborough','Nebraska','30961'),(89,1337.74,'1996-05-24','pending','70643','New Samir','NewJersey','84666-'),(90,450415000,'1990-04-22','completed','840','Lelaton','Virginia','58764-'),(95,2.75,'1996-11-04','pending','0548','West Hortenseton','Utah','85132'),(98,1.56,'1981-05-18','pending','00517','New Quincystad','Texas','01961-'),(104,2.74,'2012-11-12','pending','013','New Joany','NewYork','14189-'),(249,2661070,'1991-05-25','completed','81654','New Berthahaven','Georgia','88723'),(418,3726420,'2019-02-23','completed','785','Gutkowskiton','District of Columbia','72666-'),(422,184772000,'1970-07-13','pending','94680','Lake Jonborough','WestVirginia','97425-'),(701,3.64,'2017-02-14','pending','166','Colemanburgh','Wisconsin','71385'),(805,6.35,'2003-06-19','completed','4827','South Ernashire','Florida','93973-'),(824,175109,'1982-04-04','completed','1360','South Cathrineton','Ohio','74483-'),(900,58267500,'1984-05-27','pending','9996','South Hayleeshire','Indiana','89635-'),(996,7.1,'1984-07-21','pending','18788','New Fidel','Nebraska','30055'),(1817,2368050,'1975-03-12','pending','017','West Gunner','Minnesota','92989'),(2095,291237000,'1976-01-11','completed','204','South Jeffry','Alaska','00639'),(3303,4.05,'2021-02-06','completed','123','Lake Wallacetown','Utah','06149-'),(4691,268387,'1970-03-26','pending','758','Port Americochester','Wyoming','85945-'),(5416,0,'1975-07-04','completed','5603','Legrosstad','District of Columbia','21436'),(5520,208.3,'2021-08-12','pending','300','East Hoytshire','Arizona','70496-'),(5931,2980.25,'1973-12-03','completed','61382','Alfredashire','SouthDakota','25739-'),(6053,0,'1995-03-03','completed','20297','Alyssonhaven','SouthDakota','08630'),(8790,73.87,'2011-06-08','completed','9502','Kayceebury','Nebraska','10578-'),(8807,4086140,'2007-04-04','pending','995','Conntown','Oklahoma','30045'),(9221,880.32,'2016-04-21','completed','311','Port Tevin','Colorado','63323-'),(9447,17272.1,'2013-01-05','pending','348','Bartonton','Tennessee','96684'),(10959,3303.26,'1998-03-01','pending','44053','Port Roslynstad','Texas','05420'),(17805,254450,'2021-08-22','pending','876','Greenfelderview','NewJersey','27897'),(22823,917291,'2011-12-29','completed','1656','Cordeliafort','Colorado','39853-'),(24722,3466580,'1987-11-27','completed','84574','Port Ezekiel','Michigan','52367'),(34511,1.29,'1977-10-05','pending','044','New Chadrick','Mississippi','32944'),(41191,0,'1986-01-19','completed','99669','Bahringerfurt','Massachusetts','54016-'),(41993,1248970,'1978-02-28','completed','255','Wellingtontown','Alaska','00069'),(55730,651.95,'2004-04-27','pending','64617','Lake Daniellamouth','SouthCarolina','32637-'),(56196,11.3,'1992-12-01','completed','098','Madilynchester','Iowa','47355'),(108930,235.28,'2004-11-10','completed','98840','Murphyport','Alabama','34461-'),(110311,6865.16,'2009-05-08','pending','78980','Lake Bill','Vermont','43156'),(249883,27450.3,'2008-07-22','completed','54784','Kaseymouth','Mississippi','33618-'),(351516,3.02,'1983-09-21','completed','23008','McClureside','WestVirginia','48060'),(375693,22.06,'1983-11-09','pending','0387','O\'Connertown','Indiana','99171'),(533879,67704000,'1991-01-17','pending','2048','Lake Anabellestad','SouthDakota','57045'),(633156,1201480,'1980-10-29','pending','52752','Braunland','Indiana','69518'),(709489,641.96,'1997-12-16','completed','363','Lempiport','Arizona','53430-'),(726030,8.05,'2015-08-11','completed','675','Kameronburgh','Maine','88350-'),(878611,19177100,'1984-06-29','completed','63525','Clementstad','SouthCarolina','82317'),(2046680,7016.13,'1972-03-09','completed','01897','Schoentown','Idaho','18927'),(2229906,9665.53,'1977-04-27','completed','938','South Torrancemouth','Massachusetts','29034-'),(2880047,0.01,'1985-01-16','pending','1694','West Flossie','Kentucky','89163'),(3553598,1510340,'1989-12-03','completed','393','Nataliefort','NorthCarolina','96411'),(3994887,278.47,'2014-11-03','completed','86054','New Celine','Georgia','85349'),(5055121,0.76,'2001-05-02','completed','356','West Kelli','Vermont','35255-'),(5423818,268.85,'1995-01-29','pending','405','West Andreview','Idaho','18921'),(5445327,152523000,'2013-12-12','completed','5941','Johnsonmouth','Virginia','54885-'),(6306539,0,'2011-07-16','pending','91540','New Reymundo','Texas','35487'),(7497037,87364.2,'1971-05-28','completed','177','East Justinabury','Nebraska','59240-'),(8140387,22402100,'1971-12-22','completed','720','Toytown','Wisconsin','69495-'),(8894370,564127,'2012-01-25','pending','5432','North Zolamouth','Colorado','44000-'),(8901391,1.42,'2023-01-23','pending','05129','Nitzscheside','Arkansas','18710-'),(9659464,2311830,'1996-12-28','pending','294','South Nannie','Mississippi','00765'),(20775420,29176.2,'1974-04-21','completed','30331','New Eraside','NorthCarolina','12640'),(35236486,1719.6,'2019-03-27','pending','31416','North Theodoraside','Pennsylvania','65092-'),(37479620,0,'1992-03-09','completed','2374','Myleneview','Arizona','95063-'),(37653628,32891300,'1976-02-23','pending','4330','North Marcellemouth','Idaho','40411'),(56924635,45.8,'1974-08-16','pending','94740','Port Luzmouth','Utah','69442'),(58178199,571762,'1971-03-19','pending','152','Johanton','Washington','73899-'),(77142317,16659100,'1978-02-20','pending','13837','South Shea','NewMexico','47417-'),(81422465,343.58,'2015-05-14','completed','67277','East Isomview','Massachusetts','90794-'),(93704995,0.21,'2004-05-04','pending','10234','New Laurettafort','SouthCarolina','24041-'),(121900462,2.07,'1975-08-26','completed','77808','Creolaview','NorthDakota','73006-'),(137230991,20326400,'1973-08-17','pending','58828','Kaylinstad','SouthCarolina','53486-'),(274687837,13.78,'2020-11-10','pending','524','Bergemouth','Wisconsin','73423-'),(294427360,27.08,'1990-01-23','pending','648','East Samara','Indiana','28438'),(300491239,838.9,'2013-10-11','completed','323','Lake Luella','Alabama','08250'),(463955384,2989.4,'2016-03-30','pending','4283','Nehaport','Kansas','23368-'),(495020835,87235800,'2017-02-02','completed','663','West Rileyfort','Kansas','73796-'),(599978477,0.82,'1991-07-17','completed','240','Port Chris','Utah','46200'),(734830146,85,'1975-10-07','completed','8353','New Jovanny','Montana','00564-'),(826256869,1078.65,'2016-06-22','pending','251','Alexanneport','Alabama','03830-'),(878518353,244.57,'2014-03-30','completed','70161','Stiedemannside','Delaware','25037'),(933896950,19.43,'2011-08-31','completed','74331','North Elaina','Oklahoma','83042'),(949720637,0,'2012-02-27','pending','7069','Naomitown','Louisiana','73207'),(950525815,2.56,'2015-09-12','completed','72386','Dallintown','Hawaii','38697-');
-- INSERT INTO `Order_contents` VALUES (0,0,9),(1,1,3),(2,2,6),(3,7,9),(4,9,9),(6,19,0),(7,27,4),(8,51,5),(9,53,6),(10,60,5),(13,66,0),(28,69,4),(30,72,1),(41,78,6),(49,82,1),(54,87,7),(60,93,5),(74,145,7),(88,204,4),(89,207,8),(90,251,7),(95,297,0),(98,302,7),(104,577,7),(249,643,8),(418,715,7),(422,738,6),(701,752,8),(805,778,7),(824,863,4),(900,887,8),(996,941,1),(1817,998,9),(2095,1550,1),(3303,2159,7),(4691,3614,9),(5416,3779,1),(5520,4782,4),(5931,5054,0),(6053,5279,6),(8790,6124,5),(8807,6520,1),(9221,7209,4),(9447,18857,9),(10959,22373,8),(17805,30084,7),(22823,43031,5),(24722,51481,3),(34511,61326,0),(41191,68225,5),(41993,78655,9),(55730,81948,4),(56196,89105,0),(108930,307696,7),(110311,333222,9),(249883,356918,8),(351516,431339,7),(375693,631192,5),(533879,634230,6),(633156,856783,5),(709489,921848,9),(726030,922788,6),(878611,1271449,1),(2046680,2404628,3),(2229906,3017276,9),(2880047,3807015,1),(3553598,4875810,8),(3994887,5600720,3),(5055121,6127844,3),(5423818,6627847,3),(5445327,6825087,5),(6306539,7362542,6),(7497037,8684870,9),(8140387,9239464,6),(8894370,9247614,1),(8901391,19505422,1),(9659464,23787694,6),(20775420,27975371,4),(35236486,28109630,1),(37479620,32098795,7),(37653628,33249944,6),(56924635,40593646,3),(58178199,42575650,0),(77142317,48414473,3),(81422465,48650354,1),(93704995,63640630,6),(121900462,66440623,3),(137230991,69308473,3),(274687837,70617187,8),(294427360,76154068,2),(300491239,84309469,0),(463955384,88582958,7),(495020835,96649970,1),(599978477,242026665,3),(734830146,324370726,3),(826256869,660933824,0),(878518353,764605243,3),(933896950,765251358,9),(949720637,909978517,5),(950525815,930728853,6);
-- INSERT INTO `Payment` VALUES (0,0,2026695,49238500,'1972-03-10',''),(1,1,132281,37829,'1977-01-11',''),(2,3,0,4.02,'2005-07-16',''),(3,4,0,156.06,'2005-11-17',''),(4,6,195794050,359918000,'1990-04-11',''),(6,8,926748,0.17,'1974-09-10',''),(7,12,29,0,'2001-03-10',''),(8,21,71434065,7324.48,'1976-08-12',''),(9,25,844,9449250,'2010-07-31',''),(10,37,2677,18449500,'1993-09-21',''),(13,39,97627,71689900,'1995-03-28',''),(28,41,0,782.86,'2002-01-05',''),(30,52,655917,26994.2,'2001-11-22',''),(41,54,668,4269100,'1987-06-01',''),(49,57,5451425,157.29,'1982-01-17',''),(54,66,80895283,104223,'2017-04-08',''),(60,82,51495668,436422000,'2018-01-07',''),(74,87,90,2345390,'1993-06-01',''),(88,140,20,154.26,'1992-01-10',''),(89,142,33753,53078.4,'1989-04-24',''),(90,305,0,18196.7,'1971-12-15',''),(95,389,820780,42396100,'2000-06-13',''),(98,454,34433298,0,'1975-02-18',''),(104,531,0,0,'1973-12-19',''),(249,584,756,1823820,'1990-07-15',''),(418,758,8666,0.06,'1971-09-10',''),(422,814,3646685,1084.72,'1979-11-02',''),(701,921,31467,42971300,'1979-06-12',''),(805,953,909731569,125280000,'1979-05-22',''),(824,981,573,236991,'2006-03-17',''),(900,2628,1,1.39,'2014-01-21',''),(996,4765,991,4870.69,'1973-11-22',''),(1817,5509,855,4025.79,'1989-07-22',''),(2095,6576,766724259,1.11,'1993-12-02',''),(3303,6776,9,409510,'1978-02-12',''),(4691,8356,6005846,269785,'2006-03-07',''),(5416,9766,21,33310.9,'1977-04-03',''),(5520,10183,73,58250.6,'1993-09-26',''),(5931,15306,8151454,158.38,'2001-08-13',''),(6053,19174,591934379,1.02,'2003-02-03',''),(8790,30084,3436,2680.14,'1999-12-14',''),(8807,31463,0,6939.57,'1990-10-27',''),(9221,46591,168962,102691,'1981-07-29',''),(9447,66147,84184626,483.97,'1977-05-26',''),(10959,73550,61815,0.71,'1992-09-17',''),(17805,78298,441046330,34550.6,'1997-03-20',''),(22823,89236,403,8.57,'2012-02-02',''),(24722,89279,527483793,12.75,'2004-11-18',''),(34511,91116,424,653468,'2021-12-30',''),(41191,92709,96,323451,'1997-03-21',''),(41993,94701,0,50219.4,'1977-02-18',''),(55730,95017,0,18.45,'1997-03-16',''),(56196,414114,3331301,1915460,'1978-11-10',''),(108930,421951,944,260725,'1988-09-04',''),(110311,452215,50271464,3.44,'1981-05-17',''),(249883,542040,0,3591710,'2003-11-03',''),(351516,592440,884120500,310.19,'1989-05-18',''),(375693,796338,69677371,36.21,'1990-10-20',''),(533879,837905,6859,212.53,'1973-07-07',''),(633156,854373,33721,2185890,'2004-06-29',''),(709489,911643,9892,3414140,'1998-07-29',''),(726030,1593481,533216802,294665000,'2000-12-08',''),(878611,2162792,636181625,14311000,'2006-10-13',''),(2046680,3500787,9350,45152400,'1993-01-31',''),(2229906,3939416,786641,29673.8,'2001-05-25',''),(2880047,6236955,5,4539530,'1987-07-01',''),(3553598,6491162,3440375,785406000,'1978-09-27',''),(3994887,6544523,84333,48532.2,'1995-07-06',''),(5055121,9349599,0,8984070,'1995-08-18',''),(5423818,9749787,171,15924.9,'1974-05-21',''),(5445327,12506914,70457,21695.8,'1987-12-28',''),(6306539,26894709,260243006,223.02,'1977-06-30',''),(7497037,27943335,2,241116000,'2005-03-06',''),(8140387,29986912,7073606,11.86,'2018-06-18',''),(8894370,45467915,6702,28656800,'1994-11-22',''),(8901391,54598673,3,1090.62,'2002-06-25',''),(9659464,54700282,21740,251103,'2019-01-07',''),(20775420,54721814,121859,0,'1970-10-31',''),(35236486,60415841,536512,23469300,'1992-02-26',''),(37479620,60555241,1248,7279.54,'1997-12-14',''),(37653628,66702867,2884,384658,'2014-01-28',''),(56924635,70312763,0,1351970,'1984-10-17',''),(58178199,76573627,16,5244430,'1997-04-14',''),(77142317,76830409,0,4.11,'1986-12-21',''),(81422465,81625882,15046,616691,'1982-03-30',''),(93704995,91699410,794779374,176221000,'2018-02-27',''),(121900462,91779277,2248,1268050,'2001-06-30',''),(137230991,97164669,7209399,308.6,'2006-04-14',''),(274687837,107365850,176,556373,'2000-08-22',''),(294427360,153237556,0,0,'1996-01-10',''),(300491239,222835805,32,518778000,'1978-03-17',''),(463955384,487569431,921,932185,'1977-03-14',''),(495020835,573631494,3715,1463560,'2016-07-04',''),(599978477,730315895,9808334,0.78,'2006-03-19',''),(734830146,748236123,7653677,20103.5,'1984-07-12',''),(826256869,765812517,393,85444800,'1986-10-02',''),(878518353,774502560,78691485,2082950,'1990-04-05',''),(933896950,898445640,11,42730200,'1998-12-04',''),(949720637,906713485,0,295040000,'1996-05-26',''),(950525815,945767760,1136208,283509,'2011-10-29','');
-- INSERT INTO `Delivery` VALUES (0,'1988-09-03','','41317','Gabeberg','Hawaii','08063-',2),(1,'1992-04-14','','3811','Carrollhaven','NorthDakota','52137-',824),(3,'1998-12-10','','9179','Port Doloresland','Arkansas','77381-',9659464),(5,'1999-07-28','','65133','Kuhicshire','Illinois','44232-',418),(6,'1982-09-10','','49799','Marksport','Nebraska','63215',3),(7,'2019-11-05','','8163','East Erafurt','Connecticut','90476',41),(8,'1991-11-17','','212','New Valentinhaven','Wyoming','94789',54),(34,'1988-04-17','','43000','South Elissa','District of Columbia','57954',2229906),(40,'2014-03-17','','001','Strackeport','Texas','78464-',701),(57,'1979-01-13','','57111','North Lexieshire','WestVirginia','50667-',98),(61,'1975-01-12','','46867','South Paul','Illinois','02203-',274687837),(62,'1984-05-29','','759','New Felicity','Indiana','80991',6),(69,'1988-09-27','','084','Langworthport','Illinois','98303-',34511),(71,'1984-05-27','','68805','Port Jordyn','Ohio','22542-',878518353),(76,'1978-11-16','','11470','Schultzhaven','Idaho','67955-',5055121),(97,'2016-06-27','','4777','O\'Connellfort','California','86199',533879),(98,'1989-11-23','','061','Watsicafurt','Kansas','51886-',5416),(259,'1994-07-29','','728','Altachester','NorthCarolina','92201-',949720637),(280,'2005-07-07','','17419','Whitneyborough','Kentucky','33202',0),(326,'2000-06-09','','45867','Gerrymouth','NorthCarolina','62117',8901391),(374,'2001-01-07','','528','Satterfieldmouth','Texas','59834',878611),(524,'2013-12-02','','3400','Dooleyton','Minnesota','01546-',900),(595,'2021-09-30','','73308','North Tatum','Idaho','08040-',110311),(609,'1992-10-17','','7662','East Justentown','Ohio','01977',5520),(646,'2014-02-09','','1689','Mercedeschester','Massachusetts','22474',74),(721,'1990-05-05','','2585','Hoegerfort','Indiana','17753',49),(722,'1995-10-17','','2478','Hilllside','Idaho','10920',933896950),(783,'2021-01-11','','82767','East Dortha','Ohio','73465',90),(837,'2011-04-19','','086','Annetteview','SouthCarolina','14807-',56196),(892,'1984-12-27','','330','Lake Miracle','Minnesota','67228-',1),(959,'2010-12-21','','264','Port Art','Alabama','98627',8140387),(974,'1980-06-27','','774','Aminafort','Nebraska','85845-',137230991),(1025,'2005-09-02','','289','Rogahnburgh','Louisiana','37552-',95),(1195,'2017-07-18','','904','Sawaynberg','Michigan','17978-',104),(1631,'1999-08-21','','5746','O\'Haraton','Washington','64678-',35236486),(1952,'2020-07-23','','622','Cummingschester','Kentucky','28033-',950525815),(2899,'2017-05-08','','76489','North Erlingside','Oklahoma','23427-',37479620),(4041,'1990-08-25','','028','New Giovanni','NewJersey','07988-',81422465),(5906,'1996-04-13','','68782','Maggioland','Delaware','14044',8790),(6430,'1970-01-13','','222','Lake Kaycee','Florida','11871-',422),(6968,'1970-06-14','','565','Dietrichburgh','NewHampshire','40608-',60),(7002,'1996-04-09','','999','Gerrybury','Alaska','70775-',826256869),(7483,'2010-05-30','','8519','East Marciaside','Indiana','49862-',709489),(7540,'2013-10-03','','756','Garlandville','RhodeIsland','94248',2880047),(17270,'1988-01-07','','08960','Fayport','RhodeIsland','07078-',996),(38619,'1971-10-02','','74794','Vonfort','Tennessee','11294-',805),(38783,'2022-07-21','','4981','Sadieport','Utah','50826-',463955384),(43655,'1984-09-14','','8090','Colebury','Maine','34968-',121900462),(57145,'2000-11-29','','41022','East Rupert','Hawaii','91585-',28),(62317,'2011-01-20','','567','Blockside','Ohio','12047-',22823),(63166,'1979-06-05','','30574','Port Christop','Texas','14639-',88),(68744,'2018-06-06','','4907','Lake Wilford','Kentucky','26101-',1817),(73399,'1997-08-29','','012','Oberbrunnerland','Arizona','44355',3994887),(76458,'1974-02-23','','6798','West Leilani','Maryland','02449',599978477),(78494,'1983-11-01','','44872','Colleenburgh','WestVirginia','23231-',93704995),(79418,'2019-08-08','','6747','Steuberborough','RhodeIsland','42033-',56924635),(81159,'2002-06-09','','12374','Jamirfort','NorthCarolina','25896',300491239),(83249,'2009-09-02','','954','Franeckiside','Nevada','46910-',37653628),(149783,'1977-12-01','','4982','East Minnieberg','Colorado','14892-',41993),(316482,'2005-04-02','','62091','East Jeffmouth','Minnesota','42800-',7),(334596,'2010-07-16','','28230','Lednerton','Wyoming','77462-',8),(365654,'2012-09-03','','432','Lake Jaimeton','Minnesota','76838-',9221),(399532,'2016-05-16','','4242','Millerberg','Idaho','56072-',30),(479670,'1981-09-21','','2174','Elfriedahaven','Oklahoma','44159-',495020835),(580275,'2011-04-12','','2468','South Jayne','Nebraska','63374',294427360),(770927,'1979-05-27','','895','Corineview','SouthCarolina','54172',9447),(929042,'1990-05-09','','533','East Pearlstad','Oklahoma','71439-',77142317),(943022,'2019-08-16','','635','East Bryon','Montana','51047',10959),(945897,'2014-03-16','','5825','Joannieshire','NorthCarolina','83090',20775420),(953951,'1993-10-04','','640','West Frederickland','District of Columbia','23473',3553598),(1203977,'1981-11-18','','411','Cadenmouth','Maryland','66081',8807),(1921491,'2009-06-15','','35832','Lake Camilaberg','Alaska','27893-',2095),(2230995,'1992-12-23','','870','South Bertbury','Kansas','82932',55730),(2772280,'2020-08-19','','6823','Schmidtport','Ohio','09089-',4691),(3268190,'1985-04-22','','46548','North Gunnerport','Alabama','41332-',6306539),(3446107,'1996-08-18','','5032','Ramiroborough','Arizona','18501-',249883),(3877623,'1989-04-14','','67464','Lake Wallaceborough','Indiana','88262-',7497037),(4105250,'2009-12-13','','759','Oberbrunnerfort','Montana','24435',108930),(4742082,'1993-07-19','','4464','Bergeside','Illinois','34482-',10),(7365874,'2006-11-11','','95921','New Jesus','Kentucky','26378-',351516),(9401105,'1993-05-21','','49442','Kayleighport','Hawaii','18436-',633156),(16651480,'1971-10-30','','47188','Grahamside','Oklahoma','17373',58178199),(33948165,'1992-09-08','','7684','Marvinburgh','District of Columbia','50155-',375693),(34883248,'2021-01-16','','81984','Vincentmouth','NorthDakota','52288',5931),(45087191,'2018-07-17','','496','Shakiraside','Alaska','74640',6053),(49495568,'2009-03-07','','128','New Andres','NewJersey','24437',734830146),(53145561,'1979-02-12','','719','Santinatown','Nevada','70676-',9),(58244631,'1971-10-26','','6175','Port Hilbert','Arizona','77876',5445327),(66095772,'1983-02-01','','04007','East Jannie','Louisiana','61398-',4),(85397745,'2001-03-03','','390','Jacobsshire','Montana','98406',249),(86501569,'1977-10-14','','8022','South Wandaberg','Minnesota','58953-',5423818),(87270162,'2020-06-08','','345','McLaughlinstad','Texas','56610',2046680),(93001077,'2000-03-20','','552','Stefanieton','Indiana','60073-',726030),(93336429,'2020-09-20','','244','Port Generalshire','Connecticut','90745',13),(174745257,'1986-08-16','','001','Baumbachstad','Indiana','60290',24722),(179312151,'1998-02-06','','05819','Kutchmouth','Arizona','06885-',17805),(409379331,'1990-12-22','','37963','North Hermann','Indiana','68754-',8894370),(825094679,'1974-05-15','','051','Port Vincenthaven','NorthCarolina','96279-',3303),(920638391,'2003-09-10','','112','Sanfordstad','NorthCarolina','63726',41191),(931772482,'1983-01-18','','005','Karleeberg','Iowa','58721',89);
INSERT INTO Admin (admin_ID, admin_fname, admin_lname, admin_email, admin_password)
VALUES
(1, 'Alok', 'Sharma', 'aloksharma@gmail.com', 'password123'),
(2, 'Sarika', 'Jain', 'sarikajain@gmail.com', 'password123'),
(3, 'Vishal', 'Kumar', 'vishalkumar@gmail.com', 'password123'),
(4, 'Anjali', 'Verma', 'anjaliverma@gmail.com', 'password123');
INSERT INTO Category (category_ID, category_name)
VALUES
(1, 'Electronics'),
(2, 'Clothing'),
(3, 'Home & Kitchen'),
(4, 'Books');
INSERT INTO Product (product_ID, product_name, product_price, product_description, product_brand, product_image, product_rating, product_available_quantity, admin_ID, category_ID)
VALUES
(101, 'Samsung Galaxy S21', 79999.00, '6.2-inch FHD+ Dynamic AMOLED 2x display, Exynos 2100 processor', 'Samsung', 'samsung_galaxy_s21.jpg', 4.5, 50, 3, 1),
(102, 'Apple iPhone 13', 79900.00, '6.1-inch Super Retina XDR display, A15 Bionic chip', 'Apple', 'iphone_13.jpg', 4.8, 50, 1, 1),
(103, 'Sony Bravia 55-inch Smart TV', 69999.00, '4K HDR TV with 4K HDR Processor X1', 'Sony', 'sony_bravia_tv.jpg', 4.7, 20, 2, 1),
(104, 'Canon EOS R6 Mirrorless Camera', 184990.00, 'Full-frame mirrorless camera with 20.1 Megapixel CMOS sensor', 'Canon', 'canon_eos_r6.jpg', 4.9, 10, 1, 1),
(105, 'Bose Wireless Headphones', 29990.00, 'Noise-cancelling headphones with Alexa voice control', 'Bose', 'bose_headphones.jpg', 4.6, 30, 3, 1),
(106, 'Lenovo IdeaPad Slim 5i Laptop', 52990.00, '14-inch Full HD IPS display, 11th Gen Intel Core i5-1135G7 processor', 'Lenovo', 'lenovo_laptop.jpg', 4.4, 15, 1, 1),
(107, 'Fitbit Charge Fitness Tracker', 13990.00, 'Advanced health and fitness tracker with EDA Scan app', 'Fitbit', 'fitbit_charge_5.jpg', 4.7, 60, 2, 1),
(108, 'Dyson V11 Vacuum Cleaner', 61990.00, 'Powerful cordless vacuum cleaner with LCD screen', 'Dyson', 'dyson_v11.jpg', 4.8, 5, 1, 1),
(109, 'JBL Flip 5 Bluetooth Speaker', 9999.00, 'Waterproof Bluetooth speaker with 12-hour battery life', 'JBL', 'jbl_speaker.jpg', 4.5, 40, 4, 1);
INSERT INTO Product (product_ID, product_name, product_price, product_description, product_brand, product_image, product_rating, product_available_quantity, admin_ID, category_ID)
VALUES
(201, 'Nike Men''s Running Shoes', 3499.00, 'Comfortable and stylish running shoes for men', 'Nike', 'nike_running_shoes.jpg', 4.2, 100, 2, 2),
(202, 'Adidas Women''s Running Shoes', 2999.00, 'Lightweight and breathable running shoes for women', 'Adidas', 'adidas_running_shoes.jpg', 4.5, 75, 3, 2),
(203, 'Reebok Men''s T-shirt', 899.00, 'Soft and comfortable cotton T-shirt for men', 'Reebok', 'reebok_tshirt.jpg', 4.0, 150, 1, 2),
(204, 'Puma Women''s Sports Bra', 1199.00, 'Stylish and supportive sports bra for women', 'Puma', 'puma_sports_bra.jpg', 4.7, 50, 4, 2),
(205, 'Fila Men''s Shorts', 1499.00, 'Breathable and quick-drying shorts for men', 'Fila', 'fila_shorts.jpg', 4.3, 80, 2, 2),
(206, 'Adidas Women''s Leggings', 1999.00, 'Stretchy and comfortable leggings for women', 'Adidas', 'adidas_leggings.jpg', 4.8, 60, 3, 2),
(207, 'Nike Men''s Hoodie', 4499.00, 'Warm and comfortable hoodie for men', 'Nike', 'nike_hoodie.jpg', 4.6, 40, 2, 2),
(208, 'Puma Women''s Tank Top', 999.00, 'Soft and comfortable tank top for women', 'Puma', 'puma_tank_top.jpg', 4.2, 120, 4, 2),
(209, 'Reebok Men''s Joggers', 2499.00, 'Soft and comfortable joggers for men', 'Reebok', 'reebok_joggers.jpg', 4.0, 100, 1, 2);
INSERT INTO Product (product_ID, product_name, product_price, product_description, product_brand, product_image, product_rating, product_available_quantity, admin_ID, category_ID)
VALUES
(301, 'Stainless Steel Water Bottle', 599, 'Eco-friendly water bottle', 'Cello', 'stainless-steel-water-bottle.jpg', 4.5, 200, 1, 3),
(302, 'Air Fryer', 4999, 'Healthy cooking appliance', 'Philips', 'air-fryer.jpg', 4.2, 50, 2, 3),
(303, 'Vacuum Cleaner', 7999, 'Powerful cleaning device for home', 'Dyson', 'vacuum-cleaner.jpg', 4.8, 30, 3, 3),
(304, 'Non-Stick Cookware Set', 2399, 'Complete set of cookware for daily use', 'Prestige', 'non-stick-cookware-set.jpg', 4.4, 100, 1, 3),
(305, 'LED Desk Lamp', 899, 'Flexible lighting solution for study or work', 'Mi', 'led-desk-lamp.jpg', 4.6, 150, 2, 3),
(306, 'Electric Kettle', 1599, 'Quick and easy hot water for tea or coffee', 'Bajaj', 'electric-kettle.jpg', 4.3, 80, 3, 3),
(307, 'Food Processor', 4499, 'Versatile kitchen appliance for multiple tasks', 'Inalsa', 'food-processor.jpg', 4.5, 40, 1, 3),
(308, 'Water Purifier', 8499, 'Clean and healthy drinking water', 'Kent', 'water-purifier.jpg', 4.7, 20, 2, 3),
(309, 'Rice Cooker', 2299, 'Easy and convenient cooking of rice', 'Panasonic', 'rice-cooker.jpg', 4.1, 60, 3, 3);
INSERT INTO Product (product_ID, product_name, product_price, product_description, product_brand, product_image, product_rating, product_available_quantity, admin_ID, category_ID)
VALUES
(401, 'The Great Gatsby', 9.99, 'Classic novel by F. Scott Fitzgerald', 'Penguin', 'great-gatsby.jpg', 4.5, 20, 1, 4),
(402, 'To Kill a Mockingbird', 8.99, 'Classic novel by Harper Lee', 'HarperCollins', 'mockingbird.jpg', 4.8, 15, 1, 4),
(403, '1984', 7.99, 'Dystopian novel by George Orwell', 'Signet Classics', '1984.jpg', 4.4, 25, 2, 4),
(404, 'Animal Farm', 6.99, 'Classic allegorical novella by George Orwell', 'Signet Classics', 'animal-farm.jpg', 4.6, 30, 2, 4),
(405, 'The Catcher in the Rye', 8.49, 'Controversial novel by J.D. Salinger', 'Little, Brown and Company', 'catcher-rye.jpg', 4.2, 18, 3, 4),
(406, 'The Hobbit', 10.99, 'Fantasy novel by J.R.R. Tolkien', 'HarperCollins', 'hobbit.jpg', 4.9, 10, 3, 4),
(407, 'The Lord of the Rings', 29.99, 'Epic high fantasy novel by J.R.R. Tolkien', 'HarperCollins', 'lord-rings.jpg', 5.0, 5, 3, 4),
(408, 'The Hitchhiker''s Guide to the Galaxy', 6.49, 'Comedy science fiction novel by Douglas Adams', 'Del Rey Books', 'hitchhiker.jpg', 4.3, 22, 4, 4),
(409, 'Harry Potter and the Philosopher''s Stone', 12.99, 'Fantasy novel by J.K. Rowling', 'Bloomsbury', 'harry-potter.jpg', 4.8, 12, 4, 4);
INSERT INTO Customer (customer_ID, customer_fname, customer_lname, customer_email, customer_password, customer_balance, customer_dob, customer_address_house_no, customer_address_city, customer_address_state, customer_address_pincode, cart_ID)
VALUES
(1, 'John', 'Doe', 'johndoe@gmail.com', 'password', 5000, '1990-01-01', '123 Main St', 'Mumbai', 'Maharashtra', '400001', NULL),
(2, 'Jane', 'Doe', 'janedoe@gmail.com', 'password123', 7000, '1988-02-15', '456 Second St', 'Delhi', 'Delhi', '110001', NULL),
(3, 'Bob', 'Smith', 'bobsmith@gmail.com', 'password456', 10000, '1995-05-20', '789 Third St', 'Chennai', 'Tamil Nadu', '600001', NULL),
(4, 'Alice', 'Johnson', 'alicejohnson@gmail.com', 'password789', 20000, '1992-09-30', '321 Fourth St', 'Kolkata', 'West Bengal', '700001', NULL);