-- Update remaining categories (B, C, D) with same descriptions as Cat A
-- Cat B rules (IDs 32-57)
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Suspicious International transactions' AND category = 'Cat A' LIMIT 1) WHERE name = 'Suspicious International transactions' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Multiple Int\'l card, low value' AND category = 'Cat A' LIMIT 1) WHERE name = 'Multiple Int\'l card, low value' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Abnormal Time transaction' AND category = 'Cat A' LIMIT 1) WHERE name = 'Abnormal Time transaction' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Split transaction' AND category = 'Cat A' LIMIT 1) WHERE name = 'Split transaction' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Duplicate transaction' AND category = 'Cat A' LIMIT 1) WHERE name = 'Duplicate transaction' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'High Velocity transaction' AND category = 'Cat A' LIMIT 1) WHERE name = 'High Velocity transaction' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Above-average ticket size' AND category = 'Cat A' LIMIT 1) WHERE name = 'Above-average ticket size' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Dormant Merchant' AND category = 'Cat A' LIMIT 1) WHERE name = 'Dormant Merchant' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'High Value Transaction' AND category = 'Cat A' LIMIT 1) WHERE name = 'High Value Transaction' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'High Frequency Chargeback Merchant' AND category = 'Cat A' LIMIT 1) WHERE name = 'High Frequency Chargeback Merchant' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Excessive Refunds/Reversals' AND category = 'Cat A' LIMIT 1) WHERE name = 'Excessive Refunds/Reversals' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Out-of-Profile Geographic' AND category = 'Cat A' LIMIT 1) WHERE name = 'Out-of-Profile Geographic' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Machines of High Value Fallback Transactions' AND category = 'Cat A' LIMIT 1) WHERE name = 'Machines of High Value Fallback Transactions' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'Decline Transaction Monitoring' AND category = 'Cat A' LIMIT 1) WHERE name = 'Decline Transaction Monitoring' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'New Onboarded Merchant High Decline' AND category = 'Cat A' LIMIT 1) WHERE name = 'New Onboarded Merchant High Decline' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - Local Transaction Higher than 500K' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - Local Transaction Higher than 500K' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - Regional Transaction Higher than 1500K' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - Regional Transaction Higher than 1500K' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - Local Transaction Higher than 400K' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - Local Transaction Higher than 400K' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - International Transaction Higher than 100K' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - International Transaction Higher than 100K' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - International Transaction Higher than 25K' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - International Transaction Higher than 25K' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MV - 10 Cards Same BIN' AND category = 'Cat A' LIMIT 1) WHERE name = 'MV - 10 Cards Same BIN' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MH - 20 Cards Same BIN' AND category = 'Cat A' LIMIT 1) WHERE name = 'MH - 20 Cards Same BIN' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - Daily Amount Limit Per Card' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - Daily Amount Limit Per Card' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'High Value Transaction on New Merchant (First 90 Days)' AND category = 'Cat A' LIMIT 1) WHERE name = 'High Value Transaction on New Merchant (First 90 Days)' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'High Value Transaction on New Merchant' AND category = 'Cat A' LIMIT 1) WHERE name = 'High Value Transaction on New Merchant' AND category != 'Cat A';
UPDATE risk_rules SET description = (SELECT description FROM risk_rules WHERE name = 'MI - Suspicious International Transaction (High-Risk Countries)' AND category = 'Cat A' LIMIT 1) WHERE name = 'MI - Suspicious International Transaction (High-Risk Countries)' AND category != 'Cat A';
