-- Insert default denominations for Philippines (PHP)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('PHP', 'PHP', '₱', 0.01, true, true, 1),
('PHP', 'PHP', '₱', 0.05, true, true, 2),
('PHP', 'PHP', '₱', 0.10, true, true, 3),
('PHP', 'PHP', '₱', 0.25, true, true, 4),
('PHP', 'PHP', '₱', 1.00, true, true, 5),
('PHP', 'PHP', '₱', 5.00, true, true, 6),
('PHP', 'PHP', '₱', 10.00, true, true, 7),
('PHP', 'PHP', '₱', 20.00, false, true, 8),
('PHP', 'PHP', '₱', 50.00, false, true, 9),
('PHP', 'PHP', '₱', 100.00, false, true, 10),
('PHP', 'PHP', '₱', 200.00, false, true, 11),
('PHP', 'PHP', '₱', 500.00, false, true, 12),
('PHP', 'PHP', '₱', 1000.00, false, true, 13);

-- Insert default denominations for USD (United States)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('USD', 'USD', '$', 0.01, true, true, 1),
('USD', 'USD', '$', 0.05, true, true, 2),
('USD', 'USD', '$', 0.10, true, true, 3),
('USD', 'USD', '$', 0.25, true, true, 4),
('USD', 'USD', '$', 0.50, true, true, 5),
('USD', 'USD', '$', 1.00, true, true, 6),
('USD', 'USD', '$', 1.00, false, true, 7),
('USD', 'USD', '$', 2.00, false, true, 8),
('USD', 'USD', '$', 5.00, false, true, 9),
('USD', 'USD', '$', 10.00, false, true, 10),
('USD', 'USD', '$', 20.00, false, true, 11),
('USD', 'USD', '$', 50.00, false, true, 12),
('USD', 'USD', '$', 100.00, false, true, 13);

-- Insert default denominations for EUR (European Union)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('EUR', 'EUR', '€', 0.01, true, true, 1),
('EUR', 'EUR', '€', 0.02, true, true, 2),
('EUR', 'EUR', '€', 0.05, true, true, 3),
('EUR', 'EUR', '€', 0.10, true, true, 4),
('EUR', 'EUR', '€', 0.20, true, true, 5),
('EUR', 'EUR', '€', 0.50, true, true, 6),
('EUR', 'EUR', '€', 1.00, true, true, 7),
('EUR', 'EUR', '€', 2.00, true, true, 8),
('EUR', 'EUR', '€', 5.00, false, true, 9),
('EUR', 'EUR', '€', 10.00, false, true, 10),
('EUR', 'EUR', '€', 20.00, false, true, 11),
('EUR', 'EUR', '€', 50.00, false, true, 12),
('EUR', 'EUR', '€', 100.00, false, true, 13),
('EUR', 'EUR', '€', 200.00, false, true, 14),
('EUR', 'EUR', '€', 500.00, false, true, 15);

-- Insert default denominations for GBP (United Kingdom)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('GBP', 'GBP', '£', 0.01, true, true, 1),
('GBP', 'GBP', '£', 0.02, true, true, 2),
('GBP', 'GBP', '£', 0.05, true, true, 3),
('GBP', 'GBP', '£', 0.10, true, true, 4),
('GBP', 'GBP', '£', 0.20, true, true, 5),
('GBP', 'GBP', '£', 0.50, true, true, 6),
('GBP', 'GBP', '£', 1.00, true, true, 7),
('GBP', 'GBP', '£', 2.00, true, true, 8),
('GBP', 'GBP', '£', 5.00, false, true, 9),
('GBP', 'GBP', '£', 10.00, false, true, 10),
('GBP', 'GBP', '£', 20.00, false, true, 11),
('GBP', 'GBP', '£', 50.00, false, true, 12);

