-- ============================================================
-- Seed two default admin accounts for BDOZ
-- ============================================================
-- DEFAULT CREDENTIALS (change immediately after first login!)
--
-- 1) Username : admin
--    Password : Admin@12345
--    Role     : admin
--
-- 2) Username : superadmin
--    Password : Super@12345
--    Role     : superadmin
-- ============================================================

INSERT INTO `users` (`username`, `email`, `password_hash`, `role`, `is_active`, `is_approved`, `api_key`, `created_at`)
VALUES
(
    'admin',
    'admin@bestdataofferzone.shop',
    '$2y$10$OrVpWGTp.MX.2wT7AOjc5uOFeDGYeebbclVhalc3POVmoOJj1U/Yq',
    'admin',
    1,
    1,
    NULL,
    NOW()
),
(
    'superadmin',
    'superadmin@bestdataofferzone.shop',
    '$2y$10$4Bu21avKI.R/oIUspSs1auKn4.mxFckzlfLcGMSrKVJdrOMNfX/Fy',
    'superadmin',
    1,
    1,
    NULL,
    NOW()
)
ON DUPLICATE KEY UPDATE username = username;

-- Ensure wallets exist
INSERT IGNORE INTO `wallets` (`user_id`, `balance`, `created_at`)
SELECT id, 0.00, NOW() FROM users WHERE username IN ('admin', 'superadmin');