-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path131_Assignment-3_2021010(FINAL).sql
1739 lines (1584 loc) · 145 KB
/
131_Assignment-3_2021010(FINAL).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
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
drop database if exists online_retail_store;
create database online_retail_store;
use online_retail_store;
create table admin(
Aid VARCHAR(50) not null unique,
AFirstname VARCHAR(50) not null,
ALastname VARCHAR(50),
Aemail VARCHAR(50) not null unique,
Apwd VARCHAR(50) not null,
Aphone bigint not null unique,
PRIMARY KEY(Aid),
check(Aphone>1000000000 && Aphone<9999999999),
check(char_length(Apwd)>=6)
);
-- drop table User;
create table User (
Uid int not null unique auto_increment,
Ufirstname VARCHAR(50) not null,
ULastname VARCHAR(50),
Uemail VARCHAR(50) not null unique,
Upwd VARCHAR(50) not null,
Uaddr VARCHAR(50) not null,
Uphone bigint not null unique,
Udob DATE not null,
PRIMARY KEY(Uid),
check(Uphone>1000000000 && Uphone<9999999999),
check(char_length(Upwd)>=6)
) engine=InnoDB;
-- drop table Product;
create table Product(
Prid int not null unique auto_increment,
Prname varchar(70) not null,
Prprice int not null,
Prcategory varchar(50) not null,
Prstatus varchar(50) ,
Prunits int not null default 1,
PRIMARY KEY(Prid)
) engine=InnoDB;
-- drop table Deliveryperson;
create table Deliveryperson (
Did int not null unique auto_increment,
DFirstname VARCHAR(50) not null,
DLastname VARCHAR(50),
Demail VARCHAR(50) not null unique,
Dpwd VARCHAR(50) not null,
Daddr VARCHAR(50) not null,
Dphone bigint not null unique,
Dsalary int not null default 10000,
Daadhar bigint not null unique,
Ddob DATE not null,
PRIMARY KEY(Did),
check(Dphone>7800000000 && Dphone<9999999999),
check(char_length(Dpwd)>=6),
check(Daadhar>100000000000 & Daadhar<999999999999)
)engine=InnoDB;
-- drop table Oder;
create table Oder (
Oid int not null unique,
Uid int not null unique,
Deliverydate date not null,
Did int not null ,
PRIMARY KEY(Oid),
foreign key(Uid) references User(Uid),
foreign key(Did) references Deliveryperson(Did)
);
-- drop table Payment;
create table Payment (
Pid varchar(50) not null unique ,
Uidd int not null unique auto_increment,
Pmethods varchar(60) not null,
Pdate date not null,
PaymentStatus varchar(40) not null,
Pamount int not null default 0,
PRIMARY KEY(Pid),
foreign key(Uidd) references User(Uid)
) engine=InnoDB;
create table Cart(
Cid int not null ,
Uid int not null,
foreign key(Uid) references User(Uid),
PRIMARY KEY(Cid)
) engine=InnoDB;
create table PrUnit(
PUid int not null,
Prid int not null,
unit int not null,
Cid int not null,
PRIMARY KEY(PUid),
foreign key(Cid) references Cart(Cid)
)engine=InnoDB;
-- // new prunits should be set to equal to total units
-- //set pamount of payment=unit of prunit *(join prunit and product) prprice
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('20-4204672', 'Jeremie', 'Claye', '[email protected]', 'SeslDV', 8293416205);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('79-9541447', 'Uriel', 'Hinrichsen', '[email protected]', 'Zb7jaTcFcg', 8519877654);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('74-5368306', 'Carmelle', 'Mendoza', '[email protected]', '0JAXuEvTjT', 9224418472);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('04-6159745', 'Angelo', 'Whordley', '[email protected]', 'sg6cz7WtdqQx', 8260365522);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('97-1814405', 'Terrel', 'Gelder', '[email protected]', 'dNhjTjGez', 9198726262);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('75-1541179', 'Nicola', 'Davids', '[email protected]', 'C4jbjORW1TU5', 8975371447);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('57-7239890', 'Jesselyn', 'Fantham', '[email protected]', 'DHSBpVV', 8018500916);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('26-2819691', 'Sheena', 'Mearns', '[email protected]', '0RO6a8', 9448903484);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('42-4156790', 'Lilian', 'Mingotti', '[email protected]', '6z5qUSa', 9191287688);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('42-4847473', 'Britta', 'Revening', '[email protected]', 'Q7vrUX1FS', 8433090121);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('32-0490101', 'Netta', 'Povall', '[email protected]', 'IfoVOtd', 8984542751);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('57-1601267', 'Sergei', 'Bainbridge', '[email protected]', 'jh4YqlIrn0F2', 9690986010);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('96-9752702', 'Jacquie', 'Gabbot', '[email protected]', 'kQla4En39Zy', 9954059218);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('75-1162480', 'Kayley', 'Tamblyn', '[email protected]', 'LK3UIRjo', 8085427571);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('99-3703856', 'Bar', 'Tunniclisse', '[email protected]', 'K6HX7LDY46t', 8885691709);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('94-6425265', 'Kati', 'Pembridge', '[email protected]', 'CcDP2IWd6g', 8787250331);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('83-4124891', 'Wilbur', 'Sharple', '[email protected]', 'WURLAXh3', 8334596382);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('27-6767538', 'Clare', 'Bricknell', '[email protected]', 'J2wZAoU9', 8430582498);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('88-6745831', 'Geri', 'Lamps', '[email protected]', 'cMkb6nYp3QqL', 8752113874);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('53-8311062', 'Amelie', 'Domange', '[email protected]', 'lPXm5rU', 9700875551);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('40-6000773', 'Nathaniel', 'Kamenar', '[email protected]', 'NGiRx2uJ', 8946055438);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('79-5785052', 'Elianore', 'Carillo', '[email protected]', 'HDZappb', 8811201811);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('90-1356326', 'Colas', 'Points', '[email protected]', 'VqBA5mhqO', 8621024226);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('48-8860746', 'Darci', 'Lockery', '[email protected]', 'h2MXR563TyDK', 9947901709);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('36-1454817', 'Enrichetta', 'Lambertson', '[email protected]', 'hyWn5s6RiE', 8725777827);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('62-7474816', 'Kurt', 'Blasing', '[email protected]', 'JDAbZYYMU7', 8702159181);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('50-0401104', 'Paulette', 'Getch', '[email protected]', 'lm43NIIC', 9533044844);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('71-3456152', 'Titus', 'Capnerhurst', '[email protected]', '5IIksD', 8060531878);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('10-7314600', 'Nora', 'Standell', '[email protected]', 'fISrvmYoPrGl', 8684805231);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('90-2563093', 'Alfreda', 'Filov', '[email protected]', 'vZ72x7', 9340561320);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('47-7143561', 'Emelen', 'Renison', '[email protected]', 'ZubQ2d97v', 9759077692);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('68-6505277', 'Johnette', 'Bebb', '[email protected]', 'Xr9rbWND', 8036589655);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('29-0523720', 'Jewelle', 'Cullon', '[email protected]', 'CwtdydB', 8468478764);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('52-8518766', 'Dewey', 'Andriulis', '[email protected]', 'Zq1XSK', 8923388318);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('30-0489532', 'Bryna', 'Pieroni', '[email protected]', 'JQ2xY8v', 9163913755);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('95-3168817', 'Anthe', 'Jikovsky', '[email protected]', 'xMh3OMy', 8406256710);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('34-7624827', 'Tybalt', 'Really', '[email protected]', 'zvJU3mFIOFX6', 8438946232);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('50-7738999', 'Daveta', 'Jonson', '[email protected]', 'USie0gyJA00l', 9511560831);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('11-8976038', 'Glennie', 'Crowder', '[email protected]', '0UrsncMtTS', 8389943716);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('14-7997293', 'Monah', 'Bryde', '[email protected]', '4cPrZxxyTK', 9436152677);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('24-7731717', 'Karyn', 'Morcombe', '[email protected]', 'anVUsqkk6g', 9652317097);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('11-2897836', 'Hunt', 'Hrinchishin', '[email protected]', 'MX34rlkwbqL', 9183899285);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('44-9981787', 'Ainslie', 'Gosnoll', '[email protected]', 'RpGhn4EAZP', 9399663164);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('10-6869132', 'Jefferey', 'Dufour', '[email protected]', 'zrKCf4J', 9989766764);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('81-3312573', 'Yuri', 'Craddy', '[email protected]', '1OeGC2xa', 8570802690);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('36-6109221', 'Clevey', 'Hawsby', '[email protected]', 'nJMlQEXR', 8381460943);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('83-5147640', 'Arnie', 'Conre', '[email protected]', 'WjYbdUETe', 9548292288);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('41-6703059', 'Tandy', 'Caudrey', '[email protected]', 'mof9zSt1d9', 9559940918);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('78-1103914', 'Emilie', 'Caramuscia', '[email protected]', 'J0iSShVbUFu', 8580011552);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('73-3434934', 'Spike', 'Habbal', '[email protected]', '00jmowlGb7', 9904764906);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('85-0646851', 'Jeno', 'Mutimer', '[email protected]', 'HOk53i', 8764194720);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('01-6398724', 'Anthea', 'Cornbell', '[email protected]', 'QPzK4qc', 9329803468);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('86-1131059', 'Alphonso', 'Keerl', '[email protected]', 'ASkR5fE', 8288035518);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('25-3814326', 'Olly', 'Hakonsen', '[email protected]', 't3cHOiFW', 9354774404);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('04-3605195', 'Gardie', 'Klos', '[email protected]', '8LKssxd', 9620029635);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('45-5954550', 'Rosco', 'Buss', '[email protected]', 'qQntf00L', 8821487813);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('72-2823965', 'John', 'Castagnet', '[email protected]', '4RNk24P', 9921687184);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('23-7297268', 'Shellie', 'Wickham', '[email protected]', '97mAgPH', 9392361414);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('36-2319970', 'Dodi', 'Digwood', '[email protected]', 'bAi2Wj', 8148404487);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('11-2377904', 'Reeba', 'Yacobsohn', '[email protected]', 'C777Uz2s', 8589441180);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('98-1246293', 'Goldina', 'Reveley', '[email protected]', 'qE6VdULis2f', 8738814706);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('08-0049258', 'Melessa', 'Barabisch', '[email protected]', 'LzJBiLb', 9015746895);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('38-4605223', 'Stevie', 'Gimson', '[email protected]', '4k4dDJIk', 8951172210);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('61-7690680', 'Henri', 'Penwright', '[email protected]', 'vXxhXMt', 9126622283);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('34-0614419', 'Jania', 'Raff', '[email protected]', '6cTTDHNLzm', 9956362221);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('61-5113400', 'Katerina', 'Kits', '[email protected]', 'l8mthNlR', 8689135294);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('00-8022402', 'Silvio', 'Clapton', '[email protected]', '3YNqZPm', 8581389186);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('10-6823179', 'Sharia', 'Yuryev', '[email protected]', 'g3N8rZK', 8045997105);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('53-8123241', 'Dusty', 'Iltchev', '[email protected]', 'gNznbeJtc', 8823587319);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('67-1723194', 'Shawna', 'Guiso', '[email protected]', '0CMKAU', 9263155427);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('80-7010416', 'Maurie', 'Marrill', '[email protected]', '4t7QdKOVNEti', 9818996211);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('08-4028635', 'Saundra', 'Wilflinger', '[email protected]', '3FG9lmRu0hO', 9304272335);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('34-8659644', 'Kimbell', 'Rozet', '[email protected]', 'HAkXJ1sHoOS', 9464514161);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('90-4510715', 'Tomlin', 'Bretherton', '[email protected]', 'rkV08Kpmjfh', 9384893590);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('83-1464917', 'Karel', 'Bonehill', '[email protected]', 'ep4dYPfjmaxW', 8363915379);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('61-1988251', 'Brion', 'Gleadhall', '[email protected]', '2fTM0ST', 8713724536);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('59-0187257', 'Nickolas', 'Brownsworth', '[email protected]', 'zuryW9ymlFa', 8578738115);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('56-4970955', 'Letta', 'Caldairou', '[email protected]', 'SseMSH0pmp8', 9230650526);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('70-5537551', 'Meryl', 'Saltsberger', '[email protected]', 'bWf0CDg', 8479296926);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('47-7321387', 'Teodor', 'Clayworth', '[email protected]', '2NlWHObOg', 8260860154);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('21-0163475', 'Gwenny', 'Sherreard', '[email protected]', 'oTXyG6i', 8929451275);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('45-1891784', 'Alvina', 'Cheesman', '[email protected]', 'kKOyKb', 9067749370);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('38-4588306', 'Regen', 'Loy', '[email protected]', 'LsyX8F', 9214481947);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('19-4444469', 'Bernarr', 'Passler', '[email protected]', '1ei06d', 9802765553);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('35-2422502', 'Sascha', 'Germaine', '[email protected]', 'yQry1YgtVS', 9968733287);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('04-9718586', 'Vassily', 'Sayward', '[email protected]', 'rubml4WKh', 8444372635);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('87-1122290', 'Tiebout', 'Tapin', '[email protected]', 'pfCoVA2sRy', 9626022070);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('58-8354169', 'Fan', 'Taunton.', '[email protected]', 'qZZEWbJz', 9730167474);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('33-2944376', 'Jamaal', 'Preene', '[email protected]', 'T41dkv', 8383077371);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('52-1952712', 'Callie', 'Dauney', '[email protected]', '1wPDkvL8', 9719358755);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('74-4936777', 'Isiahi', 'Carty', '[email protected]', 'vf4ZYDh', 9034922610);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('53-3007865', 'Murielle', 'Antley', '[email protected]', 'UwYBm0C', 8470346949);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('46-1131231', 'Thayne', 'De Atta', '[email protected]', 'mRQy3ajwfDVL', 8172796288);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('34-5600795', 'Conney', 'Dorey', '[email protected]', 'gayz8hF', 8343852414);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('12-2404797', 'Muffin', 'Parcall', '[email protected]', 'Q60k4gNt', 8619585203);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('31-9474418', 'Giffard', 'Tantrum', '[email protected]', 'SAUtiI5s', 9419406920);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('74-7800970', 'Cosette', 'Wildish', '[email protected]', '0ZhXaW', 8590792314);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('90-9642568', 'Berne', 'Bony', '[email protected]', 'pooA5Suiul', 9754274545);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('94-9104072', 'Royal', 'Innocent', '[email protected]', 'gSKoCO7ZrY', 8127225450);
insert into Admin (Aid, AFirstname, ALastname, Aemail, Apwd, Aphone) values ('15-8472258', 'Stillman', 'Pembery', '[email protected]', 'WGsdJZ5j0hk', 9484799997);
select * from Admin;
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Nollie', 'Wloch', '[email protected]', 'U422zUFG3', 'Suite 33', 8216480204, '1988-02-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Timothee', 'Dargavel', '[email protected]', 'Q13GCI6Q0T', '2nd Floor', 8397232097, '2003-06-29');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Aksel', 'Bretherton', '[email protected]', 'ws6lEH6SvL', '20th Floor', 9732863403, '1994-07-31');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Richy', 'Sirrell', '[email protected]', '7RYc6EuC4', 'Room 844', 9954378572, '1988-05-11');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Mindy', 'Hulburd', '[email protected]', 'zbmqo4xnJCF', 'PO Box 9431', 9694490107, '1991-04-03');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Ewan', 'Sowman', '[email protected]', 'HLe0WSAsuflc', 'Apt 1892', 9713158639, '2002-10-13');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Davon', 'Edmundson', '[email protected]', 'ZllYymXWh9', 'Room 1410', 9789386836, '1977-10-28');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Raimund', 'Malimoe', '[email protected]', 'FUvMSN9CO', 'PO Box 51621', 9571830226, '1981-08-23');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Annabell', 'Strephan', '[email protected]', '0q1U4Am5M', 'Apt 454', 9063729781, '1993-11-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Gustave', 'Spencook', '[email protected]', 'JfpuIkyQZ', 'Room 1873', 9839621439, '1995-07-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Germayne', 'Hampton', '[email protected]', 'Lh6e922k', 'Room 709', 9133206678, '1977-04-07');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Cleve', 'Kroon', '[email protected]', 'eO6V5yUEKuLe', '16th Floor', 8938333137, '1996-06-21');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jonie', 'Dunthorn', '[email protected]', 'vqwJMcf', 'Room 1918', 9953082005, '2003-07-05');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Nerty', 'Alner', '[email protected]', 'WShV5f9', 'PO Box 73664', 8947746311, '1977-12-07');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Robinetta', 'Pim', '[email protected]', 'c4L17OrU', 'Room 254', 9052618573, '1999-11-12');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Siward', 'Conneely', '[email protected]', 'W0jYa0RX1e', '14th Floor', 9420234539, '1999-12-26');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Quinlan', 'Rioch', '[email protected]', 'LA8gW19bfxP', 'Apt 1229', 9986217305, '1995-08-10');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Othella', 'Zanettini', '[email protected]', 'Ea1OOLDAQp', '13th Floor', 8698780745, '1985-01-29');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Cissy', 'Labusquiere', '[email protected]', 'YhpVoVtxJ', 'PO Box 45161', 9865432222, '1993-01-07');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Thorpe', 'Grosier', '[email protected]', 'P4lhACyPPe7', '2nd Floor', 9122189929, '1988-03-07');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Parnell', 'Pendlenton', '[email protected]', '2YPuLVS6WX', 'PO Box 49903', 9567312710, '2000-04-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Eachelle', 'Bauldrey', '[email protected]', 'x7kqwJpIY', 'PO Box 93075', 9168271929, '1981-05-23');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jarred', 'Scapelhorn', '[email protected]', '0ICG430mI6hF', 'Suite 3', 9188099526, '1975-06-10');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Sukey', 'Bedbury', '[email protected]', 'YAoFB8NAnbDk', 'Suite 31', 8628028036, '1993-09-13');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Pacorro', 'Szapiro', '[email protected]', 'Ojo7PVa', 'Room 203', 9250499014, '1995-09-19');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Melba', 'Foan', '[email protected]', 'YaGxwyeFvUyt', 'Room 1769', 9926531493, '1982-09-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Javier', 'Holbury', '[email protected]', 'RE3vwP', 'Room 182', 8570180582, '1988-01-15');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Gisela', 'Cusiter', '[email protected]', 'lflVnwJAVAFT', 'Apt 1470', 9723770598, '1983-04-25');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Nessi', 'Turfus', '[email protected]', 'oz04Xj6', '20th Floor', 8200883092, '1981-12-09');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Consuela', 'Raffon', '[email protected]', 'zHenM4zXX', 'PO Box 79476', 9648945586, '1984-06-08');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Rusty', 'Trenoweth', '[email protected]', 'V647Ies1l', 'Suite 51', 9406622649, '1989-04-26');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Afton', 'Murch', '[email protected]', 'TCcBF5outQ', 'Apt 1252', 8959734495, '1987-09-14');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Bronnie', 'Grigoryev', '[email protected]', 'uwwUTYnRE', '2nd Floor', 8464285821, '1987-03-24');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Boothe', 'Triplet', '[email protected]', 'pFQC6e', '17th Floor', 8550527341, '2003-04-21');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Mano', 'McPartlin', '[email protected]', 'pKevapf', 'Room 1681', 8539553383, '1993-07-01');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Ajay', 'Jedrzej', '[email protected]', 'iwle7ldj', '7th Floor', 8061722379, '1979-11-05');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Itch', 'Heinreich', '[email protected]', 'vD4jUx0D', 'Suite 16', 8395943358, '1993-05-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Katey', 'Applewhite', '[email protected]', 'N8WQSMh40n', 'Apt 1442', 9992823964, '1989-02-18');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Eada', 'Basketfield', '[email protected]', '1gRUMF', 'Room 1947', 8443653133, '1998-04-17');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Valentine', 'Benedikt', '[email protected]', '1msTKCvT', 'Suite 28', 8423407960, '1996-05-31');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Una', 'Addey', '[email protected]', 'HbmfpHnzA', 'PO Box 81270', 9029809186, '1983-04-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Helen-elizabeth', 'Grindley', '[email protected]', 'XTcsik0BbWUe', 'PO Box 53310', 8681199088, '1993-03-10');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jedediah', 'Le Jean', '[email protected]', '8viIBgiejk', 'Suite 28', 9263512749, '1976-01-23');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Salomi', 'Cremer', '[email protected]', 'f4ovMGOZlFDa', 'PO Box 56485', 8655963488, '2003-12-28');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Edsel', 'Nayer', '[email protected]', 'Afp2GL1', '5th Floor', 9174749488, '1994-08-25');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Hildagard', 'Monelli', '[email protected]', 'Rlc0WR2bl', 'PO Box 44845', 8035676756, '2004-03-20');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Iggy', 'Van Salzberger', '[email protected]', 'bWuiv9ljWm', 'Room 874', 9519168754, '1978-05-18');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Willem', 'Gannan', '[email protected]', 'eKtmAttKhSqH', 'Apt 1473', 9961443863, '1998-08-25');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Ignazio', 'Jiruca', '[email protected]', 'ExCA08ioqQQ', 'Room 201', 9608699813, '2000-09-04');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Pieter', 'Edgar', '[email protected]', 'TW4LIUOx', '15th Floor', 8176220496, '1983-07-02');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Elane', 'Horley', '[email protected]', '2bodfIl17E', 'Suite 89', 8185488393, '1990-06-26');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Christie', 'Losty', '[email protected]', '9pxR7FTPxZ41', 'Suite 22', 8973698741, '1980-01-30');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Mario', 'Death', '[email protected]', 'hvfX7p8Rd5', 'Apt 844', 8937472978, '1978-01-17');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Kristyn', 'Bruun', '[email protected]', 'bakFt1GQdy', 'PO Box 86763', 9992882462, '1981-09-20');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jessamyn', 'Kernes', '[email protected]', 'flzz2OjdeK3V', 'PO Box 37037', 8013254376, '1998-07-14');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Iolande', 'Binner', '[email protected]', 'VdmjBwzOVxJA', 'Room 986', 8661265713, '2002-08-18');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Vlad', 'Churchin', '[email protected]', 'UQIcLd', '13th Floor', 9856494484, '2001-02-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Georgette', 'Mattes', '[email protected]', 'w91fxJRq1', 'PO Box 69918', 9050425705, '1996-09-23');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Cherish', 'Ghelarducci', '[email protected]', 'Sy4GF6', '4th Floor', 9529462800, '1989-12-20');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Feliks', 'Tennant', '[email protected]', 'yR8sNHk7V', 'Apt 1698', 8866584742, '1992-10-30');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Demetris', 'Walasik', '[email protected]', 'QbCw9rQ7tE', 'Apt 209', 8289520680, '1985-02-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Neil', 'Willmott', '[email protected]', '9Pg7bmdEa9', 'PO Box 50306', 8486564141, '1975-04-04');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Vanni', 'Kuhnel', '[email protected]', 'CQThSiDbosPo', 'Apt 458', 8176307448, '1996-01-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Sharline', 'Herculeson', '[email protected]', '6zoJpWDhdqp8', 'PO Box 41749', 8149845405, '1996-12-22');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Randy', 'Canto', '[email protected]', '8hLtsKEP', 'Room 213', 9225460700, '1984-09-28');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Ermentrude', 'Botham', '[email protected]', '4iW7vxnf', 'Apt 19', 8107377149, '1990-11-17');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jareb', 'Milam', '[email protected]', '9IqV16y4u', 'Apt 957', 9830315311, '2001-09-15');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Keene', 'Ablott', '[email protected]', 'DUEGcwH', 'Suite 94', 8908872743, '1990-05-28');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Yanaton', 'Cuff', '[email protected]', '4unD7C', 'Room 1105', 8374412838, '1981-09-15');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Dorothea', 'Deards', '[email protected]', 'TLOSGktLWZxY', 'Room 1707', 8151538467, '1985-02-06');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Marlee', 'Gariff', '[email protected]', 'r8LFmN9', 'PO Box 37392', 9168863334, '1975-10-03');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Felizio', 'Speariett', '[email protected]', 'oQa3YAy', 'Apt 1866', 8792381251, '1995-02-19');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Fanchette', 'Churchlow', '[email protected]', 'zkoyK19Q', 'PO Box 11145', 8262605562, '1991-10-18');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Ailis', 'Follet', '[email protected]', 'NoraJQ0RMbdX', 'Suite 25', 8347857086, '1990-12-05');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Kory', 'Guilford', '[email protected]', 'wNiITV', '18th Floor', 8933137435, '1982-08-20');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Fidelio', 'Oxtiby', '[email protected]', '8qQgIpZNzc', 'Suite 39', 9502900958, '2003-12-31');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Georg', 'Fricker', '[email protected]', 'sDsWvuLF', 'Suite 95', 9531225342, '1987-07-05');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Hamilton', 'Brigham', '[email protected]', '9Hi5iTC', 'Room 1391', 8897665127, '2000-07-27');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Lura', 'Aggott', '[email protected]', 'Yi8Q9QVgB', 'Apt 569', 8281708267, '1989-11-12');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jolee', 'Vasilchikov', '[email protected]', '02KDBvh', 'Suite 83', 8536250315, '1976-09-18');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Kennie', 'Rubens', '[email protected]', 'bco6KJKotvm5', 'PO Box 5263', 8205868669, '2003-07-19');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Abramo', 'Boothby', '[email protected]', 'pUTqKn0uxbbx', 'Room 806', 8239560043, '1995-12-04');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Lezlie', 'Steenson', '[email protected]', 'E0EzXXa', 'PO Box 34927', 9117938689, '1987-04-19');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Louie', 'Baccup', '[email protected]', 'nyorqkRZ2', 'PO Box 49893', 8282577399, '1986-04-06');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Nannette', 'Seakings', '[email protected]', 'FNGgE1odeX', '15th Floor', 9949565276, '1995-09-30');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Jess', 'Fiske', '[email protected]', 'X1ID3kIuv', 'Apt 856', 8349287572, '1995-09-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Kev', 'Kensitt', '[email protected]', 'k3CDo5HS', 'Apt 1880', 9533238949, '2000-10-13');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Amalle', 'Plom', '[email protected]', 'xSN92vO', 'Room 1322', 9288117065, '2002-11-28');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Samson', 'Cromb', '[email protected]', 'G95KFq', 'PO Box 71178', 9801758448, '1983-04-06');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Nicko', 'Germon', '[email protected]', 'KPzKZIc17H', 'Room 1250', 8379434697, '1986-03-07');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Thebault', 'Fallis', '[email protected]', 'zfcY6sSg2MT', 'Apt 271', 8915325465, '1989-03-06');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Julina', 'Stoop', '[email protected]', '7mjzfn', 'Suite 29', 8533721947, '1997-01-09');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Heriberto', 'Pues', '[email protected]', '7r09cbH', 'Suite 75', 8743195841, '1996-03-16');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Taite', 'Hanscome', '[email protected]', 'LSrttI', 'Room 1232', 9572838532, '2002-09-15');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Deloria', 'Veregan', '[email protected]', 'AmXgn5RgV', 'PO Box 2385', 9716366357, '2001-04-06');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Cyndia', 'Hauxby', '[email protected]', '0cxe8qOTaYcG', 'PO Box 53884', 8610319575, '1983-03-13');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Marcus', 'Cuvley', '[email protected]', 'DwusvG0ktP', 'Suite 97', 8691482729, '1984-03-10');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Aland', 'Griffey', '[email protected]', 'esgb1p', 'Apt 71', 8222681140, '1976-07-15');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Alexine', 'Antognelli', '[email protected]', 'PqaQpL643', 'Apt 173', 9002219327, '1986-12-21');
insert into User ( Ufirstname, ULastname, Uemail, Upwd, Uaddr, Uphone, Udob) values ( 'Dacy', 'Cornelissen', '[email protected]', 'mGluLy', 'Room 532', 8593216413, '1996-01-29');
select * from User;
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Pepsi - 600ml', 745, 'Grocery', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Flour - All Purpose', 998, 'Grocery', 'Available', 25);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Beer - Blue Light', 829, 'Grocery', 'Available', 11);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Paper - Brown Paper Mini Cups', 303, 'Grocery', 'High Demand', 18);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Water - Perrier', 432, 'Grocery', 'Available', 29);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Petite Baguette', 708, 'Grocery', 'Available', 19);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Salmon Steak - Cohoe 6 Oz', 441, 'Grocery', 'Available', 18);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sauce - White, Mix', 251, 'Grocery', 'High Demand', 27);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bok Choy - Baby', 339, 'Grocery', 'Available', 28);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Veal - Nuckle', 608, 'Grocery', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Pumpkin', 413, 'Grocery', 'Available', 24);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Beef - Texas Style Burger', 532, 'Grocery', 'High Demand', 30);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Veal - Insides Provini', 324, 'Grocery', 'Available', 18);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Pepper - White, Whole', 858, 'Grocery', 'Available', 15);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Soup - Verve - Chipotle Chicken', 394, 'Grocery', 'Available', 12);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Wine - Saint Emilion Calvet', 392, 'Grocery', 'High Demand', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dc Hikiage Hira Huba', 950, 'Grocery', 'Available', 12);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Jameson Irish Whiskey', 809, 'Grocery', 'Available', 17);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Seedlings - Buckwheat, Organic', 505, 'Grocery', 'Available', 14);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Chocolate - Dark Callets', 419, 'Grocery', 'Available', 19);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Flower - Dish Garden', 738, 'Grocery', 'Available', 29);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Ham - Smoked, Bone - In', 771, 'Grocery', 'Available', 21);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Salt - Table', 695, 'Grocery', 'Available', 35);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Mcgillicuddy Vanilla Schnap', 444, 'Grocery', 'High Demand', 27);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Muffin - Zero Transfat', 599, 'Grocery', 'Available', 20);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Cheese - Blue', 769, 'Grocery', 'Available', 35);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bread - Olive', 327, 'Grocery', 'Available', 21);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Juice - Clamato, 341 Ml', 265, 'Grocery', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Capers - Pickled', 674, 'Grocery', 'Available', 12);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Carbonated Water - Lemon Lime', 887, 'Grocery', 'Available', 25);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bread Fig And Almond', 862, 'Grocery', 'High Demand', 25);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bread - Crumbs, Bulk', 800, 'Grocery', 'Available', 18);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Tea - Herbal - 6 Asst', 693, 'Grocery', 'Available', 11);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bamboo Shoots - Sliced', 817, 'Grocery', 'Available', 29);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Chestnuts - Whole,canned', 750, 'Grocery', 'Available', 16);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bread - Petit Baguette', 256, 'Grocery', 'Available', 13);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Pastry - Apple Muffins - Mini', 992, 'Grocery', 'High Demand', 12);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Wine - Sawmill Creek Autumn', 421, 'Grocery', 'Available', 13);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Mussels - Frozen', 454, 'Grocery', 'Available', 32);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Napkin White - Starched', 779, 'Grocery', 'Available', 31);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Q', 3551320, 'Car', 'High Demand', 6);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('TL', 1952243, 'Car', 'Available', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('DeVille', 509060, 'Car', 'Available', 6);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('X5', 4219661, 'Car', 'Available', 7);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Taurus X', 1949676, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Allroad', 3858756, 'Car', 'Available', 4);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Impala', 2342688, 'Car', 'Available', 5);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('500SEL', 4038226, 'Car', 'Available', 5);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Town Car', 816872, 'Car', 'Available', 2);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Prowler', 2066335, 'Car', 'High Demand', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('SLS AMG', 4203165, 'Car', 'Available', 4);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Escort', 1533687, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Corvette', 1589853, 'Car', 'Available', 2);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Rapide', 2061443, 'Car', 'High Demand', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Yukon XL 1500', 4460991, 'Car', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Tacoma', 851499, 'Car', 'Available', 7);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('530', 1770775, 'Car', 'Available', 4);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('8 Series', 2091697, 'Car', 'Available', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('GS', 1433129, 'Car', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('300', 4654876, 'Car', 'Available', 7);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Ridgeline', 3702967, 'Car', 'Available', 4);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('S4', 1564661, 'Car', 'Available', 2);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Camry', 2576303, 'Car', 'Available', 7);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('929', 2887167, 'Car', 'Available', 7);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sable', 553385, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('M5', 2334629, 'Car', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Premier', 2645944, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Suburban 1500', 4712705, 'Car', 'High Demand', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sonata', 3767602, 'Car', 'Available', 10);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Laser', 657837, 'Car', 'Available', 2);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sonoma', 2815785, 'Car', 'Available', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Altima', 1059522, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('H3T', 3112095, 'Car', 'Available', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('1500', 2905037, 'Car', 'Available', 5);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('RL', 2480651, 'Car', 'Available', 2);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Mark VIII', 1078228, 'Car', 'High Demand', 3);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Grand Vitara', 845035, 'Car', 'Available', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Suburban 1500', 4152794, 'Car', 'High Demand', 4);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('S80', 3931045, 'Car', 'High Demand', 8);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('C-Class', 4070964, 'Car', 'High Demand', 9);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dragon Ball Z)', 833, 'Novel', 'Available', 83);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Ferngully: The Last Rainforest', 2336, 'Novel', 'High Demand', 82);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Getting Any? (Minnâ-yatteruka!)', 4033, 'Novel', 'High Demand', 66);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('One Nation Under God ', 4911, 'Novel', 'Available', 70);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Planes, Trains & Automobiles', 4521, 'Novel', 'Available', 89);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Document of the Dead', 3935, 'Novel', 'Available', 75);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Saw VI', 1778, 'Novel', 'Available', 44);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bullet for a Badman (Renegade Posse)', 2734, 'Novel', 'Available', 66);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Futurama: The Beast with a Billion Backs', 3384, 'Novel', 'Available', 73);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Two: The Story of Roman & Nyro', 2632, 'Novel', 'High Demand', 45);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Klansman, The', 3791, 'Novel', 'Available', 30);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Abominable', 4499, 'Novel', 'Available', 37);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Vidal Sassoon: The Movie', 4659, 'Novel', 'Available', 62);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bronx Tale, A', 2072, 'Novel', 'Available', 93);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Home', 305, 'Novel', 'Available', 79);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Caught Inside', 1709, 'Novel', 'Available', 57);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Zorro, the Gay Blade', 2670, 'Novel', 'Available', 92);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Romeo Is Bleeding', 1396, 'Novel', 'Available', 97);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Your Highness', 3872, 'Novel', 'Available', 40);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Ride Lonesome', 2075, 'Novel', 'Available', 41);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Four Brothers', 2452, 'Novel', 'High Demand', 45);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Onibi: The Fire Within', 2434, 'Novel', 'Available', 86);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Fallen, The', 2733, 'Novel', 'Available', 62);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('300', 286, 'Novel', 'Available', 52);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Star Trek: Nemesis', 4653, 'Novel', 'Available', 68);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Giliap', 246, 'Novel', 'Available', 98);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dracula Untold', 1127, 'Novel', 'Available', 77);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Grey Gardens', 1720, 'Novel', 'Available', 88);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Feast III: The Happy Finish', 898, 'Novel', 'Available', 55);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sokkotanssi', 640, 'Novel', 'Available', 64);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('American Psycho', 3468, 'Novel', 'Available', 89);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Stigmata', 1324, 'Novel', 'Available', 78);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('One 2 Ka 4', 4759, 'Novel', 'Available', 53);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('The Diary of a Teenage Girl', 1392, 'Novel', 'Available', 54);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Last Metro, The (Dernier métro, Le)', 649, 'Novel', 'Available', 70);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Chameleon, The ', 1713, 'Novel', 'Available', 33);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bride Wore Black, The (La mariée était en noir)', 2099, 'Novel', 'Available', 60);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Safety Not Guaranteed', 2483, 'Novel', 'Available', 49);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dog Pound', 4512, 'Novel', 'Available', 39);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Vuonna 85', 2961, 'Novel', 'Available', 62);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Psophocarpus', 763, 'Plants', 'Available', 30);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Lowland Rotala', 156, 'Plants', 'Available', 63);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Cecidonia Lichen', 390, 'Plants', 'Available', 63);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Mudmats', 703, 'Plants', 'Available', 77);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Koch''s Entosthodon Moss', 921, 'Plants', 'Available', 72);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Antilles Clearweed', 944, 'Plants', 'Available', 75);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Twocolor Sedge', 876, 'Plants', 'Available', 70);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Mono Hot Springs Evening Primrose', 759, 'Plants', 'Available', 41);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Schaffner''s Spikerush', 702, 'Plants', 'Available', 98);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sierra Hare Sedge', 766, 'Plants', 'Available', 38);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bristly Scaleseed', 996, 'Plants', 'Available', 37);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Harper''s Beaksedge', 127, 'Plants', 'Available', 68);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Cottonrose', 214, 'Plants', 'High Demand', 54);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Western Azalea', 979, 'Plants', 'Available', 75);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Rio Grande Lovegrass', 501, 'Plants', 'Available', 51);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Field Pussytoes', 500, 'Plants', 'Available', 41);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Drooping Sedge', 554, 'Plants', 'Available', 36);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Indian Anoda', 594, 'Plants', 'Available', 84);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dwarf Umbrella Tree', 304, 'Plants', 'Available', 39);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Annual Clary', 268, 'Plants', 'Available', 77);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Markhamia', 700, 'Plants', 'Available', 99);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Hairy Horsebrush', 891, 'Plants', 'Available', 79);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Bristly Matilija Poppy', 375, 'Plants', 'Available', 57);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Chaparral Pea', 864, 'Plants', 'Available', 80);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Dimpled Troutlily', 712, 'Plants', 'Available', 88);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Yellowflower Locoweed', 739, 'Plants', 'High Demand', 79);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Lassen Sandverbena', 699, 'Plants', 'Available', 95);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Marang', 143, 'Plants', 'Available', 52);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Stirtonia Lichen', 687, 'Plants', 'Available', 49);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Oregon Violet', 599, 'Plants', 'High Demand', 84);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Sticky Cinquefoil', 905, 'Plants', 'High Demand', 99);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Rigid Stripeseed', 933, 'Plants', 'Available', 48);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Michigan Monkeyflower', 738, 'Plants', 'Available', 66);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Walnut Spleenwort', 853, 'Plants', 'High Demand', 85);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Yellow Spinecape', 970, 'Plants', 'Available', 100);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Andreaea Moss', 980, 'Plants', 'Available', 93);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Fewflower Blazing Star', 279, 'Plants', 'Available', 77);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Branching Phacelia', 876, 'Plants', 'High Demand', 47);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Drumheads', 485, 'Plants', 'Available', 58);
insert into Product (Prname, Prprice, Prcategory, Prstatus, Prunits) values ('Neverdie', 687, 'Plants', 'High Demand', 47);
select * from Product;
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Noni', 'Carnell', '[email protected]', 'dNo1gZj4v6w', '82023 Pennsylvania Center', 9853102743, 10513, 984300870458, '1979-09-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Danni', 'Pashen', '[email protected]', 'FOQkcDAt', '3 Lighthouse Bay Street', 8798898298, 10833, 656628504474, '1987-03-28');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Bili', 'Ricciardiello', '[email protected]', '4oPZWufOsc', '3704 Butternut Terrace', 8385381084, 14170, 197295081215, '1993-12-13');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Bartolomeo', 'Dumbleton', '[email protected]', 'yYy64K', '1 Annamark Terrace', 7933303733, 14550, 356484679479, '1991-09-27');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Fabio', 'Duplan', '[email protected]', 'Stsfv2Z', '98338 Melby Trail', 8308452504, 14385, 259689817147, '1982-12-23');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Eula', 'Davidman', '[email protected]', 'KYCTanhSStZt', '22 Fordem Alley', 9561913533, 13836, 474144493377, '1990-11-10');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Carmita', 'Zoren', '[email protected]', 'eo7YvaxENx', '2 Delaware Park', 9080705945, 12396, 380781762668, '1979-10-20');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Leonardo', 'Withrop', '[email protected]', 'tVhRThZ', '9 Buhler Center', 9920250797, 12072, 654096611059, '2001-07-24');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Yuma', 'Pudney', '[email protected]', 'Sz8ynFAomnYk', '72 Pleasure Drive', 9107038360, 12027, 155839353289, '1983-02-23');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Benedetto', 'Ashment', '[email protected]', '6JNrvSZvVa4', '80941 Mariners Cove Hill', 8593355381, 13071, 274784030089, '1981-06-10');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Tiena', 'Mulvin', '[email protected]', '0mUNZaRHl0S', '792 Annamark Place', 9137100673, 10725, 692581897573, '1978-08-17');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Colette', 'Fransseni', '[email protected]', 'bqTN92WvJ', '8358 Oneill Junction', 9729149309, 12143, 610308838809, '1981-03-28');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Sol', 'Paulet', '[email protected]', 'vt8mEMPit', '4959 Moland Hill', 7988733830, 11163, 131776702751, '1996-05-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Imelda', 'Vuittet', '[email protected]', '2mMBDOZW', '0 Scofield Court', 8540623625, 14335, 150504695990, '1978-07-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Jaymee', 'Sudy', '[email protected]', 'Wz9OcPWr', '414 Arrowood Alley', 7968662800, 10665, 259688630312, '1988-11-14');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Reagen', 'Romer', '[email protected]', 'gWqwAkIsTn0', '2129 Kennedy Avenue', 8308025035, 12442, 105334243074, '1982-08-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Melva', 'Willgrass', '[email protected]', 'NPhtn7wE', '735 Warbler Pass', 9758662803, 10934, 325350286302, '1982-11-23');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Colleen', 'Stickler', '[email protected]', 'wvntDIX5d', '14 Gulseth Crossing', 9527621810, 10463, 966468788049, '1999-05-07');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Baldwin', 'Yosevitz', '[email protected]', 'l7OEvfRcCmk', '40 Crest Line Lane', 8748471866, 11490, 411232610780, '1988-08-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Prince', 'Rawlings', '[email protected]', 'p5O8nXzld6hh', '9309 Hoepker Crossing', 9857622695, 12726, 263968415046, '2004-10-30');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Lawton', 'Forstall', '[email protected]', 'SZJewFFZQm', '920 Elgar Avenue', 9202857566, 13147, 397154044309, '1999-08-26');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Hallsy', 'Baty', '[email protected]', 'rr8wdWW4', '29 Bayside Plaza', 9511971554, 14643, 609905637301, '2001-02-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Imogene', 'Mutch', '[email protected]', 'ufIzqi', '715 Oak Valley Avenue', 8168512826, 11912, 558374683511, '1986-03-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Chadwick', 'Heilds', '[email protected]', '3GAiA35J', '68680 Rowland Terrace', 9901451215, 14741, 394955780044, '2002-12-04');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Aimee', 'Presidey', '[email protected]', 'GqmWAcefq1ft', '73288 Talmadge Way', 9329205669, 13816, 484514655676, '1994-04-24');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Adolpho', 'Gummow', '[email protected]', 'ToPap8', '40037 Thierer Way', 8503136578, 12123, 385146858204, '1997-08-28');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Kenneth', 'Stannah', '[email protected]', 'lH1H8QC8lfU', '07 Pawling Pass', 9089378385, 13336, 958593184394, '1984-11-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Charmian', 'Elliot', '[email protected]', 'SOdUFrCAk', '3734 Loftsgordon Parkway', 7833316939, 13200, 975521837919, '1992-10-02');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Karoline', 'Schaumann', '[email protected]', '00Nd8SiY', '639 Welch Pass', 8426440012, 14110, 654790569174, '1988-04-13');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Lucie', 'Mattingson', '[email protected]', '5Ujyt0e', '9 Glacier Hill Circle', 9398122336, 13045, 735327221715, '2002-02-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Yelena', 'Scogin', '[email protected]', 'IhVWSMaQNBED', '444 Stephen Center', 9262998562, 14889, 749816622217, '1987-11-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Dalton', 'Haythorn', '[email protected]', 'Pu2FQJlkBfq8', '02 Spohn Court', 9813907238, 10406, 856370862265, '1983-03-11');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Engracia', 'Faragher', '[email protected]', 'KF3PcQGnU', '162 Veith Trail', 9115733297, 14460, 108767499605, '2001-08-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Doe', 'Levermore', '[email protected]', 'gYzWzkY', '7 Leroy Pass', 8749782870, 10386, 986813534487, '1986-04-06');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Witty', 'Loyd', '[email protected]', '6ILhcL7fw3J', '160 Dryden Pass', 8986469783, 12271, 751573356631, '2002-07-08');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Nathaniel', 'Dunnion', '[email protected]', '9fjuTvy', '38246 Northport Avenue', 7936810751, 11541, 482010721487, '1990-12-06');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ivan', 'Hughesdon', '[email protected]', 'A2U8NJ', '174 Kedzie Road', 9791356287, 13730, 270901278742, '2001-08-28');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Sascha', 'Nosworthy', '[email protected]', 'uyTyTNqH', '59 Arizona Pass', 8069469226, 11845, 548479098672, '1975-04-03');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ronnie', 'Peert', '[email protected]', 'obtO3iM', '8464 Susan Park', 8210106836, 14810, 745047342022, '1984-12-31');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Melonie', 'Hauxley', '[email protected]', 'WhU41TRz', '5820 Pleasure Avenue', 9102169877, 14371, 511423520267, '1980-09-17');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Dode', 'Rickards', '[email protected]', 'iRywIU', '94 Fieldstone Street', 8192682573, 14301, 342493189777, '1977-05-22');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ellissa', 'Bastone', '[email protected]', '8l6OCUWRbS', '97800 Dahle Way', 8188993166, 10130, 214574236157, '1978-08-29');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Maiga', 'Liebermann', '[email protected]', '3Hy97gR', '37013 Helena Pass', 9374043116, 14927, 199760060352, '2000-04-26');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Nelli', 'Purtell', '[email protected]', 'crbOe8yA2', '980 Harbort Avenue', 9450123653, 13128, 305318312381, '1977-06-08');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Welch', 'Canti', '[email protected]', '3qoRnraa', '69454 Ilene Parkway', 9990694778, 12345, 519090187389, '1980-06-25');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Wilfrid', 'McBrearty', '[email protected]', '9euCzQnhPvy', '58 Old Shore Circle', 8966355437, 10968, 761195850938, '1986-08-13');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Andeee', 'Lugg', '[email protected]', 'fMIoC2eE3', '8824 Esch Lane', 7833083505, 13012, 754625625831, '1975-03-04');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Sebastian', 'Rowswell', '[email protected]', '8LwzlN2fn', '2 Eastwood Alley', 9677951368, 10015, 315838104403, '1992-07-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Alano', 'Kenshole', '[email protected]', '17OibIqwiU', '0 Doe Crossing Circle', 8732001352, 11246, 536903506776, '1990-04-29');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Germana', 'Critchley', '[email protected]', 'pVVOIlZM', '68876 Declaration Trail', 8437658252, 10292, 711261702429, '1995-03-30');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Asa', 'Shergill', '[email protected]', 'RG6Gd2', '8958 Hoepker Crossing', 8576904287, 13167, 623905482602, '1994-01-21');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Newton', 'Dashkovich', '[email protected]', 'Up0jlm5g', '9232 Northview Parkway', 8646356662, 12014, 986034938000, '1982-06-16');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Burlie', 'Glede', '[email protected]', 'KM31gXE7', '50265 Center Place', 9701118160, 14576, 528800198100, '2000-07-26');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Arri', 'Faldo', '[email protected]', 'HYnUyPGvgiPi', '7688 Marquette Road', 9344219452, 10629, 194168083230, '1982-07-26');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Nonie', 'Baud', '[email protected]', 'q3zKOafyz9Ih', '51963 Towne Hill', 9225777898, 10047, 920803940931, '1978-06-30');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Calli', 'Hawtry', '[email protected]', 'LiulQNxq', '627 Monument Plaza', 8307923952, 12740, 550215198715, '1991-03-14');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Melody', 'Antowski', '[email protected]', 'NeZa5oZvSlM', '411 Porter Center', 9441644297, 10135, 993261406752, '1983-11-16');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Glynn', 'Anthony', '[email protected]', 'YftuRKUg4gQ8', '30777 Jenna Pass', 8670241341, 11626, 986882989700, '2001-12-17');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Elia', 'Dradey', '[email protected]', 'tJhbkB1NKIx', '08952 Grayhawk Center', 9744039884, 11731, 471391543909, '1992-12-18');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Dorey', 'Woodfine', '[email protected]', 'QhlDS5ZAEd', '81 Lake View Drive', 9530330437, 13950, 510316808096, '1978-08-09');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Layla', 'Callicott', '[email protected]', 'XtYyYm2e', '46 Center Park', 9237913797, 14588, 923672730378, '1982-12-23');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Caprice', 'Meneely', '[email protected]', 'oXRsvcU', '2259 Hagan Circle', 8497573209, 12020, 448868296625, '1995-04-05');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Rosalind', 'Odhams', '[email protected]', 'c6fLZKT', '7148 Harbort Center', 8607053589, 13938, 952552220018, '1976-10-02');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Rachele', 'Balazot', '[email protected]', 't304tTFSDp4', '549 Jay Hill', 8592360364, 14094, 675517949286, '1991-10-27');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Marcel', 'Letson', '[email protected]', 'fAyu8M', '81436 Oneill Alley', 9391903959, 14754, 671957440068, '2000-11-20');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Valma', 'Honeywood', '[email protected]', 'Ipdn30vVf', '77162 Morningstar Junction', 9946079769, 11327, 229012186319, '1988-11-28');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Hanni', 'Larder', '[email protected]', 'Uvlgzo4', '11824 Farmco Pass', 8016699269, 13642, 914061482714, '1990-01-01');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Harry', 'Beernaert', '[email protected]', 'B0cn84', '07809 Crowley Crossing', 8382597694, 10858, 828519593001, '2003-07-29');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Davy', 'Merrikin', '[email protected]', 'G0DDFcsASqvm', '6 Barnett Center', 8049956209, 14443, 635957717545, '1998-07-11');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Carlo', 'Pigne', '[email protected]', 'QLFNxNIuLZhE', '695 Warrior Trail', 9970395027, 11328, 847373421675, '2001-02-19');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Cleve', 'Teasey', '[email protected]', 'Q4wbYcvO', '9142 Bunker Hill Pass', 8894531898, 14030, 447276352854, '1999-08-31');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Aluino', 'Dilley', '[email protected]', 'BfnfHYbn8Zz', '89 Moland Terrace', 7868544286, 12387, 107353512734, '2001-06-16');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Cullan', 'Petrushkevich', '[email protected]', 'PpAy3AUaj2', '31570 Village Crossing', 9008833578, 12619, 363851611753, '1998-08-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Marcy', 'Jeandel', '[email protected]', 'Iy2IIcqJb1', '13 Farragut Terrace', 8405885781, 10958, 496092373619, '2000-11-22');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Abel', 'Sutter', '[email protected]', '4BYVO416qAb', '816 Dixon Road', 8807444430, 13403, 927600455165, '1991-03-21');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ardelis', 'McGeffen', '[email protected]', 'axg4hI', '95 Coleman Plaza', 8613675884, 11365, 381960835295, '1982-05-08');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Nathanial', 'Blagburn', '[email protected]', 'QvGyuZ9FsXbs', '6 Rigney Terrace', 8528284889, 13394, 292040464582, '1983-01-29');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Hasheem', 'Southworth', '[email protected]', 'slys92', '53273 Graceland Crossing', 9245510149, 14374, 766703481805, '2001-08-07');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Wilhelmine', 'Thwaites', '[email protected]', 'UuDttc0zAQZ8', '0177 Bobwhite Trail', 8467967279, 14028, 708218646884, '2003-04-06');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Kalli', 'Bolstridge', '[email protected]', 'cuElZX15', '43 Burning Wood Circle', 9145193203, 10946, 820119420339, '1981-05-30');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Marmaduke', 'Dibden', '[email protected]', 'jDwHS3DilN5s', '887 Autumn Leaf Circle', 7852665755, 13418, 906286718019, '1989-02-22');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Donia', 'Harsent', '[email protected]', 'WE9fnQbNXGy', '468 Stuart Pass', 9703787092, 14294, 157507494737, '2000-05-24');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Sherye', 'Dawson', '[email protected]', 'arA5LfWA3', '60 Ronald Regan Point', 8598550624, 11016, 235088093521, '2000-09-02');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Reinald', 'Sheaf', '[email protected]', 'nqns9OTfAz', '7589 Jenifer Avenue', 8618383935, 10552, 500496783824, '2001-02-22');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ursa', 'Stanistreet', '[email protected]', 'QTwPlPpfk', '5 Melody Plaza', 8101445995, 10121, 551051038717, '1984-08-11');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Alica', 'Riggulsford', '[email protected]', 'GgT7YlPKn', '1 Union Parkway', 9209754194, 11908, 471485044613, '1985-01-06');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Geoffry', 'Stoppe', '[email protected]', '4ta5VnlEQs', '1 Karstens Lane', 9505008279, 14313, 599216384671, '2003-01-01');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Merrilee', 'Kubes', '[email protected]', 'EdXXF1', '2575 Briar Crest Park', 8474312766, 14409, 411774222655, '1990-03-16');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Averyl', 'Hutcheson', '[email protected]', 'JO3bi2ajOQN', '43495 Atwood Terrace', 9311327910, 11425, 254901425820, '1983-08-26');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Dusty', 'Simoncelli', '[email protected]', 'SC6AwAgeO', '39944 Graceland Circle', 9606444196, 12815, 142365558967, '1994-11-20');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Uta', 'Lashley', '[email protected]', 'ndSYQF', '748 Longview Court', 9688577671, 12603, 346367724819, '1983-09-24');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Evaleen', 'Spanton', '[email protected]', 'AzCrxIzkHw', '7 Loftsgordon Plaza', 8205444240, 13566, 675596981698, '1984-11-11');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Putnam', 'O''Hederscoll', '[email protected]', 'H4W0A7tA', '8631 Corry Pass', 9949975614, 13498, 761301414665, '1985-09-12');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Christin', 'Spat', '[email protected]', 'TxnC7h4Wy', '7880 Sloan Crossing', 9157811272, 13502, 389104044467, '1983-07-29');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Crin', 'Tenby', '[email protected]', 'rmEa33HY7d98', '775 American Street', 9141641022, 10481, 912729657722, '1982-05-31');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Ermentrude', 'Litchmore', '[email protected]', '62Vel07u', '618 Sunnyside Park', 9597174613, 11602, 362527583026, '1978-01-05');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Cheri', 'Kmietsch', '[email protected]', 'z3R2ad4Lm', '51937 David Hill', 8145399659, 13933, 754038957630, '1990-11-10');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Sonni', 'Southwick', '[email protected]', 'vHjzpQM', '4 Sundown Trail', 9587006806, 11554, 407931214572, '1988-09-02');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Rycca', 'Van der Krui', '[email protected]', 'yBpDaltaCcop', '11 Packers Parkway', 9773172972, 12542, 557480522318, '2004-03-21');
insert into Deliveryperson ( DFirstname, DLastname, Demail, Dpwd, Daddr, Dphone, Dsalary, Daadhar, Ddob) values ( 'Tristam', 'Marczyk', '[email protected]', '0pETWwV59', '058 Bay Road', 9225881349, 10126, 471171963382, '1988-06-22');
select * from Deliveryperson;
insert into Oder (Oid, Uid, Deliverydate, Did) values (1, 100, '2022-05-17', 1);
insert into Oder (Oid, Uid, Deliverydate, Did) values (2, 99, '2022-11-30', 2);
insert into Oder (Oid, Uid, Deliverydate, Did) values (3, 98, '2022-08-21', 3);
insert into Oder (Oid, Uid, Deliverydate, Did) values (4, 97, '2022-04-03', 4);
insert into Oder (Oid, Uid, Deliverydate, Did) values (5, 96, '2022-12-03', 5);
insert into Oder (Oid, Uid, Deliverydate, Did) values (6, 95, '2022-12-06', 6);
insert into Oder (Oid, Uid, Deliverydate, Did) values (7, 94, '2023-01-23', 7);
insert into Oder (Oid, Uid, Deliverydate, Did) values (8, 93, '2023-01-29', 8);
insert into Oder (Oid, Uid, Deliverydate, Did) values (9, 92, '2022-08-03', 9);
insert into Oder (Oid, Uid, Deliverydate, Did) values (10, 91, '2022-10-16', 10);
insert into Oder (Oid, Uid, Deliverydate, Did) values (11, 90, '2022-08-24', 11);
insert into Oder (Oid, Uid, Deliverydate, Did) values (12, 89, '2022-05-02', 12);
insert into Oder (Oid, Uid, Deliverydate, Did) values (13, 88, '2022-09-13', 13);
insert into Oder (Oid, Uid, Deliverydate, Did) values (14, 87, '2022-07-14', 14);
insert into Oder (Oid, Uid, Deliverydate, Did) values (15, 86, '2022-07-31', 15);
insert into Oder (Oid, Uid, Deliverydate, Did) values (16, 85, '2023-03-07', 16);
insert into Oder (Oid, Uid, Deliverydate, Did) values (17, 84, '2022-12-23', 17);
insert into Oder (Oid, Uid, Deliverydate, Did) values (18, 83, '2023-03-11', 18);
insert into Oder (Oid, Uid, Deliverydate, Did) values (19, 82, '2023-03-18', 19);
insert into Oder (Oid, Uid, Deliverydate, Did) values (20, 81, '2022-10-16', 20);
insert into Oder (Oid, Uid, Deliverydate, Did) values (21, 80, '2022-12-10', 21);
insert into Oder (Oid, Uid, Deliverydate, Did) values (22, 79, '2022-06-22', 22);
insert into Oder (Oid, Uid, Deliverydate, Did) values (23, 78, '2022-12-07', 23);
insert into Oder (Oid, Uid, Deliverydate, Did) values (24, 77, '2023-03-11', 24);
insert into Oder (Oid, Uid, Deliverydate, Did) values (25, 76, '2022-08-30', 25);
insert into Oder (Oid, Uid, Deliverydate, Did) values (26, 75, '2022-06-14', 26);
insert into Oder (Oid, Uid, Deliverydate, Did) values (27, 74, '2022-07-04', 27);
insert into Oder (Oid, Uid, Deliverydate, Did) values (28, 73, '2022-11-26', 28);
insert into Oder (Oid, Uid, Deliverydate, Did) values (29, 72, '2022-07-12', 29);
insert into Oder (Oid, Uid, Deliverydate, Did) values (30, 71, '2023-01-28', 30);
insert into Oder (Oid, Uid, Deliverydate, Did) values (31, 70, '2023-01-11', 31);
insert into Oder (Oid, Uid, Deliverydate, Did) values (32, 69, '2022-06-19', 32);
insert into Oder (Oid, Uid, Deliverydate, Did) values (33, 68, '2022-04-25', 33);
insert into Oder (Oid, Uid, Deliverydate, Did) values (34, 67, '2023-03-07', 34);
insert into Oder (Oid, Uid, Deliverydate, Did) values (35, 66, '2022-03-24', 35);
insert into Oder (Oid, Uid, Deliverydate, Did) values (36, 65, '2023-01-22', 36);
insert into Oder (Oid, Uid, Deliverydate, Did) values (37, 64, '2022-06-04', 37);
insert into Oder (Oid, Uid, Deliverydate, Did) values (38, 63, '2022-06-30', 38);
insert into Oder (Oid, Uid, Deliverydate, Did) values (39, 62, '2023-02-07', 39);
insert into Oder (Oid, Uid, Deliverydate, Did) values (40, 61, '2022-12-30', 40);
insert into Oder (Oid, Uid, Deliverydate, Did) values (41, 60, '2022-11-08', 41);
insert into Oder (Oid, Uid, Deliverydate, Did) values (42, 59, '2022-12-10', 42);
insert into Oder (Oid, Uid, Deliverydate, Did) values (43, 58, '2023-01-11', 43);
insert into Oder (Oid, Uid, Deliverydate, Did) values (44, 57, '2022-08-21', 44);
insert into Oder (Oid, Uid, Deliverydate, Did) values (45, 56, '2022-08-04', 45);
insert into Oder (Oid, Uid, Deliverydate, Did) values (46, 55, '2022-12-06', 46);
insert into Oder (Oid, Uid, Deliverydate, Did) values (47, 54, '2022-10-25', 47);
insert into Oder (Oid, Uid, Deliverydate, Did) values (48, 53, '2022-10-05', 48);
insert into Oder (Oid, Uid, Deliverydate, Did) values (49, 52, '2022-08-06', 49);
insert into Oder (Oid, Uid, Deliverydate, Did) values (50, 51, '2022-03-21', 50);
insert into Oder (Oid, Uid, Deliverydate, Did) values (51, 50, '2022-11-02', 51);
insert into Oder (Oid, Uid, Deliverydate, Did) values (52, 49, '2023-02-13', 52);
insert into Oder (Oid, Uid, Deliverydate, Did) values (53, 48, '2022-10-16', 53);
insert into Oder (Oid, Uid, Deliverydate, Did) values (54, 47, '2022-11-25', 54);
insert into Oder (Oid, Uid, Deliverydate, Did) values (55, 46, '2022-12-20', 55);
insert into Oder (Oid, Uid, Deliverydate, Did) values (56, 45, '2023-01-09', 56);
insert into Oder (Oid, Uid, Deliverydate, Did) values (57, 44, '2022-04-30', 57);
insert into Oder (Oid, Uid, Deliverydate, Did) values (58, 43, '2023-02-18', 58);
insert into Oder (Oid, Uid, Deliverydate, Did) values (59, 42, '2022-08-18', 59);
insert into Oder (Oid, Uid, Deliverydate, Did) values (60, 41, '2022-11-04', 60);
insert into Oder (Oid, Uid, Deliverydate, Did) values (61, 40, '2022-03-27', 61);
insert into Oder (Oid, Uid, Deliverydate, Did) values (62, 39, '2022-03-29', 62);
insert into Oder (Oid, Uid, Deliverydate, Did) values (63, 38, '2023-03-02', 63);
insert into Oder (Oid, Uid, Deliverydate, Did) values (64, 37, '2022-07-19', 64);
insert into Oder (Oid, Uid, Deliverydate, Did) values (65, 36, '2022-12-05', 65);
insert into Oder (Oid, Uid, Deliverydate, Did) values (66, 35, '2022-08-05', 66);
insert into Oder (Oid, Uid, Deliverydate, Did) values (67, 34, '2023-02-12', 67);
insert into Oder (Oid, Uid, Deliverydate, Did) values (68, 33, '2022-07-17', 68);
insert into Oder (Oid, Uid, Deliverydate, Did) values (69, 32, '2022-07-18', 69);
insert into Oder (Oid, Uid, Deliverydate, Did) values (70, 31, '2023-02-24', 70);
insert into Oder (Oid, Uid, Deliverydate, Did) values (71, 30, '2022-05-06', 71);
insert into Oder (Oid, Uid, Deliverydate, Did) values (72, 29, '2022-09-15', 72);
insert into Oder (Oid, Uid, Deliverydate, Did) values (73, 28, '2022-04-20', 73);
insert into Oder (Oid, Uid, Deliverydate, Did) values (74, 27, '2022-04-09', 74);
insert into Oder (Oid, Uid, Deliverydate, Did) values (75, 26, '2023-01-21', 75);
insert into Oder (Oid, Uid, Deliverydate, Did) values (76, 25, '2022-10-30', 76);
insert into Oder (Oid, Uid, Deliverydate, Did) values (77, 24, '2022-12-13', 77);
insert into Oder (Oid, Uid, Deliverydate, Did) values (78, 23, '2022-09-21', 78);
insert into Oder (Oid, Uid, Deliverydate, Did) values (79, 22, '2022-05-19', 79);
insert into Oder (Oid, Uid, Deliverydate, Did) values (80, 21, '2022-09-19', 80);
insert into Oder (Oid, Uid, Deliverydate, Did) values (81, 20, '2022-08-19', 81);
insert into Oder (Oid, Uid, Deliverydate, Did) values (82, 19, '2022-11-28', 82);
insert into Oder (Oid, Uid, Deliverydate, Did) values (83, 18, '2022-10-09', 83);
insert into Oder (Oid, Uid, Deliverydate, Did) values (84, 17, '2022-10-18', 84);
insert into Oder (Oid, Uid, Deliverydate, Did) values (85, 16, '2022-06-12', 85);
insert into Oder (Oid, Uid, Deliverydate, Did) values (86, 15, '2022-03-23', 86);
insert into Oder (Oid, Uid, Deliverydate, Did) values (87, 14, '2022-10-05', 87);
insert into Oder (Oid, Uid, Deliverydate, Did) values (88, 13, '2023-01-16', 88);
insert into Oder (Oid, Uid, Deliverydate, Did) values (89, 12, '2022-03-31', 89);
insert into Oder (Oid, Uid, Deliverydate, Did) values (90, 11, '2022-09-04', 90);
insert into Oder (Oid, Uid, Deliverydate, Did) values (91, 10, '2022-04-26', 91);
insert into Oder (Oid, Uid, Deliverydate, Did) values (92, 9, '2023-01-20', 92);
insert into Oder (Oid, Uid, Deliverydate, Did) values (93, 8, '2022-11-27', 93);
insert into Oder (Oid, Uid, Deliverydate, Did) values (94, 7, '2022-05-01', 94);
insert into Oder (Oid, Uid, Deliverydate, Did) values (95, 6, '2022-05-28', 95);
insert into Oder (Oid, Uid, Deliverydate, Did) values (96, 5, '2022-09-01', 96);
insert into Oder (Oid, Uid, Deliverydate, Did) values (97, 4, '2022-10-25', 97);
insert into Oder (Oid, Uid, Deliverydate, Did) values (98, 3, '2022-04-13', 98);
insert into Oder (Oid, Uid, Deliverydate, Did) values (99, 2, '2022-11-19', 99);
insert into Oder (Oid, Uid, Deliverydate, Did) values (100, 1, '2023-01-31', 100);
select * from Oder;
-- delimiter //
-- CREATE TRIGGER my
-- before insert ON Payment
-- FOR EACH ROW
-- if New.PaymentStatus = "SUCCESSFUL" then set New.Pamount =0;
-- end if; //
insert into Cart (Cid, Uid) values (1, 1);
insert into Cart (Cid, Uid) values (2, 2);
insert into Cart (Cid, Uid) values (3, 3);
insert into Cart (Cid, Uid) values (4, 4);
insert into Cart (Cid, Uid) values (5, 5);
insert into Cart (Cid, Uid) values (6, 6);
insert into Cart (Cid, Uid) values (7, 7);
insert into Cart (Cid, Uid) values (8, 8);
insert into Cart (Cid, Uid) values (9, 9);
insert into Cart (Cid, Uid) values (10, 10);
insert into Cart (Cid, Uid) values (11, 11);
insert into Cart (Cid, Uid) values (12, 12);
insert into Cart (Cid, Uid) values (13, 13);
insert into Cart (Cid, Uid) values (14, 14);
insert into Cart (Cid, Uid) values (15, 15);
insert into Cart (Cid, Uid) values (16, 16);
insert into Cart (Cid, Uid) values (17, 17);
insert into Cart (Cid, Uid) values (18, 18);
insert into Cart (Cid, Uid) values (19, 19);
insert into Cart (Cid, Uid) values (20, 20);
insert into Cart (Cid, Uid) values (21, 21);
insert into Cart (Cid, Uid) values (22, 22);
insert into Cart (Cid, Uid) values (23, 23);
insert into Cart (Cid, Uid) values (24, 24);
insert into Cart (Cid, Uid) values (25, 25);
insert into Cart (Cid, Uid) values (26, 26);
insert into Cart (Cid, Uid) values (27, 27);
insert into Cart (Cid, Uid) values (28, 28);
insert into Cart (Cid, Uid) values (29, 29);
insert into Cart (Cid, Uid) values (30, 30);
insert into Cart (Cid, Uid) values (31, 31);
insert into Cart (Cid, Uid) values (32, 32);
insert into Cart (Cid, Uid) values (33, 33);
insert into Cart (Cid, Uid) values (34, 34);
insert into Cart (Cid, Uid) values (35, 35);
insert into Cart (Cid, Uid) values (36, 36);
insert into Cart (Cid, Uid) values (37, 37);
insert into Cart (Cid, Uid) values (38, 38);
insert into Cart (Cid, Uid) values (39, 39);
insert into Cart (Cid, Uid) values (40, 40);
insert into Cart (Cid, Uid) values (41, 41);
insert into Cart (Cid, Uid) values (42, 42);
insert into Cart (Cid, Uid) values (43, 43);
insert into Cart (Cid, Uid) values (44, 44);
insert into Cart (Cid, Uid) values (45, 45);
insert into Cart (Cid, Uid) values (46, 46);
insert into Cart (Cid, Uid) values (47, 47);
insert into Cart (Cid, Uid) values (48, 48);
insert into Cart (Cid, Uid) values (49, 49);
insert into Cart (Cid, Uid) values (50, 50);
insert into Cart (Cid, Uid) values (51, 51);
insert into Cart (Cid, Uid) values (52, 52);
insert into Cart (Cid, Uid) values (53, 53);
insert into Cart (Cid, Uid) values (54, 54);
insert into Cart (Cid, Uid) values (55, 55);
insert into Cart (Cid, Uid) values (56, 56);
insert into Cart (Cid, Uid) values (57, 57);
insert into Cart (Cid, Uid) values (58, 58);
insert into Cart (Cid, Uid) values (59, 59);
insert into Cart (Cid, Uid) values (60, 60);
insert into Cart (Cid, Uid) values (61, 61);
insert into Cart (Cid, Uid) values (62, 62);
insert into Cart (Cid, Uid) values (63, 63);
insert into Cart (Cid, Uid) values (64, 64);
insert into Cart (Cid, Uid) values (65, 65);
insert into Cart (Cid, Uid) values (66, 66);
insert into Cart (Cid, Uid) values (67, 67);
insert into Cart (Cid, Uid) values (68, 68);
insert into Cart (Cid, Uid) values (69, 69);
insert into Cart (Cid, Uid) values (70, 70);
insert into Cart (Cid, Uid) values (71, 71);
insert into Cart (Cid, Uid) values (72, 72);
insert into Cart (Cid, Uid) values (73, 73);
insert into Cart (Cid, Uid) values (74, 74);
insert into Cart (Cid, Uid) values (75, 75);
insert into Cart (Cid, Uid) values (76, 76);
insert into Cart (Cid, Uid) values (77, 77);
insert into Cart (Cid, Uid) values (78, 78);
insert into Cart (Cid, Uid) values (79, 79);
insert into Cart (Cid, Uid) values (80, 80);
insert into Cart (Cid, Uid) values (81, 81);
insert into Cart (Cid, Uid) values (82, 82);
insert into Cart (Cid, Uid) values (83, 83);
insert into Cart (Cid, Uid) values (84, 84);
insert into Cart (Cid, Uid) values (85, 85);
insert into Cart (Cid, Uid) values (86, 86);
insert into Cart (Cid, Uid) values (87, 87);
insert into Cart (Cid, Uid) values (88, 88);
insert into Cart (Cid, Uid) values (89, 89);
insert into Cart (Cid, Uid) values (90, 90);
insert into Cart (Cid, Uid) values (91, 91);
insert into Cart (Cid, Uid) values (92, 92);
insert into Cart (Cid, Uid) values (93, 93);
insert into Cart (Cid, Uid) values (94, 94);
insert into Cart (Cid, Uid) values (95, 95);
insert into Cart (Cid, Uid) values (96, 96);
insert into Cart (Cid, Uid) values (97, 97);
insert into Cart (Cid, Uid) values (98, 98);
insert into Cart (Cid, Uid) values (99, 99);
insert into Cart (Cid, Uid) values (100, 100);
select * from Cart;
-- Trigger 1
DELIMITER //
CREATE TRIGGER update_Pamunt
before INSERT ON PrUnit
FOR EACH ROW
BEGIN
DECLARE val,pr INT;
SELECT Prprice INTO val FROM Product WHERE Prid = NEW.Prid;
SELECT Pamount INTO pr FROM Payment WHERE Uidd = NEW.Cid;
update Payment,Product,PrUnit set Payment.Pamount= pr + (val * New.unit) where Payment.Uidd =New.Cid;
END //
DELIMITER ;
-- select * from Payment;
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (1, 'NET BANKING', '2022-09-15', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (2, 'NET BANKING', '2023-02-08', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (3, 'NET BANKING', '2022-08-15', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (4, 'NET BANKING', '2023-03-12', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (5, 'CREDIT CARD', '2022-07-26', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (6, 'COD', '2022-11-22', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (7, 'COD', '2022-11-15', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (8, 'DEBIT CARD', '2022-06-16', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (9, 'COD', '2023-01-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (10, 'CREDIT CARD', '2022-07-25', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (11, 'CREDIT CARD', '2022-05-07', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (12, 'NET BANKING', '2022-11-12', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (13, 'DEBIT CARD', '2022-05-27', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (14, 'COD', '2023-01-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (15, 'CREDIT CARD', '2022-10-18', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (16, 'DEBIT CARD', '2022-12-04', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (17, 'DEBIT CARD', '2023-03-03', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (18, 'CREDIT CARD', '2023-01-01', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (19, 'DEBIT CARD', '2022-09-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (20, 'CREDIT CARD', '2022-11-30', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (21, 'DEBIT CARD', '2022-11-17', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (22, 'CREDIT CARD', '2022-07-29', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (23, 'DEBIT CARD', '2022-07-11', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (24, 'NET BANKING', '2023-03-06', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (25, 'DEBIT CARD', '2023-01-19', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (26, 'NET BANKING', '2023-01-19', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (27, 'NET BANKING', '2022-06-17', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (28, 'DEBIT CARD', '2022-10-06', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (29, 'COD', '2022-06-01', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (30, 'CREDIT CARD', '2022-05-18', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (34, 'COD', '2022-05-13', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (35, 'DEBIT CARD', '2022-12-11', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (36, 'COD', '2023-02-01', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (37, 'COD', '2022-06-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (38, 'COD', '2022-04-20', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (39, 'COD', '2022-12-10', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (40, 'CREDIT CARD', '2022-12-27', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (41, 'CREDIT CARD', '2022-05-16', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (42, 'NET BANKING', '2023-03-10', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (43, 'COD', '2023-03-11', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (44, 'NET BANKING', '2023-01-26', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (45, 'DEBIT CARD', '2023-01-16', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (46, 'CREDIT CARD', '2022-10-25', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (47, 'CREDIT CARD', '2022-06-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (48, 'COD', '2023-02-01', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (49, 'COD', '2022-04-26', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (50, 'NET BANKING', '2022-05-11', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (51, 'CREDIT CARD', '2022-06-17', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (52, 'CREDIT CARD', '2022-09-24', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (53, 'NET BANKING', '2022-11-16', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (54, 'DEBIT CARD', '2022-10-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (55, 'NET BANKING', '2023-01-29', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (56, 'CREDIT CARD', '2022-08-20', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (57, 'CREDIT CARD', '2022-08-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (58, 'CREDIT CARD', '2022-03-31', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (59, 'DEBIT CARD', '2022-05-24', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (60, 'CREDIT CARD', '2022-03-22', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (61, 'CREDIT CARD', '2022-10-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (62, 'COD', '2023-03-17', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (63, 'DEBIT CARD', '2022-04-13', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (64, 'NET BANKING', '2022-03-24', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (65, 'COD', '2022-12-15', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (66, 'DEBIT CARD', '2023-02-04', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (67, 'CREDIT CARD', '2022-05-14', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (68, 'DEBIT CARD', '2023-02-10', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (69, 'COD', '2022-11-07', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (70, 'DEBIT CARD', '2022-06-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (71, 'DEBIT CARD', '2023-01-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (72, 'DEBIT CARD', '2022-11-25', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (73, 'COD', '2022-09-21', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (74, 'COD', '2023-01-08', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (75, 'DEBIT CARD', '2023-02-11', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (76, 'COD', '2022-08-03', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (77, 'COD', '2023-02-23', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (78, 'CREDIT CARD', '2022-04-04', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (79, 'COD', '2023-01-14', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (80, 'NET BANKING', '2022-08-28', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (81, 'NET BANKING', '2022-11-05', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (82, 'DEBIT CARD', '2022-10-13', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (83, 'NET BANKING', '2022-05-31', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (84, 'NET BANKING', '2022-09-01', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (85, 'CREDIT CARD', '2022-09-06', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (86, 'COD', '2023-02-17', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (87, 'DEBIT CARD', '2022-11-21', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (88, 'NET BANKING', '2022-04-21', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (89, 'CREDIT CARD', '2022-07-19', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (90, 'DEBIT CARD', '2022-12-26', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (91, 'COD', '2022-06-16', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (92, 'DEBIT CARD', '2022-06-19', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (93, 'COD', '2022-10-03', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (31, 'CREDIT CARD', '2022-12-06', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (32, 'DEBIT CARD', '2022-12-04', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (33, 'NET BANKING', '2022-07-23', 'UNSUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (94, 'NET BANKING', '2022-07-09', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (95, 'NET BANKING', '2023-02-26', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (96, 'CREDIT CARD', '2022-07-07', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (97, 'DEBIT CARD', '2023-01-06', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (98, 'CREDIT CARD', '2022-09-28', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (99, 'NET BANKING', '2022-08-31', 'SUCCESSFUL');
insert into Payment (Pid, Pmethods, Pdate, PaymentStatus) values (100, 'COD', '2022-04-21', 'UNSUCCESSFUL');
-- Trigger 2
DELIMITER //
CREATE TRIGGER statust
before INSERT ON PrUnit
FOR EACH ROW
BEGIN
DECLARE val INT;
SELECT Prunits INTO val FROM Product WHERE Prid = NEW.Prid;
IF val - NEW.unit < 0 THEN
SET NEW.unit = 0 ;
else
update Product,PrUnit set Product.Prunits=Product.Prunits- New.unit where Product.Prid =New.Prid;
END IF ;
SELECT Prunits INTO val FROM Product WHERE Prid = NEW.Prid;
if val=0 then
update Product,PrUnit set Product.Prstatus="Not Available" where Product.Prid =New.Prid;
END IF ;
END //
DELIMITER ;
DELIMITER ;
insert into PrUnit (PUid, Prid, unit, Cid) values (1, 75, 4, 72);
insert into PrUnit (PUid, Prid, unit, Cid) values (2, 144, 3, 31);
insert into PrUnit (PUid, Prid, unit, Cid) values (3, 70, 1, 61);
insert into PrUnit (PUid, Prid, unit, Cid) values (4, 29, 3, 67);
insert into PrUnit (PUid, Prid, unit, Cid) values (5, 3, 5, 51);
insert into PrUnit (PUid, Prid, unit, Cid) values (6, 86, 5, 24);
insert into PrUnit (PUid, Prid, unit, Cid) values (7, 130, 3, 18);
insert into PrUnit (PUid, Prid, unit, Cid) values (8, 141, 5, 23);
insert into PrUnit (PUid, Prid, unit, Cid) values (9, 9, 1, 3);
insert into PrUnit (PUid, Prid, unit, Cid) values (10, 27, 3, 51);
insert into PrUnit (PUid, Prid, unit, Cid) values (11, 41, 5, 51);
insert into PrUnit (PUid, Prid, unit, Cid) values (12, 82, 2, 67);
insert into PrUnit (PUid, Prid, unit, Cid) values (13, 83, 1, 22);
insert into PrUnit (PUid, Prid, unit, Cid) values (14, 133, 2, 81);
insert into PrUnit (PUid, Prid, unit, Cid) values (15, 24, 5, 67);
insert into PrUnit (PUid, Prid, unit, Cid) values (16, 67, 1, 6);
insert into PrUnit (PUid, Prid, unit, Cid) values (17, 6, 3, 18);
insert into PrUnit (PUid, Prid, unit, Cid) values (18, 49, 2, 96);
insert into PrUnit (PUid, Prid, unit, Cid) values (19, 51, 5, 90);
insert into PrUnit (PUid, Prid, unit, Cid) values (20, 139, 2, 63);
insert into PrUnit (PUid, Prid, unit, Cid) values (21, 147, 1, 38);
insert into PrUnit (PUid, Prid, unit, Cid) values (22, 43, 2, 40);
insert into PrUnit (PUid, Prid, unit, Cid) values (23, 88, 5, 33);