INSERT INTO `lc_geo_zones` (`name`, `description`, `date_updated`, `date_created`) VALUES
('CA Tax Zone', 'Tax zone for Canada', NOW(), NOW());
-- -----
SET @CA_VAT_ZONE = LAST_INSERT_ID();
-- -----
INSERT INTO `lc_zones_to_geo_zones` (`geo_zone_id`, `country_code`, `zone_code`, `date_updated`, `date_created`) VALUES
(@CA_VAT_ZONE, 'CA', '', NOW(), NOW());
-- -----
INSERT INTO `lc_tax_classes` (`name`, `description`, `date_updated`, `date_created`) VALUES
('Standard', '', 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, @CA_VAT_ZONE, 'percent', 'Tax 13%', '', 13, 1, 1, 1, 1, NOW(), NOW());
-- -----
UPDATE `lc_settings`
SET `value` = 'US-Letter'
WHERE `key` = 'default_print_paper_size'
LIMIT 1;
