-- Insert merchant for timeout simulation in static QR: gourmet@merstatic
-- Matching the actual merchants table structure
INSERT INTO `merchants` (
  `mid`, `sid`, `tid`, `sub_code`, 
  `merchant_type`, `merchant_genre`, `onboarding_type`, `inst_code`,
  `brand_name`, `legal_name`, `franchise_name`, `ownership_type`,
  `country_code`, `network_inst_id`, `inserted_at`, `updated_at`, 
  `partner_id`, `merchant_code`, `merchant_vpa`, `business_type`,
  `business_category`, `static_qr_code`, `qr_enabled`, `dynamic_qr_enabled`,
  `max_transaction_limit`, `daily_transaction_limit`, `settlement_frequency`,
  `settlement_account_intl`, `contact_person`, `contact_email`, `contact_phone`,
  `address`, `city`, `state`, `pincode`, `gstin`, `pan`,
  `intl_status`, `onboarded_at`, `last_transaction_at`,
  `corridor`, `local_currency`, `fx_markup_rate`,
  `settlement_account_number`, `settlement_account_ifsc`, `settlement_account_type`,
  `settlement_bank_country`, `regulatory_license`, `compliance_status`,
  `risk_category`, `status`, `partner_managed`, `stan`
) VALUES (
  'S009STATIC', 'S009STATIC', 'T009STATIC', NULL,
  'HIGH', 'WHOLESALE', 'AGGREGATOR', NULL,
  'Abu Dhabi Gourmet Static', 'Abu Dhabi Gourmet Ltd (Static QR)', NULL, 'PRIVATE',
  'AE', NULL, NOW(), NOW(),
  0x3DFE3DFA1647446F927BF15FF606179D, 'ACC_IP_09_STATIC', 'gourmet@merstatic', 'SERVICES',
  'CATERING', NULL, 1, 0,
  30000.00, 300000.00, 'T+2',
  NULL, NULL, 'payments@abudhabigourmet.ae', '+971-2-987-6543',
  '789 Corniche Road', 'Abu Dhabi', 'Abu Dhabi', '222222', NULL, NULL,
  'ACTIVE', NOW(), NULL,
  'UAE', 'AED', NULL,
  'AE987654321', 'AEBK0098765', 'CURRENT',
  NULL, NULL, 'PENDING',
  'HIGH', 'ACTIVE', 1, NULL
);