-- Insert default denominations for JPY (Japan)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('JPY', 'JPY', '¥', 1.00, true, true, 1),
('JPY', 'JPY', '¥', 5.00, true, true, 2),
('JPY', 'JPY', '¥', 10.00, true, true, 3),
('JPY', 'JPY', '¥', 50.00, true, true, 4),
('JPY', 'JPY', '¥', 100.00, true, true, 5),
('JPY', 'JPY', '¥', 500.00, true, true, 6),
('JPY', 'JPY', '¥', 1000.00, false, true, 7),
('JPY', 'JPY', '¥', 2000.00, false, true, 8),
('JPY', 'JPY', '¥', 5000.00, false, true, 9),
('JPY', 'JPY', '¥', 10000.00, false, true, 10);

-- Insert default denominations for KWD (Kuwait)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('KWD', 'KWD', 'د.ك', 0.001, true, true, 1),
('KWD', 'KWD', 'د.ك', 0.005, true, true, 2),
('KWD', 'KWD', 'د.ك', 0.010, true, true, 3),
('KWD', 'KWD', 'د.ك', 0.020, true, true, 4),
('KWD', 'KWD', 'د.ك', 0.050, true, true, 5),
('KWD', 'KWD', 'د.ك', 0.100, true, true, 6),
('KWD', 'KWD', 'د.ك', 0.250, true, true, 7),
('KWD', 'KWD', 'د.ك', 0.500, true, true, 8),
('KWD', 'KWD', 'د.ك', 1.000, false, true, 9),
('KWD', 'KWD', 'د.ك', 5.000, false, true, 10),
('KWD', 'KWD', 'د.ك', 10.000, false, true, 11),
('KWD', 'KWD', 'د.ك', 20.000, false, true, 12),
('KWD', 'KWD', 'د.ك', 50.000, false, true, 13),
('KWD', 'KWD', 'د.ك', 100.000, false, true, 14);

-- Insert default denominations for SGD (Singapore)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('SGP', 'SGD', 'S$', 0.01, true, true, 1),
('SGP', 'SGD', 'S$', 0.05, true, true, 2),
('SGP', 'SGD', 'S$', 0.10, true, true, 3),
('SGP', 'SGD', 'S$', 0.20, true, true, 4),
('SGP', 'SGD', 'S$', 0.50, true, true, 5),
('SGP', 'SGD', 'S$', 1.00, true, true, 6),
('SGP', 'SGD', 'S$', 2.00, false, true, 7),
('SGP', 'SGD', 'S$', 5.00, false, true, 8),
('SGP', 'SGD', 'S$', 10.00, false, true, 9),
('SGP', 'SGD', 'S$', 50.00, false, true, 10),
('SGP', 'SGD', 'S$', 100.00, false, true, 11),
('SGP', 'SGD', 'S$', 1000.00, false, true, 12);

-- Insert default denominations for MYR (Malaysia)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('MYS', 'MYR', 'RM', 0.01, true, true, 1),
('MYS', 'MYR', 'RM', 0.05, true, true, 2),
('MYS', 'MYR', 'RM', 0.10, true, true, 3),
('MYS', 'MYR', 'RM', 0.20, true, true, 4),
('MYS', 'MYR', 'RM', 0.50, true, true, 5),
('MYS', 'MYR', 'RM', 1.00, true, true, 6),
('MYS', 'MYR', 'RM', 5.00, false, true, 7),
('MYS', 'MYR', 'RM', 10.00, false, true, 8),
('MYS', 'MYR', 'RM', 20.00, false, true, 9),
('MYS', 'MYR', 'RM', 50.00, false, true, 10),
('MYS', 'MYR', 'RM', 100.00, false, true, 11);

-- Insert default denominations for IDR (Indonesia)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('IDN', 'IDR', 'Rp', 50.00, true, true, 1),
('IDN', 'IDR', 'Rp', 100.00, true, true, 2),
('IDN', 'IDR', 'Rp', 200.00, true, true, 3),
('IDN', 'IDR', 'Rp', 500.00, true, true, 4),
('IDN', 'IDR', 'Rp', 1000.00, true, true, 5),
('IDN', 'IDR', 'Rp', 2000.00, false, true, 6),
('IDN', 'IDR', 'Rp', 5000.00, false, true, 7),
('IDN', 'IDR', 'Rp', 10000.00, false, true, 8),
('IDN', 'IDR', 'Rp', 20000.00, false, true, 9),
('IDN', 'IDR', 'Rp', 50000.00, false, true, 10),
('IDN', 'IDR', 'Rp', 100000.00, false, true, 11);

