-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathinsert.sql
132 lines (129 loc) · 14.5 KB
/
insert.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
/*TRANSACTION TABLE*/
INSERT INTO TRANSACTION VALUES ('0000000001' , '2019-03-05' , 'mobile' , 0, 1049618, 'Manute Bol' , 'ANT' , '052969246076' , '011954352501');
INSERT INTO TRANSACTION VALUES ('0000000002' , '2019-03-15' , 'teller' , 0, 23335, 'Adisa Piene' , 'AIA' , '052854440213' , '052803119033');
INSERT INTO TRANSACTION VALUES ('0000000003' , '2019-04-05' , 'online' , 0, 77703, 'Godwell Nhamo' , 'AND' , '052834635979' , '057518800352');
INSERT INTO TRANSACTION VALUES ('0000000004' , '2019-05-30' , 'mobile' , 1, 8840, 'Lionel Andres Messi' , 'ARG' , '052658163201' , '101407441009');
INSERT INTO TRANSACTION VALUES ('0000000005' , '2019-07-17' , 'mobile' , 1, 88475, 'Kehinde Wiley' , 'ARM' , '052535713861' , '011149240176');
INSERT INTO TRANSACTION VALUES ('0000000006' , '2021-02-21' , 'mobile' , 1, 1574, 'Neymar da Silva Santos Junior' , 'BRA' , '052463471037' , '003137006202');
INSERT INTO TRANSACTION VALUES ('0000000007' , '2021-03-03' , 'teller' , 1, 26946, 'Alice Braga' , 'BRA' , '052329776238' , '057084098979');
INSERT INTO TRANSACTION VALUES ('0000000008' , '2021-03-04' , 'teller' , 0, 50831, 'Andy Lau' , 'HKG' , '052280916842' , '057442301506');
INSERT INTO TRANSACTION VALUES ('0000000009' , '2021-03-05' , 'teller' , 1, 44735, 'Teresa Teng' , 'HKG' , '052102980295' , '057261773990');
INSERT INTO TRANSACTION VALUES ('0000000010' , '2021-03-10' , 'online' , 0, 35307, 'Jornadan Noonez' , 'HND' , '011975021199' , '101142061799');
INSERT INTO TRANSACTION VALUES ('0000000011' , '2021-03-27' , 'online' , 1, 6391, 'Carlos Humberto Ruiz Gutierrez' , 'GTM' , '011904399184' , '057319873710');
INSERT INTO TRANSACTION VALUES ('0000000012' , '2021-04-07' , 'mobile' , 1, 98485, 'Konstantinos Manolas' , 'GRC' , '011803023048' , '101117740739');
INSERT INTO TRANSACTION VALUES ('0000000013' , '2021-04-17' , 'teller' , 1, 70467, 'Jimmy Cliff' , 'JAM' , '011797839558' , '057235750774');
INSERT INTO TRANSACTION VALUES ('0000000014' , '2021-04-19' , 'teller' , 1, 35818, 'Hamad bin Khalifa Al Thani' , 'KWT' , '011655005108' , '003858892273');
INSERT INTO TRANSACTION VALUES ('0000000015' , '2021-04-20' , 'online' , 1, 16686, 'Xi Jinping' , 'CHN' , '011633417719' , '101021791107');
INSERT INTO TRANSACTION VALUES ('0000000016' , '2021-04-23' , 'mobile' , 0, 22420, 'Vladimir Putin' , 'RUS' , '011622156148' , '101693522641');
INSERT INTO TRANSACTION VALUES ('0000000017' , '2021-04-27' , 'online' , 0, 57019, 'Ali Al Musrati' , 'LBY' , '011593202359' , '003569596128');
INSERT INTO TRANSACTION VALUES ('0000000018' , '2021-04-28' , 'teller' , 0, 81921, 'Adowa Wiley' , 'KEN' , '011589935432' , '052997048486');
INSERT INTO TRANSACTION VALUES ('0000000019' , '2021-05-03' , 'mobile' , 0, 12247, 'Jong-un Kim' , 'PRK' , '011548394507' , '011225810264');
INSERT INTO TRANSACTION VALUES ('0000000020' , '2021-05-06' , 'teller' , 1, 27438, 'Shakya Sujan Ratna' , 'NPL' , '011536856088' , '101595234458');
INSERT INTO TRANSACTION VALUES ('0000000021' , '2021-05-06' , 'online' , 1, 25239, 'Daniela Melchior' , 'PRT' , '011490791168' , '101335585762');
INSERT INTO TRANSACTION VALUES ('0000000022' , '2021-05-19' , 'mobile' , 1, 24134, 'Maxence Danet-Fauvel' , 'FRA' , '011373201109' , '003943484500');
INSERT INTO TRANSACTION VALUES ('0000000023' , '2021-05-22' , 'mobile' , 0, 52803, 'Vicent Cassel' , 'FRA' , '011352661122' , '003278624111');
INSERT INTO TRANSACTION VALUES ('0000000024' , '2021-05-25' , 'online' , 1, 99060, 'Volodymyr Zelensky' , 'UKR' , '011342869675' , '057886228306');
INSERT INTO TRANSACTION VALUES ('0000000025' , '2021-06-09' , 'online' , 1, 77193, 'Milla Kunis' , 'UKR' , '011287828966' , '101424863051');
INSERT INTO TRANSACTION VALUES ('0000000026' , '2021-06-09' , 'teller' , 1, 41649, 'Adjoa Andoh' , 'SSD' , '011287708756' , '057225463149');
INSERT INTO TRANSACTION VALUES ('0000000027' , '2021-06-12' , 'teller' , 1, 35557, 'Yun-Hee Im' , 'KOR' , '011224733126' , '057477132870');
INSERT INTO TRANSACTION VALUES ('0000000028' , '2021-06-14' , 'teller' , 1, 86499, 'Ho-Sook Gong' , 'KOR' , '011167757758' , '057295435415');
INSERT INTO TRANSACTION VALUES ('0000000029' , '2021-06-26' , 'teller' , 0, 20069, 'Miriam Stein' , 'CHE' , '011127911827' , '052582428379');
INSERT INTO TRANSACTION VALUES ('0000000030' , '2021-07-04' , 'teller' , 0, 66018, 'Emily Amber' , 'FIN' , '003876022037' , '011909198382');
INSERT INTO TRANSACTION VALUES ('0000000031' , '2021-07-17' , 'teller' , 0, 37200, 'Alain Delon' , 'FRA' , '003850471298' , '011580381107');
INSERT INTO TRANSACTION VALUES ('0000000032' , '2021-07-18' , 'online' , 1, 2072, 'Keanu Reeves' , 'CAN' , '003812477803' , '052730201364');
INSERT INTO TRANSACTION VALUES ('0000000033' , '2022-03-20' , 'online' , 0, 23728, 'Yeo Jung Kim' , 'PRK' , '003811137980' , '057910663379');
INSERT INTO TRANSACTION VALUES ('0000000034' , '2022-03-21' , 'online' , 1, 51275, 'Rachel Anne McAdams' , 'CAN' , '003756466892' , '052531069330');
INSERT INTO TRANSACTION VALUES ('0000000035' , '2022-03-21' , 'online' , 0, 51210, 'Elaine Thompson' , 'JAM' , '003587135587' , '003851388311');
INSERT INTO TRANSACTION VALUES ('0000000036' , '2022-03-30' , 'mobile' , 0, 91056, 'Jae-in Moon' , 'KOR' , '003582499304' , '011933182651');
INSERT INTO TRANSACTION VALUES ('0000000037' , '2022-03-30' , 'mobile' , 1, 85958, 'Su jin Jeong' , 'KOR' , '003435885763' , '003984724883');
INSERT INTO TRANSACTION VALUES ('0000000038' , '2022-04-06' , 'mobile' , 1, 37227, 'Jonas Cooper' , 'USA' , '003403634154' , '011311287885');
INSERT INTO TRANSACTION VALUES ('0000000039' , '2022-05-06' , 'mobile' , 1, 10728, 'Wang Jin Kai' , 'MAC' , '003386566230' , '057832164618');
INSERT INTO TRANSACTION VALUES ('0000000040' , '2022-05-09' , 'mobile' , 1, 1092045, 'Wui Fan' , 'MAC' , '003328353514' , '057357816051');
INSERT INTO TRANSACTION VALUES ('0000000041' , '2022-05-12' , 'mobile' , 1, 31750, 'Yejin Jeong' , 'KOR' , '003264071457' , '057480841627');
INSERT INTO TRANSACTION VALUES ('0000000042' , '2022-05-17' , 'mobile' , 1, 54598, 'Miles Teller' , 'USA' , '003263698599' , '011555061659');
INSERT INTO TRANSACTION VALUES ('0000000043' , '2022-05-26' , 'online' , 1, 23933, 'Tom Cruise' , 'USA' , '003262888593' , '052599785220');
INSERT INTO TRANSACTION VALUES ('0000000044' , '2022-06-06' , 'online' , 0, 81799, 'Joy Rolens' , 'USA' , '003196301503' , '011443261999');
INSERT INTO TRANSACTION VALUES ('0000000045' , '2022-06-08' , 'teller' , 0, 91039, 'Hailemariam Desalegn' , 'YEM' , '003157964722' , '003867477392');
INSERT INTO TRANSACTION VALUES ('0000000046' , '2022-06-20' , 'teller' , 0, 64314, 'Charles Mark Olweny' , 'SOM' , '003114088385' , '011949065994');
INSERT INTO TRANSACTION VALUES ('0000000047' , '2022-07-03' , 'teller' , 0, 52319, 'Justin Mark Marozzi' , 'SOM' , '003105009173' , '057650774252');
INSERT INTO TRANSACTION VALUES ('0000000048' , '2022-07-05' , 'teller' , 1, 12458, 'Halimah Yacob' , 'SGP' , '003100937419' , '052294474267');
INSERT INTO TRANSACTION VALUES ('0000000049' , '2022-07-05' , 'online' , 1, 17406, 'Dasha Taran' , 'RUS' , '003100386259' , '003953613760');
INSERT INTO TRANSACTION VALUES ('0000000050' , '2022-07-19' , 'mobile' , 1, 88277, 'Kristina Andrejevna Ovcinnikova' , 'RUS' , '003447729173' , '101219379546');
INSERT INTO TRANSACTION VALUES ('0000000051' , '2022-07-20' , 'mobile' , 0, 42008, 'Abd Al Aziz Awda' , 'PSE' , '011410043641' , '052971554289');
INSERT INTO TRANSACTION VALUES ('0000000052' , '2022-08-18' , 'mobile' , 0, 18036, 'Carlol Fisher' , 'FRA' , '011404687643' , '057983606917');
INSERT INTO TRANSACTION VALUES ('0000000053' , '2022-09-18' , 'teller' , 0, 96990, 'Alexis Hill' , 'FIN' , '011930536820' , '057565924564');
INSERT INTO TRANSACTION VALUES ('0000000054' , '2022-09-19' , 'teller' , 1, 39387, 'Jessica Cooper' , 'USA' , '011597146519' , '011993250517');
INSERT INTO TRANSACTION VALUES ('0000000055' , '2022-09-20' , 'teller' , 1, 81766, 'Lorenzo Thompson' , 'FRA' , '011794824060' , '003446112496');
INSERT INTO TRANSACTION VALUES ('0000000056' , '2022-09-21' , 'online' , 1, 43796, 'Kane Matthews' , 'USA' , '011569762260' , '052724495892');
INSERT INTO TRANSACTION VALUES ('0000000057' , '2022-09-22' , 'online' , 0, 37918, 'Kingsley Doyle' , 'UKR' , '011409631641' , '101699375837');
INSERT INTO TRANSACTION VALUES ('0000000058' , '2022-09-23' , 'online' , 1, 28955, 'Deacon Woods' , 'UKR' , '011340305795' , '052571837993');
INSERT INTO TRANSACTION VALUES ('0000000059' , '2022-09-24' , 'mobile' , 1, 81219, 'Diego Wilson' , 'BRA' , '011113925595' , '057132673282');
INSERT INTO TRANSACTION VALUES ('0000000060' , '2022-09-25' , 'mobile' , 1, 71098, 'Jamel Saeed Abdul Rahim' , 'PSE' , '052696493423' , '052775358563');
INSERT INTO TRANSACTION VALUES ('0000000061' , '2022-09-26' , 'teller' , 0, 77246, 'Bertie Collins' , 'GBR' , '052287514877' , '011522995891');
INSERT INTO TRANSACTION VALUES ('0000000062' , '2022-10-17' , 'teller' , 0, 23205, 'Mohammed Ali Hamadei' , 'PSE' , '052201297036' , '052771093716');
INSERT INTO TRANSACTION VALUES ('0000000063' , '2022-10-18' , 'online' , 1, 61665, 'Joanne Deborah Chesimard' , 'PSE' , '052340031128' , '101245269417');
INSERT INTO TRANSACTION VALUES ('0000000064' , '2022-10-19' , 'online' , 1, 9119, 'Nathaniel Holmes' , 'GBR' , '052311355937' , '052256693637');
INSERT INTO TRANSACTION VALUES ('0000000065' , '2022-10-20' , 'mobile' , 0, 35729, 'Aurora Cole' , 'USA' , '052501617481' , '052905438795');
INSERT INTO TRANSACTION VALUES ('0000000066' , '2022-10-21' , 'teller' , 1, 39171, 'Gene Ellis' , 'GBR' , '052767467268' , '052259444746');
INSERT INTO TRANSACTION VALUES ('0000000067' , '2022-10-22' , 'online' , 0, 34021, 'Dae-Jung Seol' , 'KOR' , '052762797936' , '101752945820');
INSERT INTO TRANSACTION VALUES ('0000000068' , '2022-10-23' , 'online' , 0, 91812, 'Hyun-Shik Jegal' , 'KOR' , '052640763573' , '101263416078');
INSERT INTO TRANSACTION VALUES ('0000000069' , '2022-10-24' , 'teller' , 0, 27004, 'Kyu-Bong Sim' , 'KOR' , '052537351603' , '003164934976');
INSERT INTO TRANSACTION VALUES ('0000000070' , '2022-10-25' , 'mobile' , 0, 58382, 'Tae gyu Kim' , 'KOR' , '052838715781' , '003509484705');
/*DNG_TXN TABLE*/
SET DEFINE OFF; -- & 무시
INSERT INTO DNG_TXN VALUES ('0000000001' , 500, 'transfer too much money.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000015' , 800, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000016' , 801, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000019' , 900, 'Suspicious person.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000022' , 860, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000023' , 271, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000024' , 649, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000025' , 322, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000026' , 613, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000027' , 929, 'Suspicious person & account.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000028' , 936, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000029' , 568, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000030' , 327, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000031' , 840, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000032' , 624, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000033' , 453, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000034' , 199, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000035' , 779, 'Suspicious account.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000036' , 756, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000037' , 811, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000038' , 460, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000039' , 791, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000040' , 550, 'Suspicious account & transfer too much money.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000041' , 440, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000042' , 591, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000043' , 898, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000044' , 256, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000045' , 761, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000046' , 370, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000047' , 720, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000048' , 806, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000049' , 493, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000050' , 272, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000051' , 271, 'Suspicious person.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000052' , 670, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000053' , 340, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000053' , 803, 'Suspicious person.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000054' , 478, 'Suspicious account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000054' , 804, 'Suspicious person.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000055' , 984, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000056' , 806, 'Suspicious person & account.' , '3');
INSERT INTO DNG_TXN VALUES ('0000000057' , 807, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000058' , 880, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000059' , 501, 'Suspicious person & account.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000060' , 814, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000061' , 113, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000062' , 120, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000062' , 811, 'Suspicious person.' , '2');
INSERT INTO DNG_TXN VALUES ('0000000063' , 914, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000064' , 579, 'Suspicious person & account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000065' , 419, 'Suspicious person & account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000066' , 181, 'Suspicious person & account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000067' , 881, 'Suspicious account.' , '0');
INSERT INTO DNG_TXN VALUES ('0000000068' , 432, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000069' , 514, 'Suspicious account.' , '1');
INSERT INTO DNG_TXN VALUES ('0000000070' , 799, 'Suspicious account.' , '1');