-- seed:up

INSERT IGNORE INTO currencies (
  code, name, symbol, symbol_position, decimal_places, rounding_mode, is_settlement, is_active
) VALUES ('BDT', 'বাংলাদেশি টাকা', '৳', 'before', 2, 'half_up', 1, 1);

INSERT IGNORE INTO wallet_accounts (
  public_id, owner_type, system_key, account_type, currency_id, status
)
SELECT '01J00000000000000000000201', 'system', 'task_rewards', 'reward_pool', id, 'active'
FROM currencies WHERE code = 'BDT';

INSERT IGNORE INTO wallet_accounts (
  public_id, owner_type, system_key, account_type, currency_id, status
)
SELECT '01J00000000000000000000202', 'system', 'referral_rewards', 'referral_pool', id, 'active'
FROM currencies WHERE code = 'BDT';

INSERT IGNORE INTO wallet_accounts (
  public_id, owner_type, system_key, account_type, currency_id, status
)
SELECT '01J00000000000000000000203', 'system', 'mystery_rewards', 'mystery_pool', id, 'active'
FROM currencies WHERE code = 'BDT';

INSERT IGNORE INTO wallet_accounts (
  public_id, owner_type, system_key, account_type, currency_id, status
)
SELECT '01J00000000000000000000204', 'system', 'payout_clearing', 'payout', id, 'active'
FROM currencies WHERE code = 'BDT';

INSERT IGNORE INTO wallet_accounts (
  public_id, owner_type, system_key, account_type, currency_id, status
)
SELECT '01J00000000000000000000205', 'system', 'manual_adjustments', 'adjustment', id, 'active'
FROM currencies WHERE code = 'BDT';