User Tools

Site Tools


podoc:currency_sql_table

Database Table Description of "currency"

Name

currency

Description

A list of all known currency types.

Purpose

Referential integrity from the shop module.

Schema

CREATE TABLE currency (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  numeric_code          NUMERIC,
  alpha_code            VARCHAR(5),
  name                  VARCHAR(40),
  entity                text
);

References tables

None.

Is referenced by tables

None.

None.

None.

History

Used first

Version 2.8

Used last

Version 2.33

Schema change history

= Version 2.8 =

CREATE TABLE currency (
  identifier            INTEGER NOT NULL PRIMARY KEY,
  numeric_code          NUMERIC,
  alpha_code            VARCHAR(5),
  name                  VARCHAR(40),
  entity                text
);

= Version 2.34 =

DROP TABLE currency;
Data change history

= Version 2.8 =

INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 784, 'AED', 'UAE Dirham', 'United Arab Emirats');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 004, 'AFA', 'Afghani', 'Afghanistan');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 008, 'ALL', 'Lek', 'Albania');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 532, 'ANG', 'Antillian Guilder', 'Netherlands Antilles');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 024, 'AOK', 'Kwanza', 'Angola');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 032, 'ARP', 'Argentine Peso', 'Argentina');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 036, 'AUD', 'Australian Dollar', 'Australia, Christmas Island, Cocos (Keeling) Islands, Heard and McDonald Islands, Kiribati, Nauru, Norfolk Island, Tuvalu');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 052, 'BBD', 'Barbados Dollar', 'Barbados');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 050, 'BDT', 'Taka', 'Bangladesh');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 100, 'BGL', 'Lev', 'Bulgaria');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 048, 'BHD', 'Bahraini Dinar', 'Bahrain');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 108, 'BIF', 'Burundi Franc', 'Burundi');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 060, 'BMD', 'Bermudan Dollar', 'Burmuda');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 096, 'BND', 'Brunei Dollar', 'Brunei');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 068, 'BOP', 'Bolivian Peso', 'Bolivia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 076, 'BRC', 'Cruzeiro', 'Brazil');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 044, 'BSD', 'Bahamian Dollar', 'Bahamas');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 104, 'BUK', 'Kyat', 'Burma');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 072, 'BWP', 'Pula', 'Botswana');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 084, 'BZD', 'Belize Dollar', 'Belize');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 124, 'CAD', 'Canadian Dollar', 'Canada');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 756, 'CHF', 'Swiss Franc', 'Liechtenstein, Switzerland');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 152, 'CLP', 'Chilean Peso', 'Chile');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 156, 'CNY', 'Yuan Renminbi', 'China');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 170, 'COP', 'Colombian Peso', 'Colombia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 188, 'CRC', 'Costa Rican Colon', 'Costa Rica');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 200, 'CSK', 'Koruna', 'Czechoslovakia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 192, 'CUP', 'Cuban Peso', 'Cuba');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 132, 'CVE', 'Cape Verde Escudo', 'Cape Verde');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 196, 'CYP', 'Cyprus Pound', 'Cyprus');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 262, 'DJF', 'Djibouti Franc', 'Djibouti');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 208, 'DKK', 'Danish Krone', 'Denmark, Faeroe Islands, Greenland');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 214, 'DOP', 'Dominican Peso', 'Dominican Republic');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 012, 'DZD', 'Algerian Dinar', 'Algeria');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 218, 'ECS', 'Sucre', 'Ecuador');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 818, 'EGP', 'Egyptian Pound', 'Egypt');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 230, 'ETB', 'Ethiopian Birr', 'Ethiopia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 954, 'EUR', 'European Currency Unit', 'Euro Monetary Cooperation Found (EMCF)');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 242, 'FJD', 'Fiji Dollar', 'Fiji');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 238, 'FKP', 'Falkland Islands Pound', 'Falkland Islands (Malvinas)');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 826, 'GBP', 'Pound Sterling', 'Canton and Enderbury Islands, United Kingdom');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 288, 'GHC', 'Cedi', 'Ghana');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 292, 'GIP', 'Gibraltar Pound', 'Gibraltar');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 270, 'GMD', 'Dalasi', 'Gambia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 324, 'GNS', 'Syli', 'Guinea');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 226, 'GQE', 'Ekwele', 'Equatorial Guinea');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 320, 'GTQ', 'Quetzal', 'Guatemala');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 624, 'GWP', 'Guinea-Bissau Peso', 'Guinea-Bissau');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 328, 'GYD', 'Guyana Dollar', 'Guyana');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 344, 'HKD', 'Hong Kong Dollar', 'Hong Kong');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 340, 'HNL', 'Lempira', 'Honduras');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 332, 'HTG', 'Gourde', 'Haiti');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 348, 'HUF', 'Forint', 'Hungary');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 360, 'IDR', 'Rupiah', 'Indonesia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 376, 'ILS', 'Shekel', 'Israel');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 356, 'INR', 'Indian Rupee', 'Bhutan, India');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 368, 'IQD', 'Iraqi Dinar', 'Iraq, Neutral Zone (betw. Saudi A. & Iraq)');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 364, 'IRR', 'Iranian Rial', 'Iran');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 352, 'ISK', 'Iceland Krona', 'Iceland');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 388, 'JMD', 'Jamaican Dollar', 'Jamaica');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 400, 'JOD', 'Jordanian dinar', 'Jordan');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 392, 'JPY', 'Yen', 'Japan');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 404, 'KES', 'Kenyan Shilling', 'Kenya');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 116, 'KHR', 'Riel', 'Kampuchea, Democratic');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 174, 'KMF', 'Comoros Franc', 'Comoros');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 408, 'KPW', 'North Korean Won', 'Korea, Democratic People\'s of');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 410, 'KRW', 'Won', 'Korea, Republic of');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 414, 'KWD', 'Kuwaiti Dinar', 'Kuwait, Neutral Zone (betw. Saudi A. & Iraq)');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 136, 'KYD', 'Cayman Islands Dollar', 'Cayman Islands');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 418, 'LAK', 'Kip', 'Lao People\'s Democratic Republic');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 422, 'LBP', 'Lebanese Pound', 'Lebanon');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 144, 'LKR', 'Sri Lanka Rupee', 'Sri Lanka');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 430, 'LRD', 'Liberian Dollar', 'Liberia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 426, 'LSM', 'Maloti', 'Lesotho');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 434, 'LYD', 'Libyan Dinar', 'Libyan Arab Jamahiriya');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 504, 'MAD', 'Moroccan Dirham', 'Morocco, Western Sahara');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 450, 'MGF', 'Malagasy Franc', 'Madagascar');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 466, 'MLF', 'Mali Franc', 'Mali');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 496, 'MNT', 'Tugrik', 'Mongolia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 446, 'MOP', 'Pataca', 'Macau');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 478, 'MRO', 'Ouguiya', 'Mauritania, Western Sahara');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 470, 'MTP', 'Maltese Pound', 'Malta');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 480, 'MUR', 'Mauritius Rupee', 'British Indian Ocean Territory, Mauritius');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 462, 'MVR', 'Maldive Rupee', 'Maldives');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 454, 'MWK', 'Kwacha', 'Malawi');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 484, 'MXP', 'Mexican Peso', 'Mexico');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 458, 'MYR', 'Malaysian Ringgit', 'Malaysia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 508, 'MZM', 'Metical', 'Mozambique');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 566, 'NGN', 'Naira', 'Nigeria');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 558, 'NIC', 'Cordoba', 'Nicaragua');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 578, 'NOK', 'Norwegian Krone', 'Antarctica, Bouvet Island, Dronning Maud Land, Norway, Svalbard and Jan Mayen Islands');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 524, 'NPR', 'Nepalese Rupee', 'Nepal');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 554, 'NZD', 'New Zealand Dollar', 'Cook Islands, Niue, New Zealand, Pitcairn Island, Tokelau');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 512, 'OMR', 'Rial Omani', 'Oman');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 590, 'PAB', 'Balboa', 'Panama');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 604, 'PES', 'Sol', 'Peru');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 598, 'PGK', 'Kina', 'Papau New Guinea');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 608, 'PHP', 'Philippine Peso', 'Philippines');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 586, 'PKR', 'Pakistan Rupee', 'Pakistan');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 616, 'PLZ', 'Zloty', 'Poland');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 600, 'PYG', 'Guarani', 'Paraguay');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 634, 'QAR', 'Qatari Rial', 'Qatar');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 642, 'ROL', 'Leu', 'Romania');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 646, 'RWF', 'Rwanda Franc', 'Rwanda');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 682, 'SAR', 'Saudi Riyal', 'Neutral Zone (betw. Saudi A. & Iraq), Saudi Arabia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 090, 'SBD', 'Solomon Islands Dollar', 'Solomon Islands');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 690, 'SCR', 'Seychelles Rupee', 'British Indian Ocean Territory, Seychelles');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 736, 'SDP', 'Sudanese Pound', 'Sudan');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 752, 'SEK', 'Swedish Krona', 'Sweden');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 702, 'SGD', 'Singapore Dollar', 'Singapore');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 654, 'SHP', 'St. Helena Pound', 'St. Helena');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 694, 'SLL', 'Leone', 'Sierra Leone');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 706, 'SOS', 'Somali Shilling', 'Somalia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 740, 'SRG', 'Suriname Guilder', 'Suriname');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 678, 'STD', 'Dobra', 'Sao Tome and Principe');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 810, 'SUR', 'Rouble', 'Byelorussion SSR, Ukrainian SSR, Union of Soviet Socialist Republics');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 222, 'SVC', 'El Salvador Colon', 'El Salvador');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 760, 'SYP', 'Syrian Pound', 'Syrian Arab Republic');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 748, 'SZL', 'Lilangeni', 'Swaziland');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 764, 'THB', 'Baht', 'Thailand');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 788, 'TND', 'Tunisian Dinar', 'Tunisia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 776, 'TOP', 'Paanga', 'Tonga');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 626, 'TPE', 'Timor Escudo', 'East Timor');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 792, 'TRL', 'Turkish Lira', 'Turkey');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 780, 'TTD', 'Trinidad&Tobago Dollar', 'Trinidad and Tobago');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 901, 'TWD', 'New Taiwan Dollar', 'Taiwan, Province of China');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 834, 'TZS', 'Tanzanian Shilling', 'Tanzania, United Republic of');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 800, 'UGS', 'Uganda Shilling', 'Uganda');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 840, 'USD', 'US Dollar', 'American Samoa, British Virgin Islands, Canton and Enderbury Islands, Guam, Haiti, Johnston Island, Midway Islands, Pacific Islands (trush territory), Panama, Puerto Rico, Turks and Caicos Islands, United States, U.S. Miscellaneous Pacific Islands, U.S. Virgin Islands, Wake Island');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 858, 'UYP', 'Uruguayan Peso', 'Uruguay');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 704, 'VND', 'Dong', 'Viet Nam');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 862, 'VEB', 'Bolivar', 'Venezuela');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 548, 'VUV', 'Vatu', 'Vanuatu');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 882, 'WST', 'Tala', 'Samoa');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 950, 'XAF', 'CFA Franc BEAC', 'Cameroon, United Republic of, Central African Republic, Chad, Congo, Gabon');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 959, 'XAU', 'Gold', '');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 951, 'XCD', 'East Caribbean Dollar', 'Antiqua, Dominica, Grenada, Montserrat, St. Kitts-Nevis-Anguilla, Saint Lucia, Saint Vincent and the Grenadines');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 952, 'XOF', 'CFA Franc BCEAO', 'Benin, Ivory Coast, Niger, Senegal, Togo, Upper Volta');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 953, 'XPF', 'CFP Franc', 'French polynesia, New Caledonia, Wallis and Futuna Islands');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 720, 'YDD', 'Yemeni Dinar', 'Yemen, Democratic');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 886, 'YER', 'Yemeni Rial', 'Yemen');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 890, 'YUD', 'New Yugoslavian Dinar', 'Yugoslavia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 710, 'ZAR', 'Rand', 'Lesotho, Namibia, South Africa');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 894, 'ZMK', 'Kwacha', 'Zambia');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 180, 'ZRZ', 'Zaire', 'Zaire');
INSERT INTO currency VALUES (NEXTVAL('currency_id_sequence'), 716, 'ZWD', 'Zimbabwe Dollar', 'Zimbabwe');
podoc/currency_sql_table.txt · Last modified: 2007/10/19 15:51 by Luud