-- Insert default denominations for THB (Thailand)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('THA', 'THB', '฿', 0.25, true, true, 1),
('THA', 'THB', '฿', 0.50, true, true, 2),
('THA', 'THB', '฿', 1.00, true, true, 3),
('THA', 'THB', '฿', 2.00, true, true, 4),
('THA', 'THB', '฿', 5.00, true, true, 5),
('THA', 'THB', '฿', 10.00, true, true, 6),
('THA', 'THB', '฿', 20.00, false, true, 7),
('THA', 'THB', '฿', 50.00, false, true, 8),
('THA', 'THB', '฿', 100.00, false, true, 9),
('THA', 'THB', '฿', 500.00, false, true, 10),
('THA', 'THB', '฿', 1000.00, false, true, 11);

-- Insert default denominations for VND (Vietnam)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('VNM', 'VND', '₫', 200.00, true, true, 1),
('VNM', 'VND', '₫', 500.00, true, true, 2),
('VNM', 'VND', '₫', 1000.00, true, true, 3),
('VNM', 'VND', '₫', 2000.00, true, true, 4),
('VNM', 'VND', '₫', 5000.00, false, true, 5),
('VNM', 'VND', '₫', 10000.00, false, true, 6),
('VNM', 'VND', '₫', 20000.00, false, true, 7),
('VNM', 'VND', '₫', 50000.00, false, true, 8),
('VNM', 'VND', '₫', 100000.00, false, true, 9),
('VNM', 'VND', '₫', 200000.00, false, true, 10),
('VNM', 'VND', '₫', 500000.00, false, true, 11);

-- Insert default denominations for KRW (South Korea)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('KOR', 'KRW', '₩', 10.00, true, true, 1),
('KOR', 'KRW', '₩', 50.00, true, true, 2),
('KOR', 'KRW', '₩', 100.00, true, true, 3),
('KOR', 'KRW', '₩', 500.00, true, true, 4),
('KOR', 'KRW', '₩', 1000.00, false, true, 5),
('KOR', 'KRW', '₩', 5000.00, false, true, 6),
('KOR', 'KRW', '₩', 10000.00, false, true, 7),
('KOR', 'KRW', '₩', 50000.00, false, true, 8);

-- Insert default denominations for CNY (China)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('CHN', 'CNY', '¥', 0.01, true, true, 1),
('CHN', 'CNY', '¥', 0.05, true, true, 2),
('CHN', 'CNY', '¥', 0.10, true, true, 3),
('CHN', 'CNY', '¥', 0.50, true, true, 4),
('CHN', 'CNY', '¥', 1.00, true, true, 5),
('CHN', 'CNY', '¥', 5.00, false, true, 6),
('CHN', 'CNY', '¥', 10.00, false, true, 7),
('CHN', 'CNY', '¥', 20.00, false, true, 8),
('CHN', 'CNY', '¥', 50.00, false, true, 9),
('CHN', 'CNY', '¥', 100.00, false, true, 10);

-- Insert default denominations for INR (India)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('IND', 'INR', '₹', 0.50, true, true, 1),
('IND', 'INR', '₹', 1.00, true, true, 2),
('IND', 'INR', '₹', 2.00, true, true, 3),
('IND', 'INR', '₹', 5.00, true, true, 4),
('IND', 'INR', '₹', 10.00, true, true, 5),
('IND', 'INR', '₹', 20.00, false, true, 6),
('IND', 'INR', '₹', 50.00, false, true, 7),
('IND', 'INR', '₹', 100.00, false, true, 8),
('IND', 'INR', '₹', 200.00, false, true, 9),
('IND', 'INR', '₹', 500.00, false, true, 10),
('IND', 'INR', '₹', 2000.00, false, true, 11);

