-- Generated seed file with password_hash() values
USE nexpanel;

-- Insert users
INSERT INTO users (id, username, password_hash, role_id, parent_id, display_name, email, phone, avatar, status, wallet_balance, created_at)
VALUES
(1, 'superadmin', '$2y$10$qs6Jvq2z7cj1efgGr3boHepmhHeiBUIsj3gLiyt4DfXUo70nlJNry', 1, NULL, 'Super Admin', 'admin@example.local', '+10000000001', NULL, 'active', 1000.00, NOW()),
(2, 'reseller1', '$2y$10$b/l.65JQTSXQSf81GkNm3.qft/MI6emaJ/hq/sj8/0pxJ5QzXhGJa', 2, 1, 'Primary Reseller', 'reseller1@example.local', '+10000000002', NULL, 'active', 500.00, NOW()),
(3, 'subreseller1', '$2y$10$FfbAj1WsGF5FnqVdnM8rnu5xoaVgXRgRoR53D.iyoyZYcsqCD3aka', 3, 2, 'Sub Reseller', 'sub1@example.local', '+10000000003', NULL, 'active', 200.00, NOW()),
(4, 'customer1', '$2y$10$1LL4gZ4wLsy23lH0iU5iou7F9R7EAwyuasc6ZVV8AdSqGECwIJDne', 4, 2, 'Test Customer', 'customer1@example.local', '+10000000004', NULL, 'active', 50.00, NOW()),
(5, 'marketer1', '$2y$10$LN560i9jVF.82MCqAc7aRetWtOnms8CCU3SJ.0Vw3H5JbrlquNgwe', 5, 1, 'Marketer', 'marketer1@example.local', '+10000000005', NULL, 'active', 25.00, NOW());

-- Note: These passwords are hashed with PHP password_hash(). Use password_verify() in your app.