Index: openacs-4/packages/ref-currency/sql/common/ref-currency-data.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-currency/sql/common/Attic/ref-currency-data.sql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/ref-currency/sql/common/ref-currency-data.sql 27 Aug 2001 21:48:55 -0000 1.1 +++ openacs-4/packages/ref-currency/sql/common/ref-currency-data.sql 2 Sep 2001 17:06:29 -0000 1.2 @@ -8,192 +8,192 @@ -- set feedback off; -insert into currencies values ('NA','',' ','','No universal currency'); -insert into currencies values ('ADP','20','0','','Andorran Peseta'); -insert into currencies values ('AED','784','2','','UAE Dirham'); -insert into currencies values ('AFA','4','2','','Afghani'); -insert into currencies values ('ALL','8','2','','Lek'); -insert into currencies values ('AMD','51','2','','Armenian Dram'); -insert into currencies values ('ANG','532','2','','Netherlands Antillan Guilder'); -insert into currencies values ('AOA','973','2','','Kwanza'); -insert into currencies values ('ARS','32','2','','Argentine Peso'); -insert into currencies values ('ATS','40','2','','Schilling'); -insert into currencies values ('AUD','36','2','','Australian Dollar'); -insert into currencies values ('AWG','533','2','','Aruban Guilder'); -insert into currencies values ('AZM','31','2','','Azerbaijanian Manat'); -insert into currencies values ('BAM','977','2','','Convertible Marks'); -insert into currencies values ('BBD','52','2','','Barbados Dollar'); -insert into currencies values ('BDT','50','2','','Taka'); -insert into currencies values ('BEF','56','0','','Belgian Franc'); -insert into currencies values ('BGL','100','2','','Lev'); -insert into currencies values ('BGN','975','2','','Bulgarian Lev'); -insert into currencies values ('BHD','48','3','','Bahraini Dinar'); -insert into currencies values ('BIF','108','0','','Burundi Franc'); -insert into currencies values ('BMD','60','2','','Bermudian Dollar'); -insert into currencies values ('BND','96','2','','Brunei Dollar'); -insert into currencies values ('BOB','68','2','','Boliviano'); -insert into currencies values ('BOV','984','2','','Mvdol'); -insert into currencies values ('BRL','986','2','','Brazilian Real'); -insert into currencies values ('BSD','44','2','','Bahamian Dollar'); -insert into currencies values ('BTN','64','2','','Ngultrum'); -insert into currencies values ('BWP','72','2','','Pula'); -insert into currencies values ('BYB','112','0','','Belarussian Ruble'); -insert into currencies values ('BYR','974','0','','Belarussian Ruble'); -insert into currencies values ('BZD','84','2','','Belize Dollar'); -insert into currencies values ('CAD','124','2','','Canadian Dollar'); -insert into currencies values ('CDF','976','2','','Franc Congolais'); -insert into currencies values ('CHF','756','2','','Swiss Franc'); -insert into currencies values ('CLF','990','0','','Unidades de fomento'); -insert into currencies values ('CLP','152','0','','Chilean Peso'); -insert into currencies values ('CNY','156','2','','Yuan Renminbi'); -insert into currencies values ('COP','170','2','','Colombian Peso'); -insert into currencies values ('CRC','188','2','','Costa Rican Colon'); -insert into currencies values ('CUP','192','2','','Cuban Peso'); -insert into currencies values ('CVE','132','2','','Cape Verde Escudo'); -insert into currencies values ('CYP','196','2','','Cyprus Pound'); -insert into currencies values ('CZK','203','2','','Czech Koruna'); -insert into currencies values ('DEM','276','2','','Deutsche Mark'); -insert into currencies values ('DJF','262','0','','Djibouti Franc'); -insert into currencies values ('DKK','208','2','','Danish Krone'); -insert into currencies values ('DOP','214','2','','Dominican Peso'); -insert into currencies values ('DZD','12','2','','Algerian Dinar'); -insert into currencies values ('EEK','233','2','','Kroon'); -insert into currencies values ('EGP','818','2','','Egyptian Pound'); -insert into currencies values ('ERN','232','2','','Nakfa'); -insert into currencies values ('ESP','724','0','','Spanish Peseta'); -insert into currencies values ('ETB','230','2','','Ethiopian Birr'); -insert into currencies values ('FIM','246','2','','Markka'); -insert into currencies values ('FJD','242','2','','Fiji Dollar'); -insert into currencies values ('FKP','238','2','','Falkland Islands Pound'); -insert into currencies values ('FRF','250','2','','French Franc'); -insert into currencies values ('GBP','826','2','','Pound Sterling'); -insert into currencies values ('GEL','981','2','','Lari'); -insert into currencies values ('GHC','288','2','','Cedi'); -insert into currencies values ('GIP','292','2','','Gibraltar Pound'); -insert into currencies values ('GMD','270','2','','Dalasi'); -insert into currencies values ('GNF','324','0','','Guinea Franc'); -insert into currencies values ('GRD','300','0','','Drachma'); -insert into currencies values ('GTQ','320','2','','Quetzal'); -insert into currencies values ('GWP','624','2','','Guinea-Bissau Peso'); -insert into currencies values ('GYD','328','2','','Guyana Dollar'); -insert into currencies values ('HKD','344','2','','Hong Kong Dollar'); -insert into currencies values ('HNL','340','2','','Lempira'); -insert into currencies values ('HRK','191','2','','Croatian kuna'); -insert into currencies values ('HTG','332','2','','Gourde'); -insert into currencies values ('HUF','348','2','','Forint'); -insert into currencies values ('IDR','360','2','','Rupiah'); -insert into currencies values ('IEP','372','2','','Irish Pound'); -insert into currencies values ('ILS','376','2','','New Israeli Sheqel'); -insert into currencies values ('INR','356','2','','Indian Rupee'); -insert into currencies values ('IQD','368','3','','Iraqi Dinar'); -insert into currencies values ('IRR','364','2','','Iranian Rial'); -insert into currencies values ('ISK','352','2','','Iceland Krona'); -insert into currencies values ('ITL','380','0','','Italian Lira'); -insert into currencies values ('JMD','388','2','','Jamaican Dollar'); -insert into currencies values ('JOD','400','3','','Jordanian Dinar'); -insert into currencies values ('JPY','392','0','','Yen'); -insert into currencies values ('KES','404','2','','Kenyan Shilling'); -insert into currencies values ('KGS','417','2','','Som'); -insert into currencies values ('KHR','116','2','','Riel'); -insert into currencies values ('KMF','174','0','','Comoro Franc'); -insert into currencies values ('KPW','408','2','','North Korean Won'); -insert into currencies values ('KRW','410','0','','Won'); -insert into currencies values ('KWD','414','3','','Kuwaiti Dinar'); -insert into currencies values ('KYD','136','2','','Cayman Islands Dollar'); -insert into currencies values ('KZT','398','2','','Tenge'); -insert into currencies values ('LAK','418','2','','Kip'); -insert into currencies values ('LBP','422','2','','Lebanese Pound'); -insert into currencies values ('LKR','144','2','','Sri Lanka Rupee'); -insert into currencies values ('LRD','430','2','','Liberian Dollar'); -insert into currencies values ('LSL','426','2','','Loti'); -insert into currencies values ('LTL','440','2','','Lithuanian Litus'); -insert into currencies values ('LUF','442','0','','Luxembourg Franc'); -insert into currencies values ('LVL','428','2','','Latvian Lats'); -insert into currencies values ('LYD','434','3','','Lybian Dinar'); -insert into currencies values ('MAD','504','2','','Moroccan Dirham'); -insert into currencies values ('MDL','498','2','','Moldovan Leu'); -insert into currencies values ('MGF','450','0','','Malagasy Franc'); -insert into currencies values ('MKD','807','2','','Denar'); -insert into currencies values ('MMK','104','2','','Kyat'); -insert into currencies values ('MNT','496','2','','Tugrik'); -insert into currencies values ('MOP','446','2','','Pataca'); -insert into currencies values ('MRO','478','2','','Ouguiya'); -insert into currencies values ('MTL','470','2','','Maltese Lira'); -insert into currencies values ('MUR','480','2','','Mauritius Rupee'); -insert into currencies values ('MVR','462','2','','Rufiyaa'); -insert into currencies values ('MWK','454','2','','Kwacha'); -insert into currencies values ('MXN','484','2','','Mexican Peso'); -insert into currencies values ('MXV','979','2','','Mexican Unidad de Inversion (UDI)'); -insert into currencies values ('MYR','458','2','','Malaysian Ringgit'); -insert into currencies values ('MZM','508','2','','Metical'); -insert into currencies values ('NAD','516','2','','Namibia Dollar'); -insert into currencies values ('NGN','566','2','','Naira'); -insert into currencies values ('NIO','558','2','','Cordoba Oro'); -insert into currencies values ('NLG','528','2','','Netherlands Guilder'); -insert into currencies values ('NOK','578','2','','Norvegian Krone'); -insert into currencies values ('NPR','524','2','','Nepalese Rupee'); -insert into currencies values ('NZD','554','2','','New Zealand Dollar'); -insert into currencies values ('OMR','512','3','','Rial Omani'); -insert into currencies values ('PAB','590','2','','Balboa'); -insert into currencies values ('PEN','604','2','','Nuevo Sol'); -insert into currencies values ('PGK','598','2','','Kina'); -insert into currencies values ('PHP','608','2','','Philippine Peso'); -insert into currencies values ('PKR','586','2','','Pakistan Rupee'); -insert into currencies values ('PLN','985','2','','Zloty'); -insert into currencies values ('PTE','620','0','','Portuguese Escudo'); -insert into currencies values ('PYG','600','0','','Guarani'); -insert into currencies values ('QAR','634','2','','Qatari Rial'); -insert into currencies values ('ROL','642','2','','Leu'); -insert into currencies values ('RUB','643','2','','Russian Ruble'); -insert into currencies values ('RUR','810','2','','Russian Ruble'); -insert into currencies values ('RWF','646','0','','Rwanda Franc'); -insert into currencies values ('SAR','682','2','','Saudi Riyal'); -insert into currencies values ('SBD','90','2','','Solomon Islands Dollar'); -insert into currencies values ('SCR','690','2','','Seychelles Rupee'); -insert into currencies values ('SDD','736','2','','Sudanese Dinar'); -insert into currencies values ('SEK','752','2','','Swedish Krona'); -insert into currencies values ('SGD','702','2','','Singapore Dollar'); -insert into currencies values ('SHP','654','2','','Saint Helena Pound'); -insert into currencies values ('SIT','705','2','','Tolar'); -insert into currencies values ('SKK','703','2','','Slovak Koruna'); -insert into currencies values ('SLL','694','2','','Leone'); -insert into currencies values ('SOS','706','2','','Somali Shilling'); -insert into currencies values ('SRG','740','2','','Suriname Guilder'); -insert into currencies values ('STD','678','2','','Dobra'); -insert into currencies values ('SVC','222','2','','El Salvador Colon'); -insert into currencies values ('SYP','760','2','','Syrian Pound'); -insert into currencies values ('SZL','748','2','','Lilangeni'); -insert into currencies values ('THB','764','2','','Baht'); -insert into currencies values ('TJR','762','0','','Tajik Ruble'); -insert into currencies values ('TJS','972','0','','Somoni'); -insert into currencies values ('TMM','795','2','','Manat'); -insert into currencies values ('TND','788','3','','Tunisian Dinar'); -insert into currencies values ('TOP','776','2','','Paaaaanga'); -insert into currencies values ('TPE','626','0','','Timor Escudo'); -insert into currencies values ('TRL','792','0','','Turkish Lira'); -insert into currencies values ('TTD','780','2','','Trinidad and Tobago Dollar'); -insert into currencies values ('TWD','901','2','','New Taiwan Dollar'); -insert into currencies values ('TZS','834','2','','Tanzanian Shilling'); -insert into currencies values ('UAH','980','2','','Hryvnia'); -insert into currencies values ('UGX','800','2','','Uganda Shilling'); -insert into currencies values ('USD','840','2','','US Dollar'); -insert into currencies values ('USN','997','2','','US Dollar (Next day)'); -insert into currencies values ('USS','998','2','','US Dollar (Same day)'); -insert into currencies values ('UYU','858','2','','Peso Uruguayo'); -insert into currencies values ('UZS','860','2','','Uzbekistan Sum'); -insert into currencies values ('VEB','862','2','','Bolivar'); -insert into currencies values ('VND','704','2','','Dong'); -insert into currencies values ('VUV','548','0','','Vatu'); -insert into currencies values ('WST','882','2','','Tala'); -insert into currencies values ('XAF','950','0','','CFA Franc BEAC'); -insert into currencies values ('XCD','951','2','','East Carribbean Dollar'); -insert into currencies values ('XOF','952','0','','CFA Franc BCEAO'); -insert into currencies values ('XPF','953','0','','CFP Franc'); -insert into currencies values ('YER','886','2','','Yemeni Rial'); -insert into currencies values ('YUM','891','2','','Yugoslavian Dinar'); -insert into currencies values ('ZAR','710','2','','Rand'); -insert into currencies values ('ZMK','894','2','','Kwacha'); -insert into currencies values ('ZWD','716','2','','Zimbabwe Dollar'); +insert into currencies values ('NA',NULL,' ',NULL,'No universal currency'); +insert into currencies values ('ADP','20','0',NULL,'Andorran Peseta'); +insert into currencies values ('AED','784','2',NULL,'UAE Dirham'); +insert into currencies values ('AFA','4','2',NULL,'Afghani'); +insert into currencies values ('ALL','8','2',NULL,'Lek'); +insert into currencies values ('AMD','51','2',NULL,'Armenian Dram'); +insert into currencies values ('ANG','532','2',NULL,'Netherlands Antillan Guilder'); +insert into currencies values ('AOA','973','2',NULL,'Kwanza'); +insert into currencies values ('ARS','32','2',NULL,'Argentine Peso'); +insert into currencies values ('ATS','40','2',NULL,'Schilling'); +insert into currencies values ('AUD','36','2',NULL,'Australian Dollar'); +insert into currencies values ('AWG','533','2',NULL,'Aruban Guilder'); +insert into currencies values ('AZM','31','2',NULL,'Azerbaijanian Manat'); +insert into currencies values ('BAM','977','2',NULL,'Convertible Marks'); +insert into currencies values ('BBD','52','2',NULL,'Barbados Dollar'); +insert into currencies values ('BDT','50','2',NULL,'Taka'); +insert into currencies values ('BEF','56','0',NULL,'Belgian Franc'); +insert into currencies values ('BGL','100','2',NULL,'Lev'); +insert into currencies values ('BGN','975','2',NULL,'Bulgarian Lev'); +insert into currencies values ('BHD','48','3',NULL,'Bahraini Dinar'); +insert into currencies values ('BIF','108','0',NULL,'Burundi Franc'); +insert into currencies values ('BMD','60','2',NULL,'Bermudian Dollar'); +insert into currencies values ('BND','96','2',NULL,'Brunei Dollar'); +insert into currencies values ('BOB','68','2',NULL,'Boliviano'); +insert into currencies values ('BOV','984','2',NULL,'Mvdol'); +insert into currencies values ('BRL','986','2',NULL,'Brazilian Real'); +insert into currencies values ('BSD','44','2',NULL,'Bahamian Dollar'); +insert into currencies values ('BTN','64','2',NULL,'Ngultrum'); +insert into currencies values ('BWP','72','2',NULL,'Pula'); +insert into currencies values ('BYB','112','0',NULL,'Belarussian Ruble'); +insert into currencies values ('BYR','974','0',NULL,'Belarussian Ruble'); +insert into currencies values ('BZD','84','2',NULL,'Belize Dollar'); +insert into currencies values ('CAD','124','2',NULL,'Canadian Dollar'); +insert into currencies values ('CDF','976','2',NULL,'Franc Congolais'); +insert into currencies values ('CHF','756','2',NULL,'Swiss Franc'); +insert into currencies values ('CLF','990','0',NULL,'Unidades de fomento'); +insert into currencies values ('CLP','152','0',NULL,'Chilean Peso'); +insert into currencies values ('CNY','156','2',NULL,'Yuan Renminbi'); +insert into currencies values ('COP','170','2',NULL,'Colombian Peso'); +insert into currencies values ('CRC','188','2',NULL,'Costa Rican Colon'); +insert into currencies values ('CUP','192','2',NULL,'Cuban Peso'); +insert into currencies values ('CVE','132','2',NULL,'Cape Verde Escudo'); +insert into currencies values ('CYP','196','2',NULL,'Cyprus Pound'); +insert into currencies values ('CZK','203','2',NULL,'Czech Koruna'); +insert into currencies values ('DEM','276','2',NULL,'Deutsche Mark'); +insert into currencies values ('DJF','262','0',NULL,'Djibouti Franc'); +insert into currencies values ('DKK','208','2',NULL,'Danish Krone'); +insert into currencies values ('DOP','214','2',NULL,'Dominican Peso'); +insert into currencies values ('DZD','12','2',NULL,'Algerian Dinar'); +insert into currencies values ('EEK','233','2',NULL,'Kroon'); +insert into currencies values ('EGP','818','2',NULL,'Egyptian Pound'); +insert into currencies values ('ERN','232','2',NULL,'Nakfa'); +insert into currencies values ('ESP','724','0',NULL,'Spanish Peseta'); +insert into currencies values ('ETB','230','2',NULL,'Ethiopian Birr'); +insert into currencies values ('FIM','246','2',NULL,'Markka'); +insert into currencies values ('FJD','242','2',NULL,'Fiji Dollar'); +insert into currencies values ('FKP','238','2',NULL,'Falkland Islands Pound'); +insert into currencies values ('FRF','250','2',NULL,'French Franc'); +insert into currencies values ('GBP','826','2',NULL,'Pound Sterling'); +insert into currencies values ('GEL','981','2',NULL,'Lari'); +insert into currencies values ('GHC','288','2',NULL,'Cedi'); +insert into currencies values ('GIP','292','2',NULL,'Gibraltar Pound'); +insert into currencies values ('GMD','270','2',NULL,'Dalasi'); +insert into currencies values ('GNF','324','0',NULL,'Guinea Franc'); +insert into currencies values ('GRD','300','0',NULL,'Drachma'); +insert into currencies values ('GTQ','320','2',NULL,'Quetzal'); +insert into currencies values ('GWP','624','2',NULL,'Guinea-Bissau Peso'); +insert into currencies values ('GYD','328','2',NULL,'Guyana Dollar'); +insert into currencies values ('HKD','344','2',NULL,'Hong Kong Dollar'); +insert into currencies values ('HNL','340','2',NULL,'Lempira'); +insert into currencies values ('HRK','191','2',NULL,'Croatian kuna'); +insert into currencies values ('HTG','332','2',NULL,'Gourde'); +insert into currencies values ('HUF','348','2',NULL,'Forint'); +insert into currencies values ('IDR','360','2',NULL,'Rupiah'); +insert into currencies values ('IEP','372','2',NULL,'Irish Pound'); +insert into currencies values ('ILS','376','2',NULL,'New Israeli Sheqel'); +insert into currencies values ('INR','356','2',NULL,'Indian Rupee'); +insert into currencies values ('IQD','368','3',NULL,'Iraqi Dinar'); +insert into currencies values ('IRR','364','2',NULL,'Iranian Rial'); +insert into currencies values ('ISK','352','2',NULL,'Iceland Krona'); +insert into currencies values ('ITL','380','0',NULL,'Italian Lira'); +insert into currencies values ('JMD','388','2',NULL,'Jamaican Dollar'); +insert into currencies values ('JOD','400','3',NULL,'Jordanian Dinar'); +insert into currencies values ('JPY','392','0',NULL,'Yen'); +insert into currencies values ('KES','404','2',NULL,'Kenyan Shilling'); +insert into currencies values ('KGS','417','2',NULL,'Som'); +insert into currencies values ('KHR','116','2',NULL,'Riel'); +insert into currencies values ('KMF','174','0',NULL,'Comoro Franc'); +insert into currencies values ('KPW','408','2',NULL,'North Korean Won'); +insert into currencies values ('KRW','410','0',NULL,'Won'); +insert into currencies values ('KWD','414','3',NULL,'Kuwaiti Dinar'); +insert into currencies values ('KYD','136','2',NULL,'Cayman Islands Dollar'); +insert into currencies values ('KZT','398','2',NULL,'Tenge'); +insert into currencies values ('LAK','418','2',NULL,'Kip'); +insert into currencies values ('LBP','422','2',NULL,'Lebanese Pound'); +insert into currencies values ('LKR','144','2',NULL,'Sri Lanka Rupee'); +insert into currencies values ('LRD','430','2',NULL,'Liberian Dollar'); +insert into currencies values ('LSL','426','2',NULL,'Loti'); +insert into currencies values ('LTL','440','2',NULL,'Lithuanian Litus'); +insert into currencies values ('LUF','442','0',NULL,'Luxembourg Franc'); +insert into currencies values ('LVL','428','2',NULL,'Latvian Lats'); +insert into currencies values ('LYD','434','3',NULL,'Lybian Dinar'); +insert into currencies values ('MAD','504','2',NULL,'Moroccan Dirham'); +insert into currencies values ('MDL','498','2',NULL,'Moldovan Leu'); +insert into currencies values ('MGF','450','0',NULL,'Malagasy Franc'); +insert into currencies values ('MKD','807','2',NULL,'Denar'); +insert into currencies values ('MMK','104','2',NULL,'Kyat'); +insert into currencies values ('MNT','496','2',NULL,'Tugrik'); +insert into currencies values ('MOP','446','2',NULL,'Pataca'); +insert into currencies values ('MRO','478','2',NULL,'Ouguiya'); +insert into currencies values ('MTL','470','2',NULL,'Maltese Lira'); +insert into currencies values ('MUR','480','2',NULL,'Mauritius Rupee'); +insert into currencies values ('MVR','462','2',NULL,'Rufiyaa'); +insert into currencies values ('MWK','454','2',NULL,'Kwacha'); +insert into currencies values ('MXN','484','2',NULL,'Mexican Peso'); +insert into currencies values ('MXV','979','2',NULL,'Mexican Unidad de Inversion (UDI)'); +insert into currencies values ('MYR','458','2',NULL,'Malaysian Ringgit'); +insert into currencies values ('MZM','508','2',NULL,'Metical'); +insert into currencies values ('NAD','516','2',NULL,'Namibia Dollar'); +insert into currencies values ('NGN','566','2',NULL,'Naira'); +insert into currencies values ('NIO','558','2',NULL,'Cordoba Oro'); +insert into currencies values ('NLG','528','2',NULL,'Netherlands Guilder'); +insert into currencies values ('NOK','578','2',NULL,'Norvegian Krone'); +insert into currencies values ('NPR','524','2',NULL,'Nepalese Rupee'); +insert into currencies values ('NZD','554','2',NULL,'New Zealand Dollar'); +insert into currencies values ('OMR','512','3',NULL,'Rial Omani'); +insert into currencies values ('PAB','590','2',NULL,'Balboa'); +insert into currencies values ('PEN','604','2',NULL,'Nuevo Sol'); +insert into currencies values ('PGK','598','2',NULL,'Kina'); +insert into currencies values ('PHP','608','2',NULL,'Philippine Peso'); +insert into currencies values ('PKR','586','2',NULL,'Pakistan Rupee'); +insert into currencies values ('PLN','985','2',NULL,'Zloty'); +insert into currencies values ('PTE','620','0',NULL,'Portuguese Escudo'); +insert into currencies values ('PYG','600','0',NULL,'Guarani'); +insert into currencies values ('QAR','634','2',NULL,'Qatari Rial'); +insert into currencies values ('ROL','642','2',NULL,'Leu'); +insert into currencies values ('RUB','643','2',NULL,'Russian Ruble'); +insert into currencies values ('RUR','810','2',NULL,'Russian Ruble'); +insert into currencies values ('RWF','646','0',NULL,'Rwanda Franc'); +insert into currencies values ('SAR','682','2',NULL,'Saudi Riyal'); +insert into currencies values ('SBD','90','2',NULL,'Solomon Islands Dollar'); +insert into currencies values ('SCR','690','2',NULL,'Seychelles Rupee'); +insert into currencies values ('SDD','736','2',NULL,'Sudanese Dinar'); +insert into currencies values ('SEK','752','2',NULL,'Swedish Krona'); +insert into currencies values ('SGD','702','2',NULL,'Singapore Dollar'); +insert into currencies values ('SHP','654','2',NULL,'Saint Helena Pound'); +insert into currencies values ('SIT','705','2',NULL,'Tolar'); +insert into currencies values ('SKK','703','2',NULL,'Slovak Koruna'); +insert into currencies values ('SLL','694','2',NULL,'Leone'); +insert into currencies values ('SOS','706','2',NULL,'Somali Shilling'); +insert into currencies values ('SRG','740','2',NULL,'Suriname Guilder'); +insert into currencies values ('STD','678','2',NULL,'Dobra'); +insert into currencies values ('SVC','222','2',NULL,'El Salvador Colon'); +insert into currencies values ('SYP','760','2',NULL,'Syrian Pound'); +insert into currencies values ('SZL','748','2',NULL,'Lilangeni'); +insert into currencies values ('THB','764','2',NULL,'Baht'); +insert into currencies values ('TJR','762','0',NULL,'Tajik Ruble'); +insert into currencies values ('TJS','972','0',NULL,'Somoni'); +insert into currencies values ('TMM','795','2',NULL,'Manat'); +insert into currencies values ('TND','788','3',NULL,'Tunisian Dinar'); +insert into currencies values ('TOP','776','2',NULL,'Paaaaanga'); +insert into currencies values ('TPE','626','0',NULL,'Timor Escudo'); +insert into currencies values ('TRL','792','0',NULL,'Turkish Lira'); +insert into currencies values ('TTD','780','2',NULL,'Trinidad and Tobago Dollar'); +insert into currencies values ('TWD','901','2',NULL,'New Taiwan Dollar'); +insert into currencies values ('TZS','834','2',NULL,'Tanzanian Shilling'); +insert into currencies values ('UAH','980','2',NULL,'Hryvnia'); +insert into currencies values ('UGX','800','2',NULL,'Uganda Shilling'); +insert into currencies values ('USD','840','2',NULL,'US Dollar'); +insert into currencies values ('USN','997','2',NULL,'US Dollar (Next day)'); +insert into currencies values ('USS','998','2',NULL,'US Dollar (Same day)'); +insert into currencies values ('UYU','858','2',NULL,'Peso Uruguayo'); +insert into currencies values ('UZS','860','2',NULL,'Uzbekistan Sum'); +insert into currencies values ('VEB','862','2',NULL,'Bolivar'); +insert into currencies values ('VND','704','2',NULL,'Dong'); +insert into currencies values ('VUV','548','0',NULL,'Vatu'); +insert into currencies values ('WST','882','2',NULL,'Tala'); +insert into currencies values ('XAF','950','0',NULL,'CFA Franc BEAC'); +insert into currencies values ('XCD','951','2',NULL,'East Carribbean Dollar'); +insert into currencies values ('XOF','952','0',NULL,'CFA Franc BCEAO'); +insert into currencies values ('XPF','953','0',NULL,'CFP Franc'); +insert into currencies values ('YER','886','2',NULL,'Yemeni Rial'); +insert into currencies values ('YUM','891','2',NULL,'Yugoslavian Dinar'); +insert into currencies values ('ZAR','710','2',NULL,'Rand'); +insert into currencies values ('ZMK','894','2',NULL,'Kwacha'); +insert into currencies values ('ZWD','716','2',NULL,'Zimbabwe Dollar'); -- set feedback on; commit;