-- Insert default denominations for AUD (Australia)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('AUS', 'AUD', 'A$', 0.05, true, true, 1),
('AUS', 'AUD', 'A$', 0.10, true, true, 2),
('AUS', 'AUD', 'A$', 0.20, true, true, 3),
('AUS', 'AUD', 'A$', 0.50, true, true, 4),
('AUS', 'AUD', 'A$', 1.00, true, true, 5),
('AUS', 'AUD', 'A$', 2.00, true, true, 6),
('AUS', 'AUD', 'A$', 5.00, false, true, 7),
('AUS', 'AUD', 'A$', 10.00, false, true, 8),
('AUS', 'AUD', 'A$', 20.00, false, true, 9),
('AUS', 'AUD', 'A$', 50.00, false, true, 10),
('AUS', 'AUD', 'A$', 100.00, false, true, 11);

-- Insert default denominations for NZD (New Zealand)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('NZL', 'NZD', 'NZ$', 0.10, true, true, 1),
('NZL', 'NZD', 'NZ$', 0.20, true, true, 2),
('NZL', 'NZD', 'NZ$', 0.50, true, true, 3),
('NZL', 'NZD', 'NZ$', 1.00, true, true, 4),
('NZL', 'NZD', 'NZ$', 2.00, true, true, 5),
('NZL', 'NZD', 'NZ$', 5.00, false, true, 6),
('NZL', 'NZD', 'NZ$', 10.00, false, true, 7),
('NZL', 'NZD', 'NZ$', 20.00, false, true, 8),
('NZL', 'NZD', 'NZ$', 50.00, false, true, 9),
('NZL', 'NZD', 'NZ$', 100.00, false, true, 10);

-- Insert default denominations for CAD (Canada)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('CAN', 'CAD', 'C$', 0.01, true, true, 1),
('CAN', 'CAD', 'C$', 0.05, true, true, 2),
('CAN', 'CAD', 'C$', 0.10, true, true, 3),
('CAN', 'CAD', 'C$', 0.25, true, true, 4),
('CAN', 'CAD', 'C$', 0.50, true, true, 5),
('CAN', 'CAD', 'C$', 1.00, true, true, 6),
('CAN', 'CAD', 'C$', 2.00, true, true, 7),
('CAN', 'CAD', 'C$', 5.00, false, true, 8),
('CAN', 'CAD', 'C$', 10.00, false, true, 9),
('CAN', 'CAD', 'C$', 20.00, false, true, 10),
('CAN', 'CAD', 'C$', 50.00, false, true, 11),
('CAN', 'CAD', 'C$', 100.00, false, true, 12);

-- Insert default denominations for MXN (Mexico)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('MEX', 'MXN', '$', 0.05, true, true, 1),
('MEX', 'MXN', '$', 0.10, true, true, 2),
('MEX', 'MXN', '$', 0.20, true, true, 3),
('MEX', 'MXN', '$', 0.50, true, true, 4),
('MEX', 'MXN', '$', 1.00, true, true, 5),
('MEX', 'MXN', '$', 2.00, true, true, 6),
('MEX', 'MXN', '$', 5.00, true, true, 7),
('MEX', 'MXN', '$', 10.00, true, true, 8),
('MEX', 'MXN', '$', 20.00, false, true, 9),
('MEX', 'MXN', '$', 50.00, false, true, 10),
('MEX', 'MXN', '$', 100.00, false, true, 11),
('MEX', 'MXN', '$', 200.00, false, true, 12),
('MEX', 'MXN', '$', 500.00, false, true, 13),
('MEX', 'MXN', '$', 1000.00, false, true, 14);

