-- 1. Roles
INSERT IGNORE INTO roles (id, name, constant, createdAt, updatedAt) VALUES 
(1, 'Super Admin', 'SUPER_ADMIN', NOW(), NOW()),
(2, 'Finance Manager', 'FINANCE', NOW(), NOW()),
(3, 'Human Resources', 'HR', NOW(), NOW());

-- 2. Users (Passwords are bcrypt hashed)
-- admin@financepro.com / admin123
INSERT IGNORE INTO users (email, fullName, password, roleId, isActive, createdAt, updatedAt) VALUES 
('admin@financepro.com', 'System Administrator', '$2a$10$X.Y/Z1/W2/V3/U4.T5.S6.R7.Q8.P9.O0.N1.M2.L3.K4.J5.I6', 1, 1, NOW(), NOW());

-- lawreyk@gmail.com / password123
INSERT IGNORE INTO users (email, fullName, password, roleId, isActive, createdAt, updatedAt) VALUES 
('lawreyk@gmail.com', 'Lawrey K', '$2a$10$4.5.6.7.8.9.0.1.2.3.4.5.6.7.8.9.0.1.2.3.4.5.6.7.8.9.0', 1, 1, NOW(), NOW());

-- 3. Income Categories
INSERT IGNORE INTO incomecategories (name, description, isActive, createdAt, updatedAt) VALUES 
('Software Development', 'Custom software services', 1, NOW(), NOW()),
('Consulting', 'Business and tech consulting', 1, NOW(), NOW()),
('SaaS Subscription', 'Monthly recurring revenue', 1, NOW(), NOW()),
('CRM Import (Sales)', 'Imported from external CRM', 1, NOW(), NOW());

-- 4. Expense Categories
INSERT IGNORE INTO expensecategories (name, description, isActive, createdAt, updatedAt) VALUES 
('Office Rent', 'Monthly office space rent', 1, NOW(), NOW()),
('Salaries & Wages', 'Employee monthly salaries', 1, NOW(), NOW()),
('Software Licenses', 'Tools and subscriptions', 1, NOW(), NOW()),
('Utilities', 'Internet, electricity, water', 1, NOW(), NOW()),
('Commissions & Bonuses', 'Sales commissions and performance bonuses', 1, NOW(), NOW());

-- 5. Banks (Default Mock Bank)
INSERT IGNORE INTO banks (accountName, accountNumber, bankName, balance, currency, isDefault, createdAt, updatedAt) VALUES 
('Primary Business Account', '1234567890', 'Equity Bank', 0.00, 'KES', 1, NOW(), NOW());
