INSERT INTO `lc_currencies` (`status`, `code`, `number`, `name`, `value`, `decimals`, `prefix`, `suffix`, `priority`, `date_updated`, `date_created`) VALUES
(1, 'GBP', '826', 'British Pound', 1.00, 2, '£', '', 0, NOW(), NOW());
-- -----
ALTER TABLE `lc_products_prices` ADD `GBP` DECIMAL(11,4) NOT NULL;
-- -----
ALTER TABLE `lc_products_campaigns` ADD `GBP` DECIMAL(11,4) NOT NULL;
-- -----
ALTER TABLE `lc_products_options_values` ADD `GBP` DECIMAL(11,4) NOT NULL;
-- -----
UPDATE `lc_settings` SET `value` = 'GBP' WHERE `key` in ('store_currency_code', 'default_currency_code');
-- -----
UPDATE `lc_currencies` SET `value` = 0.7475 WHERE `code` = 'USD' LIMIT 1;
-- -----
UPDATE `lc_currencies` SET `value` = 0.8768 WHERE `code` = 'EUR' LIMIT 1;
-- -----
INSERT INTO `lc_geo_zones` (`name`, `description`, `date_updated`, `date_created`) VALUES
('GB VAT Zone', '', NOW(), NOW());
-- -----
SET @GB_VAT_ZONE = LAST_INSERT_ID();
-- -----
INSERT INTO `lc_zones_to_geo_zones` (`geo_zone_id`, `country_code`, `zone_code`, `date_updated`, `date_created`) VALUES
(@GB_VAT_ZONE, 'GB', '', NOW(), NOW());
-- -----
INSERT INTO `lc_tax_classes` (`name`, `description`, `date_updated`, `date_created`) VALUES
('Standard', '', NOW(), NOW()),
('Reduced', '', NOW(), NOW());
-- -----
INSERT INTO `lc_tax_rates` (`tax_class_id`, `geo_zone_id`, `type`, `name`, `description`, `rate`, `rule_companies_with_tax_id`, `rule_companies_without_tax_id`, `rule_individuals_with_tax_id`, `rule_individuals_without_tax_id`, `date_updated`, `date_created`) VALUES
(1, @GB_VAT_ZONE, 'percent', 'GB VAT 20%', '', 20.0000, 1, 1, 1, 1, NOW(), NOW()),
(2, @GB_VAT_ZONE, 'percent', 'GB VAT 5%', '', 5.0000, 1, 1, 1, 1, NOW(), NOW());