-- Insert default denominations for CHF (Switzerland)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('CHE', 'CHF', 'CHF', 0.05, true, true, 1),
('CHE', 'CHF', 'CHF', 0.10, true, true, 2),
('CHE', 'CHF', 'CHF', 0.20, true, true, 3),
('CHE', 'CHF', 'CHF', 0.50, true, true, 4),
('CHE', 'CHF', 'CHF', 1.00, true, true, 5),
('CHE', 'CHF', 'CHF', 2.00, true, true, 6),
('CHE', 'CHF', 'CHF', 5.00, false, true, 7),
('CHE', 'CHF', 'CHF', 10.00, false, true, 8),
('CHE', 'CHF', 'CHF', 20.00, false, true, 9),
('CHE', 'CHF', 'CHF', 50.00, false, true, 10),
('CHE', 'CHF', 'CHF', 100.00, false, true, 11),
('CHE', 'CHF', 'CHF', 200.00, false, true, 12),
('CHE', 'CHF', 'CHF', 1000.00, false, true, 13);

-- Insert default denominations for SEK (Sweden)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('SWE', 'SEK', 'kr', 1.00, true, true, 1),
('SWE', 'SEK', 'kr', 2.00, true, true, 2),
('SWE', 'SEK', 'kr', 5.00, true, true, 3),
('SWE', 'SEK', 'kr', 10.00, true, true, 4),
('SWE', 'SEK', 'kr', 20.00, false, true, 5),
('SWE', 'SEK', 'kr', 50.00, false, true, 6),
('SWE', 'SEK', 'kr', 100.00, false, true, 7),
('SWE', 'SEK', 'kr', 200.00, false, true, 8),
('SWE', 'SEK', 'kr', 500.00, false, true, 9),
('SWE', 'SEK', 'kr', 1000.00, false, true, 10);

-- Insert default denominations for NOK (Norway)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('NOR', 'NOK', 'kr', 1.00, true, true, 1),
('NOR', 'NOK', 'kr', 5.00, true, true, 2),
('NOR', 'NOK', 'kr', 10.00, true, true, 3),
('NOR', 'NOK', 'kr', 20.00, true, true, 4),
('NOR', 'NOK', 'kr', 50.00, false, true, 5),
('NOR', 'NOK', 'kr', 100.00, false, true, 6),
('NOR', 'NOK', 'kr', 200.00, false, true, 7),
('NOR', 'NOK', 'kr', 500.00, false, true, 8),
('NOR', 'NOK', 'kr', 1000.00, false, true, 9);

-- Insert default denominations for DKK (Denmark)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('DNK', 'DKK', 'kr', 0.50, true, true, 1),
('DNK', 'DKK', 'kr', 1.00, true, true, 2),
('DNK', 'DKK', 'kr', 2.00, true, true, 3),
('DNK', 'DKK', 'kr', 5.00, true, true, 4),
('DNK', 'DKK', 'kr', 10.00, true, true, 5),
('DNK', 'DKK', 'kr', 20.00, false, true, 6),
('DNK', 'DKK', 'kr', 50.00, false, true, 7),
('DNK', 'DKK', 'kr', 100.00, false, true, 8),
('DNK', 'DKK', 'kr', 200.00, false, true, 9),
('DNK', 'DKK', 'kr', 500.00, false, true, 10),
('DNK', 'DKK', 'kr', 1000.00, false, true, 11);

-- Insert default denominations for AED (UAE)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('ARE', 'AED', 'د.إ', 0.25, true, true, 1),
('ARE', 'AED', 'د.إ', 0.50, true, true, 2),
('ARE', 'AED', 'د.إ', 1.00, true, true, 3),
('ARE', 'AED', 'د.إ', 5.00, false, true, 4),
('ARE', 'AED', 'د.إ', 10.00, false, true, 5),
('ARE', 'AED', 'د.إ', 20.00, false, true, 6),
('ARE', 'AED', 'د.إ', 50.00, false, true, 7),
('ARE', 'AED', 'د.إ', 100.00, false, true, 8),
('ARE', 'AED', 'د.إ', 200.00, false, true, 9),
('ARE', 'AED', 'د.إ', 500.00, false, true, 10),
('ARE', 'AED', 'د.إ', 1000.00, false, true, 11);

