forked from M-Elsaeed/dbproj
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Populating tables.sql
744 lines (744 loc) · 103 KB
/
Populating tables.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
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (1, '014 Boyle Hollow Suite 258\nEast Justus, NM 87723-2', '84405');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (2, '196 Brown Fall Apt. 645\nMaxstad, KS 13422-6334', '59873');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (3, '935 Labadie Lodge\nHellerside, NJ 10272-6700', '60909');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (4, '5784 Skiles Turnpike Suite 470\nHendersonhaven, NE ', '16538');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (5, '35598 Connelly Mall Apt. 351\nRyleyland, OR 74566', '98271');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (6, '092 Gerlach Track Apt. 632\nPurdybury, AK 41835-878', '92223');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (7, '3925 Amanda Junction Suite 478\nPort Lauriane, NY 6', '7355');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (8, '698 Brian Mills Apt. 831\nThompsonside, MT 56204-03', '98349');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (9, '400 Florian Plaza\nSydnitown, NV 93185-6155', '907');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (10, '09321 Orn Hill Suite 661\nEast Waino, MO 67561-8416', '44264');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (11, '037 Micaela Keys\nBrandimouth, MI 21037', '8372');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (12, '939 Paris Port\nWest Percy, NY 55607', '43011');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (13, '183 Domenic Lodge\nEast Ramiroview, OR 01395', '35996');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (14, '454 Lubowitz Spurs Suite 712\nTrompchester, WY 5392', '1516');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (15, '28997 Watson Orchard\nNew Lempiview, VA 28309-1290', '39106');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (16, '959 Beahan Keys Apt. 303\nLake Anita, FL 11919', '90935');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (17, '0527 Claudie Lodge Apt. 364\nEast Nelda, WY 73961-1', '38341');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (18, '825 Wilfred Vista Suite 668\nKutchton, VA 97568', '41116');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (19, '3393 Schowalter Highway\nWest Payton, KY 45567', '39212');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (20, '19194 Kristy Bridge Suite 120\nPfefferville, IL 768', '14468');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (21, '121 Breitenberg Rue Apt. 613\nJonesmouth, CA 53958-', '23493');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (22, '60082 Domenica Overpass\nNew Hollymouth, NY 27564-7', '94291');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (23, '8455 Pacocha Lane\nPort Kaseyton, SC 48700-6672', '28011');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (24, '46947 Destiney Trace\nEast Nathanaelstad, AK 19610-', '98287');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (25, '92636 Wolff Freeway\nLarkinstad, GA 06922', '6182');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (26, '1149 Reid Spring\nSouth Sadyeside, CT 30852', '96225');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (27, '7809 Hintz Hills\nPort Imelda, NJ 08293-3196', '30981');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (28, '440 Hane Square\nWest Kelsie, AK 82807-0865', '68439');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (29, '351 Derek Point Suite 348\nWest Carmel, KS 65866', '38418');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (30, '869 Tomas Fords\nCasperhaven, IN 21360', '48195');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (31, '80728 Mills Green Apt. 484\nKuhlmanberg, AL 39801', '3458');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (32, '62577 Luettgen Port\nSouth Rasheed, DC 31166', '67792');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (33, '8689 Auer Meadows\nNorth Ladariusmouth, OK 81842-69', '86136');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (34, '6735 Christine Club\nSophiashire, RI 26042', '73297');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (35, '953 Claudia Plains\nGiannishire, SD 90550', '12222');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (36, '7212 Balistreri Row Suite 070\nWest Reymundoport, M', '50237');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (37, '355 Bashirian Knoll Apt. 024\nStantonfurt, UT 45812', '3391');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (38, '128 Gino Junction\nNorth Artchester, NY 94977', '24536');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (39, '66797 Batz Ville Suite 705\nHowardton, AZ 39683-769', '39470');
INSERT INTO `ATMs` (`id`, `address`, `balance`) VALUES (40, '510 Colten Circles\nDurganshire, NV 19098-8259', '97882');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (1, 'Dr. Raymundo Aufderhar II', '2016-03-14', '155 Lindgren Pike Suite 868\nPort Edwinton, WY 99667', 'Gislasonburgh', '221-683-6159x62', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (2, 'Lolita Borer', '1994-06-15', '4281 Akeem Estate Apt. 615\nWest Maximo, VA 58476', 'Hayesside', '1-680-991-1613x', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (3, 'Una Boyer', '2004-02-18', '93836 Jarrett Bypass\nRosalynfort, IA 16237', 'North Natashahaven', '957.678.0345', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (4, 'Prof. Bertram Rosenbaum', '1987-10-25', '84729 Monty Wall Apt. 417\nWardbury, LA 30517-1392', 'North Trey', '(649)567-0896x1', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (5, 'Mr. Aidan Mayert', '2002-02-10', '84916 Gaetano Parks\nZemlakborough, PA 08066', 'South Arifort', '461-550-9998', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (6, 'Mrs. Serena Schamberger V', '2013-06-15', '437 Pollich Forges\nGibsonfort, PA 32367', 'Lloydmouth', '(765)960-5049x0', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (7, 'Lilian Bergstrom DVM', '2011-02-16', '5126 Karelle Wells\nAlexandrineville, DE 92144-3318', 'Cummingsview', '(370)897-5293x5', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (8, 'Crystel Hegmann', '1974-04-01', '68104 Dillan Heights\nNew Estrella, CT 30221', 'East Arnoldberg', '528.762.3538x20', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (9, 'Dr. Adrain Weimann', '1985-03-12', '15560 Hallie Glen Suite 615\nSouth Tillmanfort, MA 83588', 'Amarimouth', '1-035-153-0852', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (10, 'Kale Schowalter', '1991-09-30', '73102 Buckridge Lane Apt. 328\nBarrowsbury, ID 33536-6309', 'Hodkiewiczmouth', '(150)958-7326', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (11, 'Ruth Murray', '1992-10-24', '177 Alyson Ramp Apt. 043\nPort Laney, MS 19479', 'Isadoreburgh', '057-280-3285x29', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (12, 'Blaze Dicki I', '1986-08-23', '06174 Rubie Fort Apt. 495\nWest Maxinetown, MN 92964', 'Vivienberg', '1-786-978-9032x', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (13, 'Miss Antonetta Beatty', '2018-11-11', '472 Von Island\nBoyerborough, OK 37938-7635', 'Baumbachside', '040.921.6720x04', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (14, 'Sierra Herzog', '2003-08-15', '5255 Cartwright Neck\nWest Ellsworth, UT 03864', 'Lake Harry', '(740)845-2211', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (15, 'Mrs. Serena O\'Connell', '1972-03-02', '38336 Kreiger Ridge Apt. 883\nPort Amberhaven, MN 24800', 'West Eldred', '1-538-269-3482', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (16, 'Virginie Kuvalis', '2016-05-16', '242 Boyle Valley\nNew Bentown, OR 45797-7156', 'East Dahlia', '(643)679-3958', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (17, 'Shany Block', '1990-02-12', '4866 Major Mills Suite 563\nSchmittchester, MI 03854', 'West Kale', '+78(2)758846645', 'jaquelin.trantow@example.');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (18, 'Kaya O\'Kon', '1979-01-01', '93813 Larson Falls\nNorth Emmaleemouth, MS 99829-0916', 'Kingchester', '830.544.4074x15', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (19, 'Mallory Hegmann II', '1984-04-12', '149 Hagenes Ville Apt. 861\nKiehnchester, CO 74322-4150', 'Hagenesport', '(068)155-8899x5', '[email protected]');
INSERT INTO `person` (`national_id`, `person_name`, `birth_date`, `address`, `city`, `phone_number`, `email`) VALUES (20, 'Johnpaul Skiles', '2010-12-03', '778 Parisian Lodge Apt. 469\nNew Jacquelynport, RI 28746', 'North Justice', '(494)457-8919x2', '[email protected]');
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (1, 'est', 'Suscipit omnis amet sed cumque et dolor. Eligendi corrupti occaecati nam eos. Et rerum excepturi vel.', '0.199', 277);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (2, 'quibusdam', 'Ut sit eos aut ab provident laboriosam. Explicabo quaerat voluptatibus dolorum. Deserunt tenetur corrupti consequatur cumque dolor et. Inventore nihil rerum omnis est rerum quibusdam.', '0.083', 167);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (3, 'odio', 'Tempora fugit eaque culpa eius fuga amet. Natus molestiae ad nihil cum omnis. Consequuntur cumque mollitia dicta aut nihil minus amet.', '0.168', 302);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (4, 'dolores', 'Est tempore et suscipit aperiam. Modi perspiciatis et accusamus minima et.', '0.327', 108);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (5, 'dignissimos', 'Ut incidunt et molestias iure nihil. Aut iure quae excepturi unde dolores saepe enim. Odit quod officia officiis ut.', '0.207', 282);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (6, 'recusandae', 'Et dicta deleniti qui impedit. Numquam delectus rem incidunt inventore asperiores assumenda. Consectetur dignissimos explicabo rem excepturi.', '0.096', 190);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (7, 'eum', 'Rerum odit perferendis sint deleniti rerum odio facere. Quas voluptatem iusto dolorem expedita eos. Nihil repellat laboriosam nostrum accusamus vero aliquid itaque sunt.', '0.009', 28);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (8, 'non', 'Ab illum vero sapiente vel. Voluptas tenetur qui totam dicta animi nisi. Atque voluptates ut laudantium quisquam aliquam dolores.', '0.242', 199);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (9, 'fugiat', 'Sapiente delectus eius sunt dolorem debitis sed omnis sint. Incidunt veritatis qui doloremque ut exercitationem. Ducimus eum dolores quaerat saepe id impedit voluptatem.', '0.139', 78);
INSERT INTO `sub_accounts` (`id`, `acc_name`, `description`, `interest_rate`, `interest_interval`) VALUES (10, 'quisquam', 'Temporibus non id temporibus odio ex qui ut. Id fugit enim sed est impedit veniam. Voluptate minima qui et soluta.', '0.298', 229);
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (1, 'Eiu', '82.841');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (2, 'Aut', '21.706');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (3, 'Nem', '39.653');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (4, 'Ill', '73.147');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (5, 'Qua', '52.71');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (6, 'Qui', '12.667');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (7, 'Und', '95.177');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (8, 'Qui', '42.855');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (9, 'Quo', '52.674');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (10, 'Est', '88.076');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (11, 'Sit', '28.932');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (12, 'Sit', '70.507');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (13, 'Et.', '2.832');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (14, 'Est', '51.928');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (15, 'Ad.', '54.418');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (16, 'Et.', '84.939');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (17, 'In.', '83.6');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (18, 'Qui', '28.771');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (19, 'Ad.', '55.404');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (20, 'Est', '60.206');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (21, 'Sun', '13.233');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (22, 'Qui', '22.661');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (23, 'Sit', '22.963');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (24, 'Ut.', '96.374');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (25, 'Ea.', '22.461');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (26, 'Ad.', '18.131');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (27, 'Id.', '54.703');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (28, 'Qui', '81.19');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (29, 'Est', '81.814');
INSERT INTO `currencies` (`id`, `triple_code`, `exchange_rate`) VALUES (30, 'Et.', '56.281');
INSERT INTO `issuers` (`id`, `issuerName`) VALUES (1, 'Visa');
INSERT INTO `issuers` (`id`, `issuerName`) VALUES (2, 'MasterCard');
INSERT INTO `issuers` (`id`, `issuerName`) VALUES (3, 'American Express');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Aut amet si', 'quasi', '014.402.9411', 'msfe', '268 Wolf Well Apt. 268\nLake Bernita, NY 90423-0788', 'Lake Micha', '1980-06-23');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Aut volupta', 'unde', '536.338.5025', 'jufp', '579 Vandervort Highway Apt. 938\nWest Abbigailville', 'South Eldr', '2008-06-27');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Cupiditate ', 'mollitia', '639.833.8457', 'ecbg', '09479 Lue Stream\nWest Maxwell, WY 67901', 'Bradfordbu', '1985-01-07');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Dolore non ', 'suscipit', '(113)896-8904', 'wpqo', '158 Homenick Neck Suite 489\nWest Dangelo, NY 53586', 'Macyberg', '1984-05-18');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Eos facere ', 'autem', '+01(9)095907151', 'eukx', '2385 Casey Highway Apt. 237\nSouth Mabel, KS 82071-', 'New Brandy', '2016-09-14');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et amet und', 'eveniet', '09995932537', 'pvxq', '50941 Daniel Summit Suite 046\nWest Kolbymouth, SD ', 'Jaskolskiv', '1997-05-25');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et aut est ', 'optio', '1-039-668-4999x', 'iuhz', '9016 Schuster Grove\nConsidinebury, NJ 71407-8361', 'Hettingerc', '1974-08-15');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et beatae d', 'maiores', '779.009.7868x64', 'dbcv', '037 Raina Divide\nEast Florine, WY 13013', 'Jackelinev', '2005-09-28');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et cum offi', 'fugit', '986-629-5689', 'uqsv', '738 Armstrong Landing\nEast Rusty, TX 55394-2749', 'Joannieche', '1978-02-25');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et error ea', 'eius', '(972)143-6865', 'jyxv', '773 Armand Meadow Apt. 089\nNew Zulaville, NV 11432', 'Lake Dimit', '1993-05-10');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Et quo modi', 'nihil', '742.443.9108x19', 'mstd', '739 Kozey Shoal\nNew Antone, DC 35076-1016', 'Nolanchest', '1981-09-19');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Hic odio qu', 'ex', '(630)172-0110x9', 'srit', '4232 Satterfield Estates\nOrtiztown, CA 42552-2428', 'Raphaellec', '1983-04-03');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Iure est vo', 'adipisci', '(403)945-6727x9', 'ulzg', '1028 Homenick Forges Suite 059\nEast Lonzotown, MA ', 'Wizaside', '1977-04-02');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Magni at id', 'eum', '+84(4)868459151', 'qtuv', '877 Smitham Gardens Apt. 213\nWest Cristalbury, MS ', 'Kirlinboro', '1997-03-25');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Nobis fugia', 'id', '320-574-9678x63', 'uamr', '5230 Crystel Turnpike Suite 401\nDexterview, HI 030', 'Schulistmo', '2013-03-23');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Omnis et in', 'ratione', '(481)899-0989x1', 'mimj', '11914 Sipes Road Apt. 458\nGulgowskiton, KY 79257', 'North Pasq', '1973-06-04');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Qui ea dolo', 'aperiam', '(870)003-1468x4', 'nyeb', '92831 Christiansen Throughway\nPort Titusside, AK 4', 'South Fran', '2009-08-15');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Qui sunt ut', 'dicta', '319.659.2583', 'djmq', '64204 Ashtyn Springs Apt. 326\nLake Lorenzhaven, KS', 'Kaileevill', '2017-04-13');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Quia aut se', 'nobis', '(701)611-3181x3', 'njlz', '399 Hansen Drive Apt. 150\nNew Tiana, NE 11654', 'Prohaskala', '1976-08-16');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Quia sunt u', 'nihil', '394.557.9540x77', 'rexj', '291 Garry Spurs Apt. 875\nWest Laurie, MO 95038-985', 'Elisamouth', '1980-07-24');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Quia velit ', 'tempora', '919.174.8811x24', 'boyh', '749 Spencer Lake\nVandervortstad, DC 74595-5274', 'Jettieside', '1999-04-21');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Quo esse si', 'dicta', '086.111.2313x19', 'okpr', '304 Maggio Ferry\nAgustinafurt, PA 81987-3506', 'Lake Trevo', '1980-04-04');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Rem nulla q', 'qui', '645.110.7471x70', 'mcgx', '3719 Cassandre Parkways Apt. 724\nKlingborough, AZ ', 'Lake Carme', '1994-06-17');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Sed ea et n', 'quaerat', '078-635-0838x47', 'rfad', '017 Camren Heights\nLake Henry, FL 73915-8378', 'New Gudrun', '1999-12-16');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Sunt autem ', 'beatae', '847.751.0592x48', 'ocbe', '91874 Ambrose Road Apt. 720\nLake Peyton, NC 65330', 'Port Jaida', '1997-04-15');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Sunt sed ne', 'dolore', '1-015-556-3140x', 'itay', '90830 DuBuque Mountains Suite 184\nKohlerland, IN 7', 'Port Olebo', '2014-03-23');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Ut laborum ', 'inventore', '848-630-2342x12', 'vkdi', '48916 Chauncey Bypass Suite 334\nAureliohaven, IA 1', 'Lindseyvil', '1973-06-17');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Vel suscipi', 'sed', '1-772-774-8331x', 'cyyt', '06179 Moore Fall\nLake Emelieville, NM 18082', 'Abernathyp', '2007-02-01');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Vero maxime', 'numquam', '379-790-7133', 'xxuj', '375 Elias Alley Apt. 875\nLake Lornamouth, NM 83172', 'Lindgrenst', '2016-01-20');
INSERT INTO `branches` (`SWIFT`, `b_name`, `phone_number`, `postal_code`, `address`, `city`, `opening`) VALUES ('Voluptas at', 'velit', '(060)149-7482x0', 'joou', '2099 Hettinger Turnpike\nBauchport, OK 22798-9058', 'Lake Brian', '1974-11-02');
INSERT INTO `departments` (`id`, `d_name`) VALUES (1, 'sapiente');
INSERT INTO `departments` (`id`, `d_name`) VALUES (2, 'velit');
INSERT INTO `departments` (`id`, `d_name`) VALUES (3, 'molestiae');
INSERT INTO `departments` (`id`, `d_name`) VALUES (4, 'nisi');
INSERT INTO `departments` (`id`, `d_name`) VALUES (5, 'odit');
INSERT INTO `departments` (`id`, `d_name`) VALUES (6, 'aliquam');
INSERT INTO `departments` (`id`, `d_name`) VALUES (7, 'eius');
INSERT INTO `departments` (`id`, `d_name`) VALUES (8, 'et');
INSERT INTO `departments` (`id`, `d_name`) VALUES (9, 'qui');
INSERT INTO `departments` (`id`, `d_name`) VALUES (10, 'blanditiis');
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut amet si', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut volupta', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Cupiditate ', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Dolore non ', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Eos facere ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et amet und', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et aut est ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et beatae d', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et cum offi', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et error ea', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et quo modi', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Hic odio qu', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Iure est vo', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Magni at id', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Nobis fugia', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Omnis et in', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui ea dolo', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui sunt ut', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia aut se', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia sunt u', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia velit ', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quo esse si', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Rem nulla q', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sed ea et n', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt autem ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt sed ne', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Ut laborum ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vel suscipi', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vero maxime', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Voluptas at', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut amet si', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut volupta', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Cupiditate ', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Dolore non ', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Eos facere ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et amet und', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et aut est ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et beatae d', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et cum offi', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et error ea', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et quo modi', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Hic odio qu', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Iure est vo', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Magni at id', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Nobis fugia', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Omnis et in', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui ea dolo', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui sunt ut', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia aut se', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia sunt u', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia velit ', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quo esse si', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Rem nulla q', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sed ea et n', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt autem ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt sed ne', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Ut laborum ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vel suscipi', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vero maxime', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Voluptas at', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut amet si', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut volupta', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Cupiditate ', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Dolore non ', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Eos facere ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et amet und', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et aut est ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et beatae d', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et cum offi', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et error ea', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et quo modi', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Hic odio qu', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Iure est vo', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Magni at id', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Nobis fugia', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Omnis et in', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui ea dolo', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Qui sunt ut', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia aut se', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia sunt u', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quia velit ', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Quo esse si', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Rem nulla q', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sed ea et n', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt autem ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Sunt sed ne', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Ut laborum ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vel suscipi', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Vero maxime', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Voluptas at', 10);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut amet si', 1);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Aut volupta', 2);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Cupiditate ', 3);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Dolore non ', 4);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Eos facere ', 5);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et amet und', 6);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et aut est ', 7);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et beatae d', 8);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et cum offi', 9);
INSERT INTO `department_branch` (`branch_swift`, `dept_id`) VALUES ('Et error ea', 10);
INSERT INTO `customers` (`id`, `account_id`) VALUES (1, 0);
INSERT INTO `customers` (`id`, `account_id`) VALUES (2, 570281);
INSERT INTO `customers` (`id`, `account_id`) VALUES (3, 748507);
INSERT INTO `customers` (`id`, `account_id`) VALUES (4, 2);
INSERT INTO `customers` (`id`, `account_id`) VALUES (5, 679290179);
INSERT INTO `customers` (`id`, `account_id`) VALUES (6, 36193);
INSERT INTO `customers` (`id`, `account_id`) VALUES (7, 85433);
INSERT INTO `customers` (`id`, `account_id`) VALUES (8, 34);
INSERT INTO `customers` (`id`, `account_id`) VALUES (9, 45129013);
INSERT INTO `customers` (`id`, `account_id`) VALUES (10, 6);
INSERT INTO `customers` (`id`, `account_id`) VALUES (11, 259945);
INSERT INTO `customers` (`id`, `account_id`) VALUES (12, 5);
INSERT INTO `customers` (`id`, `account_id`) VALUES (13, 46541);
INSERT INTO `customers` (`id`, `account_id`) VALUES (14, 157);
INSERT INTO `customers` (`id`, `account_id`) VALUES (15, 7);
INSERT INTO `customers` (`id`, `account_id`) VALUES (16, 61);
INSERT INTO `customers` (`id`, `account_id`) VALUES (17, 17035);
INSERT INTO `customers` (`id`, `account_id`) VALUES (18, 64665376);
INSERT INTO `customers` (`id`, `account_id`) VALUES (19, 8);
INSERT INTO `customers` (`id`, `account_id`) VALUES (20, 468802);
UPDATE `bank`.`customers` SET `account_id` = '0' WHERE (`account_id` = '1');
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (1, 'at', 1);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (2, 'esse', 2);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (3, 'in', 3);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (4, 'dolore', 4);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (5, 'rem', 5);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (6, 'error', 6);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (7, 'qui', 7);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (8, 'perspiciatis', 8);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (9, 'accusamus', 9);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (10, 'temporibus', 10);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (11, 'quam', 1);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (12, 'cumque', 2);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (13, 'fugit', 3);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (14, 'sunt', 4);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (15, 'iure', 5);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (16, 'voluptatem', 6);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (17, 'officia', 7);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (18, 'debitis', 8);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (19, 'numquam', 9);
INSERT INTO `roles` (`id`, `r_name`, `dept_id`) VALUES (20, 'dicta', 10);
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (1, '469594', 1,'eugene.miller', 'Et ullam perspiciatis.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (2, '43276', 2,'roob.eden', 'In pariatur velit.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (3, '410248', 3,'lschroeder', 'Aperiam qui et.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (4, '363787', 4,'wilkinson.brennon', 'Est incidunt sed.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (5, '387049', 5,'wdenesik', 'Consectetur nulla aut.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (6, '200329', 6,'yspinka', 'Dolor rem.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (7, '177685', 7,'jalyn61', 'Culpa commodi.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (8, '256137', 8,'herminio.satterfield', 'Accusantium rerum.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (9, '288309', 9,'rowe.tia', 'Eos tempore.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (10, '194113', 10,'xbarton', 'Alias asperiores.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (11, '471341', 11,'reuben.dach', 'Dolorem quo ipsum.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (12, '287032', 12,'daphne46', 'Ad facilis minus.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (13, '176669', 13,'predovic.rosalia', 'Aliquam sunt ut.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (14, '284196', 14,'blick.adele', 'Adipisci pariatur optio.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (15, '310883', 15,'jspencer', 'Ea saepe.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (16, '220906', 16,'bgorczany', 'Eaque velit quos.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (17, '457377', 17,'ohalvorson', 'Est aut illum.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (18, '430687', 18,'ola.labadie', 'At eius sapiente.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (19, '382318', 19,'acrooks', 'Deleniti enim.');
INSERT INTO `employees` (`id`, `salary`, `role_id`,`userName`, `user_password`) VALUES (20, '406065', 20,'mustafa19', 'Maiores nesciunt.');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (0, 1, 1, '74668971077');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (0, 1, 11, '31273675430');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (0, 1, 21, '24123804318');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (2, 2, 2, '89733220032');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (2, 2, 12, '35219380352');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (2, 2, 22, '6285455217');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (5, 3, 3, '72407812299');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (5, 3, 13, '19858977152');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (5, 3, 23, '73527276051');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (6, 4, 4, '7413019239');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (6, 4, 14, '93329057331');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (6, 4, 24, '64341141610');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (7, 5, 5, '80808542902');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (7, 5, 15, '43319095671');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (7, 5, 25, '16534965764');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (8, 6, 6, '73061045818');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (8, 6, 16, '3373424476');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (8, 6, 26, '7801819453');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (34, 7, 7, '3556577162');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (34, 7, 17, '80321285921');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (34, 7, 27, '31560721202');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (61, 8, 8, '7879823073');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (61, 8, 18, '14388142572');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (61, 8, 28, '11962761124');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (157, 9, 9, '6447025528');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (157, 9, 19, '90140133538');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (157, 9, 29, '8333315746');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (17035, 10, 10, '96039609192');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (17035, 10, 20, '4769197152');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (17035, 10, 30, '54636421939');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (36193, 1, 1, '82595997071');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (36193, 1, 11, '4946123343');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (36193, 1, 21, '1152352197');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (46541, 2, 2, '18736301781');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (46541, 2, 12, '50441854028');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (46541, 2, 22, '71200686554');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (85433, 3, 3, '7495874445');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (85433, 3, 13, '68315052428');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (85433, 3, 23, '24967331718');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (259945, 4, 4, '39061005553');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (259945, 4, 14, '15405094297');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (259945, 4, 24, '8389396779');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (468802, 5, 5, '21665455075');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (468802, 5, 15, '52815547073');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (468802, 5, 25, '53390988382');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (570281, 6, 6, '15627808310');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (570281, 6, 16, '39687668765');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (570281, 6, 26, '81010526466');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (748507, 7, 7, '1123536657');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (748507, 7, 17, '86381323822');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (748507, 7, 27, '11558427661');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (45129013, 8, 8, '23892781092');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (45129013, 8, 18, '55985955428');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (45129013, 8, 28, '12018112884');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (64665376, 9, 9, '56466730964');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (64665376, 9, 19, '43640526850');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (64665376, 9, 29, '44974570023');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (679290179, 10, 10, '16828418104');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (679290179, 10, 20, '23350824462');
INSERT INTO `accounts_sub_accounts` (`account_id`, `subaccount_id`, `currency_id`, `balance`) VALUES (679290179, 10, 30, '81313015940');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (1, 1, '1981-05-26', '316', '8888');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (2, 2, '1993-05-30', '883', '7688');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (3, 3, '1980-08-29', '9903', '7733');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (4, 4, '2018-01-18', '9988', '876');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (5, 5, '2010-12-23', '204', '1142');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (6, 6, '1997-12-14', '9347', '4092');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (7, 7, '1993-06-25', '3008', '3269');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (8, 8, '1979-12-03', '2559', '7140');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (9, 9, '2006-10-22', '8415', '3771');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (10, 10, '1980-09-05', '9768', '5280');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (11, 11, '1976-11-30', '8321', '2913');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (12, 12, '2014-04-19', '9996', '3072');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (13, 13, '2017-02-02', '612', '4770');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (14, 14, '1989-06-28', '8034', '7419');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (15, 15, '1982-08-07', '9371', '7169');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (16, 16, '1993-10-06', '6374', '1737');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (17, 17, '1993-11-07', '2073', '4221');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (18, 18, '1995-01-11', '7609', '1414');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (19, 19, '1983-09-09', '4890', '715');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (20, 20, '1973-10-21', '7945', '43');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (21, 1, '2006-06-15', '2735', '159');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (22, 2, '1973-12-26', '5051', '1974');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (23, 3, '2006-11-19', '8574', '123');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (24, 4, '2012-12-17', '3699', '88');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (25, 5, '1989-12-01', '8199', '9682');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (26, 6, '1981-09-23', '2899', '3071');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (27, 7, '1999-03-25', '1205', '5006');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (28, 8, '2002-02-24', '9107', '5666');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (29, 9, '2015-04-29', '5370', '8575');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (30, 10, '2017-10-19', '5036', '7490');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (31, 11, '2013-02-12', '7147', '3143');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (32, 12, '1972-08-02', '8061', '6257');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (33, 13, '1986-09-03', '2767', '8394');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (34, 14, '2007-07-10', '1420', '7926');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (35, 15, '1994-02-04', '4355', '1770');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (36, 16, '2018-12-01', '6301', '4896');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (37, 17, '2013-05-23', '3078', '5347');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (38, 18, '2018-06-12', '888', '2386');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (39, 19, '2003-05-19', '2362', '6707');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (40, 20, '2006-10-07', '4701', '4869');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (41, 1, '1994-03-09', '8825', '1745');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (42, 2, '2009-05-14', '325', '1577');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (43, 3, '1983-05-14', '5563', '5985');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (44, 4, '1970-05-13', '7073', '6241');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (45, 5, '1971-01-28', '2826', '8299');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (46, 6, '2012-07-24', '9551', '9359');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (47, 7, '1971-07-09', '986', '8009');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (48, 8, '2001-07-05', '870', '1615');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (49, 9, '1992-06-03', '5727', '4448');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (50, 10, '1997-07-09', '5253', '1995');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (51, 11, '2011-11-18', '2072', '5956');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (52, 12, '1986-01-24', '1092', '9332');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (53, 13, '1999-09-17', '8883', '9921');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (54, 14, '1976-05-05', '4699', '6746');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (55, 15, '1984-05-27', '8245', '3639');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (56, 16, '1979-03-08', '753', '9554');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (57, 17, '1982-11-20', '7154', '2409');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (58, 18, '1972-02-04', '2255', '118');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (59, 19, '2007-10-08', '8442', '9715');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (60, 20, '1976-03-05', '299', '6756');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (61, 1, '1991-06-30', '6652', '6400');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (62, 2, '2014-10-23', '1304', '2776');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (63, 3, '1996-09-16', '9271', '4159');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (64, 4, '2013-10-23', '4403', '9782');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (65, 5, '2011-09-08', '8714', '7418');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (66, 6, '2014-08-18', '7282', '5334');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (67, 7, '2006-07-02', '4786', '3763');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (68, 8, '1971-05-27', '612', '4587');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (69, 9, '1984-02-01', '1030', '5930');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (70, 10, '2000-05-07', '5999', '4907');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (71, 11, '1999-04-25', '2730', '6828');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (72, 12, '2000-01-24', '7330', '5481');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (73, 13, '2005-03-16', '1707', '1295');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (74, 14, '1995-12-17', '7174', '8000');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (75, 15, '2007-06-22', '7933', '5085');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (76, 16, '2004-07-03', '8681', '5196');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (77, 17, '2000-07-16', '6914', '6318');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (78, 18, '1990-12-21', '6796', '4659');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (79, 19, '2014-06-12', '5172', '4813');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (80, 20, '2005-10-27', '5548', '7307');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (81, 1, '1981-09-10', '9443', '5399');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (82, 2, '2000-08-21', '2373', '7460');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (83, 3, '2008-06-16', '8614', '5696');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (84, 4, '1982-11-13', '6891', '2222');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (85, 5, '1997-10-22', '2041', '6335');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (86, 6, '1985-08-04', '9658', '454');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (87, 7, '2012-12-25', '8728', '1223');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (88, 8, '1974-12-24', '588', '7053');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (89, 9, '1970-06-29', '2508', '2586');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (90, 10, '2007-02-04', '8904', '2894');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (91, 11, '1980-03-29', '3661', '6448');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (92, 12, '1973-10-19', '8429', '5569');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (93, 13, '1992-04-26', '4655', '5414');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (94, 14, '2002-02-19', '8939', '7572');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (95, 15, '2001-08-29', '7570', '483');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (96, 16, '1991-02-20', '4894', '3099');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (97, 17, '1976-04-29', '4188', '2525');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (98, 18, '1984-04-24', '1654', '2993');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (99, 19, '1990-12-01', '9598', '199');
INSERT INTO `payroll` (`id`, `employee_id`, `payment_date`, `bonuses`, `penalties`) VALUES (100, 20, '1998-12-17', '3235', '1107');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (0, 1, 0, 1, '10510.24', '1997-09-26 07:45:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (2, 2, 2, 2, '157507157.391', '1997-11-15 20:02:32');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (5, 3, 5, 3, '368753.21', '2005-12-26 01:20:11');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (6, 4, 6, 4, '1500.167', '2004-01-20 11:47:33');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (7, 5, 7, 5, '3304.98', '1992-08-15 16:17:03');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (8, 6, 8, 6, '2804376.897', '1988-04-04 22:40:13');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (34, 7, 34, 7, '1244107.083', '2013-05-22 22:51:06');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (61, 8, 61, 8, '1.125', '1978-12-07 10:05:46');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES (157, 9, 157, 9, '247136305.782', '2007-02-10 17:37:38');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 17035, 10, 17035, 10, '43023.338', '1993-12-01 15:54:27');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 36193, 1, 36193, 1, '47044.174', '2000-03-02 05:20:52');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 46541, 2, 46541, 2, '2.451', '1992-07-16 23:47:53');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 85433, 3, 85433, 3, '7.619', '1975-12-11 13:26:04');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 259945, 4, 259945, 4, '219283386.626', '1995-01-21 07:49:27');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 468802, 5, 468802, 5, '67674.015', '2006-02-14 23:46:26');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 570281, 6, 570281, 6, '105714.192', '1981-02-09 00:32:13');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 748507, 7, 748507, 7, '40819.537', '2003-09-14 07:27:03');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 45129013, 8, 45129013, 8, '4653563.506', '1977-05-20 12:08:19');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 64665376, 9, 64665376, 9, '386467412.075', '2008-12-22 07:01:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 679290179, 10, 679290179, 10, '6515088.175', '1981-05-22 22:34:15');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 0, 1, 0, 1, '127466532.538', '2006-10-01 21:05:48');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 2, 2, 2, 2, '4.089', '1991-06-07 17:13:29');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 5, 3, 5, 3, '0.626', '2015-05-21 16:13:50');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 6, 4, 6, 4, '160644.441', '1997-08-22 05:28:41');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 7, 5, 7, 5, '200376.512', '2014-09-30 04:22:25');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 8, 6, 8, 6, '3.344', '2001-09-19 20:57:21');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 34, 7, 34, 7, '32.277', '2015-03-08 23:31:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 61, 8, 61, 8, '5.081', '1992-05-06 03:20:40');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 157, 9, 157, 9, '0.959', '1972-09-17 08:13:36');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 17035, 10, 17035, 10, '6727879.555', '1998-01-17 20:24:45');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 36193, 1, 36193, 1, '452.598', '2001-11-20 20:31:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 46541, 2, 46541, 2, '0.083', '1999-02-09 15:19:03');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 85433, 3, 85433, 3, '19634.71', '1982-02-05 16:04:20');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 259945, 4, 259945, 4, '23.444', '1990-08-09 21:26:32');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 468802, 5, 468802, 5, '973423743.011', '1982-10-22 22:26:51');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 570281, 6, 570281, 6, '22.411', '1977-09-08 11:20:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 748507, 7, 748507, 7, '916025.869', '2003-06-26 17:24:10');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 45129013, 8, 45129013, 8, '0.456', '1982-03-11 03:50:53');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 64665376, 9, 64665376, 9, '304281.631', '2009-03-21 21:56:43');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 679290179, 10, 679290179, 10, '146.161', '2001-05-22 08:38:35');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 0, 1, 0, 1, '0.011', '2015-01-13 02:47:11');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 2, 2, 2, 2, '0.16', '1998-04-15 03:40:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 5, 3, 5, 3, '21312609.708', '2004-01-30 10:00:39');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 6, 4, 6, 4, '0.372', '1984-12-12 09:00:50');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 7, 5, 7, 5, '4375481.314', '1990-07-25 02:56:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 8, 6, 8, 6, '294703.424', '1989-04-17 14:53:00');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 34, 7, 34, 7, '209196230.161', '1996-09-08 09:58:07');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 61, 8, 61, 8, '1914108.189', '1997-06-18 21:50:25');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 157, 9, 157, 9, '6053.001', '1982-01-01 02:48:55');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 17035, 10, 17035, 10, '81.356', '1986-07-08 10:59:19');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 36193, 1, 36193, 1, '673.921', '1992-07-26 06:53:12');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 46541, 2, 46541, 2, '3555231.826', '2011-10-12 08:04:43');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 85433, 3, 85433, 3, '25031508.105', '1991-04-15 11:36:44');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 259945, 4, 259945, 4, '32530471.978', '1987-03-03 02:43:53');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 468802, 5, 468802, 5, '253.433', '1975-01-01 19:00:07');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 570281, 6, 570281, 6, '2.41', '1984-01-02 04:17:54');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 748507, 7, 748507, 7, '302031.689', '2017-06-30 19:52:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 45129013, 8, 45129013, 8, '25600.142', '1992-08-31 08:11:35');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 64665376, 9, 64665376, 9, '0.071', '1984-09-22 16:00:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 679290179, 10, 679290179, 10, '2678232.19', '2005-03-25 07:51:13');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 0, 1, 0, 1, '631.165', '2009-04-14 21:35:11');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 2, 2, 2, 2, '125384.133', '2012-01-23 01:47:37');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 5, 3, 5, 3, '2349768.672', '2011-03-30 08:53:50');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 6, 4, 6, 4, '590.641', '1984-09-20 13:16:42');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 7, 5, 7, 5, '4176784.044', '2018-04-15 16:36:58');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 8, 6, 8, 6, '209681.774', '1972-05-13 12:11:59');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 34, 7, 34, 7, '29346194.741', '1976-07-03 19:40:48');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 61, 8, 61, 8, '46.346', '1983-12-21 06:35:45');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 157, 9, 157, 9, '1.59', '1972-05-07 04:31:46');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 17035, 10, 17035, 10, '630593.037', '2003-10-04 01:36:55');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 36193, 1, 36193, 1, '1.749', '1971-02-26 14:41:55');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 46541, 2, 46541, 2, '37.843', '2004-04-08 22:02:32');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 85433, 3, 85433, 3, '5364.074', '2014-09-21 14:17:50');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 259945, 4, 259945, 4, '29501754.554', '1984-03-12 00:03:08');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 468802, 5, 468802, 5, '178.067', '2000-05-22 19:49:47');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 570281, 6, 570281, 6, '702257228.17', '1992-03-04 11:41:18');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 748507, 7, 748507, 7, '1952.669', '1976-01-27 10:07:51');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 45129013, 8, 45129013, 8, '6.562', '2014-06-12 09:41:00');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 64665376, 9, 64665376, 9, '7.809', '1997-10-03 07:55:02');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 679290179, 10, 679290179, 10, '6142205.611', '1974-04-20 01:45:56');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 0, 1, 0, 1, '104705.872', '2017-08-14 00:14:53');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 2, 2, 2, 2, '618585.835', '1975-06-09 08:49:31');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 5, 3, 5, 3, '6631815.869', '2011-10-17 19:54:52');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 6, 4, 6, 4, '0.058', '2014-05-31 02:41:54');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 7, 5, 7, 5, '605935.147', '1971-06-05 16:29:22');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 8, 6, 8, 6, '15087413.324', '1986-05-02 03:49:12');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 34, 7, 34, 7, '55747891.328', '2003-10-07 07:35:42');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 61, 8, 61, 8, '39626.589', '1975-03-17 13:53:25');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 157, 9, 157, 9, '59296.026', '2012-12-28 14:21:26');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 17035, 10, 17035, 10, '17.679', '2013-05-25 07:57:02');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 36193, 1, 36193, 1, '630693.669', '1990-10-08 18:45:03');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 46541, 2, 46541, 2, '418661.491', '2006-05-18 23:12:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 85433, 3, 85433, 3, '12.988', '2010-05-25 15:35:32');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 259945, 4, 259945, 4, '33249.583', '2003-04-14 22:46:20');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 468802, 5, 468802, 5, '59748725.369', '2013-11-03 14:42:12');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 570281, 6, 570281, 6, '0.041', '1996-10-08 09:23:36');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 748507, 7, 748507, 7, '66.57', '1984-09-10 20:44:49');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 45129013, 8, 45129013, 8, '186322140.971', '1979-08-21 00:56:19');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 64665376, 9, 64665376, 9, '164.101', '2007-11-04 12:44:07');
INSERT INTO `transactions` ( `from_account`, `from_subAccount`, `to_account`, `to_subAccount`, `amount`, `t_time`) VALUES ( 679290179, 10, 679290179, 10, '0.349', '2011-06-20 11:39:30');
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 1, 1);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 2, 2);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 3, 3);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 4, 4);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 5, 5);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 6, 6);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 7, 7);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 8, 8);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 9, 9);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 10, 10);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 11, 11);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 12, 12);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 13, 13);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 14, 14);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 15, 15);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 16, 16);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 17, 17);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 18, 18);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 19, 19);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 20, 20);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 21, 21);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 22, 22);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 23, 23);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 24, 24);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 25, 25);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 26, 26);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 27, 27);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 28, 28);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 29, 29);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 30, 30);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 31, 31);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 32, 32);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 33, 33);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 34, 34);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 35, 35);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 36, 36);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 37, 37);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 38, 38);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 39, 39);
INSERT INTO `atm_transaction` (`atm_id`, `transaction_id`) VALUES ( 40, 40);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Aut amet si', 1);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Aut volupta', 2);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Cupiditate ', 3);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Dolore non ', 4);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Eos facere ', 5);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et amet und', 6);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et aut est ', 7);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et beatae d', 8);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et cum offi', 9);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et error ea', 10);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et quo modi', 11);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Hic odio qu', 12);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Iure est vo', 13);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Magni at id', 14);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Nobis fugia', 15);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Omnis et in', 16);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Qui ea dolo', 17);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Qui sunt ut', 18);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Quia aut se', 19);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Quia sunt u', 20);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Quia velit ', 21);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Quo esse si', 22);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Rem nulla q', 23);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Sed ea et n', 24);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Sunt autem ', 25);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Sunt sed ne', 26);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Ut laborum ', 27);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Vel suscipi', 28);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Vero maxime', 29);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Voluptas at', 30);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Aut amet si', 31);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Aut volupta', 32);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Cupiditate ', 33);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Dolore non ', 34);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Eos facere ', 35);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et amet und', 36);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et aut est ', 37);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et beatae d', 38);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et cum offi', 39);
INSERT INTO `branch_transaction` (`branch_swift`, `transaction_id`) VALUES ('Et error ea', 40);
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('340204093490358', 45129013, 2, '2007-08-04', '1989-03-17', '646901', 'credit', '528');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('342241137589961', 570281, 3, '1983-01-09', '2014-06-25', '572255', 'debit', '687');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('345162408740873', 64665376, 3, '1991-02-20', '2016-07-11', '772936', 'credit', '861');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('345201240869517', 61, 1, '1994-12-03', '1971-05-16', '344725', 'credit', '387');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('347585297461024', 85433, 1, '2013-02-21', '2011-06-05', '197321', 'credit', '513');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('349916820253904', 570281, 2, '2007-07-28', '2014-05-27', '235192', 'debit', '335');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('372217413029344', 2, 3, '1993-07-06', '2004-08-29', '778126', 'credit', '106');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('374415279354826', 468802, 3, '2011-04-07', '1984-08-03', '516913', 'credit', '331');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('379872096910150', 36193, 1, '1995-08-17', '1994-02-19', '89879', 'credit', '323');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4024007115547', 34, 3, '2013-04-25', '2015-02-13', '125604', 'credit', '977');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4024007124386711', 8, 3, '1987-02-12', '2003-09-27', '73408', 'credit', '843');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4024007160724', 0, 3, '1975-02-22', '1980-10-01', '815649', 'credit', '116');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4024007163989596', 2, 2, '1970-07-12', '2002-03-23', '330673', 'credit', '143');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4024007182176', 34, 2, '2013-06-27', '1980-02-17', '475879', 'debit', '322');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4172907913673011', 85433, 1, '2010-11-28', '1976-03-01', '31719', 'debit', '847');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4354030585438786', 5, 3, '2012-04-25', '2009-07-07', '324826', 'credit', '486');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4485340379571785', 468802, 2, '1983-11-11', '1978-09-25', '382356', 'credit', '376');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4485461384588', 46541, 3, '1991-08-30', '2008-12-02', '60064', 'credit', '486');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4485792477735852', 46541, 2, '1972-11-15', '1981-01-11', '470882', 'debit', '658');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4532281244260', 64665376, 3, '1981-02-13', '1993-04-13', '555694', 'debit', '543');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4539038192849', 0, 1, '1981-02-06', '1980-02-24', '648814', 'debit', '902');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4539200242614848', 748507, 2, '1996-04-28', '2004-08-16', '775446', 'debit', '991');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4539515466355792', 468802, 3, '1988-01-22', '1996-05-28', '549436', 'credit', '402');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4539534285885514', 157, 3, '1998-03-12', '2011-02-28', '556050', 'debit', '971');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4542832567116', 259945, 2, '2015-03-17', '2013-06-20', '807858', 'credit', '728');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4556267732152', 34, 1, '2018-09-19', '1996-07-11', '354774', 'credit', '477');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4556512372023', 679290179, 1, '1994-03-08', '2007-10-13', '262368', 'credit', '565');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4556690026179147', 2, 2, '1993-05-06', '1998-02-14', '507299', 'credit', '959');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4556728392000', 748507, 1, '1984-04-25', '1991-05-14', '364361', 'debit', '939');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4556912602922094', 36193, 3, '1990-05-22', '1974-04-07', '582120', 'debit', '425');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4660352374496', 45129013, 1, '1988-03-02', '1975-01-15', '397348', 'credit', '456');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716093242154', 157, 3, '2012-03-17', '1985-03-27', '320578', 'debit', '877');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716155548493', 259945, 1, '1977-01-10', '1989-10-02', '797232', 'credit', '297');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716329585381894', 61, 3, '2005-08-16', '1997-03-12', '822909', 'credit', '106');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716375019133631', 6, 3, '1998-07-12', '1986-07-19', '691295', 'debit', '983');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716453941563', 17035, 1, '1985-01-15', '2002-10-11', '851689', 'debit', '245');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716511510871682', 45129013, 3, '2000-07-24', '1972-10-11', '524849', 'debit', '577');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716723273651', 64665376, 1, '1982-11-30', '1979-10-09', '582588', 'debit', '925');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716833164937038', 61, 1, '2016-12-24', '1985-04-30', '660778', 'debit', '395');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4716838510953624', 259945, 3, '1983-10-06', '2012-10-17', '227133', 'credit', '520');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4889508850813', 34, 3, '2006-05-03', '1972-06-26', '654775', 'credit', '421');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4916234046724', 157, 2, '1980-01-18', '1982-09-28', '659371', 'credit', '772');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4916286847523', 7, 3, '1972-02-12', '1990-10-17', '79251', 'credit', '836');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4916447793073', 36193, 2, '2005-05-02', '1999-12-15', '70890', 'debit', '202');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4916691107501097', 46541, 3, '2013-05-11', '1984-06-26', '857327', 'credit', '692');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4929498526186244', 468802, 2, '1983-02-10', '2010-05-09', '355341', 'credit', '781');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4929501099894', 64665376, 2, '1976-12-09', '1970-11-21', '923016', 'debit', '162');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4929703388645383', 748507, 1, '1993-08-16', '1992-04-17', '107988', 'credit', '934');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('4929987491459', 679290179, 3, '1985-07-13', '1974-03-08', '384823', 'debit', '510');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5118891282366825', 5, 2, '1979-03-02', '1994-05-09', '235910', 'credit', '743');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5122785919086773', 748507, 2, '1995-09-02', '1971-12-08', '965563', 'debit', '779');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5145001531352981', 46541, 1, '2001-07-30', '1983-01-15', '525349', 'credit', '347');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5147557993528957', 679290179, 1, '1987-12-17', '1984-12-06', '235928', 'credit', '400');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5148699432340291', 5, 2, '2009-06-29', '2014-10-20', '550761', 'credit', '945');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5157725452263031', 570281, 1, '1977-10-10', '2002-09-25', '137635', 'credit', '492');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5180187673493689', 7, 1, '1994-04-13', '1978-08-20', '175673', 'debit', '801');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5182656707415663', 8, 1, '1997-05-18', '1985-01-12', '689371', 'debit', '200');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5200999752354362', 570281, 1, '1984-11-30', '2002-08-26', '302398', 'debit', '328');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5204909475576074', 17035, 1, '2017-05-27', '1986-06-04', '344799', 'debit', '502');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5208725126562385', 5, 3, '1999-12-18', '1997-10-27', '27056', 'debit', '394');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5221775029854474', 7, 2, '1983-03-12', '2003-12-04', '861062', 'debit', '769');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5221801460398402', 46541, 2, '2005-10-11', '1995-05-29', '251558', 'credit', '707');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5231822212091966', 85433, 3, '1975-11-29', '2009-01-11', '812466', 'debit', '396');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5261065264329950', 45129013, 3, '1973-01-12', '1986-11-13', '796335', 'credit', '301');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5261806445832956', 2, 1, '1989-03-10', '1971-10-20', '649337', 'credit', '344');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5264832795420529', 6, 1, '2000-08-06', '2005-08-17', '126089', 'debit', '334');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5270188150704673', 45129013, 2, '1998-02-04', '2007-11-22', '308244', 'debit', '593');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5275417528774756', 0, 1, '2012-03-18', '1983-12-29', '652213', 'credit', '313');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5287185649304596', 570281, 3, '2000-07-13', '2004-12-20', '267590', 'credit', '836');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5289556795488536', 6, 3, '2014-04-18', '2002-10-30', '474186', 'debit', '317');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5306177617953998', 17035, 2, '1991-06-16', '2004-04-02', '997335', 'debit', '544');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5310685370843128', 0, 3, '1997-06-19', '1984-07-05', '4372', 'credit', '628');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5312938319403749', 64665376, 1, '2012-09-09', '2016-04-02', '664402', 'credit', '734');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5324391817987767', 8, 3, '1988-03-11', '1995-07-04', '873510', 'credit', '686');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5332135089897394', 157, 1, '2004-02-28', '1987-08-06', '808956', 'debit', '461');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5353995646048869', 34, 1, '1995-08-24', '1970-09-27', '217944', 'debit', '401');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5376197996847174', 6, 2, '1991-02-28', '2001-11-28', '915483', 'debit', '698');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5376855221872520', 5, 1, '1986-09-05', '1975-11-05', '669987', 'credit', '930');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5387211954153879', 748507, 3, '1994-01-19', '1974-04-24', '83227', 'credit', '303');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5394344189684867', 61, 2, '2018-08-25', '1986-10-27', '172060', 'credit', '462');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5407076837319819', 259945, 1, '1988-11-29', '1995-02-28', '307954', 'debit', '662');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5418701422816767', 0, 2, '2008-12-31', '2006-04-21', '735097', 'debit', '865');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5427523507448438', 259945, 2, '2010-11-19', '2004-05-16', '614066', 'credit', '754');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5434223142998236', 7, 2, '2018-03-22', '1991-10-27', '929363', 'credit', '831');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5470670178038997', 2, 1, '2000-09-16', '1996-03-04', '240341', 'debit', '417');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5493775094157733', 36193, 1, '1985-09-28', '1975-01-15', '943687', 'credit', '441');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5497801471134643', 85433, 3, '2017-07-10', '2015-03-13', '235230', 'debit', '440');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5513015663389556', 6, 1, '2014-10-15', '1975-08-22', '103949', 'debit', '714');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5534253018356846', 8, 2, '1994-08-11', '2017-05-20', '51009', 'credit', '310');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5557477286849922', 17035, 3, '2004-07-23', '1986-12-04', '736736', 'credit', '183');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5570600477533306', 85433, 2, '2018-05-02', '2004-10-17', '397171', 'debit', '150');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5571345640965958', 157, 2, '1996-10-10', '1977-08-21', '402083', 'debit', '967');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('5592642333990275', 36193, 2, '1982-02-12', '2015-11-12', '226449', 'credit', '223');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011208019768962', 468802, 1, '1973-07-18', '2001-09-15', '499485', 'debit', '834');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011554992292661', 17035, 3, '2011-06-27', '1981-10-07', '980116', 'debit', '494');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011573000993518', 61, 2, '2009-11-02', '1992-10-25', '396963', 'debit', '320');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011586811230653', 679290179, 2, '1998-10-31', '2004-04-02', '378058', 'credit', '642');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011871517597892', 7, 1, '1970-06-06', '1997-05-26', '194041', 'debit', '137');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011883659219675', 679290179, 2, '1970-01-07', '2011-11-30', '997402', 'credit', '337');
INSERT INTO `customer_cards` (`cnumber`, `account_id`, `issuer_id`, `issue_date`, `expirey_date`, `daily_limit`, `ctype`, `CVV`) VALUES ('6011896314497517', 8, 2, '2017-02-26', '1988-10-18', '790258', 'credit', '314');