ALTER TABLE `currencies` ADD `ISO_2` VARCHAR(2) NOT NULL DEFAULT '' AFTER `id`;

--
-- Dumping data for table `currencies`
--

INSERT INTO `currencies` (`id`, `ISO_2`, `name`, `short`, `rate`) VALUES
(1, 'EU', 'Euro', '&euro;', 1.0000000000),
(2, 'BG', 'Lev (New) (BG)', 'BGN', 0.0000000000),
(3, 'CZ', 'Czech Koruna (CZ)', 'CZK', 0.0000000000),
(4, 'DK', 'Danish Krone (DK)', 'DKK', 0.0000000000),
(5, 'HU', 'Forint (HU)', 'HUF', 0.0000000000),
(6, 'PL', 'Zloty (PL)', 'PLN', 0.0000000000),
(7, 'RO', 'New Romanian Leu (RO)', 'RON', 0.0000000000),
(8, 'SE', 'Swedish Krona (SE)', 'SEK', 0.0000000000),
(9, 'GB', 'Pound Sterling (GB)', 'GBP', 0.0000000000),
(10, 'HR', 'Kuna (HR)', 'HRK', 0.0000000000),
(11, 'NO', 'Norwegian Krone (NO)', 'NOK', 0.0000000000),
(12, 'RU', 'New Rouble (RU)', 'RUB', 0.0000000000),
(13, 'CH', 'Swiss Franc (CH)', 'CHF', 0.0000000000),
(14, 'TR', 'Turkish Lira (new) (TR)', 'TRY', 0.0000000000),
(15, 'AL', 'Lek (AL)', 'ALL', 0.0000000000),
(16, 'AM', 'Dram (AM)', 'AMD', 0.0000000000),
(17, 'AZ', 'Azerbaijani Manat (AZ)', 'AZN', 0.0000000000),
(18, 'BY', 'Belarussian Rouble (BY)', 'BYR', 0.0000000000),
(19, 'BA', 'Bosnian Convertible Mark', 'BAM', 0.0000000000),
(20, 'GE', 'Lari (GE)', 'GEL', 0.0000000000),
(21, 'GI', 'Gibraltar pound (GI)', 'GIP', 0.0000000000),
(22, 'IS', 'Icelandic Króna (IS)', 'ISK', 0.0000000000),
(23, 'MK', 'Denar (MK)', 'MKD', 0.0000000000),
(24, 'MD', 'Moldovan Leu (MD)', 'MDL', 0.0000000000),
(25, 'RS', 'Serbian Dinar (RS)', 'RSD', 0.0000000000),
(26, 'UA', 'Hryvnia (UA)', 'UAH', 0.0000000000),
(27, 'US', 'US Dolar', '$', 0.0000000000);