-- Insert default denominations for SAR (Saudi Arabia)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('SAU', 'SAR', 'ر.س', 0.25, true, true, 1),
('SAU', 'SAR', 'ر.س', 0.50, true, true, 2),
('SAU', 'SAR', 'ر.س', 1.00, true, true, 3),
('SAU', 'SAR', 'ر.س', 5.00, false, true, 4),
('SAU', 'SAR', 'ر.س', 10.00, false, true, 5),
('SAU', 'SAR', 'ر.س', 20.00, false, true, 6),
('SAU', 'SAR', 'ر.س', 50.00, false, true, 7),
('SAU', 'SAR', 'ر.س', 100.00, false, true, 8),
('SAU', 'SAR', 'ر.س', 200.00, false, true, 9),
('SAU', 'SAR', 'ر.س', 500.00, false, true, 10);

-- Insert default denominations for QAR (Qatar)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('QAT', 'QAR', 'ر.ق', 0.25, true, true, 1),
('QAT', 'QAR', 'ر.ق', 0.50, true, true, 2),
('QAT', 'QAR', 'ر.ق', 1.00, true, true, 3),
('QAT', 'QAR', 'ر.ق', 5.00, false, true, 4),
('QAT', 'QAR', 'ر.ق', 10.00, false, true, 5),
('QAT', 'QAR', 'ر.ق', 20.00, false, true, 6),
('QAT', 'QAR', 'ر.ق', 50.00, false, true, 7),
('QAT', 'QAR', 'ر.ق', 100.00, false, true, 8),
('QAT', 'QAR', 'ر.ق', 200.00, false, true, 9),
('QAT', 'QAR', 'ر.ق', 500.00, false, true, 10);

-- Insert default denominations for BHD (Bahrain)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('BHR', 'BHD', '.د.ب', 0.005, true, true, 1),
('BHR', 'BHD', '.د.ب', 0.010, true, true, 2),
('BHR', 'BHD', '.د.ب', 0.025, true, true, 3),
('BHR', 'BHD', '.د.ب', 0.050, true, true, 4),
('BHR', 'BHD', '.د.ب', 0.100, true, true, 5),
('BHR', 'BHD', '.د.ب', 0.500, true, true, 6),
('BHR', 'BHD', '.د.ب', 1.000, false, true, 7),
('BHR', 'BHD', '.د.ب', 5.000, false, true, 8),
('BHR', 'BHD', '.د.ب', 10.000, false, true, 9),
('BHR', 'BHD', '.د.ب', 20.000, false, true, 10);

-- Insert default denominations for OMR (Oman)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('OMN', 'OMR', 'ر.ع.', 0.005, true, true, 1),
('OMN', 'OMR', 'ر.ع.', 0.010, true, true, 2),
('OMN', 'OMR', 'ر.ع.', 0.025, true, true, 3),
('OMN', 'OMR', 'ر.ع.', 0.050, true, true, 4),
('OMN', 'OMR', 'ر.ع.', 0.100, true, true, 5),
('OMN', 'OMR', 'ر.ع.', 0.250, true, true, 6),
('OMN', 'OMR', 'ر.ع.', 0.500, true, true, 7),
('OMN', 'OMR', 'ر.ع.', 1.000, false, true, 8),
('OMN', 'OMR', 'ر.ع.', 5.000, false, true, 9),
('OMN', 'OMR', 'ر.ع.', 10.000, false, true, 10),
('OMN', 'OMR', 'ر.ع.', 20.000, false, true, 11),
('OMN', 'OMR', 'ر.ع.', 50.000, false, true, 12);

