Index: openacs-4/packages/acs-reference/sql/common/country-data.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/country-data.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-reference/sql/common/country-data.sql 17 Jul 2001 05:03:21 -0000 1.1 @@ -0,0 +1,259 @@ +-- packages/acs-reference/sql/common/country.sql +-- +-- @author jon@jongriffin.com.com +-- @creation-date 2000-11-21 +-- @cvs-id $Id: country-data.sql,v 1.1 2001/07/17 05:03:21 jong Exp $ + +-- country is taken from ISO 3166 + +-- I need to know the easy way to add extended chars in sqlplus then I can add french and spanish + +-- ISO country codes + +--set feedback off; + +insert into countries (default_name,iso) values ('AFGHANISTAN','AF'); +insert into countries (default_name,iso) values ('ALBANIA','AL'); +insert into countries (default_name,iso) values ('ALGERIA','DZ'); +insert into countries (default_name,iso) values ('AMERICAN SAMOA','AS'); +insert into countries (default_name,iso) values ('ANDORRA','AD'); +insert into countries (default_name,iso) values ('ANGOLA','AO'); +insert into countries (default_name,iso) values ('ANGUILLA','AI'); +insert into countries (default_name,iso) values ('ANTARCTICA','AQ'); +insert into countries (default_name,iso) values ('ANTIGUA AND BARBUDA','AG'); +insert into countries (default_name,iso) values ('ARGENTINA','AR'); +insert into countries (default_name,iso) values ('ARMENIA','AM'); +insert into countries (default_name,iso) values ('ARUBA','AW'); +insert into countries (default_name,iso) values ('AUSTRALIA','AU'); +insert into countries (default_name,iso) values ('AUSTRIA','AT'); +insert into countries (default_name,iso) values ('AZERBAIJAN','AZ'); +insert into countries (default_name,iso) values ('BAHAMAS','BS'); +insert into countries (default_name,iso) values ('BAHRAIN','BH'); +insert into countries (default_name,iso) values ('BANGLADESH','BD'); +insert into countries (default_name,iso) values ('BARBADOS','BB'); +insert into countries (default_name,iso) values ('BELARUS','BY'); +insert into countries (default_name,iso) values ('BELGIUM','BE'); +insert into countries (default_name,iso) values ('BELIZE','BZ'); +insert into countries (default_name,iso) values ('BENIN','BJ'); +insert into countries (default_name,iso) values ('BERMUDA','BM'); +insert into countries (default_name,iso) values ('BHUTAN','BT'); +insert into countries (default_name,iso) values ('BOLIVIA','BO'); +insert into countries (default_name,iso) values ('BOSNIA AND HERZEGOVINA','BA'); +insert into countries (default_name,iso) values ('BOTSWANA','BW'); +insert into countries (default_name,iso) values ('BOUVET ISLAND','BV'); +insert into countries (default_name,iso) values ('BRAZIL','BR'); +insert into countries (default_name,iso) values ('BRITISH INDIAN OCEAN TERRITORY','IO'); +insert into countries (default_name,iso) values ('BRUNEI DARUSSALAM','BN'); +insert into countries (default_name,iso) values ('BULGARIA','BG'); +insert into countries (default_name,iso) values ('BURKINA FASO','BF'); +insert into countries (default_name,iso) values ('BURUNDI','BI'); +insert into countries (default_name,iso) values ('CAMBODIA','KH'); +insert into countries (default_name,iso) values ('CAMEROON','CM'); +insert into countries (default_name,iso) values ('CANADA','CA'); +insert into countries (default_name,iso) values ('CAPE VERDE','CV'); +insert into countries (default_name,iso) values ('CAYMAN ISLANDS','KY'); +insert into countries (default_name,iso) values ('CENTRAL AFRICAN REPUBLIC','CF'); +insert into countries (default_name,iso) values ('CHAD','TD'); +insert into countries (default_name,iso) values ('CHILE','CL'); +insert into countries (default_name,iso) values ('CHINA','CN'); +insert into countries (default_name,iso) values ('CHRISTMAS ISLAND','CX'); +insert into countries (default_name,iso) values ('COCOS (KEELING) ISLANDS','CC'); +insert into countries (default_name,iso) values ('COLOMBIA','CO'); +insert into countries (default_name,iso) values ('COMOROS','KM'); +insert into countries (default_name,iso) values ('CONGO','CG'); +insert into countries (default_name,iso) values ('CONGO, THE DEMOCRATIC REPUBLIC OF THE','CD'); +insert into countries (default_name,iso) values ('COOK ISLANDS','CK'); +insert into countries (default_name,iso) values ('COSTA RICA','CR'); +insert into countries (default_name,iso) values ('COTE D''IVOIRE','CI'); +insert into countries (default_name,iso) values ('CROATIA','HR'); +insert into countries (default_name,iso) values ('CUBA','CU'); +insert into countries (default_name,iso) values ('CYPRUS','CY'); +insert into countries (default_name,iso) values ('CZECH REPUBLIC','CZ'); +insert into countries (default_name,iso) values ('DENMARK','DK'); +insert into countries (default_name,iso) values ('DJIBOUTI','DJ'); +insert into countries (default_name,iso) values ('DOMINICA','DM'); +insert into countries (default_name,iso) values ('DOMINICAN REPUBLIC','DO'); +insert into countries (default_name,iso) values ('EAST TIMOR','TP'); +insert into countries (default_name,iso) values ('ECUADOR','EC'); +insert into countries (default_name,iso) values ('EGYPT','EG'); +insert into countries (default_name,iso) values ('EL SALVADOR','SV'); +insert into countries (default_name,iso) values ('EQUATORIAL GUINEA','GQ'); +insert into countries (default_name,iso) values ('ERITREA','ER'); +insert into countries (default_name,iso) values ('ESTONIA','EE'); +insert into countries (default_name,iso) values ('ETHIOPIA','ET'); +insert into countries (default_name,iso) values ('FALKLAND ISLANDS (MALVINAS)','FK'); +insert into countries (default_name,iso) values ('FAROE ISLANDS','FO'); +insert into countries (default_name,iso) values ('FIJI','FJ'); +insert into countries (default_name,iso) values ('FINLAND','FI'); +insert into countries (default_name,iso) values ('FRANCE','FR'); +insert into countries (default_name,iso) values ('FRENCH GUIANA','GF'); +insert into countries (default_name,iso) values ('FRENCH POLYNESIA','PF'); +insert into countries (default_name,iso) values ('FRENCH SOUTHERN TERRITORIES','TF'); +insert into countries (default_name,iso) values ('GABON','GA'); +insert into countries (default_name,iso) values ('GAMBIA','GM'); +insert into countries (default_name,iso) values ('GEORGIA','GE'); +insert into countries (default_name,iso) values ('GERMANY','DE'); +insert into countries (default_name,iso) values ('GHANA','GH'); +insert into countries (default_name,iso) values ('GIBRALTAR','GI'); +insert into countries (default_name,iso) values ('GREECE','GR'); +insert into countries (default_name,iso) values ('GREENLAND','GL'); +insert into countries (default_name,iso) values ('GRENADA','GD'); +insert into countries (default_name,iso) values ('GUADELOUPE','GP'); +insert into countries (default_name,iso) values ('GUAM','GU'); +insert into countries (default_name,iso) values ('GUATEMALA','GT'); +insert into countries (default_name,iso) values ('GUINEA','GN'); +insert into countries (default_name,iso) values ('GUINEA-BISSAU','GW'); +insert into countries (default_name,iso) values ('GUYANA','GY'); +insert into countries (default_name,iso) values ('HAITI','HT'); +insert into countries (default_name,iso) values ('HEARD ISLAND AND MCDONALD ISLANDS','HM'); +insert into countries (default_name,iso) values ('HOLY SEE (VATICAN CITY STATE)','VA'); +insert into countries (default_name,iso) values ('HONDURAS','HN'); +insert into countries (default_name,iso) values ('HONG KONG','HK'); +insert into countries (default_name,iso) values ('HUNGARY','HU'); +insert into countries (default_name,iso) values ('ICELAND','IS'); +insert into countries (default_name,iso) values ('INDIA','IN'); +insert into countries (default_name,iso) values ('INDONESIA','ID'); +insert into countries (default_name,iso) values ('IRAN, ISLAMIC REPUBLIC OF','IR'); +insert into countries (default_name,iso) values ('IRAQ','IQ'); +insert into countries (default_name,iso) values ('IRELAND','IE'); +insert into countries (default_name,iso) values ('ISRAEL','IL'); +insert into countries (default_name,iso) values ('ITALY','IT'); +insert into countries (default_name,iso) values ('JAMAICA','JM'); +insert into countries (default_name,iso) values ('JAPAN','JP'); +insert into countries (default_name,iso) values ('JORDAN','JO'); +insert into countries (default_name,iso) values ('KAZAKSTAN','KZ'); +insert into countries (default_name,iso) values ('KENYA','KE'); +insert into countries (default_name,iso) values ('KIRIBATI','KI'); +insert into countries (default_name,iso) values ('KOREA, DEMOCRATIC PEOPLE''S REPUBLIC OF','KP'); +insert into countries (default_name,iso) values ('KOREA, REPUBLIC OF','KR'); +insert into countries (default_name,iso) values ('KUWAIT','KW'); +insert into countries (default_name,iso) values ('KYRGYZSTAN','KG'); +insert into countries (default_name,iso) values ('LAO PEOPLE''S DEMOCRATIC REPUBLIC','LA'); +insert into countries (default_name,iso) values ('LATVIA','LV'); +insert into countries (default_name,iso) values ('LEBANON','LB'); +insert into countries (default_name,iso) values ('LESOTHO','LS'); +insert into countries (default_name,iso) values ('LIBERIA','LR'); +insert into countries (default_name,iso) values ('LIBYAN ARAB JAMAHIRIYA','LY'); +insert into countries (default_name,iso) values ('LIECHTENSTEIN','LI'); +insert into countries (default_name,iso) values ('LITHUANIA','LT'); +insert into countries (default_name,iso) values ('LUXEMBOURG','LU'); +insert into countries (default_name,iso) values ('MACAU','MO'); +insert into countries (default_name,iso) values ('MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','MK'); +insert into countries (default_name,iso) values ('MADAGASCAR','MG'); +insert into countries (default_name,iso) values ('MALAWI','MW'); +insert into countries (default_name,iso) values ('MALAYSIA','MY'); +insert into countries (default_name,iso) values ('MALDIVES','MV'); +insert into countries (default_name,iso) values ('MALI','ML'); +insert into countries (default_name,iso) values ('MALTA','MT'); +insert into countries (default_name,iso) values ('MARSHALL ISLANDS','MH'); +insert into countries (default_name,iso) values ('MARTINIQUE','MQ'); +insert into countries (default_name,iso) values ('MAURITANIA','MR'); +insert into countries (default_name,iso) values ('MAURITIUS','MU'); +insert into countries (default_name,iso) values ('MAYOTTE','YT'); +insert into countries (default_name,iso) values ('MEXICO','MX'); +insert into countries (default_name,iso) values ('MICRONESIA, FEDERATED STATES OF','FM'); +insert into countries (default_name,iso) values ('MOLDOVA, REPUBLIC OF','MD'); +insert into countries (default_name,iso) values ('MONACO','MC'); +insert into countries (default_name,iso) values ('MONGOLIA','MN'); +insert into countries (default_name,iso) values ('MONTSERRAT','MS'); +insert into countries (default_name,iso) values ('MOROCCO','MA'); +insert into countries (default_name,iso) values ('MOZAMBIQUE','MZ'); +insert into countries (default_name,iso) values ('MYANMAR','MM'); +insert into countries (default_name,iso) values ('NAMIBIA','NA'); +insert into countries (default_name,iso) values ('NAURU','NR'); +insert into countries (default_name,iso) values ('NEPAL','NP'); +insert into countries (default_name,iso) values ('NETHERLANDS','NL'); +insert into countries (default_name,iso) values ('NETHERLANDS ANTILLES','AN'); +insert into countries (default_name,iso) values ('NEW CALEDONIA','NC'); +insert into countries (default_name,iso) values ('NEW ZEALAND','NZ'); +insert into countries (default_name,iso) values ('NICARAGUA','NI'); +insert into countries (default_name,iso) values ('NIGER','NE'); +insert into countries (default_name,iso) values ('NIGERIA','NG'); +insert into countries (default_name,iso) values ('NIUE','NU'); +insert into countries (default_name,iso) values ('NORFOLK ISLAND','NF'); +insert into countries (default_name,iso) values ('NORTHERN MARIANA ISLANDS','MP'); +insert into countries (default_name,iso) values ('NORWAY','NO'); +insert into countries (default_name,iso) values ('OMAN','OM'); +insert into countries (default_name,iso) values ('PAKISTAN','PK'); +insert into countries (default_name,iso) values ('PALAU','PW'); +insert into countries (default_name,iso) values ('PALESTINIAN TERRITORY, OCCUPIED','PS'); +insert into countries (default_name,iso) values ('PANAMA','PA'); +insert into countries (default_name,iso) values ('PAPUA NEW GUINEA','PG'); +insert into countries (default_name,iso) values ('PARAGUAY','PY'); +insert into countries (default_name,iso) values ('PERU','PE'); +insert into countries (default_name,iso) values ('PHILIPPINES','PH'); +insert into countries (default_name,iso) values ('PITCAIRN','PN'); +insert into countries (default_name,iso) values ('POLAND','PL'); +insert into countries (default_name,iso) values ('PORTUGAL','PT'); +insert into countries (default_name,iso) values ('PUERTO RICO','PR'); +insert into countries (default_name,iso) values ('QATAR','QA'); +insert into countries (default_name,iso) values ('REUNION','RE'); +insert into countries (default_name,iso) values ('ROMANIA','RO'); +insert into countries (default_name,iso) values ('RUSSIAN FEDERATION','RU'); +insert into countries (default_name,iso) values ('RWANDA','RW'); +insert into countries (default_name,iso) values ('SAINT HELENA','SH'); +insert into countries (default_name,iso) values ('SAINT KITTS AND NEVIS','KN'); +insert into countries (default_name,iso) values ('SAINT LUCIA','LC'); +insert into countries (default_name,iso) values ('SAINT PIERRE AND MIQUELON','PM'); +insert into countries (default_name,iso) values ('SAINT VINCENT AND THE GRENADINES','VC'); +insert into countries (default_name,iso) values ('SAMOA','WS'); +insert into countries (default_name,iso) values ('SAN MARINO','SM'); +insert into countries (default_name,iso) values ('SAO TOME AND PRINCIPE','ST'); +insert into countries (default_name,iso) values ('SAUDI ARABIA','SA'); +insert into countries (default_name,iso) values ('SENEGAL','SN'); +insert into countries (default_name,iso) values ('SEYCHELLES','SC'); +insert into countries (default_name,iso) values ('SIERRA LEONE','SL'); +insert into countries (default_name,iso) values ('SINGAPORE','SG'); +insert into countries (default_name,iso) values ('SLOVAKIA','SK'); +insert into countries (default_name,iso) values ('SLOVENIA','SI'); +insert into countries (default_name,iso) values ('SOLOMON ISLANDS','SB'); +insert into countries (default_name,iso) values ('SOMALIA','SO'); +insert into countries (default_name,iso) values ('SOUTH AFRICA','ZA'); +insert into countries (default_name,iso) values ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS'); +insert into countries (default_name,iso) values ('SPAIN','ES'); +insert into countries (default_name,iso) values ('SRI LANKA','LK'); +insert into countries (default_name,iso) values ('SUDAN','SD'); +insert into countries (default_name,iso) values ('SURINAME','SR'); +insert into countries (default_name,iso) values ('SVALBARD AND JAN MAYEN','SJ'); +insert into countries (default_name,iso) values ('SWAZILAND','SZ'); +insert into countries (default_name,iso) values ('SWEDEN','SE'); +insert into countries (default_name,iso) values ('SWITZERLAND','CH'); +insert into countries (default_name,iso) values ('SYRIAN ARAB REPUBLIC','SY'); +insert into countries (default_name,iso) values ('TAIWAN, PROVINCE OF CHINA','TW'); +insert into countries (default_name,iso) values ('TAJIKISTAN','TJ'); +insert into countries (default_name,iso) values ('TANZANIA, UNITED REPUBLIC OF','TZ'); +insert into countries (default_name,iso) values ('THAILAND','TH'); +insert into countries (default_name,iso) values ('TOGO','TG'); +insert into countries (default_name,iso) values ('TOKELAU','TK'); +insert into countries (default_name,iso) values ('TONGA','TO'); +insert into countries (default_name,iso) values ('TRINIDAD AND TOBAGO','TT'); +insert into countries (default_name,iso) values ('TUNISIA','TN'); +insert into countries (default_name,iso) values ('TURKEY','TR'); +insert into countries (default_name,iso) values ('TURKMENISTAN','TM'); +insert into countries (default_name,iso) values ('TURKS AND CAICOS ISLANDS','TC'); +insert into countries (default_name,iso) values ('TUVALU','TV'); +insert into countries (default_name,iso) values ('UGANDA','UG'); +insert into countries (default_name,iso) values ('UKRAINE','UA'); +insert into countries (default_name,iso) values ('UNITED ARAB EMIRATES','AE'); +insert into countries (default_name,iso) values ('UNITED KINGDOM','GB'); +insert into countries (default_name,iso) values ('UNITED STATES','US'); +insert into countries (default_name,iso) values ('UNITED STATES MINOR OUTLYING ISLANDS','UM'); +insert into countries (default_name,iso) values ('URUGUAY','UY'); +insert into countries (default_name,iso) values ('UZBEKISTAN','UZ'); +insert into countries (default_name,iso) values ('VANUATU','VU'); +insert into countries (default_name,iso) values ('VENEZUELA','VE'); +insert into countries (default_name,iso) values ('VIET NAM','VN'); +insert into countries (default_name,iso) values ('VIRGIN ISLANDS, BRITISH','VG'); +insert into countries (default_name,iso) values ('VIRGIN ISLANDS, U.S.','VI'); +insert into countries (default_name,iso) values ('WALLIS AND FUTUNA','WF'); +insert into countries (default_name,iso) values ('WESTERN SAHARA','EH'); +insert into countries (default_name,iso) values ('YEMEN','YE'); +insert into countries (default_name,iso) values ('YUGOSLAVIA','YU'); +insert into countries (default_name,iso) values ('ZAMBIA','ZM'); +insert into countries (default_name,iso) values ('ZIMBABWE','ZW'); + +-- set feedback on; +commit; + + + Index: openacs-4/packages/acs-reference/sql/common/currency-data.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/currency-data.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-reference/sql/common/currency-data.sql 17 Jul 2001 05:03:21 -0000 1.1 @@ -0,0 +1,205 @@ +-- packages/acs-reference/sql/common/currency.sql +-- +-- @author jon@jongriffin.com +-- @creation-date 2000-11-29 +-- @cvs-id $Id: currency-data.sql,v 1.1 2001/07/17 05:03:21 jong Exp $ + +-- initial data for currencies + +-- 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'); + +-- set feedback on; +commit; + + + + + + Index: openacs-4/packages/acs-reference/sql/common/language-data.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/common/Attic/language-data.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-reference/sql/common/language-data.sql 17 Jul 2001 05:03:21 -0000 1.1 @@ -0,0 +1,146 @@ +-- packages/acs-reference/sql/common/language.sql +-- +-- @author jon@jongriffin.com +-- @creation-date 2000-11-21 +-- @cvs-id $Id: language-data.sql,v 1.1 2001/07/17 05:03:21 jong Exp $ +-- +-- add some data +insert into language_codes values ('aa','Afar'); +insert into language_codes values ('ab','Abkhazian'); +insert into language_codes values ('af','Afrikaans'); +insert into language_codes values ('am','Amharic'); +insert into language_codes values ('ar','Arabic'); +insert into language_codes values ('as','Assamese'); +insert into language_codes values ('ay','Aymara'); +insert into language_codes values ('az','Azerbaijani'); +insert into language_codes values ('ba','Bashkir'); +insert into language_codes values ('be','Byelorussian'); +insert into language_codes values ('bg','Bulgarian'); +insert into language_codes values ('bh','Bihari'); +insert into language_codes values ('bi','Bislama'); +insert into language_codes values ('bn','Bengali; Bangla'); +insert into language_codes values ('bo','Tibetan'); +insert into language_codes values ('br','Breton'); +insert into language_codes values ('ca','Catalan'); +insert into language_codes values ('co','Corsican'); +insert into language_codes values ('cs','Czech'); +insert into language_codes values ('cy','Welsh'); +insert into language_codes values ('da','Danish'); +insert into language_codes values ('de','German'); +insert into language_codes values ('dz','Bhutani'); +insert into language_codes values ('el','Greek'); +insert into language_codes values ('en','English'); +insert into language_codes values ('eo','Esperanto'); +insert into language_codes values ('es','Spanish'); +insert into language_codes values ('et','Estonian'); +insert into language_codes values ('eu','Basque'); +insert into language_codes values ('fa','Persian'); +insert into language_codes values ('fi','Finnish'); +insert into language_codes values ('fj','Fiji'); +insert into language_codes values ('fo','Faeroese'); +insert into language_codes values ('fr','French'); +insert into language_codes values ('fy','Frisian'); +insert into language_codes values ('ga','Irish'); +insert into language_codes values ('gd','Scots Gaelic'); +insert into language_codes values ('gl','Galician'); +insert into language_codes values ('gn','Guarani'); +insert into language_codes values ('gu','Gujarati'); +insert into language_codes values ('ha','Hausa'); +insert into language_codes values ('hi','Hindi'); +insert into language_codes values ('hr','Croatian'); +insert into language_codes values ('hu','Hungarian'); +insert into language_codes values ('hy','Armenian'); +insert into language_codes values ('ia','Interlingua'); +insert into language_codes values ('ie','Interlingue'); +insert into language_codes values ('ik','Inupiak'); +insert into language_codes values ('in','Indonesian'); +insert into language_codes values ('is','Icelandic'); +insert into language_codes values ('it','Italian'); +insert into language_codes values ('iw','Hebrew'); +insert into language_codes values ('ja','Japanese'); +insert into language_codes values ('ji','Yiddish'); +insert into language_codes values ('jw','Javanese'); +insert into language_codes values ('ka','Georgian'); +insert into language_codes values ('kk','Kazakh'); +insert into language_codes values ('kl','Greenlandic'); +insert into language_codes values ('km','Cambodian'); +insert into language_codes values ('kn','Kannada'); +insert into language_codes values ('ko','Korean'); +insert into language_codes values ('ks','Kashmiri'); +insert into language_codes values ('ku','Kurdish'); +insert into language_codes values ('ky','Kirghiz'); +insert into language_codes values ('la','Latin'); +insert into language_codes values ('ln','Lingala'); +insert into language_codes values ('lo','Laothian'); +insert into language_codes values ('lt','Lithuanian'); +insert into language_codes values ('lv','Latvian, Lettish'); +insert into language_codes values ('mg','Malagasy'); +insert into language_codes values ('mi','Maori'); +insert into language_codes values ('mk','Macedonian'); +insert into language_codes values ('ml','Malayalam'); +insert into language_codes values ('mn','Mongolian'); +insert into language_codes values ('mo','Moldavian'); +insert into language_codes values ('mr','Marathi'); +insert into language_codes values ('ms','Malay'); +insert into language_codes values ('mt','Maltese'); +insert into language_codes values ('my','Burmese'); +insert into language_codes values ('na','Nauru'); +insert into language_codes values ('ne','Nepali'); +insert into language_codes values ('nl','Dutch'); +insert into language_codes values ('no','Norwegian'); +insert into language_codes values ('oc','Occitan'); +insert into language_codes values ('om','(Afan) Oromo'); +insert into language_codes values ('or','Oriya'); +insert into language_codes values ('pa','Punjabi'); +insert into language_codes values ('pl','Polish'); +insert into language_codes values ('ps','Pashto, Pushto'); +insert into language_codes values ('pt','Portuguese'); +insert into language_codes values ('qu','Quechua'); +insert into language_codes values ('rm','Rhaeto-Romance'); +insert into language_codes values ('rn','Kirundia'); +insert into language_codes values ('ro','Romanian'); +insert into language_codes values ('ru','Russian'); +insert into language_codes values ('rw','Kinyarwanda'); +insert into language_codes values ('sa','Sanskrit'); +insert into language_codes values ('sd','Sindhi'); +insert into language_codes values ('sg','Sangro'); +insert into language_codes values ('sh','Serbo-Croatian'); +insert into language_codes values ('si','Singhalese'); +insert into language_codes values ('sk','Slovak'); +insert into language_codes values ('sl','Slovenian'); +insert into language_codes values ('sm','Samoan'); +insert into language_codes values ('sn','Shona'); +insert into language_codes values ('so','Somali'); +insert into language_codes values ('sq','Albanian'); +insert into language_codes values ('sr','Serbian'); +insert into language_codes values ('ss','Siswati'); +insert into language_codes values ('st','Sesotho'); +insert into language_codes values ('su','Sundanese'); +insert into language_codes values ('sv','Swedish'); +insert into language_codes values ('sw','Swahili'); +insert into language_codes values ('ta','Tamil'); +insert into language_codes values ('te','Tegulu'); +insert into language_codes values ('tg','Tajik'); +insert into language_codes values ('th','Thai'); +insert into language_codes values ('ti','Tigrinya'); +insert into language_codes values ('tk','Turkmen'); +insert into language_codes values ('tl','Tagalog'); +insert into language_codes values ('tn','Setswana'); +insert into language_codes values ('to','Tonga'); +insert into language_codes values ('tr','Turkish'); +insert into language_codes values ('ts','Tsonga'); +insert into language_codes values ('tt','Tatar'); +insert into language_codes values ('tw','Twi'); +insert into language_codes values ('uk','Ukrainian'); +insert into language_codes values ('ur','Urdu'); +insert into language_codes values ('uz','Uzbek'); +insert into language_codes values ('vi','Vietnamese'); +insert into language_codes values ('vo','Volapuk'); +insert into language_codes values ('wo','Wolof'); +insert into language_codes values ('xh','Xhosa'); +insert into language_codes values ('yo','Yoruab'); +insert into language_codes values ('zh','Chinese'); +insert into language_codes values ('zu','Zulu'); + +commit; +-- end language.sql \ No newline at end of file