-- ============================================================
--  NexSMS — Seed Data (MySQL / MariaDB)
--  Run AFTER schema.sql
--  Default admin: admin@bulksms.com / Admin@123456
-- ============================================================

-- Default settings
INSERT INTO `settings` (`key`, `value`) VALUES
  ('base_sms_cost',   '0.0100'),
  ('app_name',        'NexSMS'),
  ('max_sms_per_job', '1000')
ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);

-- Default admin user
-- Password: Admin@123456 (bcrypt cost=12)
INSERT INTO `users`
  (`id`, `name`, `email`, `password_hash`, `role`, `status`,
   `sms_balance`, `wallet_balance`, `sms_buying_price`, `sms_selling_price`,
   `created_at`, `updated_at`)
VALUES (
  '00000000-0000-4000-8000-000000000001',
  'Admin',
  'admin@bulksms.com',
  '$2y$12$JxhrDwZktcE4QoLVKXarveCM3XKPPoDDVtKaaliGZvlUL1CpwlLSy',
  'admin',
  'active',
  999999,
  999999,
  0.0100,
  0.0500,
  NOW(),
  NOW()
)
ON DUPLICATE KEY UPDATE `updated_at` = NOW();