-- Insert default denominations for ILS (Israel)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('ISR', 'ILS', '₪', 0.10, true, true, 1),
('ISR', 'ILS', '₪', 0.50, true, true, 2),
('ISR', 'ILS', '₪', 1.00, true, true, 3),
('ISR', 'ILS', '₪', 2.00, true, true, 4),
('ISR', 'ILS', '₪', 5.00, true, true, 5),
('ISR', 'ILS', '₪', 10.00, true, true, 6),
('ISR', 'ILS', '₪', 20.00, false, true, 7),
('ISR', 'ILS', '₪', 50.00, false, true, 8),
('ISR', 'ILS', '₪', 100.00, false, true, 9),
('ISR', 'ILS', '₪', 200.00, false, true, 10);

-- Insert default denominations for TRY (Turkey)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('TUR', 'TRY', '₺', 0.01, true, true, 1),
('TUR', 'TRY', '₺', 0.05, true, true, 2),
('TUR', 'TRY', '₺', 0.10, true, true, 3),
('TUR', 'TRY', '₺', 0.25, true, true, 4),
('TUR', 'TRY', '₺', 0.50, true, true, 5),
('TUR', 'TRY', '₺', 1.00, true, true, 6),
('TUR', 'TRY', '₺', 5.00, false, true, 7),
('TUR', 'TRY', '₺', 10.00, false, true, 8),
('TUR', 'TRY', '₺', 20.00, false, true, 9),
('TUR', 'TRY', '₺', 50.00, false, true, 10),
('TUR', 'TRY', '₺', 100.00, false, true, 11),
('TUR', 'TRY', '₺', 200.00, false, true, 12);

-- Insert default denominations for ZAR (South Africa)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('ZAF', 'ZAR', 'R', 0.10, true, true, 1),
('ZAF', 'ZAR', 'R', 0.20, true, true, 2),
('ZAF', 'ZAR', 'R', 0.50, true, true, 3),
('ZAF', 'ZAR', 'R', 1.00, true, true, 4),
('ZAF', 'ZAR', 'R', 2.00, true, true, 5),
('ZAF', 'ZAR', 'R', 5.00, true, true, 6),
('ZAF', 'ZAR', 'R', 10.00, false, true, 7),
('ZAF', 'ZAR', 'R', 20.00, false, true, 8),
('ZAF', 'ZAR', 'R', 50.00, false, true, 9),
('ZAF', 'ZAR', 'R', 100.00, false, true, 10),
('ZAF', 'ZAR', 'R', 200.00, false, true, 11);

-- Insert default denominations for EGP (Egypt)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('EGY', 'EGP', '£', 0.25, true, true, 1),
('EGY', 'EGP', '£', 0.50, true, true, 2),
('EGY', 'EGP', '£', 1.00, true, true, 3),
('EGY', 'EGP', '£', 5.00, false, true, 4),
('EGY', 'EGP', '£', 10.00, false, true, 5),
('EGY', 'EGP', '£', 20.00, false, true, 6),
('EGY', 'EGP', '£', 50.00, false, true, 7),
('EGY', 'EGP', '£', 100.00, false, true, 8),
('EGY', 'EGP', '£', 200.00, false, true, 9);

-- Insert default denominations for NGN (Nigeria)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('NGA', 'NGN', '₦', 50.00, true, true, 1),
('NGA', 'NGN', '₦', 100.00, true, true, 2),
('NGA', 'NGN', '₦', 200.00, true, true, 3),
('NGA', 'NGN', '₦', 500.00, false, true, 4),
('NGA', 'NGN', '₦', 1000.00, false, true, 5),
('NGA', 'NGN', '₦', 2000.00, false, true, 6),
('NGA', 'NGN', '₦', 5000.00, false, true, 7),
('NGA', 'NGN', '₦', 10000.00, false, true, 8),
('NGA', 'NGN', '₦', 20000.00, false, true, 9),
('NGA', 'NGN', '₦', 50000.00, false, true, 10);

