-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcurrencies.sql
78 lines (75 loc) · 8.96 KB
/
currencies.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
create column table currency (
id int primary key generated by default as IDENTITY,
iso_code nvarchar(5),
symbol nvarchar(10),
unicode nvarchar(25),
position_ nvarchar(20),
comments nvarchar(255)
);
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values('USD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('EUR','€','€','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CAD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('GBP','£','£','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('AUD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('AED','د.إ','','after','Can not find');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('ANG','ƒ','ƒ','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('AOA','AOA','AOA','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('ARS','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BAM','KM','KM','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BBD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BGL','лв','лв','before','ISO code is actually BGN');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BHD','BD','BD','after','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BND','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('BRL','R$','R$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CHF','Fr','Fr','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CLF','UF','UF','after','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CLP','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CNY','¥','¥','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('COP','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CRC','₡','₡','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('CZK','Kč','Kč','after','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('DKK','kr','kr','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('EEK','KR','KR','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('EGP','E£','E£','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('FJD','FJ$','FJ$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('GTQ','Q','Q','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('HKD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('HRK','kn','kn','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('HUF','Ft','Ft','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('IDR','Rp','Rp','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('ILS','₪','₪','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('INR','Rs','Rs','before','There is not a unicode');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('JOD','د.ا','','','Can not find');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('JPY','¥','¥','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('KES','KSh','Ksh','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('KRW','₩','₩','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('KWD','KD','KD','after','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('KYD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('LTL','Lt','Lt','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('LVL','Ls','Ls','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('MAD','د.م.','','','Can not find');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('MVR','Rf','Rf','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('MXN','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('MYR','RM','RM','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('NGN','₦','₦','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('NOK','kr','kr','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('NZD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('OMR','OMR','﷼','after','Unsure if this is correct');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('PEN','S/.','S/.','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('PHP','₱','₱','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('PLN','zł','Zł','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('QAR','QAR','﷼','after','Unsure if this is correct');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('RON','lei','lei','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('RUB','руб.','руб','after','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('SAR','SAR','﷼','after','Unsure if this is correct');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('SEK','kr','kr','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('SGD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('THB','฿','ł','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('TRY','TL','TL','before','There is not a unicode');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('TTD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('TWD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('UAH','₴','₴','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('VEF','Bs F','Bs.','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('VND','₫','₫','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('XCD','$','$','before','');
insert into "TEST_DB"."CURRENCY"("ISO_CODE","SYMBOL", "UNICODE","POSITION_","COMMENTS") values ('ZAR','R','R','before','')