Restore default currencies in BO

[Prestawise]

Hi everyone

Ive found out that if i delete the default currencies and add my own it [Moderated by Patric] up my sales stats.. How can i restore to prestashop's default currencies when i first installed the shop?

[Prestawise]

Oh and it removes my invoices too in my orders... Im going crazy argh!

[rocky]

Execute the following SQL query on your database using phpMyAdmin to reset your currencies to the default ones:

TRUNCATE TABLE `ps_currency`;
TRUNCATE TABLE `ps_module_currency`;
INSERT INTO `ps_currency` (name, iso_code, sign, blank, conversion_rate, format, deleted) VALUES
('Euro', 'EUR', '€', 1, 1, 2, 0), ('Dollar', 'USD', '$', 0, 1.47, 1, 0), ('Pound', 'GBP', '£', 0, 0.8, 1, 0);
INSERT INTO `ps_module_currency` (`id_module`, `id_currency`) VALUES (3, 1),(3, 2),(3, 3),(4, -2),(6, 1),(6, 2),(6, 3);

Change ps_ to your database prefix.

[Ed_03]

Thanks Rocky for that query you saved me