
UPDATE `%%XC%%_countries` SET `active_currency` = 1 WHERE code IN (
  'US', 'BM', 'VG', 'TL', 'ZW', 'MH', 'PW', 'PA', 'PR', 'SV', 'TC', 'FM', 'EC'
  );
UPDATE `%%XC%%_countries` SET `active_currency` = 2 WHERE code IN (
  'AD', 'AT', 'BE', 'CH', 'CY', 'DE', 'DK', 'ED', 'EE', 'ES', 'FI', 'FR', 'GR', 'HU', 'IE', 'IT', 'LV', 'LT', 'LU', 'MC', 'MF', 'MT', 'NL', 'NO', 'PL', 'PT', 'SE', 'SI', 'SK', 'SM', 'VA'
);
UPDATE `%%XC%%_countries` SET `active_currency` = 3 WHERE code = 'CA';
UPDATE `%%XC%%_countries` SET `active_currency` = 4 WHERE code = 'AU';
UPDATE `%%XC%%_countries` SET `active_currency` = 4 WHERE code = 'NZ';
UPDATE `%%XC%%_countries` SET `active_currency` = 5 WHERE code = 'GB';

-- Order messages
INSERT INTO `%%XC%%_conversations` (`id`, `order_id`) VALUES (1, 1);
INSERT INTO `%%XC%%_conversations` (`id`, `order_id`) VALUES (2, 2);
INSERT INTO `%%XC%%_conversations` (`id`, `order_id`) VALUES (3, 3);
INSERT INTO `%%XC%%_conversations` (`id`, `order_id`) VALUES (4, 5);

INSERT INTO `%%XC%%_conversation_members` (`conversation_id`, `profile_id`) VALUES (1,7);
INSERT INTO `%%XC%%_conversation_members` (`conversation_id`, `profile_id`) VALUES (4,7);

INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1394005550, 1, 1, 'regular', 'Hi! Is my order will be delivered in 20 days?');
INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1394015681, 1, 7, 'regular', 'The order has been shipped and you should receive it in 10-15 days');
INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1394035714, 1, 1, 'regular', 'Thanks!');

INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1396005698, 2, 1, 'regular', 'Thanks you!');

INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1407023365, 3, 1, 'regular', 'Hi! I received it! My son is very happy! Thank you!!!');

INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1452604402, 4, 1, 'regular', 'Hi! Do not send order, I will pick up it tomorrow');
INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1452607521, 4, 7, 'regular', 'Hello! Ok, your order awaiting you. Thanks');
INSERT INTO `%%XC%%_vendor_convo_messages` (`date`, `conversation_id`, `profile_id`, `type`, `body`) VALUES (1452624592, 4, 1, 'regular', 'Thank you!');