-- Insert default denominations for BRL (Brazil)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('BRA', 'BRL', 'R$', 0.05, true, true, 1),
('BRA', 'BRL', 'R$', 0.10, true, true, 2),
('BRA', 'BRL', 'R$', 0.25, true, true, 3),
('BRA', 'BRL', 'R$', 0.50, true, true, 4),
('BRA', 'BRL', 'R$', 1.00, true, true, 5),
('BRA', 'BRL', 'R$', 2.00, false, true, 6),
('BRA', 'BRL', 'R$', 5.00, false, true, 7),
('BRA', 'BRL', 'R$', 10.00, false, true, 8),
('BRA', 'BRL', 'R$', 20.00, false, true, 9),
('BRA', 'BRL', 'R$', 50.00, false, true, 10),
('BRA', 'BRL', 'R$', 100.00, false, true, 11),
('BRA', 'BRL', 'R$', 200.00, false, true, 12);

-- Insert default denominations for ARS (Argentina)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('ARG', 'ARS', '$', 1.00, true, true, 1),
('ARG', 'ARS', '$', 2.00, true, true, 2),
('ARG', 'ARS', '$', 5.00, true, true, 3),
('ARG', 'ARS', '$', 10.00, true, true, 4),
('ARG', 'ARS', '$', 20.00, false, true, 5),
('ARG', 'ARS', '$', 50.00, false, true, 6),
('ARG', 'ARS', '$', 100.00, false, true, 7),
('ARG', 'ARS', '$', 200.00, false, true, 8),
('ARG', 'ARS', '$', 500.00, false, true, 9),
('ARG', 'ARS', '$', 1000.00, false, true, 10),
('ARG', 'ARS', '$', 2000.00, false, true, 11);

-- Insert default denominations for CLP (Chile)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('CHL', 'CLP', '$', 1.00, true, true, 1),
('CHL', 'CLP', '$', 5.00, true, true, 2),
('CHL', 'CLP', '$', 10.00, true, true, 3),
('CHL', 'CLP', '$', 50.00, true, true, 4),
('CHL', 'CLP', '$', 100.00, true, true, 5),
('CHL', 'CLP', '$', 500.00, false, true, 6),
('CHL', 'CLP', '$', 1000.00, false, true, 7),
('CHL', 'CLP', '$', 2000.00, false, true, 8),
('CHL', 'CLP', '$', 5000.00, false, true, 9),
('CHL', 'CLP', '$', 10000.00, false, true, 10),
('CHL', 'CLP', '$', 20000.00, false, true, 11);

-- Insert default denominations for COP (Colombia)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('COL', 'COP', '$', 50.00, true, true, 1),
('COL', 'COP', '$', 100.00, true, true, 2),
('COL', 'COP', '$', 200.00, true, true, 3),
('COL', 'COP', '$', 500.00, true, true, 4),
('COL', 'COP', '$', 1000.00, false, true, 5),
('COL', 'COP', '$', 2000.00, false, true, 6),
('COL', 'COP', '$', 5000.00, false, true, 7),
('COL', 'COP', '$', 10000.00, false, true, 8),
('COL', 'COP', '$', 20000.00, false, true, 9),
('COL', 'COP', '$', 50000.00, false, true, 10),
('COL', 'COP', '$', 100000.00, false, true, 11);

-- Insert default denominations for PEN (Peru)
INSERT IGNORE INTO `default_country_denominations` 
(country_code, currency_code, currency_symbol, denomination_value, is_coin, is_active, display_order) VALUES
('PER', 'PEN', 'S/', 0.10, true, true, 1),
('PER', 'PEN', 'S/', 0.20, true, true, 2),
('PER', 'PEN', 'S/', 0.50, true, true, 3),
('PER', 'PEN', 'S/', 1.00, true, true, 4),
('PER', 'PEN', 'S/', 2.00, true, true, 5),
('PER', 'PEN', 'S/', 5.00, true, true, 6),
('PER', 'PEN', 'S/', 10.00, false, true, 7),
('PER', 'PEN', 'S/', 20.00, false, true, 8),
('PER', 'PEN', 'S/', 50.00, false, true, 9),
('PER', 'PEN', 'S/', 100.00, false, true, 10),
('PER', 'PEN', 'S/', 200.00, false, true, 11); 